SUMMARY

• Over 15 years in data architecture and data management, including data modeling, Master Data Management, data analysis, data integration, database administration and data conversion
• Performed logical and physical design for Online Transaction Processing (OLTP) and Data Warehouse (OLAP) databases using Erwin
• Performed logical and physical data modeling for DB2 UDB and Oracle platforms
• Business domains included supply chain and global trade management, banking, securities trading, insurance and healthcare, biotech, CRM and eCommerce.
• Master data management and CRM experience included Siebel 7 Marketing, eClinical and ePharma verticals
• Familiarity with Hadoop and decision trees
• Excellent communication skills
• Recently took consulting assignments while focusing to relocate parents to another state

TECHNICAL SKILLS

Databases: Oracle V8, V9 & V11; SQL Server; Vertica; DB2 UDB (UNIX); MySQL, Informix SE, dBase Clipper

Languages: Oracle PL/SQL, SQL, DB2 SQL PL, C - language, Perl, Informix 4GL, SAS, Cobol

Data Modeling Tools: Erwin, ER/Studio

Software Packages: Siebel CRM, Peoplesoft ERP, Oracle Clinical System

Operating Systems: AIX, HP-UX, Solaris, SCO UNIX, MS Windows, MVS

PROFESSIONAL EXPERIENCE

Confidential

Data Architect Consultant

Responsibilities:

• As a data architect and data modeler documented and enhanced CRM BI data model.
• Created stored procedures for CRM datastore data profiling.

Environment: Erwin, Vertica, SQL Server

Confidential

Data Architect

Responsibilities:

• As a data architect performed data modeling and data migration for financial investment CRM data repository.

Environment: Erwin, Oracle 11, SQL

Confidential

Data Architect

Responsibilities:

• As a data architect performed requirements analysis, logical and physical data modeling for enterprise data warehouse while complying with corporate standards.
• Maintained data dictionaries and integration of systems through database design
• Supported and mentored development project teams.
• Projects included fraud management, benchmarking and infrastructure management applications.

Environment: Erwin, DB2 UDB V9, SQL, IBM Data Studio

Confidential

Data Architect

Responsibilities:

• Designed and implemented a referentially consistent archive and purge process for Supply Chain management application.
• Performed data analysis and data cleansing in support of a large retail store chain customer of the Global Trade Management system.
• Developed data model for the next generation of Global Trade & Supply Chain management application based on canonical OAGIS (Open Applications Group) mode.
• Designed and developed data migration of the Restricted Party screening to the new platform.
• Provided support to the DBAs in database configuration and data validation during conversion to Oracle 11G RAC environment.
• Made performance index recommendations.
• Restructured SQL statements to improve database performance.
• Facilitated communication and exchange of information between customer management, development, QA testing and DBA groups.
• Mentored development engineers in use and optimization of SQL.

Environment: Oracle V11G R1, Oracle GRID, Erwin, SQL, PL.SQL, TOAD, MySQL, Cassandra

Confidential

Database Consultant

Responsibilities:

• As a database consultant for health insurance underwriting applications development team, performed data modeling, data mapping and data analysis, as well as data load of the legacy data and data integration.
• Mentored team members in Erwin, SQL and PL/SQL.
• Assisted underwriting team in building new applications based on the new National Pricing Database.

Environment: Erwin, SQL, Oracle V10, TOAD, Jasper Reports, MS Access, DB2 UDB V8, Windows

Confidential

DB2 DBA

Responsibilities:

• As a consultant for major enterprise software company, performed DB2 DBA support tasks for the development of internal CRM implementation.
• Performed migration from DB2 V7 to V8, from Solaris to AIX platforms. Created stored procedures for data conversion activities.
• Performed SQL tuning and optimization and database performance monitoring.

Environment: EDB2, UDB V7, and V8, AIX, Solaris

Confidential

Data Architect

Responsibilities:

• As a consultant for major pharmaceutical companies performed data modeling, data analysis and data conversion for installation and upgrade of Siebel 7 eClinical and ePharma systems.
• Performed requirements analysis and defined entity relationship diagram for RCI’s implementation of Siebel Call Center.
• Functioned as a technical lead on Customer Information Management project - loading customer’s master data from multiple sources into Siebel DB.
• Performed tuning and optimization of Enterprise Integration Manager (EIM) data load utility.
• Provided support for enterprise master data management.

Environment: DB2 UDB, EIM, Siebel 7, AIX, Erwin

Confidential

Solutions Architect

Responsibilities:

• As a member of Platform Technologies Solutions Engineering group was responsible for certification and performance of Siebel software on DB2 UDB platform, with primary focus on EIM data load utility.
• Produced a white paper on optimization and tuning of EIM for DB2 UDB.
• Assisted Siebel Expert Services in customer engagements on optimization of EIM data loads to achieve a sub-second transaction rate.
• In partnership with IBM, organized and performed a “Cluster Proven” branding test of Siebel application on HACMP clusters.

Environment: DB2 UDB, Oracle, MS SQL, EIM, Siebel 2000, Siebel 7, AIX, Windows

Confidential

Data Architect

Responsibilities:

• As a data architect created high-level logical data model for the company wide implementation of Siebel Customer Relationship Management (CRM) system.
• Performed data integrity audits to drive data cleansing effort.
• Facilitated the report group with data architecture and SQL statements.
• Designed and implemented the financial/billing and bandwidth reporting interfaces to Siebel system.

Environment: Oracle 7, ERwin, Siebel ‘99, SUN Solaris, Veritas HA

Confidential

Data Modeler

Responsibilities:

• Created logical and physical data model for Requirement Validation and Testing Application using Erwin modeling tool and Oracle database.
• Performed database and system administration tasks on Solaris SUN server.
• Implemented data conversion from the client's legacy systems to Oracle Clinical System

Environment: Oracle 7, ERwin, SUN Solaris

Confidential

IT Architect

Responsibilities:

• As the database architect for the IBM list server ("iSource") project, created the logical database model, designed and implemented the physical database, implemented ESQL-C function library to provide database access for this application.
• As the database administrator (DBA) and integrator for the ShopIBM Catalog project, developed and implemented an E-commerce application. Optimized the DB2 database and SQL for performance and storage.
• As the database architect for the Environmental Hazardous Substances (EHS) Management System, produced a data model using Erwin data modeling tool for an Intranet-based chemical material authorization system.
• Performed definition and normalization of entities; established referential integrity by the use of referential constraints, and primary and foreign keys.
• Produced physical database design and database optimization.
• Verified and corrected legacy data to ensure data integrity.

Environment: DB2 UDB, C, ERwin, RS/6000 single and SP2 processors, AIX