SUMMARY OF QUALIFICATIONS:

• Twelve years of experience in complete Software Development Life Cycle.
• Extensive experience in Data warehousing, ETL, Data Modeling, Physical and Logical Database designing for Insurance, Pharmaceutical and Financial Industries.
• Experience in Data warehousing ETL using Informatica Power Center 9.1/7.1.2/6.2/5.1, Informatica Power Mart 6.2/5.1, Oracle 9.x/8i/8.0/7.x, MS SQL Server 6.5/7.0, OLTP, OLAP, Data Reports and Erwin.
• Expert database development skills using DB2, Oracle PL/SQL to write stored procedures, stored functions, packages and triggers.
• Wrote Pre-session and Post-session shell scripts to truncate tables and analyze tables.
• Experience in Upgrade Informatica 5.1 to Informatica 7.1.3.
• Developed Informatica mappings, re-usable transformations.
• Implemented performance tuning with the Transformations, Sessions and on the Source Databases.
• Handling Production support.
• Trouble shooting, data cleansing and data integrity. Extensively working on bug fixes and enhancements.
• Extensively worked in DB2 stored procedures, UNIX scripting.

TECHNICAL SKILLS:

RDBMS : Oracle 9.i/8.x/7.x, SQL Server6.5/7.0/2000, DB2, MS Access, Sybase.

Data Warehousing : Informatica Power Center 9.1/7.1/6.2/5.1, Power mart 6.2/5.1/4.7, ETL, Data-

mart, OLAP, OLTP, SQL Plus.

Utilities : TOAD 7.3/7.2, SQL Navigator 3.1/4.5, MS Visio, MSOffice, Erwin4.0, Rapid

SQL 7.3.3.

Reporting Tools : Business Objects 5.0/4.1, Crystal Report 8.5, Cognos 7.3/8.1, Report Net.

Languages : C, C , COBOL, SQL, PL/SQL, Perl, UNIX Shell Scripting Korn shell, Bourne

Shell ,Visual Basic 5.0, Java Basics , HTML.

Operating Systems : Sun Solaris 2.6/2.7, HP-UX and IBM AIX 4.2/4.3, Win 3.x/95/98, Win NT 4.0,

SCOUNIX, Red Hat Linux.

Modeling Technologies : Unified Modeling Language UML , ER diagrams, Data Modeling.

PROFESSIONAL EXPERIENCE:

Confidential

Lead Informatica and Architect

Responsibilities:

• Scripts were run through UNIX shell programs for Batch scheduling.
• Developed/enhanced the UNIX, SQL scripts for the metadata management.
• Wrote UNIX scripts to automate the data transfer.
• Created PL/SQL Stored Procedures for various needs of the transformations while loading the data.
• Provided production support after rolling the application out.
• Did Complete Production support, flexible with work schedules depending upon production issues.
• Involved in Informatica Administration.
• Creating user, folders, folder migration, taking Repository backup in Informatica.
• Informatica Data Quality is used to for data validation.
• Worked with offshore to control design and lead development activities
• Responsible for trouble shooting, data cleansing and data integrity.
• Maintaining multiple databases and customizing reports based on user requirement.
• Extensively working on bug fixes and enhancements.
• Helped in developing best practices for the GI data warehouse.
• Participated in troubleshooting and facilitated transition to system test, UAT and production phases.
• Planned, organized and supervised team activities.
• Participated in most of the user sessions regarding the requirements and design of the system especially about specification of the reports.
• Responsible for troubleshoot and query existing data to identify problems and come up with solutions for data integrity problems.
• Interact with the senior management whenever necessary.
• Designed and developed preprocessors for the incoming data from various sources.
• Database support to the team through production rollout.
• Designed the weekly and daily batches with complex dependencies and schedule them.
• Worked closely with Client Analytics and Marketing users to understand informational needs and business challenges.

Environment: Informatica Power Center 9.1, DB2-AIX64 9.5.2, UNIX AIX 5.3, DBArtisian 8.1.5, SQL server 2008, Oracle 11g, Toad, Windows 2008.

Confidential

Senior ETL Developer

Responsibilities:

• Data Sources dealt with: FACTS Field Activity Tracking System , Proscape vendor software to track presentations , and MyCall Asset Management System.
• Using Informatica Designer, Extract Transform the data from various source systems by incorporating various business rules for different applications by using the different objects and functions which the tool supports.
• Designed the weekly and daily batches with complex dependencies and scheduled them.
• Extracting, staging and loading into the Stage and Core ODS tables, Field Sales Call information from Facts DB2 databases.
• Staging and loading into the stage and Core ODS tables Proscape Data.
• Extracting, staging and loading into the stage and Core ODS tables, MyCall Asset Management Presentation and Screen reference data.
• Created various Documents such as source-To-Target Data mapping Document, Unit Test Cases and Data Migration Document.
• Involved in different Team review meetings.
• Develop joiner transformation for extracting data from multiple sources.
• Created transformation like Lookup, Filters, Expressions, Joiners, Update Strategy and Stored Procedures etc to implement business logic and check constraint integrity.
• Wrote pre-session shell scripts to truncate tables. Post-session shell scripts to Analyze tables and failure/success after completion of workflows.
• Atomized workflows schedule using PMCMD and Unix Shell Scripts.
• Wrote SQL scripts to extract data and load into DB2 database.

Environment: Informatica Power Center 7.1.2, Oracle 9.1.2, SQL Navigator 4.5, UNIX, DB2, ERWIN

Confidential

ETL Developer and Administrator

Responsibilities:

• Helped in developing best practices for the enterprise wide data warehouse.
• Tested all the business application rules with test live data and automated, monitored the jobs using Informatica.
• Upgrade Informatica 5.1 to Informatica 7.1.3.
• I worked as Informatica Administrator throughout the project.
• Developed Informatica mappings, re-usable transformations. Developed and wrote procedures for getting the data from the Source systems to the Staging and to Data Warehouse system.
• Used aggregate, expression, lookup, update strategy, router, and rank transformation.
• Creating user, folders, folder migration, taking Repository backup in Informatica.
• Facilitate end-user procedures development.
• Developed ETL scripts to extract and cleanse data from SQL databases for loading into Cognos
• Administered backups, tuning, configuration, and performance.
• Wrote several queries against Informatica repository to create portable processes and batches and to create reports on the metadata.
• Created Catalogs, Folders, User Classes and reports using Cognos Impromptu and Report.
• Created standard filters, calculation prompts, and conditions

Environment: Informatica Power Center 5.1/6.1.2/7.1.3 Oracle 8i/9i, Cognos 7.1.3, Report Net, UNIX,

Confidential

ETL Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, and metrics and project coordination.
• Involved in the development of Data Mart and populating the data marts using Informatica.
• Check and Tune the performance of application for giving the optimum system performance of the System.
• Created and Scheduled Sessions and Batch Processes based on demand, run on time, run only once using Informatica Workflow Manager.
• Created various Documents such as Source-To-Target Data mapping Document, Backroom Services Document, Unit Test Cases and Data Migration Document.
• Wrote pre-session shell scripts to check session enable/ disable before running/scheduling batches.
• Wrote post-session shell scripts to check status of session like failure/success after completion of all batches.
• Implemented slowly changing dimensions methodology to keep track of historical data.

Environment: Informatica Power Center 6.2, DB2, Oracle 8i, Erwin 4.0, Rapid SQL 7.3.3, UNIX, Autosys.

Confidential

ETL Consultant

Responsibilities:

• Involved in the design of the Star Schema and created Logical and Physical Data Models using Erwin 4.0 Involved in creation of Data Warehouse database Physical Model, Logical Model using ERWIN data modeling tool.
• Using Informatica Repository Manager, maintained all the repositories of various applications, Created users, user groups, security access control,
• Using Informatica Designer, Extract Transform the data from various source systems by incorporating various business rules for different applications by using the different objects and functions which the tool supports
• Tested all the business application rules with test live data and automated, monitored the jobs using Informatica Server Manager.
• Involved in PL/SQL coding that includes Stored Procedures, Packages and Cursors.
• Participated in design of infrastructure to support corporate wide Data Warehouse that includes several Sources and several Data Marts and a central database.
• Extensively used ETL to load data from source systems like Flat Files, DB2, Excel Files, XML and CSV Files into staging tables and load the data into the target database MS SQL Server 2000.
• Involved in designing and developing the Universes using BO designer and created many reports as per the client requirements.
• Participated user meetings regarding the design of reports in the data mart.

Environment: Informatica Power Center5.1, Oracle 8i, SQL Server 2000, MS access 2000, DB2, Erwin 4.0, Toad, Unix, Business Objects 5.0.

Confidential

Informatica Developer

Responsibilities:

• Involved in construction of Logical and Physical data models including star schemas using Erwin.
• Loading data to the Interface tables from multiple data sources such as MS Access, SQL Server, Excel Spreadsheets and Text files via SQL Loader to Oracle database.
• Used Informatica Designer for developing mappings, used various Informatica transformations.
• Implemented performance tuning with the Transformations, Sessions and on the Source Databases to load the data efficiently in to the target.
• Created sessions, batches and also partitions in the session to reduce the time to load data from the existing sources to database.
• Scripts were run through UNIX shell programs for Batch scheduling.
• Created Session and Batches using Server Manager according to the frequency, interdepends.
• Developed data transfer strategy from various legacy data sources
• Created PL/SQL Stored Procedures for various needs of the transformations while loading the data.
• Created Migration Documentation and Process Flow for mappings and sessions
• Created Unit Test plans and involved in primary unit testing of mappings I created.

Environment: Informatica Power Center 5.1, Oracle 8i, Windows NT, UNIX, Excel, SQL Server 7.0, SQL Loader, Erwin 3.5, and TOAD 7.2

Confidential

Senior Software Engineer

• GTP allows multi-protocol packets to be tunneled through the UMTS/GPRS backbone between GSNs and between the SGSN and UTRAN. GTP packets carry the user's IP or X.25 packets.
• The GTP-U protocol is implemented by SGSNs and GGSNs in the UMTS/GPRS backbone and by Radio Network Controllers RNCs in the UTRAN.
• I was involved in the overall design and implementation of the project. The GTPU Layer lies in the 3G network. I was responsible for implementing the code for processing the Peer message. I was also responsible for the unit testing and the integration testing of the project. The Testing was done by Perl Scripts.

Environment: C, Linux