Gagan Deep Email & Phone Number

Canada

Mississauga, Ontario, Canada

• Responsible for providing BI (ETL & Reporting) solutions to Walmart business users
• Working in an agile environment and supporting data requirements for different operations in Walmart.
• Developing and maintaining ETL processes and Tableau reports for various departments such as Pharmacy, Private Brands, Merchandising, and E-commerce etc.
• Involved in creating strategies for the building data model to fetch accurate data in an efficient manner
• Utilizing newly set-up data lake capabilities to store and retrieve data in a faster way.
• Working with business users to understand their data needs and building capabilities to take effective analytical decisions

Toronto, Ontario

• Teaching assistant for 3 different courses related to financial modeling
• Checked students’ assignments and handled their queries with satisfactory and timely response
• Facilitated face to face sessions with students for providing detailed explanation of their mistakes

Gurgaon, India

• Responsible for providing BI (ETL & Reporting) solutions to clients by analyzing financial accounting data
• Worked as a member of the asset management data integration team, responsible for providing business intelligence solutions to business by analyzing the financial investment data
• Involved in requirement gathering sessions, understanding financial business needs and conveying the same to other junior team members
• Created new interfaces based on business requirements. These interfaces involved fetching of data from different source system like databases, XML's, flat files, excel etc. and loading them to target using Informatica.
• Assisted in the collection and documentation of user requirement and prepare low-level designs.
• Maintained strong relationships and effective communication with financial business partners

Gurgaon, India

• Responsible for implementation of a data warehouse for the banking and finance domain of MAS ((Monetary Authority of Singapore)
• Created a Data warehouse for Banking and Finance domain of MAS
• Single-handedly completed a phase of a project in Singapore despite the communication gap
• Brainstormed with the company’s senior management to establish the design of data warehouse by understanding the client data and to decide accurate technology implementation
• Trained 5 junior employees on ETL, SQL and Unix
• Involved in creation of POCs for most of the mappings (including SCDs) used in this project

Noida Area, India

• Part of the team responsible for providing ETL solutions to GE business
• Worked closely with GE counterparts on various ETL development and support projects
• Created complex ETL packages using SSIS for transferring data between different databases and files, incrementally loading partitioned tables and fetching data from web services.
• Created SSIS packages for File Transfer from one location to the other using FTP task
• Reviewed SSIS data flows, various tasks and data, which is loaded into targets as per Business Logic

Master Of Business Administration - Mba, Business Analytics

Activities and Societies: Awarded Graduate Entrance Scholarship

B.Tech