Summary
Overview
Work History
Skills
Websites
Academic And Professional Records
Skilled Familiarity
Trainings Achievements And Projects
Core Areas Of Expertise
Personal Information
Disclaimer
Software
Timeline
Generic

Nitin Sethi

Lead Analytics
Delhi

Summary

Seeking excellence in the chosen professional field through self motivation, hard work and augmentation of core skills requires for effectively delivering the goods. Believe strongly in the concept of work through positive motivation. Discerning Computer Systems Analyst devoted to improving computer systems and network performance for enhanced productivity. Works actively with management to develop cost-benefit analyses and set objectives for system maintenance and upgrades. Stays up-to-date on latest security regulations and protocols to execute effective measures for sustaining privacy and operational integrity. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

Overview

4
4
years of professional experience

Work History

Data Analytics Team Lead

Rio Tinto
NEW DELHI
04.2020 - Current
  • Working on all Workday end-to-end reporting execution and planning which reports we should have and how to visualize them for leadership.
  • I participated in cross-departmental strategy meetings as a representative of the analytics function.
  • I worked on the design and formulation of the people survey to understand the health of the organization.
  • Designed and implemented the sentiment analyses using NLP.
  • Facilitated regular training sessions on cutting-edge analytics techniques, keeping the team up-to-date with industry best practices.
  • Developed custom data analytics tools, resulting in improved insights and decision-making support for management.
  • Developed polished visualizations to share the results of data analyses.
  • Actively participated in recruitment efforts, interviewing potential candidates, and selecting top talent for the organization.
  • Improved data quality by implementing rigorous validation processes and automated error detection.
  • Cultivated strong relationships with key stakeholders across the business, ensuring alignment between data-driven insights and strategic objectives.
  • Mentored junior analysts to develop their technical skills and advance within the team hierarchy.
  • Improved data collection methods by designing surveys, polls, and other instruments.
  • Ran statistical analyses within software to process large datasets.
  • Enhanced team collaboration with cross-functional stakeholders through clear communication and timely project updates
  • Evaluated new software solutions to determine their potential impact on current workflows and overall productivity improvements within the team
  • Skilled at working independently and collaboratively in a team environment

Sr Solution Analyst

Mckinsey & Co
NEW DELHI
8 2010 - Current

Working on Full Asia model using Python, which caters to client consumer behavior (it's banking-specific),.

  • Owner of various data processing tasks to support decision-making
  • Execute defined scopes using agile methodology and collaboratively with team of data scientists, data engineers, end users, and key business stakeholders.
  • Create and develop data visualization methods (presentation) for internal and external stakeholders.
  • I assist teams with ad hoc analyses using tools such as Python, R Studio, Tableau, Excel, SQL, VBA, and SPSS, among others.
  • Created lot of analysis and generated high-quality solutions
  • Helping teams to continuously develop and demonstrate improved analysis methodologies and tools
  • Working on tool implementation with several banks
  • Using R/SAS, I am responsible for maintaining data and assisting teams in performing manipulations on data from various sources.
  • Handling large data sets in R/SAS and using different types of packages for various tasks
  • Scoping requirements, giving them to team, taking end products, performing a quality check on them, and then implementing tool on client site
  • Working with and creating several benchmarking tools using Python and Excel VBA, I created several benchmarking tools.
  • I created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
  • Ensure adoption and replication of solutions delivered by team's solutions are adopted and replicated globally.
  • I worked on lot of regression models (in Python and R Studio).
  • I worked on manipulating and analyzing complex, high-volume, high-dimensional data from various sources to highlight patterns and relationships.
  • Responsible for interacting with business stakeholders, gathering requirements, and managing delivery
  • With Tableau, I have created visualizations for logistics calculations and departmental spend analysis.
  • I used Tableau in creation of metrics, attributes, filters, reports, and dashboards; I created advanced chart types, visualizations, and complex calculations to manipulate data.
  • I am working with Tableau Extracts, Table Calculations, LODs, etc.
  • I have created complex Tableau charts and dashboards using actions and filters.
  • I solve problems with clients and teams in analytics.
  • Create KPIs for both customer satisfaction survey results and disease management.
  • Innovating new things, like fuzzy logic, to help teams clean up their data in less time
  • Creating Excel model as per client requirements
  • Helping analytics team with various tools and techniques
  • Modeling with Excel and Access
  • Updating and running existing Alteryx workflows
  • Create work flows, fetch data from various sources, such as Oracle databases and Excel, and blend data using Alteryx.
  • Writing and updating SQL queries to pull out data for various kinds of analytical reporting
  • Generating analysis datasets, tables, listings, and graphs as required
  • Interacting with other departments, such as statistics and data management, to ensure high level of client satisfaction through successful project execution
  • Analyze and resolve data load issues by working with business and technical teams.
  • Coding to enable mapping of various data extracts and sets (excel, Teradata, etc.) to new standardized SAS dataset
  • Assistance in developing new SAS data warehouse to enrich and store transactional losses from variety of sources
  • Coding to enable reporting of internal loss data to various customers in unique formats
  • Coding to download line of business-specific extracts for updates and loss validations
  • Job includes huge data (in excess of hundreds of millions of records) and is responsible for data quality, data organization, metadata, and data profiling.
  • Provide technical support to data warehouse teams.
  • Providing assistance with design and development of enterprise-wide repositories for all corporate data tools, database systems, or other specialized decision support or expert systems
  • Supporting both internal and external customers through system interfaces with legacy data and sophisticated query and analysis tools
  • Creating ad hoc reports and documenting process
  • Helping to develop, maintain, and support reporting and development
  • Assisting with migration and conversion of current reports into new centralized report library
  • Assisting with project planning, analysis, and documentation
  • Assisting with statistical quality assurance review and program validation for each project.
  • Ensuring timely delivery of accurate and high-quality products
  • Interacting with offshore counterparts is necessary to ensure high level of client satisfaction through successful project execution.

Skills

Self Motivation

undefined

Academic And Professional Records

  • Advance analytics, IIT Delhi, Certification
  • Data Scientist, Johns Hopkins University, Graduation
  • M.A. Economics, Masters, M.A.
  • Scaled agile certified, SAFe Scrum Master, Certification

Skilled Familiarity

  • Rio Tinto, India, 04/2020, Present, Handling a team of people who are working on reporting, analytics, automation, tool development etc., Responsible for data analytics and reporting with the team., Acting as a translator between the technical team and internal clients to facilitate discussions and ensure value-adding outcomes and to scope it well., Done automations to eliminate manual work within and for other departments as well the other team and those work/automations are now deployed by other team, and we are helping them to implements the same., Responsible to develop more capabilities in the team., Training people on advance tools and techniques, so that they can help Rio HR., Taking care of the global reports on the daily and monthly basis and the RTTMS tickets generated by the SLT plus the adhoc reports as well., Regularly interact with other Analytics team members across the hubs to maintain and improve a common approach to deliver analytics projects across the company and exploring more globally as well across the industries., Working on People survey reports, data handling and analyzing the sentiments on the comments entered in the free test space in the survey by the employees. I have created a machine learning algorithm that can analyses large text/comments by the employees to give them a sentiment score by which the leadership can understand the sentiments on the particular people survey. Earlier they were struggling with how to get this and when I joined, I created this and now it’s very helpful, its based-on Python and deep learning concept., Added lot of new report and charts on the legacy report to help my HR and the leadership and to provide them good insights so which will help them in decision making., Working on Azure to understand and explore how we can help RIO in larger space going forward., Mentoring team on the fast-developing field of advanced analytics to increase competence in data-driven decision making and problem-solving approaches.
  • Mckinsey & Co, 08/2010, 03/2020, Working on the Full Asia model using python that caters the clients on the consumer behavior (Its banking specific)., Analyze financial performance of United’s schedule and make recommendations to improve margins, Owner of various data processing tasks to support decision making., Execute defined scopes applying the agile methodology and collaboratively with a team of data scientists, data engineers, end users and key business stakeholders., Create and develop data visualization methods (presentation) for internal and external stakeholders., Helping teams with ad-hoc analyses using tools like Python/R studio/Tableau/Excel/SQL/VBA/SPSS etc., Created lot of analysis and generate high quality solutions, Helping teams to continuously develop and demonstrate improved analysis methodologies and tools., Working on the Tool implementation with several banks., Using R/SAS maintaining the data and helping teams to do manipulations in the data from different sources., Handling big data sets on R/SAS and using different type of packages the various task., Scoping the requirements and giving them to the team and taking the end products and performing the Quality check on the same and then implementing the tool on the client site., Working and creating several benchmarking tools using Python and Excel VBA., Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights., Ensure adoption and replication of solutions delivered through the team globally, Worked on lot of regression models (Python / R studio), Worked on manipulating and analyzing complex, high-volume, high dimensionality data from various sources to highlight patterns and relationships., Responsible for interaction with business stake holders, gathering requirements and managing the delivery., With Tableau I have created visualization for logistics calculation and department spend analysis., Used Tableau in creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data., Working with Tableau Extracts, Table Calculations, LODs etc., Created complex Tableau charts and dashboards using actions and filters., Problem solving with client and teams on analytics., Generate KPI for customer satisfaction survey results and disease management., Innovating new things like Fuzzy logic to help teams to clean up their data in less time., Creating excel model as per client requirement., Helping analytics team with various tools and techniques., Modeling with excel and access., Updating and running existing Alteryx workflows., Create work flows, fetch data from different sources like oracle database and Excel and data blending using Alteryx., Writing and updating SQL queries to pull out the data for various kind of analytical reporting., Generating analysis datasets, tables, listings, and graphs as required., Interacting with other departments, such as Statistics and Data Management, to ensure a high level of client satisfaction through successful execution of projects., Analyze and resolve data load issues by working with the business and technical teams., Coding to enable the mapping of various data extracts/data sets (excel, .csv, .txt, Teradata, etc.) to a new standardized SAS dataset., Assistance with developing a new SAS data warehouse to enrich and store transactional losses from various sources., Coding to enable the reporting of internal loss data to various customers in unique formats., Coding to download line of business specific extracts for updates and validations of losses., Job includes with huge data (in excess of hundreds of millions of records) and are responsible for data quality, data organization, metadata, and data profiling, Provide technical support on data warehouse teams., Providing assistance with the design and development of the enterprise-wide repositories for all corporate data tools, database systems, or other specialized decision support or expert systems., Supporting both internal and external customers by systems interface with legacy data and use of sophisticated query and analysis tools, Creating Adhoc reports and documenting the process., Helping to develop, maintain and support reporting and development., Assisting with migration and conversions of current reports into a new centralized report library., Assisting with project planning, analysis and documentation., Assisting with statistical quality assurance review and program validation for each project., Ensuring timely delivery of accurate and high-quality products., Interacting with offshore counterparts, to ensure a high level of client satisfaction through successful execution of projects.

Trainings Achievements And Projects

  • Got Achievers award from Mckinsey & co.
  • Star Performer award from Mckinsey & co.
  • Best Team handling award from Peoplestrong.
  • Best performer Award in March 2009 from UHG.
  • Best Performance Award in January 2009 from UHG.
  • Best Performance Award in December 2008 from UHG
  • Best Performance Award in March 2008 from UHG.
  • Excellence Award in 2006 from GENPACT.

Core Areas Of Expertise

  • Working on Power BI, Power platform and Power Apps.
  • Have created automation on Python and Selenium.
  • Handling analytics on People survey which includes data management, data cleaning, visualization.
  • Created machine learning model for sentiment analytics.
  • Exposure to Azure.
  • Safe SCRUM Master certified
  • Automating report from manual to advance platforms to take care of BAU’s automatically.
  • Training new joiners on Tools and techniques (Python, R studio, Tableau, SQL, Machine learning algorithms etc.)
  • Strong problem-solving skills for a business problem
  • Working on Data science algorithms using platforms like R Studio/Python/Alteryx etc.
  • Using Python for running Machine learning algorithms and supporting team with their business problems.
  • Working on Tableau for Data visualization.
  • Working on Alteryx for data cleaning and data steps.
  • Working on SAS datasets to help multiple teams.
  • Working on R to do the data cleaning and data steps.
  • Working on excel models for client implementation.
  • Generating analysis datasets, tables, listings, and graphs
  • Maintaining huge data in MS packages
  • Problem solving with team.
  • Solution provider in terms of tools and techniques.
  • Handling data for 12 Asian counties and the single point of contact for all the Partners.
  • Good knowledge of SPSS.
  • Strong analytical and strategic planning skills.
  • Proficient with all major computer systems & necessary applications.
  • Self motivated, enthusiastic and a proven leader.
  • Projects in which I can use my knowledge and abilities to help your team accomplish its goals ahead of deadline.

Personal Information

Date of Birth: 12/04/83

Disclaimer

I hereby declare that the facts given in resume are correct to best of my knowledge and belief.

Software

Data Science

Machine Learning

NLP

HR Data Model

Workday

Data Visualizations

Scrum Master

Team Management

Problem Solving

Timeline

Data Analytics Team Lead

Rio Tinto
04.2020 - Current

Sr Solution Analyst

Mckinsey & Co
8 2010 - Current
Nitin SethiLead Analytics