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
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
Similar Profiles
GURUPRASATH KRGURUPRASATH KR
Senior Consultant at Deloitte USI Consulting - Deloitte DigitalSenior Consultant at Deloitte USI Consulting - Deloitte Digital
Akhtar KhanAkhtar Khan
DC Senior Consultant at Deloitte Consulting India Private Limited (Deloitte USI)DC Senior Consultant at Deloitte Consulting India Private Limited (Deloitte USI)
SHRESTH ISHSHRESTH ISH
Advisory Intern at Deloitte USIAdvisory Intern at Deloitte USI
Rolwin D'CunhaRolwin D'Cunha
Senior Auditor at Deloitte USISenior Auditor at Deloitte USI
Smriti RanaSmriti Rana
Technical Architect & Lead at Builder.aiTechnical Architect & Lead at Builder.ai