Chakradhararao N V H Sanka

201-***-**** ac09xw@r.postjobfree.com

Profile for: Sr Informatica Developer/Designer

Snapshot: Qualified IT professional with 11 years of experience in Business Intelligence, ETL Solution and Data Warehousing across diverse organizations in the domains of Healthcare, Insurance, Telecom & Banking, exploring challenging technical assignments with a professionally managed organization. Core competencies include….Data Warehousing Applications, Data Modeling for small to medium data marts, Informatica Power Center, Informatica Data Quality, Informatica DIH, Informatica Cloud, Oracle database with PL/SQL & SQL, Teradata data base with Teradata utilities (BTEQ, FLOAD, MLOAD, TPUMP), SQL Server with SSIS, Abinitio, Project Management, Quality Assurance, Risk/ Change Management, Integration & Migration, Reporting & Documentation, Cross Functional Team Coordination

Executive Summary

11 years of extensive experience in complete Software development life cycle (SDLC) with a strong background in Design/Modeling, database development and implementation of various business intelligence and data warehouse / data marts projects that cover gathering Business Requirements, GAP Analysis, Development, Implementations and Documentation.

Over 10 years of extensive experience as an Informatica Developer in Data Integration, Migration and ETL process using Informatica Power Center 9.x/10.x

Experience in integration of various Operational Data Source (ODS) with Multiple Relational Databases like Oracle, SQL server and DB2 and Worked on integrating data from flat files like fixed width and delimited.

Data modeling experience in designing and implementing Data Mart and Data Warehouse applications using Erwin.

Experience in data profiling and score cards creation using Informatica Analyst and Informatica Developer

Experience in creation of mapping documents from source to target data flow

Experience in designing data models as per the customer requirement for small to medium data marts using Erwin

Significant exposure in designing/ developing ETL solutions using Informatica Power Center tool, Informatica Data Quality, UNIX and PL/SQL

Experience in creating packages in SQL Server Integration Services (SSIS) for data load from one server to another server

Proficient in Oracle 10g, Teradata, SQL Server, Toad, PL/SQL and UNIX Shell Scripting

Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.

Experience in writing utilities for Teradata - FLOAD, MLOAD, BTEQ.

Experience in using FLOAD and MLOAD with Informatica Power Center

Proficient in defining technical requirements/ high level design, configuration management, process audits, agile estimation techniques, agile concepts of project management

Industry expert having keen understanding and hands-on exposure to all phases of Project / Program Life Cycle

Efficient Team Leader & Player, combining communication, interpersonal & problem solving skills with analytical, decision making and leadership capabilities to enhance organizational objectives

Good Project Coordination skills, onsite coordination and offshore team management.

IT Forte

ETL/Reporting Tools

Informatica 9.x/10/x, Informatica Developer (IDQ), Informatica Analyst(IDQ), Informatica Data Integration Hub (DIH), SQL Server Integration Services (SSIS), Abinitio, SSRS, Qlikview

Operating System

Windows XP/7/8.x

Database

Oracle 10g, Teradata 13, SQL Server 2008/2012, DB2

Languages/Scripting

SQL & PL/SQL, Shell Scripting

Special Software

Sub Version (SVN), $Universe; JCL

Data Modeling Tools

Data Modeling using Erwin

Professional Development

Informatica Power Center Data Integration 9.x Developer Specialist.

Certified Scrum Master (CSM)

Professional, Academy for Healthcare Management (PAHM).

Oracle Certified Expert

TOGAF 9 Certified

Teradata Certified Professional.

Education

M Sc. (Computer Science), Andhra University 2002

Professional Experience

Accomplishments

Played key role in setting up Informatica tools lab and organizing training at account level in Informatica Data Quality

Functioned as coordinator for new technology initiatives at account level and member of Center of Excellence (Technical) group providing technical solutions for various projects in account

Rated highest ratings in three years in a row

Recipient of Star of the Quarter award during tenure with the organization

Recipient of On the Spot Award for enhancing client satisfaction through exemplary service delivery

One of the four members who has completed TOGAF 9 certification out of 1500+ resources at account level

Part of Informatica SME at account level

Job Profile

Liaise with clients for collating/ evaluating requirements, conducting system analysis followed by finalizing technical/ functional specifications

Prepare/ present high level design documents for the project; guide team members in design, development, testing and troubleshooting of application (s)

Set up high level of technical designs, suggest changes to developers for implementing best practices in design, coding, architecture and security

Ensure compliance to industry best practices/ quality parameters in development of internal and external applications

Involved in preparing reports, manuals and other documentation on status, operation and maintenance of project

Coordinate activities related to developing pipeline for delivering organization’s software products to QA as well as production

Groom/ mentor team members in synchronizing individual team deliverables with product releases

Involved in design, development & unit testing of applications in compliance to organization as well as industry standards. Assisted & aligned activities of individual team members to product release schedules

Maintained updated documentation/ reports on status, operation and maintenance of project to enable effective decision making by the senior management team

Generated reports, manuals and other documentation on status, operation and maintenance of software

Set up test environments for implementing tests, assessing and documenting results

Managed opportunities for application and process improvement. Maintained updated project related documentation for team members and other parties

Guided team members in coding, architecture and security across internal and external applications

Projects

Project Name: NCPDP : Duration: Sep 2013 to Jun 2017 : Client: HUMANA inc, Louisville, KY, USA

Role: ETL Designer / Technical Lead

Technology used: Windows 7; SQL, PL/SQL, Shell Scripting; Informatica PC 9.1/10.1, Informatica Developer, Oracle 10g, SQL Server Integration Services (SSIS) 2010, SQL Server 2012, Teradata 13, $Universe, TOAD, Erwin

Project Brief: NCPDP standards have transformed the pharmacy industry, saving billions of dollars in health system costs while increasing patient safety and quality of care. As part of this standard, each healthcare company need to submit pharmacy claims details to State / CMS in NCPDP format. As part of this program Humana send pharmacy data to State/ CMS in the NCPDP format. After receiving the files State/CMS IT department process the files for various standards and regulations and response file transmitted back to Humana IT. Based on the response any changes need to be done for the process to be implemented and resend the claims. This gives the State/CMS to promote standards for the electronic exchange of healthcare information related to pharmacy services

Responsibilities:

Involved in requirement analysis by interacting with client SME and business

Profiling of source data and submit the profiling report to the business using Informatica Developer tool (IDQ)

Creation of score cards for profiling and submit the same to business using Informatica Developer tool (IDQ)

Interacting with business to discuss the profiling outputs and score cards

Creation of source to target mapping with the help of business

Provide project estimation based on work to be done, technology to be used and duration of project including ETL design for the module end to end in a defined format

Involved in designing database tables and related constraints for NCPDP data mart

Evaluate downstream systems for impact analysis. Assign/ coordinate work to team members

Involved in development of IDQ mappings and integrating into PowerCenter

Involved in development of Informatica workflows for transform and loading Oracle source data into Data Marts in Teradata.

Involved in development of Informatica workflows to load the data using FLOAD and MLOAD.

Transformed data from one data base server to other database server using SQL Server Integration Services (SSIS)

Designed SSIS Packages to transfer data from flat files to SQL Server

Update status report to clients at specific time intervals by providing metrics to provide project status on monthly basis at account level

Involved in end to end management of projects in compliance to project delivery schedules and other SLA parameters

Prepare reports, manuals and other documentation on the status, operation and maintenance of project

Follow up with team members in ensuring compliance to project delivery schedules and other SLA parameters

Project Name: Bazaar Voice : Duration: May 2013 - Aug 2013 : Client: AVIVA Insurance, UK

Role: ETL Developer/Designer

Technology used: Windows 7; SQL, Shell Scripting; Informatica PC 9.1, Teradata 13; Teradata SQL Assistant, SQL Server Integration Services (SSIS)

Project Brief: Aviva launched a new customer Ratings & Reviews proposition, giving customers the opportunity to provide online feedback after purchasing a motor or home policy. As part of the post-purchase R&R delivery, the BIMI team built a new data feed to enable Bazaarvoice Inc to contact recent purchasers of Motor and Home insurance. Bazaar Voice is a third party service provider to Aviva who is collecting the online feedback based on the customer extract. The review process is extended to Claims service as well as the Policy feedback process ran successfully for Aviva. In the new process source files claims feedback will be processing and output file extracts with policy and claims data in required format will be generated.

Responsibilities:

Involved in collating/ evaluating requirements gathering and mapped spec documents

Conducted data analysis on various source systems as well as downstream impact analysis

Designed & developed various ETL components, scheduling techniques and components

Involved in development of Informatica workflows to load the data using FLOAD and MLOAD.

Involved in development of BTEQs for transforming data within Teradata.

Transformed data from SQL Server to Teradata using Informatica workflows

Designed SSIS Packages to transfer data from flat files to SQL Server

Set up developed components across various environments like integration, system, UAT, production support and Production

Prepared/ implemented unit test plans on developed components including unit test reports as part of quality process

Project Name: Solvency-II : Duration: Mar 2012 - Apr 2013 : Client: AVIVA Insurance, Canada

Role: ETL Developer/Designer

Technology used: Windows 7; SQL, Shell Scripting; Informatica PC 9.1, Teradata 13; Teradata SQL Assistant

Project Brief: Solvency II is the updated set of regulatory requirements for insurance companies that operate in the European Union (EU) to comply with; based on economic principles for the measurement of assets and liabilities. It will also be a risk-based system as risk will be measured on consistent principles and capital requirements will depend directly on this Embedding Solvency II Framework within the Aviva Canada, General Insurance (GI) Business is mandatory as per regulatory guidelines. With Solvency II implementation, the general consensus is that companies must continue to improve and strengthen their internal models on an on-going basis to ensure they are state of the art and updated for current market conditions. The implementation of Solvency ll will have a major impact upon the people, processes and systems of all insurance organizations

Responsibilities:

Involved in converting high level/ low level design document or business case to appropriate ETL code

Developed session to run, unit testing, delivering and deployment. Coordinated activities related to extracting data from various sources like relational database, feed files and loading into Teradata using Informatica

Used various types of transformations like expression, filter, lookup, update strategy, SQL, aggregator, router and joiner in mappings

Prepared test cases and tested mappings. Resolved issues related to transformations and mappings

Implemented performance tuning techniques for developing mappings

Collaborated with onsite team in analysis, design discussions for development activity to be supported by offshore team

Defined work plan, monitored & reported on status based on project requirements

Managed deployment process of Informatica code from lower regions to higher regions

Project Name: Vital Signs : Duration: Feb 2011 - Feb 2012 : Client: GE Healthcare, Milwaukie, US

Role: ETL Developer/Designer

Technology used: Windows XP; SQL, Shell Scripting; Informatica PC 9.1, Teradata 13; Teradata SQL Assistant, SubVersion (SVN), Cronacle

Project Brief: Aligning Vital Signs reporting systems with GE reporting systems post acquisition of the organization by GE using Agile methodology

Responsibilities:

Involved in converting high level/ low level design document or business case to appropriate ETL code, developing session to run, unit testing, delivering and deployment

Developed design and solutions to complex business scenarios using Informatica and other tools

Conducted unit testing, functional testing of code and design including quality checks/ reviews for code developed by other members. Managed performance tuning of Informatica code and long running source SQL queries

Rendered deployment support to production for migrating/ deploying code to higher environments without issues. Performed production cycle monitoring post production deployment and data validation

Conducted root cause analysis for effectively resolving defects

Project Name: GMITPROD BOXI Retirement : Duration: May 2010 - Feb 2011 : Client: GE Healthcare, Milwaukie, US

Role: ETL Developer/Designer

Project Brief: Application designed for retirement of Oracle GMITPROD. The application, GEMSIT DW Retirement includes ETL development to bring PRODERP data flowing into GMITPROD into Teradata ODS as well. Currently data is loading from PRODERP to Oracle GMITPROD. Once the data load pointing to Teradata completely, new universe will be created on this ODS

Technology used: Windows Xp; SQL, Shell Scripting; Informatica PC 9.1, Teradata 13; Teradata SQL Assistant; SubVersion (SVN); Cronacle

Responsibilities:

Coordinated activities related to converting high level/ low level design document or business case to appropriate ETL code

Developed session to run, unit testing, delivering and deployment including designs/ solutions to complex business scenarios using Informatica and other tools

Conducted unit testing/ functional testing of code, root cause analysis for effectively resolving defects; designed, developed and evaluated quality for code developed by other members

Managed performance tuning of Informatica code and long running source SQL queries

Rendered deployment support to production for migrating/ deploying code to higher environments without issues. Performed production cycle monitoring post production deployment and data validation

Project Name: UTAH Connection Reporting : Duration: Apr 2009 - Apr 2010 : Client: SunTrust Bank, USA

Role: ETL Developer/Designer

Technology used: Windows Xp; SQL, Shell Scripting; Abinitio, DB2, SQL Server, Unix

Project Brief: SunTrust has proposed to build a robust, scalable and extensible Debit Card reporting solution encompassing all debit cards – Utah and non-Utah. This reporting solution will allow users to obtain insights around usage and performance of all debit cards used in the Point of Sale (POS) for both signature and PIN transactions. The reports will be developed via pre-defined metrics that have been determined by the Business. It will also allow ad-hoc querying and analysis of information to facilitate informed decision making

Responsibilities:

Involved in converting high level/ low level design document or business case to appropriate ETL code

Developed session to run, unit testing, delivering and deployment. Designed solutions to complex business scenarios using Abinitio and other tools

Conducted unit/ functional testing of code; designed, developed, conducted quality checks and reviews for code developed by other members

Prepared Abinitio graphs for extraction, transformation and loading data including wrapper scripts for implementing Abinitio graphs. Rendered status report at various levels based on senior management requirements

Participated in project audits, review meeting and other activities related to project

Rendered deployment support to production for migrating/ deploying code to higher environments without issues. Performed production cycle monitoring post production deployment and data validation

Conducted root cause analysis for effectively resolving defects

Project Name: BASEL2 ETL CONVERSION FOR ALGO V4.6 : Duration: May 2008 – Mar 2009 : Client: Royal Bank of Scotland, London, UK

Role: ETL Developer/Designer

Technology used: Windows Xp; SQL, Shell Scripting; Informatica PC 8.6, Oracle 10g; Unix; Toad

Project Brief: The Risk Platform is the Group's strategic solution to deliver the calculation and reporting of risk measures required to meet Basel 1 and advanced Basel 2 compliance. Algorithmics is a third party tool that handles RWA calculations for RBS. Algo is undergoing an upgrade from its current version V4.5.3 to V4.6 which requires RBS to feed data to ALGO in a CSV file format rather than feeding the existing XML files. The purpose of the Algo Scaling is to implement a technology solution to provide a capability to provide data needed by Algo V4.6 in the required CSV file format

Responsibilities:

Involved in developing ETL design documents, Unit Test Specifications (UTS) for various graphs

Prepared Informatica mappings for extraction, transformation and loading data

Conducted Unit Testing with UTS and rendered system testing as well as warranty support

Earlier Assignments

Patni Computer Systems Ltd ~ Sr. Engineer (Software) ~ Mar 2006 – Feb 2008

Contact this candidate