SUMMARY

• 11 years of total IT experience in the Planning, Analysis, Design, Implementation and Maintenance in different domains of Shipping, Manufacturing, Retail, Healthcare, Cable and Telecommunication companies.
• 10 years of strong Data Warehousing experience using Informatica Power Center 9.5.1/8.6/8.5./8.1.1/8.0/7. X (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations), Warehouse Designer, Power Exchange, Power Connect, ETL, DB2, Oracle 10g/9i/8i, MS SQL Server 2005/2000, MS SSIS, Business Objects 6.x/5.x, Power Designer, Web Services & SFDC, Power Designer.
• 8 years of strong Business Analysis experience on Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• 5 years Highly Proficient in Data Modeling, Strong in Data Warehousing concepts, Dimensional, Star Schema and Snowflake Schema methodologies. Complete understanding of Ralph - Kimball and Inmon approaches to Data Warehousing.
• Strong experience in various ERP systems BAAN4, BAAN5, JDE Edwards, Pronto, SAP and Peoplesoft.
• 11 years of experience using Oracle 11g/10G/9i/8i/8.x/7.x, DB2 8.0/7.0, Oracle Exadata, MS SQL Server 2008/2005/2000 , Oracle Exadata, HP Neoview, MS SQL Server & Access 7.0/2000, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000, Win 3.x/95/98/2000, Win NT 4.0 and Sun Solaris 2.x. Experienced in PL/SQL scripts and shell scripting. Strong Experience to databases SQL, PL/SQL, SQL*PLUS, SQL*Loader, DBMS Packages, TOAD & ODBC interfaces to Oracle.

TECHNICAL SKILLS:

Data Warehousing: Informatica PowerCenter 9.5.1/8.6.1/8.5/8.1.1/8.0/7.1.2/7.0 (Source Analyzer, Informatica Power Mart 6.2, (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, and Informatica server, PowerConnect, Power Analyzer, ETL, Metadata Reporter, Data Quality, Data Profiler, Informatica Power Exchange, Metadata, Data Mining, Datamart, OLAP, OLTP, SQL* Plus, SQL*Loader, SFDC, WebServices.

Data Analysis: Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis

Dimensional: Data Modeling Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Power Designer

Databases: Oracle 11g/10g/9i/8i/8.0/7.0, Oracle Exadata, MS SQL Server 2000/7.0/6.5 , DB2, Unix Shell Scripting, SQL, PL/SQL, HP Neoview.

Others: Unix Shell Scripting, SQL, PL/SQL, SQL*LOADER, TOAD, SQL*Plus 3.3/8.0.

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

PROFESSIONAL EXPERIENCE:

Confidential, Miami, FL

Senior Analyst

Responsibilities:

• Improve the existing process by following standards and processes.
• Design and develop Simple to Complex Business rules using Informatica and make them perform better.
• Assist team on complex business rules implementation.
• Involve in migration of the code from lower to higher environments and setup the efficient process in place.
• Closely work with BA and Business for QA & UAT and ensure the deployment of the code to production.
• Support & Monitor the existing business critical applications

Environment: Informatica PowerCenter 9.5.1, Oracle 11g, PL/SQL, MS Office, MS Visio, Linux.

Confidential

Senior Associate

Responsibilities:

• Architect & Design ETL processes for complex business logic and projects.
• Design ETL Load strategy that performs better on Oracle DB.
• Work closely with Offshore and ETL Team lead during the build of the project and make sure the timelines are met.
• Work closely with Business and SME’s for requirement clarifications.
• Develop/Modify/Assist Offshore in ETL Mappings using Informatica Powercenter 9.51.
• Design and Develop PL/SQL procedures for Standard Audit and Data Archival Processes.
• Review Offshore activities and allocate tasks to the teams on day to day basis.
• Work as a Team Lead to assign, monitor, guide and review tasks of the junior developers.
• Work with ETL Admin in Deployment process and guidance.
• Assist & Work with QA Team on System Integration Testing.
• Extensively worked on creating High Level Design documents for multiple projects & enhancements.
• Closely work with Business on a daily basis on User Acceptance Testing and answering queries from the business.

Environment: Informatica PowerCenter 9.5.1, Oracle 11g, PL/SQL, MS Office, MS Visio, IBM AIX.

Confidential, Atlanta

Sr. ETL Architect

Responsibilities:

• Architect the Datawarehouse, Build Datamodel for CCI (Cox Communication) Recruiting Subject Area.
• Design and Modify/Build ETLs to convert the Datawarehouse for the Peoplesoft Upgrade from 8.9 to 9.1 version and also to account for the DataIntegration of CCI data in CEI (Cox Enterprise) peoplesoft application.
• Architect ETL Strategy for Loading data into Recruiting Warehouse.
• Design ETL Load Strategy that would perform better on the Oracle Exadata Database.
• Create Technical Design Document that meets the business requirements following all Industry defined standards.
• Conduct meeting with Business Users & SME for requirement clarifications.
• Review Designs with Offshore Teams and act as a onshore lead for an two offshore teams of Size 10 and 5.
• Analyze and Build data model using Power Designer for Recruiting Subject area, which Sources data from Taleo Application.
• Conduct Daily meetings with 2 Offshore Teams to Clarify On the questions and guide on the Development.
• Work Closely with Report Team (OBIEE) to understand the reporting requirements and adjust the datamodel accordingly.
• Develop/Modify/Assist Offshore in ETL Mappings using Informatica Powercenter 9.51.
• Review Offshore activities and allocate tasks to the teams on day to day basis.
• Review Code developed by Offshore to make sure the function requirements are met and code meets all the Standards.
• Review Unit Test Case, DB Scripts and Migration Document.
• Work Closely with Cox ETL Team and Senior management to report on the Project Status, Timelines and Escalations.
• Work with QA Team in the QA Testing phase and Resolve issues/bugs raised during QA Phase.
• Work with Business Users and Assist/Answer questions during UAT phase.

Environment: Informatica PowerCenter 9.5.1, Sybase PowerDesigner, Oracle Exadata, SQL Loader, Informatica Analyzer, PL/SQL, Flat Files, MS Office, MS Visio.

Confidential, Atlanta

Senior Informatica Developer/ Lead

Responsibilities:

• Designed the Overall system architecture for the APPWORLD Data Hub.
• Create ETL Architecture and design document for APPWORLD Data Hub.
• Documented the development and configuration guides for Informatica PowerCenter.
• Designed Data flow process for integrating various systems into A data hub.
• Designed ETL control and audit process for capturing the Batch load information.
• Developed the data validation, data cleansing process templates in Informatica.
• Developed the Architecture guidelines for the ODS, DW and Data marts.
• Created templates for loading dimensions and fact tables in the Data marts.
• Created POC templates for data acquisition from system of record using PowerExchange for Web Service.
• Architected, Designed and documented the end to end solution approach for the OtC data mart.
• Created Informatica Naming, performance and reusability standards.
• Designed the Exception handling process to capture invalid and orphan records.
• Designed the restartability and recovery process for Informatica workflows.

Environment: Informatica PowerCenter 9.5.1, PowerExchange for Web Service, HP Neoview. Oracle 11g,Oracle Exadata, SAP BW, PL/SQL, Flat Files, MS Office, MS Visio.

Confidential, Florida

Senior Informatica Developer/ Lead

Responsibilities:

• Designed Informatica process and involved in mapping development to load data from different Sources into the target Oracle relational database. Data is migrated by applying business logic using transformations in mapping.
• Worked on upgrading Informatica from 7.1.3 to 8.6.1. Created test plan and tested the migration process.
• Involved in designing the data model.
• Worked on integrating data from different ERP source systems like BAAN, JDE Edwards, Pronto, SAP and Smart Vision
• Worked on extracting data from databases like Oracle, SQL Server 2000, 2005, DB2, Flat Files and Excel files.
• Worked as onsite coordinator & lead for the team of 6.
• Allocated and Monitored daily tasks to offshore team
• Guided offshore team in solution approach, design, development and testing phases of the projects.
• Involved in offshore resource management and project management.
• Created packages in SSIS for ETL processes.
• Involved in requirement clarification meetings with the end users and converting the requirements into designs.
• Extensively worked on creating High Level Design documents.
• Worked on building and maintaining Master Data Management (MDM).
• Extensively followed six sigma processes and methodologies while testing and in root cause analysis.
• Worked on creating re-usable components in Informatica.
• Implemented Error Handling Strategies.
• Writing PL/SQL Stored procedures for processing business logic in the database.
• Tuning of SQL queries for better performance.
• Involved in Unit Testing and preparation of the test cases.
• Extensively involved in User Acceptance Testing and Production Deployment.
• Involved in writing Korn shell scripts to run batch jobs and automating their schedules.
• Worked on Migration of Informatica components, creation of repository users, security control and logs management.
• Extensively involved in the performance tuning of Informatica mappings.
• Prepared a production monitoring and support handbook and Run Book.
• Interacted with business representatives for requirement analysis and to define business and functional specifications.
• Used version control & change control processes.

Environment: Informatica Power Center 8.6.1/7.3, SSIS Visual Studio 2005/2008, HP Unix Windows 2008, PL/SQL, PL/SQL developer, Baan5, Baan4, Pronto, JDE, Oracle, Sql Server, SAP.

Confidential

Oracle UNIX Developer

Responsibilities:

• Level 2 supports for implementation Site Testing of FF4 to new Sites.
• Diagnosis and resolution of user reported incidents.
• Actioning all incidents and requests received from business helpdesk like modification of data, set-up issues and client queries.
• Providing analysis and metrics from problem logging software and periodic status report.
• Root Cause Analysis, Active work to improve the supportability of the system through Process improvement and engaging the development teams in eliminating the root cause.
• Liaising with Product Support Team to prioritize problems reported and arranging for Workarounds until problems are solved.
• Configuration and set-up issues are dealt with.
• The overnight scheduled jobs and any job failures are analyzed and appropriate action is taken.
• Developing tools for automating day-to-day activities: wherever possible routine tasks and procedures are automated simplified and documented.
• Taking major part in the process of Archival and Housekeeping the data.

Environment: UNIX AIX, Oracle 7i, SQL, Shell scripting, Java, AR System (Remedy Tool), BRF Docto.