SUMMARY:

• Over 6 years of working experience as a Data Modeler and Data Analysis with high proficiency in requirement gathering and data modeling including design and support of various applications in OLTP, Data Warehousing, OLAP and ETL Environment
• Extensive experience in data warehouse complete life cycle
• Extensively experienced in using tools like SQL Plus, TOAD, SQL Developer and SQL Loader.
• Excellent Data Warehousing concepts including Meta data and Data Marts.
• Excellence in delivering Quality Conceptual, Logical and Physical Data Models for Multiple projects involving various Enterprise New and Existing Applications and Data Warehouse.
• Expertise in Data Modeling using tools likes ERWIN along with the hands on experience in using Forward Engineering and Reverse engineering functionality.
• Experienced in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Proficient in data mart design, identifying facts & dimensions, star & snowflake schemes
• Experienced in Data Modeling using designed tool Erwin, Oracle SQL Developer, SQL Server Management studio, My SQL, SQL Plus and Toad.
• Management of Data integrity, Data standard, Data enhancement, Data publishing, data capture, data migration, Data auditing, Data Quality, Data Exception Handling process, Data Rejection process, Meta data, workflow
• Having experience in writing complex SQL queries to perform end - to-end ETL validations and support Ad-hoc business requests. Also good in developed Stored Procedures, Triggers, Functions, Packages using SQL/PLSQL.
• Excellent knowledge on creating reports on SAP Business Objects, Webi reports for multiple data providers.
• Strong Database experience using Oracle 12c/11g/10g/9i, XML, DB2, SQL server
• Experience in testing Business Intelligence reports generated by various BI Tools like Business Objects
• An excellent team player& technically strong person who has capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in the project.

TECHNICAL SKILLS:

Modeling Tools: Erwin 8.0, r9, ER/Studio, MS Visio

ETL Tools: Informatica Power Center

Languages: SQL, PL/SQL, T-SQL, XML, HTML, UNIX Shell Scripting, C, C++

Databases: MS SQL Server, DB2 UDB, MS Access, Oracle

Operating Systems: Windows 8/7/XP, UNIX (AIX)

Testing Tools: Test Director, Quick Test Pro, Quality Center

PROFESSIONAL EXPERIENCE:

Confidential, CA

Data Analyst

Responsibilities:

• Worked on data analysis, data profiling, data modeling, data mapping and testing for a given task
• Worked with DBA to create the physical model tables. Scheduled multiple brain storming sessions with DBAs and production support team to discuss about views, partitioning and indexing schemes case by case for the facts and dimensions.
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• Developed mapping spreadsheets for ETL team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, Transformation Rules and corporate meta-data definitions.
• Helped the BI, ETL Developers, Project Manager and end users in understanding the Data Model, data flow and the expected output for each model created
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository
• Managed full SDLC processes involving requirements management, workflow analysis, source data analysis, data mapping, metadata management, data quality, testing strategy and maintenance of the model.
• Consolidate and audit metadata from disparate tools and sources, including business intelligence (BI), extract, transform, and load (ETL), relational databases, modeling tools, and third-party metadata into a single repository.
• Expert level understanding of using different databases in combinations for Data extraction and loading, joining data extracted from different databases and loading to a specific database.
• Extensively used Erwin as the main tool for modeling along with Visio
• Used SQL on a wide scale for analysis, performance tuning and testing

Environment: Microsoft SQL Server 2008/2005, IBM DB2 9.X, SQL, Erwin 8.x/9.x, Visio, Informatica, Business Objects XI, MS Access.

Confidential, SFO, CA

Data Analyst / Data Modeler

Responsibilities:

• Involved in extensiveDatavalidation using SQL queries and back-end testing
• Designed star schemas and bridge tables to control slowly changing dimensions. Applied the normal forms on the OLTP database.
• Gathered and analyzed existing physicaldatamodels for in scope applications and proposed the changes to thedatamodels according to the requirements.
• Worked with the Data Architect in defining and maintaining database design standards
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Created dimensional model for the reporting system by identifying required dimensions and facts usingErwin r8.1
• Collaborated with other data modeling team members to ensure design consistency and integrity
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks) Created reports based on database usage and perform capacity planning. Responsible for creating user groups and assigning permissions.
• Worked with Database Administrators (DBA) to build conceptual and physical database models.
• Used forward engineering to generate DDL from the Physical Data Model and handed it to the DBA.
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that server

Environment: ERWIN r7.x/8.x, MS SQL Server 2008/2005, IBM DB2 8.1/9.1, Toad For DB2, Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.

Confidential, NC

Data Analyst

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Responsible for the analysis of business requirements and design implementation of the business solution.
• Developed Conceptual, Logical and Physical data models for central model consolidation.
• Used Erwin r7.3 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Facilitated transition of logical data models into the physical database design and recommended technical approaches for good data management practices.
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward Engineering.
• Involved in designing Data marts by using Star Schema and Snowflake schema.
• Extensive system study, design, development and testing were carried out in the Oracle environment to meet the customer requirements.
• Redefined attributes and relationships in the model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Worked on the reporting requirements and involved in generating the reports for the Data Model.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Generated DDL statements for the creation of new database objects like table, views, indexes, packages and stored procedures.
• Tuning and code optimization using different techniques like dynamic SQL, dynamic cursors, tuning SQL queries, writing generic procedures, functions and packages

Environment: Erwin 7/8, Informatica, Oracle 9i/10g, SQL Server 2005, MS Excel, MS Visio, Crystal Reports, DB2 UDB.

Confidential

QA Tester

Responsibilities:

• Involved in System Coding, Data conversion, Development and Implementation.
• Involved in Normalizing of database to remove data redundancy.
• Prepared Entity Relationship diagrams (Physical & Logical).
• Created tables, views, synonyms and sequences, Database Triggers, Stored Procedure, Functions and Packages.
• Created database objects like tables, views, synonyms, indexes and sequences.
• Used SQL Loader and Export, Import utilities to load / Extract the data.
• Create shell scripts to run the Processes at time schedule according to business rules.
• Created the indexes to optimize the performance of the data retrieval process.
• Tested all the new and modified program units.
• Extensively used Database triggers, PL/SQL procedures, packages and functions while developing the forms and reports.

Environment: Informatica Power center6.2/7.1, Oracle 9i, SQL, PL/SQL, Windows XP, UNIX, MS Office.