Profile Summary:

• Over eight years 8 of experience in Database development, including Data warehousing ETL using Informatica, Oracle, SQL Server, Windows server, UNIX and Solaris.
• Over eight years 8 of experience in data extraction, transformation and loading data using Informatica PowerCenter 9.5/9.1/8.6/8.1/7.1.4 Admin Console, Informatica Service, Repository Manager, Designer, Workflow Manager, and Workflow Monitor ,
• Two years of experience using Informatica Power Exchange 9.1/8.6.
• One year of experience of reporting using OBIEE 11g tool.
• Experienced in integration of various data sources like Oracle 11g/10g/9i, IBM DB2, MS SQL Server 2005/2000, XML, flat files into staging area.
• Worked on non-relational sources like flat files and used secure FTP.
• Worked on Oracle PL/SQL programming, stored procedures, creating triggers, sequence generator on the target tables.
• Worked on Performance Tuning Informatica Targets, Sources, mappings and sessions.
• Well versed with Kimball's methodology-Dimensional modeling, star schema in implementing Decision Support Systems.
• Worked on Data Modeling using Erwin 4.0 Data Modeler.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Worked on Incremental loading Target databases using SCD Type1/Type2 loads.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.
• Over Four Plus years 4 of total experience in Analysis, Plan, Design, Development and Implementation of Business Intelligence using Data Warehouse/Data Mart Design, ETL, OLAP and Client/Server on Windows and UNIX platforms.
• Extensive hands-on experience in Extraction, Transformation and Loading, Data Migration and Data Conversion Projects.
• Excellent technical and analytical skills of OLTP.
• Dimension modeling for OLAP, ER modeling Database design.

TECHNICAL SKILLS:

• DWH: Informatica Power Center 9.5/9.1/8.6/8.1/7.1, Power Exchange 9.1/8.6/8.1
• Data Modeling: Erwin 7.0/4.1, MS Visio
• Programming: SQL, PL/SQL, Toad 7.x, C , Visual Basics 6.0, UNIX Shell Scripting
• Databases: Oracle 11g/10g/9i/8i, SQL Server 2007/2000, IBM DB2 7.0, Teradata 14/12,
• Sybase11
• O/S: Windows Vista/NT/2000, MS-DOS, Linux, Sun Solaris
• ReportingTools: Cognos 7, Business Objects XI, OBIEE 11g.
• Computers Systems:
• HP UNIX 10.1, 10.2, 11.0
• Sun Solaris
• Windows 95/98/NT/2000/XP/VISTA
• Programming Languages:
• Korn Shell scripting
• SQL, PL/SQL, Pro c
• Internet Technologies:
• HTML, XML, .Net
• BI Tools:
• Informatica Power Center 8.x/7.x, Data stage5.2, Business ObjectsXI/6.x/5.x, Oracle Data Integrator, WebFocus4.3.5
• Job Scheduler:
• Maestro 1.3, Autosys
• Version Control:
• Visual Source safe, PVCS Dimensions, Clear Case, Documentum
• Oracle Technologies: Oracle Designer 2000 Designer 9i/6i, Oracle Developer 2000,
• Forms 9i/6i//5.0/4.5/3.0, Reports 9i/6i/5.0/4.5/2.5, SQL Loader,
• Oracle Discoverer 3.1
• Databases:
• Oracle 10g/9i/8i, Netezza, Teradata, Sql Server2005, MSAccess, DB2, Toad, Microsoft DTS
• Data Modeling Tool:Erwin
• Defect Tracking Tool:
• Test Track, Remedy

PROFESSIONAL EXPERIENCE

Confidential

Role: Sr Software Engineer

Responsibilities:

• Involved in designing of Informatica mappings by translating the business requirements.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Involved in configuring Informatica cloud, Database Connection, ETL design and Data processing.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator and Router transformations for populating target table in efficient manner.
• Crated Mapplet and used them in different Mappings.
• Performance tuning of the Informatica mappings using various components like Parameter Files, round robin and Key range Partitioning.
• Implemented documentation standards and practices to make mappings easier to maintain.
• Involved in creating RPD, Logical design, reports, answers and connectivity.
• Involved automating retail prepaid system process and enhance the process.
• Created Function, Packages and Triggers and dependencies of the processes.
• Involved in support, maintaining, enhancing and developing new interfaces for application.
• Created Teradata Utilities like MLOAD, FLOAD and DATA PUMP.
• Created Unix Script for ETL jobs and archiving file processes.
• Created PowerExchange Registration, DataMap and configured recovery processes.
• Created three tire testing process and involved in reviewing mapping and UTCs

Environment: Informatica PowerCenter 9.5, Informatica PowerExchange 9.1/8.6, Teradata 13, WinSQL, Oracle 11g, DB2, SQL server 2007, Flat files, PL-SQL, Sun Solaris, Cognos, ESP, Putty, MQ Series, XML, Erwin 7.1, Unix, MLOAD, BTEQ and FLOAD.

Confidential

Role: Sr Informatica Developer

Responsibilities:

• Understand the business functionalities of XLRe CONFIDENTIAL CONFIDENTIAL OBU's data and convert them into Destiny Application based on Destiny Business rules.
• Extract the data from RSG application to staging area thru flat files and Tables.
• Implemented Dashboards Analytics using Business objects Performance manager.
• Upload the data from staging area into Destiny database
• Extract the data from RSG application to staging area thru flat files and Tables.
• Developed stored procedures for generic values instead of using the sequence generator transformations.
• Involved in the Software Development Life Cycle.
• Converted different Line of Business: XL Property, XL Casualty, XL Excess of loss based on business rules.
• Involved in supporting the project and resolved production issues.
• Work closely with database administrators and reporting team to ensure data is refreshed for each cycle and balancing the reports of converted data.
• Involved tuning the session performance by using various techniques.
• Used Autosys for Scheduling Informatica batch and stand alone sessions with different jobs.
• Attended web conference with Business Objects.
• Created Web Intelligence reports with dynamic objects that are linked to the values those are returned from the database.
• Involved in Migrating BO 6.5 to BO XI R2.
• Worked on Web Services to consume and send data.
• Worked on MQ Series Source, target, XML transformation and generator

Environment: Informatica PowerCenter9.1/8.1.1, Informatica PowerExchange 9.1/8.1, Business objects XIR2/6.5, Oracle 10g, Win SQL, UNIX, LINUX, Cognos, Teradata, Autosys, CVS and Test Tracker

Confidential

Role: Consultant Program Analyst

Responsibilities:

• Involved in the documentation/Design of Technical Design Document of various interfaces like Sales organization, Field AOP, and Field Forecast.
• Used Teradata, SQL assistant for running the SQL Queries to check the data loaded to the Target Tables.
• Designed and developed mappings, mapplets and sessions from source to target database using Informatica Power Center.
• Used simple to moderately complex debugging techniques to test ETL applications.
• Developed Test Cases for testing the ETL mappings.
• Conducted code reviews and lead design reviews to assure compliance.
• Involved in migration of ETL/Bteq code from Development environment to QA environment and finally to Production environment.
• Followed Informatica development standards and enforce best practices.
• Performed QA work to verify the results provided from other teams.
• Worked with various file formats like fixed length and delimited.
• Involved in creation of BTEQ Script for validating the data quality like referential integrity, not null check.
• Maintained the proper communication between other teams.
• Utilizing the existing UNIX shell scripts to run the informatica workflow through process control.
• Scheduled sessions and batch process based on demand, run on time, run only once using Informatica Workflow Manager.
• Identified BI reporting problems, and suggests practical resolutions.
• Participates in on-call support for ODS and the data warehouse.
• Involved in documentation to describe program development, logic, coding, testing, and any changes and corrections.

Environment: Informatica PowerCenter7.1/8.1, Windows2000, Business Objects XIR2/6.x, WEBi, Crystal Reports, LDAP, , Autosys, SQL Server, Documentum, Teradata, Defect Track tool

Confidential

Role: ETL Developer

Responsibilities:

• As a team member involved in collecting all the requirements for building the database.
• Involved in Creation and designed required tables, indexes and constraints for all production activities.
• Played a key role in designing the application and migrate the existing data from relational sources to corporate warehouse effectively by using Informatica Power center.
• Responsible for Extracting, Transforming and Loading data from Oracle, Flat files and placing them into targets.
• Developed various mappings using Mapping Designer and worked with Source qualifier, aggregator, connected unconnected lookups, Filter transformation, and sequence generator transformations.
• Involved in Data Modeling and design of Data Warehouse and Data Marts in Star Schema methodology with conformed and granular dimensions and fact tables.
• Used SQL, PL/SQL for database related functionality.

Environment: Informatica Power Center 7.1, Teradata V2 R6, SQL, Windows XP, SQL Assistant, UNIX Shell Script.