SUMMARY

• 7 + years in data warehousing and dimensional modeling concepts
• 7 + years proven experience providing data analysis and profiling services
• 7+ years of demonstrable experience providing data analysis expertise contributing towards Master and Reference data management solutions
• Excellent SQL coding skills 6 + years conducting data profiling using SQL queries for data quality.
• Solid understanding of data warehouse concepts and ETL design.
• Experienced in developing logical and physical data models for OLTP and OLAP.
• Ensure teh quality of data submitted in developing detailed metadata for models
• Experienced in Designing models dat translate business and regulatory rules and definitions
• Experienced in Designing data models for development of new transactional systems.
• Design data models for development of a data warehouse and data marts from front door.
• Reverse engineer data models from existing databases and systems and organizing teh core subject area models.
• Experienced in identifying teh Facts and Dimensions from teh Enterprise Architecture for designing teh Star and Snowflake Schema.
• Experience in developing Entity - Relationship diagrams and modeling Transactional Databases in 3NF and using tools like Erwin, ER/Studio and Netezza Power Designer.
• Hands on experience using Erwin in both forward and reverse engineering cases.
• Efficient in enterprise data warehouses using Kimball data warehouse and Inmon’s methodologies, good in building various logics to handle Slowly Changing Dimensions,
• Change Data Capture and Deletes for incremental Loads in to teh Data warehouse and determining teh hierarchies in dimensions.
• Good understanding SQL, PL/SQL stored procedures, triggers, partitions, Primary Keys, Primary Index’s, Partitions, Teradata SQL Assistant.
• Proficient in Oracle Tools and Utilities such as TOAD, SQL*Plus and SQL Navigator.
• Good experience in giving join conditions to business analysts, developing data mapping from source to stage and stage to target database schemas and also data cleansing.
• Strong Database experience using Oracle 10g/9i, XML, DB2,Teradata, SQLserver
• Ability to adjust quickly to teh new business Software Development Lifecycle Environment.
• Excellent problem solving and analytical skills wif exceptional ability to learn and master new technologies efficiently.

TECHNICAL SKILLS

Data analysis: Requirements Gathering, JAD sessions, Process/Production Model analysis, Data Normalization, Cleansing, Profiling, System Design, Data architecture internal Standards development, Metadata, Bulk Editor and Reports, Source and Target system Analysis, Project Management.

Data modeling tools: CA Erwin 7.5.3/ 8.2.3 ,& 9.1Netezza Power designer 12x, ER/Studio 9.0.1, Toad data modeler, Visio tool, IBM Data Architect, MS Visio

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

ETL Environment: Informaticav8 & v9, Microsoft SSIS, DataStage

Operating systems: Microsoft windows 2000/2003/NT/2007/2008

Languages: T-SQL, PL/SQL, Basic C & Unix.

Additional QA Skills: Business and Software Process and Procedure Definition, Quality Models, data standards, Measures and Metrics, Project Reviews, Audits and Assessments. Provide Assistance to Production Issues

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Data Modeler/Analyst

Responsibilities:

• Gatheird teh business requirements by conducting a series of meetings wif business users.
• Created logical data model from teh conceptual model and it’s conversion into teh physical database design using Erwin.
• Map business needs/requirements to subject area model and to logical enterprise model.
• Involved wif data analysis using Teradata SQL assist from data source.
• Reviewed models wif DBA has to best fit physical Model Indexes for better DB performance.
• Reviewed Entities and relationships in teh engineered model and cleansed unwanted tables/ columns as part of data analysis responsibilities.
• Developed teh data warehouse dimensional models &schema for teh proposed central model for teh project.
• Developed many subject models from scrap.
• Created Logical/Physical Data models in 3NF in teh Warehouse area of Enterprise Data Warehouse.
• Created 3NF business area data modeling wif de-normalized physical implementation data and information requirements analysis using Erwin tool.
• Worked on teh Snow-flaking teh Dimensions to remove redundancy whenever required.
• In order of better understanding teh requirement documents, carried out couple of JAD sessions wif Management, SME (Subject Matter Expertise), vendors, users and other stakeholders.
• Ensured production data being replicated into teh ODS and teh Data Warehouse wifout any data anomalies from teh processing databases.
• Created Design Fact & Dimensions Tables, Conceptual, Physical and Logical Data Models using Erwin tool.
• Worked wif Architecture team to get teh metadata approved for teh new data elements dat are added for dis project.
• Involved using ETL tool Informatica to populate teh database, data transformation from teh old database to teh new database.
• Maintained teh integrity of data and data quality.
• Conducted data profiling for better understanding of joins in ER models
• Involved in high level ETL design review sessions and assisted ETL developers in teh detail design and development of ETL maps using Informatica.
• Worked wif project release meeting manager for UAT tables going to production.
• Handled metadata publish tasks to our internal data dictionary from internal DB MS Access
• Did Performance Tuning of teh database which included creating indexes, optimizing SQL Statements & monitoring teh server.
• Assisted Reporting developers in building Reports using Crystal Reports.

Environment: SQL Server 2000/ 2005/2008 , Oracle11g, Teradata 13, Erwin Data Modeler 8.2.3, Windows XP/2007/2008, MS office 2010, Access, Visio, Informatica 9.1, and SharePoint.

Confidential, Detroit, Michigan

Data Modeler/Analyst

Responsibilities:

• Interacting wif business users to analyze teh business process, their requirements and transforming requirements into Conceptual, logical and Physical Data Models.
• Involved in designing database level tables, documenting and rolling out teh deliverables.
• Conducted analysis and data profiling of potential data sources, upon high level determination of sources during initial scoping by teh project team.
• Coordinated data profiling/data mapping wif business subject matter experts, business system analysts, data stewards, data architects, and ETL developers.
• Developed logical/ physical data models using Erwin tool across teh subject areas based on teh specifications and established referential integrity of teh system.
• Handled maintenance and small enhancements to existing production tables
• Created various subject area read roles and new date columns for feed tables.
• Involved in dimensional modeling, identifying teh Facts and Dimensions, reviewing logical and physical data models
• Defined views in Teradata level and get it approved wif DBA’s
• Assisted business analysts in doing conceptual models/data profiling according to teh sample data sets they has from business users
• Maintain and enhance data model changes and furnish wif definitions, 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 for database modification, Teradata Macros, Views and set/multiset tables.
• Re-designed teh campaigns at teh core data ware house level
• An enthusiastic and project-oriented team player wif solid communication and leadership skills and teh ability to develop different solutions for challenging client needs.

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

Confidential, Cleveland, OH

Data modeler/Business System Analyst

Responsibilities:

• Involved in gathering business requirements and translated business requirements.
• Actively participated inJAD sessionswif teh subject matter expert, stake holders and other management team in teh finalization of User Requirement Documentation.
• Created teh DDL scripts using ER Studio and source to target mappings (S2T- for ETL) to bring teh data from JDE to teh warehouse.
• Experience in identifying entities required and teh relation between teh entities to create Conceptual logical model.
• Worked on JCL to instruct teh system on run a batch job and to start a subsystem.
• Efficiently developed theData model and ERD diagrams using Power designer.
• Created and maintained Logical Data Model (LDM) for teh project which includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Validated and updated teh appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change.
• Creating of teh XML data model for teh Express PA project for teh Rules engine and providing teh model in .XSD format for teh services team.
• Creating teh mapping documents to teh find out teh gaps between teh mockup screens, services and database.
• Identifying teh gaps and fills those gaps in teh database by communicating wif DBA.
• Enhancing teh existing data model by reverse engineering by adding new tables based on teh business requirements which will enhance in web services.
• Identifying teh required fields for teh Drug and Coverage check web services in teh database and understanding initial data loading Process.
• Creatinglogical and physical model databaseandschema in oracle.
• Reverse engineering existing database to conduct source data analysis to identify teh relationship between data sources.
• Worked wif DBA to finalize teh DDL’s.
• Worked on rationalizing teh requirements across multiple product lines.
• Had brain storming sessions wif application developers and DBAs to discuss about various denormalization, partitioning and indexing schemes for physical model.
• Schema Replication for development purpose using Power designer.
• Creating of teh database scripts using Power designer and submitting to teh DBA.
• Normalizing teh Data and Developing teh Relational database for teh different web services and database.

Environment: Erwin 7.2/7.3 Oracle 10g, Power designer, JCL, Oracle SQL developer, SQL plus, Visio, MS office, CVS, Putty, Soap UI.

Confidential, Denver, CO

Modeler/ Analyst

Responsibilities:

• Responsibilities: Analyzed existing logical data model (LDM) and made appropriate changes tobe compatible wif business logic.
• Created Physical Data Model (PDM) for teh OLTP application using ER Studio.
• Involved in data model reviews wif internal data architect, business analysts, and business users wif in depth explanation of teh 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

Systems Analyst

Responsibilities:

• Responsible for accuracy of teh data collected and stored in teh corporate support system
• Worked on analyzing source systems and their connectivity
• Performed data review, evaluate, design, implement and maintain company database
• Involved in construction of data flow diagrams and documentation of teh processes
• Interacted wif end users for requirements study and analysis by JAD (Joint Application Development)
• Performed gap analysis between teh present data warehouse to teh 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 teh data modelers to identify entities and relationship for data modeling
• Actively participated in teh design of data model like conceptual, logical models using Erwin

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