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, Snowflake 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 ERWIN reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, co-coordinated wif DBAs’ to apply the data model changes.
• Experienced wif Dimensional data modeling for Data Marts
• Extensive experience in gathering business requirements, implementing business processes, identifying risks, impact analysis and UML modeling
• Utilized RUP (Rational Unified Process) to configure and develop processes, standards, and procedures
• Possess strong Conceptual and Logical Data Modeling skills, has experience wif JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications, queries.
• Created/maintained/modified database design document wif detailed description of logical entities and physical tables.
• Excellent noledge of waterfall and spiral methodologies of Software Development Life Cycle (SDLC).
• Expertise in Software Development Life Cycle Process (SDLC), Use Cases and Rational Unified Process (RUP).
• Well versed wif various software development methodologies (SDLC, Agile Methodology, Extreme Programming, MSF)
• Dimensional Modeling was done using SSAS where cubes were built containing Facts, Measures and dimensions these cubes were generated using Data Source Views, build, deployed and processed to be analyzed in the cube browser.
• Perform Data Profiling to assess the risk involved in integrating data for applications, Teradata system
• Possess strong Documentation skill and noledge sharing among Team, conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
• Extensive Experience working wif 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 designing including schema and table design, stored procedures, Triggers, Views, and Indexes & Primary Keys.
• Possess a strong analytical, verbal, inter-personal skill that halps in communicating wif developers, team members.
• Expertise in writing business and software development processes and procedures.

TECHNICAL SKILLS

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

Business Skills: Knowledge & skillset of complete data warehouse, front end requirements gathering, business process analysis, business environment, market research Analysis, project management, agile (Sprints/spikes), dimensional Modeling, relational modeling, OLTP designing, metadata skills, development of standards and documentation for datawarehouse and Production support in ETL

Data Modeling Tools & ETL: ER-Studio, DataMart, Erwin Data modeler workgroup v8.2/7.x/4.x, MS Visio, Informatica 9.1, Congo’s BI reporting Modeler

Defect Tracking Tools: Mercury Interactive Suite: Test Director 8.0, Quality Center

Programming: SQL, PL/SQL, HTML, C/C++, XML.

Operating Systems: Windows NT/2000/XP/2007/2010.

Tools: Toad, command editor, MS Project, MS Office 2003/2010

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Data Modeler/Data Analyst

Responsibilities:

• Attended and participated in information and requirements gathering sessions
• Ensured that business requirements can be translated into data requirements
• Involved in the analysis of the existing claims processing system, mapping phase according to functionality and data conversion procedure.
• Translated business requirements into working logical and physical data models.
• 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, glossary terms, etc.
• Experienced wif Dimensional data modeling for Data Marts
• 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.
• Created business requirement documents and integrated the requirements and underlying platform functionality.
• 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.
• Perform Data Profiling to assess the risk involved in integrating data for applications, Teradata system
• Created PL/SQL packages 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.
• Involved wif all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.

Environment: Power Designer 16/15, Erwin v9.1, SQL Server 2000/2005/2008, MS-Excel, Visio, MS-Access, Oracle, SQL, PL/SQL, Teradata, Informatica v9.1

Confidential, Dallas, TX

Data Modeler/Data Analyst

Responsibilities:

• Interacting wif business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Conducted analysis and profiling of potential data sources, upon high-level determination of sources during initial scoping by the project team.
• Coordinated data profiling/data mapping wif business subject matter experts, data stewards, data architects, ETL developers, and data modelers.
• Developed logical/ physical data models using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
• Involved in dimensional modeling, identifying the Facts and Dimensions.
• Maintain and enhance data model wif changes and furnish wif definitions, notes, and reference values and check lists.
• Worked very close wif Data Architectures and DBA team to implement data model changes in database in all environments. Generate DDL scripts for database modification, Teradata Macros, Views and set tables.
• An enthusiastic and project-oriented team player wif solid communication and leadership skills and the ability to develop different solutions for challenging client needs.

Environment: SQL Server 2000/ 2005, Erwin 7.5.2, Windows XP, XML, Excel, Access, Visio.

Confidential, Houston, TX

Data Modeler/ Data Analyst

Responsibilities:

• Analyzed existing logical data model (LDM) and made appropriate changes to make it compatible wif 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 wif internal data architect, business analysts, and business users wif in depth explanation of the data model to make sure it is in line wif business requirements.
• Worked at conceptual and physical (using IE methodology) database level to implement and build corporate enterprise information strategies.
• Worked on analyzing source systems and their connectivity
• Analyzed different options for heterogeneous database connectivity and defined policies for dealing wif different source databases wif ETL team.
• Worked wif cross-functional teams and prepared detailed design documents for production phase of current customer database application.

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

Confidential

Business Analysis/Data Modeling

Responsibilities:

• 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
• Validated and updated the appropriate Logical Data Models to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change
• Generated user and technical documentation for processes in all phases of the project
• Conducted all data model reviews as appropriate during project lifecycle
• Coordinated wif 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

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

Confidential

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 denormalized 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).

Environment: Informatica Power Center, Designer, Work Flow Manager, Toad 8.0, Oracle 9i/8.0, Siebel, Trillium, PL/SQL, UNIX, Erwin 4.0/3.5.x, Windows XP/NT

Confidential

Systems Analyst

Responsibilities:

• Responsible for accuracy of the data collected and stored in the corporate support system.
• Performed data review, evaluate, design, implement and maintain company database.
• Involved in construction of data flow diagrams and documentation of the processes.
• Interacted wif end users for requirements study and analysis by JAD (Joint Application Development).
• Performed gap analysis between the present data warehouse to the future data warehouse being developed and identified data gaps and data quality issues and suggested potential solutions.
• Participated in system and use case modeling like activity and use case diagrams.
• Analyzed user requirements and worked wif the data modelers to identify entities and relationship for data modeling.
• Actively participated in the design of data model like conceptual, logical models using Erwin.

Environment: Erwin 3.x, Oracle 9.x, and MS Excel and Access.