Janarthanan Nagarajan

Experience

• 

  Chennai Petroleum Corp. Ltd (Indian Oil)

  Dec 2008 - Jan 2009

  Trainee Engineer

  Establishing and supervising Product Quality Control programs, strategies and new operating procedures.Temperature control of polymers, reactors and chemical percentages.Maintain Temperature and Pressure parameters for desired product outcomeDesign and test chemical processing and associated plants and equipmentOperation and maintenance of pilot plants, processing units or processing plants.Develop alternate solutions to existing problems. Perform all detail work necessary to determine best solutions. Show less

• 

  MYTA

  Nov 2010 - Jul 2011

  Administrator

  Developing strong relationships with client companies.Advertising vacancies in a wide range of media and receiving and reviewing candidate applications.Conducting interviews and short-listing viable candidates.Requesting references and checking applicant suitability before submitting details to clients.Briefing the candidate about the responsibilities, salary and benefits of the job in question and organizing follow up interview with clients.Negotiating pay and salary rates and finalizing arrangements between client and candidate. Show less

• 

  Lebara Mobile

  Sept 2011 - Jul 2012

  Regional Merchandising Coordinator

  • Manage a portfolio of three National accounts in the United Kingdom.• Specialized in Telecom Domain Industry• Address customer questions and concerns regarding products, prices and availability.• Research and secure new accounts in South, North and Midlands’s territory.• Supervise three Merchandising account managers. • Develop and execute annual sales plans and strategies for the South, North and Midlands region.• Retain and ensure proper handling and care of existing client accounts.• Prepare monthly commissions payroll reports for 70+ sales representatives.• Design displays to make the store experience interactive and engaging.• Verify that all merchandising standards were maintained on a daily basis.• Maintain friendly and professional customer interactions.• Place special merchandise orders for customers.• Responsible for Conducting Blue Audit for all the Outlets in the UK.• Responsible for providing the route plan to all the Merchandisers through MFA.• Managing the Score system and Route Monkey software.• Responsible for “Everything Everywhere Blue”• Arranging stocks and managing the absence records of the Merchandisers.• Met and exceeded quarterly sales quotas by 10%.• Weekly and monthly strategy reports to analyze business trends and make recommendations.• Conduct staff meetings with sales personnel to introduce new merchandise.• Authorize payment of invoices and return of merchandise.• Create and implement POS with chosen vendors. Show less

• 

  Ayapa Services Ltd

  Oct 2012 - Apr 2013

  Sales Manager

  • Managing all the Sales staff across the London region.• Responsible for providing the commission to all the customers who achieved the monthly target. Mentoring staff and training them.• Providing activation and churn report to the management against each network. Conduct sales review meetings monthly.

• 

  Tata Consultancy Services

  Jan 2014 - May 2019

  Tableau Developer

  • Interacting with multiple stakeholders to gather business needs & develop technical specs• Converting pre-existing Excel-based reports to Tableau dashboards• Designing Tableau Dashboards with interactive views, trends and drill-downs for various users·• Deploying rich graphical visualisations in dashboards to create effective views of data such as Line Charts, Bar Charts, Pie Charts• Scatter Plots, Histograms, TreeMaps, Heat Maps, Area Charts, Gantt Charts, Bullet Graphs in Tableau Desktop• Implementing advanced Tableau features such as parameters, table calculations, sets, groups, user filters to deliver highly usable dashboards• Highlighting views by using Annotations (Points, Marks, Area, etc.) wherever required• Creating different KPIs using calculated key figures and parameters• Publishing and sharing reports with the business users on the Tableau Server• Creating Tableau Dashboards with interactive views, trends and drill-downs along with user-level security• Accessing & transforming massive datasets through filtering, grouping, aggregation, & statistical calculation• Connected Tableau server with share-point portal and setup auto-refresh feature·• Developed Tableau workbooks from multiple data sources using Data Blending for General Electric• Developed rich dashboards using Tableau Desktop to deliver actionable insights for Bank of America• Analysing user requirements and validating the available data to propose usable designs as Business Analyst for Star Alliance• Identified process boundaries and determining opportunities to automate processes and functions as Energy Analyst for TCS CTO Team Show less

• 

  University of Exeter

  Oct 2019 - Jan 2021

  Data Research Analyst

  • Worked on ETL data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services. • Created packages in SSIS with error handling • Used For each loop container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs. • Created SSIS packages to Extract, Transform and Load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all. • Used data conversion tasks in SSIS to load the data from flat file to SQL Server database. • Developed monitored and deployed SSIS packages. • Developed rich dashboards using Tableau Desktop to deliver actionable insights• Developed Tableau workbooks from multiple data sources using Data Blending• Developed rich dashboards using Tableau Desktop to deliver actionable insights• Developing visual reports, dashboards and KPI scorecards using Tableau desktop• Published Reports in the required originations and made Dashboards available to Web clients and mobile apps• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QT and MTD type of analysis. Show less

• 

  Elven Energy Ltd

  Apr 2021 - Apr 2022

  Business Intelligence Analyst

  • Understand the Requirements and Functionality of the application from specifications.• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau and Power BI.

• 

  Nexeon Ltd

  Apr 2022 - now

  • Business Intelligence Developer

    Jan 2024 - now

  • Data Analyst

    Apr 2022 - Dec 2023