Experience Summary/Brief Profile:

• 7.5 years of IT experience as an Informatica ETL developer. Involved in Analysis, Design, Development, Implementation, Unit Testing in Data Warehousing, ODS and Data Integration environments.
• Extensive experience with analysis, design, development, customizations, implementation and support of software applications in Data warehousing, Business Intelligence BI and Master Data Management MDM .
• Hands on experience on handling huge volume of data and good experience on working on performance tuning.
• Extensively worked on data extraction, transformation and loading data from various sources like EBCIDIC files, JMS, Oracle and DB2 using Informatica Power Center 9.5.
• Hands on experience of Informatica Power Exchange.
• Proficiency in developing PL/SQL and SQL PL on relational databases like Oracle and DB2 respectively.
• Involved in building UNIX shell framework for DW life cycle.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.

Technology Accomplishments:

• Automated Informatica workflow XML generation using VB Macro.
• Automated Informatica deployment process using pmrep command.
• Performed ETL on variety of sources like JMS, EBCIDIC and ASCII using Power Center.
• Used a variety of transformations like TRANSACTION CONTROL, NORMALIZER, RANK.
• Applied UDF to 300 fields in one shot by parsing Informatica mapping XML
• Implemented 4 pass through partitions in Informatica in order to fasten the data load.
• Split cobol file dags to individual files using Power Exchange.
• Migrated TERADATA BETQ scripts to DB2 compatible.
• Built a robust shell framework to perform daily batch process.
• Implemented myriad CONTROL-M groups for job scheduling.
• Developed DB2 SQL PL Modules, Stored procs to manage database range partitions.
• Implemented latest SQL features like recursive WITH clause, Analytical functions
• Implemented DB2 9.7 SQL PL concepts Modules for DB partition management
• Automated Golden Gate replicate start and stop using on demand control-M jobs
• Implemented SQL advanced techniques like XMLAGG for string concatenation, SYS CONNECT BY PATH to identify employee manager manager relationship in HR Phonebook data.
• Implemented Flashback Query mechanism to view the data that has been deleted by Source system.
• Parsing of xml file has been done using Oracle xmltype during GrandCentral enhancement.
• Modified existing feed processing previously utl file was used by using sqlloader.
• Tuning of batch jobs which were executing for hours by replacing row-by-row processing with Insert/ append / select.
• Involved in oracle up gradation from 10gR2 to 11gR1.

Technologies Worked On:

Projects Handled:

Confidential

ETL developer

Confidential is a ODS system which does process both batch and real-time data from OLTP loan service providing systems such as MSP, VLS. MBODS does perform DQ, TDQ validations and does integrate loan information received from multiple SORs.

Contribution:

• Processed real time data. Data received from JMS queues is processed using XML parser.
• Processed data received through web services.
• Used a variety of transformations like TRANSACTION CONTROL, NORMALIZER, RANK.
• Applied UDF to 300 fields in one shot by parsing Informatica mapping XML
• Implemented 4 pass through partitions in Informatica in order to fasten the data load.
• Split cobol file dags to individual files using Power Exchange.
• Migrated TERADATA BETQ scripts to DB2 compatible.
• Built a robust shell framework to perform daily batch process.
• Implemented myriad CONTROL-M groups for job scheduling.
• Developed DB2 SQL PL Modules, Stored procs to manage database range partitions.
• Implemented latest SQL features like recursive WITH clause, Analytical functions
• Implemented DB2 9.7 SQL PL concepts Modules for DB partition management.

Technologies: INFORMATICA 9.1.0 FP6, DB2 9.7, AIX - UNIX Shell Scripting, DB2 9.7, AIX, Windows.

Confidential

Project Description:

Confidential is a home lending related data origination store where we receive loan information from two different source systems. We map loan related information received from two different systems, we process it and send it to Chase File Management where they maintain all loan related files.

Contribution:

• Analyze the source specific files and define the order of loading.
• Requirement gathering with Business Analysts.
• Design the entire flow starting from file validation till they reach the target tables.
• Develop UNIX shell scripts as and when required for mail generation/audit info.
• Invoke the Informatica workflows through a web service.
• Accept JMS Message with pre-defined elements from service contract.
• Implement the audit control mechanism and re processing of files.
• Reusability of code Look up Transformations/Mapplets/Mappings with parameter file configuration.
• Develop table level triggers to get the identity columns.
• Implement the Source control mechanism and code movement from Development to Testing to Production.
• Implement ETL standard templates to maintain the uniformity of code.
• Develop mappings, sessions, workflows.
• QA the entire code of the team and pass on the test cases so that the most erratic files can be handled.
• Deploy code to production and support the pre/post deployment activities.
• Prioritize tasks, Tickets and assign to the team members.
• Follow up with the estimates and achieve the goals to meet the deadlines.
• Error files need to be re-processed to be fixed and get that back as source.
• Implemented new package where all the replicated indexes are renamed to defined convention and keeping then in sequence. Identifying unused queries from gv object usage.
• Automated Golden Gate replicat start and stop using on demand control-M jobs.
• Implemented SQL advanced techniques like XMLAGG for string concatenation, SYS CONNECT BY PATH to identify employee manager manager relationship in HR Phonebook data.

Technologies: INFORMATICA 9.1.0, Oracle 11gR2 PL/SQL , Control-M, Golden Gate and Shell Scripting, Oracle 11gR2, AIX, WindowsConfidential The major goal of this application is to handle credit processes like Credit Approval, facility Generation, Collateral Monitoring and MIS.It has 6 major modules namely: Credit Approval, Collateral Exposure Management, Collateral Monitoring, Stress Testing, Management Information System, PIMS.

Contribution:

• Interaction with client to collect the requirements.
• Distribution of the tasks to team members
• Preparation of LLD's from The Specifications Document provided.
• Preparation of High-Level ETL design document.
• Development of SCD Type-1 Type -2 ETL workflows for both Incremental and history loads.
• Involved in Code reviews, Unit testing, defect fixing , Migration Documents for higher environments.
• Involved in code Migrations and validations to Different Environments like SIT, UAT PROD.
• Support to QA in bug fixing.
• Conducting Technical sessions between Client and Polaris team on the concepts/Tools requested by Client.
• Responsible for assessing the Team members in annual appraisals.
• Involved in Resourcing for the open positions in the project.
• Involved in Completing Billing and creation of invoices for entire team.
• Involved in Completing Quality Audits for the projects Delivered to production to ensure the quality code is delivered to Production. Modified existing feed processing previously utl file was used by using sqlloader.
• Tuning of batch jobs which were executing for hours by replacing row-by-row processing with Insert/ append / select.
• Modified existing universes, canned and adhoc reports in BO.

Technologies: Informatica Power center 8.6.1, Oracle PL/SQL, Java EJBs, Business Objects, Oracle 10gR2, 11gR1, Sun Solaris, Windows platform.

• Confidential Shipping division T S has evolved into a multifaceted global enterprise with a turnover exceeding US 700 million, handling more than 15 million tons of various commodities.
• From a modest beginning as a trader in building materials, the division has grown to become the largest dealer of dry bulk cargo in the region. With a global network of offices and experienced staff, it successfully meets the changing requirements of a demanding clientele.

Contribution:

• Interaction with client to collect the requirements
• Distribution of the tasks to team members
• Preparation of ETL design document and ETL mapping specification document
• Development of ETL workflows for Incremental, Audit and Replic load as per the EDW Standards.
• Design and development of U sessions to automate the jobs
• Preparation of Deployment plan and supportive documents to deploy the code to QA and PROD environments with version controlling
• Code reviews, Unit testing and Reconciliation with oracle EDW
• Involved in the Product Enhancements.
• Developed Ref Cursors, objects and pl/sql tables.
• Invoking of web services from pl/sql.
• Unit testing and involved in User acceptance Testing
• Preparation of releases on the new developments/bug fixes.

Technologies: Oracle PL/SQL, ASP. Net ,Crystal reports, Oracle 10g, Windows.Confidential commercial and residential properties.

Contribution:

• Involved in functional discussions with the Business user.
• Presided in Business knowledge transfer session to the legacy systems and boundary applications.
• Involved in development and Unit testing of ETL components.
• Transferring the business knowledge to the Subordinates after acquiring the business requirements from Client.
• Resolved the Production issues encountered in the Production run.
• Resolved the Bugs/Tickets raised by the Business user.
• Effective utilization of reporting tools like Crystal reports.
• Independently working and supporting another project Trade License along with the current project.
• Experienced in implementing error handling Process. Automated failure handling.
• Involved in data analysis, UAT and Production stages of project. Developed Informtica Mappings, Workflows, DB Procedures, Functions, Materialized views, Views, Synonyms, Triggers, PLSQL Blocks in the above project.