SUMMARY:

• 13 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, Dimension and Fact Table Data Modeling, Conceptual Design Data Architecture.
• Expertise in Data Analysis, Data Profiling and Maintenance of Oracle Data Warehouse
• Expertise in Data flow diagram, Slowly changed Dimensions, Star Schema and Snowflex Schema model
• Experience in ETL using Informatica 7.x, 8.x, 9.x with Oracle 8.x, 9i, 10g and 11g versions.
• Excellent knowledge in Salesforce Force.com with migrating Cloud data to Oracle 11g
• Experience in Waterfall and Agile project life cycle methodologies
• 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.
• Expertise in writing procedures, functions, triggers and packages using PL/SQL.
• Oracle Certified DBA OCP , experience in database administration methodologies in Oracle.
• 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 SKILL:

EXPERIENCE:

Confidential

Data Analyst

• The Coalition program will enable Nationwide Insurance to:
• Build brand equity through exclusive participation in the coalition and affiliation with other partner brands e.g., home improvement
• Improve customer satisfaction by recognizing member loyalty
• Discover new insights into consumer behavior that improves marketing effectiveness in driving new customer acquisition

Responsibilities

• Business, User and IT Requirement gatherings, and detail discussions with Business and Analyst team
• Requirement study, System study analysis, Data profiling and Data analysis to meet the business requirements
• Working with Business and Analyst teams to translate business and system needs into IT Requirements.
• Involved in conceptual/logical and physical data models to meet the business and IT requirements.
• Creating the Data analysis, Data mapping and design documentation for the IT requirements.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
• Involved in analysis of the given data in any format such as XML, Table, Web service, flat files and provided the accurate inferences, in accord with the objectives of the analysis
• Gathering required data to conduct analysis from several source systems, cleansing, transformed and integrated into the target system
• Developed Oracle PL/SQL programs, mappings, sessions and workflows in Informatica Power Center.
• Coordinating with external teams for interface related issues and making sure it gets resolved in time for consistent performance of the system

Environment: Informatica PowerCenter 9.x, Oracle 11g, Erwin, Toad, Rational Requirements Composer, XML, J2EE

Confidential

Data Analyst

CTL Out of Region Ordering OOR SFDC Salesforce Dot Com INT integrating the legacy systems OOR Oppty, Quoting/Ordering, Product catlog, Customer Hub and Inventory with Salesforce CRM system SFDC . Migrating the existing and current oppty, quoting, ordering, and customer Hub data with new SFDC cloud system to create one stop CRM solution for Centurylink. Migrating and processing the SFDC cloud data with proxy database for business analysis, reports and decision making

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
• Responsible for designing the complete application Data model design and architecture
• Involved in Data Analysis, Data Profiling for the source and target system
• Created salesforce External loader application and connect to salesforce.com for migrating the CRM data
• 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.
• Creating ETL mappings in Informatica and performing data migration between various applications.
• Design reviews, code walkthrough and developement in Oracle Functions, Stored Procedures and Application Backfill Scripts
• 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, Erwin, Visio, Control-M, Caliber, Dimensions

Confidential

ETL Developer/ Data Analyst

The Enterprise Markets Group EMG of CenturyLink business unit is particularly complex with complex IT systems and applications catering to the enterprise needs in the areas of Ordering, Provisioning and Billing. To accomplish the growth targets launching new products and services and to ensure customer satisfaction. EMG application provides complete picture about Enterprise and WHSL customers, opportunities, quotes, orders, provisioning and events. The users able to track the status of submitted quote, orders, monitor the progress, manage fallouts, provisioning, billing and etc

Responsibilities

• Involved in detailed analysis of requirements and creation of requirement specifications and functional specifications.
• Creating dimension and fact tables, involved in design activities of logical/physical data model
• Involved in Source and Target Data profiling , Data analysis, Data mapping, Data cleansing
• 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.
• Involved in the development of SQL Scripts PL/SQL stored procedures, functions and packages to process business data in OLTP system.
• 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, Erwin, Toad, Control-M, Caliber, Dimensions

Confidential

ETL Developer

Qwest Marketing Strategic Organization MSO Corp is a part of the larger MDSS Marketing Decision Support Strategy program of Qwest. Qwest owns companies involved in domestic and international telecommunications, cable and wireless networks, directory publishing and interactive multimedia services. MSO contributes significantly to the MDSS Group's marketing strategies by providing fast delivery of marketing-specific information to the clients to target and segment markets, identify market opportunities and assess competitive threats.

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, SQL Loader 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 9i Application Server, Oralce 10g, PL/SQL, Toad, Control-M, Caliber, Dimensions, Affinium, JSP

Confidential

DBA Member PL/SQL Programmer

DataMigration provided the data management expertise for the analysis, Data Migration and assessment of Data readiness from legacy system to new CRM application. Assessed Data Resource Management activities, overall data architecture, and ETL processes. Provided insights, findings and recommendations for next steps culminated into a customer roadmap for CRM development / implementation

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

• AutoPac deals with the automation of dealer management system for automobiles. It is an exceptionally powerful management information tool, an aid to control and a vital asset in business development and progress. The system consists of the following integrated modules, namely:
• New Car Sales
• HRMS
• Stock Management
• Service

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