SUMMARY:

• Goal - oriented IT professional with strong background in Database development and designing data models, with particular emphasis on designing online transactional processing (OLTP) and Data Warehouse systems for Financial, Retail and Health Care domains.
• Excellent knowledge of waterfall and spiral methodology of software development life cycle (SDLC).
• Strong Knowledge of Data Warehouse Architecture and Star Schema, Snow flake Schema, FACT and Dimensional Tables.
• Participated in JAD sessions and requirements gathering & identification of business subject areas.
• Created, documented and maintained logical and physical database models in compliance with enterprise standards.
• Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model.
• Used the Ralph Kimball Methodology for Data Warehouse and Data Mart designs.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Managed the meta-data for the Subject Area models for both Operational & Data Warehouse/Data Mart applications.
• Have worked with ETL tools to migrate data from various OLTP databases to the data mart.
• Excellent knowledge in SQL and coding PL/SQL Packages, Procedures.
• Managed performance and tuning of SQL queries and fixed the slow running queries using utilities like Explain, Trace, and Tkprof.
• Proficient in creating Views, Materialized views & Partitions for the Oracle warehouse.
• I have excellent communications skills and work well with end users and management.

TECHNICAL SKILLS:

Modeling Tools: Erwin, ER Studio, MS Visio, Toad, Rational Rose

Modeling Specialties: Logical & Physical Data Models, OLTP & OLAP Design and Development Dimensional modeling.

Data Analysis: End user Requirement Gathering, JAD Sessions, Data, Source Systems Analysis, and Data Relationships.

RDBMS: Oracle 10g/9i/8i/8.0, MS SQL SERVER 2000/2005 and MS Access

ETL Tools: Informatica.

Programming: PL/SQL, JAVA

PROFESSIONAL EXPERIENCE:

Confidential

Data Modeler

• Interacted with the business users to gather requirements.
• Perform reverse engineering of the dashboard requirements to model the required data marts.
• Obtain information of the ways the organization uses its data.
• Designed and developed the conceptual then logical and finally physical data models to meet the needs of reporting
• Applied a dimensional model structure to archive an agile data model
• Leverage and enforce standards for data naming conventions to ensure consistency and reuse of data model
• Validate business use cases for accuracy and completeness of proposed data models
• Manages the flow of information between departments through the use of relational databases.
• Working with other key roles such as Business Analysts, Data Architects, DBAs, ETL developers to achieve the set goal
• Performing problem assessment, resolution and documentation of the data mart models.
• Participate in code/design reviews and provide input into best practices for reports and universe development.
• Document and communicate technical solutions to ensure that proper & optimized techniques, queries, data standards and final deliverables are understood and incorporated into data models.

Environment: Oracle Data modeler, Oracle 11g, Business objects, Informatica, MS Excel.

Confidential,Washington Dc

Data Modeler

• 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.
• Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary terms in accordance with the Corporate Data Dictionary etc.
• Validated and updated the appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change
• Generated high-level data access documentation for processes.
• Designed Metadata Repository to store data definitions for entities, attributes & mappings between data warehouse and source system data elements.
• Conducted all data model reviews as appropriate during project lifecycle
• Coordinated with project DBA to update the physical database model to in corporate high-level design changes (table de-normalization, type-code column additions, etc.) as they occur.
• Maintained data model and synchronized it with the changes to the database
• Master data management.
• Provided input to resolve data limitation and issues.
• Performance tuning.
• Attended and participated in information and requirements gathering sessions (JAD).
• Ensured that business requirements can be translated into data requirements.
• Reviewed Project Charter and provided input into project plan.

Environment: ER Studio, Oracle 11g R2, SQL SERVER 2008 R2,TOAD, MS Office, Linux, Windows

Confidential, MD

Data Modeler

• Participated in JAD sessions, gathered information from Business Analysts, end users and other stakeholders to determine the requirements.
• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modelling.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN
• Involved in translating business requirements into data requirements.
• Used data vault modeling method which was adaptable to the needs of this project.
• Created and maintained Logical Data Model (LDM) for the project which included documentation of all entities, attributes, data relationships, referential integrity, domains, codes, business rules, glossary terms, etc.
• Created business requirement documents and integrated the requirements and underlying platform functionality.
• Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Maintained data model and synchronized it with the changes to the database.
• Involved in the modeling and development of Reporting Data Warehousing System.
• Used ETL tool Informatica to extract, transform and load data into data warehouses from various sources like relational databases, application systems.
• Developed stored procedures and triggers.
• Wrote packages, procedures, functions, exceptions using PL/SQL.
• Reviewed the database programming for triggers, exceptions, functions, packages, procedures.
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.

Environment: Erwin 7, MS Visio, Oracle 11g, Informatica, Toad.

Confidential,HERDON,VA

Data Modeler, Network Outage System

• Facilitated logical JAD sessions to discuss and gather business requirements for all assigned projects. This process included scheduling meetings with the business and application groups, documenting agendas and minutes.
• Participated in data analysis and data dictionary and metadata management - Collaborating with business analysts, ETL developers, data quality analysts and database administrators.
• Designed Order provisioning business processes, target applications architecture and target data model.
• Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for reports.
• Developed relational model design, dimensional modeling.
• Validated and maintained the enterprise-wide logical data model for Data Staging Area.
• Worked at conceptual/logical/physical data model level using Erwin according to requirements.
• Aided and verified DDL implementation by DBAs, corresponded and communicated data and system specifications to DBA, development teams, managers and users.
• Managed the meta-data for the Subject Area models for both Operational & Data Warehouse/Data Mart applications.
• Conducted data profiling, qualities control/auditing to ensure accurate and appropriate use of data.
• Performed data analysis on production data issues.
• Used Data Stage to extract data from relational databases, various file formats. Cleansed and transformed the data before loading it to target database.
• Developed queries using PL/SQL and stored procedures.

Environment: ERWIN 7, Oracle 10g, SAP Business Objects Data Services 3.X

Confidential,WASHINGTON,DC

Guest Management System | Data Analyst/ Data Modeler

• Involved in interactions with Subject Matter Expert, Project Manager, Developers, and the end-users in more than one JAD sessions to gathering the new requirements.
• Involved in all phases of SDLC from requirement, design, development, testing and rollout to the field user and support for production environment.
• Translated business requirements into data design requirements used for driving innovative data designs that meet business objectives.
• Developed Business and Subject Area Logical Data Models, Physical Data Models, Physical Staging area Data Models and Data Flow Diagrams.
• Extensively used ERWIN to design Logical/Physical Data Models, forward/reverse engineering, publishing data model, applying DDLs to database, Data Modeling and restructuring the existing data Model.
• Applied Discover Financial Data Naming Standards, created new naming standards, checked models in and out of ERWIN Model Repository, and documented data model translation decisions.
• Generated database objects such as Table, Views, Synonyms, Database Link by executing the script generated from ERWIN with appropriate privileges
• Responsible in designing and introducing new (FACT and Dimension Tables) to the existing Model.
• Used various levels of triggers and procedures to validate the data at each level.
• Extensively involved in writing PL/SQL stored procedures, functions and packages.
• Created database tables with complex constraints applicable to the business rules.
• Involved in Optimizing SQL queries involving large tables.
• Created Indexes and Materialized Views to improve the overall system performance.
• Tested the application to ensure proper functionality, data accuracy, and modifications had no adverse impact on integrated system environment.
• Involved in the maintenance and support of existing applications with the users.
• Involved in training and production support at various client locations

Environment: Erwin, Oracle 10g, SQL Server 2005, Business Object Data Integrator 6.X, VB Script, PL/SQL, Microsoft Project/Office.

Confidential

SQL programmer

• Analyze and evaluate specifications, architect designs and coding issues.
• Create complex analytic queries on large data sets
• Create stored procedures, triggers, and functions
• Performance tuning of key queries.
• Interact and collaborate with other team members in developing life cycles.

Environment: Oracle, SQL * Plus, Excel, Access.