PROFESSIONAL SUMMARY:

• Managed the meta-data for the Subject Area models for both Operational Data Warehouse/Data Mart applications.
• 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.
• 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:

WORK EXPERIENCE:

Confidential 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.
• Used data vault modeling method which was adaptable to the needs of this project.
• Involved in translating business requirements into data requirements.
• 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.
• 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

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.
• 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

Data Modeler, Brokerage Conversion Project

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.
• Developed ETL procedures 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

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.
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN
• Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications.
• Created different subject areas structures for business support and modeling prints.
• Participated in the analysis of the existing payment processing system, mapping phase according to functionality and data conversion procedure.
• 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.
• Developed stored 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 Object Data Integrator R2

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 Server 2005, Business Object Data Integrator 6.X, VB Script, PL/SQL, Microsoft Project/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

Responsibilities:

Web Developer

• 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.