SUMMARY

• Hands - on, results-driven, technical consultant with over 10 years of experience in information-modeling, architectural design and implementation of OLTP, Data Warehouse and Operational environments.
• Data Modeler and Architect for OLAP, OLTP, Data Warehousing Systems.
• Strong analysis, design, development, deployment and support experience in Dimensional Modeling (Star schemas) and relational data modeling.
• Expert in Enterprise data modeling (ELDM), conceptual, logical and physical data modeling.
• Skilled with interacting and implementing systems using cross-functional teams comprised of; business users, architects, application developers, database administrators, system administrators, and data center operations.
• Strong technical skills and experience as Database Specialist, Application DBA and Developer for Oracle Databases.
• Good understanding of ERP Oracle Applications Architecture in Finance and Distribution Modules.
• Highly experienced in financial, Banking and brokerage industry. Good functional knowledge in Retail and Manufacturing industries.
• Team player, working effectively with clients, end-users and middle/senior management in accomplishing objectives.
• Excellent verbal communication and inter-personal skills at the technical and user level in multinational organizations.

TECHNICAL SKILLS

OS: WINDOWS, Linux, UNIX

RDBMS: Oracle 7 to 11g, SQL Server, Teradata, Sybase and DB2

Designer Tools: Sybase Power Designer 16.1, Erwin 7.x, MS Visio, SQL power Architect

Languages: SQL, PL/SQL, C, C++, VB 6, HTML, Java, VB Script and UNIX Shell Script

Reporting Tools: OBIEE, Forms & Reports (D2K), Crystal Reports

ERP Package: Oracle Applications 11i (Finance and Distribution Modules)

Methodologies: Agile, Waterfall

Tool and Utilities: SQL, Harvest, Peregrine, Toad v7.4, SQL Developer, Data Load v4.3, Clarify, Smart-term Essential (FTP), WS-FTP pro, PVCS, VSS, SQL*Loader, MS SharePoint, PICCT, PAC 2k, MS-Office, Autosys

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Modeler/Data Architect

Environment: Power Designer, Oracle Exadata, DB2, Sybase, SQL Server, Oracle 11g, OBIEE, SQL, Meta data Manager, Data Warehouse

Responsibilities:

• Implemented PWI conceptual data model describing the entire PWI organization which combines PI and WI.
• Designed and implemented multiple phases of Data warehouse with data extracted from various OLTP systems like Defined Contributions on DB2 and Defined Benefits on Sybase etc for a centralized pool of data to report from using OBIEE. Designed cubes and rollups for all reporting efforts.
• Interacted with Enterprise Architects, Business users and BSA’s to gather and interpret business requirements.
• Architected and maintained power designer logical and physical data models of the data warehouse and data marts. Worked closely with the DBA team to complete and generate the physical Database in development and test environments.
• Extensive data analysis and modeling on all Workplace products from OLTP to Warehouses to Data Marts
• Prepared and maintained database architecture and modeling policies, procedures and standards.
• Applied data naming standards, checked models in and out from power designer repository.
• Documented many existing data models to enable sharing and publishing of data.
• Worked closely with DBA’s in generating DDL’s in order to implement the physical models.
• Lead the design and preparation of various standard documents for modeling and naming conventions including internal data modeling Do’s and Dont’s.
• Developed definitions of data objects, including attributes and unique identifiers.
• Good understanding of data modeling for Big Data and Data Vault.

Confidential

Senior Data Modeler/Data Architect

Environment: Erwin7.3.8, SQL, Excel, Rochade, Model Mart, TeradataConversion project integrates new business lines and business partners into Confidential ’s Card Data Warehouse.

Responsibilities:

• Designed and developed logical data model for different credit bureaus like Transunion, Equifax etc, Interactive voice response (IVR area).
• Worked closely with DBA’s in generating DDL’s in order to implement the physical models.
• Developed definitions of data objects, including attributes and unique identifiers.
• Prepared LDM review packet containing source to target mapping, applied naming and abbreviation standards,
• Worked in preparing ELDM alignment packet for integrating the project models into Enterprise logical data model.

Confidential

Senior Data Modeler/Data Architect

Responsibilities:

• Designed and maintained Enterprise Data Model and fully attributed.
• Developed definitions of data objects, including attributes and unique identifiers.
• Prepared various mapping spreadsheets for integrating all major BDW models into ELDM.
• Integrated models have been added to ELDM (Entities, Attributes and relationships)
• Modeled various business critical data models into ELDM from different libraries like (Account library, Generic Loan, Reference data library, Application library, and Customer Contact).
• Ensured the reuse of ELDM data objects is accurate and maximized.

Confidential

Senior Data Modeler

Environment: Oracle 10g, Erwin7.3, SQL, Ws-Pro FTP, Excel, Visio, UNIX, TOAD, SQL Developer, Quality Center

Responsibilities:

• Designed logical and physical data model for the bank integration projects and accounts using Erwin tool.
• Responsible for the development, care, and maintenance of logical and physical Erwin data models, along with corresponding metadata, to support Confidential Online Applications.
• Responsible for creating, Maintaining and publishing the data models for all the applications and Data Dictionary to ODS.
• Reviewed the logical model with Business users, DBA’s and testing team to provide information about the data model and business requirements.
• Normalized the newly added tables to adhere the relational concepts.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
• Performance tuning of SQL scripts, procedures and packages.
• Had brain storming sessions with application developers and DBAs to discuss about various de-normalization, partitioning and indexing schemes for physical models.
• Loaded data using SQL * Loader, external tables, Export-import including the new technologies like data pump.
• Responsible for preparing the database build including the Release Notes for all test environments including UAT and PROD.
• Responsible for doing the impact analysis for the change requests related and change management.
• Participated in data analysis and also studied different systems for the merger project like HOGAN, BETA etc
• Created, managed and executed UNIX shell scripts to create account data.
• Extracted flat files from Unix Legacy sources, heavy cleansing, formatting and messaging to feed data into Oracle server.
• Created technical documentation for database, Function documentation/specification for report requirements
• Maintained the data dictionary. And also involved in various development tasks using PL/SQL database programming skills for writing procedures, packages and triggers.
• Reverse engineered the source database to understand the source system database structure.
• Prepared UNIX shell scripts to call pl/sql packages, loader files for batch processing and also to send conditional notifications to email ids and pagers in case of errors.
• Assisted prod support team in analyzing and debugging issues within database and UNIX batches.
• Prepared Technical Design documents, process flow documents and UTC documents.

Confidential

Data Modeler/Database Specialist

Environment: Erwin, Oracle (SQL, PLSQL), SQL Server, Developer 2000(forms6i and Reports 6i), TOAD, Citrix Server (Client Tool), UNIX, windows XP, Ws-Pro FTP, Oracle Apps 11.5.10

Responsibilities:

• Designed and developed various PL/SQL packages, procedures using APIs to load data from staging tables into Oracle base tables.
• Developed inbound and outbound interfaces.
• Designed data conversion systems for conversion of data from legacy to core apps tables.