Bhaskar Sharma Email & Phone Number

Irving, Tx

Fort Mill, South Carolina, United States

• Design, implement, and maintain scalable data pipelines using AWS services such as Glue, Data Pipeline,Lambda to move Source file to RDS.• Processed nightly & near real time data to Operational Database.• Ensure data quality and consistency across different data sources• Develop workflows that trigger based on specific events, orchestrating actions across & Lambda Glue Jobs.• Create Airflow DAGs to load data from Operational DB to DWH.• Use AWS CloudWatch or other monitoring tools to track event ingestion, processing, and delivery metrics.• Define clear event schemas and standards to ensure consistency and compatibility across event producers and consumers.• Triage many possible courses of action in a high-ambiguity environment, making use of both quantitative analysis and business judgment.

Bengaluru, Karnataka, India

• Developed modern Data Architectures, such as data warehouses, data lakes, data meshes, hubs and associated capabilities including ingestion, governance, modeling, observability.• Extensive experience with OLAP System and developing Datawarehouse Schemas like Star schema and Snowflake schema used in relational, Dimensional modeling using industry leading Data Modeling tool Erwin• Extensive experience in Dimensional Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering, Publishing Erwin diagrams, analyzing data sources and creating interface documents.• Experience in the implementation of Data Management projects, Master Data Management, Metadata Management, Data Quality, Data Integration, Lineage, Data Assets cataloguing, Data Lifecycle, ETL transformations, Data Flows analysis.• Worked on Dimensional modeling to design and develop STAR schemas using ER-win 9, Identifying Fact and Dimension Tables.• Developed, maintained, and enhanced various Informatica mappings and workflows to perform ETL of data from multiple sources into the Datawarehouse.

Dublin, County Dublin, Ireland

• Designed Dimensional Modeling, identifying the Facts and Dimensions.• Created Conformed Dimensions to allow Roll up & Drill down across to other data marts• Created Custom Fact Tables to track and measure specific types of transaction that customer made. Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Flat files.• Development of ETL using Informatica IDQ.

Pune, Maharashtra, India

• Data Analysis, Requirement Analysis and Data Mapping for ETL processes.• Developed Mapping, worklets and Workflows in informatica IDQ to achieve data loads.• Done end to end testing for initial and incremental data loads.• Implement delta deduction logics in code using MD5 functions.• Implement data Warehousing concepts of SDC Type 1 and Type 2 for data loading• Creating Hive external tables to store the GGS output. Working on them for data analysis to meet the business requirements.• Involved in Hive performance optimizations like partitioning, bucketing and perform several types of joins on Hive tables and implementing Hive series like JSON and Avro.• Use agile development environments using continuous integration and deployments.

Pune, Maharashtra, India

• Performed System Study, Design, Development, and Implementation of the system.• Created wholesale loan billing interfaces for Bill generation.• Creating PL/SQL Packages, Procedures, Functions for data population and validation as per project requirements.• Extensively used bulk collection in PL/SQL objects for improving the performing.• Deliver many builds for converting old bills into new LIQ system.• Maturity bill generation one day prior of maturity without altering default days and last regular bill.• Testing the code, deployment, defect fix and supporting the application.

Mumbai, Maharashtra, India

• Supporting of database packages, procedures, functions and triggers on Oracle 10g databases.• Maintaining database objects such as tables, views, synonyms, indexes, sequences as well as custom packages tailored to business requirements.• Written logical SQL queries using joins, sub queries and correlated sub queries.• Extensively worked with Dynamic SQL.• Creating independent transactions using Pragma Autonomous Transactions• Involved in PL/SQL Code review and modification for the development of new requirements.• Working on multiple schemas within a database, thereby making use of Grants, Privileges and Synonyms• Involved in partitioning of very large tables. Used range partitions.• Performance tuning through Explain Plan, tkprof, AWR reports.• Understanding the functional flow of all modules through BRD.• Designing the database structure and developing the code as per requirement using PL/SQL.• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements• Programmed Packages, stored procedures, queries, and triggers in Oracle 11g.• Used SQL*Loader to load bulk data from various flat files.• Writing SQL using joins, sub queries and correlated sub queries.• Testing the code, deployment and supporting the application.