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 teh 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 teh 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 teh 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 teh 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 teh BI, ETL Developers, Project Manager and end users in understanding teh Data Model, data flow and teh 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 teh 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 teh 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 teh normal forms on teh OLTP database.
• Gathered and analyzed existing physicaldatamodels for in scope applications and proposed teh changes to thedatamodels according to teh requirements.
• Worked with teh Data Architect in defining and maintaining database design standards
• Used Model Mart of Erwin for TEMPeffective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Created dimensional model for teh 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 teh 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 teh Physical Data Model and handed it to teh DBA.
• Worked on large data warehouse Analysis services servers and developed teh different reports for teh 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 teh analysis of business requirements and design implementation of teh business solution.
• Developed Conceptual, Logical and Physical data models for central model consolidation.
• Used Erwin r7.3 for TEMPeffective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Facilitated transition of logical data models into teh physical database design and recommended technical approaches for good data management practices.
• Worked with DBA group to create Best-Fit Physical Data Model from teh 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 teh Oracle environment to meet teh customer requirements.
• Redefined attributes and relationships in teh model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Worked on teh reporting requirements and involved in generating teh reports for teh Data Model.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Generated DDL statements for teh 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 teh data.
• Create shell scripts to run teh Processes at time schedule according to business rules.
• Created teh indexes to optimize teh performance of teh data retrieval process.
• Tested all teh new and modified program units.
• Extensively used Database triggers, PL/SQL procedures, packages and functions while developing teh forms and reports.

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