Project Management Information Systems

Pratik Bhatnagar

USA *****************@*****.*** 346-***-**** www.linkedin.com/in/pratik-bhatnagar EDUCATION

University of Houston, C.T Bauer College of Business, Texas, USA Aug 2022 – May 2024 Master of Science in Management Information Systems Coursework: Systems Design, IT Project Management, Financial Planning, Transaction Processing Systems, Healthcare Analytics University of Pune, Maharashtra, India Aug 2015 – Jun 2019 Bachelor of Engineering in Electronics & Telecommunications Coursework: Database Management, Control Systems, Information Visualization, Data structures and Algorithms PROFESSIONAL EXPERIENCE

PAG Consulting INC, Houston, Texas, Business Analyst May 2023 – May 2024

● Led end-to-end requirement gathering, creating BRDs and solution designs that reduced rework by 20% and ensured alignment between business and technical teams using Jira and Confluence

● Analyzed acquisitions and mergers data using SQL, improving decision-making accuracy by 15%, and validated data during ETL processes to ensure perfect data accuracy

● Orchestrated process optimization, leveraging Excel to drive a 15% performance improvement and generate $75,000 in revenue

● Built Power BI dashboards to visualize financial metrics, enhance reporting efficiency by 25%, and drove Agile Scrum processes to boost team productivity by 30%

KPIT, Pune, India, Business System Analyst Mar 2020 – Oct 2022

● Spearheaded, development and execution of 2K+ software test cases using Postman enhancing product quality and reliability by 18%

● Partnered with cross-functional teams to define data requirements and optimized SQL queries, reducing data retrieval time by 36%

● Conducted system analysis, testing, and user support, reducing platform transition time by 25%, while designing Tableau dashboards to deliver actionable insights, enhancing decision-making and project rollouts

● Led UAT for 5 projects, implementing features that boosted product efficiency by 48% and improved operations, upgrading user experience and client satisfaction

Ericsson, Pune, India, Project Manager Aug 2019 – Mar 2020

● Directed business requirement gathering, coordinated with clients and cross-functional teams, ensuring project alignment and increasing productivity by 25%

● Analyzed key performance indicator’s (KPI) tracking and performed risk analysis using Smartsheet and tableau, mitigating high- risk events and improving project success rate by 32%

● Delegated tasks to associates, modernized project workflows using Agile (SCRUM) methodology with Azure DevOps for product management, planned sprint strategies to boost project completion efficiency by 60% Siemens, Mumbai, India, Data Analyst Dec 2017 – Jan 2018

● Enhanced reporting efficiency by 40% by refining data collection methods for 10+ annual reports, leveraging AWS S3 buckets and Glue for streamlined data processing and storage

● Improved data accessibility by 25% by designing a structured data map and centralized repository, enabling faster data retrieval and analysis for energy-related datasets using AWS Redshift and Lambda SKILLS

Programming: Python, R, C++, Pandas, NumpPy, PyTorch, PySpark, Scikit-learn, OpenCV, DAX Data Analytics: SQL, SAS, GCP, AWS, Azure, Tableau, PowerBI, Qlik, Excel, ETL, SSIS, Snowflake, Alteryx, Data Warehousing Project Management: Smartsheet, Jira, SDLC, Agile, Budget Planning, Risk Assessment, SharePoint, SAP, ERP, Supply Chain Optimization PROJECTS AND PUBLICATIONS

Age Progression and Regression model using Deep Learning

● Developed a deep learning model on the UTK face dataset with 20K images to predict facial progression and rejuvenation of frontal views. The model was trained for 50 epochs at a 0.02% learning rate and achieving an accuracy rate of 95% for the entire model Covid-19 Data Analytics and Dashboard implementation using Tableau

● Cleaned and explored the Covid-19 dataset using Python, then implemented a Tableau dashboard with over 5 KPIs; utilized methods focused on metadata for enhancing data understanding AI Model Development for Advanced Driver-Assistance Systems (ADAS)

● Trained AI models on diverse datasets, achieving 82% accuracy for NLP-based pattern recognition in ADAS enhancing reliability CAMPUS AND COMMUNITY INVOLVEMENT

● Awarded with a certificate of excellence for outstanding achievements of ADAS practices at KPIT, 2021

● Volunteer – ‘Mavlas of America’: Mentoring first generation underprivileged girls

Contact this candidate