Data Developer
Resume:
RAMKUMAR SHARMA
Middleburg Heights, Ohio - *****
********.********@*****.***
PROFESSIONAL SYNOPSIS:
* ***** * ****** ** IT professional experience in Analysis, Design, Modeling, Development, Testing Implementation and Support of Data Warehousing applications in banking domain.
Extensive experience in development and designing of ETL methodology for supporting data transformations and processing in a corporate wide environment using Informatica PowerCenter v8.6/ 9.6, Oracle (SQL, PL/SQL), Teradata, UNIX and Scripting.
Involved in the Software development lifecycle (SDLC) from requirements gathering through development and support for Financial institution using Informatica PowerCenter, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
Involved in creating data maps using Informatica Power Exchange 9.6.
Knowledge of data warehousing techniques like Star/ Snowflake schema, Facts, Dimensions, Slowly changing dimension, Data Integration and other ETL methodologies.
Experience in integration of various data sources like SQL Server, Oracle, Teradata and Flat Files.
Skilled in Performance tuning, Error handling and Production Support.
Extensively worked on transformations such as Source Qualifier, Joiner, Filter, router, Expression, Lookup, Aggregator, Sorter, Update Strategy, Sequence generator and stored procedure transformations.
Experience in writing Oracle Queries, Procedures, and Functions.
Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations.
Experience in scheduling the batch jobs using workflow monitor, Autosys and CA7 scheduling tools.
Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
ACADEMIC PROFILE:
B. Tech. (Electronics & Communication Engineering.), June 2008
U. P. Technical University, Lucknow, Uttar Pradesh, India
TECHNICAL SKILLS:
ETL Tools : Informatica Powercenter 8.6.1/ 9.6.1, Powerexchange 9.6,
Toad, Putty, Harvest, WS-FTP
Database : Oracle 9i, SQL Server 2000, PL/SQL, Teradata
Languages : PL/SQL, Unix Shell Scripting
Scheduling Tools : Autosys, CA7
Incident Management : Service Center, Infoman, Service Now
Other Tools : Toad 11, Teradata Studio 15.10, Putty, WS-FTP, Endeavor & Harvest
PROJECTS & ASSIGNMENTS:
1.PNC Financial Services Group, March 2015 – Till Date
Sr. Informatica Developer (Technical Lead), Cleveland - OH
Enterprise Information Insight (EII)
Information Insights provides easy access to a comprehensive suite of dashboards designed to improve decision-making and encourage better business processes, by showing personalized and relevant Information in an easy to understand manner. Information Insights enables access to dashboards, EIP load information, alerts, search capabilities, enterprise metrics, EIP release status, and data quality metrics - each with individual pages to sort and categorize.
Responsibilities:
Interacted with business users and team leads for better understanding of business specifications & requirements, identifying data source and development strategies.
Analysed business requirements, technical specifications, source repositories and physical data models for ETL mappings.
Created technical Design documents and ETL jobs for extracting data from various heterogeneous sources, transforming it and finally loading it into the data warehouse using Informatica 9.6.1.
Developed simple and complex mappings for loading dimension and fact tables as per star schema technique using various active and passive transformations in Informatica 9.6.1.
Designed and developed pre and post session UNIX scripts (Extraction and loading scripts) and batch execution routines.
Created re-usable workflows, sessions and other tasks like event wait, event raise, decision, command and email to run the workflows with the logic embedded in the mappings.
Improved performance of ETL’s with session partitioning and pushdown optimization techniques.
Used debugger and breakpoints to view transformations output and debug mappings.
Analysed session log files to resolve errors in mappings and managed session configuration for imporved performance.
Raised ALM Defects, Change Requests and Incident Management, analyzed and coordinated resolution of code flaws for the development environment and hot fixed them in QA and production environments during the runs.
Coordinated team efforts like handing over, tracking the timelines and reviewing the code and performing Testing sessions and therefore meeting the business requirements and client standards.
Creates and maintains all databases required for development, testing, education and production usage. Performs the capacity planning required to create and maintain the databases.
Used Informatica Autosys and CA7 scheduler to run the Jobs in respective environments.
Environment: Informatica 8.6.1/ 9.6.1, Oracle 9i, PL/SQL, Teradata, TOAD, Teradata Studio, UNIX, Harvest, Autosys & CA7.
2.PNC Financial Services Group, March 2013 – Feb 2015
Sr. Informatica Developer (Module Lead), Cleveland - OH
Enterprise Data Warehouse (EDW)
Main objective of EDW is to build a data warehouse which act as Golden Source of data. The Enterprise Data Repository (EDR) provides the holistic view of customer, exposure and rating data which is key for Basel II implementation. Basel II is an accord to be followed by Financial Institutions to increase their risk sensitivity by defining three types of risk (Credit, Market, and Operational) and improving the capital and internal efficiencies of financial institutions by defining supervisory review process and public disclosure norms. This project is to make PNC bank BASELII Compliance. Project is to implement BASEL II compliance across all its portfolios. This will give PNC a strong emphasis on risk management and improvements in bank’s risk assessment capabilities. This project is using Business Data warehouse Model (BDW) to build Enterprise wide warehouse.
Responsibilities:
Prepared a detailed Technical Design Document after analyzing the Functional Specifications and Architectural Diagram. Technical Design Document captured all functional and technical requirements.
Worked with different sources like Teradata, Oracle, SQL Server, DB2 UDB and flat files.
Performed Data Cleansing before loading it on data warehouse.
Developed numerous complex Informatica Mappings, Mapplets and reusable transformations using various transformations like Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
Extensively used Lookup Transformation and Update Strategy Transformation while working with Slowly Changing Dimensions.
Involved in Performance Tuning by determining bottlenecks at various points like targets, sources, mappings and sessions. This led to better session performance.
Used Target Load Order Plan and Constraint based loading for loading data appropriately into multiple Target Tables.
Designed and developed pre and post session UNIX scripts (Extraction and loading scripts) and batch execution routines using mapping parameter/variable.
Used debugger and breakpoints to view transformations output and debug mappings.
Created PL/SQL Procedures for data extractions, transformation and loading.
Loaded data into Teradata by using BTEQ batch scripts.
Performed Code review to ensure that ETL development was done according to client’s ETL standard and ensured that ETL best practices were followed.
Raised ALM Defects, Change Requests and Incident Management, analyzed and coordinated resolution of code flaws for the development environment and hot fixed them in QA and production environments during the runs.
Used Informatica Autosys and CA7 scheduler to run the Jobs in respective environments.
Environment: Informatica 8.6.1/ 9.6.1, Oracle 9i, PL/SQL, Teradata, TOAD, Teradata Studio, UNIX, Harvest, Autosys & CA7.
3.PNC Financial Services Group, June 2011 – Feb 2013
Sr. Informatica Developer, Cleveland - OH
Enterprise Data Quality Assurance
Data Quality Assurance provides iterative services designed to detect inaccurate information and provide visibility for remediation, system, and process improvement efforts. As an enterprise of a size as big as PNC, the enterprise data should be secure and of high quality and reliability. Data Quality Assurance performs production data accuracy tests on multi-millions of rows on a regular basis (typically monthly). Informatica Power Center Tool and SQL technology will be used to perform data accuracy tests. Publish executive summary and detailed Data Accuracy Metrics using Oracle Business Intelligence Reporting tool.
Responsibilities:
Involved in all phases of project (Gathering requirements from Business users, Preparation of detail Design, Development, Unit Testing, Deployment).
Used Informatica PowerCenter for coding data quality rules and capture quality results.
Developed mappings/ Reusable Objects/ Transformation/ mapplets by using mapping designer, transformation Developer and mapplet designer in Informatica Power Center 8.6/ 9.6.
Created reusable transformations and mapplets which were used in other data quality mappings.
Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and
Sequence Generator, Update Strategy, Union, Lookup, Joiner, and Stored procedure
Transformations.
Used UNIX shell scripts in pre and post session commands to check whether ETL Audit succeeded or failed.
Involved with Informatica migration team while migrating Informatica Environment from 8.6 to 9.6.
Coordinated team efforts like handing over, tracking the timelines and reviewing the code and performing Testing sessions and therefore meeting the business requirements and client standards.
Used Autosys JIL scripts for scheduling workflows.
Status reporting and train new team members.
Handling checking of informatica components into Harvest.
Used Informatica Autosys and CA7 scheduler to run the Jobs in respective environments
Environment: Informatica 8.6.1/ 9.6.1, Oracle 9i - PL/SQL, TOAD, UNIX, Harvest, Autosys & CA7.
4.PNC Financial Services Group, January 2009 – May 2011
Informatica Developer, Pune - India
Enterprise Information Management (EIM)
EIM is aimed to provide application integration and maintenance services for various applications and process data from various sources like Oracle, SQL Server, DB2, Mainframe and flat files. In this project, our major tasks are to re-engineering & enhancement services to the existing applications that are used in banking functions.
Responsibilities:
Daily load monitoring to provide results to business users on time.
Respond to the incidents raised by users.
Investigate and provide solution to the problems raised by users.
Escalate the issues to the concerned groups (Admins, DBA etc) as per their requirement using Infoman and Service Center.
Code review & EQA for all new applications which didn’t adhere to development standards.
Defect assignment and resolving escalated issues.
Defect tracking and maintaining defect and issue logs.
Co-ordinate maintenance activities with Admins and DBA’s.
Respond to Adhoc requests raised by users.
Enhancement’s to the existing application, creation of value addition for process improvement.
Giving updates to clients, end users, business users regarding issues.
Manual processing of files in case of an incident.
Environment: Informatica 8.6, Oracle 9i - PL/SQL, TOAD, UNIX, Harvest, Autosys & CA7.
PERSONAL DETAILS:
Name
Ramkumar Sharma
Date Of Birth
November 2, 1986
Gender
Male
Language's Known
Hindi & English
Nationality
Indian
Present Address
7754 Lucerne Drive, Apt # O22, Middleburg Heights, OH 44130
Contact Number
PASSPORT DETAILS:
Name as on passport
Relationship
Passport Number
Date of Issue
Expiry Date
Place of Issue
Ramkumar Sharma
Self
G8186315
06-05-2008
05-05-2018
Ghaziabad, India
Contact this candidate