Sql Server Project
Resume:
Chakradhararao N V H Sanka
201-***-**** **********.*****@*****.***
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