SUMMARY:

• IT Professional with 10+ years of experience on Data Warehouse/Data Mart development strategies for extraction, transformation, and loading (ETL) in Informatica Power Center from various database sources.
• Strong experience with Informatica Data Quality IDQ 9.6, Informatica Analyst and Informatica Power Center 9X/10X tools.
• Extensively worked with various Relational and non - relational sources and target systems including Teradata, SQLServer, Oracle, PLSQL, Flat files, XML files, SalesForce.Com (SFDC) etc.
• Strong experience in Data Mart life cycle development, performed ETL procedure to load data from different sources like SQL Server, Oracle, Teradata, DB2, COBOL files & XML Files and flat files into data marts and data warehouse using Power Center Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor.
• Good experience with developing Data profiling, Scorecards, Mapplets, Rule, Mappings, workflows, Data Cleansing, Data Standardization process, data exceptional handling using Informatica Data Quality Developer IDQ and Informatica Analyst tools.
• Expertise in identifying performance bottlenecks and optimizing performance with in Informatica mappings, sessions and workflows.
• Expertise in understanding of Business Processes, grain identification, identification of dimensions and measures for OLAP applications.
• Highly motivated and goal-oriented individual with a strong background in SDLC Project Management and Resource Planning using AGILE methodologies.
• Strong knowledge of Entity-Relationship concept, Facts and Dimensions tables and developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modelling.
• Comprehensive experience of working with Type1, Type2 methodologies for Slowly Changing Dimensions (SCD) management.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Extensive experience in developing Stored Procedures, Functions and Triggers, Complex SQL queries using SQL Server TSQL and Oracle PL/SQL.
• Experience with Quality Analysis (QA) of data extracts.
• Experience on Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Experience in Jobs scheduling, monitoring and Production support in a 24/7 environment. Good experience with automating Informatica workflows with third party scheduling tools.
• Experience with version control system TortoiseSVN.
• Good working knowledge of various Informatica designer transformations like Source Qualifier, Dynamic and Static Lookups, connected and Unconnected lookups, Expression, Filter, Router, Joiner, Normalizer and Update Strategy transformation.
• Experience in Task Automation using UNIX Scripts, Job scheduling and Communicating with Server using pmcmd.
• Good experience with Production Support activities, incidents, Service requests, Problem tickets, change tickets, DR activities, Maintenance activities with Service Now, Service Anywhere and Servicedesk.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS:

Operating Systems: Windows (XP, 2000, 2003 Server,) Linux, Unix (AIX, HP-UX)

Tools: MS-Project, Visual Source Safe, Visio

ECM: HP Exstream, MS SharePoint

Languages: PL/SQL, Shell, Unix Scripting

DBMS: SQL Server, Oracle, Teradata and DB2

Data Modeling: Star-Schema Modeling, Snowflakes Modeling, FACT and dimension Tables, Erwin

Middleware, BI/ETL Technologies: Informatica PowerCenter, IDQ, Kalido MDM, IBM DataStage, Cognos, Java J2EE, SOA Framework, Web Services

Job Monitoring Tools: Tidal, Autosys

PROFESSIONAL EXPERIENCE:

Sr. Informatica Developer

Confidential, Buffalo, NY

• Liaise with business subject matter experts in analyzing business requirements, understand the various data sources, design and developed ETL processes to load data from source to target.
• Manage artifacts - versions, including software code, documents, design models.
• Worked in different projects including Extracts standardization program, Primary value reporting, Medicare secondary payer, Implementations of eArc (Electronic Adjustment/Replacement claims) program and several third party vendor extracts.
• Fine-tuned existing mappings for performance optimization.
• Created standard Member, Provider, Medical and Pharmacy claims extract mappings which can be used to generate extract files for multiple employer groups across different LOBs.
• Analyzed the existing systems and the business user requirements for tactical and strategic needs.
• Hands on Development on Kalido MDM.
• Formulating enterprise standards in the following areas: Project Management, Enterprise Reporting, Enterprise Data Architecture Modeling logical and physical, Metadata, data security, and Extraction Transformation Load ETL routines.
• Created Source to Target technical mapping documents, design documents and test case documents for the ETL processes.
• Designed mapplets and reusable transformations to standardize multiple frequently used business rules.
• Actively participated in the Informatica code review process across the organization.
• Designed multiple scheduling processes for different projects using Tidal scheduler as per the business needs.
• Participated in the application turnover process with production support team for multiple projects.
• Hands on development on the tools Informatica Power Center 10.1/9.6/8.6, Oracle11g/10g, Kalido MDM 8.5, DB2, XML, Toad, Oracle SQL Developer, Tidal, HP ALM, Workday, TFS, PL/SQL, SQL, UNIX Shell Scripts, SVN.

Sr. Informatica Developer

Confidential,Buffalo, NY

• Worked for $100M program to revamp Core Administrative Platform (CAP) to replace an existing IBM-Power based legacy health care application to a an advanced application with latest infrastructure to provide with enhanced functionality, high-availability with optimal maintenance capabilities.
• Managed conversion programs of Code sets, Providers, Groups, Membership enrollments, Benefit Plans, Authorizations, Agreements and Claims from legacy to new infrastructure.
• Designed architectural framework for rerouting consumers - both business users and customer service representatives and applications like Enterprise Data Warehouse (EDW), Enterprise Content Management (ECM), services orchestration -both external and internal with third party applications, EDI interfaces, real-time-SOA and batch-ETL interfaces from legacy to new application.
• Worked with multiple LOB owners- Commercial, Medicaid/Medicare/Child-Health Plus, Self-Funded in identifying and implementing business rules and constraints across new application to maintain consistent data across enterprise in an effort to retain source of truth across the enterprise.
• Communicated with business in discussions with State exchange, Western New York HEALTHeNET and vendors like MEDecision, NIA-Magellan, Optum, Eliza and Family Choice for data exchange related to enrollments, benefits, providers and claims.
• As part of agile methodology, attended daily scrum meetings, sprint planning, backlog grooming sessions.
• Based on the functional requirements created technical design specification documents for ETL Process.
• Implemented Kalido Categories and loaded those categories with Staging Feeds and File feeds.
• Implemented multiple ETL processes to extract data from heterogeneous sources like Flat Files, oracle, db2 and transforming the data and loading the same into Oracle and Flat Files.
• Responsible for preparing Design documents (High Level Design document and Low level design document) and security and other compliance standard documents.
• Designed several ETL processes for Medicare/Medicaid reporting.
• Involved in creating the test cases and test plans for user acceptance testing and system testing based on functional Specifications.
• Designed multiple scheduling processes for different projects using Tidal scheduler as per the business needs. Participated in the application turnover process with production support team for multiple projects.

Informatica ETL Developer

Confidential, Gaithersburg, MD

• Prepared Mapping specification document which explains source, target and transformation rules/Business logics which need to be applied.
• Developed SCD type 1, 2, 3 mappings to load the data from source to target, Dimension tables, Facts, etc.
• Developed mappings for integrating the data from various sources systems to enterprise Dataware house tables.
• Designed mappings using various transformations Ex: Source, Target, Lookup, Filter, Router, Sorter, Aggregator, Joiner, Union, Update Strategy, Expression transformation, etc.
• Identified bottlenecks and performance tuned at source, target, mapping and sessions where bottle neck occurs.
• Perform code reviews and execute the unit test cases.
• Knowledge Transition to QA team for code changes which are migrating to QA Environment.
• Migration of code changes to QA environment and providing support till QA sign off.
• Trouble Shooting the issues/defects which comes during QA testing and fixing defects.
• Migration of code changes to Integration/UAT environments, trouble shooting and fixing issues.
• Knowledge Transition to Production Support team for code changes which are migrating to Prod Environment and resolution to issues.
• Environment: Informatica PowerCenter 8.X, SQL Server Database, Oracle 11g, WSDL.

Business Analyst & Middleware Developer

Confidential

• Involved in the preparation of the functional specifications of the Financial Transaction System.
• Involved in the Development, Implementation of the backend procedures. Coded a number of PL/SQL stored procedures and data base trigger functions.
• Created Master Detail and Cross Tab reports to view the data in an analyzed way.