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.
• 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 variousOLTPdatabases to the data mart.
• Excellent knowledge inSQLand codingPL/SQLPackages, 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, Data extraction, Integration, transformation and Migration, OLTP & OLAP Design and Development.

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

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

ETL Tools: Data Stage, Informatica

Reporting Tools: Tableau, Cognos

Programming: PL/SQL, JAVA, Pascal

Scripting languages: Java script, PHP

PROFESSIONAL EXPERIENCE

Confidential, Gaithersburg, MD

Data Modeler

Responsibilities:

• 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.
• 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 whichincluded 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.
• Developedstored procedures and triggers.
• Wrote packages, procedures, functions, exceptions using PL/SQL.
• 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

Responsibilities:

• 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.
• Participatedin data analysis and data dictionaryandmetadata 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.
• Developedrelational model design, dimensional modeling.
• Validated and maintained the enterprise-wide logicaldatamodel forDataStaging Area.
• Worked at conceptual/logical/physical data model level using Erwin according to requirements.
• Aided and verified DDL implementation by DBAs, corresponded andcommunicated 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 ofdata.
• Performeddataanalysisonproductiondataissues.
• 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 ObjectsData Services3.X

Confidential, OAKDLE, MN

Data Modeler

Responsibilities:

• Reviewed functional requirements and use cases to determine the necessary data requirements.
• Participated in creating realistic project plans with detailed tasks and ensuring their timely execution.
• Reversed engineered current system data model and subdivided it into work streams for analysis.
• Created process flows and data flow diagrams of the current and future systems.
• Performed dependency and gap analysis for data structure changes on other downstream applications and impact of new data elements on existing downstream processes.
• Designed and produced logical and physical data models for the financial platform and other in-house applications running on Oracle databases.
• DevelopedETLprocedures for moving data from source to target systems.
• Worked closely with both functional and technical team on the creation of data models which can seamlessly integrate with existing data structures on multiple Oracle databases integrated by database links.
• Generated Surrogate Key for the dimensions in the fact table for indexed and faster access of data.
• Generated data source to target mapping documents.
• Maintain database standards documents example Naming standards document, Data dictionary to ensure consistency.

Environment: ERWIN 7.2, MS Visio, Toad, Oracle 10g/11g, PL/SQL, SQL*Plus, Toad, Data Stage

Confidential, NJ

Data Modeler

Responsibilities:

• Participated in JAD sessions with business users and analysts to understand and document the business requirements in alignment to the financial goals of the company.
• Designed and developed use cases, Data Flow Diagrams, and sequence diagrams.
• Participated in the analysis of the existing payment processing system, mapping phase according to functionality and data conversion procedure.
• Created different subject areas structures for business support and modeling prints.
• 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, business rules, glossary terms, etc.
• Created business requirement documents and integrated the requirements and underlying platform functionality.
• Maintained data model and synchronized it with the changes to the database.
• Extensively involved in the modeling and development of Reporting Data Warehousing System
• Designed the database tables & created table and column level constraints using the suggested naming conventions for constraint keys.
• Used ETL tool to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Developedstored procedures and triggers.
• Wrote packages, procedures, functions, exceptions using PL/SQL.
• Reviewed the database programming for triggers, exceptions, functions, packages, procedures.
• Assisted in performed Unit testing & User Acceptance testing.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.

Environment: Erwin 4, MS Visio, Oracle 10g, SQL Server 2000, Business ObjectData IntegratorR2

Confidential

Data Modeler

Responsibilities:

• Actively involved in the design phase of the development, conducted detailed data modeling for the database to be developed.
• Ensured that business requirements can be translated into data requirements
• Designed and build logical and physical data models for OLTP & OLAP systems.
• Developed, tested, managed and documented data warehouse operations and tasks.
• Assisted in the design the overall ETL processes and architecture.
• Performed complex data analysis in support of ad-hoc requests.
• Analyzes data to identify root-cause of issues related to data warehouse and ETL processes and provided troubleshooting expertise in resolving technical issues.
• Developed processes that define, support and enforce information and data quality standards.

Environment: Erwin, Oracle 10g,SQL Server2005, Business ObjectData Integrator6.X, VB Script, PL/SQL, MicrosoftProject/Office.

Confidential

WEB DEVELOPER

Responsibilities:

• Worked with graphical design tools including Adobe Photoshop, Macromedia Flash, and Dreamweaver.
• Developed a dynamic, secure Web site from scratch.
• Responsible for the installation of e-mail and other forms.
• Responsible for the design of client websites right from conceptual stage to implementation stage as per client’s requirement.
• Recognized system deficiencies and implemented solutions.
• Performed the validation and testing of the finished web sites.

Confidential

Web Developer

Responsibilities:

• Developed entire application components as well as individual applications, working on the entire process of web development, including planning, designing/developing and implementing software code for website components.
• Provided assistance to testers and supported personnel.
• Communicated with back-end developers, system engineers and web designers to receive data needed for development.
• Interacted and coordinated with technical teams and creative designers to integrate front-end design with back-end technology.
• Responsible for the design and development of web sites and web applications through the use of MS Front Page, Macromedia Flash, Adobe Photo Shop, HTML 5.0, PHP, JavaScript, CSS.