Professional Summary * 6+ years of extensive experience in the field of Information Technology with more than 5 years of experience in Transactional (OLTP), Data Warehouse (OLAP) database solutions. * Proficient inall the phases of the Software development lifecycle, including requirements Definition, Analysis, Design, System Implementation, Performance Tuning, Testing and Production Support. * Strong understanding of logical and physical database designs and also dimensional modeling schemas like Star and Snowflake schema. * Expertise in Data Modeling using tools like Erwin, Oracle Designer, Toad Data Modeler and MS Visio along with the hands on experience in using Forward Engineering and Reverse Engineering functionality. * Experience in Data Modeling for Online Transactional processing (OLTP) systems, Online Analytical Processing (OLAP) systems. * Developed Data Dictionaries, Metadata, Design Standards, Design Guidelines, Design Best Practices, ERwin Tool Guidelines and SDLC Process Documents. * Experience in working with industry standard analysis techniques to uncover client requirements and identifying the roles and deliverables in the Organization by creating Use Case Models, Data Flow Models along with Activity Diagrams, Sequence Diagrams and State Diagrams using Microsoft Visio. * Experience with Business Process Modeling, Process Flow Modeling, Data Flow Modeling * Strong Experience in writing Database Objects like Packages, Stored Procedures, Functions, Triggers. * Strong experienced with Enterprise OLTP data architecture. * Reviewing current operational/master data structures.

Highlights:

• Modeling Experience
• OLAP
• Online Analytical Processing (OLAP)
• Oracle
• Business Requirements
• Data Management
• Data Modeling
• Data Warehouse
• Database
• ERwin