Pratiksha Milind Lavhatre
Associate Consultant · Capgemini
Boston, MAWork Experience
Associate Consultant
Capgemini2017 – 2018
• Created visually attractive reports & dashboards with Power BI, and deployed it onto the cloud using gateway • Automated daily monitoring manual task by creating an SSIS package which saved 20 hours weekly • Prepared technical designs by analyzing business requirements and reviewed several application modules making enhancements • Used Agile Scrum project management framework to deliver the project successfully • Communicated and resolved the queries raised by the clients, providing in-depth analysis within 24 hours • Recipient of "Star" Award twice for managing and supporting 3 projects simultaneously and worked as a team lead for a team of five
Analyst
Capgemini2015 – 2017
• Developed SSIS packages to Validate, Extract, Transform and Load data to Data Warehouse and Marts from various source • Performed migration of Tableau and SSRS reports to Power BI report • Maintained and build SQL scripts, indexes and complex queries for data analysis and extraction • Planned, designed and implemented application database code objects, stored procedure, cursors and views • Developed multidimensional cubes with SSAS for deeper and faster data analysis • Executed data preprocessing for effective cleansing and slicing/dicing of the data extracted from different sources MS Excel and SQL Server
Education
Master's in Information Systems
Northeastern University2020
Master's in Information Systems
Bachelor's in Electrical Engineering
Yeshwantrao Chavan College of Engineering2015
Bachelor's in Electrical Engineering