Vinayak Sambhaji Gorade
Pune
Summary
Lead Data Engineer and Product Owner at Allianz Technology SE with expertise in SQL and PySpark. Proficient in Azure Data Factory and data warehousing, facilitating effective stakeholder collaboration. Demonstrated success in database engineering and software integration, resulting in improved system efficiency and timely project delivery. Extensive experience in developing, designing, and implementing database solutions, complemented by strong communication and organizational skills.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Lead Data Engineer, Product Owner
Allianz Technology SE
Pune
07.2013 - Current
- Executed migration of legacy ETL processes to Microsoft Fabric, achieving 25% reduction in processing time.
- Developed Azure Data Factory pipelines for efficient execution of Databricks Notebooks.
- Managed analysis and reporting requirements within agile frameworks and sprint cycles.
- Gathered and analyzed business requirements as Product Owner through collaboration with clients.
- Optimized SQL queries and PySpark scripts to enhance system performance and reduce costs.
- Conducted data validation and implemented testing strategies to ensure accuracy during migration.
- Designed dimensional data models (Star Schema) and OLAP cubes in partnership with Database teams.
- Utilized AZURE Cloud, SAS EG, POWER BI, and JIRA for effective project management.
Business Analyst
Genpact
Hyderabad
08.2011 - 12.2012
- Company Overview: Client: Nissan North America
- Contribution: Development of User stories, designing interfaces, development and defect fixing.
- Worked as Business Analyst for Nissan North America Reporting (NNA) in Genpact.
- Providing detailed business and technical documentation and functional designs.
- Created database objects such as tables, views, synonyms, indexes, sequences.
- Incorporated business rules and constraints and created new tables for all modules.
- Modifying stored procedures, functions, packages, views, and SQL queries as per new business requirements/changes.
- Train and mentor teams and internal business units and stakeholders and data management framework requirements, improvements, and operationalization.
- Providing inputs to Management Weekly, Monthly Reports for improvements.
- Created Complicated Stored Process Using SAS EG and PL/SQL To Generate Output.
- Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions, and conditional statements.
- Transforming a problem definition into an algorithm and translating into VBA, Knowledge of MS Excel/MS Access objects, their properties, and methods to automate reports.
- Client: Nissan North America
Reporting Analyst
Infosys Ltd
Pune
02.2010 - 08.2011
- Company Overview: Client: Procter & Gamble Co. (P&G)
- Worked as Reporting Analyst for Procter & Gamble Co. (P&G) in Infosys from Feb 2010 to Aug 2011.
- Experience in using SAS to read, write, import, and export to another data file formats, including delimited files, Microsoft Excel, PDF and MS Access tables.
- Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
- Provide Database setup & automation training for delivery analyst for delivering the report as per client requirement.
- Created Dashboards/ Automated Reports for the completed report requirements via MS Access and Excel, VBA Programing, Tibco Spotfire and SAS ETL.
- Client: Procter & Gamble Co. (P&G)
Education
M.C.M - Computer Management
RJPMS, Pune University
Pune06-2009
Skills
- Agile project management
- Data engineering
- Data warehousing
- Microsoft Fabric
- SQL and databases
- ETL development
- NoSQL databases
- Python programming
- Relational databases
- Linux, UNIX, shell
- Oracle, PL/SQL
- C#NET, SAS
- DB2, SQL Server
- PostgreSQL, MongoDB
- WinSCP, PuTTY
- JIRA, Confluence
- Toad, UC4, AMT
- Azure/AWS
- GitHub, TortoiseSVN
Languages
- English
- Hindi
- Marathi
- German A1
Personal Information
- Hobbies: Reading, Adventure activities, Travelling
- Passport Number: Z6113741
- Date of Birth: 03/10/87
- Nationality: Indian
- Marital Status: Married
Certification
Microsoft AZ-900 and DP-203/Azure Data Engineer
Timeline
Lead Data Engineer, Product Owner
Allianz Technology SE
07.2013 - Current
Business Analyst
Genpact
08.2011 - 12.2012
Reporting Analyst
Infosys Ltd
02.2010 - 08.2011
M.C.M - Computer Management
RJPMS, Pune University
Similar Profiles
Nandhu G NairNandhu G Nair
Senior Analyst - Operations at Allianz Technology SESenior Analyst - Operations at Allianz Technology SE
Sruthi S NairSruthi S Nair
Senior Technical Analyst- Global Identity and Access Management at Allianz Technology SESenior Technical Analyst- Global Identity and Access Management at Allianz Technology SE
Junqian LiuJunqian Liu
Risk Manager at Allianz Technology SERisk Manager at Allianz Technology SE
JILU JACOBJILU JACOB
Technical Architect - Release, Tooling & CICD at Allianz Technology SETechnical Architect - Release, Tooling & CICD at Allianz Technology SE
Niraj DigheNiraj Dighe
Lead Software Engineer at Cloud Software GroupLead Software Engineer at Cloud Software Group