PRITAM BHATKAR
DATA ANALYST
New Jersey
adckaw@r.postjobfree.com
SUMMARY
A Data Analyst with 3+ years of significant experience in Analyst role with proven and tested business, mathematical, good problem-solving and decision-making abilities, excellent communication skills and a self- motivated enthusiastic learner.
SKILLS
Language: SQL, PL / SQL
Reporting Tools: Tableau, SSRS, Power BI
ETL Tools: Informatica, SSIS, SSAS
Database: SQL Server, MySQL, Oracle, Teradata, MongoDB Methodologies: SDLC, Agile, Scrum
Tools: MS Office, Google Analytics, Power BI
Operating System: Windows 7/8/10, Ubuntu
EDUCATION
MS in Information Systems
New Jersey Institute of Technology, Newark, New Jersey EXPERIENCE
Role: Data Analyst Intern Pfizer Inc., CT
Sept 2019 to Dec 2019
• Medical data cleaning and pre-processing to analyse the data and interpret the results using statistical methods in Tableau.
• Developed Analysis report by identifying the trends from the visualizations to monitor the performance of the products.
• Predicted factors contributing delay in delivery of medicines, daily jobs and On-time delivery performance for quick reach-out to clients (patients).
• Performed Data analysis using Python Pandas.
• Performed Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data Profiling on source data.
• Utilized data visualization software Tableau to compile data gathered from flat files/Excel/Oracle/MSSQL/Teradata using SAS/SQL, SAS/macros. 2
Role: Supply Chain Analyst Intern Knorr Bremse Powertech USA, NJ Jun 2019 to Aug 2019
• Supported company's business strategy by developing and managing global supply base contributing to growth.
• Boosted KPIs and continuous improvement strategies to enhance logistical operations and meet supply chain needs.
• Analysed and reviewed transport data of products and goods to draw insights of delivery progress of vendors over-time.
• Filled the gap among the stakeholders and clients by tracking daily SAP programs and optimizing them by strategic planning for data analytics.
Role: Business System Analyst Jio, India
Oct 2015 to Aug 2018
• Organized and executed strategies for migrating and consolidating data.
• Developed and updated SOP for key functions and features of each system.
• Collected data in field, evaluated findings and produced reports and presentations.
• Diagrammed and charted problems to facilitate comprehensive analysis.
• Identified and analysed application and system issues to provide permanent solution for end users to keep business up-to-date.
• Communicated client's business requirement by building data and process models.
• Performed functional, user-acceptance and integration testing to verify that business requirements are met.