Sumit Kumar Pandey
New Delhi
Summary
As a professional Data Analyst/Developer with over 12 years of working experience, I am fluent in a wide variety of software and data management systems, ranging from traditional options like Advanced Excel, MS Power Query, VBA Automation, MS Access, Tableau, Power BI, Python, machine learning algorithms, and SQL.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Lead Software Engineer/Data Analyst
FIS GLOBAL
03.2021 - Current
- Developed and implemented machine learning models through python for banking solution
- Created model in simple techniques such as multiple linear regression and logistic regression for created estimation cost for the projects
- Developed a machine learning model through python for Media Stock forecasting
- Collaborated with team members to build integrated analytic solutions including data pipelines, modelling and dashboards
- Liaised with teams to understand business needs, translated into analytics & executed strategy, which increased conversions by 15%
- Build the application for Integrated Payables banking solution by using the VB, C#.net, SQL
- Developed dashboards for Monthly and weekly reporting through Power BI and Tableau
- Build, Maintenance, debugging and problem-solving of existing or new Applications
Business/Data Analyst
American Express Banking Corp
04.2015 - 02.2021
- Accountable for Managing, Planning, Developing, and Deploying of data strategy that support the programmatic and administrative functions for the JAPA region vendors (HK, AUS, SGP, Taiwan, New Zealand) with respect to daily production, reporting or for any other reconciliation issue
- Developed a machine learning model for Media & Plastic Stock forecasting for all JAPA markets
- Worked on MSTR(Micro Strategy) platform, Pull various reports or data for Analysis using python and make processes streamline for JAPA and EMEA market
- Generated MIS reporting & Dashboards for the Senior Management through Tableau and Power BI Tools
- Create Automation Tools using VBA
- Maintenance, debugging and problem-solving of existing VBA Applications
Data Analyst & VBA Programmer
Manpower Solutions
01.2014 - 04.2015
- Managed multiple projects before of deadline
- Worked with the analytics team to maintain and develop reports and ensure maximum process performance
- Managed migrations in maintenance and support
- Implemented software components as per business requirements
- Implemented improvements to data collection which increased data accuracy by 25% in reconciliation process
- Assisted with database design and data cleaning, improving data quality and integrity
- Involved in developing ETL processes for new data sources
Quality Analyst – Operations
Suntec Web Service Pvt Ltd.
08.2012 - 01.2014
- Collaborated with department managers to determine functionality requirements, resolve data quality issues, and improve the quality of the source data
- Analysed and defined data requirements, specifications and procedures; planned for and anticipated changes in data capacity requirements, and evaluated new technologies and architectures
- Handled Data Processing work & preparing all sorts of MIS regarding inventory and billing
- Maintaining MIS with the help of PIVOT, V-LOOKUP, etc
Education
MCA -
IGNOU
01.2012
BCA -
IGNOU
01.2010
HSC (12th) -
CBSE
01.2006
SSC (10th) -
CBSE
01.2004
Skills
- Python
- Data Visualization
- Statistical Analysis
- Scikit-Learn
- Matplotlib
- Advance Excel
- MS Access
- Tableau
- PowerBI
- SQL
- ETL
- Machine Learning
- VBA
- Data Analysis
Certification
- Data Scientist, DataCamp, In Progress
- Machine Learning with Python, Simplilearn, Completed
- Tableau Desktop, Simplilearn, 2021
Accomplishments
- Best performer for creating Email controller tools for AEBC India controllership team.
- Streamline various processes by collaborating with Stake Holders to determine functionality requirements, resolve data quality issues, and improve the quality of the source data.
- Awarded for streamlining internal processes for greater Speed and Agility.
- Awarded on successfully platform migration from BIS to GIP.
Personal Information
- Father's Name: Sh. Jagat Narayan Pandey
- Date of Birth: 11/13/87
- Marital Status: Married
Timeline
Lead Software Engineer/Data Analyst
FIS GLOBAL
03.2021 - Current
Business/Data Analyst
American Express Banking Corp
04.2015 - 02.2021
Data Analyst & VBA Programmer
Manpower Solutions
01.2014 - 04.2015
Quality Analyst – Operations
Suntec Web Service Pvt Ltd.
08.2012 - 01.2014
MCA -
IGNOU
BCA -
IGNOU
HSC (12th) -
CBSE
SSC (10th) -
CBSE
Similar Profiles
Mycobi LeeMycobi Lee
Print and Insert Operator 2 at FIS GlobalPrint and Insert Operator 2 at FIS Global
Sonal HolaySonal Holay
PM Lead - Sr. AVP at FIS GlobalPM Lead - Sr. AVP at FIS Global
ARIJIT KARARIJIT KAR
Software Test Analyst at FIS GlobalSoftware Test Analyst at FIS Global