Informatica Senior Developer/Tech Lead

SUMATHI DEVARAJAN

SUMMARY OF QUALIFICATIONS

Around 10+ years of total IT experience in developing applications using Informatica Power Center 7x, 8x and 9x, Informatica MDM 9.5/9.7.1/ Multidomain 10.1.0, IDQ 9.5, Informatica B2B DX & DT.

Involved in different phases of Software Development Life Cycle (SDLC) and having strong work experience on Data warehouse applications. Also have an exposure in environments requiring direct customer interaction during specifications, design and development and product implementation phases.

Expertise working on both Waterfall and Agile methodology to successfully accommodate changes and delivered user stories with more quality in stringent timelines.

Expertise in working on End-To-End implementation of Data warehouse and Strong understanding of Data warehouse concepts, ETL, Star Schema, Data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT & Dimensions tables, Physical & logical database design and modeling, ERwin 4.5.

Data modeling experience using Dimensional Data modeling, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling.

Expertise in Master Data Management concepts, Methodologies and building MDM solutions.

Extensive experience in providing technical leadership for the team on Informatica Powercenter, Informatica MDM (Siperian), IDD (Informatica Data Director), IDQ (Informatica Data Quality), Address Doctor and Identity Matching.

Performed Business Request analysis, creating Business request response, Data Profiling, Source system analysis, data modeling, Trust/Match strategy design, MDM performance/load count monitoring, SIF API implementation.

Expertise in Informatica Power Center, B2B DX/DT by building and Testing DT, DX and PC components.

Worked closely with business application teams, business analysts, data architects, database administrators and BIS reporting teams to ensure the ETL solution meets business requirements. Performance improvement changes to the existing code of Informatica, queries using explain plan. Well versed with database partitioning and Informatica mappings performance improvement using partitioning. Processed large volumes of data and large files. Extensive experience in SQL tuning and Performance tuning of PL/SQL programs.

Extensive experience in working with Relational databases Oracle 10g/9i, DB2 extracting data from these sources and also from other platforms like DB2, Oracle10g/9i, MS SQL server 2005/03/00, Flat files etc.

Proficient working experience in creating Oracle Stored Procedures, Functions, Cursors, DB Triggers and Indexes. Extensive experience in SQL tuning and Performance tuning of PL/SQL programs. Proficient in SQL*Loader, SQL*PLUS, ODBC, TOAD, SQL developer applications to manage database and development.

Developed extensively UNIX Shell Scripts (ksh) for data interfaces and batch jobs.

Implemented solutions using cutting edge technologies such as Informatica data profiling, pushdown optimization, data archival, Control-M.

Good knowledge in Advanced Data warehousing architecture and methodologies, ETL framework, Multidimensional data modeling techniques.

Implemented Change Data Capture (CDC) techniques like slowly changing target (type1, type2, and type3), slowly growing targets.

Involved in analyzing high level design document, development, testing, code review and Production support activities

Have good experience in solving critical production problems and in taking critical business decisions. Worked as a team lead and Onsite/Offshore coordinator.

Knowledge on Core Java & Python programming.

Knowledge on Big data and Hadoop eco systems

Trained on Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive, Pig, Sqoop, Oozie and Flume.

EDUCATION

Master of Computer Applications, from SVCET, India, 2006.

CERTIFICATIONS:

Level 1 -Oracle Certified Associate

Level 2 - Oracle Certified Professional.

Scrum Master Certified.

TECHNICAL SKILLS

Tool: Informatica Power Center (9.6.1, 9.0.1, 8.5.1, 8.1.1), IDQ 9.5, MDM 9.7.1, MDM 10.1, Informatica Data Director (IDD) 9.5, Informatica B2B DX, B2B DT, IBM DataStage 8.5

Databases: Oracle 10g/9i, MS-SQL Server 2005/2003, DB2 UDB.

Platform: UNIX, Windows 98/XP/2000.

Programming Languages: Oracle PL/SQL Programming, SQL, Oracle Stored procedures, functions, Microsoft T-SQL programming, UNIX Shell scripting, Perl Scripting, SQL, XML and Core Java.

Others tools: Oracle (9i, 10g), DB2 Client, TOAD, putty, Control-M, ODBC, Sql plus.

PROFESSIONAL EXPERIENCE

Client –State of Connecticut, Hartford CT. Aug 2015 - Aug 2017

Project: ImpaCT (Integrated Management Process and Accountability System for CT)

Role: Informatica Sr. Developer

Work Location: Client office, Hartford, CT

Client Name: Deloitte and DSS, Hartford, CT

Department of Social Services (DSS) provides a variety of services/programs to adults, families, children, people with disabilities and elderly, includes health coverage, child support, food and nutrition aid, energy assistance and program grants. Clients can apply for benefits through www.connect.ct.gov and worker will enter the client details into EMS (Eligibility Management System) where client can access the information for approved/eligible programs. ImpaCT is an application where client can submit documents/details through online or worker can do this behalf of client for eligibility. ImpaCT is a conversion project of 26 years old data from legacy system (EMS) to new application for building the online application for faster eligibility process.

Responsibilities:

Responsible to prepare System functional design document and Technical design document.

Design and development of mappings, transformations, sessions, workflows and ETL batch jobs, shell scripts to load data into Source to Stage, Data warehouse and Data mart as per the business rules.

Extracted large volumes of data form DB2, MS SQL Server, Oracle, Flat file systems to target Oracle database

Extensively worked on extracting the data from various flat files (fixed width, delimited), applying the business logic and then loading them to the DB2 databases.

Used debugger to identify bugs in existing mappings by analyzing data flow,

Created SQL scripts, store procedures, functions, views using PL/SQL, Unix shell scripts which were used to transform data

Coordinating in migrating Informatica code to different Test environments such as SIT/INT/MOCK and for testing.

Responsible to do data loads in various environments such as INT/TST/MOCK for testing.

Responsible to fix the defects identified by QA’s.

Responsible to work on the CR (Change Requirement) and Enhancing the existing mappings, workflows with new business requirements and replaced existing Java ETLs with Informatica workflows. Report the project status to the management

Involved in all the implementation activities of Go Live from Pilot to Waves.

Troubleshoot the reasons for load failures, analyze and identify the missing data and their dependencies.

Work on DCR’s to fix the existing PROD data using PLSQL scripts.

Ability to coordinate across teams, working closely with peers to ensure the appropriate focus and sense of urgency is applied to all production issues.

Environment: Informatica Power Center 9.6.1, Oracle SQL & PLSQL, UNIX Shell Scripting.

Client: Cigna - Health Care Sep 2014 – Aug 2015

Project: AccelRx/CAQH

Role: Informatica Sr. Developer / Tech Lead

Work Location: Greenwood Village, CO

Cigna is one of the world’s largest investor-owned global health service companies with international operations in 30 countries and more than 80 million global customer relationships. Through its operating subsidiaries, Cigna provides health care coverage directly to individuals and through employers, affinity partners, brokers and consultants. Other related benefits that are offered include group disability, life and accident insurance and international insurance. All products and services are provided exclusively by or through operating subsidiaries of Cigna. Corporation, including Connecticut General Life Insurance Company, Cigna Health and Life. Insurance Company, Life Insurance Company of North America and Cigna Life Insurance Company of New York. Cigna HealthCare is one of the nation's leading providers of health benefit programs. Cigna HealthCare offers a complete range of group medical, dental and life insurance, and designs benefit programs to meet the needs of employers of all sizes.

AccelRX:

Cigna's pharmacy clients are migrating from Argus to Catamaran. This project is about accommodating the migrated clients into the ODS. The Benefits RDS is a data integration, data management and data services platform, which, at this time, primarily supports Cigna’s Select Segment business and 270/271 HIPAA response. Information Factory has been identified as Cigna’s approved enterprise approach for operational data integration, across all Cigna initiatives. The overall objective of this project is to integrate FJA benefits into existing benefits structure and facilitate the 270/271 response.

CAQH:

Maximizes business efficiency and savings by developing and implementing federally mandated operating rules. Helps optimize operations by tracking industry adoption of electronic administrative transactions for all its end consumers. It processes clients/subscribers from various source systems and feeds into data mart applying all business rules to integrate coverage/benefits in order to process 270/271 request and response.

Responsibilities:

ETL Role:

Participate in the Analysis and reviewing mapping specification document and interact with SA’s to understand the requirement and clarifications.

Responsible to prepare high level and low level design document and presenting the document to Client.

Created Development standards (Naming Conventions, Folder structure etc), Reusable codes (mapplets, shortcuts, worklets etc) and Deployment group in Repository Manager.

Break up the work into task list and estimate based on simple, medium and complex methodology.

Responsible to develop Informatica mappings with various transformations, mapplets, sessions, worklets and workflows per business rules.

Responsible to optimize the mappings to improve the performance and resolve performance issues.

Was involved in conducting the review of Informatica Code, Unit Test Cases & Results with the System Analyst, QA’s and Solution Architect and get it approved.

Prepared migration document to move the mappings from development to testing and then to production repositories.

Migrate the code to all higher environment using Harvest, track all versioning details of every component/object and coordinate with cross functional teams.

Worked in an agile methodology to successfully accommodate changes and delivered user stories with more quality in stringent timelines.

Involve in all test environments, fix the defects and support QA’s

Involve in the implementation activities of every project release, create prod support manuals and present it to hand over to support team.

Oracle Stored Procedure:

Participate in the Analysis and reviewing mapping specification document and interact with SA’s to understand the requirement and clarifications.

Responsible to prepare the high level design document and review with Client and End consumer.

Coordinate with offshore to complete the development per timeline.

Review the code with Client and get it approved.

Involve in migrating the code, tracking the versioning.

Actively involved in all test environment and fix the defects and support QA’s.

Involve in Performance test and coordinate with PVS team and apply the recommendations to the Stored procedure if there are any performance degrade found.

Involve in the implementation phase of every project release and prod check out with End consumer and business users.

Environment: Informatica Power Center 9.0, Oracle SQL & PLSQL, UNIX, SCM (Code Migration), ESP Scheduler.

Client: Healthfirst Dec 2013 – Sep 2014

Project: Leaf Plans Phase I & II

Role: Informatica MDM Hub Developer/Module Lead

Work Location: Lake Mary, FL

Healthfirst is a not-for-profit managed care organization sponsored by some of the most prestigious and nationally recognized hospitals and medical centers in New York. We are one of the fastest growing health plans in our area with over 900,000 diverse members and a network of more than 24,000 providers and 3,400 employees.

Responsibilities:

Collaborate with source system experts to design integration points, ensuring completeness and accuracy of the data

Involved in design, development, testing, automation, and support of MDM domains.

Involved with Data Steward Team for designing documenting and configuring Informatica Data Director for supporting management of MDM data

Identified Golden Record BVT for Customer Data by analyzing the data and duplicate records coming from different source systems.

Adhere to MDM best practices, architecture and other standards.

Created landing tables Staging tables Base Tables as per the data model and data sources.

Developed mappings using various cleanse functions, define Trust Score Validation rules, Match rules and Merge settings.

Used Hierarchy tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles.

Writing and customizing user exits, customizing configuring Business Data director (BDD) Informatica data director (IDD) applications.

Setup SIF for java application communication and interfacing the IDD as required.

Worked on Real Time Integration between MDM Hub and External Applications using Power Center and SIF API for JMS

Design and development test scenarios for unit and integration testing.

Preparation of test cases and code review document, debugging the defects identified and fixing them.

Participated in managing code and configurations for multiple environments, release management process, maintaining environment configurations and controls, and code integrity.

Ability to coordinate across teams, working closely with peers to ensure the appropriate focus and sense of urgency is applied to all production issues. Provides assistance in root cause analysis for service interruptions.

Published the records to downstream applications with help of ETL power center & message queue.

Environment: Informatica MDM 9.7, IDD, Oracle SQL & PLSQL, UNIX, WebLogic, WebSphere/JBoss.

Client: Affiliated Computer Services Inc. (ACS) - Xerox Company Jul 2013-Dec 2013

Project: EDI HOpR Implementation

Role: Informatica Sr Developer, Health Care Solution

Work Location: Tallahassee, FL

The Xerox Inc. goal is to achieve CAQH CORE certification for their HIPAA transactions, for that they need to implement their EDI system (HIPAA transactions) compliance on the Affordable Care Act (ACA) standards of CAQH CORE Operating Rules requirements. The project HIPAA Operating Rules Assessment (HOpR) involves the impact analysis of EDI applications and the processes supporting legacy operations of CO, DC, DOL, MS, MT, NM, PBM Commercial (HI & OH), PBM Texas and WY as applicable in light of CAQH CORE Operating rules (Phase I, Phase II and Phase III (Only EFT/ERA) rules and documenting the high level solution recommendation. In the current EDI system involved multiple core technologies Informatica, Java and Mainframe. At high level Informatica does convert input files into different format files, Trading Partner validation, HIPAA validation and X12 data conversion etc. This assessment to analyze the Core rules impacts in each of the core application to provide solution recommendation.

Responsibilities:

Responsible for On Call Production support activities, handling real time and batch issues.

Monitoring EDI Legacy Batch and Real time jobs.

Responsible to implement & test CRs in all PRE Prod environments.

Involved in the defect fix of B2B Development.

Involved in deployment of Maps to other environments.

Responsible to work on JIRA tickets and provide resolution to close the tickets.

Support Project managers for status tracking and reporting

Scheduling and Monitoring the UAT jobs.

Start and stop Informatica services using scripts.

Create standard and best practices for using the platform.

Resolve any issue raised by the client and communicate with the concerned team.

Environment: Informatica 9.1.0 B2B DX, B2B DT 9.1.6, UNIX, Oracle 10g.

Client: WellPoint July 2012 -Jun 2013

Role: Technical Lead/System Analyst

WellPoint, Inc. is the largest managed health care, for-profit company in the Blue Cross and Blue Shield Association. It was formed when WellPoint Health Networks, Inc. merged into Anthem, Inc., with the surviving Anthem adopting the name, WellPoint, Inc. and began trading its common stock under the WLP symbol on December 1, 2004.

EPDS V2 – Migration

Providers from regional systems are migrated to a common database to use it as single source of truth. This will be used by downstream applications for claim processing. The project is centered on the Informatica MDM platform and will utilize capabilities of Informatica data quality tools and Informatica data integration tools

Responsibilities:

Understood business requirements and data and created MDM data models and IDD configuration for domains as per the requirements provided by customers with their data.

Designed and configured MDM hub and IDD. Created Staging, Landing tables, Mappings and data flow to the Base object tables, Match& Merge, Trust settings, Complex hierarchies & workflow for Informatica MDM.

Data Profiling and Data Quality Analysis of the data given by customer to find out anomalies in the data and highlighting the effectiveness of the Informatica Products.

Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.

Used Address Doctor extensively for Address validation of Providers from different legacy Source Systems. Built several reusable components on IDQ using Parsers, Standardizers and Reference tables which can be applied directly to standardize and enrich Address information.

Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems.

Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.

Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.

Used Hierarchies tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.

Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.

Configured match rule set property by enabling search by rules in MDM according to Business Rules.

Performed match/merge and ran match rules to check the effectiveness of MDM process on data.

Worked on performance tuning of the complex transformations, mappings, sessions and SQL queries to achieve faster data loads to the data warehouse.

Implementing the Business Change Requests (BCR) at the client side.

Ensuring that the team has the required technical expertise to execute the project. This involves the identification of key technical areas related to the project and conducting training sessions to plug any gaps.

Worked on real time implementation using SIF

Worked on hub customization and user exits.

Environment: Informatica MDM 9.5, MDM IDD 9.5, JBoss 5.1, DB2, Address Doctor 5, Informatica Data Quality, Informatica power center 9.6.1.

Client: Affiliated Computer Services Inc. (ACS) - Xerox Company Apr 2011 –-Jun 2012

Project: Department of Health Care Services, North Dakota - Data Conversion

Role: Informatica Sr. Developer & Module Lead, Health Care Solution

Work Location: Chennai, Tamil Nadu, India

Implement MMIS system for North Dakota Medicaid Program. Extracting data from Legacy and converting as per client requirement and loading into data warehouse.

Responsibilities:

Responsible for review of Technical specs and tracking modules

Review the modules/code and ensure the delivery

Responsible to lead 4-5 people per each module.

Involved in the development of mappings using ETL tools, unit testing

Involved in SIT testing phase and do critical defect fix and provided resolution.

Interact with the Quality groups to ensure that the highest level of quality standards are maintained

Support Project managers for status tracking and reporting

Offshore Point of contact for the Technical team for any discussions

Informatica Code migration using deployment group.

Scheduling and Monitoring the UAT, PROD jobs.

Start and stop Informatica services using scripts.

Create standard and best practices for using the platform.

Worked closely with development team to provide guideline, code review, finalize code and move it to Project folder.

Resolve any issue raised by the client. Handled team at offshore, assigned and distributed the work

Conducted unit, performance and user acceptance testing.

Environment: Informatica 8.5, 9.0, UNIX, Oracle 10g.

Client: E*Trade Financial Corp, US May 2010 - Apr 2011

Project:

Role: Data Stage Developer

Work Location: Chennai, Tamil Nadu, India

A diversified financial services holding company, by and through its subsidiaries, is a global provider of financial services to retail, corporate and institutional customers E*Trade wants to build ETL solution and common platform to develop BI applications to analyze their customers, operation teams. Goal is to increase the efficient of overall workflow by analyzing the work item handling process.

Responsibilities:

Analysis of High level design document.

Review the modules/code and ensure the delivery.

Interact with onsite Lead to understand the requirements/strategy.

Involved in the development of jobs/unit testing and data profiling using ETL tools.

Involved in SIT/UAT testing phase and do critical defect fix and provided resolution.

Support project managers for status tracking and reporting.

Environment: Data Stage 8.5, UNIX, Perl Scripting, IBM DB2.

Client: Blue Cross Blue Shield

Project: Administration of HSC and EDW projects Sep 2007 – Apr 2010

Role: Informatica Developer

Work Location: Chennai, TamilNadu, India

Blue Cross BlueShield, United States is one of the largest non-profitable Health Insurance Company in the world. The services provided are health care insurance, coverage, prescriptions, education, Research, and Marketing etc. HSC and EDW are primarily responsible for BlueCross BlueShield facets, dental, provider etc extracts wherein data is continuously changing for the same purpose Informatica’s Power Exchange CDC option has been used to deliver near real time data to the business

Responsibilities:

Development:

Actively involved in understanding architecture design and ETL Informatica development activities of building Operational Data Stores (ODS) to support Operational and Analytical Reporting

Responsible for implementing the staging strategy by adopting various staging options (staging, file, relational). Extracted data from Facets application to pull it into the Staging area.

Analyzed facets data like claims, billing to resolve related subject areas issues. Analyzed the data models of all the extracts such as facets, dental, provider and FRS.

Used Facets application to open, add generations, enter and save information.

Extensively worked with pmcmd and infaservice startup and shutdown commands

Developed mappings sourcing XML data using best practices, isolated and resolved issues that arise in the staging and pre-production environment.

Extracted data from Staging area (MSSQL) to EDW (Oracle) using SQL queries.

Performed unit testing and design verification for implementing BI processes.

Extensively used Informatica client tools-Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager for resolving day to day issues.

Created mapping/mapplets, reusable transformations using transformations like Lookup, Filter, Expression, Stored Procedure, Aggregator, Update Strategy etc.

Extensively worked in the performance tuning of the long running ETL mappings and workflows in all lower environments.

Managing the migration of all Informatica Objects and session parameter files.

Involved in running of shell scripts and using other UNIX commands to facilitate smooth migration and development process.

Written PL/SQL packages, procedures and functions to achieve various business functionalities.

.

Environment: Informatica 8.6, Oracle, SQL Server 2005, DB2, Windows XP.

Client: Option One Mortgage Corporation Feb 2007 - Aug 2007

Project: OOMC CIF B2B (Customer Information File B2B Data mart)

Role: DI Trainee

Work Location: Chennai, Tamil Nadu, India.

Option One is a mortgage company, which processes home loans. CIF B2B denotes Customer information File Business to Business data mart, which is a part of the enterprise data warehouse model. CIF B2B involves cleansing of loan data through brokers who are assigned under different account executives. The project was aimed to analyze the revenue generated by the brokers and account executives.

Responsibilities:

Build Informatica workflows and mappings following strict naming and coding standards.

Work with existing functionality for UNIX automation, status and reporting runtime functionality, ensuring satisfactory response time with the database connectivity/and or system command interfaces.

Interact with Analytical Teams on a limited basis.

Implement best practices on new Informatica implementations with cross environmental considerations.

Involved in all the testing environment and document test cases and test scripts.

Facilitates knowledge transfer and mentors other team members.

Environment: Informatica 7.1, Oracle, MS SQL Server 2000, Windows 2000.

Contact this candidate