Highlights -

• Over 9 years of IT experiences in Data Warehousing ETL Requirements Gathering Analysis Design Development Integration Implementation and Testing using Informatica PowerCenter/ Power Exchange 9.5.1HF4 to 7.1 for Health Care Insurance Banking IT and Wireless Industry in different Methodologies.
• Experienced in Migration of codes from Repository to Repository wrote up Technical/Functional Mapping specification Documents for each Mapping along with unit testing for future development.
• Proficient in Designing the Automation Process of Workflows and configuring/scheduling the Workflows for load frequencies. Skilled to Develop Test Tune and Debug the Mappings Sessions.
• Experienced to Profile Analysis Standardize Clean Integrate Score Carding Marge Match Reference Data from various source systems using Informatica Data Quality IDQ Toolkits.
• Worked with Address Doctor different algorithms eg. Biogram Jaro/Edit distance Reverse algorithm in IDQ.
• Proficient in interacting with the business users. Pioneered in different load strategies from heterogeneous source systems to target. Successfully implemented SCD Type1/Type2 load Capture Data Changes and maintain the Data history. Monitored the system during data loading.
• Experienced to identify the Bottlenecks of data load and Tuned the Bottlenecks for better performance.
• Extensive experiences to create Logical Physical Data Modeling on Relational OLTP Dimensional Data Modeling OLAP on Star schema for Fact Dimension tables using CA ERwin.
• Experienced in Informatica Architecture/Administration for installing and configuring Repository Web Hub services for configuration of Domain/Gateway Services Authentication Configuration Service Management etc using the Administration Consol Repository Manager tools.
• Excellent to write the Stored Procedures Triggers Indexes Functions by PL/SQL SQL Scripts. Developed various reports dash board using MicroStrategy reporting tools.
• Experienced as Database Administration in Oracle 9i Flashback RMAN to Recover the data Database Design Enterprise level Backup/ Recovery procedure Performance Tuning Table Partitioning Database Architecture Monitoring and Database Migration SQL Developer.
• Excellent in communication and interpersonal skills vivid analytical ability to solve the problems.
• Team player motivated and dynamic with excellent oral and written communication skills.

• Oracle Database 9i Oracle Certified professional OCP .

Technologies -

Professional Experiences

Sr. ETL Developer.

Cconfidential

Confidential the largest healthcare industry in Los Angeles is implementing the new EDW over the old EDW in a multiple phases to acquire more accurate cost information. Previously the EDW were largely based on legacy application and annually the cost ratios were updated and then calculated for each visit summary during the DW build cycle. But there were exceptions to the ratios based upon specific CDMs and/or new CDMs which might not be discovered in a timely fashion leading to inaccurate costing analysis.

Responsibilities -

• Participated in daily/weekly meetings monitored the work progresses of teams and proposed ETL strategies.
• Based on requirements designed and coded new/old Mappings and validated/debugged old Mappings tested Workflows Sessions and figured out the better technical solutions on old new Mappings for Source/Target compatibility. Identified the bottlenecks in old Mappings and tuned them for better Performance.
• Migrated the codes from Prod to Dev Dev to Test Test to Prod environment and wrote up the Team Based Development technical documents to smooth transfer of project. Prepared ETL technical Mapping documents along with test cases for each Mapping for future developments to maintain SDLC.
• Worked on various complex SCD Type1/Type 2 Mappings in different layers to maintain the data history. Used Mappings Sessions Variables/Parameters Parameters files Reusable Transformations Mapplets to maintain the life cycle development and fixed other s Mappings.
• For each Mapping prepared effective Unit Integration and System test cases for various stages to capture the data discrepancies/inaccuracies to ensure the successful execution of accurate data loading.
• Worked on Informatica PowerCenter 9.5.1HF4 Tools- Repository Manager Informatica Designer Workflow Manager/Monitor and carefully monitored the system during data loading.
• Designed the automation process of Sessions Workflows scheduled the Workflows created Worklets command email assignment control event wait/raise conditional flows etc and configured them according to business logics requirements to load data from different Sources to Targets.
• Created Pre Post-Sessions UNIX Scripts to merge the flat files and to create delete temporary files change the file name to reflect the file generated date etc.
• Used Debugger to validate the Mappings and gained troubleshooting information about the data and error conditions. Involved in fixing the invalid Mappings. Wrote various Functions Triggers and Stored Procedures to drop re-create the indexes and to solve the complex calculations.

Environment - Informatica PowerCenter 9.5.1 HF4 Oracle 11g/10g SQL PL/SQL TOAD 9.5 Putty WinSCP UNIX Shell Scripting MS-SQL Server 2005 SharePoint HIPPA IIR Web Services WSDL MySQL.

Sr. ETL / IDQ Developer.

Confidential

Confidential the largest health care industry maintains more than 4000 hospital s data and provides the IT support. Currently the company is moving forward from ICD-9 to ICD-10 standard to consolidate the EDW onto one platform from various disparate EHR platforms in order to prepare for the mandatory CMS ICD-10 remediation. Project includes the development and testing of data integration into the new Enterprise Data Warehouse EDW .

Responsibilities -

• Coordinated in daily team meetings technical code review meetings and interacted with business people for better technical solutions and proposed ETL strategy based on Agile Methodologies.
• Worked on Informatica PowerCenter 9.1.0-9.5.1HF2 Tools- Repository Manager Informatica Designer Workflow Manager/Monitor Informatica Data Quality IDQ Developer/Analyst Toolkits.
• Validated debugged old Mappings tested Workflows Sessions and figured out the better technical solutions on old new Mappings for Source/Target compatibility due to version changes. Identified the Bottlenecks in old/new Mappings and tuned them for better Performance.
• Developed various complex SCD Type1/Type 2 Mappings to maintain the data history in different layers. Used Mapping Sessions Variables/Parameters Parameters files Reusable Transformations Mapplets to maintain the life cycle development. Designed and coded of major change requests as per new requirements.
• Worked on Automation process of Sessions Workflows scheduled the Workflows created Worklets command email assignment control event wait/raise conditional flows etc and configured them according to business logics requirements to load data from different Sources to Targets.
• Worked on Team Based development for Migrating the codes from Development to Test Test to Production environment and wrote up the Team Based Development technical documents to smooth transfer of project. Prepared ETL technical Mapping documents with test cases for each Mapping for future developments.
• Prepared effective Unit Integration and System test cases of Mappings for various stages to capture the data discrepancies/inaccuracies to ensure the successful execution of accurate data loading.
• Created Pre Post-Sessions UNIX Scripts Functions Triggers and Stored Procedures to drop re-create the indexes and to solve the complex calculations on data.
• Worked with Informatica Data Quality IDQ 9.5.1 Developer/Analyst Tools to remove the noise of data using different transformations like Standardization Merge and Match Case Conversion Consolidation Parser Labeler Address Validation Key Generator Lookup Decision etc.
• Created Reference/Master data for profiling using IDQ Analyst tools. Used the Address Doctor Geo-coding table to validate the address and performed exception handling reporting and monitoring the data.
• Built the Physical Data Objects and developed various mapping mapplets/rules using the Informatica Data Quality IDQ based on requirements to profile validate and cleanse the data. Identified and eliminated duplicate datasets and performed Columns Primary Key Foreign Key profiling using IDQ 9.5.1. for MDM.
• Responsible to manage data coming from different sources like Hadoop CSV Flat file MS-SQL Oracle etc. loading and transforming of large sets of structured semi structured and unstructured data.
• Worked on Web Services WSDL to extract data from different Web Links and created Mappings load the data into target tables. Used WSDL link to represent the data in MS-Word MS-Excel in Ads-on menu.

Informatica Power Center 9.1.0-9.5.1HF2 Oracle 11g PL/SQL Toad 9.5 Dynamic SQL UNIX Shell Scripting SharePoint HIPPA Embercado IIR Web Services WSDL MDM MySQL.

Sr. ETL / IDQ Informatica Developer.

Confidential

Confidential the country s largest health care industry planned to build an EDW in a multiple phase to maintain their historical data. This is a challenge for BCBS because the data is coming from different source systems is refreshing with two/three weeks delay. It is due to large volume of data also due to processing time mainly due to large processes is running behind the scene. The company has planned to improve EDW and to get the most recent data Real-Time Data . All the data coming from different systems needs to be integrated transformed migrated to the target database.

Responsibilities -

• Participated in team meetings and proposed ETL strategy based on Agile Methodology.
• Worked on Informatica PowerCenter 8.6.1-9.1.0.HF1 Tools- Repository Manager Informatica Designer Workflow Manager/ Monitor Informatica Data Quality IDQ Developer and Analyst Toolkits.
• Based on Subject Areas provided concrete solutions for complex/critical Mappings and created various complex Mappings in different layers. Successfully implemented SCD Type1/ Type 2 for insert capture data changes and delete operation to maintain the data history. Created Mapping Sessions Variables/Parameters Parameters files Mapplets Reusable Transformations to reuse during life cycle development.
• Created batches based on Subject Areas for different layers to run Workflows/Worklets and Sessions scheduled the Workflows for load frequencies and configured them to load data.
• Involved in debugging the invalid Mappings. Tasted Mappings Sessions and Workflows to figure out the Bottlenecks and tuned them for better performance. Built Unit test queries to test data accuracy.
• Migrated the codes from Development to Test Test to Production. Created effective Unit System Integration test of data on different layers to capture the data discrepancies/inaccuracies to ensure the successful execution of accurate data loading. Created technical documentations for each Mapping for future developments.
• Designed and coded change request as per the new requirements. Created Pre Post-Sessions UNIX Scripts Stored Procedures to drop re-create the indexes and to solve the complex calculation.
• Worked with Informatica Data Quality IDQ 9.5.1 Developer/Analyst Tools to remove the noise of data using different transformations like Standardization Merge and Match Case Conversion Consolidation Parser Labeler Address Validation Key Generator Lookup Decision etc.
• Created Reference/Master data for profiling using IDQ Analyst tools. Used the Address Doctor Geo-coding table to validate the address and performed exception handling reporting and monitoring the data.
• Built the Physical Data Objects and developed various mapping mapplets/rules using the Informatica Data Quality IDQ based on requirements to profile validate and cleanse the data. Identified and eliminated duplicate datasets and performed Columns Primary Key Foreign Key profiling using IDQ 9.5.1. for the MDM.

Environments -

Informatica Power Center 9.1.0/8.6.1 Teradata Oracle 11g PL/SQL UNIX Toad 9.5 Dynamic SQL Shell Scripting. Web Services WSDL SQL Navigator ILM IDQ 9.5.1 IIR BTEQ MDM Hadoop.

Sr. ETL Developer.

Confidential Inc the world s largest entertainment company took a Enterprise Data Warehouse EDW project to maintain their large volume of data. The project aim was mainly the operational data coming from different source systems design the data model clean transform load them to an integrated repository database according to business requirements to develop analytical reporting system.

Responsibilities -

Worked on data Integration from different sources using Informatica PowerCenter/Power Exchange 8.6.1/9.1 Tools- Repository Manager Informatica Designer Workflow Manager/ Monitor and Upgraded the system from 8.6.1 to 9.1. Participated in team meetings and proposed ETL strategies.

• Developed various complex Mappings and successfully implemented SCD Type1/Type 2 to keep the data history changes. Designed and coded change request as per the new requirements.
• Migrated the codes from Repository to Repository. Used debugger to validate the Mappings and gained troubleshooting information about the data and error conditions. Involved in fixing the invalid Mappings. Tested the Mappings Sessions Workflows and Worklets. Wrote the test queries to check if the data was loading to dimension tables and fact tables properly.
• Created and reviewed the logical and physical data model for the fact and dimension tables according to business requirements to be used for EDW. Created DDL scripts to implement Data Model changes. Created ERwin reports in HTML RTF format depending upon the requirements published Data Model in Model Mart co-coordinated with DBAs to apply the data model changes.
• Created effective Unit System and Integration Test cases for various stages of ETL to capture the data discrepancies and inaccuracies to ensure the successful execution of accurate data loading.

Wrote Functions Stored Procedures to drop re-create the indexes and to solve the complex calculation as needed. Tested and maintained data integrity among various Sources and Targets. Worked on Performance Tuning to tune the data loading by identifying the Bottlenecks in Sources Targets Mappings Transformations Sessions Database Network then fixing them. Involved in providing Informatica Technical Support to the team members as well as the business.

Environments -

Informatica PowerCenter/Power Exchange 8.6.1/9.1 Teradata Oracle 10g MS-Server 2008 PL/SQL ERwin 8.2 Toad 9.5 Putty WinSCP UNIX SOAP SAP COBOL Web Services WSDL BTEQ MySQL.

ETL Developer/ Informatica Data Modeler.

Confidential is the country s largest Mobile Company provides the services to almost 50 million people. The Company planned to take multiple phase projects to maintain call records history. The purpose of this project was to design the DWH services to keep call record history of customers and information pertaining to customer demographics transaction behavior invalid SIM analysis of customer satisfactions.

Responsibility -

• Used Informatica 8.6.1 to Extract Transform and Load data from Oracle MS-SQL Server 2000 CSV and flat files to Oracle Server and Migrated the Informatica from 7.1 to 8.6.1.
• Created several complex Mappings Mapping Parameters/Variables mapplets Parameters files successfully implemented the SCD Type1/Type2 to load the data to maintain the history of data.
• Migrated the codes from Repository to Repository. Created and Monitored Workflows/Sessions using Informatica Workflow Manager/Monitor to load data from different Sources to Target.
• Tested all applications to smooth flow of data. Scheduled and ran the extraction load processes.
• Maintained Metadata naming and Warehouse standards for future application development.
• Involved in writing Functions Triggers and Stored Procedures in PL/SQL as per the requirements.

Extensively worked on Performance Tuning to tune the data load by identifying the Bottlenecks in Sources Targets Mappings Transformations Sessions Database and Network.

• Worked on data conversion integration load verification. Performed Unit System Integration. Tested Mappings in various stages of ETL to capture the data discrepancies/inaccuracies to ensure the successful execution of accurate data loading and used debugger to troubleshoot logical errors.
• Created and reviewed the logical and physical model for the fact and dimension tables from the source systems according to business requirements to be used for EDW. Created DDL scripts for implementing Data Modeling changes. Created ERwin reports in HTML RTF format depending upon the requirement published Data model in model mart co-coordinated with DBAs to apply the data model changes.
• Provided Informatica technical support to the team members as well as the business.

Environments -

Informatica Power Center 8.6.1 Oracle 9i MS-SQL Server 2005 PL/SQL UNIX ERwin 7.2 Toad 9.5. MS-DOS SIF SQL Navigator ILM Putty WinSCP Unix Shell Scripting.

ETL Developer.

Confidential is a country s largest Heath Care Company providing a steady flow of innovative services/ medicines that improve health well being of people around the country. The project focused on gathering Customers Insurance to customers Products Orders etc and loading that data into EDW.

Responsibilities -

• Participated in team meeting to design develop implement the project proposed ETL strategies.
• Developed several complex Mappings and successfully implemented SCD Type1/Type 2 to keep the history changes. Worked with Variables/Parameters Parameter Files Workflows Sessions and configured them for smooth transfer of data. Extensively worked on identifying the Bottlenecks and resolved them to accelerate the performance of loading the data. Performed tuning of by Text-Enhance >SQL queries for speedy extraction of data and troubleshooted the long running Sessions and fixed the issues.
• Involved in the development of Stored Procedures Functions Views Materialized Views and Triggers to drop re-create the indexes and to process business data according to requirements.
• Worked with the testing team to resolve bugs related to ETL Mappings created effective Test Cases Unit Coding and Integration Testing for various stages of ETL to capture the data discrepancies and inaccuracies to ensure the successful execution of accurate data loading.
• Created Objects into repository by merging and importing into Micro Strategy Repositories.
• Reported to the senior Micro Strategy consultant about weekly and monthly project status.
• Designed and developed ad hoc queries analytics and dashboards through Micro Strategy solutions.
• Created the weekly project status reports tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
• Involved in meetings with production team for issues related to deployment maintenance future enhancements backup and crisis management of DW.

Environment - Informatica Power Center 7.1 ERwin 4.0 CDC Windows 2000 Oracle 9i/ PL/SQL TOAD. Jaspersoft Micro Strategy Putty WinSCP UNIX Shell Scripting.

ETL Developer Informatica

This Data warehouse Application was built for the Credit Cards Division and was aimed at building a data mart for Sales analysis which is called Sales Performance data mart . The project involves providing online credit and liability information to customers and management. The project aimed at facilitating faster credit processing for the customer and also helps in assessing and containing the credit risk for the bank. The project has interface with a number of subsystems which provide it real time information to provide the global picture of a customer. This ETL initiative gets data feeds from various source systems across the globe.

Responsibilities -

• Designed developed ETL processes based on business rules job control mechanism using Informatica Power Center 7.1. Re-engineered on existing Mappings to support new/changing business requirements.
• Migrated the codes from Repository to Repository. Worked extensively on complex standard non-reusable Mappings and successfully implemented SCD Type1/Type 2 to keep the history changes.
• Used Workflow Monitor to monitor the jobs reviewed Sessions/workflow logs that were generated for each Sessions to resolve issues used Informatica debugger to identify issues in Mapping execution.
• Monitored production jobs on a daily basis and worked on issues relating to the job failure and restarted failed jobs after correcting the errors. Performed administration jobs like user privileges migrations starting stopping pmrep/pmserver. Backup and restore repository service.
• Used Mapping Sessions Variables/Parameters and Parameter Files to support change data capture and automate workflow execution process to provide 24x7 available data processing.
• Involved in writing UNIX Shell scripts Pre/Post Sessions commands for the Sessions wrote Shell scripts to kickoff workflows unscheduled workflows get status of workflows.
• Tuned SQL Statements Mappings Sources Targets Transformations Sessions Database Network for the bottlenecks used Informatica parallelism options to speed up data loading to target.
• Developed PL/SQL Procedures to process business logics in the database and use them as a Stored Procedure Transformation. Created various Functions Triggers and Views to resolve the business needs.

Environment - Informatica PowerCenter 7.1 Oracle 9i SQL Server 2000 Flat Files CSV files PL/SQL UNIX Shell Scripting TOAD. Putty WinSCP.

Database Administrator Oracle .

Confidential is involved in the business of multiple platforms. To run the business smoothly the company took the decision to maintain their database without any interruptions. The purpose of this project was to maintain the database integrity 24/7 hour support and keep the backup of the data.

Responsibility -

• Created several databases documented migration process monitors and load scripts. Altered modified and created tables views and sequences. Created Oracle instances with appropriate initialization Parameters as requested. Took RMAN backup of the data in Tape and Disk.
• Created users and assigned them privileges and roles as requested by application developers. Controlled the Database User Maintenance Access Control Set up Oracle Data Guard Tape Management Procedure Creation and Schema Management ensuring Database Security.
• Exported data from old systems and imported them into new databases using expdp and impdp. Customized Export/Import for large scale data transfer. Created and maintained of Recovery Catalog Created Materialized Views Indexes rebuild Indexes and table partition to tune the databases.
• Modified table spaces and object storage as needed. Managed archives/redo logs Creating control file log file Recovery the data figured out the bottlenecks for Performance Tuning Activities.
• Developed system program to automate database backup monitoring and other DBA functions.
• Automated routine DBA tasks of database monitoring by Shell / SQL scripts was responsible for proactive management. Cloning of the database with the help of EXPORT/IMPORT and RMAN.

Environments -

Oracle 10g Data-Guard Application Server Tuning Flashback RMAN OEM Linux Data Warehousing Partitioning etc.