Summary

• 12 years of extensive experience in Enterprise Information Management end-to-end Data Warehousing, Data Integration Data Migration. Developing Data Warehouse roadmap, strategy and architecture, dimensional datamarts and reports.
• Expertise in Logical Physical Designing of Databases, Data Modelling, Conceptual Design Data Architecture.
• Expertise in writing procedures, functions, triggers and packages using PL/SQL.
• Oracle Certified DBA OCP , experience in database administration methodologies in Oracle.
• Experience in ETL using Informatica 7.x, 8.x, 9.x with Oracle 8.x, 9i, 10g and 11g versions.
• Experience in SQL Loader, Export Import utilities.
• Excellent knowledge in Salesforce Force.com with migrating Cloud data to Oracle 11g
• Expertise in Maintenance of Oracle Data Warehouse
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Application Data migration from IDOL4 to Oracle 9i, 9i to 10g and 10g to 11g
• Monitored and tuned database performance including SQL tuning and database tuning.
• Worked with development and operations team and resolved problems quickly and efficiently.
• Excellent interpersonal, analytical and communication skills.

Technical Skills

Experience

Confidential

Tech Lead - Onsite

Responsibilities

• Extensively interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• System Study and Analysis on OOR sytems and SFDC system on intergrating the application data
• Design reviews, code walkthrough and developement in Oracle PL/SQL, Functions, Stored Procedures, triggers and Application Backfill Scripts
• Created salesforce External loader application and connect to salesforce.com for migrating the CRM data
• Developing application data model design and architecture
• Creating ETL mappings in Informatica and performing data migration between various applications.
• Regular data migration of the existing OOR system data into SFDC CRM system
• Translated Business processes into Informatica mappings by using Informatica Designer which populated the Data into the Target system
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Onsite and Offshore coordination to clarify the requirements and provided technical assistance.
• Environment: Informatica PowerCenter 9.x, PowerExchange 9.x, Oralce 11g, Salesforce.com, Unix Scripts, PL/SQL, Toad, PL/SQL developer, Caliber, Dimensions

Confidential

ETL Developer Onsite

Responsibilities

• Involved in detailed analysis of requirements and creation of requirement specifications and functional specifications.
• Involved in the development of SQL Scripts PL/SQL stored procedures, functions and packages to process business data in OLTP system.
• Performance tuning of SQL and PL/SQL
• Creating dimension and fact tables,Involved in design activities of logical/physical data model
• Preparing the high level and low level design documents for ETL Mappings
• Developed mappings, sessions and workflows in Informatica Power Center.
• Resolving issues related to OLAP and Stored procedures in OLTP.
• Performed tuning of sessions in Target, Source, Mappings and Session areas
• Worked with production support team to resolve the data issues
• Environment: Informatica PowerCenter 8.x, Oralce 10g/11g, PL/SQL, Toad, Caliber, Dimensions

Confidential

ETL Developer Onsite/Offshore

Responsibilities

• Carrying out Requirement study and impact analysis. The requirement document is logged in using Caliber Tool for configuration.
• Designed the source to target mappings that contain the business rules and performed the extract, transform and load process using Informatica ETL Tool.
• Developing Oracle PL/SQL ,UNIX Scripts to perform data migration in the Datamarts
• Using Informatica and Abinitio ETL tool for moving data across databases, also involved in Address Cleansing using tool Trillium.
• Perfomance Tuning in SQL and PL/SQL scripts.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Workflows and the Target Data.
• Developing Web based reports for the Affinium Campaigns using JSP
• Environment: Informatica PowerCenter 7.x, Abinitio, Trillium, Oracle 10g, PL/SQL, Toad, Caliber, Dimensions, Affinium, JSP

Confidential

DBA Member PL/SQL Programmer

Responsibilities

• Migrating Data from IDOL4 database to ORACLE 9i database.
• Data mappting between the legacy system and new system
• Writing Stored Procedures in Oracle.
• Designing Backup and Recovery process and its implementation.
• Monitoring the tablespaces periodically for growth.
• Responsible for creating the different tablespaces for partitions, indexes and tables.
• Experience in SQL Loader, Export Import utilities.
• Environment: Oralce 9i, PL/SQL, SQL Loader, Unix

Confidential

Programmer

Responsibilities

• Writing Oracle stored procedures and Scripts
• Experience in SQL Loader, Export Import utilities.
• Creating tables, indexes and other Oracle objects
• Developing web interfaces using JAVA,JSP and Servlets
• Environment: Oralce 8i, PL/SQL, Java, JSP, Servlets