PROFESSIONAL SUMMARY:

• Overall 7 years of experience in IT, with proficiency as
• Terad Confidential /Informatica developer and strong expertise in SQL queries, stored procedures, Terad Confidential Macros.
• All - round experience in requirement analysis, d Confidential base design and Implementation of D Confidential warehouses with strong understanding of Dimensional Modelling, Slowly Changing Dimensions, Fact and Dimensional table, Star & Snowflake Schema, D Confidential staging.
• Expertise in loading and extracting d Confidential from Terad Confidential using various utilities like Terad Confidential SQL Assistant, BTEQ, MULTILOAD, FASTLOAD, FASTEXPORT, TPUMP and Terad Confidential Parallel Transporter.
• Good experience of the ETL processes applied to different industries. D Confidential Warehousing experience using Informatica PowerCenter 8.x/9.x/10.x (Workflow Manager, Workflow
• Monitor, Repository Manager, Source Analyser, Warehouse
• Designer, Mapping Designer, Mapplet DesignerTransformation developer), D Confidential mart, ETL, OLAP, OLTP.
• 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.
• Experience in Development of Informatica Mappings, corresponding Sessions and Workflows.
• Experienced in writing Terad Confidential SQL scripts for transforming business rules.
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics, Hints and SQL Trace both in Terad Confidential as well as Oracle.
• Expertise in developing summaries and reports using Advanced Terad Confidential SQL according to business needs.
• Expertise in understanding the business requirements and converting them into Technical specifications and reverse engineering the existing systems or processes for documenting and bug fixing.
• Experience in performance tuning of large-scale d Confidential bases using
• Views, indexing mechanism, Global Temporary tables, and Volatile tables in TERAD Confidential using Terad Confidential Parallel Transporter (TPT).
• Excellent experience in ETL Tools like Informatica and Informatica BDE and on implementing Slowly Changing Dimensions (SCD).
• Expertise in developing the Batch control processes in UNIX.
• Involved in generating Mload and Tpump scripts to load the d Confidential into Terad Confidential table.
• Extensively worked on Informatica Designer components, Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Expertise in Oracle Stored Procedures, Triggers, Index, Table
• Partitions and experienced in Loading d Confidential like Flat Files, XML Files, Oracle, DB2, SQL Server into D Confidential Warehouse/D Confidential Marts using Informatica.
• Experienced in developing business reports by writing complex SQL queries using views, macros, volatile and global temporary tables.
• Quick adaptability to new technologies and zeal to improve technical skills.
• Good analytical, programming, problem solving and troubleshooting skills.
• Extensive knowledge in Terad Confidential SQL assistant, Terad Confidential viewpoint, fast Export, Fast Load, Multi Load, BTEQ scripts, TPUMP and Terad Confidential parallel Transporter.
• Extensively worked with XML files as a source and target, used transformations like XML generator and XML parser to transform XML files, and used oracle XML type to store XML files.
• Strong background in various D Confidential Modelling tools using Erwin, MS Visio.

TECHNICAL SKILLS:

Informatica: ETL 10.0.1/9.5.1/9.1.0/8.6.1/8.5/8.1/7.1/6.2

BO D Confidential Integrator: Business Objects BO XI-R2\6.5, Crystal

BI tools Reports.: Oracle 10g/11g, SQL Server 2005D Confidential base

Terad Confidential v12/13/14,15, DB2: TOAD, SQL*Loader, MS SQL Server Interfaces Management Studio

Languages: PL/SQL, C, C++, SQL, HTML, XML.

Environment: Windows 2000\NT\XP, UNIX, Linux

Concepts: RDBMS, D Confidential Warehousing/ D Confidential marts Informatica Scheduler, Autosys, CTLM Scheduling

Tools: Modelling Tools ERWIN, MS Vision, ER Studio

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Informatica Developer

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.
• Done the impact analysis in terms of schedule changes, dependency impact, code changes for various change requests on the existing
• D Confidential Warehouse applications that running in a production environment.
• Validated, debugged old Mappings tested Workflows & Sessions and figured out the better technical solutions.
• Identified the Bottlenecks in old/new Mappings and tuned them for better Performance.
• Created BTEQ scripts with d Confidential transformations for loading the base tables.
• Worked on optimizing and tuning the Terad Confidential SQL to improve the performance of batch and response time of d Confidential for users.
• Created Batch scripts for active batch job scheduling and supporting them.
• Fast Export utility to extract large volume of d Confidential and send files to downstream applications.
• Extensively used informatica PowerCenter 10.0.1 to extract d Confidential from various sources, which included Flat files, SQL server, Oracle, Ma - Access and XML.
• Developed various complex SCD Type1/Type2 Mappings to maintain the d Confidential 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 Team Based development to migrate the codes from Dev. to Test to Prod environment and wrote up the Team Based Development technical documents to smooth transfer of project.
• Created Pre-& Post-Sessions UNIX Scripts, Functions, Triggers and Stored Procedures to drop & re-create the indexes and to solve the complex calculations on d Confidential . Transformed and loaded of large sets of structured, semi-structured and unstructured d Confidential coming from different sources like CSV, Flat file MS-SQL, Oracle etc.

Environment: Informatica Power Center 10.0.1, Terad Confidential, CTLM, Cognos, Oracle 10g/11g, MS Access, MS SQL Server 2008, Unix, Shell Scripting, Perl Scripting, Sybase, SQL PL/SQL, XML SQL*Plus, TOAD, Oracle Applications 11i.

Confidential, Dallas, TX

ETL Developer

Responsibilities:

• Worked closely with business analyst and D Confidential Warehouse architect to understand the source d Confidential and the need of the Warehouse.
• Involved in profiling, cleansing, standardization and Match/Merge.
• Identifying and acquiring new d Confidential sources.
• Performed tuning of Queries for optimum performance.
• Extensively worked with Designer tools like Source Analyzer, Target designer, Mapping designer, mapplet designer, Transformation Developer.
• Preparation of Test d Confidential for Unit testing and d Confidential validation tests to confirm the transformation logic
• Tuned various queries by COLLECT STATISTICS on columns in the WHERE and JOIN expressions.
• Created source and Target Definitions, Reusable transformations, mapplets and work lets.
• Created Mappings and extensively used transformations like
• Source Qualifier, Filter, Update Strategy, Lookup, Expression, Router, Joiner, Normalizer, Aggregator and Sequence Generator, Web services Consumer.
• Used Workflow Manager to create sessions, work lets workflows.
• Extensively involved in tuning the mappings, sessions and the Source Qualifier query.
• Identified performance issues in existing sources, targets and mappings by analyzing the d Confidential flow, evaluating transformations and tuned accordingly for better performance.
• Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target D Confidential
• Involved in migration of mappings and sessions from development repository to test and production repository.

Environment: Informatica PowerCenter 9.5, Terad Confidential, Oracle 11g, PL/SQL, Dynamic SQL, UNIX Shell Scripting, SharePoint, Web Services, MySQL, Autosys.

Confidential

Informatica Developer

Responsibilities:

• Extensively involved in tuning the mappings, sessions and the Source Qualifier query.
• Designed and created ETL mappings using Informatica mapping designer.
• Worked on Terad Confidential parallel transport (TPT) to load d Confidential from d Confidential bases and files to Terad Confidential
• Worked extensively on performance tuning by making changes to SQL in source qualifier.
• Analysis of Source, Requirement, existing OLTP system and
• Identification of required dimensions and facts from the D Confidential base.
• Fine - Tuned existing mappings for better performance.
• Documented mappings and transformations.
• Performance tuned and optimized various complex SQL queries.
• Creation of facts and dimensions according to the business requirements.
• Monitoring and improving performance of daily jobs on oracle d Confidential base.
• Identifying integrity constraints for tables.
• Experienced in identifying and documenting d Confidential integration issues, challenges such as duplicate d Confidential, non-conformed d Confidential, and unclean d Confidential .
• Involved in production support and done knowledge transfer to team members.
• Actively involved in Daily check in meetings to discuss on the production issues and resolved.
• Worked on Automation process of Sessions, Workflows, scheduled the Workflows, created Work lets and configured them according to business logics & requirements to load d Confidential from different Sources to Targets.
• Involved in various testing activities like d Confidential base testing, unit testing, system testing, performance testing and was also responsible for maintaining of testing metrics, defect tracking.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test d Confidential and loading for testing, error handling and analysis and Maintenance of the D Confidential Marts.

Environment: s:Informatica PowerCenter 9.1, Terad Confidential, Oracle 11g, MS SQL Server 7.0 2000, Flat files, SQL, SQL*Loader, Erwin, Toad, Windows 2000, Unix Shell Scripting.

Confidential, Baltimore, Maryland

Informatica (ETL) Developer

Responsibilities:

• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with
• ETL and Reporting system and also to successfully implement business logic.
• Has a very good knowledge of FACETS tool and Healthcare domain, worked on the various modules like.
• Worked on all type of health insurance d Confidential like member enrolment, plans, benefits, claims etc.
• Good experience on FACETS CTP (Claims Test Pro) and FACETS Testing.
• Processing claims through EDI 834 and 837 files to FACETS system and also worked on scenarios for complete claims lifecycle
• Responsible to ensure members are getting loaded correctly to CSP Facets through 834 files.
• Understood the Business point of view to implement coding using Informatica power centre designer
• Migrate historical d Confidential, which is one time and built migration process for ongoing d Confidential loads using Informatica power centre designer.
• Developed mappings to extract d Confidential from various source systems like SQL Server, Flat files, XML and load into D Confidential warehouse.
• Used Source Analyser and Warehouse designer to import the source and target d Confidential base schemas, and the Mapping Designer to map the sources to the target.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline d Confidential to D Confidential Warehouse.
• Involved in versioning the whole process and retiring the old records using the built - in's DD UPDATE, DD DELETE, and DD INSERT.
• Debugging invalid mappings using breakpoints, testing of stored procedures and functions, testing of Informatica sessions, batches and the target D Confidential .
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Identified sources, targets, mappings and sessions and tuned them to improve performance.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Implemented D Confidential warehouse and d Confidential base applications with Informatica ETL in addition with d Confidential modelling and reporting tools on Terad Confidential, Oracle, DB2.
• Worked as a part of a production support team and provided 24 x 7 supports.

Environment: Informatica PowerCenter (Repository Manager, Designer, Workflow Manager, Workflow Monitor and Repository Server Admin console), Power Exchange 9.1, 9.1, Oracle 12c/11g, EDI 834 and 837, FACETS 4.7.1PL/SQL, SQL, COGNOS, TOAD, LINUX, Shell scripts, Terad Confidential .