PROFESSIONAL SUMMARY:

• 5 years of data warehousing, Financial Crime technology (AML) and offshore coordination experience in the areas of ETL design and development and in Oracle. Involved in complete Software Development life - cycle (SDLC) of various projects, including application development, enhancement development, maintenance and Production support.
• Extensive experience on Informatica PowerCenter tools - Source Analyzer, Warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Performed Data Extractions, Transformation of data as per business rules and load target Database
• Strong skills in Oracle SQL and Developed and Implemented many generic ETL routines using PL/SQL that are widely used in the entire Data Warehouse processes (loading, balancing and Data Quality)
• Experienced in Investigating Production incident and issues and analysis root cause.
• Write, debug and maintain UNIX shell scripts
• Exclusive experience in Project management and project Co-ordination as Tech Lead
• Extensive experience in ETL extraction, transformation and loading of data directly from different heterogeneous sources like Flat files (Fixed width & Delimited), CSV files and Relational Databases.
• Extensive experience in Data Integration and extracting data from various Operational and Legacy Systems to Data Warehouse using Informatica
• Sound knowledge in tuning Informatica mappings and identifying bottlenecks and resolving the issues to improve the performance of the data loads and extracts.
• Expertise with Data Warehouse Concepts and methodologies.
• Experienced in creating test cases, test scripts, unit testing, integration testing and worked on QC.
• Experience in working with Slowly Changing Dimensions and setting up Change Data Capture (CDC) mechanisms.
• Expertise in Job Schedulers and monitoring tools like AutoSys and have created jobs using JIL.
• Experienced using Oracle 11g/10g/9i, SQL, Toad 9.1.0.62, SQL*Plus, SAP R/3,
• Working Knowledge in IBM DB2 UDB 8.0, MS SQL Server 7.0/2000, Teradata 12, Developer 2000, Windows 95/98/2000/XP, Win NT 4.0 and Sun Solaris.
• Demonstrated accomplishments in analysing problems, involved in developing and implementing standards and best practices.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 8.5.1/8.6.1/9.0.1/9.1.1/9.5.1, Power Exchange 8.5/8.6

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2000/2005, IBM DB2 UDB 8.0/7.0 IBM DB2 7.1, DB2/AS400, Teradata 12/V2R6.2

Data Modeling Tools: Erwin 4.1/7.3Languages: SQL, Oracle PL/SQL, Unix Shell Scripting, JIL

Tools: Toad 7.3/9.1/11.6, SQL Plus, SQuirreL SQL Client, MS VISIO 2007/2010, Composite Software.

Scheduler Tools: AUTOSYS 4.5.1, Corntab, Informatica Scheduler

ERP: SAP R/3

Operating system: Unix, Windows NT, Windows 95/98/00/XP

WORK EXPERIENCE:

Confidential, Jersey City, NJ

Informatica Developer

Responsibilities:

• Exclusively worked on Power Center designer and created Mappings and workflows to facilitate validation and loading of daily Customer files and Watch List files.
• Worked on Informatica Performance improvement using partitions and parallel data processing.
• Query databases using SQL and PL/SQL to generate ad-hoc reports for users and vendors.
• Used SQL Hints and Optimization techniques for Performance improvement.
• Created Shell scripts to automate manual processes, file transfers and to spool files from database.
• Created AutoSys JIL scripts, updated existing scripts and monitor daily batches.
• Maintain, schedule and set dependencies for the sequential jobs execution in Autosys.
• Created and maintained ETL jobs to perform Extract, Transform and Load customer data for Scanning against Watchlist on Daily basis.
• Actively participated in Informatica migration from 9.0.1 to 9.5.1
• Integrate data from multiple source systems into single data warehouse using Informatica and Oracle.
• Investigate on data issues and conduct root cause analysis and resolution for Screening.
• Created Data Base external tables to load one time High volume files.
• Write and tune SQL and PL/SQL code.
• Extensively performed unit testing and integration testing and worked closely with QA team and Business Users for SIT and UAT phases.
• End to End Project co-ordination and Management for New Boards and Migrations to ESS.ET
• Close Interaction with SOR and LOB’s for smooth data transitions as per ESS requirement.
• Assisted and verified step by step deployment and project implementation plans during go-live.
• Involved in Post deployment validation and data verifications.
• Performed Data quality checks on new on-boarding feeds and provided the results of the data issue with sample files.
• Extracted files and generated reject reports for capturing exceptions on request from upstream vendors.
• Co-ordinated with Vendor teams to test the daily file transmissions
• Worked hand in hand with off shore team for continued development and monitoring.
• Run daily jobs to keep the lower environment in sync with Production to facilitate SIT and UAT testing of various on-boarding projects.

Environment: Informatica power center 9.0.1 and 9.5.1, Oracle11g, UNIX, Toad 11.6, Autosys 4.5.1 / iXP 11.3

Confidential, Bridgewater, NJ

Associate ( Informatica Module Lead )

Responsibilities:

• Requirement gathering and Analysis using Visio
• Giving presentation to the client regarding the approach to be followed and effort required.
• Analysed the old Unix and PL SQL packages and procedures to implement the logic in the new ETL processes.
• Translate the business requirements into technical specifications to facilitate the transformation of Data.
• Offshore coordination and close interaction with business and Vendors.
• Design and develop the ETL maps for loading the data and data integration. Unit testing of the ETL maps.
• Analyse the business related changes that need to be accommodated in the maps.
• Validate the data loaded into the target tables against the source system.
• Co-ordination with team for work allocation, review & ensuring quality delivery to the customer.
• Analyse the data quality issues during load.
• Primarily worked on Performance Tuning of SQL overrides and mapping transformations by identifying and removing bottle necks and improved Job Performance.
• Involved in Data mapping and Requirement/Design spec Documentation of the project and migrating releases into test and production environments, addressed and resolved post deployment and production issues.
• Involved in planning and execution of Systems Integration Testing with the QA Team and reviewed the results. Worked on QC to Update test valuation results and fixes.
• Identified production issues & provided Production Support by working across various functional teams.
• Involved and responsible for smooth transition from the design, Construction, SIT, UAT, Deployment and till the end of Hyper care.
• Coordinate with the team to complete the Quality related activities and responsible for Audit meetings and the audit findings closure in C20

Environment: Informatica powercenter 9, Oracle10g, UNIX, Compositesw, Toad 9.1.0.62, SQuirreL SQL Client

Confidential, Wayne, PA

Informatica Developer

Responsibilities:

• Created necessary “Meta Data” tables in Oracle to handle “Zip file Process”, “Decompression Process” and “Translator Selection Process”
• Created “Informatica PowerExchange Datamaps” to pull data from VSAM Source Systems and imported the datamaps into Source Analyzer by using ETL Informatica PowerCenter Designer.
• Data integration of relational data from Teradata and DB2 databases which was one of the source systems and loaded to OC DB.
• Implemented filter criteria into “Data maps” to filter the data while pulling the data from VSAM Source Systems.
• Created Complex mappings using Informatica ETL for populating data into “Staging Tables” and “OC BDL” files for the translators
• Created “Reusable Transformations and Mapplets” to avoid designing separate mappings for the same set of business rules.
• Worked with various tasks such as Session, Command, Email, Event-Wait, Event-Raise, Timer, Decision & Assignment tasks while creating Worklets and Workflows.
• Created “Pre-Session & Post-Session UNIX Shell scripts” to handle “SFTP and Archiving Zip files and Loaded & Unloaded BDL files”.
• Designed PL/SQL stored procedures to automate backend database activities.
• Developed Unix Shell scripts and used them in Informatica Pre- & Post- Session command tasks and Standalone Command tasks.
• Extensively worked on Informatica PowerExchange to extract data from SAP R/3 tables and views.
• Worked with Toad to communicate with all the backend Oracle databases.
• Worked on SQL tuning, Dynamic SQL’s and SQL Loader utilities.
• Created necessary “Parameter files” for the parameters used in the mappings.
• Created “Reusable Schedulers” to execute the workflows and Monitored Jobs and provided support on timely basis.
• Created “E-mail” tasks to notify the business people whenever any file got failed without assigning to any translator.
• Comfortable with the wizards to implement Informatica Change Data Capture logic by using Type1/Type2/Type3.
• Worked on Performance Tuning of various mappings by identifying and removing bottle necks.

Environment: Informatica Power Center 8.6.1, Informatica Power Exchange 8.6, Toad 9.1.0.62, SAP R/3, XML, VSAM, UNIX, WINDOWS XP, MS SQL Server 2005, Oracle 10g, Teradata 12, IBM DB2 UDB 8.0/7.0

Confidential, Simsbury, CT

Informatica Developer

Responsibilities:

• Worked on Informatica Power Center tools - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Developed ETL Transformations & loading process that are consistent across all applications and systems
• Requirement analysis in support of Data Warehousing efforts and integration of data.
• Created Logical and Physical models for Warehouses using Erwin
• Translated the high-level design requirements into Detail design and ETL mapping specifications.
• Performed Benchmark testing of Hardware Vs Process Speeds for Informatica mappings to calculate the lead times for batch processing.
• Created Complex mappings using Unconnected Lookup, SQL, Aggregate and Router transformations for populating target table in efficient manner
• Created Mapplets and used them in different Mappings for maintaining the standards and created Data mappings / STM.
• Created events and tasks in the Workflows using workflow manager
• Worked with various tasks such as Session, Command, Email, Event-Wait, Event-Raise, Timer, Decision & Assignment tasks while creating Worklets and Workflows.
• Used Shell Scripts and PMCMD to interact with Informatica Server from Autosys-jobs (UNIX) tool.
• Scheduled, Monitored and fixed issues in production environment.
• Setting of Error Logic for streamlining and automating the data loads for cleansing and trapping incorrect data on staging servers and then loading it to the data warehouse and Populating the warehouse.
• Developed Informatica mappings and also tuned them for better performance
• Created PL/SQL packages and procedures to build business rules to load data
• Designed strategy and coded procedures to extract daily incremental data
• Created UNIX shell scripting for file handing and archival and also to run the workflows for Informatica mappings
• Developed PL/SQL procedures, functions, and packages
• Involved in Testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches, Workflows and the Target data.
• Developed materialized views for aggregate data information
• Involved in Performance Tuning of Informatica mappings, SQL Query, views etc
• Monitored job through Autosys application view and extensively involved creating jobs for tool

Environment: Informatica Power Center 8.6.1/8.1.1 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Informatica Power Exchange 8.5, Oracle 9i, UNIX, Toad 7.3, Erwin 7.3 & Autosys.