SUMMARY

• Over 9 years overall IT exposure with systems design, development, integrating, testing support and production support over Data warehousing… which involves ETL/ Reports development, Data modeling.
• Experience in Data modeling, data warehouse, data mart, ETL design development.
• Extensively worked on Informatica until 10.2 version.
• Experience in data warehousing and data mart, extraction, transformation and loading (ETL) from different data sources like Oracle, XML, and Flat files into Data Warehouse.
• Involved in teh full development lifecycle from requirements gathering through development and support using Informatica Power Center, Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor.
• Expertise in using informatica transformations (Active and Passive) to read teh unstructured data to transform and load.
• Experienced in resolving informatica performance by debugging through session logs and transformations.
• Created flat files with report counts to send out to end users after each dry run through informatica post session commands.
• Proficient in understanding ETL and Database relationship and constantly upgrading to ORALCE Functions which makes easy and performance halps in ETL.
• Strong skills in Oracle SQL programming which includesSQL, PL/SQL Packages, Stored Procedures, Functions, Cursors, Views.
• Extensive experience in identifying performance issues, debugging and Performance Tuning using SQL auto trace, explain plan, Indexing and hints.
• Involved in writing UNIX shell scripts to automate batch schedule process using PMCMD commands.
• Created Various reports through Cognos to monitor teh Data load failures, data failed in cleaning process, data processed summary, data matched and converted for each Dry run.
• Automated Informatica mappings through CA7, Opcon batch schedulers.
• Experienced in providing technical support, troubleshooting, report design and monitoring of system usage.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center, IDQ (Data Quality)

Databases: Oracle /10g/11i.

Reporting Tools: Cognos and Crystal reports

Job scheduling Tools: Opcon, CA7

Programming: SQL, PL/SQL, Unix Shell, Java

Environment: Windows XP/2007, Win NT, UNIX MS - DOS

PROFESSIONAL EXPERIENCE

Confidential, Indiana

DC Delivery Specialist/ Data Warehouse Lead/ Specialist

Responsibilities:

• Involved from day one in JAD sessions,gatheirdthe requirements from teh client, analyzed and requested data extracts according to teh application data model.
• Proficient in understandingapplicationbusiness requirements and translating specs into technical requirements. Staged (legacy IBM cobol files) into new RDBMS Database.
• Normalized data fields to meet teh business requirements and specifications to build a data marts for various source files into a metadata.
• Used Informatica various transformation like Expression, Filter, Rank transformations and IDQ (Informatica Data Quality) in data cleansing process.
• Involved in IDQ developer tool in cleasing legacy unstructured data through labeler and Standardizer transformations.
• Normalized data fields to meet teh business requirements and specifications to build a data marts for various source files into a metadata.
• Created reusable User defined functions and mapplets where rules were defined/published as reusable in different mappings.
• Created canonical/Intermediate tables to identify purified data through Informatica.
• Experienced in extracting, transforming and loading teh data according to teh business requirements of teh application by using Informatica various transformations likeSource Qualifier, Expression, Connected and UnConnected Lookups, Normalizer, Sorter, Rank, Aggregator, Union, Joiner, Update Strategy, Filter, Sequence Generator, Stored Procedure, Java,XML transformations.
• Used XML transformation as SQ to sync PROD with PRE PROD master clinet index data.
• Used information various Pre and Post Unix commands to get teh used defined alerts.
• Used various ORACLE functions (lead. lag) to transform data according to application standards.
• Created PL/SQL procedure for archiving Staged data after loaded into workal portal in incremental data load process in regards of Performance.
• Developed serval summary reports through Cognos in terms of each Dry run statistics, retrieving informatica from metadata.
• Involved in writingscripts in code migration process.
• Involved in creating a script to update database sequences to Informatica sequences through PMCMD command.
• Have hands of experience in creating new repositories like DEV, SIT from Informatica Administrator console.
• Used CA7 batch scheduler to automate Informatica jobs, according to application and Relational database flow.
• Lead and monitor teh team in monthly scheduled dry runs and provide solutions for failed jobs.
• Perform code reviews and provide comments.
• Train peer developers and present them an overview of teh project process.
• Involved in teh documentation of various modules of teh application for later reference.
• Presenting teh exception data, data discrepancies between legacy and new systems to teh client and acquiring teh required information for fixing teh issues.
• Involved in assigning teh defects to teh team members and assisting them with solutions as needed.

Environment: Informatica Power Center 10.2/ 9.6 hotfix/ 9.5, Power Exchange, Oracle 11g, and XML files, SQL Developer, Flat Files, CA 7, Unix, and Cognos.

Confidential, Santa Fe, NM

Datawarehouse Consultant

Responsibilities:

• Worked closely to understand business and transformation process.
• UsedNormalizertransformation to read cobol flat files into Oracle database designed tables.
• TEMPEffectively used Informatica parameter files for defining mapping variables dynamically, used FTP connections through Informatica to securely read flat files and load into new system database.
• Handled high-volume data, Performance Tuning and troubleshooting long running jobs by analyzing session logs.
• Worked with Connected and Unconnected lookups to call Stored Procedure for pre-& post load sessions.
• Good noledge in areas like Product, Individuals, Demographics, Benefits, Accounts and Summary details.
• ImplementedSCDtype-2 andSCDtype-3 load strategy for teh Data Warehouse.
• Developed test cases for validating teh ETL processes and navigating through Application after dry run to ensure Application is up and number.
• Gatheird data necessary for conversion. Identified gaps or flaws where teh logic might fail and report to teh Source System for correction.
• Lead in implementing data in production and involved in daily and monthly run and batch jobs through opcon.
• Lead in verifying teh data after teh daily run and sending out detail reports to teh client/end users.
• Interact directly with teh Client ingathering requirements for reports and analyzing data according to reporting tool.
• UsedSQLextensively in command objects of Cognos reports.
• Used Cognos reports for validating legacy system data and sending out reports to clients.
• Createnested, conditional subgroupsandformatting features inreports.
• CreateSub reportsretrieved from teh main report to implement teh business logic.
• Used various Aggregator function list teh benefits amounts issued by state to each individual monthly and annually.
• Involved in creating UNIX scripts to Migrate reports to higher environments.
• Involved in validating Quarter, Mid and Yearly reports and validating them.
• Involved in unit testing and preparing test cases.

Environment: Informatica Power Center 9, Power Exchange 9.x, Oracle 11g, XML files, Oracle Express, SQL Developer, Flat Files, opcon, UNIX, Cognos.

Confidential

SQL Developer

Responsibilities:

• Gatheird teh requirements and prepared design documents.
• Written various SQL queries and subqueries to retrieve data from database according to application front end design.
• Created auto generated insert script to insert new facility information into Database.
• Created SQL query to list out working hours of each facility.
• Created different database views.
• Involved in coding teh logic using C#.
• Involved in testing and documentation.

Environment: Oracle 9g, C#.