SUMMARY:

• Have been in the IT industry for over 20+ years and during this period involved in a number of projects across many industries including Banking and financial services, Manufacturing, Government, Healthcare, Printing and publishing, Retail, Travel and hospitality.
• Technical experience includes roles as ETL /BI/ OLTP/Data warehouse / Data Migration/Integration consultant, Oracle Developer, Informatica/DataStage Team Lead/Developer, Siebel EIM consultant.

TECHNICAL SKILLS:

• Oracle Database (worked on all versions 5.x to 11g)
• PL/SQL, Oracle Utilities, performance tuning
• DB2, SQL*SERVER (2000/2003), Confidential - SQL
• SIEBEL - CRM
• Unix (Aix, Sun Solaris)
• Unix shell scripting
• Database design, modeling
• Data warehousing (Design, ETL. Tuning)
• Data Conversion/Migration, Integration experience
• Banking, Financial services experience

PROFESSIONAL EXPERIENCE:

Confidential, Morrisville, NC

Sr. Consultant - Informatica & Oracle

Responsibilities:

• Led the development effort single handedly, to deliver the solution for this complex project. Used complex transformations (JMS, XML Parser, XML Generator) to receive and process, Java transformation (to remove non Unicode characters, data type validations), Shell scripting (to pass the results to Audit/Log tables), session/workflow/mapping variables to pass information between jobs.
• Also involved in Knowledge transfer to developers /QA team in Poland and Singapore new to Informatica, did code / design review and provided support to QA and UAT during testing.

Environment: ORACLE 11g, Informatica Powercenter 9.5, PL/SQL, ETL, UNIX Shell Scripting, JMS (messaging), Teamcity, Subversion (Tortoise), LINUX, windows, MS - OFFICE, MS Power point, SQL Server, Oracle.

Confidential, NC

ETL Consultant

Responsibilities:

• Work with CAPGEMINI team to ensure smooth transition to the new team.
• Work with Business analyst, lead in preparing technical mapping documents (MAPDOC) from Business requirements.
• Design and develop ETL jobs to extract data from various sources and load into the ERM data warehouse
• Develop Adhoc DB scripts using ANSI SQL.
• Develop UNIX shell scripts for the jobs to be scheduled from ESP job scheduler.
• Perform unit testing and co-ordinate with the QA team for the system integration testing etc.
• Preparing necessary Artifacts, approvals etc. for code migration to Prod and QA environments.

Environment: DB2 UDB, Informatica 9.5, 8.6.1, ESP (Job scheduling), UNIX Shell Scripting, SAS 9.3, SharePoint

Confidential, NC

Consultant

Responsibilities:

• Participate in the design workshop with all stake holders and translate business requirements into technical specifications.
• Design and develop ETL jobs to extract data from Siebel CRM and provide onetime, daily, monthly feeds to downstream systems (Enterprise data warehouse (eDB), OBAW) using Informatica and PL/SQL.
• Develop Unix shell scripts for the jobs to be scheduled from Control M
• Perform unit testing and co-ordinate with the QA team for the system integration testing etc. Also, prepare code deployment builds and work with DBAs to migrate to SIT, UAT and Production environments.
• Participate in code review meetings and mentor junior developers.

Environment: ORACLE 11g,Oracle Streams (Golden gate),OBAW(Oracle Business Analytics Warehouse), Siebel CRM - 8.x, Informatica 9.0, 8.6.1, PL/SQL, Control M, Unix Shell Scripting, SharePoint, MS - OFFICE, MS Power point

Confidential, RTP, NC

Consultant - Informatica

Responsibilities:

• Design and documenting overall ETL framework for the CPS data warehouse system
• Design and develop ETL jobs to extract data from clients (Fannie Mae, BoFA, JPM Chase, Metlife, Capital one etc), Enterprise data warehouse and corporate reporting systems, using Informatica, TSQL and DB2-SQL.
• Develop import scripts to load data into data warehouse in DB2.
• Develop and schedule jobs using Autosys and Windows batch files.
• Provide 1st level of support

Environment: SQL SERVER, DB2 9.1 UDB, Informatica 9.0, Confidential -SQL, ANSI SQL, Data Architect, Data Studio, Autosys, MS Visio, MS Project, MS - OFFICE, MS Power point

Confidential, Durham, NC

DWH consultant - Informatica & Oracle

Responsibilities:

• Reviewing existing ETL architecture, processes and making recommendation.
• Documenting ETL framework
• Developing Informatica jobs
• Developing mapping for MDM data synchronization with Staging, ODS and Data Mart

Environment: Oracle 11G, UNIX (Solaris), Informatica 8.6.2, 9.0 Oracle PL/SQL, PL/SQL Developer, TOAD, Unix Shell Script., SQL*Loader, Data pump, MS Visio, MS Project, MS - OFFICE, MS Power point

Confidential, Morrisville, NC

Sr. Data warehouse Engineer - Informatica & Oracle

Responsibilities:

• Redesigning and migration of ETL processes from PL/SQL to Informatica.
• Analyze source data from custodians and other 3rd party (Pershing, Bloomberg, and Volaris). Prepare design specifications, mapping documents, develop and test ETL jobs in Informatica.
• Preparing design and workflow documentation (mapping, Business process, dataflow diagrams, and Business process diagrams)
• Design and developing mappings for reference data synchronization with data warehouse
• Monitoring and tuning database, ETL processes for optimal performance. Implement best practices wherever possible.
• Work and deliver in fast paced projects using agile methodology.

Environment: Oracle 11G, UNIX (Solaris), Informatica 8.6.2, Oracle PL/SQL, PL/SQL Developer, Unix Shell Script., SQL*Loader, Data pump, MS Visio, MS Project, Control M, Informatica Power Center 8.5.1, MS - OFFICE, MS Power point

Confidential, Rockville, MD

Senior Database Engineer

Responsibilities:

• Meet with business stakeholders and other technical team members to gather and analyze application requirements
• Design database solutions to satisfy application (business and technical) requirements
• Implement database solutions using available database development tools
• Preparing design and workflow documentation (mapping, Business process, dataflow diagrams, and Business process diagrams)
• Redesigning and migration of ETL processes from PL/SQL to Informatica.
• Developed frame work and best practices documentation.
• Provide written status reports to management regarding project status, task, and issues/risks
• Involved in NRT (near real time) implementation project.

Environment: Oracle 11G, UNIX (Solaris), Oracle PL/SQL, Informatica 8.6.2, Oracle Designer, TOAD, PL/SQL Developer, Unix Shell Script., SQL*Loader, Data pump, MS Visio, MS Project, Clear Case, SharePoint, MS - OFFICE, MS Power point

Confidential, New York

ETL Team Lead/BI

Responsibilities:

• Gather business requirements.
• Document, design and develop end-to-end ETL processes in PL/SQL.
• Mapping data from different sources (internal system and external data sources like Bloomberg) to target system (Fermat DWH)
• Implemented CDC (change data capture) mechanism for the daily data feeds.
• Develop PL/SQL scripts (package, procedures, functions, ETL scripts) using Oracle collections (Bulk collect, Forall), merge, global temporary tables, external tables, parallel processing, analytical functions etc.
• Develop, test and fine tune ETL scripts (PL/SQL/ DataStage) and jobs
• Introduced coding standards and best practices for PL/SQL script development
• Develop Unix shell scripts to trigger ETL jobs at specific time and also based on the file arrival in the inbound area
• Re-engineering PL/SQL Scripts to DataStage with common re-usable components
• Provide 1st level production support (PL/SQL and DataStage)
• Developing PL/SQL scripts to extract and load data on to BI database using OBIEE for management reports, Dashboards etc
• Project plan and resource estimation for roll-outs to 17 countries worldwide
• Managing and mentoring team of 5 (both permanent and contract staff)
• Participate in weekly project working committee (PWC) and user group meetings
• Integrate with Mind Align (messaging tool)for job completion notifications, job failure, late arrival of files etc
• Involved in developing common ETL framework in DataStage with Confidential consultants
• Reviewed source data and recommended data acquisition and transformation strategy.
• Involved in conceptual, logical and physical data modeling and used star schema in designing the data warehouse.
• Worked closely with business analysts and business intelligence development team with the primary focus on ETL design. Development and support. gathering requirement, Proof of concept, gap analysis, design, development, Testing and Implementation of data warehouse
• Extensively involved in developing ETL processes, loading and validating data from source systems into data warehouse using Informatica 8.5.1 and Oracle SQL, PL/SQL procedures.
• Involved in unit testing, integration testing and system testing.
• Load and generate dashboards for the Global financial risk management group.
• Designed and developed separate unified single window dashboards for internal use (production support team) to monitor the ETL loads, reporting on the load time, configuration changes, reconciliation between the source and target data, exceptions etc.
• Performed day to day administration of OBIEE servers/services (starting/stopping services, repository migration, configuration changes, user accounts maintenance etc).

Environment: Informatica Power Center 8.5.1, Oracle 10G Rel.2, DB/2 (Data Stage repository), UNIX (Solaris), Oracle PL/SQL, Oracle business intelligence enterprise edition 10.1.3.4, Control M, TOAD, PL/SQL Developer, Unix Shell Script., SQL*Loader, Data pump, MS Visio, MS Project, Clear Case, Mind Align, SharePoint

Confidential

Consultant

Responsibilities:

• Gather business requirements.
• Data mart design and modeling
• Develop scripts for dala cleansing, data enrichment and data de-duplication
• Data mapping between Ecommerce system and the data mart
• Designing batch data feeds
• Develop and implement solution
• Vendor evaluation & Selection.
• Project management
• Develop and implement customized bar code integration solution
• Data mapping between Ecommerce system and the data mart
• Develop and implement solution
• Manage a team of 4 members

Environment: Oracle 9i, Oracle PL/SQL, J2EE, Java, Apache, Windows 2003, MS Visio, MS Project

Confidential

ETL / Data Migration Consultant

Responsibilities:

• Requirement study.
• Data mapping between Peoplesoft and Siebel applications.
• Designing and developing ETL scripts to provide data feed to DSS warehouse.
• Preparing EIM data mapping document and sign-off
• Developing PL/SQL Scripts to migrate data to Siebel EIM tables
• Performance improvement using Bulk collect, SQL tuning, DB tuning
• Creating and testing Siebel data loading scripts (ifb) to populate data from EIM repository to Siebel tables.
• Preparing test plans and scripts
• Working with Confidential & Siebel technical team to resolve issues.
• Assisting in System testing and integration testing.

Environment: Oracle 9i, Siebel 7.5, Siebel EIM, Oracle PL/SQL, SQL Developer, SQL*Loader, UNIX, Windows

Confidential

Data Migration Consultant

Responsibilities:

• Performing data analysis and Data mapping between the Legacy systems to the target Siebel CRM intermediate (EIM) repository.
• Handling sensitive data related to child abuse and case history during migration
• Mapping and converting data from external sources (MS-ACCESS, flat files, Excel) to Siebel tables.
• Developed PL/SQL scripts to load the data from common repository to Oracle database based on the business rules. Incorporated provisions for recycling rejected data during conversion. Developed packages and procedures for common routines such as balancing reports, handling rejected data etc.
• Tuned the conversion scripts to maximize throughput
• Estimation on store space, table and index sizing and database tuning to improve performance.
• Developed generic scripts to load data to common repository through SQL*LOADER.
• Established balancing checks to ensure that the data balances with the input after conversion at each stage. This is in the form of reports/enquiry through PL/SQL.
• Automated the whole conversion process execution using UNIX shell scripts.
• Interacting with Siebel team (Accenture) and SAP team on data mapping and conversion issues.
• Developing and implementing ETL scripts and automated data load process
• Provide input to the Data Conversion Manager on progress and status of tasks for inclusion in the weekly status report.
• Post Go-Live Support

Environment: Oracle 9i, Siebel 7.5.3, Siebel EIM, Oracle PL/SQL, SQL Developer, SQL*Loader, UNIX, Windows, SAP (FI/CO), UNIX Shell Scripting

Confidential

Systems Developer

Responsibilities:

• Developing / maintaining application using Pro*Cobol, Oracle Forms/Reports 6i, PL/SQL
• GAP analysis
• Developed new modules on negotiated interest rates, securitization, eBill payment etc
• Developed new reports for Australian treasury regarding money transfers exceeding limits, inactive accounts and on susceptible fund transfers.
• Testing and post go-live support

Environment: Oracle 9i, COBOL, Oracle Forms/Reports 8i, PL/SQL, TOAD, shell scripting, SQL*Loader, UNIX, Windows.

Confidential

Development team Lead

Responsibilities:

• System Study and design.
• Developing application using ColdFusion, TSQL.
• Migrating data from client database (Eastern Palliative care) database in Oracle to SQL*SERVER.
• Migrating HL7 data to database
• Managing a team size of 5 people.
• Database and application tuning.

Environment: SQL/SERVER 2000, ColdFusion, Transact SQL, Apache Linux, Windows