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, ERStudio.
• 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 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.
• Created/maintained/modified data base design document with detailed description of logical entities and physical tables.
• 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.
• Possess strong analytical, verbal, inter-personal skill helps communicating developers, team members.
• 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.
• Experienced in Business requirements conformation, data analysis, data modeling, logical and physical database design and implementation.
• 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.
• Experienced in preparing Business Process Re-engineering Models.
• Improving the Performance of the SQL Queries, Functions, Procedures, Packages and Database Objects by creating Normal, Unique.
• Involved in performance tuning of queries to achieve high response times.
• Optimal in performing Database Tuning in reducing the Cost and Cardinality of the SQL.
• Assisted quality assurance team in preparing test scripts and test cases.
• Worked on Documenting Data Models, logic, coding, testing, changes and corrections.
• Utilized RUP (Rational Unified Process) to configure and 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, writing functional specifications, queries.
• Possess a strong analytical, verbal, inter-personal skill that helps in communicating with developers, team members.
• 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 10g/9i/8i/8.0, MS SQL SERVER 2000/2005,Erwin 7.x/4.x

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

Data Modeling: Erwin 7.x/4.x, MS Visio

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

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

Operating Systems: Windows NT/2000/XP

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

PROFESSIONAL EXPERIENCE

Confidential, VA

Data Modeler/Data Analyst

Responsibilities:

• Interacting with 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 with 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 changes and furnish with definitions, reference values and check lists.
• Worked very close with Data Architectures and DBA team to implement data model changes in database in all environments. Generate DDL for database modification, Teradata Macros, Views and set tables.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop different solutions for challenging client needs.

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

Confidential, TX

Data modeler/Data analyst

Responsibilities:

• Participated in JAD session with business users and sponsors to understand and document the business requirements in alignment to the financial goals of the company.
• Created the conceptual model for the data warehouse using Erwin data modeling tool.
• Reviewed the conceptual EDW (Enterprise Data Warehouse) data model with business users, App Dev and Information architects to make sure all the requirements are fully covered.
• Analyzed large number of COBOL copybooks from multiple mainframe sources (16) to understand existing constraints, relationships and business rules from the legacy data.
• Worked on rationalizing the requirements across multiple product lines
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.
• Implemented Agile Methodology for building an internal application.
• Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about the data model and business requirements.
• Worked with ETL to create source to target mappings (S2T).
• Forward Engineering to enhance the Data Structures Existing Database and Creating New Schemas.
• Worked on Mercury Quality Center to track defect logged against the logical and physical model.
• Had brain storming sessions with application developers and DBAs to discuss about various denormalization, partitioning and indexing schemes for physical model.
• Worked on Requirements Traceability Matrix to trace the business requirements back to logical model.

Environment: Erwin, DB2 v 4.8, Oracle 10g, Mainframe DB2, SQL Server 2000, SQL*Loader, Informatica Power Center 8.1.

Continental, Chicago

Data modeler/Data analyst

Responsibilities:

• Interacting with 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 with 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 data model with changes and furnish with definitions, reference values and check lists.
• Worked very close with Data Architectures and DBA team to implement data model changes in database environments. Generate DDL scripts for database modification, Teradata Macros, Views and set tables.
• An enthusiastic and project-oriented team player with 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) 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.
• 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.

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

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

Confidential

Database Developer

Responsibilities:

• Participated in the Design Team and user requirement gathering meetings.
• Analyzed specifications and identified source data needs to be moved to Data Warehouse.
• Extracted source data from Oracle, SQL Server, Flat files, XML using PL/SQL loaded into target Database.
• Developeddocumentationfor administrators to follow steps to add, modify, delete or change rights for different users of different departments.
• Involved in re-designing or customizing theexisting Viewsto suit the reporting needs.
• Created stored procedures, packages, triggers, tables, views, synonyms, and test data in Oracle.
• DevelopedPL/SQL scriptsto validate and load data into interface tables.
• Efficiently reduced the Cost and Tuned the SQL Queries by using various Hints and Optimizers on looking at the Explain Plan
• Scheduled sessions and batches on Informatica server using Informatics Server Manager.
• Created UNIX shell scripts for automating daily load processes.

Environment: ORACLE, PL/SQL, SQL, Microsoft Project, Microsoft Office Suite, MS SQL Server, Oracle 8.1, Windows 2000 server

Confidential

Data Modeler

Responsibilities:

• Analyzed the DW project database requirements from the users in terms of the tables.
• 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