Mar 2023 – Jan 2025 · 1 yr 10 mos · Hybrid

• Cloud Data Architect | Design & Architecture | Solution Architecture Expert | IT Consulting Leader | Dataplex | Data Catalog | Visualization
• DataPlex
• Databricks
• DBT poc
• Great-Expectations and Datahub implementation

Apr 2022 – Mar 2023 · 11 mos

Feb 2020 – Mar 2022 · 2 yrs 1 mo

• Working on Google cloud Platform(GCP). Certified Google Data Engineer
• Enabling customers to move to cloud based solution from legacy systems/On-Prems.
• Helping customers strengthen IT strategy
• Intern training programs and capacity planning etc
• Highly accomplished at organizing and facilitating one-on-one discussions, workshops, and requirement elicitation session
• GCP/AWS/BigQuery/Composer/Python/DataLake/Athena /Glue/Agile

Mar 2017 – Jan 2020 · 2 yrs 10 mos · Gurgaon, India

• Expertise in concepts of end-to-end project planning & implementation from scope management to activity sequencing, risk analysis to quality management in line with guidelines and norms.
• Providing an exhaustive, robust and secure Data Warehouse solution, end-to-end design, development and delivery of a Data Warehouse Architecture, by providing users with reusable Data Warehouse layers using Informatica ETL tool on Oracle database, to finally provide reports in presentation layer using QlikSense.
• Data warehouse application development while delivering value in the full software development lifecycle from concept and design to testing
• As a transition lead, Prepare project plan and obtain management approval of the project plan. Assure all team members understand their roles and accept their responsibilities
• Good experience on Azure services – Azure SQL (DB and DWH), Azure Storage's, Data Lake, Data Factory and Azure Analysis Services.
• Strong Data modelling experience using Star/Snowflake schema, Re-engineering, Dimensional Data modelling, Fact & Dimension tables, Physical & logical data modelling.
• Collaborated with business and technology stakeholders to ensure that the data warehouse architecture, development and utilization follows specifications and project plans
• Strong Knowledge on Hadoop 1.x/2.x Cluster architecture and monitoring the cluster.
• Providing solutions for distributed systems using Big Data technologies - InformaticaBDM/Hive/Pig/Sqoop/Python/MongoDB/AWS
• Loaded the dataset into Hive for ETL Operation.
• Efficient in building hive and Pig Scripts
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Experienced at creating effective Test data and development through Unit test cases to ensure successful execution of the data.
• Developed and maintained technical specification documentation for all reports and processes.

Jun 2014 – Mar 2017 · 2 yrs 9 mos · Gurgaon, India

• FMCG and Supply Chain business model (Perod Ricard India)
• Leading the team of DWBI development and support.
• Good understanding of OBIEE 11g DW reporting (RPD Logical and Physical layer)
• Creating conceptual Data Warehouse models, data analysis documents for reporting.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.Writing SQL statements to extract data from production transnational database for OLTP reporting requirements. Upgrading the ETL DW system, bug fixing and new change requirements to cater business needs.
• Strong Data modeling experience using Star/Snowflake schema, Re engineering, Dimensional Data modeling, Fact & Dimension tables, Physical & logical data modeling. Experienced in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Extensively worked on UNIX shell scripts that are used in scheduling Informatica pre/post session operations, database administrations and database connections.
• Experienced at Creating effective Test data and development through Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion.
• Diagnosed complex data warehouse ETL processes, business logic failures and data flows, in order to quickly resolve issues
• Demonstrates leadership skills and motivates the team for increased productivity. Has good communication, interpersonal and presentation skills.

Aug 2013 – Feb 2014 · 6 mos · Pune Area, India

• Involved in designing phase of data warehouse layer.
• Designing the mapping documents
• In continuous discussion with client and onsite counterparts for the business requirement (Transformation logic)
• Worked closely with Manager to create Project Management Report and Unified Project Plan
• Developing the mapping and workflows in Informatica, using Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplet Designer.
• Creating sample tables to store data in data warehouse.
• Enhancement of existing ETL framework (Unix Cluster) as per the project requirement.
• Have created directory structure or the landing area for the source and target files.
• Working on Unix Shell scripts which will aim at providing validation and other header/trailer checks.
• Working on errors catch block so to provide proper alert mails to support team which will enable them to reset the workflow accordingly.
• Mentoring an intern on data warehouse and database functionality.

Jan 2011 – Jul 2013 · 2 yrs 6 mos · Pune Area, India

• Managing DoubleClick Linux cluster, reporting and Ad server (Windows).
• Handling the issues created during report publishing, ad serving and due to jobs running on sever or server load.
• Developing and assisting changes in back-end modules, such as packages, functions, procedures, triggers and Informatica jobs.
• Development/Customization of new/existing reports, Performance Tuning and Optimization of existing reports (SQL and PL/SQL)
• Extensively worked with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplet Designer.
• Extracted Source Data using Informatica tools and Stored procedures from Source Systems.
• Designed various mappings using transformations like LookUp, Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator, and Expression Transformation.
• Involved in Performance tuning and testing at mapping level.
• Managing the database objects and the data as stored procedures, functions, triggers, tables, views, indexes, query tuning and identifying database performance issues
• Worked with reporting team for analysis, design and scheduling of 200+ reports
• Window server patching, Ad server roll outs and coordinating with different teams on maintenance windows.
• Interacted with client to gather the requirements and implement the same in the project.
• Coordinate and communicate system outage/maintenance’s to clients and stake holders
• Application Area : DoubleClick Media and Advertising (DART : Dynamic Advertising and Resource Tool)

Aug 2010 – Nov 2010 · 3 mos

• Expertise in Oracle9i and Oracle Database 10g.

Nov 2008 – Jan 2011 · 2 yrs 2 mos

• .Experience with BFSI (ABN AMRO & RBS) processes
• .UNIX administration, Shell scripting, System and problem analysis.
• .Writing Sql scripts for day to day data mining.
• .Oversaw the database objects and the data as stored procedures, functions, triggers, tables, views, query tuning and materialized views.
• .Installation of new Service Packs, Releases and Patches in UNIX and Windows.
• .Scripting the problematic search tasks like health checks on production
• .Oracle error handling and changes in database.
• .Scheduling and troubleshooting to resolve job failures (autosys & Cron job)
• .Working on the Change Management Processes like, SIT, UAT, Team Review Meeting, PreCAB, CAB and then finally Deployments after CAB approval.
• .Monitoring and tracking of incident reports and their associated permanent corrective actions ensuring their completion within required time frames (SLA’s).
• .Ensure that the Incident record is fully updated prior to Problem Management handover.
• .Requirement Analysis of the Project.
• .Performing impact analysis of new functionalities being added.
• .Suggesting the Management regarding the new project and system requirements.
• .Finding the Root Cause of a problem and taking corrective actions.
• .Review of customizations and verify the functional documents.
• .Maintaining consistence in the system performance.
• .Preparing the system for the disaster situations (DR).
• .Involvement in unit testing, load testing, benchmark testing and DR testing
• .Application Area: MIFT payment Processing System

May 2005 – Jul 2005 · 2 mos

• Understanding of BSNL communication in INDORE(MP).
• Understanding of Broadband, Marketing and telecommunication aspects