SUMMARY

• Over 15 years of experience in the Data Warehouse and OLTP Systems analysis, design and implementation.
• Professional experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema in implementing Decision Support Systems
• Professional experience in developing conceptual, logical and physical data model using ER Studio DA,Erwin, Visio.
• Professional experience in designing and developing ETL solutions (ODI, SSIS,DTS, Informatica).
• Professional experience in Data Migration and Conversion and worked on multiple Conversion and migration projects (oracle, SQL server, DB2) in different environment.
• Professional experience in Data warehousing analysis, Data flow documentation, Data cleansing, Data quality validation and Testing.
• Professional experience in Analysis, Design and deploy Enterprise Data Warehouse and successfully performed platform Migration.
• Successfully implemented alerts, backups, data loads etc., using Perl, shell scripting.
• Professional experience in coordinating with PM, SDM and Development team to provide subject matter expertise in developing solutions for various database projects.
• Excellent communication skills, versatile team player and adaptable for new technologies.

TECHNICAL SKILLS

RDBMS: Oracle 11g, 10g (r 1&2), Oracle 9i (Release 2), Oracle 8i, Oracle 8.x (8.0.5), Oracle 7.x (7.1.6, 7.3.4), SQL Server 7/ 2000/2005/2008 , DB2, mysql 3.23/4/5,Access.

Data Modeling Tools: Visio, ER - studio Data Architect(DA), ERWIN 5.1./3.5

ETL Tools: ODI, DTS/SSIS, OWB, Informatica(7.x - 8.x)

Oracle/SW Tools: Enterprise Management Sutudio,OEM 10g, Oracle SQL*Loader, RMAN, Data Guard, Oracle Enterprise Manager (9i/10g/11g), Export/Import, SQL Trace, TKPROF, Replication, Manager, DBArtisian, TOAD, DBARTISAN, SQL*ReportsLanguages SQL, PL/SQL 8i/9i, Perl, Shell Scripting (Bourne, Korn),JAVA1.2/1.1, CFML,PHP, C.

OS Environment: Sun Solaris 10/9.0/8.0/2.7/2.6 , Red Hat 9/8/7.x/6, HP UX 11i/10.0, AIX 5L/5.2/4.3/4.2/, Microsoft Windows 9x/NT/2000/XP/2003, VeritasVolume Manager, Veritas Cluster File System, Net Backup,Tivoli Storage Manager, Legato Networker.

Hardware Systems: Sun Fire (V480, V240, 880), Sun Ultra-Enterprise, Sun SPARC (E6500, E5500, E450, E250), HP-9000, IBM RS/6000, and Intel 486/P5/P6 PC's DELL Power Edge (2400, 2450, 2650, 2550, 1650)

Monitoring tools: Sitescope, Tivolimon and openview

PROFESSIONAL EXPERIENCE

Confidential, Seattle WA

Sr. Data Warehouse Consultant/Lead

Responsibilities:

• Lead team and coordinated various projects on systems upgrade and design atchitecture enhancements for various source systems upgrades.
• Designed ETL process for various sources systems and designed reports.
• Designed Capitation and premium modules and integrated in the data warehouse.
• Designed the Pharmacy module and enhanced ETL process for the data loads.
• Designed the Data extracts for various vendors for claim recovery. (ETL and data Modules).
• Evaluated, designed and implemented Change Data Capture (Attunity Replicate).
• Designed and developed etl and reports for eligibility,claims,provider,Pharmacy data.
• Designed and lead project on claim processing system upgrade (xcelys 6.3)
• Designed and lead Project on Medical Mangement system (Jiva 5.2)
• Designed and developed OLAP Cubes (Claims,Pharmacy, Eligibility and members)

Environment: s: Oracle 10g/11g, Oracle 10gR2 RAC /11g r2 RAC, SQL server 2005/2008, ER Studio Data Architect, SSIS, SSAS, SSRS, sqlplus, OEM 10g/11g, AIX 5.2/4.5/4.2, RedHat AS 2.1 / Red Hat Enterprise Linux 4.0/5.0, Windows/2003 (AS) /2008.Attunity Replicate 2.0, Opalis,Jiva 4.5/5.2,Xcelys 5.x/6.3

Confidential, Irving TX

Sr Data Warehouse Consultant /Tech Lead (Oracle and SQL Server)

Responsibilities:

• Lead team and cooordinate on various project along side with Global resources from India to meet tight project timelines.
• Coordinated with Project Manager and Clients for requirments on various projects and Designed Database architecture and provided estimates for database setup part of the project.
• Designed (LDM and PDM) and deployed the Enterprise Data Warehouse (EDW) by consolidating individual business units(telecom,business and wireless) into Data Warehouse. This is an effort towards having centralised warehouse enterprise wide.
• Involved in designing Data Marts and worked with users to enchance design for new requirements and troubleshoot performance issues.
• Coordinated with various teams (source for DW) and disigned and setup interfaces for DW.
• Designed database migration strategies and implemented database migration from Windows (orace 10g ) to Linux RHEL 4 (Oracle 11g).
• Coordinate and work with various Techinical/Business teams from different departments on Enterprise Warehouse migration project.This is project to consolidate data warehouse from different busniess units to one Enterprise warehouse through out Confidential .
• Evaluated and impleted ODI ( Oracle Data Integrator) ETL tool to replace all the current and legacy etl processes.
• Lead team and coordinated project on SQL 2008(Failover cluster intallation) upgrade and DTS to SSIS conversion.
• Designed and configured drivers and data sources for various source database(oracle,SQL Server, DB2, file) to warehouse (oracle).
• Migrated AWARE Data Warehouse from windows (Oracle 10g) to Linux (oracle 11g on RHEL) and extensively worked on conversion of windows batch scripts to unix shell script for various processes.
• Extensively worked with developers and DBA on tuning various ETL processes and addressed performance issues.

Environment: s: Oracle 7.X/8.X/8i/9i/10g/11g, Oracle 10gR2 RAC /9i r2 RAC, SQL server 2000/2005/2008 , Oracle Data Integrator(ODI), Oracle Designer, ER Studio, Toad 7.3, Informatica 8.x, Unix Shell Scripting, sqlplus, OEM 10g,Enterprise Manager 9i,Weblogic 9,EMC Storage, statspack, Veritas Storage Foundation for Oracle RAC,, Sun Solaris 10/9/8/2.7, AIX 5.2/4.5/4.2, HP UX 10.x and 11.x, RedHat AS 2.1 / Red Hat Enterprise Linux 3.0Windows NT/2000/2003 (AS) /XP.

Confidential, Denver,CO

Sr. Database consultant(Data/ETL)

Responsibilities:

• Coordinated and designed database migration strategies to migrate data to five new companies from Cendant Corporation (cendant split to five new companies).
• Worked with PM for various RFS (Request for Service) Projects and Coordinate with SDM’s (Service Delivery Mangers) on various projects to provide subject matter expertise for customer requirements and troubleshooting Data Issues.
• Coordinated with GR (Global Resources) DBA’s and Application developers to achieve project meet project timelines.
• Worked on designing the ETL process(design specification, mapping) with various source systems and integrated with Enterprise data warehouse.
• Worked on developing strategies for Data migration on for five company as they split to different independent clients/companies.
• Worked on design and develop database object for Lawson HR Applications production/dev/test environment upgrade to 8.03 and Upgraded BSI tax factory (have W2, etc information) to 7.0.g.1 performed schema changes, data loads and parallel testing of payroll data.
• Maintaining 24/7 mission critical production databases about 200 + which support Enterprise Business Suit 11i,CRM,Lawson,Oracle Financials, Real Estate, Oracle HR and J2EE Applications.
• Performance tuning of SQL statements, rollback segments, recreating indexes and collecting stats on the basis of statspack report in order to compare the performance issues.
• Analyzed and tuned performance for instance and databases.
• Installing, configuring and administering Oracle Servers. Planning, Designing, Developing and maintaining databases for production/test/Dev and Lab environments.
• Active member in leading the Database and Analytic team in designing and deploying various projects along with PM’s, SDM’s and customers.

Environment: s: Oracle 9i/10g/11g,SQL Server 2000/2005, Oracle 11g/10gR2 RAC, Data guard 9i/10g,Replication Manager, DBArtisian, Toad 7.3, Oracle Data Integrator 10g, Unix Shell Scripting, sqlplus, OEM 10g,Enterprise Manager 9i,Lawson 8.0,Weblogic 9,EMC Storage, statspack, Veritas Storage Foundation for Oracle RAC,, Sun Solaris 10/9/8/2.7, AIX 5.2/4.5/4.2, HP UX 10.x and 11.x, RedHat AS 2.1 / Red Hat Enterprise Linux 3.0Windows NT/2000/2003 (AS) /XP.

Confidential

Systems Engineer/ Database Architect

Responsibilities:

• Designed Database and developed ERD using Erwin 3.2/Visio 2002 Professional for various products and provisioning system.
• Designed and developed LDM and PDM for Corporate Customer Portal and SSO system.
• Designed and developed LDM and PDM for Corporate Customer Provisioning system. Worked on ETL specification and developed mapping for various modules.
• Designed and developed Asset Tracking System(ATS) database to support asset tracking enterprise wide.
• Desinged and developed SingNet Broadband Authentication System and developed data loads from vaious provisioning system realtime.
• Designed dailup and broadband customer billing module and intergrated with Corporate Billing systems.
• Designed and developed data loads for various source systems and integrated to data warehouse .
• Created materialized view for data replication on oracle 9i. Import tables and/or schema as requested for various application databases.
• Analyzed and tuned performance for instance and databases. Analyzed and tuned performance for Oracle Applications.
• Performed Performance tuning at various level of database for multiple databases oracle and SQL Server.
• Assisted the Oracle Developers in SQL tuning for various applications.
• Furnished Oracle expertise and advice. Answered questions about the infrastructure standards, procedures, and contacts.

Environment: Oracle 8.0/8i/9i, Oracle 9i Data Warehousing, Oracle 8i, Informatica 7.1,SQL Server 7/2000, Visio, Oracle Warehouse Builder 9i, Business Objects 5.1/4.0, Veritas Netbackup, SQL\PL-SQL, java, Perl, php, JavaScript., Unix Shell Scripting, Unix CRON jobs, ER WIN 5.1, Sun Solaris 8.0/2.7/2.6, HP-UX 11.0,AIX 4.2, RedHat 7.3/8/EL-AS-2.1, Windows NT/2000 Advance Server.

Confidential

Database administrator /Analyst

Responsibilities:

• Responsible for the administration, support, and performance tuning of multiple development and production Oracle databases (Oracle 7 and 8).
• Involved in all database related projects providing assistance with all aspects of design and implementation as well as doing development in PL/SQL and UNIX shell script for various customers like Softpath Pvt. Ltd India, Ramson Industries, Pvt. Ltd, and others.
• Installation and Configuration of Oracle (7.1.6, 7.3.2.3, 8.0.5).
• Created the data model, table/index definitions (DDL), installation of all Oracle software, creating several databases using the most current Oracle features such as partitioned views, read-only tablespaces, parallel query to name a few.
• Performed post-production database tuning by reviewing the database's SQL statements as well as database and O/S review
• Installation and Configuration of Oracle7.3 and Applying Patches both Server side and Client side.
• Developed backup and recovery strategy utilizing UNIX scripts to perform hot backups, cold backups, DDL exports and database restores by reading a parameter file, which indicated the backup type to be performed.
• Tuning SQL statements by using SQL trace (tkprof) and Explain Plan utilities so as the data retrieval path is optimized.
• Responsible for fine tuning and optimizing the Oracle load process; reviewed SQL code, load programs and operating system parameters to achieve the most efficient load process possible.
• Performed post-delivery benchmark activities to improve overall performance; found (and corrected) deficiencies with respect to indexes, constraints and stored procedures.
• Developed Forms, Reports, Graphics and PL/SQL programs.
• Involved in designing the Forms, Coding and generating various reports for the Registrations, Diagnostics and Billing Modules.
• Creating tablespaces/datafiles, users, schema, tables and roles for each site and hub databases.
• Creating indexes to improve system performance.
• Monitoring these Indexes for future alteration on the basis of new applications based on indexed Tables and using these to the maximum in applications.
• Developed reports for registrations and Diagnostics
• Developed billing modules and database API, Unit testing and Module testing.
• Interact with users, document change requests, customize records, panels, menus, develop interfaces, report and batch applications.

Environment: s: Oracle 7.X/8, Developer2000 (Forms 5.0/4.5, Reports Writer 2.5, Graphics 2.5), PL/SQL 2.3, SQL 3,SQL Backtrack, Sun Solaris 2.6,Enterprise Srever3500, Ultra5/10, Line Terminal Server, COMPAQ Proliant 1500, WinNT4.0, WinNT workstation, Win95,Windows 95/NT.