SUMMARY:

• Result - oriented professional with over 6 years of experience in Requirements gathering, System & Data Analysis, Data Architecture, Database Design and Database Modeling.
• Strong background in various Data Modeling tools using ERWIN.
• Expert knowledge inSDLC(Software Development Life Cycle) and good experience in the field of business analysis, reviewing, analyzing, and evaluating business systems and user needs, business modeling, document processing.
• Extensive experience inRelationalData Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams,Forward and Reverse Engineering, Publishing ERWIN diagrams, analyzing data sources and creating interface documents.
• Designed and developed Data Marts by following Star Schema and Snowflake Schema Methodology, usingindustry leadingData Modeling tools likeERWIN.
• Having Experience in Normalizing Data from 1NF to 3NF.
• Understanding the Slowly Changing Dimensions Type1, Type2, Type3.
• Conducted JAD sessions, created Use Cases, work flows and Power Point presentations.
• Gathering and translating business requirements into technical designs and development of the physical aspects of a specified design.
• Gathered and documented Functional and Technical Design documents.
• Assisted quality assurance team in preparing test scripts and test cases
• Worked on Documenting Data Models, logic, coding, testing, changes and corrections.
• Energetic and self-motivated team player with excellent communication, interpersonal, and leadership skills, thrives in both independent and collaborative work environments.

TECHNICAL SKILLS:

RDBMS: Oracle 10g/9i/8i/8.0, MS SQL SERVER 2000/2005, ERwin 7.x/4.x

Business Skills: Definition Requirements, Business Process Analysis, Use Case Modeling & Analysis, Business Environment and Market Research Analysis, Project Management

Programming: SQL

Tools: Toad, command editor, MS Project, MS Office 2003

PROFESSIONAL EXPERIENCE

Confidential, Springfield, IL

Data Steward/Data Analyst

Responsibilities:

• Identified and examined all Confidential applications to determine if they can be integrated with other applications or if the data being collected is also collected in other applications which would allow those applications to be retired.
• Interacted with program people and business owners on Confidential ’s IT Systems to reduce the data collection burden on the school districts which will greatly improve data quality and consistency.
• Conducted Gap analysis on various systems to identify redundant data.
• Involved in documenting systems that are in the metadata workbook. An excel spreadsheet was created and the tables and fields were documented for various systems.
• Supported design, testing and implementation of the ILDS data warehouse. Test scripts for various systems were documented.
• Worked on Educational Data Warehouse.
• Provided other data analysis services, as required.
• An enthusiastic and project-oriented team player with solid communication and leadership skills.

Confidential, Dallas, TX

Data Modeler/Data Analyst

Responsibilities:

• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Conducted analysis and profiling of potential data sources, upon high level determination of sources during initial scoping by the project team.
• Coordinated data profiling/data mapping with business subject matter experts, data stewards, data architects, ETL developers, and data modelers.
• Developed logical/ physical data models using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
• Involved in dimensional modeling, identifying the Facts and Dimensions.
• Maintain and enhance data model with changes and furnish with definitions, notes, reference values and check lists.
• Worked very close with Data Architectures and DBA team to implement data model changes in database in all environments.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop different solutions for challenging client needs.

Confidential, CHICAGO, IL

Data Modeler/Data Analyst

Responsibilities:

• Created an Enterprise data model for the company. Systems within project scope were marketing, sales, customer care, service order processing, billing, etc.
• Produced functional decomposition and logical models into an enterprise data model.
• Analyzed the Business Requirements, Functional Specification Documents to prepare conceptual model.
• Consulted with client management and staff to identify and document business needs and objectives, current operational procedures for creating the logical and physical data model.
• Modeled a database to store customer demographic and other data like click stream data, Meta data.
• Performed Data Analysis using procedures and functions in PL/SQL.
• Worked on Reverse Engineering the data models in ERwin.
• Designing by effective data modeling, implementing database standards and processes.
• Was responsible to test the metadata and synchronize the data.
• Developed Logical data model using ER diagrams in ERwin.
• Designed and implemented a physical data model in ERwin to handle marketing strategies and to satisfy reporting needs.
• Produced functional decomposition diagrams and defined logical data model.
• Conducted team meetings and JAD sessions with the SMEs, stakeholders and other management teams.
• Created a DDL scripts based on physical design of the central relational database.

Confidential, Richmond, VA

Data Modeler

Responsibilities:

• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Conducted analysis and profiling of potential data sources, upon high level determination of sources during initial scoping by the project team.
• Coordinated data profiling/data mapping with business subject matter experts, data stewards, data architects, ETL developers, and data modelers.
• Worked on Bank Data ware house and Mortgage Data ware house.
• Developed logical/ physical data models using ERwin tool across the subject areas based on the specifications and established referential integrity of the system.
• Normalized the database to put them into the 3NF of the data warehouse.
• Involved in dimensional modeling, identifying the Facts and Dimensions.
• Maintain and enhance data model with changes and furnish with definitions, notes, reference values and check lists.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop different solutions for challenging client needs.

Confidential

Business Analysis/Data Modeling

Responsibilities:

• Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN
• Validated and updated the appropriate Logical Data Models to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change
• Generated user and technical documentation for processes in all phases of the project
• Conducted all data model reviews as appropriate during project lifecycle
• Coordinated with project DBA to update the physical database models to incorporate design changes (table de-normalization, type-code column additions, etc.) as they occur
• Involved in data profiling and cleansing to remove redundant data
• Provided input to resolve data limitation/constraints and issues
• Developedstored procedures, triggers, functions and packages in PL/SQL
• Reviewed processes and provided input into project plan
• Extensively used tracing methods to troubleshoot various time consuming queries.
• Provided other data analysis services, as required