Professional Summary

• Over 10 years of experience in the field of Information Technology with extensive knowledge in Modeling for Online Transactional processing OLTP and Online Analytical Processing OLAP systems.
• Expert knowledge in SDLC Software Development Life Cycle .
• Experience in Design, Development and Implementation of the enterprise-wide architecture for structured and unstructured data, providing architecture and consulting services to Business Intelligence initiatives and data driven business applications.
• Extensive experience in Dimensional Modeling using Star schema and Snowflake schema methodologies of Data Warehouse and Integration projects.
• Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering ERWIN diagrams, Subject area, Domain, Naming Standards Documentation, analyzing data sources and creating interface 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.
• Strong Experience in writing Database Objects like Packages, Stored Procedures, Functions, Triggers.
• Developing Data dictionary and maintaining Metadata for models.
• Coordinates with other developers in best performance tuning practices.
• Involved in debugging and developing exception-handling procedures whenever required.
• Strong in conceptualizing and communicating enterprise data architecture frameworks for global enterprises for inter operation of data warehouses, middleware, and web applications.
• Good documentation, communication and problem solving skills.

Technical Skills:

Professional Experience:

Confidential

Data Modeler/Analyst

Responsibilities:

• Attends and participates in information and requirements gathering sessions.
• Translates business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications.
• Designs Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN.
• Creates and maintains 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.
• Validates and updates the appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change.
• Generates high-level data access documentation for processes.
• Designs Metadata Repository to store data definitions for entities, attributes mappings between data warehouse and source system data elements.
• Generates process data CRUD Create/Read/Update/Delete matrix
• Conducts all data model reviews as appropriate during project lifecycle.
• Coordinates with project DBA's to update the physical database model to incorporate high-level design changes table de-normalization, type-code column additions, etc. as they occur.
• Maintains data model and synchronize it with the changes to the database.
• Provides input to resolve data limitation and issues.
• Coordinates with ETL team in best mapping and transformation processes to ensure consistency.

Environment: ERWIN, Oracle 11g, MS Visio, MS Office, TOAD, Informatica

Confidential

Web Developer/Data Modeler

Responsibilities:

• Develop or validate test routines and schedules to ensure that test cases mimic external interfaces and address all browser and device types.
• Document test plans, testing procedures, or test results.
• Evaluate code to ensure that it is valid, is properly structured, meets institution standards and is compatible with browsers, devices, or operating systems.
• Create web models or prototypes that include physical, interface, logical or data models.
• Develop web site maps, application models, image templates, or page templates that meet project goals, user needs, or institution standards.
• Identify problems uncovered by testing or customer feedback, and correct problems or refer problems to appropriate personnel for correction.
• Involved in designing the LDM and PDM models in Data Modeling Tools like Erwin.
• Assisted in the design of the services that will send data across support applications in tracking and analyzing student processes including but not limited to admissions, registration, course selections, etc.

Environment: HTML, XML, CSS, JavaScript, dotCMS, SQL Server, TOAD Modeler, Visio, MS Access, MS SharePoint, PhotoShop

Confidential

Data Modeler

Responsibilities:

• Involved with Business Analysts team in requirements gathering and in preparing functional specifications and changing them into technical specifications.
• Conducted and participated JAD sessions with the Project managers, Business Analysis Team, Finance and Development to team gather, analyze and document the Business and reporting requirements.
• Analyze the Business information requirements and research the OLTP source systems to identify the measures, dimensions and facts required for the reports.
• Involved in making screen designs, Use Cases and ER diagrams for the project using ERWIN and Visio.
• Coordinated with the Business Analyst and prepared Logical and Physical Data-models as per the requirements involving multiple subject areas, domains and naming standards.
• Designed and developed the DDL scripts, data mapping documents, data dictionary and Meta data of the models and maintained them.
• Coordinated with DBA on data base build and table normalizations and de-normalizations.
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary and change during the project.
• Generated user and technical documentation for individual processes.
• Identified and streamlined complex queries which were causing iterations and effecting database and system performance.
• Identified database inconsistencies like orphan objects, duplicate objects and coordinating with various teams to decide on the appropriate action to be taken.
• Coordinated in database changes needed for the front end development team, explained and guided them on the database architecture and objects for effectively accessing the database.

• Work directly with non-IT business analysts throughout the development cycle, and provide post-implementation support, once developed including investigation of data and report issues identified by customers.

Environment: ERWIN, Oracle, MS-SQL Server, MS-Visio, MS Office

Confidential

Data Modeler

Responsibilities:

• Translated Business Requirements into working Logical and Physical data models for OLTP, Data Warehouse and Data Mart applications.
• Designed data model for OLTP applications using the ERWIN tool.
• Attended JAD sessions with the business analysts in order to understand the client and the end user reporting needs.
• Designed Conceptual, Logical and Physical data models using the ERWIN tool.
• Generated DDL scripts during the forward engineering process for the actual physical build of the database.
• Created documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Involved in various data modeling tasks that included forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas etc.
• Generated reports using the ERWIN tool in order to assist the ETL teams.
• Provided training on data model to different application groups across the enterprise.
• Extensively used complex SQL queries for querying and analysis of data.
• Created Stored Procedures in order to implement the business logics.
• Created Triggers and Sequences in the Physical Data Model so as to meet the business logics as and when required.
• Provided other data analysis services as required.

Environment: Erwin 7, SQL, PL/SQL, Oracle 9i

Confidential

Geospatial Data Modeler/Reporter

Responsibilities:

• Modeled, developed, reviewed and/or edited applications used to support decision making at multiple levels in the organization.
• Developed geospatial enhanced solutions for facility management, real property analysis, energy analysis, health and disease tracking analysis, developmental and critical infrastructure protection.
• Used Esri software and extensions to solve issues and developed repeatable custom solutions.
• Coordinated with Specialists and Subject Matter Experts SME's to integrate GIS with client solutions.
• Generated mappings and reports time series, forecast, statistical, etc understandable to clients and also made recommendations based on geospatial facts.

Environment: ArcGIS 9, SQL Server 2005, ERDAS Imagine, MS Office.