SUMMARY:

• 6 years of experience in the Information Technology industry.
• 5 years of experience in working with data warehouses and using Informatica PowerCenter 7.1, 8.1, 8.6, 9.0.1 Designer, Repository Manager, Workflow Manager and Workflow Monitor and OBIEE Oracle Business Intelligence Enterprise Edition .
• Expertise in configuration, performance tuning, installation of Informatica, in integration of various data sources like Oracle, Teradata, MS SQL Server, IBM DB2, XML and Flat files.
• 4 years of extensive experience with databases MS SQL Server 2000/2005/2008, Oracle 8i/9i/10g/11g, Teradata .
• Working knowledge of Oracle data Integrator ODI .
• Working knowledge of PL/SQL, performance tuning of Oracle using SQL trace, SQL plan, SQL hints, Oracle partitioning, various indexes and join types.
• Hands on experience on Informatica Power Exchange for loading/retrieving data from mainframe systems.
• Experienced with Informatica PowerExchange 8.x for Loading/Retrieving data from mainframe systems
• Experience in Business Requirement Analysis, Application Design, Data Modeling, Development, Reporting, Testing of Data Warehousing and Database business systems and Implementations.
• Extensive knowledge with dimensional data modeling, star schema/snowflakes schema, fact and dimension tables.
• Customized and configured OBIEE application using OBIEE Answers, OBIEE iBots, OBIEE Dashboards, BI Publisher and Administration Tool. Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE 10g and 11g
• Experience in modeling and building the OBIEE repository, deployment and migration of OBIEE components like RPD and Catalog from 10g to 11g
• Managed key subject area of very large relational database in client server environment.
• 4 years of UNIX shell scripting. Hands on exposure on UNIX environment and experience in using third party scheduling tools like DAC Data warehouse Administration Console and SOS Job scheduler.
• Strong skills in data analysis, data requirement analysis and data mapping for ETL processes.
• Ability to prioritize and execute tasks in a high-pressure environment.
• Experience in mentoring and providing knowledge transfer to team members, support teams and customers.
• Reliable, proactive, responsible, hardworking and good team player.

TECHNICAL SKILLS

• ETL Tools: Informatica Power Center 9.0.1/8.x/7.x/6.x, OWB 11.2.0.3 , ODI
• BI Tools: OBIEE 11.1.1.3/11.1.1.5 , Cognos BI Suit, BI Publisher
• Databases: MS SQL Server 2005/2008, Oracle 9g/9i /10g/11g, Teradata, IBM DB2.
• Database Skills: Cursors, Stored Procedures, Functions, Views, Triggers, and Packages
• Client Side Skills: SQL, PL/SQL, UNIX shell scripting, CSS.
• OS: Windows 2000/2003/XP/Vista/Windows 7, UNIX/Solaris
• Methodologies: Data Modeling Logical / Physical, Star/ Snowflake Schema, FACT Dimension Tables, ETL, Software Development Life Cycle SDLC
• Tools: Toad, SQL developer, MS Project, JIRA, MS Visio, and Autosys, DAC Data warehouse Administration Console , SOS job scheduler

PROFESSIONAL EXPERIENCE:

AS Mandated by the federal Affordable Care Act ACA . This project implements NC FAST System interoperability with the Federally-Facilitated Marketplace FFM , where individuals can determine if they qualify for either Medicaid or subsidized health insurance, with the online option to purchase health insurance directly from a provider. The ACA required the new Modified Adjusted Gross Income MAGI ruleset for 8 Family and Children's Medicaid programs to be implemented.

Responsibilities:

• Worked closely with Manager and Database Administrator
• Analyzed functional specs and created technical documentation.
• Extensively used all the features of Informatica 9.1 including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Responsible for developing, support and maintenance for the ETL Extract, Transform and Load processes using Informatica powercenter.
• Designed and developed several ETL scripts using Informatica, UNIX shell scripts
• Analyzed the source data coming from Oracle, Flat Files, and MS Excel coordinated with data warehouse team in developing Dimensional Model.
• Loaded the data into the Teradata database from Oracle and DB2 databases using Load utilities like like MultiLoad, Tpump, and Fast Load to load data into Teradata data warehouse.
• Created ftp connections, database connections ODBC for the sources and targets.
• Backup/Restoration of repositories.
• Implemented Change Data Capture CDC in midrange and mainframe system using Informatica Power Exchange 9.x to capture changes from source to target.
• Implemented various workflows using transformations such as JAVA transformation, XML transformation, Normalizer, look up, aggregator, stored procedure and scheduled jobs for different sessions.
• Implemented Slowly Changing dimension methodology for accessing the full history of accounts and transaction information.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager.
• Used Teradata utilities like fastload, multiload, tpump to load data.
• Develops and unit tests efficient ETL scripts in a Teradata environment.
• Experience with writing and executing test cases for data transformations in Informatica
• Scheduled mappings and workflows using Autosys
• Created medium to complex PL/SQL stored procedures for integration with Informatica using Oracle 10g.
• Upgrading and maintenance for data warehouse tools
• Co-ordinate with the off-shore teams and mentored junior developers.
• Analyzed performance tuning of Oracle 10g to improve its performance.
• Developed Shell Scripts to automate file manipulation and data loading procedures
• Proficient with Visual Source Safe for version control for Informatica objects, Oracle views and packages and test scripts.
• Developed UNIX shell scripts to control the process flow for Informatica workflows to handle high volume data.
• Prepared Test cases based on Functional Requirements Document.
• Developed Procedures and Functions in PL/SQL for Data ETL.
• Involved in Unit, System, Performance, Concurrent and QA testing.
• Worked with complex management reports in OBIEE using master-detail relationship, drill through, drill up and drill down, burst options, and PROMPTS and also with aggregate aware.
• Created dashboards for a managerial overview with drill up and drill down capabilities

Environment: Informatica Power Center 9.x , Toad 8.5.1.6, Oracle 11g, Erwin, SQL plus, PL/SQL, OBIEE 11.1.1.3 , Oracle Enterprise Manager 10g, 12c , SQL Developer 3.2.x, 4.0 Teradata 13.0, UNIX., SVN

Confidential

Position: Informatica Developer

Confidential is the leader in online learning for grades K through 12, full-time online public schools in many states across the country, individual course and product sales directly to families and in a growing number of public schools across the country which are engaged in bringing individualized learning approaches into the traditional classroom.

Responsibilities:

• Analyzed user requirements for the system.
• Supported in Design, Development, Test and Deployment of project development.
• Responsible for verification of functional specifications and review of deliverables. Designed and Created data cleansing, validation and loading scripts for Oracle data warehouse using Informatica Power Center 9.0.1.
• Customized and developed RPD Physical, Business model and Presentation Layer , configured metadata objects and Web Catalog Objects using OBIEE.
• Developed Dashboards such as Default Dashboard for the users when after login directed to a default dashboard based on the department they work using OBIEE.
• Hands-on OBIEE experience as data modeler, data analyst, report developer and OBIEE architect to understand and relate to user issues and make informed decisions.
• Extensively used Informatica Client Tools Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Mapplet Designer, and Informatica Repository.
• Created reusable transformations and mapplets to use in multiple mappings.
• Created and monitored workflows and tasks using Informatica Power Center Workflow Manager.
• Extensively used transformations like router, aggregator, lookup, source qualifier, joiner, expression, aggregator and sequence generator transformations in extracting data in compliance with the business logic developed.
• Analyzed newly converted data to establish a baseline measurement for data quality in data warehouse.
• Created global repository, Groups, Users assigned privileges using repository manager.
• Setting up batches and sessions to schedule the loads at required frequency using Power Center server manager.
• Worked on Oracle Data Integrator 11g ODI to build K12 Project.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules, security efficiently and test cases.
• Imported external data flat files into Oracle tables using PL/SQL.
• Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables. Used Parallel hints for performance tuning.
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and incorporate the changes as and when necessary.
• Provided assistance during user testing interaction with the users .

Environment: Informatica Power Center 8.6.3/8.6.1 Designer, Workflow Manager, Workflow Monitor, Repository Manager , OBIEE 10.1.3.3, Oracle Data Integrator 11g,IDQ, PL/SQL, Informatica Power Connect, Metadata manager, DB2, Oracle10g, UNIX Shell Scripting, TOAD Oracle Designer

Confidential

Position: Informatica Developer

Confidential is one of the major Financial Companies. A web based Customer relationship management CRM , application, enables users to view all accounts associated with a customer. The system maintains database at backend, which stores day-to-day Transactions, Customer Information.

Responsibilities:

• Involved in gathering the Business requirements from the client and writing and maintaining technical/design documentation.
• Designed and developed end-to-end ETL process for the FIIS production systems.
• Analyzed the business requirements for ETL process and created schema flow diagrams in VISIO.
• Performed extensive analysis of metadata to test the integrity, consistency and appropriateness of the data brought into the warehouse from various sources.
• Create and deployed the ETL code across the environments.
• Analyzed and tuned queries on the database that will be executed from reporting system.
• Leveraged Informatica to extract data from heterogeneous source systems and aggregate the data and load into the target warehouse.
• Extracted data from sources like Oracle database and Flat Files.
• Created various reusable transformations in designer such as Slowly Changing Dimensions using Informatica Power Center Transformation Developer.
• Created various Mapplets in designer using Informatica Power Center Mapplet Designer.
• Design and Development of ETL routines, using Informatica Power Center 8.6.3 within the Informatica Mappings, usage of Aggregator, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers.
• Worked on Unix AIX4.3 machine on which Informatica Server was installed to check for the session logs.
• Worked on the UNIX AIX4.3 to connect to the Oracle database and run PL/SQL scripts.
• Used Informatica Power Connect for SAP to pull data from SAP R/3.
• Wrote stored procedures for dropping and recreating indexes for efficient Data Load.
• Extensively worked on the tuning of mappings and sessions.
• Used Teradata utilities such as FastExport, FastLoad and MultiLoad.
• Writing BTeq scripts for Teradata.
• Worked on Clear Case Source Control System, this provides a virtual workspace to check in and checkout various files and directories.
• Created and Scheduled Sessions and Batch Process based on demand using Informatica command line prompt.
• Analyzed the existing database and designed the Universes using Business Objects Designer Module.
• Created number of standard reports and queries based on the existing classes/objects.

Environment: Informatica Power Center 8.6.3/8.6.1 Designer, Workflow Manager, Workflow Monitor, Repository Manager , Informatica Power Connect, DB2, Oracle10g, UNIX Shell Scripting, TOAD Oracle Designer, ERWIN 7.2.

Confidential

Position: ETL Developer

Electrolux is leading company in household appliance maker. Its products sell under a variety of brand names including its own and are primarily major appliance and vacuum cleaners. The company also makes appliances for professional use.

Responsibilities:

• Worked Developed various Mappings, Mapplet and Transformations for migration of data from various existing systems to the new system using Informatica Designer.
• Development and deployment of various Informatica mappings in different Environments.
• Developing various Job Scheduling codes to run various Production jobs using Job Scheduler.
• Provided the data warehouse development methodology and created the architecture and dimensional model to develop an effective decision support system DSS Consolidated the requirements and worked to create the Enterprise Data Model along with the Logical Data Model for the system using ERWIN CASE tool.
• Created Entities, attributes, relationships and the data dictionary for the system. Testing the codes, Workflows, Mappings in Informatica Power center.
• Data Modeling done with Multidimensional Architecture.
• Extensive Experience in SDLC and in handing large volume of data.
• Testing the Application under various Environment using tools like Quality Center.
• Involved in peer to peer-to-peer reviews.
• Identifying Bugs and reporting defects.
• Knowledge of Backups, Partitioning of Database.
• Created and managed the global and local repositories and permissions using Repository Manager.
• Extract and deploy various types of data in the target database using ODI.
• Development of pre-session, post-session routines and batch execution routines using server to run Informatica sessions.
• Developed data mappings between source systems and warehouse components.
• Created and defined DDL's for the tables at staging area.
• Documentation for ETL development process. Installation and troubleshooting guide.
• Dealt with Medicare D reports/data.
• Used corntab/autosys for sechedualing Informatica / Oracle jobs.
• Used FACETS data as source for the various data marts member/claims
• Did integration testing of mappings and data transformations involving service centers for various EDI transactions.
• Dealt with batch processes related to EDI/CLaims/Member data load.

Environment: Informatica Power Center 8.1, Oracle 9i, ODI, Teradata V2R3, UNIX Solaris , Sybase, Erwin 4.0/3.5.x, MS SQL Server 2000, PL/SQL, MS Access 2000, Shell Programming, SQL Loader Toad

Confidential

Position: ETL Developer

Description: Farmer Insurance is one of the biggest insurance providers worldwide and is also known for the wide range and types of insurances it provides. The project dealt with the Revenue generated per month and the cost incurred at different offices to analyze the profitability by different segment, by office, by company, by client. The main object of the PDM data mart is to collect the Practitioner information from different sources and load into PDM data mart. PDM Data mart helps to build Monthly claims report for every individuals or groups.

Responsibilities:

• Involved in the full software development life cycle.
• Participated in Requirement Gathering, Business Analysis, User meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
• Designed, Developed and maintained ETL Data Extraction, Transformation and Loading mappings using Power Center -Designer to extract the data from multiple source systems like Oracle, Flat file and Teradata to the target database Oracle.
• Extensively used Informatica Client tools Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Used connected and unconnected lookups whenever appropriate, with appropriate caches
• Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up connected and unconnected , Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.
• Implemented slowly changing dimension SCD for accessing the full history of Customer and transactions of customer. Implement Type I, II, and III changes in slowly changing dimension tables.
• Used Informatica Designer to create reusable transformations to be used in Informatica mappings and mapplets.
• Used debugger to test the mapping and fixed the bugs
• Created and configured workflows, worklets Sessions to transport the data to target systems using Informatica Workflow Manager.
• Involved in designing technical specifications for building DataMart.
• Implemented error-processing strategy to reprocess error data and manage notification of error data to corresponding business team.
• Assisted in Data Modeling using Erwin modeling tool .Captured data error records corrected and loaded into target system.
• Created Effective Test Data and Unit Test cases for Vendor Reporting System to ensure the successful execution of the data loading processes, Created SQL scripts to verify test cases from source to target database oracle.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Used Autosys Scheduler in creating and scheduling the job's run timings.
• Worked in fixing poorly designed mappings, workflows, worklets, sessions, and target data loads for better performance.
• Wrote SQL, PL/SQL codes, stored procedures and packages.
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
• Involved in PL/SQL statements performance tuning.
• Involved in Fine-tuning of sources, targets, mappings and sessions for Performance Optimization.

Environment:

ETL- Informatica Power Exchange, Power Center 8.1,,Oracle10g,PL/SQL, Teradata, TOAD, DB2, Erwin7.2, Autosys, XML, WinNT UNIX.

Confidential

Position: Informatica Developer

Description: Cigna is a health care service with a motto of serving people to improve their health, well being, and sense of security. It is one of the largest health insurance company in the U.S. which operates internationally in 30 countries and has more than 70 million customer relationships worldwide. This Project was aimed to replace the existing way that Insurance data is processed by a new Enterprise System. Data was coming in from different sources and types, which include Premium, Claim, Loss and Policy. The new Enterprise system will provide all necessary functions of the retiring systems or superseded by improved functionality. System also is interfaced out to various areas within the organization, downstream and outside business partners.

Responsibilities:

• Involved in gathering the Business requirements from the client and writing and maintaining technical/design documentation.
• Involved in Logical and Physical data models that capture current/future state data elements and data flow using Erwin.
• Used advanced techniques of Informatica to load data from source MS SQL Server, Flat files, DB2 into the target DW, TeraData.
• Designed and developed complex Mappings using Informatica PowerCenter Designer.
• Designed reusable transformations and Mappings Data Quality Plan Mapplets, Build Data quality Scorecards.
• Extensively worked with transformations Lookup, Update Strategy, Expression, Filter, Stored Procedures, Router and others.
• Designed, developed and fine-tuned stored procedures. Tuning of SQL queries for better performance. Imported external data flat files into Oracle tables.
• Implemented changes in slowly changing Dimension Type 2 3 tables.
• Created and ran workflows using Workflow Manager to load the data into the Target Database.
• Optimized/Tuned mappings for better performance and efficiency.
• Developed mapping parameters and variables to support SQL override.
• Used debugger to test the data flow between source and target and to fix the invalid mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Used session partitions, dynamic cache memory and index caches for improving performance of Informatica services/ server
• Designed and developed table structures, stored procedures and functions to implement business rules.
• Used UNIX shell scripting and PMCMD command line for workflow automation and Created Shell scripts to execute some packages from Informatica.
• Used application development tools like TOAD Oracle to develop SQL queries and stored procedures. Oracle as backend database and Oracle Data IntegratorCDC.
• Tested the data and data integrity among sources and targets using Unit Testing, UAT.
• Associated with Production support team in various performances related issues DAC updates.

Environment: Informatica PowerCenter 7.x, Teradata, Oracle 9i, SQL, PL/SQL, DB2, Toad, Erwin, UNIX HP/ Linux and Win XP.