SUMMARY:

• I have 12 years of IT experience in Business Intelligence and Data Warehousing.
• My main technical forte is Informatica. I am an ETL Developer. Apart from Informatica I have experience in Oracle, Teradata, Unix and Autosys.
• I have experience in Banking & Finance, Telecommunication and HealthCare domains.
• Worked on the ETL design and prepared Data Flow Diagram in Power Point to show the data flow between tables.
• Experience with dimensional data modeling, star schema and snowflake schema.
• Experience in Data cleansing, Slowly Changing Dimensions.
• Experience in Debugging sessions and mappings; Performance Tuning of the Sessions and mappings, implementing the complex business rules, optimizing the mappings.
• Experience in extraction of data from various Heterogeneous sources (Relational database, Flat Files, Mainframe Files and XML) to load into Data Warehouse/data mart targets.
• Project Lead experience in Decision Support Systems - Data Warehousing implementing ETL (Extract, Transform and Load) using Informatica Power Center 9.5/8.6/7.1.3
• Extensively worked on Power Center Mapping Designer, Workflow Manager, Repository Manager and Workflow Monitor.
• Well acquainted with Performance Improvement of sources, targets, mapping and sessions to overcome the bottlenecks in mappings.
• Extensive development experience working in all phases of the Software Development Life Cycle (SDLC) especially in Data warehousing and Business Intelligence.
• Experienced in management and delivery of multiple modules/projects in AGILE and Waterfall methodology.
• Prepare/maintain documentation on all aspects of ETL processes, definitions and mappings to support knowledge transfer to other team members.
• Experience in creating and monitoring Autosys jobs (Box, Command and File Watcher Jobs).
• Experience in production Support in Technical and Performance issues.
• Excellent oral/written/interpersonal communication skills, quick learner, willing to adapt to the team/organizational environment.
• Development and support experience. As part of Production Support, analyze the production failure based on workflow and session logs and find the recovery process to recover the failed job/ETL

TECHNICAL SKILLS:

Tools: Informatica 9x,8x,7x, Autosys

Methodologies: Waterfall, Agile

Database: Oracle 12c/11g/10g, SQL Server 2008, Teradata 12/13, Green Plum

Operating System: Windows XP, Windows 7, Unix

Domains: Banking & financial, Telecommunication

Others: Toad, SQL Assistant, Putty, HPSM, HPQC

PROFESSIONAL EXPERIENCE:

Confidential, Monterey Park, CA

EBI-ETL Team

• Development and support of over 40 DataMarts of MUFG Dimensional Data Warehouse.
• In DDW, there are more than 500 jobs run daily, weekly, monthly and yearly based on their schedule.
• Coordinate with the business to understand the requirements for the new projects or enhancements.
• Design and develop the ETL (Stage, Dimension and Fact Layer) for the new project based on BRD, DDD and Mapping Specs.
• ETL Design Includes preparing data flow diagram to show data flow between tables.
• Perform Unit testing and prepare the unit test result document.
• Participate in SIT and UAT to get the business sign off to move the code to Production.
• Prepare Automation and Autosys Scripts.
• Create the change request and coordinate with the implementation team to deploy the code in Production.
• Responsible for smooth execution of releases
• Responsible for production support and maintenance.
• As part of Production Support, analyze the production failure based on workflow and session logs and find the recovery process to recover the job/ETL.

Environment: Informatica Power Center 9.5, Oracle,SQL Server, Green Plum, Unix and Autosys

Confidential

Responsibilities:

• Detailed Analysis of the present functionalities of Enterprise Data Warehouse
• ETL Design and Implementation of migration from Ab-Initio-DB2 to Informatica-Teradata
• Interact on a daily basis with product owners to efficiently migrate marts to the new system.
• Review and certify the code developed within the team and help in migration of the code.
• Provide estimates of modules to fit into the Scrum method for agile execution.
• Participate and provide in design discussions.
• Change management request preparation and getting the approvals
• End to end code movement from Dev to QA, QA to UAT and UAT to PROD for Informatica and Teradata.

Environment: Informatica Power Center 9.5, Teradata, Unix

Confidential

Responsibilities:

• Involved in requirement gathering and analysis.
• Involved in the data modelling of staging database.
• Involved in the design and implementation of ETL.
• Involved in writing SQL statements as a part of ETL coding.
• Involved in writing procedures in PL/SQL
• Developed the mapping between source and target to load the data into tables of target database.
• Mapping is done through Stored Procedure, Filter, Router, Aggregator, Joiner, Lookup and Update Strategy Transformations.
• Done the Unit Testing
• Involved in the Performance tuning of the ETL code.
• Involved in transition to production

Environment: Informatica Power Center 7.X, Oracle, Teradata, Unix

Confidential

Responsibilities:

• Involved in requirement gathering and analysis.
• Involved in the data modelling of staging database.
• Involved in the design and implementation of ETL.
• Involved in writing SQL statements as a part of ETL coding.
• Involved in writing procedures in PL/SQL
• Developed the mappings, sessions, reusable transformation and workflows.
• Mapping is done through Stored Procedure, Filter, Router, Aggregator, Joiner, Lookup and Update Strategy Transformations.
• Done the Unit Testing
• Involved in the Performance tuning of the ETL code.
• Involved in transition to production

Environment: Informatica Power Center 8.X, SQL, Oracle

Confidential

Responsibilities:

• Analyzing and Implementing KBI (Key Business Indicator) for Customer Deactivations and Product Deactivations.
• Involved in requirement gathering and analysis.
• Involved in the data modelling of staging database.
• Involved in the design and implementation of ETL.
• Involved in writing SQL statements as a part of ETL coding.
• Involved in writing procedures in PL/SQL
• Developed the mappings, sessions, reusable transformation and workflows.
• Mapping is done through Stored Procedure, Filter, Router, Aggregator, Joiner, Lookup and Update Strategy Transformations.
• Done the Unit Testing
• Involved in the Performance tuning of the ETL code.
• Involved in transition to production
• Created Target tables for Customer and Product Deactivations.
• Developed SP for Customer Deactivations where data are loaded from base source and reference tables to staging tables and from staging to target tables (KBI tables).
• Developed SP for Product Deactivations where data are loaded from source to reference tables to staging tables and from staging to target tables.
• Developed SPs to implement the Add and Drop partition logic for a particular table based on the retention period.
• Analyzing business flow of MBM (Manual Billing Migration) in reverse way, by checking mapping details, business logics and work flow in INFORMATICA to find business logics, all the source tables, database schemas, Flat files and Target tables.

Environment: Informatica Power Center 8.X, SQL, Oracle

Confidential

Responsibilities:

• Co-ordinated with Client and Developed the Stored Procedure for daily ancillary which is used to analyse the charge posted and cancelled services details for a particular day.
• Developed Stored Procedures for Billing and Bill Estimations.
• Written batch process SP to map Parkway database tables and Ware house tables.
• Developed stored procedures to invoke in .Net Crystal Reports for Patient Accounting module.
• Have been part of regression testing.
• Given successful Demo on Billing, Bill Estimations and Doctor Fee to the Parkway Client.

Environment: Oracle and Unix

Confidential

Responsibilities:

• Code debugging for finding the bug and reviewing it for production movement.
• Developing procedures and triggers to fix the production issues.
• Done Cross module reconciliations between Billing, Metasolv, POS and CRM to minimize the data discrepancy.
• Developed shell scripts for clearing log files from API servers and System task servers.
• Developed shell scripts for sending auto mails for activations and dunning across Teams to do the RCA for SLA slippage.
• Handling dunning (outgoing/incoming call barring/unbarring of a telephone no.), disconnections and bulk upload processes.
• SDCA Migration for migrating series of numbers from one switch to other switch
• Monitoring the Reports in the dash board and doing analysis for SLA slippage for the below,
• Post paid New Connections
• Post paid Disconnection
• Dunning
• Automating functionalities of the system to reduce manual intervention.
• Doing coding whenever any new requirement comes from the client.
• Monitoring CRON jobs in UNIX.

Environment: Metasolv, Oracle and Unix