SUMMARY

• 7+ years of extensive experience in the complete Software Development Life Cycle (SDLC) covering Requirements Management, Data Analysis, Data Modeling, System Analysis, Architecture and Design, Development, Testing and Deployment of business applications.
• Strong Data modeling experience using ER diagram, Dimensional data modeling, Logical/Physical Design, Star Schema modeling, Snow - flake modeling using tools like Erwin, ER-Studio.
• Experience in Designing the Data models for OLTP & OLAP database system.
• Created DDL scripts for implementing Data Modeling changes. Created ERWINreports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, co-coordinated with DBAs’ to apply the data model changes.
• Extensive experience in gathering business requirements, implementing business processes, identifying risks, impact analysis and UML modeling
• Utilized RUP (Rational Unified Process) to configure, develop processes, standards, and procedures
• Possess strong Conceptual and Logical Data Modeling skills, has experience with JAD sessions for requirements gathering, creating data mapping documents, functional specifications, queries.
• Worked implementing Data scrubbing techniques to eliminate errors due to data inconsistencies
• Excellent knowledge waterfall, spiral methodologies of Software Development Life Cycle (SDLC).
• Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling review sessions user groups, participated in requirement sessions to identify requirement feasibility.
• Extensive Experience working with business users/SMEs as well as senior management.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Experience in backend programming including schema and table design, stored procedures, Triggers, Views, and Indexes.
• Knowledge of capital market and familiar with different financial instruments like Derivatives.
• Experienced in Working with product managers, project managers, Business users, Applications development team members, CM Team, DBA teams and Data Governance team on a daily basis to analyze requirements, and design and development technical solutions.
• Proven knowledge in capturing data lineage, table and column data definitions, valid values and others necessary information in the data models.
• Experienced in database performance tuning and data access optimization, writing complex SQL quires and PL/SQL blocks like stored procedures, Functions, Triggers, Cursors and ETL packages.
• Designed the Partitioning for tables according to business logic. Creation of Local/Global indexes depending on the types of queries to be performed on the tables.
• Experienced in Normalization and Demoralization processes, Logical and Physical data modeling techniques.
• Strong knowledge on clinical data Naming standards
• Improving the Performance of the SQL Queries, Functions, Procedures, Packages and Database Objects by creating Normal, Unique.
• 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 11g/10g/9i/8i/8.0, MS SQL SERVER, Erwin

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

Data Modeling: Erwin, MS Visio

Defect Tracking Tools: Quality Center, Test Director

Programming: SQL, PL/SQL, HTML, XML, Erwin, Erstudio

Operating Systems: Windows, Unix Linux

Tools: Toad, MS Project, MS PowerPoint, MS Excel, MS Word, MS Access

PROFESSIONAL EXPERIENCE

Confidential, NY

Data Modeler

Responsibilities:

• Created conceptual, logical and physical models based on requirements gathered through interviews with the business users
• Updated existing models to integrate new functionality into an existing application.
• Conducted one-on-one sessions with business users to gather data warehouse requirements.
• Analyzed database requirements in detail with the project stakeholders by conducting joint Requirement Development sessions.
• Developed normalized Logical and Physical database models to design OLTP system
• Combine business and technical knowledge to determine the most appropriate business needs.
• Analysing the business requirements for building data marts and data warehouse
• Design, developed, implement and maintained conceptual/logical/physical data models for complex data warehouses
• Developing Snowflake by normalizing the dimension tables.
• Develop logical specifications and user requirements to design solutions for the application environment
• Perform program analysis, design, code, test, implement, troubleshoot, and write documentation
• Create functional specifications, Source to Target Mappings and document findings
• Identify data elements needed to support new requirements
• Responsible for creating and executing test cases to validate ETL and report code changes made for break/fixes and new enhancements
• Responsible for creating global views for downstream consumption for various Users such as Data Warehouse, Frito Lay etc.
• Extensive experience in PL/SQL programming - Stored Procedures, Functions, Packages and Triggers
• Massaged the existing model to create new logical and physical models that formed the basis for the new application.
• Designing normalized and star schema data architectures using Erwin and forward engineering these structures into Teradata
• Used ERStudio for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Identified the most appropriate data sources based on an understanding of corporate data thus providing a higher level of consistency in reports being used by various levels of management.
• Verified that the correct authoritative sources were being used and that the extract, transform and load (ETL) routines would not compromise the integrity of the source data.
• Other similar professional responsibilities as needed.

Environment: ERStudio, Teradata, Oracle,Informix, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro, StarTeam, HP ALM Quality Center 12.20, Teradata SQL Assistant, Embarcadero Rapid SQL.

Confidential, Tampa, FL

Data Modeler

Responsibilities:

• Analyzed existing logical data model (LDM) appropriate changes to make compatible business logic.
• Created Physical Data Model (PDM) for the OLTP application using ER Studio.
• Created Data Models using IDEF1X methodology.
• Involved in data model reviews with internal data architect, business analysts, and business users with in depth explanation of the data model to make sure it is in line with business requirements.
• Worked at conceptual and physical (using IE methodology) database level to implement and build corporate enterprise information strategies.
• Performed data analysis and created the conceptual, logical, and physical data models for a variety of financial products including FX, Equities, Fixed Income, REPO, Convertible Bonds, Structured Products, Derivatives, CMOs, Warrants, Mutual Funds, Money Market Funds, Pools, Swaps, Hedge Funds, Private Equity, Liquidity, Market Data, Interest Rate Products, etc.
• Responsible for reformat and migration of existing security and derivative database information into new SQL Server database.
• Utilized Data scrubbing to ensure no errors exists across the data in process
• Worked on analyzing source systems and their connectivity
• Analyzed different options for heterogeneous database connectivity and defined policies for dealing with different source databases with ETL team.
• Worked with cross-functional teams and prepared detailed design documents for production phase of current customer database application
• Used SAS macro for pre-processing
• Involved in Data Collection and Data Modeling using IBM SPSS

Environment: ER Studio, Informatica Power Center 7.1.2, Sybase, Windows, Toad, PL/SQL, Oracle 9i, SQL Server 2000, SQL*Loader, AIX 5.0, Windows 2000, Macro, SPSS

Confidential, Los Angeles, CA

Data Modeler / Data Analyst

Responsibilities:

• Created conceptual, logical and physical models based on requirements gathered through interviews with the business users
• Updated existing models to integrate new functionality into an existing application.
• Conducted one-on-one sessions with business users to gather data warehouse requirements.
• Analyzed database requirements in detail with the project stakeholders by conducting joint Requirement Development sessions.
• Developed normalized Logical and Physical database models to design OLTP system
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin.
• Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, co-coordinated with DBAs' to apply the data model changes.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Maintaining and implementing Data Models for Enterprise Data Warehouse using ERWIN
• Create and maintain Metadata, including table, column definitions
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Responsible for defining the naming standards for data warehouse.
• Possess strong Documentation skills and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in sessions to identify requirement feasibility.
• Extensive experience in PL/SQL programming - Stored Procedures, Functions, Packages and Triggers
• Performed tasks such as data scrubbing to obviate the data errors that occur during migration
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Massaged the existing model to create new logical and physical models that formed the basis for the new application.
• Designing normalized and star schema data architectures using Erwin and forward engineering these structures into Teradata
• Eliminated errors in ERwin models through the implementation of Model Mart (a companion tool to ERwin that controls the versioning of models).
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Identified the most appropriate data sources based on an understanding of corporate data thus providing a higher level of consistency in reports being used by various levels of management.
• Verified that the correct authoritative sources were being used and that the extract, transform and load (ETL) routines would not compromise the integrity of the source data.

Environment: Erwin, SQL Server, Teradata, Oracle, DB2, Informix, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro, OBIEE.

Confidential, Bloomfield, CT

Data Modeler

Responsibilities:

• Analyzed the DW project database requirements from the users in terms of the tables which will be most useful.
• Collected the information about the existing ODS by reverse engineering.
• Analyzed the requirements for developing Conceptual model.
• Worked on all SDLC methodologies most importantly Agile Methodology
• Normalized the entities and de-normalized them for the DW.
• Defined relationships, cardinalities among entities.
• Created fully normalized till 3rd Normalization technique using Power Designer.
• Wrote PL/SQL Stored Procedures, Functions, Views, Packages and Triggers to implement business rules into the application.
• Involved in Data Loading and Data Migration. Used SQL*Loader to load data from Excel file into Temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Developed queries using PL/SQL and many stored procedures to do the validations.
• Created and maintained Database Objects (Tables, Views, Indexes, Sequences, Database triggers, stored procedures etc).
• Possess strong Documentation skills and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in sessions to identify requirement feasibility.
• Extensive experience in PL/SQL programming - Stored Procedures, Functions, Packages and Triggers
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Massaged the existing model to create new logical and physical models that formed the basis for the new application.
• Designing normalized and star schema data architectures using Erwin and forward engineering these structures into Teradata
• Eliminated errors in ERwin models through the implementation of Model Mart (a companion tool to ERwin that controls the versioning of models).
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Identified the most appropriate data sources based on an understanding of corporate data thus providing a higher level of consistency in reports being used by various levels of management.
• Verified that the correct authoritative sources were being used and that the extract, transform and load (ETL) routines would not compromise the integrity of the source data.

Environment: Erwin, SQL Server, Teradata, Oracle, DB2, Informix, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro, OBIEE.

Confidential, NE

Data Modeler

Responsibilities:

• Logical & Physical Data Modeling - ER Modeling & Dimensional Modeling.
• Normalizing the tables/relationships to arrive at effective Relational Schemas.
• Identifying the facts & dimensions; grain of fact, aggregate tables for Dimensional Models.
• Developing Snowflake Schemas by normalizing the dimension tables as appropriate.
• Implementation of Business Rules in the Database using Constraints & Triggers.
• Dimensional Data Modeling to deliver Multi-Dimensional STAR schemas.
• Worked with data compliance teams, Data governance team to maintain the data models, Metadata, Data Dictionaries; define source fields and its definitions.
• Availed Data scrubbing techniques to eliminate data inconsistencies during data processing
• Participate in biweekly technical huddle meeting with development and DBA team. Participate in weekly data analyst meting and submit weekly data governance status.
• Rapid Audit of the requirements and existing systems; Requirements & Business Process Analysis.
• Developed, Implemented & Maintained the Conceptual, Logical & Physical Data Models using tools like ERwin Data Modeler 4.x, ER/Studio 7.x (ER Studio)- Forward/Reverse Engineered Databases.
• Design & Implementation of Data Marts; DBA coordination; DDL & DML Generation & usage.
• Convert models from CA ERwin to ER/Studio 7.5 (ERStudio); developed numerous macros.
• Metadata & Data Dictionary Management; Data Profiling; Data Mapping.
• Compiles and maintains the Enterprise Schema across all applications. Enforces principles of good canonical data design.
• Performance Tuning (Database Tuning, SQL Tuning, Application/ETL Tuning).
• Designing Data Flows & System Interfaces - Service Oriented Architecture (SOA) & Web Services.
• Architecting Work Flows, Activity Hierarchy & Process Flows; Design EDW / CDW components.
• Metadata Repository, Data Dictionary; Documentation using Interface Diagrams, Flow Charts.
• Assist developers in Performance Tuning & discussing Design Patterns/high level application design.

Environment: DB2 UDB 8.x, Oracle 11g/ 10g, SQL Server 2005/ 2000, Sybase data server 12.5, UNIX, Toad, Business Objects, Ab Initio, Teradata V2R6, Embarcadero ER/Studio 7.5 (ER Studio), Business Objects, XML, XSD, AIX, Java / J2EE

Confidential

Data modeler

Responsibilities:

• Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications.
• DesignedStar and Snowflake Data Modelsfor Enterprise Data Warehouse using ERWIN
• Validated and updated the appropriateLogical Data Modelsto process mappings, screen designs, use cases, business object model, and system object model as they evolve and change
• Generated user and technical documentationfor 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 in corporate 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
• Used Data gap for analyzing existing data

Environment: Erwin 4.0, SQL Server 2000, MS-Excel, Visio, MS-Access, Oracle, SQL, PL/SQL, Data Gap