Data Informatica
Resume:
DIVYA MERIN MATHEW
*** ***** *** *** *, Rutherford, New Jersey, USA - 07070
adjkma@r.postjobfree.com
Professional Summary
Highly motivated IT Professional with 13+ years hands on experience in Architecture, Design and Development of multi - tier enterprise software applications. Design/development using Informatica Power Centre ETL Tool, Shell Scripting, Unix, PL/SQL and other related technologies. Strong experience in development of database related projects, maintenance & enhancement of complex application with strong analytical & development skills.
9 + years of experience in developing complex mappings in Informatica Power Centre ETL Tool to load the data from various sources into the Data Warehouse, using different transformations/ Stages like Joiner, Transformer, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier, Stored Procedure transformation etc.
13+ years of experience in processing large scale Teradata databases and actively involving in Data Modelling, SQL Query Tuning and optimization, Performance Improvement methodologies.
13+ years of IT experience in Design, Development, Testing, Implementation and Support of Data Integration & Regulatory Reports Solutions using Oracle PL/SQL & SQL, Oracle Forms & Reports.
Proficient in Performance tuning and performance optimization techniques in both Informatica and database.
Hands on experience with Fact, Dimensional, Star and Snowflake data modelling concepts. Expertise in tuning existing mappings, identifying and resolving performance bottlenecks at various stages.
Very strong in developing Complex~Drill-down~Matrix Reports using Reports 6i, XML/BI Publisher. Good technical exposure to Interfaces, Conversions. Rich Experience in query optimization, transaction processing and database design.
An effective team player with proven abilities in training and guiding team members and enabling knowledge sharing among the team.
Experience in designing FSD (Functional Specification Document), TSD (Technical Specification Document) and MSD (Mapping specification Document).
Involved in FSD, TSD and MSD reviews.
Responsible for code development, unit testing, code reviewing and code migration to SIT/UAT.
Experienced in designing and writing on-demand UNIX shell scripts.
Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion.
Have represented Change management, Incident management and release management calls with Business Managers.
Education
B.Tech (Information Technology) - 2005 - Anna University, India
Skills
ETL Tool : Informatica PowerCenter 10.2.0
RDBMS : Oracle 11g/10g/9i Server, MS-SQL Server
Languages : SQL, PL/SQL
Database Tools : SQL*Loader, SQL Developer, Toad 8.0, BI Publisher,IBM Netezza
Version Control : Synergy, Visual SourceSafe, Harvest, RTC,GIT,Bit Bucket
Quality Centre Tool : HPQC, JIRA
Job Scheduling Console : Control – M, Zena,Tidal,Autosys
Front End Tools : Oracle Forms/Report 11g/10g/6i, Oracle BI Publisher
Professional Experience
1. Data warehousing Projects & Enhancements Informatica Power Centre, Unix Shell scripting,SQL
Company : Collabera
Client : Bank of America
Duration: Jun 2020 –Till date
Role & Responsibilities: Senior Software Engineer
Involved in developing data models & tables using 3rd Normal form and star schema concepts.
Developing/Modifying new/existing Informatica source codes as per functional needs.
Extensively used Informatica Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, update strategy, Sequence generator and Stored Procedures.
Involved in Performance Tuning in Informatica for source, transformation, targets, mapping and session.
Data Modelling
SQL query Tuning and optimization
Developing/Enhancing codes as per Agile Methodology
Developed, executed and documented test plans for Unit and System Integration Testing.
Involved in the end to end implementation
2. Data warehousing Projects & Enhancements Informatica Power Centre, Unix Shell scripting,SQL
Company : Infosys Limited,New Jersey
Client : Ralph Lauren
Duration: Jun 2018 –October 2019
Role & Responsibilities: Onsite Technology lead
Involved in developing data models & tables using 3rd Normal form and star schema concepts.
Developing/Modifying new/existing Informatica source codes as per functional needs.
Extensively used Informatica Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, update strategy, Sequence generator and Stored Procedures.
Involved in Performance Tuning in Informatica for source, transformation, targets, mapping and session.
Debugging Unix Shell scripts.
Data Modelling
SQL query Tuning and optimization
Production Support
3. North star Informatica Power Centre, Unix Shell scripting,SQL
Company : Cognial Technologies Inc,New Jersey
Client : MUFG (Mitsubishi UFJ Financial Group)
Duration: Jan 2018 –April 2018
Purpose of this project is to replace Canada’s core banking system with a new system to support current operations as well as future expected growth due to new business strategies. The Current system is out of date and causes slow throughput.
Role & Responsibilities: Senior Informatica Developer
Involved in developing data models & tables using 3rd Normal form and star schema concepts.
Developing/Modifying new/existing Informatica source codes as per functional needs.
Extensively used Informatica Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, update strategy, Sequence generator and Stored Procedures.
Involved in Performance Tuning in Informatica for source, transformation, targets, mapping and session.
Working on the parallel testing by running concurrent batches and debugging the issues faced during batch run in Tidal Scheduler.
Debugging Unix Shell scripts.
4. Local Incorporation Informatica Power Centre, Oracle –PL/SQL,SQL
Client: Malayan Banking Berhad, Singapore
Duration: Feb 2016 –May 2017
In June 2012, the monetary authority of Singapore announces requirement for existing important qualifying full bank to locally incorporate their retail operations for better depositor protection. In April 2015 Maybank SG is designated as a domestic systematically important bank in Singapore and is required by the monetary authority of Singapore to locally incorporate at minimal its retail operations for better depositor protection.
Role & Responsibilities: Data Warehouse Lead
Involved in the impact study, effort and cost estimation of the Project.
Involved in Requirement gathering and design stage of the Project.
Involved in developing data models & tables using 3rd Normal form and star schema concepts.
Leading/Developing/Modifying new/existing Informatica source codes as per functional needs.
Created mappings to extract data from Flat Files,Cobol files and Oracle.
Extensively used Informatica Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, update strategy, Sequence generator and Stored Procedures.
Involved in Performance Tuning in Informatica for source, transformation, targets, mapping and session.
Developing/Modifying new/existing PL/SQL packages, procedure and functions as per user requirements.
Performed necessary changes to the Oracle Forms, Reports to cater for the project needs.
Reviewing coding, testing strategies and end-to-end testing of developed modules.
Developed, executed and documented test plans for Unit and System Integration Testing.
Automated Informatica and Oracle -PL/SQL Packages & Procedures using UNIX shell scripting In Zena Job scheduler.
5. Data Warehouse Integration Informatica Power Centre, Oracle –PL/SQL,SQL
Client: Malayan Banking Berhad, Singapore
Duration: Jan 2014 – Jan 2016
This project is to migrate all data loading programs which were using legacy SQL loader and UTL Files. In 2013 bank implemented Informatica ETL tool and migrated nearly 600 loading and transformation legacy programs into Informatica tool. The Benefit of this migration is centralization and better performance. Designed, developed and implemented a big data warehouse using Informatica Power Centre ETL Tool.
Role & Responsibilities: Data warehouse developer
Analyzed the business requirements and created required functional & Technical specifications.
Involved in Daily and Weekly Status meetings.
Migrated SQL Loader/ UTL_FILE programs into Informatica Mappings using Informatica PowerCentre.
Developed New Informatica Mappings, Sessions and workflows based on business requirements.
Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, update strategy and Sequence generator and Stored Procedure.
Developing/Modifying new/existing Oracle Reports as per user requirements.
Developing/Modifying new/existing pl/sql packages,procedures and functions as per requirements.
Managed the development and execution of test plans, and effected corrective action on data quality issues.
Automated the Informatica and Oracle -PL/SQL Packages & Procedures using UNIX shell scripting.
Post Implementation Support and providing training to end users.
Co-ordinated with business users for the post production fixes and enhancements.
Observed and monitored ETL batches to report the issues related to SLAs and ETL jobs.
Involved in finding and fixing of bugs/issues in ETL mappings
Involved in the design and development of the process to handle high volumes of data and large volumes of data loading in a given load window.
Involved in jobs scheduling, monitoring and production support in a 24/7 environment.
Involved in Documentation regarding the ETL process.
Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
6. Regulatory Reporting Informatica PowerCentre, Oracle PL/SQL, Reports & Forms
Consultant: Comtel Solutions Pte LTD, Singapore
Client: Malayan Banking Berhad, Singapore
Duration: Nov 2009 - Dec 2013
Every year bank has to adhere to Monetary Authority of Singapore regulatory requirements. Below are some of the regulatory reports which has been developed or enhanced to meet the regulatory needs.
●MAS Notice 610
●MAS Notice 759
●MAS Notice 760
●MAS Notice 649
●Deposit Insurance
●AML Reports
Role & Responsibilities: Data warehouse developer
Analyzed the business requirements and created required Functional & Technical specifications.
Involved in Daily and Weekly Status meetings.
Created the ETL design documentation, Mapping document, Migration document, Test cases.
Developing/Modifying new/existing Informatica Mappings, Oracle Reports as per user requirements.
Involved in developing data models and tables using 3rd Normal form and star schema concept .
Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, update strategy and Sequence generator and Stored Procedure.
Involving in coding, unit testing, and end-to-end testing of developed modules.
Automated the Informatica and Oracle -PL/SQL Packages & Procedures using UNIX shell scripting.
Post Implementation Support and providing training to end users.
Involved in jobs scheduling, monitoring and production support in a 24/7 environment.
7 GE Security Rollout Oracle Apps 11i ~INV, GL, AP, AR, OM
Client: iGate Solutions, Bangalore
Duration: July 2008 - June 2009
This project includes modules like General Ledger, Accounts Receivable, Accounts Payable, Order Management, Inventory and Purchasing. GE Security intends to roll-out Oracle Application modules to further set of 3 EMEA countries over 2 phases (UK, Poland & Italy). The broad level activities included are Knowledge acquisition from the business users, Gap analysis (perform localization, data conversion and customer facing documents gap analysis), Development including data conversion & loading, Develop Unit Test Customizations, Executing automatic data conversions for Customers, open AR Invoices/Sales Orders, Configuring Oracle Setups, Conduct Conference Room Pilots & User Acceptance Testing, Conduct super-user and end-user training, Transition & post-go-live support.
Role & Responsibilities:
Performing Oracle Forms personalization as per functional specifications.
Developing/Modifying new/existing Oracle Reports/ BI publisher reports as per user requirements.
Developing/Modifying new/existing PL/SQL packages, procedures and functions as per user requirements.
Involving in coding, unit testing, and end-to-end testing of developed modules.
Involved in developing data models and tables using 3rd Normal form.
Post Implementation Support and providing training to end users.
8. GE Security Flash light Oracle Apps 11i ~ GL, AP, AR, OM
Client: iGate Solutions, Bangalore
Duration: Dec 2007 - June 2008
GE Security intends to roll-out Oracle Application Modules to further set of 9 countries over 2 Phases. A significant piece of Flashlight is to consolidate local country warehouses into a central Distribution Centre in the Netherlands and replace the legacy ERP system with Oracle at the same time.
Role & Responsibilities: Oracle Developer
Performing Oracle Forms personalization as per functional specifications.
Developing/Modifying new/existing Oracle Reports/ BI publisher reports as per user requirements.
Developing/Modifying new/existing PL/SQL packages, procedures and functions as per user requirements.
Involving in coding, unit testing, and end-to-end testing of developed modules.
Involved in developing data models and tables using 3rd Normal form.
Post Implementation Support and providing training to end users.
Performing the technical work, Documentation, Data Migration.
9. ALISE Oracle10g~Forms10g~Reports10g~PL/SQL
Client: SG Global Solutions, Bangalore
Duration: Sep 2007 – Dec 2007
Role & Responsibilities: Oracle Developer
The ALISE application is the software which allows to manage the agreements of lending/borrowing of securities at the SGCIB. The lending/borrowing of securities is a regulated practice of the financial markets which consists in the issuance of an Over the Counter On OTC the interaction is bilateral. One, known as lending, is committed to yielding for duration its rights on a given quantity of a given security. The other, known as borrowing, is committed to compensate the lender and gives as guarantee to the lender the equivalent of the amount of securities lent in cash or securities. This guarantee is called the collateral.
References: Available on request.
Contact this candidate