SUMMARY:

• 8+ 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.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Extensive experience in gathering business requirements, implementing business processes, identifying risks, impact analysis and UML modeling
• Excellent knowledge of waterfall and spiral methodologies of Software Development Life Cycle (SDLC).
• Experience in Designing the Data models for OLTP & OLAP database system.
• Exert in building Enterprise Data Warehouse or Data warehouse appliances from Scratch using both Kimball and Inmon Approach
• 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.
• Maintaining and implementing Data Models for Enterprise Data Warehouse using ERWIN 9.0/7.1/7.2/4.1/4.2/3.5
• 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.
• Created/maintained/modified data base design document with detailed description of logical entities and physical tables
• Good in Normalization (1NF, 2NF, 3NF and BCNF)/Denormalization techniques for effective and optimum performance in OLTP and OLAP environments
• Well versed in system analysis, ER/Dimensional Modeling, Database design and implementing RDBMS specific features.
• Well versed with various software development methodologies (SDLC, Agile Methodology, Extreme Programming, MSF)
• Experience in dealing with different data sources ranging from flat files, Excel, Oracle 11g/10g/9i, SQL Server 2008/05/03 and Informix 10/11.5
• Created data stage jobs using IBM InfoSphere Data Stage
• Extensively worked on Data Profiling concepts to maintain the data quality and data reliability
• Extensively worked on Data Cleansing or Data Scrubbing concepts to validate the corrupted data
• Excellent hands on experience in Master Data Management (MDM) when the organization having problems with the quality, consistent classification and identification of data
• 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.
• Experienced in writing SQL and PL/SQL scripts in Data warehousing applications involved in database design and Data modeling
• Expert in tuning the SQL queries by providing proper indexes, table partitioning and proving the optimized queries to the application team
• 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
• Create and maintain documentation and help information for teams utilizing core geospatial services around process, requirements, and test criteria for application development and deployment processes; Communicate these changes and updates to broad range of audiences and external vendors
• Expertise in writing business and software development processes and procedures.

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g/9i/8i, MS SQL SERVER 2000/2005/2008

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

Data Modeling: Erwin 9.0/7.1/7.2/4.1/4.2/3.5, Power Designer (v16.0/v16), ER studio and IBM Rational Data Architect v7, MS Visio 2007/2010

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

Languages: SQL, PL/SQL, HTML, XML

Operating Systems: Windows NT/2000/XP/7, UNIX

Tools: TOAD, command editor, MS Project, MS Office 2003/07/10

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis,MN

Data Modeler/ Tester

Responsibilities:

• Understand and translate business needs into data models supporting long-term solutions.
• Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• 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 power designer 16.5
• Created fully normalized till 3rd Normalization technique using Power Designer 16
• 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.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Recommend opportunities for reuse of data models in new environments.
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Evaluate data models and physical databases for variances and discrepancies.
• Validate business data objects for accuracy and completeness.
• Analyze data-related system integration challenges and propose appropriate solutions.
• Develop data models according to company standards.
• Review modifications to existing software to improve efficiency and performance.
• Examine new application design and recommend corrections if required.
• Conducted User Acceptance Testing (UAT)
• Understand the master test plan and/ or the project plan
• Create or assist in creating own test plan
• Generate test cases based on the requirements and other documents
• Report defects/results to the stakeholders
• Reply to returned bug reports (for example, when a bug report is returned as not reproducible)
• Re-test resolved defects
• Update test cases based on the discovered defects
• Provide inputs to the team in order to improve the test process
• Report work progress and any problems faced to the Test Lead or Project Manager as required
• Support the team with testing tasks as required

Environment: Power Designer 16.5, Teradata, PL/SQL, Oracle 9i, SQL Server PDW

Confidential, Bentonville, AR

Data Modeler / Data Analyst

Responsibilities:

• Gathered Business requirements by organizing and managing meetings with business stake holders, Application architects, Technical architects and IT analysts on a scheduled basis.
• Analyzed the business requirements by dividing them into subject areas and understood the data flow within the organization
• Created conceptual & logical models, logical entities and defined their attributes, and relationships between the various data objects
• Updated existing models to integrate new functionality into an existingapplication .
• Conducted one-on-one sessions with business users to gather data warehouse requirements.
• 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 r9
• 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 r9
• Create and maintain Metadata, including table, column definitions
• Synched up the models by reverse engineering, compare model and merge model from database to the original models
• Responsible for defining the naming standards for data warehouse.
• Creating PL/SQL packages - Stored Procedures, Functions and Triggers
• Used Model Mart of Erwin r9 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• UsedErwinfor 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).
• 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
• Eliminated errors in ERwin models through the implementation of Model Mart (a companion tool to ERwin that controls the versioning of models
• Tuned the SQL Queries by breaking down the predefined queries into smaller queries for processing, Pushed Query processing up from the client to application server level
• 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
• Assisted the ETL Developers and Testers during the development and testing phases
• Conducted User Acceptance Testing (UAT)
• Fixed bugs, tracked defects in usage and functionality of interfaces that helped increase the code efficiency

Environment: Erwin r9, SQL Server 2008, Oracle 11g, Informix 16, MS Excel, MS Visio 2010, Rational Rose 7, Requisite Pro 7.1, TOAD, SQL, PL/SQL, Windows XP/NT/2000

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
• Created business requirement documents and integrated the requirements and underlying platform functionality
• 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 power designer 16
• Created fully normalized till 3rd Normalization technique using Power Designer 16
• 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.
• Worked in Multi-User modeling environment which is Erwin Model Manager.
• Automated use of data naming standards by creating Erwin Macros
• 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.
• Designed the database tables & created table and column level constraints using the suggested naming conventions for constraint keys.
• 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.
• Used PL/SQL to developedstored procedures and triggers.
• Resolved the revolving issues by conducting and participating in JAD sessions with the users, architects, and developers
• Worked along with the testing team to derive test cases for efficient Data reporting

Environment: Power Designer 16/15, Erwin 7.5, SQL Server 2000/2005/2008, MS-Excel, Visio, MS-Access, Oracle 10g, SQL, PL/SQL, Windows XP, UNIX

Confidential, Dallas, TX

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 r7.0 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.
• Implemented the Slowly changing dimension scheme (Type II) for most of the dimensions
• Creating procedure for updating the data from factory systems, through Oracle PL/SQL
• Developed the required data warehouse model using Star schema for the generalized model
• Maintain and enhance data model with changes and furnish with definitions, notes, 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 scripts for database modification, Teradata Macros, Views and set tables
• Participated in User Acceptance Testing (UAT) of finished Reports and Dashboard and delivered the quality tested web application to the Logistics users

Environment: SQL Server 2000/ 2005, Erwin 7.0, XML, Excel 07, Access 07, Visio 2007, Windows XP

Confidential, Houston, TX

Data Analyst/ Data Modeler

Responsibilities:

• Analyzed existing logical data model (LDM) and made appropriate changes to make it compatible with 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

Sr Programmer

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 r4.0
• 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
• 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
• Provided input to resolve data limitation/constraints and issues

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

Confidential

Software Engineer

Responsibilities:

• Assisted in gathering Business Process Requirements and translated them into functional and non-functional requirements of the Business Requirement Document (BRD), which used as input to the functional design specifications
• Assisted in Creating Use Case/Activity /Sequence Diagrams in MS Visio 2003
• Worked along with the testing team to derive test cases for efficient Data reporting
• Conducted the Unit testing and prepared the testing document
• Worked with senior Business Analysts to create business requirements, workflow, environment details and plan phases in development
• Created SQL statements to validate the data table

Environment: MS Excel, MS Visio 2003, MS Power Point, J2EE, SQL