SUMMARY:

• Eleven plus (11+) years of IT experience in the Analysis, Design, Development, Support, Testing and Implementation of business application systems for Healthcare, Pharmaceutical, Financial and Energy Utility Sectors.
• Strong experience in the Analysis, design, development, testing, and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Strong Data Warehousing ETL experience of using Informatica 10.5/9.1/8.5. x/
• PowerCenter Client tools - Mapping Designer, Repository Manager, Workflow Manager/Monitor and Server tools, Informatica Server Administration
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation, and production support.
• Extensive testing ETL experience using Informatica 10.5/9.1/8.5. x, IDQ 10. (PowerCenter Designer, Workflow Manager, Workflow Monitor and Server Manager) Oracle, Netezza and Microstrategy BI.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using Toad
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, Netezza, MS Access and Teradata.
• Additional Experience with open source Talend ETL tool.
• Extensive experience in developing Stored Procedures, Functions, Views, and Triggers, Complex SQL queries using SQL Server, TSQL, and Oracle PL/SQL.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing, and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle 12/11g / 10g/9i, MS SQL Server, Netezza, Teradata, Cobol files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like Automic, Tidal, Autosys and CronTab, Informatica scheduler
• Worked extensively with slowly changing dimensions
• Hands-on experience across all stages of the Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Experience with Agile and Waterfall - SDLC implementations
• Excellent interpersonal and communication skills, and is experienced in working with senior-level managers, business people and developers across multiple disciplines.

SKILL:

ETL: Informatica Power Center Mapping Designer, Repository Manager, Workflow Manager/Monitor (ver 8.1, 9.5, 10.1)

Talend Open Studios

Shell Scripting: ksh, bash, python 3.x, Perl (file validations, file downloads, workflow executions)

BI: Microstrategy 9

Salesforce Integration: Jitterbit 8

DB scripting: PL/SQL (Oracle), BTEQ, Fast Load

Change Data Capture/Data lake: IBM InfoSphere CDC (IIDR)

B2B Data Exchange: Informatica B2B x - DT/DX (9.1)

Virtualization: Denodo Express 6

Databases: Netezza, Oracle, SQL Server

Data Quality: Informatica IDQ (ver 9)

Flat files: CSV, delimited, tab files, Cobol files

Data Model: Star & Snow Flake Schemas, Atomic Warehouse Model (AWM)

Scheduling: Automic, Tivoli, Autosys Crontab

Testing tool: HPQC, Jira Project and Team lead as BI operations lead

Delivery Methodology: Agile and Linear

PROFESSIONAL EXPERIENCE:

Senior ETL Developer/ BI Operation lead

Confidential, Allentown, PA

Responsibilities:

• Onsite lead with the dual responsibility of BI Operation Application and ETL Senior developments
• Supporting complex BI structure with key responsibility and reporting to business
• Responsible for Business Analysis and Requirements Collection.
• Involved in building the ETL architecture and Source to Target mapping to load data into the Data warehouse.
• Responsible for various business response metrics like SLA, Incident counts and L2 work from business lines for BI
• Technology point of contact for Business Analyst, Business lines
• Bi Project review committee member and Audit co-ordinator.
• Lead and Manage a team of 6
• Working with various groups to facilitate organizational and departments goals of Finance, Distribution, Transmission
• Executing consulting requests that require elevated privileges in the system
• Execution of all runbook items as needed to keep those systems up, running, and running well
• Development of additional data quality checks and processes (converting manual processes to automated)
• Informatica PowerCenter (10.1, 9.5)
• Informatica Data Quality 9
• Informatica Administration
• Denodo express 6, Jitterbit connect
• InfoSphere Data Replication IIDR
• Microstrategy BI reporting enterprise
• Netezza and Oracle Datawarehouse stack
• Unix scripting
• Manage a team of MSTR in requirement gathering
• Understanding business needs and documenting client requirements
• Co-ordinate with offshore team on the delivery of the solution
• Lead and Manage a team of 4

Technology Landscape:

• Informatica 9.1, Microstrategy BI
• SQL server integration SSIS
• Oracle PL/SQL, Batch scripting
• Jira

Datawarehouse Consultant

Confidential

Responsibilities:

• Strategies and Developing ETL solution in Talend and MySQL
• Gather the source data and load strategies for historical and event-occurring data
• Design Aggregated tables based on BI requirements for clinical trial searches
• Technology Landscape:
• Talend Open Studio
• PL/SQL scripts
• Requirements gathering and Analysis for new work packets in ETL and MFT
• Unit test case documentation and system testing
• To install and validate the Informatica B2B (DX, DT, MFT) on the new environments
• Migrate all the 52 vendors on MFT and retire the Unix scripts. Handle a separate public, a private key pair for each vendor
• Go live and supporting the new infrastructure afterward
• Fixing daily issues such as - incorrect data issues, missing files, long-running MFT jobs, failures due to outage etc.
• Automated jobs for process improvement to stabilize the system and make it more robust
• Carried out maintenance activities such as Informatica server bounce, installed Hot Fix and EBF, etc.
• Maintained various Netezza Servers (Including Mustang and Twin Fin Servers)
• Also In my project experience as Netezza admin, I have automated multiple support tasks using integrated solution shell scripts
• Technology Landscape:
• Informatica Power Centre ver 8.5
• Informatica B2B DX/DT
• Netezza Appliance (MPP)/Oracle
• Netezza Administration
• Unix Scripting
• HPQC

Datawarehouse Consultant

Confidential

Responsibilities:

• Involved in the analysis of the user requirements and identifying the sources.
• Created technical specification documents based on the requirements by using S2T Documents.
• Involved in the preparation of High-level design documents and Low-level design documents.
• Involved in Design, analysis, Implementation, Testing, and support of ETL processes for Stage, ODS, and Mart.
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS, and Mart.
• Developing ETL mappings and ETL Mapplets.
• Worked on various kinds of transformations like Expression, Aggregator, Stored Procedure, Lookup, Filter, Joiner, Rank, Router and Update Strategy.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Analyse the test data given for the mappings and Mapplets
• Unit testing the mapping and the Mapplets using the Unit test data.
• Analysis of Specification Documents provided for mappings and Mapplets. Tuned SQL for BI and Informatica jobs
• Technology Landscape:
• Informatica Power Centre ver 8.6
• Oracle PL/SQL
• Unix scripting

ETL Developer

Confidential

Responsibilities:

• Interacted with onsite Clients to understand database and ETL requirements for the project including migration of Informatica codes, Oracle script changes
• Created Informatica ETL process Informatica developer and Administrator
• Understanding the Business requirements based on the Functional specification to design the ETL methodology in technical specifications.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data
• Consolidation, standardization, matching Trillium for the unstructured flat file data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) process using Informatica Power Center 8.5.
• Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.
• Implemented performance tuning of Sources, Targets, Mappings, and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Improved session Performance by enabling property incremental aggregation to load incremental data into the target table.
• Worked with Functional team to make sure the required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
• Copied/Exported/Imported the mappings/sessions/ worklets /workflows from development to Test Repository and promoted to Production.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.
• Prepared Design Documents and Unit Test Cases for ETL process
• Re-Designing and developing Informatica ETL packages to meet the end requirements
• Deployed and migrated procedures to QA environment with Release Notes and Code Migration Documents
• Provided production support to the ETL issues, DB code fixes in Oracle and Teradata
• Technology Landscape:
• Informatica Power Center 7.1, 8.1
• Oracle PL/SQL, SQL server, Teradata
• Teradata BTEQ scripts
• Jira
• Crontab, Tivoli