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/Data Modeler

Responsibilities:

• Worked on data analysis, data profiling, data modeling, data mapping and testing for a given task
• Worked on Teradata Environment based on the data from PDM. Conceived, designed, developed and implemented this model from the scratch
• Worked with DBA to create the physical model and 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, SQL, Erwin 8.x/9.x, Visio, Informatica, Business Objects XI, MS Access.

Confidential, SFO, CA

Data Analyst / Data Modeler

Responsibilities:

• Involved in extensive Datavalidation 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 physical datamodels for in scope applications and proposed the changes to the datamodels 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, Teradata 6.2

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.