SUMMARY

• 7 Years of experience in the complete Software Development Life Cycle (SDLC)
• 7 years of functional and technical experience covering management cascades, source data analysis, business system analysis, architecture and design info layers, supporting ETL development, QA testing and deployment of various business applications.
• 7 years of strong data modeling experience using Erwin Data Modeler tools & ER Studio
• 7 years of experience in dimensional & relational modeling, star schema and snow - flake
• 7 years of experience in strong data profiling as a business system analyst.
• 7 years of technical experience in providing various templates for Erwin, Forward Engineer DDLs, and Reverse Engineer Database in to Unified Data Models, pre scripts,
• 7 years of experience in enhancing data ware house standards, governance sessions.
• 6 years of experience in generating ERWIN reports
• 7 years’ experience with metadata management, developed bridge connections & scripts to publish metadata into web dictionary using MS Access and Oracle ODBC servers.
• 6 plus years of experience in Conceptual and Logical, physical data modeling skills
• 7 years of business side experience as a data modeler and mid-level data architect
• 6 plus years conducted JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications, queries and SLA documentation over designed database objects for projects I handled.
• Effective use of features like model mart, bulk editor, design layers, complete compare, split model, model sources and transforms
• Identify models including sub type, super types and hierarchical layers.
• 6 plus experience about data profiling and analyzing business user requirements and fast delivery to business intelligence teams for reporting.
• ExcellentSQL coding skills, experience writing complex queries and working with various relational databases, installed database objects in all the relational databases.
• 5 Years of Experience in Teradata, acquired good SQL coding skills, Indexes, Partitioned fields, statistics, providing security roles to the database models.
• Experience in creating schema and table design, stored procedures, Triggers, Views
• Actively involved in gap analysis, Performance Tuning, Error handling Product support
• Excellent knowledge of Agile methodologies in data warehouse
• Worked as scrum master and modeler/analyst roles for projects in agile data warehouse
• 6 years experienced in financial banking, tax systems, insurance, operation risk management, mortgage, supply-chain, material management and health care domains.
• Experience working with business users/SMEs as well as senior management.
• Experience in architecting, maintenance of Data Warehouses on Teradata, Oracle, SQL.
• Strong understanding of the principles of Enterprise Data warehousing
• Optimum Proficient in using MS Office including MS Visio, MS Access and MS Project
• Experience in working with ETL - Extract, Transform, Load transactions using Informatica.
• Experience in using HTML, ASP, Visual Basic and basic Unix commands
• Assisted developers, ETL, BI team and end users to understand and maintain change log for each data model.
• Expert in developing SSIS/DTS Packages to extract, transform and load (ETL) data into data warehouse/data marts from heterogeneous sources.
• Strong analytical problem identification, problem-solving and communication skills.

TECHNICAL SKILLS

Data Analysis: Requirements gathering, JAD sessions, process model analysis and DFD analysis, Use-case analysis, data normalization, Data cleansing, profiling, system design, data architecture development, source and target system analysis, project management

Data modeling: Erwin 3.5/ 4.1.4/ 7. x, Erwin R8, Power designer 12.1, v15.3.0, ER/Studio 9.0.1, Toad data modeler, Visio tool

Database systems: Oracle (11g,10g/9i/8i/7.x), Teradata12/13, SQL server (2008/2005/2000 ), Sybase, MySQL, MS Access 2007, DB2

Operating systems: Microsoft windows 2007/XP/vista.

Programming languages: SQL, PL/SQL, C/C++, basic Unix commands

Quality assurance: Business and Software Process and Procedure Definition, Quality Models and standards, Measures and Metrics, Project Reviews, Audits and Assessments

Data Warehouse Environments: MS Visio, Agile, Waterfall, Erwin, ER Studio, Informatica, Data Stage, Teradata, Oracle and SQL, MS office

PROFESSIONAL EXPERIENCE

Confidential, Jackson, MS

Sr. Data Modeler

Responsibilities:

• Actively participated in gathering the business requirements by conducting a series of meetings with business users.
• Developed various Data ware house standards, metadata capture process, and SDLC enhancements
• Map business needs/requirements to subject area model and to logical enterprise model.
• Supported in providing solutions to business user needs in BI process using tools Congo’s, Crystal Reports, BO, OBI, and SSRS.
• Lead the analysts and testers with data analysis using SQL assist tools from data source.
• Extensive supported ETL developers in scheduling and understanding the SLA’s
• Worked with data base administrators in designing CSprie infolayer for above mentioned Promotion and Pricing Innovation project.
• Redesigned their OLTP billing system, for better database performance.
• Designed their treasury database for understanding the fund position flow circuit
• Handled CDC assignments and analyzed source data dictionary, developed source, stage, persistent stage and target tables, cleansed unwanted tables/ columns as part of data analysis responsibilities.
• Developed the data warehouse models (star schema) for the proposed central model for the project.
• Created Logical/Physical Data models in 3NF of Enterprise Data Warehouse.
• Created 3NF business area data modeling with de-normalized physical implementation data and information requirements analysis using Erwin tool.
• Identified Primary keys, indexes and table types based on source data and supports better performance for target database tables
• Worked on the Snow-flaking the Dimensions to remove redundancy.
• In order of better understanding the requirement documents, carried out couple of JAD sessions with Management, SME (Subject Matter Expertise), vendors, users and other stakeholders.
• Ensured production data being replicated into the ODS and the Data Warehouse without any data anomalies from the processing databases.
• Created Design Fact & Dimensions Tables, Conceptual, Physical and Logical Data Models using Erwin tool.
• Worked with Architecture team to get the metadata approved for the new data elements that are added for this project.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database.
• Created Teradata community in resolving production issue quickly
• Maintained the integrity of data to ensure the effective functioning and also monitored data quality.

Environment: Windows 2000/XP, Erwin 8.2, SQL server 2005/2008, Teradata, Business Objects XI, MS Excel 2007, Informatica 9.1.

Confidential, Jacksonville FL

Sr. Data Modeler

Responsibilities:

• Worked at conceptual and physical database level to implement and build corporate enterprise information strategies using Erwin Tool.
• 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.
• Designed a data model for storing various documents in Oracle Database
• Experience writing Queries in Oracle Database.
• Used Teradata Fast Load utility to load large volumes of data into empty Teradata tables in the Datamart for the Initial load.
• Used Teradata Fast Export utility to export large volumes of data from Teradata tables and views for processing and reporting needs.
• Involved with data analysis using Teradata SQL assist from data source.
• 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 with SSIS to import, export and transform the data between the linked servers.
• Extensively involved in various data modeling tasks including forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas, publishing model to PDF and HTML format, generating various data modeling reports etc
• Performed Analysis and designing of Star Schema Data Mart with Facts and Dimension.
• 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.
• Performed Data Analysis and Data validation by using TOAD against the Oracle database. Documented the application, implementation and day-to-day maintenance, configuration procedures of the system.

Environment: Erwin 8.2/ ER Studio, Toad, ORACLE, SQL*LOADER, Teradata, Windows XP, Excel, Access, Visio, Informatica 9.1

Confidential, Plano, 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.
• Worked on Bank Data ware house and Mortgage Data ware house.
• Developed logical/ physical data models using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
• Normalized the database to put them into the 3NF of the data warehouse.
• Used Teradata Fast Load utility to load large volumes of data into empty Teradata tables in the Datamart for the Initial load.
• Used Teradata Fast Export utility to export large volumes of data from Teradata tables and views for processing and reporting needs.
• Involved in dimensional modeling, identifying the Facts and Dimensions.
• Worked on SSIS tools likeImport and Export Wizard,PackageInstallation,and SSIS Package Designer.
• 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.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop different solutions for challenging client needs.
• Working Experience with ERwin R8 which supports SQL Server 2008.

Environment: ORACLE, SQL Server 2005/2008, Teradata, ERwin 7.1, Windows XP, Excel, Access, Visio.

Confidential, Tampa, Fl

Data Modeler

Responsibilities:

• Involved in Source code scanning and analysis.
• Derived logical data model from source systems.
• Obtained DDL of Production Data Stores.
• Mapped physical to logical definitions using ERWIN tool.
• Created logical data model with physical mapping for Financial Instrument subject area.
• Abstract EDM from physical data model.
• Standardize naming conventions to better reflect business needs, e.g. Address, etc…
• Assign primary keys to all tables; evaluate use of multiple dates in the primary keys.
• Evaluate use of ‘Blank’ and ‘Null’ as valid attribute values in entity definitions
• Eliminated repetitive attributes (e.g. numbered codes in tables should go to a separate table), levels and type codes, (e.g. simplify product table to make it more manageable through normalization; eliminate redundancies across databases, price and classification)
• Reduced total number of tables (e.g. avoid single attribute tables, many Issue tables)
• Developed logical models for Transaction - Events affecting client holdings or accounts, Client Account - Holding vehicle for assets, Products & Services - Firm service or offering, e.g. check writing, debit cards, etc.,Party - Individual or organization of interest to UBS WMA, Position - The intersection of a client account with a financial instrument, Financial Instrument - data & pricing for WMA instruments, Corporate Action - Any event that brings material change to a financial instrument, Operational Position Keeping - Real-time position and balances, General Ledger - Accounting books of business for UBS WMA
• Defined EDM for Subject Areas such as Financial Instrument, Party, Client/Account, And Operational Position Keeping. Defined mappings from EDM back to physical for the following subject areas:
• Financial Instrument to PDB, FPM, KAR
• Party to CRDB
• Client/Account to CRDB
• Operational Position Keeping to RPB
• Exported EDM to Virtualization-friendly format.
• Provided a consistent, structured view of the data for front-end applications.

Environment: DB2, VSAM, ORACLE, Erwin 7.5.2, Windows XP, Excel, Access, Vision.

Confidential

Business 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 with 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 with 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.