SUMMARY

• EIGHT years IT experience in developing BI Applications Using Informatica, Oracle, Teradata, SQL Server, UNIX, Shell Scripts, PLSQL, and Sybase.
• Diverse experience in Healthcare and Banking Domains
• Presently, working for Blue Cross and Blue shield of Minnesota to implement the ICD - 10 project which includes remediation of 50+ applications and extracts within Warehouse.
• Honored with SCOPE (Special Contribution to Project Excellence), Tech Whiz, We applaud award for outstanding performance.
• High working experience with Informatica PowerCenter transformations like Joiner, Router, Update Strategy, connected and unconnected lookups, Expression, Sorter, Filter, Union, Normalizer, etc. Also worked with varied sources and targets like relational tables, flat files, XML Editor, VSAM files, XLS etc. Aware of the basic administrative tasks with Integration Service, Repository Manager
• Good hands on for BTEQ, MLOAD and FLOAD Teradata scripts
• Excellent skills in working with UNIX shell scripts. Developed shell scripts for feed file integrity checks, FTP activities and commands like ftp, scp, find, grep, pipe, cut, redirection and utilities like Awk and Sed
• Implemented the innovative tasks to minimize the manual efforts in projects. For example, to generate the ICD-10 TEST data, complex UNIX shell scripts to scan the impact of table(s) and column(s) in Informatica Repository, generic FTP script for all the submission extracts.
• Over ONE years of experience in dimensional modeling techniques like Star and Snowflake schemas using PowerDesigner.
• Extensive experience with CA7,Control M and Autosys job scheduler
• Designed and developed EDW, DM and Data Quality Systems for prestigious clients Confidential Inc, BCBS.
• Strong in dimensional modeling such as star schema and snow flake dimensional models, Logical and physical data modeling and 3NF data modeling.
• Strong in performance tuning of complex SQL queries
• Involved in detailed Analysis, design, development, maintenance and upgrading systems to support business operations.
• Created and Used Workflow Variables, Session Parameters and Mapping Parameters
• Experience in Creating Tables, Views, Indexes, Synonyms, Constraints, Procedures, Shell Scripting, FTP and Remote copy
• Expert in Informatica PC and PA Repository Metadata Queries
• Strong in Database concepts like SQL, PL/SQL, Procedures, Functions, Triggers, Advanced PL/SQL programming, Data warehouse and Dimensional Modeling concepts
• Very flexible and can work independently as well as in a team environment
• Involved in Preparing HLD,LLD, Test cases, Test Plan, Cut over Plan and ETL Estimation
• Helped Infra in migrate code into different environments
• Worked on different Sources such as Oracle, Teradata, Sybase, Power Exchange VSAM Files, SQL Server, Web Service, MQ server and Flat Files
• Identified and tracked the SCD tables
• Created Procedure For Purging Data and Generating Files Dynamically
• Created Package to Populate the Dates in Date Dimensions Tables
• Experienced in Performance and tuning of the ETL and complex SQL queries
• Experience with Level 2 production support, involving resolution of issues escalated to development team
• Shares learning and coaching experience through knowledge transfers between peers

TECHNICAL SKILLS

ETL: Informatica Power Center 9.5/9.1/8.5.1/7. x/6.x, Informatica Power Connect & Exchange for Mainframe, Informatica.

RDBMS: Teradata, Oracle 11i/10g/9.x/8.x,MS SQL Server 2008, Sybase.

Design/Application: PowerDesigner, Microsoft Visio (Visio Soft Diagram), Autosys, Control-M, WLM, Query man, SQL Developer.

Languages/Scripting: UNIX, PL/ SQL, UNIX Shell Scripting.

Data Modeling: Dimensional Data Modeling (Star Schema, Snow-Flake, FACT-Dimensions), Conceptual Physical and Logical Data Modeling using PowerDesigner.

Operating System: Sun Solaris, UNIX/LINUX, MS-DOS, Windows 2008/2007/ NT/2000/XP.

Other Tools: Power Designer, SQL Developer,WINSCP, PUTTY, JIRA Quality Center, Clear Case, Build Forge, IT2B, Rational Clear Case for defect tracker, Teradata SQL Assistance, Rapid SQL.

PROFESSIONAL EXPERIENCE

Confidential, Eagan, MN

Sr. Informatica/Teradata Developer

Responsibilities:

• Working as Technical Lead and Data Modeler for ICD-10 projects implementation for Enterprise Data Information Management (a.k.a EDIM).
• Implemented the ICD-10 implementation for Inbound assets (STAR Finalized Claims, Pended Claims, Accepted Claims and CCS Claims successfully loaded to Integrated Data ware House a.k.a IDW)
• Worked to make outbound submission assets with ICD-10 compliance for various vendors like VIPS, TriZetto (pricing workflow, DTA Groper and many more.
• Implemented the LEAP CE and LEAP i10 product in IDW. These products hold the relationship between ICD-9 and ICd-10 diagnosis/surgical procedure codes.
• Performing the data analysis, calculating the impact analysis of ICD-10 changes in all the EDIM applications.
• Designed and developed the Informatica Impact Analyzer tool to find the ICD-10 impacts in all the applications.
• Designed the developed the scripts to create the ICD-10 TEST data in lower environments.
• Working with various users to capture the requirement in form of user stories,
• Participated to calculate the Level of efforts for ICD-10 impacted assets.
• Responsible for data models changes (with PowerDesigner tool) and mapping data sheet per asset requirement.
• Creating the Technical Specification Design documents per business requirement for each asset.
• Developing Informatica mappings and workflows for extracts and feeds. Data is extracted through mappings from different sources like Relational database tables, VSAM files, etc.
• Designed ETL processes for optimal performance.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings & implement data warehouse
• Created Parameter files to pass database connections, parameter entries for source and target
• Converted existing SQL Scripts logic into ETL Mappings for Aggregate Tables and MV
• Worked extensively on Informatica partitioning when dealing with huge volumes of data and also partitioned the tables. Used Pass Through, Round Robin and Hash portioning.
• Worked on command tasks, event wait tasks, event raise tasks, timer tasks to implement business logic
• Implemented Target Load Plan and Pre Session and Post Session Scripts
• Created test cases and test scripts to validate data.
• Review the detail level design and ensure that the IT standards are followed
• Created complex Informatica mappings, mapplets and re-usable transformations and prepared various mappings to load the data into different stages like landing, staging and target tables.
• Best use of METADATA in Informatica to reduce the manual effort
• Tuned the performance of complex Informatica mappings and database.
• Worked with cross functional teams to resolve the issues.
• Created slowly changing dimensions & Fact tables to meet the business requirements.
• Used the debugger in Informatica to test the mapping and fix the mappings
• Worked on various lookup caches like static, dynamic and persistent
• Created the ETL best practices and mentored other team members.
• Scheduling of Informatica Jobs, Infa code Migration
• Used various transformations including Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy for designing and Optimizing.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Performed data validations.
• Created deployment documents, Informatica install instructions, etc.
• Involved in the defect analysis for UAT environment along with users to understand the data and to make any modifications to code.
• Performed root cause analysis and resolved complex issues.
• Created SQL Queries to validate the data in both source and target databases.
• Prepared the recovery process in case of workflow failure due to database issues or network issues
• Conduct a thorough code review and ensure that the outcome is in line with the objective and all the processes and standards are followed.
• Warranty support and Knowledge Transfer of each asset after production implementation.

Environment: Informatica Power Center 9.5, Oracle 11g, Teradata 14, Power Exchange 9.0.1, Main Frame, Windows, UNIX.

Confidential

Sr. Informatica/Teradata Developer

Responsibilities:

• Analyzing the requirements and making functional specification by discussing with business user groups and translate the Business Requirements and documented source-to-target mappings and ETL specifications
• Design and developed complex UNIX scripts for WTX tool to parse the HL7 format files.
• Design and developed the complex Informatica mappings to load the data to EDWARD data warehouse.
• Generate the Data Exchange extracts per vendor specification out of EDWARD data warehouse.
• Extensively used the BTEQ scripts, MLOAD and FLOAD scripts to load the huge volume of data.
• Lead the development team and co-ordinate the projects among the developers
• Designed ETL processes for optimal performance.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings & implement data warehouse
• Created Parameter files to pass database connections, parameter entries for source and target
• Worked extensively on Informatica partitioning when dealing with huge volumes of data and also partitioned the tables. Used Pass Through, Round Robin and Hash portioning.
• Worked on command tasks, event wait tasks, event raise tasks, timer tasks to implement business logic
• Implemented Target Load Plan and Pre Session and Post Session Scripts
• Created test cases and test scripts to validate data.
• Review the detail level design and ensure that the IT standards are followed
• Created complex Informatica mappings, re-usable transformations and prepared various mappings to load the data into different stages like landing, staging and target tables.
• Tuned the performance of complex Informatica mappings, SQL queries and database.
• Worked with cross functional teams to resolve the issues.
• Used the debugger in Informatica to test the mapping and fix the mappings
• Worked on various lookup caches like static, dynamic and persistent
• Created the ETL best practices and mentored other team members.
• Scheduling of Informatica Jobs, Infa code Migration
• Used various transformations including Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy for designing and Optimizing.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Performed data validations.
• Involved in the defect analysis for UAT environment along with users to understand the data and to make any modifications to code.
• Performed root cause analysis and resolved complex issues.
• Created SQL Queries to validate the data in both source and target databases.
• Prepared the recovery process in case of workflow failure due to database issues or network issues
• Conduct a thorough code review and ensure that the outcome is in line with the objective and all the processes and standards are followed.

Environment: Informatica, Teradata, UNIX shell scripting, WLM.

Confidential

IT Developer

Responsibilities:

• Involved in all phases of the project life cycle including requirement gathering, analysis, design, coding, testing and implementation.
• Interpreted and comprehend business/data requirements from upstream processes
• Documented technical requirement specifications and detailed designs for ETL processes of moderate and high complexity.
• Created and documented source-to-target mappings and ETL specifications.
• Created complex Informatica mappings, mapplets and re-usable transformations and prepared various mappings to load the data into different stages like landing, staging and target tables.
• Created scripts for FTPing files, data manipulation and validations.
• Designed and performed all activities related to migration of ETL components between environments during development and deployment (E.g. Dev to SIT, SIT to UAT and UAT to PROD repositories).
• Checked for missing data, negatives and consistency and completed field-by-field data verifications for source and target data consistency.
• Created slowly changing dimensions tables to meet the business requirements.
• Used various transformations including Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and Optimizing. Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Prepared the error handling document to maintain the error handling process and created test cases for the mappings developed then created the integration testing document.
• Involved in the defect analysis call for UAT environment along with users
• Developed workflows using Task Developer, Worklet Designer, and Workflow Designer in Workflow manager and monitored the results using Workflow Monitor.
• Prepared the UNIX Shell Scripts to process the file uploads, one of the SOURCE for the data that process the uploads into different stages (Landing, Staging and Target tables)
• Worked on the AUTOSYS scheduling tool and prepared AUTOSYS JIL code for the new UNIX shell scripts that are created as a part of business requirements.
• Worked in production support of application, involving resolution of issues and implementing to production.

Environment: Informatica 7.3, Sybase, UNIX, JIRA.

Confidential

QA Tester

Responsibilities:

• Involved to understand the requirement of the product.
• Preparation of technical specification document, Test cases and Test result summary.
• Execution of Test cases.
• Preparing the matrix to keep track of defects.

Environment: Manual Testing of the product.