Vijay Gulati
Senior Consultant At Deloitte USI | ETL | Data Warehousing | Data Analytics
Gurgaon
Summary
- 10+ years of experience Progressive IT experience focusing on Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence.
- Bachelor of Technology in Computer Engineering.
- Experience in cross-functional Collaboration, cross-functional Agility, Agile Software Development, Product Lifecycle Management.
- 10+ years of experience in Structured Query Language (SQL), Business Intelligence.
- Experience in mentoring technical teams and ability to partner cross-functionally with technical and business stakeholders.
Overview
10
10
years of professional experience
5
5
Certifications
Work History
Senior Consultant
Deloitte USI
Gurgaon
08.2021 - Current
- Leading Data Modernization project for US Life Science Client.
- Project involves building interfaces for Data Conversion, Inbound and Outbound catering to requirements of all Ex-US Markets.
- Technology Stack involves - Snowflake, Postgres, Matilion, EC2, Autosys, CICD.
- Determined areas for improvement and implemented processes to alleviate problems.
- Evaluated clients' needs and created plan of action to provide solutions.
- Exceeded customer requirements with accurate and deliverable solutions.
- Streamlined processes to cut downtime and optimize employee productivity.
- Identified business issues through careful collaboration with key stakeholders.
- Troubleshot issues by understanding issue, diagnosing root cause and coming up with effective solutions.
Technical Lead
EY GDS
Gurgaon
07.2019 - 08.2021
- Lead IFRS 17 Data Modernization project for Australian Insurance Client.
- Technology Stack - Azure DevOps. SSIS, SQL Server, Visual Studio.
- Evaluated and adopted new technologies to address changing industry needs.
- Supervised architecture, design and implementation of company-wide platforms and applications.
- Provided educational expertise and mentoring to junior team members.
- Drove technical initiatives for large enterprise systems to align with long-term business strategies.
- Assessed project milestones and team performance to keep staff on-task.
Consultant
Deloitte USI
Gurgaon
10.2017 - 07.2019
- Lead Data Migration for US Insurance Client.
- Lead Re-insurance module.
- Technology Stack - Informatica BDM, EC2, S3, Autosys.
- Delivered outstanding service to clients to maintain and extend relationship for future business opportunities.
- Managed multiple deadlines across several businesses to meet dynamic needs of multiple clients.
- Created and developed detailed work plans to meet business priorities and deadlines.
- Helped meet changing demands by recommending improvements to business systems or procedures.
Senior Data Analyst
Sopra Steria
Noida
08.2016 - 10.2017
- Worked on Enhancements for Germany based Banking client.
- Technology stack - Informatica Power Center, SQL Server, Unix
- Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
- Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
Senior Systems Engineer
Infosys
Chandigarh
08.2013 - 08.2016
- Worked for various US Based Health Care client.
- Technology Stack - Informatica Power Center, BI Publisher, SSIS.
- Performed root cause analysis to provide resolutions for production issues.
- Collaborated with clients to determine need and devise appropriate software and hardware solutions..
- Created manuals and taught training sessions to educate co-workers on new systems.
Skills
Data Warehousing
Consulting
Team Management
ETL Tools
Performance Benchmarking
Project Management
Data Analytics
Project Documentation
Employee Supervision
Flexibility
Certification
Az-900
Technology And Tools
- ETL (IPC, BDM)
- Database (Oracle, SQL Server, Redshift, PostgreSQL)
- Reporting (SSRS, Cognos)
- Erwin
- Toad for Oracle
- WinSCP
- Putty
- Autosys and UC4 Schedulers
- JIRA, HP ALM
- Snowflake, SnowSQL
Domain And Methodologies
- US HealthCare
- Life Insurance
- LSHC
- Waterfall, Agile.
Professional Awards
- INSTA - Infosys
- Applause (2) - Deloitte
- Outstanding - Deloitte
- SPOT - EY GDS
- Extra Miler - EY GDS
Leadership Experience
- Managed a team of 24 practitioners at offshore.
- Mentored junior developers and new joiners (both onshore/Offshore).
- Worked on building competency at an Org Level by giving training sessions on Informatica BDM and RedShift.
Timeline
Senior Consultant
Deloitte USI
08.2021 - Current
Technical Lead
EY GDS
07.2019 - 08.2021
Consultant
Deloitte USI
10.2017 - 07.2019
Senior Data Analyst
Sopra Steria
08.2016 - 10.2017
Senior Systems Engineer
Infosys
08.2013 - 08.2016