SUMMARY

• Over 8 Years of progressive IT experience in the field of Data modeling, Business and Data Analysis, Production Support, Database Management, Requirements Gathering, Application and Decision Support.
• Enterprise Data Modeler with a deep understanding of developing Enterprise Data Models that strictly meet Normalization Rules, as well as Enterprise Data Warehouses using Kimball and BillInmonData Warehouse Methodologies.
• Knowledgeable in Best Practices and Design Patterns, Cube design, BI Strategy and Designand 3NF Modeling.
• Extensive work experience on Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) system environment.
• Experience in Microsoft SQL database management, Software Development Life Cycle (SDLC) and Project Management using methodologies like Relational Unified Process (RUP), Agile and Waterfall.
• Expertise on forward and reverse engineering using tools like ERWIN, ER Studio and Data Architect.
• Experienced in working with RDBMS like Oracle 10g/ 9i/ 8i, Microsoft SQL Server 2008 R2 and Teradata.
• Proficient in designing of Star and Snowflake schemas with a very good understanding of fact and dimensional tables.
• Expertise inSQL queries, PL/SQL Packages,SQL Plus,StoredProcedures, Functions, Triggersand Performance Analysis,Creating Partitions, Indexes, Aggregating tables when required.
• Analyzing Target and Source database systems like Oracle 8i/9i/10g, SQL Server 2008, MySQL and Teradata using complex SQL code and working with multiple source types including flat files, CSV, RDBMS and spreadsheets.
• Experience in Extract, Transformand Load(ETL) data from spreadsheets, database tables and other sources using SQL Server Integration Services (SSIS) and SQL Server Reporting Service (SSRS) for managers and executives.
• Expertise in designing Conceptual, Logical and PhysicalData Models forvarious environments and business processes.
• Helped BI Report Development teams (Micro strategy) to build intelligent cube technology (MOLAP,ROLAP) and optimize complex cube SQL on OLAP star schema to achieve best performance.
• Strong analytical, communication skills that helps in communicating with business users, development team and project management staffs.

TECHNICAL SKILLS

Data Modeling Tools: Erwin Data modeler r 7.1/7.2/7.3/8.2, ER Studio 8.0/9.1/9.5, Power Designer 11.0/12.0/12.5, Toad data modeler

Reporting Tools: Business Objects XI, Crystal Reports

OLAP Tools: SSAS

ETL Tools: SSIS, SSRS, Informatica7.1.3/8, Data Stage

Databases: MSSQL servers 2000/2005/2008,, Teradata V2R5/V2R6/12,Oracle 8i/9i/10g/11g, DB2, MS Access 2003/2007/2010

Programming Languages: SQL, C, C++, .Net

Web Technologies: HTML, CSS, PHP

PROFESSIONAL EXPERIENCE

Confidential, Winston - Salem, NC

Sr. Data Modeler

Responsibilities:

• Developed OLTP system by designing Logical and eventually PhysicalDataModel from the Conceptual Data Model.
• Worked on normalization techniques. Normalized the data into 3rd Normal Form (3NF).
• Arranged various guiding sessions for Programmers, Engineers, System Analysts and others for clarification of performance requirements, interfaces project capabilities and limitations.
• Analyzed and presented the gathered information in graphical format for the ease of business managers.
• Produced Source to target data mapping by developing the mapping spreadsheets.
• Identified required dimensions and Facts using Erwin tool for the Dimensional Model.
• Validated business data objects to ensure the accuracy and completeness of the database.
• Represented existing business models by UML diagrams.
• Used Erwin tool to develop a Conceptual Model based on business requirements analysis.
• Implemented Snow-flak schema to ensure no redundancy in the database.
• Implemented Forward Engineering by using DDL scripts and generating indexing strategies to develop the logical data model using Erwin.
• Reverse Engineered physical data models from SQL Scripts and databases.
• Optimized and updated UML Models (Visio) and Relational Data Models for various applications.
• Supported SalesForce.com maintenance with services such as periodic data cleansing and workflow.
• Implemented ETL techniques for Data Conversion,Data Extraction and Data Mapping for different processes as well as applications.
• Maintained ReferentialIntegrity by Introducingforeignkeys and normalized the existing data structure to work with the ETL team and providedsource totarget mapping to implement incremental, full and initial loads into the target data mart.
• MaintainedDataConsistency by evaluating and updating logical and physical data models to support new and existing projects.
• Reviewed different codes and designs to ensure no ERRORS in the systems and to recommend required update if needed.
• Generated various reports using SQL Server Report Services (SSRS) for business analysts and the management team.
• DesignedOLTP system environment and maintained documentation of Metadata.
• Well experienced in documenting data relationships, business rules, allowed rules,evolvedglossary and codes.

Environment: Oracle 11g, TOAD 9.7, SSRS, Erwin Data Modeler 8.2, Erwin Model Manager 7.3, MS Visio, Windows Vista.

Confidential

Data Modeler/ Data Administrator

Responsibilities:

• Communicated with users and business analysts to gather requirements.
• Involved in business process modeling using UML.
• Involved in preparing Logical Data Models/Physical Data Models.
• Defined the calculations based on the reporting needs and the source data available
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Developed mappings in Informatica to load the data from various sources includes SQL server, DB2, Oracle, Flat files into the Data Warehouse, using different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator.
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using Erwin7.3 tool.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Developed data mapping documents between Legacy and User Interface Systems.
• Wrote PL/SQL statement, stored procedures and Triggers in DB2 for extracting as well as writing data.
• Created shared containers to simplify job design.
• Created job sequences to execute a set of jobs.
• Participated in weekly status meetings, Gained Hands-on experience in ITSM tools: Remedy 7.0, Active Directory.
• Conducted User Acceptance Testing on the application - resolved issues from the participants, prepared and submitted Test Analysis Reports and participated in Product Readiness Review.
• Prepared the documentation of Data Acquisition and Interface System Design.

Environment: Oracle 10g,Power Designer 9.0, Informatica7.1.3,MS Excel, SQL,Microsoft Windows Vista/Unix, Remedy7.0.

Confidential, Richmond, VA

Data Modeler/Data Analyst

Responsibilities:

• Involved in understanding of business processes to learn business requirements.
• Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business users
• Analyzed existing logical data model (LDM) and made appropriate changes to make it compatible with business requirements.
• Worked with DBA to create the physical model and tables using ERWin 7.2.
• Involved in creating entity relational and dimensional relational data models using Erwin tool.
• Worked closely with data warehouse architect and business intelligence analyst in developing solutions.
• Resolved the data type inconsistencies between the source systems and the target system using the mapping documents and analyzing the database using SQL queries.
• Performed extensive requirement analysis and developed use cases and workflow diagrams.
• Documented and delivered functional specification document to the project team.
• Conducted JAD sessions for communicating with stakeholders and project directors.

Environment: Oracle 10g,Sql Server 2008, My SQL, Erwin 7.3, Crystal Reports, MS Excel, SQL, Microsoft Windows Vista, Power Point, QC Explorer.

Confidential, Dallas, TX

Data Modeler/System Analyst

Responsibilities:

• Performed Data Modeling, Database Design, and Data Analysis with the extensive use of ER Studio (8.0)
• Conducted meetings and JAD sessions with Subject Matter Experts (SME) to gather various business requirements from Business Analysts and Data Analysts.
• Analyzed the gathered information and represented it to develop the Conceptual Model.
• Worked on spiral and waterfall methodologies of Software Development Life Cycle (SDLC).
• Optimized the database by cleansing the redundant data. Reverse Engineered by redefining various attributes and their relationships.
• Identified Facts and Dimensions involved in dimensional modeling.
• Ensured data model consistency by developing best practices for coding and standard naming conventions.
• Developed new training modules and conducted knowledge sharing sessions for engineer trainees.
• Performed Data Manipulation as a part of the application process.
• Developed Logical and the Physical Model from the Conceptual Model with the use of ER Studio.
• Worked on Rational Unified Process (RUP).
• Executed Test Scripts to verify the expected result.
• Developed the star schema of the data warehouse by De-normalizing the existing Database.
• Developed OLAP datamodel with enforced Referential Data Integrity.
• Developed various UML diagrams such as classsequence using Rational Rose Model.
• Proficient in GUI, Relational Database Model (RDBMS), designing of OLAP system environment as well as Report Development.
• Expertise in creating report models for building Ad-hoc Reports Using SSRS, Crystal Reports9 and Excel Spreadsheet.

Environment: Oracle 9i, ER Studio (8.0), SSRS,Crystal Reports9,Windows XP,Excel,Power Point.

Confidential

Data Modeler/Data Analyst

Responsibilities:

• Experience on slowly changing dimensions (SCD) and hierarchical dimensions.
• Involved in Data Analysis for the data warehouse and data mart system.
• Developed standards and guidelines to maintain and administer the SQL Server database.
• Involved in Source Data Analysis and designing mappings for data extraction.
• Utilized ERwin Data Modeler to capture Datamart requirements for a database design consisting of 100+ Tables across nine subject areas.
• Evaluated the data requirements and presented the integration plan to bring together existing BI Systems and create a customer centric view of its business.
• Developed, Tested and Implemented T-SQL scripts, Stored Procedures, Viewsand User Defined Functions.
• Created complex SSIS packages that deliver multiple data formats using LOOP and conditional sequential containers and .Net script tasks.
• Actively used salesforce.com to monitor data governance processes, usage and adoption at the application level.
• Developed dashboard reports using SQL Server Reporting Service (SSRS) for managers and executives.
• Analyzed long running/slow queries and tuned the same to optimize application and system performance.

Environment: Oracle 8i, Erwin 7.3.11, SQL Server, SSIS, SSRS,MS Access 2000/2003,Excel 97/2000/2003.

Confidential 

Data Analyst

Responsibilities:

• Developed the logical and physical model from the conceptual model developed using a tool Erwin by understanding and analyzing business requirements.
• Manipulating, cleansing & processing data using Excel, Access and SQL.
• Responsible for loading, extracting and validation of client data.
• Maintained the data integrity during extraction, manipulation, processing, analysis and storage.
• Analysing raw data, drawing conclusions & developing recommendations
• Executing SQL scripts to manipulate data for data loads and extracts.
• Developing data analytical databases from complex financial source data.
• Advising on the suitability of methodologies and suggesting improvements.
• Using Informatica& SAS to extract transform & load source data from transaction systems.
• Assisted for the development of Interface Design Model (IDM).
• Recommended required corrections by examining the new application proposal.
• Expertise in creating triggers, stored procedures, functions, views and SQL-Scripts.
• Maintained documentation using Crystal Reports.
• Data output - Made data chart presentations and coded variables from original data, conducted statistical analysis as and when required and provided summaries of analysis.

Environment: Oracle 8i, Erwin 4.1, SQL Server, Windows XP, MS Excel, Informatica.