Candidates About

 

Mani Kanta Gutta

Professional Summary:

·         Overall 8years of Software Life Cycle experience in System Analysis, Design, Development, and Implementation, Maintenance, and Production support of Data Warehouse Applications.

·         Extensive experience with Informatica Power Center 10.x,9.x, 8.x, IDQ 9.6.1/9.0.1/8.6 MDM and, Teradata, SQL server, oracle databases

·         Worked on various domains including Healthcare, Insurance and Finance domains.

·         Expertise in working with Informatica, Designer, Work Flow Manager, Work Flow Monitor, Source   Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Gant Chart, Task View, Mappings, Workflows, Sessions, Re-usable Transformations, Shortcuts, Import and Export utilities.

·         Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, Data Vault, Oracle Designer and modeling tools like Erwin and Visio, SCD, Surrogate keys, Normalization/De normalization.

·         Analysis, estimations, Design, Construction, Unit and System Testing and implementation.

·         Extensive Knowledge in designing functional and detailed design documents for data warehouse development

·         Worked on IDQ tools for data profiling, data enrichment and standardization.

·         Experience in development of mappings in IDQ to load the cleansed data into the target table using various IDQ transformations. Experience in data profiling and analyzing the scorecards to design the data model

·         Experience in the integration of various data sources such as Oracle, SQL Server, Sybase, Teradata, DB2, XML Files and Flat files.

·         ImplementedB2B Project – DT/DX (Data Transformation Studio), Data Transformation Accelerator, Data Format Transformation Library, Data Transformation Engine and full integration with Power center

·         Extensive hands on experience using Teradata utilities (SQL, BTEQ, Fast Load, Multi Load, Fast Export, TPT), UNIX in developing tools and system applications, as well as B2B Data Transformation,

·         Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Data Transformation Services etc.

·         Extracted Data from multiple operational sources of loading staging area, Data Warehouse and data marts using CDC/ SCD (Type1/Type2/Type3) loads.

·         Experience in PL/SQL Programming (Stored procedures, Triggers, Packages) using Oracle and have a good knowledge in Sybase.

·         Experience with writing daily batch jobs using UNIX shell scripts, and developing complex UNIX Shell Scripts for automation of ETL.

·         Knowledge in designing Dimensional models for Data Mart and Staging database.

·         Worked in a variety of Business domains which include Finance, Telecom, Health care and Retail industries, including off-shoring model.

·         Expertise in Data Warehousing, Data Migration, Data Integration using Business Intelligence (BI) tools such as Informatica Power Center, Power Exchange CDC, B2B Data Transformation, Informatica Data Quality.

·         Expertise in defining and documenting ETL Process Flow, Job Execution Sequence, Job Scheduling and Alerting Mechanisms using command line utilities.

·         Extensive experience in implementing Error Handling, Auditing and Reconciliation and Balancing Mechanisms in ETL process.

·         Skilled in developing Test Plans, Creating and Executing Test Cases.

·         Worked with Waterfall, Agile for SDLC project lifecycle.

·         Excellent Analytical, Written and Communication skills.

 

 

 

Technical Summary:

 

ETL Tools	Informatica Power Center 10.x./8.x/7.x (Admin Console, Repository Manager, Designer, Workflow Manger, Workflow Monitor), Informatica B2B data exchange, IDQ, MDM, MSSQL Server Integration Services (SSIS).
Data Modeling	Erwin, ER Studio
DBMS	Oracle 11g/10g/9i, MS SQL Server 2008/2005, Microsoft Access, Teradata, ODBC
Programming Languages	SQL, PL/SQL, Unix Shell scripting
Operating Systems	Windows XP/2008/2003/2000, UNIX
Other tools	VISIO, TOAD, CONTROL-M, CITRIX, Autosys (Batch Scheduling)

 

 

Work Experience:

CareFirst, Stamford, CT                                                                                             Jan 2016-Present

Sr.  Informatica Developer

.

Responsibilities:

• Involved in the complete end-to-end flow of SDLC.
• Working closely with business analysts and data analysts to understand and analyze the requirement to come up with robust design and solutions.
• Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems and loading into Staging and Enterprise Data Vault
• Worked on extracting data from the heterogeneous source systems like MS SQL Server, Oracle, and loading into Landing Layer and then to Data Warehouse
• Involved in standardization of Data like of changing a reference data set to a new standard.

·         Data if validated from third party before providing to the internal transformations should be checked for its accuracy (DQ).

·         Led B2B structured and unstructured transformations that included: resolving end user problems, training on B2B transformations and resolving system failures.

●     Created Pre/Post Session/SQL commands in sessions and mappings on the target instance. 

●     Responsible for creating Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.

●     Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.

●     Created Audit, Control and batch tables to monitor load process on user requests.

●     Involved in massive data profiling using IDQ (Analyst tool) prior to data staging.

• Created profiles and score cards for the users using IDQ.
• Created Technical Specification Documents and Solution Design Documents to outline the implementation plans for the requirements.

·         Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.

·         Involved in massive data cleansing prior to data staging from flat files.

·         Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.6 by using various transformations like Expression, Source Qualifier, Filter, Router, Sorter, Aggregator, Update Strategy, Connected and unconnected look up etc.

·         Implemented slowly changing dimensions Type 1,2 using ETL Informatica tool.

• Created Informatica components required to operate Data Quality (Power Center required)
• Designed best practices on Process Sequence, Dictionaries, Data Quality Lifecycles, Naming Convention, and Version Control.
• Created Use-Case Documents to explain and outline data behavior.
• Developed scripts for creating tables, views, synonyms and materialized views in the Datamart.
• Involved in designing and developing logical and physical data models to best suit the requirements.

·         Working with Informatica Developer (IDQ) tool to ensure data quality to the consumers.

·         Used Address validator transformation for validating various customers address from various countries by using SOAP interface

• Converted business requirements into highly efficient, reusable and scalable Informatica ETL processes.
• Created mapping documents to outline source-to-target mappings and explain business-driven transformation rules.
• Data if sourced from database that has valid not null columns should not undergo DQ check for completeness.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases for initial loads.
• Designed mappings to read data from various relational and file source systems such as SQL Server, flat files and XML files.

 

Environment: Informatica Power Center 10.0/9.6, IDQ 9.6, B2BDT/DX 9.6, T-SQL, TOAD, Windows NT/XP, XML file sources, ERWIN 4, MS Visio, Remedy, Sky-bot, Rally

 

HealthCare Partners, Dallas, TX                                                      April 2014-Dec 2015

Sr.  Informatica Data Warehouse Developer

HealthCare Partners, a division of DaVita HealthCare Partners, manages and operates medical groups and affiliated physician networks in California, Nevada, Florida, Arizona, and Texas. The project was aimed at making a data warehousing system out of life insurance customers having different health insurance policies. The data used to come in as flat file, XML, from different databases and loaded into the target database using Informatica Power Center.

Responsibilities:

• Gathered Business requirements from various analysts for sourcing flat files, relational sources from various vendors
• Analyze source data for potential data quality issues and created exception mappings /cleanup scripts to clean up bad source data 
• Created logical and physical model using Erwin for oracle and SQL server target database.
• Worked with DBA’s and Informatics admins for server size estimation and Informatica tool installation.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion.
• Worked extensively on Informatics mappings to load data from various sources to final target tables based on the business logic
• Created complex mappings for the retro activity requirements from client.
• Developed slowly changed dimensions (SCD) Type 1 and Type 2 and created incremental process on daily/weekly basis as per the source system
• Worked with Shortcuts across Shared and Non-Shared Folders
• Worked with static dynamic and persistent caches.
• Migrated Informatica mappings across different environments (Dev/QA/UAT)

·         Designed audit and batch tables for audit tracking and responsible for implementing incremental mapping designs

·         Created informatics mappings using various transformations such as Joiner, Routers, Look ups(connected and unconnected), Sequence generator, sorters, update strategy, Normalizer etc.

·         Created various reusable transformations like Mapplets for populating ETL attributes on the target tables, worklets, sessions, command tasks for notifications

·         Worked extensively on performance tuning informatics mappings, created partitions at the workflow level, worked on oracle stats for performance of mappings.

·         Alignment of data dictionary, schema, mapping extracts.

·         Created pre/post-SQL commands for dropping indexes and re-creating them on the target tables during loads.

·         Developed PL/SQL procedures, functions to facilitate specific requirement.

·         End to End testing of data extracts that includes sanity checks, integration testing if multiple extracts for single system, data/schema testing

·         Co-ordination of setting up secure FTP channel across different source and client servers.

·         Extensively worked on production defects and change requests from users.

·         Created shell scripts in Unix platform for running mappings, workflows, source file management, updating parameter files.

·         Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations

·         Responsible for best practices of Informatica mappings, workflows and automation.

·         Created documents for data flow and ETL process using Informatica mappings to support the project.

 

 

Environment:  Informatica Power Center 9.5, IDQ 9.5, Autosys, Erwin, Oracle 11g, HP ALM, SQL SERVER 2008, XML, T-SQL, Shell Scripts, Oracle, PL-SQL.

 

Deutsche Bank, Jersey City, NJ                                                                 July2013-Mar2014 

Sr. Informatica Developer

 

Deutsche bank provides mobile banking services supporting 90% of banking activities that can be performed using the Internet banking portal. The mobile banking applications include credit card services as well. The mobile app is supported on smart phones like the iPhone, Android and Google voice. The various features available on the mobile app are balances & activity, transfers, bill payment, services and locations. The mobile application, which is downloaded on to the phone, is called the thick client. The user can also type in their mobile browser to be redirected to the device recognized application called thin client where all the features of the mobile thick client are available. The thin client application was developed keeping in mind the mobile phones, which do not support mobile application, downloads.

 

 

Responsibilities:

• Interacted with business team to understand business needs and to gather requirements.
• Prepared requirements document in order to achieve business goals and to meet end user expectations.
• Created Mapping document from Source to stage and Stage to target mapping.
• Involved in creating data models using Erwin.

• Worked with Designer tools like Source Analyzer, Target designer, Mapping designer, Mapplet designer, Transformation Developer.
• Designed Mappings by including the logic of restart.
• Created source and Target Definitions, Reusable transformations, mapplets and worklets.

·         Created Mappings and used transformations like Source Qualifier, Filter, Update Strategy, Lookup, Expression, Router, Joiner, Normalizer, Aggregator-Sequence Generator and Address-Validator.

·         Involved in tuning the mappings, sessions and the Source Qualifier query.

• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Manage all technical aspects of the ETL mapping process with other team members
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.

• Performed Unit testing and created Unix Shell Scripts and provided on call support.
• Preparation of UTP (Unit Test Plan) with all required validations and test cases.

• Created sessions and workflows to run with the logic embedded in the mappings using Power center

• Created a Abbott Teradata standards and best practices document for the EDW and TD DBA teams to follow.
• Involved in the fixing and following-up of the integration issues with Teradata and Informatica ETL tool.
• Involved in the migration from Oracle to Teradata Database using Informatica power center.

·         Actively participated in Scrum Meetings.

·         Worked on PL/SQL, Functions and Procedures.

·         Developed and modified UNIX shell scripts as part of the ETL process.

• Participated in discussions with the team members on Prod issues and resolved.
• Extensively used IDQ which helped in debugging and reducing development time.
• Created formatted addresses that conform regulatory requirements and improved the data quality of addresses using Address validator.
• Using Address-Doctor we validated, parsed, cleansed, standardized global address data.
• Used Match and Consolidator transformation in IDQ which helped in reducing the duplicates.
• Created several session and workflows in IDQ which we deployed in Power Center.
• Using IDQ analyst tools we validated the address and performed exception handling, reporting and monitoring the data using Address Doctor.

·         IDE is used for data profiling over metadata and IDQ for data quality measurement.

• Monitoring the Data Quality, Generating weekly/monthly/yearly statistics reports on production processes – success / failure rates for causal analysis as maintenance part and Enhancing exiting production ETL scripts.
• Managed Scheduling of Tasks to run any time without any operator intervention.
• Leveraged workflow manager for session management, database connection management and scheduling of jobs.

·         Worked with Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation of Informatica Power center.

• Created Unix Shell Scripts to automate sessions and cleansing the source data.
• Implemented pipeline partitioning concepts like Hash-key, Round-Robin, Key-Range, Pass Through techniques in mapping transformations

 

Environment: Informatica Power Center 9.1, IDQ, Oracle 11g, SSIS, Teradata, Fast load, Multiload, Teradata SQL Assistant, TOAD, SQL Server, Erwin, UNIX.

 

 

 

 

 

 

 

TransSys Solutions, Chennai, India                                                                  Sept 2011 –June 2013

Sr. Informatica Developer  

 

        TransSys Solution is a global consulting and technology Service Company focused on helping customers maximize value of their IT investments, by delivering unparalleled solutions and services. TransSys is known for its functional and technical expertise across industries and business functions for Human Capital management’s, Financial, projects manufacturing and supply chain. It has partnership with Oracle so, that high level of support from oracle on new technologies, updates.                  

 

 

 

Responsibilities:

 

• Conducted JAD sessions with business users and SME's for better understanding of the reporting requirements.
• Design and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.

·         Develop high level and detailed level technical and functional documents consisting of Detailed Design Documentation function test specification with use cases and unit test documents

·         Analysis of source systems and work with business analysts to identify study and understand requirements and translate them into ETL code.

·         Handled technical and functional call across the teams.

·         Responsible for the Extraction, Transformation and Loading (ETL) Architecture & Standards implementation

·         Responsible for offshore Code delivery and review process

·         Translated Business specifications into PL/SQL code. Extensively used Explain Plan. Designed, Developed and fine-tuned Oracle Stored Procedures and triggers.

·         Worked in all phases of Data Integration from heterogeneous sources, legacy systems to Target Database.

·         Worked on Informatica Power Center tool – Source Analyzer, Warehouse designer, Mapping and Mapplet Designer, Transformations, Informatica Repository Manager, Informatica Workflow Manager and Workflow Monitor

• Involved in Design Review, code review, test review, and gave valuable suggestions.
• Worked with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Created partitions for parallel processing of data and worked with DBAs to enhance the data load during production.
• Performance tuned Informatica session, for large data files by increasing block size, data cache size, and target-based commit
• Worked on CDC (Change Data Capture) to implement SCD (Slowly Changing Dimensions).
• Involved in writing a procedure to check the up-to-date statistics on tables.
• Used Informatica command task to transfer the files to bridge server to send the file to third party vendor.
• Took part in migration of jobs from UIT to SIT and to UAT.
• Created FTP scripts and Conversion scripts to convert data into flat files to be used for Informatica sessions

 

Environment: Informatica Power Center 8.6.1, Oracle 10g, IDQ, MS SQL Server 2012, SQL, PL/SQL, SQL*Plus, TOAD, Erwin, AIX, Shell Scripts, Unix

 

 

 

Max New York Life Insurance, Hyderabad, India                                      March 2010–Sept 2011

Informatica Developer

The primary objective of the project was to make a data warehousing system out of customers. This process involved gathering the source data globally from its group of companies (in various proprietary formats like RDBMS, Flat files etc.  The data was extracted, transformed and loaded into target database using different mappings and transformations. The EDW warehouse was developed to capture data from different systems and loading to staging area, ODS & Data mart for analysis & reporting purposes.

 

Responsibilities:

·         Involved in Business analysis and requirements gathering.

·         Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.   

<p class="MsoNormal" style="text-align:jus