SUMMARY

• Around 10 years of total IT experience in Data modeling, Data architecture, design & development of BI solutions, Client/Server and Web applications on Windows, UNIX & Linux platforms.
• Extensive data warehouse expertise in OLAP and relational modeling (3NF/OLTP) with a wide repertoire of domain experience in Government, Retail, Banking & Finance etc.
• Data Architect
• Solid experience in designing Requirement Traceability matrix and determining the Gap analysis for the artifacts collected.
• Expert - level experience in the field of business data asset management using Data Profiling, Data cleansing, Data mining.
• Consummate knowledge in Conceptual, Logical and Physical Database Design by leveraging tools like Erwin and ER Studio.
• Governance Over 4 years of data governance/MME experience with data content, data quality (Data Flux), security and accessibility to meet internal and external customer needs.
• Database: Vast experience in creating models for Oracle, Teradata V2R13, DB2, MS SQL Server 2005, SQL, XML
• Created Stored Procedures, BTEQ & TPT Scripts. Analyzed Performance bottleneck during data flow between systems.
• Good experience in Teradata performance tuning using Join indexes, Partitioning, Temporary tables and statistics analysis.
• Worked with day to day Repository Management activities like Model Merging, User Role Creation, User Access Grants, Model Freezing and Model Version Management. Undertaken the responsibility of reverse engineering and synchronizing existing legacy data models.
• Designed Data models for Multi-Terabyte Systems and built Enterprise Data Warehouses (Ex: Confidential / Confidential / Confidential ).
• Strong knowledge of programming in UNIX Shell /Perl scripts
• Strong communication skills and project management capabilities.

TECHNICAL SKILLS

Primary Skills: Logical/Physical Data Modeling using CA Erwin Embarcadero ER/Studio and Agile Methodology over Teradata, Oracle,DB2 databases and Flat Files.

Methodology Focus: 3NF Relational Modeling & Dimensional Modeling using Inmon and Kimball Approach.

Languages: Java, C/C++, pro*C, VB6.0, Developer2000 Forms, PERL, TPT

Data modeling Tools: ERwin 4.1, ERStudio 8.5, Teradata Profiler, SQL Assistant

ERP Technologies: SAP R/3 (ABAP/4)

Middle Ware: EJB, RMI, CORBA

Web Technologies: HTML, XML, JSP, Servlets, JDBC

Databases: Oracle 11g/10g/9i/8i/8.x/7.x,, MySql, Teradata 13,Sql,PL/Sql

Application Servers: Weblogic 7.x, Tomcat 4.0, Websphere 5.1, Websphere 6.1

MME Tools: Metacenter 3.7/3.6.3/3.6.2/3.6.0

BI Tools: Business Objects, Informatica 7.2.1, Cognos Report Net

Testing Tools: Win Runner, Load Runner, Mercury QC

Operating Systems: WINDOWS 98/2000/NT/XP/Mac OSX

PROFESSIONAL EXPERIENCE

Confidential, Lansing, MI

Senior Data Modeler / Data Architect

Responsibilities:

• Collaborated with the stake holders efficiently in conducting the JAD sessions to address all the key business ambiguities which arise while identifying key Indicators.
• Identified quantifiable measures after understanding the Confidential processes.
• Ensured that data aspects of projects were fully addressed and consistent in approach by introducing and integrating data considerations into existing Object Oriented methodology and system development life-cycle.
• Constructed data models, designed schemas, generated DDL and worked with development team members on the implementation of project.
• Defined and developed specific standards encompassing Data Modeling and Physical Database Design, Change Management, Business Objects Universe Design.
• Integrated new subject areas and business units such as OSMIS, JET, FSSP in an effort to lay foundation for the SOM enterprise data warehouse.
• Ensured all the physical modeling practices are adhered to before the DDL’s are created in DRBC.
• Designed and implemented (POC) proof of concepts after identifying the scope of the project and before development design so as to understand the feasibility, guestimate efforts.
• Strong understanding of Indexing, partitioning and other Teradata V2R13 specific applications like BTEQ, TPT, FLOAD, Indexing wizard, Viewpoint etc.
• Well Versed with different SQL Development Tools like TOAD, Teradata Sql Assistant and Teradata Bteq.
• Experience in handing slowly Changing Dimensions using TPT utility and fast loading into empty Target tables.
• Experience in application enhancements. Developed, tested and deployed Teradata scripts.
• Strong experience with UNIX Shell Scripting, SQL, PL/SQL Coding & scripting.
• Skilled in Automation, Optimization, and Performance Tuning of Teradata SQL’s.

Environment: ERwin 8.x, SQL, Teradata 13, Teradata SQL Assistant, VB 6, Oracle

Confidential, Beaverton, OR

Senior Data Modeler /Application Engineer

Responsibilities:

• Interacted with the BSA’s & Business partners to collect data specifications & artifacts.
• Understood traceability matrix & DDS to ensure source data is aligned to requirements.
• Co-ordinate with the Architectural team and come up with proposed design & possible solutions.
• Made key decisions on proposed design structure, which can possibly serve as a purpose and answer all the KBQ’s.
• Created the attributes for the dimensions/Fact tables based on the traceability matrix & source systems.
• Modeled logical & physical data models based on the KBQ’s collected.
• Implemented the Data Modeling for BI environment using Erwin 7.x
• Conducted model walk through sessions with the business partners.
• Implemented enterprise guidelines for data modeling and data asset management.
• Designed the physical data models using data provisioning and consumption techniques in a Teradata environment.
• Research and recommend changes where technology can be better used within the overall systems environment to improve efficiency, lower costs, and enhance the quality of business applications.

Environment: ERwin 7.x/ERStudio 7.5, SQL, Teradata V2R6,VB, Teradata SQL Assistant, Oracle

Confidential, Thousand Oaks, LA

Senior Data Modeler

Responsibilities:

• Understood traceability matrix document to ensure source data is aligned to requirements.
• Created the attributes for the dimensions/Fact tables based on the traceability matrix & source systems.
• Modeled logical & physical data models based on the KBQ’s collected.
• Conducted model walk through sessions with the business partners.
• Implemented enterprise guidelines for data modeling and data asset management.
• Produced data model solutions meeting technical specifications and business requirements according to the established designs.
• Expert in ER/Studio Repository Management and administration.
• Day to day admin tasks associated to ER/Studio Repository like granting user access, creating roles, working with DBAs for Repository database performance issues and merging models, coding new macros and customizing canned ER/Studio Macros.
• Configuration Management and Version control of ERwin Model Mart and ER/Studio Repository.
• Provide capacity estimates for database design planning and performance tuning suggestions to DBA.
• Modeling activities included LDMs for Business Intelligence, Data Warehouse and Applications domain.
• Extension of Operational Data Store (ODS) and Parsing XML structures to create Hierarchical model.
• Generated the CDMA out of ERStudio to generate the source target-mapping template.
• Updated the definitions & physical names based on the Confidential & Teradata standards.
• Worked in conjunction with Database Administrators and Development teams to come up with an efficient database design.
• Generated & reviewed DDL & DQ scripts s using ERStudio before communicated to the DBA for the implementation.
• My role was to migrate ERwin changes to ERStudio master data model in very tight timelines.
• Created Source to Target worksheet for ETL processes in Informatica using CDMA.

Environment: ERwin 7.x/ERStudio 7.5, SQL, Teradata 13,VB, Teradata SQL Assistant

Confidential, Riverwoods, Chicago

Team Lead/ Data Modeler

Responsibilities:

• Understood and validated the project requirements.
• Created and maintained Business Process Models, Process flow Models, Data Flow models & conducted walk through sessions with Business partners.
• Reviewed and understand the data analysis artifacts.
• Contributed in data profiling & data mining.
• Created and converted the Logical data models in to Physical.
• Migrated several data models from ERwin 4.1 into ERStudio 7.5/8.5 as per the naming standards.
• Created the data Lineage mappings using the source to target mapping document.
• Supported Business Process Analyst, Designers, and Architectural Experts with enterprise and process area modeling, workshops, documentation, training and user support.
• Participated in technical reviews and inspections related to business process models.
• Conducted review walk through of data models involving SME, developers, testers and analysts.
• Generated & reviewed DDL & DQ scripts s using ERStudio before communicated to the DBA for the implementation.
• Involved in database designing and administration in IBM DB2 UDB, Teradata, MS SQL Server and Oracle.
• Supported Business Process Analyst, Designers, and Architectural Experts with enterprise and process area modeling, workshops, documentation, training and user support
• Creative in solving governance issues.
• Name released the data models to publish the metadata to Metacenter to make it available to the users.
• Contributed in filling the S-T mapping templates for the data models.
• Contributed in upgrading the ERStudio dev & prod repositories from 7.5 to 8.0 & from 8.0 to 8.5.
• Grant access to the new users & assign role names on as needed basis.
• Implemented the new Metacetnter Materialized views every time ERStudio repository was upgraded.
• Released the locks on data models that are no longer used & checked out by the other users.
• Used undo checkout operation on the data models to revoke the changes in the repository.

Environment: ERwin 4.1/ERStudio 8.5, PL/SQL, Teradata V2R6, Oracle 10g, Teradata SQL Assistant, Lotus Notes, Metacenter 3.8,AIX,VB 6

Confidential, IL

Cognos Consultant/Informatica Developer/ Data Modeler

Responsibilities:

• Generate the conceptual, logical, physical, staging, enterprise & database layer data model based on the artifacts collected.
• Created and converted the Logical data models in to Physical.
• Updated the Logical and Physical Data Modeling guidelines documents.
• Generate the DDL scripts with the subject area changes.
• Created the Informatica source to target mapping document.
• Implemented the Informatica changes to populate the missing reporting elements.
• Developed most of list, cross tab & dashboard reports for accountabilities & head counts in Cognos 8.
• Expertise in customizing the reports using html item and java script.
• Used HTML item in most of the list reports to drill through hierarchies.
• Managed Framework Manager Model and published packages.
• Contributed in creating the complex reports.
• Created dashboard, departmental, activity and performance reports.

Environment: Cognos 8, TOAD, UNIX, SQL SERVER, ERSwin 3.5,Informatica 8.x