PROFESSIONAL SUMMARY

• 7 years of IT experience in design, analysis, development, documentation, coding and implementation including but not limited to Databases, Data Warehouse, ETL Design. Expertise in Finance, Insurance, Health Care, Retail E-commerce and Energy domains.

• ETL experience using Informatica 9.1/8.6.1/8.6/8.5/8.1/8.0/7.1/6.2/5.1 Power Center/ Power Mart/ Power Play Designer, Workflow Manager, Workflow Monitor and Server Manager
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping, Mapplet Designer and Transformation Developer.
• Extensive experience in Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
• Worked with Informatica Power Center to move data from multiple sources into a common target area such as Data Marts and Data Warehouse using Source Qualifiers, Expressions, Normalizers, Routers, connected/unconnected Lookups/procedures, Update strategies, Mapplets and Slowly Changing Dimensions.
• Provide support to Onshore and Offshore team members.
• Knowledge of Migration, backup, recovery, tuning, tracing and troubleshooting.
• Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like flat files, XML files, Oracle, SQL Server, MQ-Series, Teradata, DB2.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Expertise in utilizing Oracle utility tool SQL Loader and expertise in Toad for developing Oracle applications.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment and change data capture, Periodic and Accumulating snapshots
• Good experience in Data profiling and Data Analysis.
• Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.
• Experience in Performance Tuning of sources, targets, mappings and sessions.
• Delivered 24/7 supports including scheduled and emergency night and weekend work.
• Interpersonal skills and ability to work independently and deliver on time, hard working and ability to adapt to new technologies very quickly.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Description: Confidential Communications is one of the nation's largest independent telecommunications providers offering local, long distance, and Internet access services in 24 states and supporting more than 2 million access lines. Frontier is in the process of acquiring approximately 4.8 million access lines from Verizon Communications and on the way to becoming America's 1 communications carrier focused on rural areas and small and medium-sized towns and cities. The transaction involves 14 states and they need to be converted to Frontier's DPI Billing System.

Responsibilities:

• Responsible for gathering Business requirements and translate into technical requirements.

• Involved in translating the functional requirements into technical mapping specifications and leveraged Informatica Power Center 9.1 to extract the data from AS/400 DB2 files, Oracle tables and flat files to populate billing, service order and plant interface files, which are then loaded into the Citizens DPI Billing system.
• SQL Loader scripts for bulk data loads to Oracle tables and extracting Oracle dumps from Verizon.
• Experienced in writing Queries against DB2 on AS400 Environment.

• Optimization/performance tuning techniques implemented to identify bottlenecks- Query tuning Explain Plan, SQL Trace , table partitioning, memory tuning and cache management.
• Expertise in debugging and production support.
• Experience in writing Shell scripts for file manipulation, extraction and execution of Workflows
• Extensive use of the STRSQL, AS/400 Query facilities in AS/400 and execution of SQL queries using PL/SQL Developer 7.1.0 and also used SQL Loader efficiently to load large volumes of flat file data.
• Extensively worked with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplet Designer.
• Developed mappings/sessions using Informatica Power Center 9.1/8.6.1 / Power exchange 8.5.1 for data loading.
• FTP scripts and Extraction of Unstructured Data from various Verizon Data formats using Perl/Shell Scripts. XML/flat file formats also extracted successfully.
• Responsible for managing Informatica Services like Repository Service, Integration Services, Reference Table Manager Services etc.
• Designed and developed error handling and rekey mechanism in Informatica
• Monitored daily loads and provided on call production support L2 during data Loads.
• Creating Change Control Requests as required by assigned projects and ensuring end to end extensive support as Data Analyst and address overall data quality, including the design of ETL strategies to source, match a Merge from various disparate systems
• Creating Change Control Requests as required by assigned projects and ensuring end to end quality of assigned projects.
• Installation configuration of Informatica services for 64 bit OS.
• Created repository assigned grants to users to access the repository.
• Experienced in creating xsds and landing XML extracts.
• Used transformations like Joiner, Expression, Connected, Unconnected lookups, Filter, Aggregator, Stored Procedure, Rank, Update Strategy, Router, Sorter, Sequence generator etc.

Environment: ETL/Informatica PowerCenter 9.1/8.6.1/8.5.1, Informatica Power Exchange 9.1, Oracle 11g, PL/SQL, Telecordia,XML,Flat files, UNIX, Toad, SQL Developer, VSAM, CSV, XML files,AS400, DB2, Perl, Shell Scripting, HP Quality Center.

Confidential

Informatica Developer

Confidential of America RGA is a Global life reinsurance company. RGA delivers expert solutions in life reinsurance, risk management, facultative underwriting, product development, and capital-motivated reinsurance services. RGA is an Industry leader in the United States and counting more than three-quarters of the 100 largest life companies as clients.

Responsibilities

• Involved in full project life cycle - from analysis to production implementation and support with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into Business intelligence database.
• Based on the requirements created Functional design documents and Technical design specification documents for ETL Process.
• Designing and reviewing the data models using Erwin tool.
• Designing and reviewing the ETL solutions in Informatica Power Center 7.1.3
• Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Extensively worked on Informatica client tools like Designer, Workflow Manager and workflow monitor.
• Created complex mappings using Aggregator, Expression, Joiner transformations including complex lookups, Stored Procedures, Update Strategy and others
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Designed and developed table structures, stored procedures, and functions to implement business rules.
• Extensively involved in migration of ETL environment, Informatica Objects, Database objects and EDW.
• Tested data integrity among various sources, targets and various performance related issues.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment.

Environment: Informatica Power Center 8.6.1, ETL, Business Objects, Oracle 10g/9i, MS Sql server 2000, Teradata V2R6 as IDW, HP - Unix, Linux, Erwin, PL/SQL, Autosys for scheduling.

Confidential

Informatica Developer

Confidential utilizes a manager-of-managers approach to investing the assets of each Harbor fund. Harbor Capital Advisors serves as the investment manager to each Harbor fund. Harbor Capital Advisors identifies institutional oriented investment firms to serve as sub adviser to each Harbor fund.

Project: Atomic Data warehouse

Confidential Data warehouse was built to collect data for different Subject areas such as Funds, Accounts, Fund Transaction, Parties and Locations. Later an Incremental Data Mart is built to collect the De-normalized data for each Subject area from the normalized Data Warehouse.

Responsibilities

• Involved in design, development, testing phases of ETL.
• Designed an error handling approach to handle the errors in the Atomic Data Warehouse.
• Created ETL Mapping and test case documents to load the data in the Funds Subject area for the atomic data warehouse and Data Mart.
• Received various Flat files from third party Fund Managers for the Share Class and Mutual Funds which were subsequently cleansed and loaded into the Staging area, Data Warehouse and Mart
• Designed and developed Informatica mappings for data loads and data cleansing for Funds Subject area in ADW and the complete Data Mart.
• Extensively worked on Informatica Designer, Work Flow Manager, Work Flow Monitor and Repository Manager.
• Used transformations like Joiner, Aggregator, Expression, Normalizer, Update strategy, Filter, Sequence generator, Lookup and Source qualifier transformations in Informatica Designer.
• Developed Mapplets and Worklets and used them in the Informatica mappings and workflows.
• Built a Data Mart to collect the data from all subject areas in ADW.
• Documented the project documents such as Mappings specifications, test cases and process flow diagrams.
• Involved in Data Modeling changes with ETL Architect as part of the Development process.
• Involved in JAD sessions with the users and Reporting team in massaging the final set of data as per their requirements.

Environment: Informatica Power Center 8.6, Oracle SQL Developer, Work Flow Manager, Work Flow Monitor, Oracle 10g , PSPad, Tidal, Putty, Unix scripting, AIX 5.3

Confidential

Informatica Developer

Confidential has initiated an enterprise initiative to have a centralized source of customer intelligence for its 3 lines of businesses - Value City Stores, DSW Shoes and Filene's Basement. The fundamental driver of this initiative is a strategic CRM and BI strategy that will innovate all of RVI's companies with the ability to Identify and relate to our customers via multi-channel customer loyalty programs and direct marketing campaigns. Analyze customer behavior, shopping patterns and trends that will lead to stronger decision making, improved customer experiences and ultimately increased customer loyalty. Maximize advertising and operational effectiveness with enhanced analytical, reporting and information delivery tools.

Responsibilities

• Based on the requirements created Functional design documents and Technical design specification documents for ETL Process.
• Designing and reviewing the data models using Erwin tool.
• Designing and reviewing the ETL solutions in Informatica Power Center 7.1.3
• Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Designed and developed table structures, stored procedures and functions to implement business rules.
• Extensively involved in migration of ETL environment, Informatica, Database objects.
• Involved in splitting of Enter price data warehouse environment and Informatica environment in to 3 of each company.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment.

Environment: Informatica Power Center 7.1.1, Teradata V2R6, Micro Strategy, MS Sql server 2000, Oracle 10g, 9i/8i, HP Unix, Perl scripting and Windows 2000, Erwin 4.2, PL/SQL.

Confidential

ETL Developer

Confidential is a leading IT software services company which offers a wide range of information technology services including software development, managed IT services, engineering design, data warehouse development, and systems integration outsourcing.

Responsibilities

• Worked on Informatica Source Analyzer, Data warehousing designer, Mapping Designer and Transformations
• Worked with Transformations like Source Qualifier, Aggregator, Expression, Lookup, update strategy, Filters, Stored procedure, Router are mostly used
• Created mappings and maplets and also tuned them for better performance.
• Extensively involved in data Extraction, Transformation and loading ETL Process from source to target using Informatica
• Designed data warehouse using Star Schema.
• Importing source, target tables from respective databases and created reusable transformations and mappings using Designer Tool set of Informatica
• Scheduled workflows using workflow manager workflow monitor
• Extensively Involved in Preparation of Technical Specifications
• Prepared Unit Test cases for unit testing and Specification Requirements.

Environment: Informatica 6.1, Oracle 8i, SQL Loader, Windows 2000 / NT, Toad