Kumar Vaibhav
Mobile: (+91) 9767622835
Email:
[email protected]SUMMARY:
• 6+ years of strong experience in Business and Data Governance, Data Integration, Data
Modelling, SQL, ETL solution.
• Worked with AWS Cloud platform and its features which includes EC2, VPC, RDS,
REDSHIFT, IAM, S3, CloudWatch, Cloud Trail, CloudFormation and Autoscaling etc
• Experienced in Dimensional Data Modelling experience using Data modelling, Relational
Data modelling, ER/Studio, Star Join Schema/Snowflake modelling, FACT & Dimensions
tables, Conceptual, Physical & logical data modelling.
• Expertise in the Data Analysis, Design, Development, Implementation and Testing using
Data Conversions, Extraction, Transformation and Loading (ETL) and SQL Server,
ORACLE and other relational and non - relational databases.
• Data Analysis- Data collection, data transformation and data loading the data using
different ETL systems like Informatica.
• Work with Solution Architects to develop ETL/Data Integration/Data Processing Flows.
• Translates enterprise or business requirements into long-term information/data
architecture solutions, including conceptual, logical and physical models
• Experienced working on modification of views on Databases, Performance Tuning and
Workload Management.
• Experience in migrating legacy/On-premise ETL framework on Cloud.
CURRENT PROJECT:
No Project Name Project experience and outcome of the business engagement
1 Dialog Data Platform • Data modernization from On-Prim to AWS cloud
migration • Leading a team of 5 for 2 modules.
• Analysis of current ETL code to migrate on AWS glue ETL
Organisation: tool.
Blazeclan India Pvt Ltd • Responsible for migration activity of Oracle Exadata to
Jan 2021-Till now Snowflake
• Part of Architecture Design process for the project.
PROJECT EXPERIENCES:
No Project Name Project experience and outcome of the business engagement
1 Enterprise Data Hub • Part of Architectural design of EDH on AWS cloud and
(EDH), PETRONAS, suggested relevant solution and services for
Malaysia implementation
• Performed ETL design for all the data sources.
Organisation: • Prepared the Database design for multiple data sources.
Blazeclan India Pvt Ltd • Performed Data stewardship
Aug 2019-June 2020 • Responsible for provisioning of AWS platform for
implementation EDH on AWS Cloud
2 Yoodo – Celcom • Performed Data profiling Activity, Data Model and Design
Datalake, Malaysia standards for integration of multiple data sources.
• ETL design process.
Organisation: • Data analysis activities to capture data requirements for
Blazeclan India Pvt Ltd development of Visualisations
Jan 2019-Aug 2019 • Data governance rules and Redshift data base design
(Access management of Database tables and Schema)
3 FCA BI GABRIEL, • Responsible for ETL Architecture and Database design
Financial Conduct • Prepared Data model and helped ETL developers to
Authority, London implement the business rules correctly.
• Performed activities to help visualization developer to get
Organisation: data requirements
Capgemini India Pvt Ltd • Worked in Oracle Database.
Jan 2016-Dec 2018
4 Account Re-distribution • Interacted with the Users and Business Analysts to gather
System, Morgan the necessary requirements of the project
Stanley, New York, USA • Responsible for query building, data issue solving, query
fine tuning and ETL development in Informatica.
Organisation: • Responsible for development of ETL framework to
Capgemini India Pvt Ltd integrate multiple source feeds and maintain repository of
Mar 2015-Dec 2015 the Business Objects reports containing sensitive
objects/fields & Usage Information.
• Performed Unit testing, Documented the ETL design
5 Insurance Analytics • Developed Insurance claim Analytics solution for a Travel
Solution, Germany and Tour Industry giant.
• Helped to solve high complexity issues, communicating
Organisation: problem resolution and additional information to
Capgemini India Pvt Ltd management, customer groups, project teams and other IT
Nov 2014-Mar 2015 support groups.
• Developed Informatica mappings to load necessary source
tables in Oracle.
• Ensured that strategies are in place for risk identification,
mitigation and contingency planning
• Implementation of SCD type 2, SCD type 1
Achievements:
1) ORACLE MASTER SQL Certified
2) Bachelor of Engineering in Computer Science from Pune university.
3) Have On-site experience for 2 Clients (Data Engagements).
