SUMMARY:

• Over 11 years of referable expertise in Database development and Data warehousing with hands - on ETL Development skills. Strong understanding and work experience in domains such as Banking, Insurance, Retail and Financial sectors.
• Data Processing experience in designing, developing and implementing Data Mart applications, mainly transformation processes using ETL (Informatica/SSIS). Hands-on Experience in installation, upgrading patches, configuration, and Administration of Informatica PowerCenter client/servers.
• Intimate knowledge of the database schema and as an ETL developer has a full understanding of each step in the ETL process and can write ETL programs with scripts, packages, mappings, etc. (depending on the tool). Analysis, development, QA, implementation, monitoring and administration of the ETL process.
• Extensive experience in implementation of Data Cleanup procedures, transformations, Shell Scripting, Stored Procedures and execution of test plans for loading the data successfully into the targets.
• Emphasized on Performance of Mapping Optimizations in Informatica Client/Administration tools.
• Worked on various heterogeneous databases: Oracle, SQL Server, DB2, Teradata, Sybase, Flat files and XML in creating SQL reports, ETL Overrides, transactions and conversions.
• Automation and scheduling of Informatica jobs using Crontab, AutoSys and Control M.
• Technical abilities are complemented by sound communication and good user interaction abilities, well versed with the quality processes.

TECHNICAL SKILLS:

Job Function: Architect, Developer, Administrator, Maintenance, Analysis, Testing, Documentation, DPR, CM.

Data Modeling: Erwin 4.0/3.5, PowerDesigner,Microsoft Visio.

ETL Tools: Informatica PowerCenter 9.6, 9.5.1, SSIS

Databases: Oracle (12c, 11i, 10g), IBM DB2/UDB 9.7, SQL Server (2005, 2008, 2012), Sybase, Teradata, IBM Mainframes.

ERP Tools: SAP R/3 releases 4.6B, and 4.6C

Languages: PL/SQL, T-SQL, C and C++, C#.

Scripting: UNIX Shell Scripting, PERL

Tools: WinSQL, SQL*Loader, MS Project 2012, MATLAB 9, AutoSys, Control M, TOAD

VC: TFS, GitHub, MS Visual SourceSafe, IBM Rational ClearCase 7, PVCS, SVN Tortoise

PROFESSIONAL EXPERIENCE:

Confidential, Fort Mill, SC

Developer III

Responsibilities:

• As Data Service Developer, my expertise included CRM, ETL, SQL, C# and API Developments for CAT teams.
• Create/Enhance CRM Outbound data feeds, Distribution process for Order Fulfillments, Field Force Alignments, Web API process and other Requests for the Client Aligned Teams.
• Develop custom process for preferred clients to decrease manual operational interventions on the PP+ CRM platform. Recent program included Patient-Nurse Auto Alignments with their respective Patient/Provider zip codes.
• Create/Update C# program, SSIS Dataflow and Write Complex T-SQL queries to process Data feeds, Inbound/Outbound distribution Files and Field Force Alignments.
• Team Foundation server (TFS) is used in versioning the Data Services Work Items and keeping track of them in Scrum Daily Calls. DSU helps Developers the understand team perspective and Items that need to be prioritized.
• For Quality of work did or gave peer review and adhered Lash Standard processes - including proper handling of SDLC Release Plan, Release Notes and other requirements to be reviewed before handing over to Testing teams.
• Used ServiceNow for all the Change Request, Incidents and Sprint Releases.
• As Developer, the standard documents that are required to be completed for Change Release approvals include - SDLC Release Plan, Release Notes for all environments, Technical Design Document, Production Validation Checklist and TFS Change-sets.

Environment: TFS, Agile, SQL Server, SSIS, C#, PPLUS CRM,Webservices, API, ServiceNow.

Confidential, NYC, NY

Lead ETL Developer

Responsibilities:

• As a senior Informatica Lead built the Informatica 10.1 platform for CPG from scratch.
• Currently assisting client on Clergy Pension Plan Review(CPPR) overhaul from Oracle BW database into new EDW (MySQL).
• Developed Overall Informatica process by building ETL mappings and Unix Shell scripts
• Implemented and helped creating Informatica Medatadata objects and CPG glossary to provide visual map of the data flow within the environment.
• Build best practices ETL & Parameterized entire batch process so it can be reused by the developers.
• Build Audit Control Process to log any ETL batch loads
• Created Mapping documents, run books, How-to Informatica process documents.
• Helped various vendors to abide the company structure and timeline for immediate remediation effort with minimal cost and compliance.

Environment: Jira, Agile, Informatica 10.1, MySQL, SQL Server, ServiceNow, GitHub, SSIS, Ruby and Linux.

Confidential, NYC, NY

Lead ETL Developer

Responsibilities:

• As a senior advisor at Confidential & Young worked on project management and IT related projects including data warehouse, ETL, Spotfire and Guidewire technology.
• Currently assisting client on Program Governance Creation and Program Structure/Governance Oversight. This helped client to manage current structure, project stakeholders and PMO office.
• Worked at top banking client on CCAR IA PMO project to streamline and help the team to deliver Weekly CCAR Report submissions to the client.
• Created metrics to help client for monthly resource requirements, Actuals to Budgets, Milestones tracking.
• Helped clients to process data migration, change management, RAID logs and best practices.
• Presented client with decks for current and future state assessment and turnaround time to mitigate/resolve issues.
• Created BRD/FRD documents, Change Management, PowerPoint presentation to the C- Level board and updated it to the companies’ SharePoint.
• Helped various vendors to abide the company structure and timeline for immediate remediation effort with minimal cost and compliance.

Environment: PowerPoint, Excel, ETL tool, SharePoint, Informatica, SSIS, Guidewire and Databases.

Confidential, NYC, NY

Lead ETL Developer

Responsibilities:

• As ETL Lead developer and support person, took control of the L3 activities. Unit testing, Analysis, Solutions for the Book of Work given to LCDB data issues and other development activities.
• Identify critical components that need performance tuning both at ETL, UNIX and Database level.
• Streamline the LCDB exceptional handling currently done using Perl/UNIX scripts. Standardize non-generic FW scripts into generic file watcher script, which handles the start to end of the LCDB daily process.
• Working on parallel Remediation LCDB process that will complement, standardize and Fix current LCDB process.
• Ground work and Proof of Concept to upgrade the Informatica to latest versions

Environment: Informatica PowerCenter 8.5, Oracle 10g, Siebel, UNIX (Solaris), Control M, SVN Tortoise, Oxygen XM editor, MS Outlook, ASCII/XML Files

Confidential, Bethlehem, PA

Lead ETL Architect and Developer

Responsibilities:

• Helped creating ETL database modules for Design, Development, Analytical/Reporting purposes.
• Assisted various development groups and application developers, to chart out the overall successful flow of data into multiple target systems.
• Identified potential risks/sub-standards and fixed them in the new projects.
• For the above projects (scope) and some not mentioned - My Major roles as Informatica and SSIS Lead Developer is to help Guardian’s Data Integration projects finish successfully and document them for future analysis.
• Created integration between business glossary and Metadata manager to help using correct table objects.
• Created UNIX shell Scripts to process jobs (run scripts, generate parameters and merge statements), safe FTP transfer of Data Files and/or trigger completion ETL Workflow process.
• Created complex Informatica mappings to support Slowly Changing Dimensions, Change Data Capture and Transactional loads for various systems.
• Develop data profiling and quality assessment processes
• Worked on unit testing, system integration testing data validation, migrations to UAT and Production environments.
• Created Technical documentation (run-books, technical understanding) and standards for project charter sign off.
• On call, Monthly rotation and bi-weekly recycle repositories during scheduled window.
• Responsible for Informatica Admin duties, error handling, scheduling and maintenance.
• Automate Informatica Scheduling process using CRONTAB. Maintain Inventory for the batch jobs, person responsible for each application and group email lists
• Assisted Informatica up-gradation to 9.0.1 on Client/Server and tested applications
• Participated in semi - annual DR Exercises and tested failover of the major ETL business batch jobs.
• Supporting Microsoft SSIS Packages deployments, scheduling and debugging.
• ServiceNow to process business tickets and incidents.

Environment: Informatica PowerCenter 9.6/9.5.1/9.0.1/8.1.1, DB2 UDB 9.7, MSSQL Server 2005/2008, SSIS/SSRS, Oracle 10g, Siebel, Teradata, Java/J2EE, Eclipse, IBM MQ series, SQL*Loader, UNIX (AIX), Lotus Notes

Confidential, Plymouth Meeting, PA

Lead ETL Developer

Responsibilities:

• Worked as ETL Developer to furnish specs and document them for business requirements
• Upgraded Informatica 8.1.1 SP5 on Windows environment.
• Installed SQL Server 2005 client on windows for testing one of the target database.
• Worked on Aggregator, Filter, Router, and Lookup, Update strategy, Expression and SAP/ALE IDOC transformation.
• Processed Informatica to ‘create Inbound iDoc (Intermediate Documents) Mappings’ to send the SAP Inbound iDocs to SAP systems and to ‘create custom Outbound Mappings’ to read R/3 tables.
• Worked on ALE (application link enables)/iDOCs, RFC/BAPIs multiple stream custom mappings, data conversion and extraction using BDC programs, reporting, dialog programming and enhancements.
• Worked on Database Stored Procedures, Functions, Triggers and Database Constraints

Environment: Informatica Power Center 8.1.1, SAP ECC 6.0, BAPI/ALE, ABAP/4, Microsoft SSIS, MSSQL Server 2000/2005, Oracle 10g, PL/SQL, SQL*Loader, Java/J2EE, Eclipse, QlikView 11, IBM MQ series, IBM AIX, Hadoop

Confidential, Philadelphia, PA

Lead ETL Developer

Responsibilities:

• Worked on ETL Architecture to furnish business requirement specs and document them for Informatica developments.
• Understood the business requirements, standards and best practices. Created technical mapping specifications for design/build of Informatica mappings.
• Directed implementation of Informatica PowerExchange 8.x install including options (SAP R/3 extraction, VSAM creation from Mainframes data map, Batch/real- time CDC, SQL Server CDC).
• Created Informatica batch jobs for loading iDocs, Flat Files and database objects to Sunoco ODS environment.
• Created SSIS packages and configuration files to load data into SQL Server 2005. This includes complex T-SQL queries (Common Table Expressions) and Functions, profiles, configurations.
• Helped in installation, upgrading and applying patches from Informatica 7.1.1 to 8.5.1.
• Tune the system run EXPLAIN Plan, SQL Trace and TKPROF against long running queries.
• Used SQL Override to reduce the no. of transformations and improved the performance of the sessions.
• Having command on troubleshooting with the help of error logs generated by Informatica server and testing of the ETL procedures using Informatica session log.
• Worked Extensively on SQL Server 2000/2005 Target databases to find solutions and rectify them in views.
• Migrated new database objects for WebFocus team to create Masters for the reports.
• Well documented and designed the table load plans including aspects of surrogate keys, dimension tables, fact tables and the aggregate tables.

Environment: Informatica Power Center 8.5.1/7.1.1, PowerExchange 8.1, Microsoft SSIS, MSSQL Server 2000/2005, ORACLE 10g, DB2 UDB 8.2, Web Focus 7, PL/SQL, SAP R/3 4.6B, SQL*Loader, PowerBuilder 11.5, IBM-AIX

Confidential, Milwaukee, WI

ETL Developer and Administrator

Responsibilities:

• As Informatica Architect was involved in creating POC for upgrading Informatica PowerMart 6.x v to 7.1.1.
• In Phases (divided into groups) - Gigantic task included overhaul of the 35 clients (40 repositories) Informatica.
• Involved in implementing new ETL transformations (like lookups on flat files, union and java) logic wherever necessary.
• Developed and maintained industry wide best standard policy document and enforced them time-to- time.
• Created New Repositories and configured them to the UNIX environment also created script profiles to be invoked by the user instead of them directly connecting to the server engine.
• Experienced processing daily requests for creating user’spermissions, Object/Folder migration to Production Repositories, creating new DB connections and Backup - Restore Informatica repositories
• Monitor load process during high usage and health check pmserver, pmrepserver, pmrepagent and other running objects every 15 minutes.
• Audit the production repository by running the queries against the OPB tables and revoke the obsolete user access. This also gave flexibility to prepare timeline for present users to be checked out
• Extensively used Multi-load and Fast-load utility to populate the flat file data into the Teradata database.
• Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance.
• Performance Tuning was key aspect to increase the productivity of each job and also decrease CPU utilization of different environments during peak hours.
• Involved in Optimizing and Performance tuning logic on targets, sources, mappings, and sessions to increase the efficiency of session and Scheduled Workflows using AutoSys and/or Control M.
• Worked closely with database team for handling any of the effects on Informatica from Oracle 10g RAC installation, patching, configuration and fine-tuning.
• Created test CA AutoSys jobs to Schedule jobs in the production environments.

Environment: Informatica Power Center/PowerMart 7.1.1/6.1, PowerBuilder 11.5, Teradata V2R4/V2R5, UDB 8.0, IBM Mainframes, Siebel, SQL Server 2000, ORACLE 10g, RAC, PL/SQL, SAP R/3 4.6B, SQL*Loader, IBM-AIX

Confidential, Blue Bell, PA

ETL Developer

Responsibilities:

• Technical Communications with the client which includes the understanding the requirement of the client in the architecture TrueComp 3.7 and TrueComp5.1.2 system, environment setup and ETL process in the Development and Testing Environment. Worked on TrueComp 3.7 transactions which must be converted into the new transaction format through pre-pipeline process to properly manage retroactivity.
• Analyzed and documented the client’s requirement process logic for Data Conversion
• Customized several delivered ETL mappings per requirements.
• Worked on different sources like SQL Server 2000, Flat files, Main Frames and loaded data into target oracle 9i Data warehouse.
• Designed and developed complex join, look up transformation rules (BR) to generate consolidated data.
• Error checking and testing of the ETL procedures and programs using Informatica session log.
• Validated mappings and generated custom SQL override for some of the mappings
• Created stored procedures and Freehand SQL methods and creating complex Ad-hoc Reports using the Business
• Involved with onsite team for onsite-offshore coordination

Environment: Informatica Power Mart 6.1, Business Objects 5.1, Erwin 4.0/3.5, Oracle 9i, UDB 8.0,Sybase 11.2, PowerBuilder, PL/SQL, SQL*Loader, TOAD, UNIX

Confidential, Richmond, VA

ETL Developer

Responsibilities:

• Used IBM’S METHOD BLUE to create design documents for Informatica mappings.
• Worked with Business Analyst to gather business requirements and Involved in weekly team meetings
• Reviewed the business requirements and created internal and external design for Informatica jobs.
• Created technical document for Rebates, offer enhancement and Common Spec. Involved in transfer and integration of data between third party vendors called Connect3’s Promotion Manager and Confidential .
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Flat files, SQL Server, DB2 and loading to Oracle target Data Warehouse.
• Analyzed ETL data issues in Teradata data warehouse and Oracle staging tables.
• Extensively used various types of transformations such as Expression, Normalizer, Joiner, and Update strategy, Lookup (Connected and Unconnected) to load the data
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Involved in Optimizing and Performance tuning logic on targets, sources, mappings, and sessions to increase the efficiency of session and Scheduled Workflows using AutoSys and/or Control M.

Environment: Informatica Power Center 7.1.3, Erwin 3.5, SAP R/3, Teradata V2R4/V2R5, Oracle 9i, SQL Server, DB2, PL/SQL, SQL*Loader, TOAD, UNIX