| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Schaumburg, IL | PHONE NUMBER AVAILABLE | EMAIL AVAILABLE | LINKEDIN LINK AVAILABLE
Technical Skills
ETL Technologies : Informatica PowerCenter V8/V9/10 & IICS/IDMC - CDI, Informatica B2B Data Exchange,
Informatica Data Quality (IDQ)
SAP Technologies : SAP Commissions / Sales Performance Management, Express Data Loader (XDL), SDI,
SAP Datasphere, SAP HANA Data Modelling, Calculation Views, SAP BW, SAP Data Services
Cloud Technologies : Azure Data Factory V2, Azure Data Bricks, PySpark, Azure SQL, Azure Synapse Services,
Azure Functions, Logic Apps, Azure Data Lake Storage (ADLS) & ADLS Gen2, Logic Apps
Databases : Oracle, Microsoft SQL Server, SAP HANA, Teradata
Programming Languages : Python, Java, Unix Shell Scripting
Tools : Erwin Data Modeler, Control-M, SQL Developer, Toad for oracle, DBeaver,
SAP HANA Web IDE, Rally, GIT, Github Actions, JIRA, ServiceNow, SVN, ALM
Reporting Tools : SAP Business Objects - Crystal Reports, WEBI, Power BI
Operating Systems : Windows, Unix
Relevant Experience
Senior Data Integration Developer, Callidus Cloud an SAP Company Dec 2019 May 2024
Requirement gathering, built data dictionary and developed POCs and share cost estimate of the project.
Collaborate with Various teams such as Customer Service Provider, business stakeholders, Product team, and vendor partners in
gathering requirements.
Responsible for creating source-to-target mappings, high-level design, and detailed design-level documents.
Extensive experience across diverse industry sectors including Insurance, Automobile, Study group, and telecommunications.
Developed and maintained ETL pipelines to integrate data from multiple sources, ensuring data consistency and accuracy.
Designed and developed monthly provision reports for generating Payment Invoices for the Dealers with 100% accuracy.
Implemented a feature to effectively automated the monthly file processing, resulting in a saving of $100K annually.
Optimized the existing oracle stored procedures and reduced the execution time by 60 percent.
Designed and Developed Data warehousing solutions to migrated data from Oracle to SAP HANA database.
Setup a comprehensive knowledge transfer program and assumed role of SME for domain knowledge, reducing onboarding time for
new employees by 40%.
Led technical workshops for requirements clarification with Product teams, speed up the development by engaging all stakeholders.
These collaborative efforts resulted in successful delivery of multiple projects ahead of schedule.
Streamlined on-call support by introducing an SME layer for faster incident resolution, implementing weekly operational reviews to
share insights and enhance services, and introducing secondary support to reduce burden for primary.
Senior Software Developer, Parexel International Pvt Limited Aug 2016 Nov 2019
Designed and developed data warehousing system for BI, delivering insights into the Clinical Datamart. This initiative empowered
the business to make more data-driven and informed decisions.
Actively involved in Requirements gathering discussions with Business Analyst, Architect, and various stake holders to understand
and implement the new enhancements without impacting the existing functionality.
Implemented Data warehouse design data model and Created Source to Target Mapping Specification Documents.
Experienced in designing and deploying databases with high-quality data sources using Erwin tool.
Extracted source data from multiple source systems such IH, Impact, Medical Image, RTSM and EDC source into Clinical Data
warehouse using Unix and Informatica.
Creation of database objects like tables, views, materialized views, procedures, and packages using Oracle 12c with development
tools as Toad and SQL Developer.
Worked on performance tuning of the stored procedures, packages and reduced the processing time by 50%.
Created mapping for SCD type 1, SCD type 2 and Type 3 Dimensions and performing Unit testing.
Developed informatica mappings using Transformations like Expression, Router, Aggregator, Joiner, Expression and Lookup, Update
strategy, Normalizer, Transaction Control, Java, and Sequence generator.
Software Engineer, IBM India Pvt Ltd, Client: Barclays Feb 2014 - Aug 2016
Involved in the design and architectural discussions by effectively coordinating between onshore and offshore teams.
Developed proof of concepts to validate proposed solutions and reduce technical risk.
Understanding the Design Document and Mapping Documents.
Developed mappings for loading data from source tables and Flat files (Delimited) to staging tables and then to target tables using
transformations like Source Qualifier, Expression, Lookup, Update Strategy and Joiner.
Worked with Flat files delimited and fixed width, Relational Tables (Oracle) as Source and target systems.
Used Session parameters, Mapping variables/parameters and created Parameter files for imparting flexible runs of workflows based
on changing variable values.
Involved in Optimizing and Performance tuning logic of mappings to increase the efficiency.
Involved in Unit Testing, Peer review of ETL code and building Unit Test case documents.
Education
Jawaharlal Nehru Technological University, Bachelor of Engineering, June 2011.
Certifications:
Microsoft Certified: Azure Data Engineer Associate.
Certified SAP Sales Performance Management (SAP Commissions Specialist).
Discovering SAP Business Technology Platform - Record of Achievement.
Exploring SAP Datasphere.
SAP Certified Associate Integration Developer.
AZ-900: Microsoft Azure Fundamentals
Python for Beginners in OpenSAP.
Awards
Driving Consumption Award In recognition of outstanding achievement for 100% accurate Payment reports.
Making an Impact Award In recognition of outstanding achievement for process automation.
|
