OBJECTIVE:

To acquire a challenging position with an athletic company utilizing the opportunity to offer proven and developing skills within the company.

PROFESSIONAL SUMMARY:

• Seven years of qualified experience in data modeling and data analysis as a Proficient in gathering business requirements and handling requirements management.
• Experience in Software Development Life Cycle (SDLC) including System Analysis, Design, Data Modeling, Dimensional Modeling, Requirements Gathering, Decision Support and Implementation of various applications in OLTP and Data Warehousing.
• Experienced in designing the Conceptual, Logical and Physical data modeling using ER win and ER Studio Data modeling tools.
• Practical understanding of the data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Having good experience with Normalization(1NF,2NFand3NF) and De-normalization techniques for improved database performance in OLTP, OLAP, Data Warehouse and Data Mart environments.
• Experience in Data transformation, Data mapping from Source to Target database schemas, Data Cleansing.
• Experience in using and maintaining Metadata Management Tools for maintaining Business and Technical Metadata.
• Good experience in Data Modeling using Erwin r9.5/r9.1/r8/r 7.3/7.3.4/7.3.8 , ER Studio.
• Expert in writing SQL queries and optimizing the queries in Oracle 10g/11g, SQL Server 2008 R2/2012/2014.
• Extensive experience in development of Oracle SQL PL/Scripts.
• A good expertise in Extract, Transform and Load (ETL) data from spreadsheets, database.
• Have worked with ETL tools to extract, transform and load data from relational databases and various file formats and loaded to target database.
• Strong experience in Informatica and Data Stage ETL/ELT tools.
• A very good knowledge with dealing different types of data sources such as flat files, Excel, Oracle, Sybase, and SQL Server.
• Experience in using SSIS in solving complex business problems.
• Experience in building reports using SQL Server Reporting Services and Crystal Reports.
• Experience in creating, maintaining and designing database diagrams, setting table relationships and indexes.
• Forward Engineering the Data Models, Reverse Engineering on the existing Data Models and updates the data models.
• Created DDL scripts for implementing Data Modeling changes.
• Having good knowledge in Unified Model Language(UML) such as Use cases, Classes, Interaction, Sequence, state Diagrams, Deployment.
• Expert in Microsoft products that include Outlook, Word, Excel, PowerPoint, Visio .
• Created ERWIN reports in HTML, RTF, PDF format depending upon the requirement.
• Participated in JAD sessions, created Use Cases, Work Flows and Power Point presentations.
• Knowledge in NoSQL database technologies used in modern data warehouse architectures.
• Perform data analysis and profiling of source data.
• Excellent interpersonal and oral/written communication skills.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin r 7.3/7.3.4/7.3.8, Erwin r8, Erwin r9.1/9.5, Embarcadero ER/Studio, Oracle Designer, Sybase Power Designer

OLAP Tools: Microsoft Analysis Services, Business Objects and Crystal Reports9

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

Database Tools: Microsoft SQL Server 2008/2012/2014, MySQL, Oracle 11g/10g, DB2, MS Access 2007/2010 and Teradata V2R6.1, Sybase

Packages: Microsoft Office Suite, Microsoft Project 2010, SAP and Microsoft Visio.

ETL Tools: Informatica 7.1, Data junction, Data Stage, SSIS.

Other Tools: SAS Enterprise Guide, SAP ECC and Panorama Web Service, Code Flow/TFS

PROFESSIONAL EXPERIENCE:

Confidential, SFO, CA

Sr. Data Modeler/Data Analyst

Responsibilities:

• Gathering business requirements by organizing and managing meetings with business stake holders, Application architects, Technical architects and IT analysts on a scheduled basis.
• Analyzed the business requirements by dividing them into subject areas and understood the data flow within the organization
• Created conceptual & logical models, logical entities and defined their attributes, and relationships between the various data objects.
• Worked on data warehousing, ETL, SQL , scripting and big data (MPP + Hadoop).
• Updated existing models to integrate new functionality into an existing application.
• Conducted one-on-one sessions with business users to gather data warehouse requirements.
• Developed normalized Logical and Physical database models to design OLTP system
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r9
• Created DDL scripts for implementing Data Modeling changes.
• Created ERWIN reports in HTML, RTF format depending upon the requirement, Published Data model in model mart. created naming convention files, co-coordinated with DBAs’ to apply the data model changes.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Good understanding and knowledge of NZ-SQL, Netezza Tools and utilities.
• Involved in setting up events for proactive monitoring.
• Involved in Analyzing and Optimizing Query Performance .
• Have a good understanding of Optimizer and Query execution plans .
• Responsible for migrating the data and data models from SQL server and Oracle environment to Teradata environment and applied Big data and Hadoop on top of it.
• Maintaining and implementing Data Models for Enterprise Data Warehouse using ERWIN r9.
• Create and maintain Metadata, including table, column definitions.
• Synched up the models by reverse engineering, compare model and merge model from database to the original models.
• Responsible for defining the naming standards for data warehouse.
• Used Model Mart of Erwin r9 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Verified that the correct authoritative sources were being used and that the extract, transform and load (ETL) routines would not compromise the integrity of the source data
• Eliminated errors in ERwin models through the implementation of Model Mart (a companio tool to ERwin that controls )the versioning of models.
• Tuned the SQL Queries by breaking down the predefined queries into smaller queries for processing, Pushed Query processing up from the client to application server level.
• Evaluated Data Profiling, Cleansing, Integration and Extraction Tools.
• Generate weekly and monthly asset inventory reports.
• Possess strong Documentation skills and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in sessions to identify requirement feasibility.

Environment: Erwin r9, SQL Server 2014, Oracle 11g, Informix 16, MS Excel, MS Visio 2010, Requisite Pro 7.1, TOAD SQL, PL/SQL, Windows.

Confidential, Birmingham, AL

Data Modeler/Data Analyst

Responsibilities:

• Participated in all phases including Analysis, Design, Coding, Testing and Documentation. Gathered Requirements and performed Business Analysis.
• Extensively used SQL for Data Analysis.
• Done Reverse engineering on existing data model to understand the data flow and business flows.
• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) as per business requirements.
• Created Schema objects like Indexes, Views, and Sequences.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Developed normalized Logical and Physical database models to design OLTP system for insurance applications.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r9.1.
• Developing the Data Mart for the base data in Star Schema, Snow-Flake Schema involved in developing the data warehouse for the database.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis.
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.
• Responsible for defining the naming standards for data warehouse.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 and SQL Server database systems.
• Exhaustively collected business and technical metadata and maintained naming standards.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
• Extensively performed Manual Test Process.
• Extensively generated both logical and physical reports from ERwin.

Environment: Erwin r9.1, Informatica 7.1, Windows XP/NT/2000, SQL Server 2014, SQL, Oracle11g, DB2, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro

Confidential, NYC, NY

Data Modeler/SQL Developer

Responsibilities:

• Gathered and analyzed requirements from the end users and converted functional specifications to technical specifications documents.
• Reverse-Engineered numerous existing database schemas to get an understanding of existing database architecture.
• Created Data Model from scratch which involved a complete life cycle implementation that encompassed business requirement gathering, analyzing their source systems; and then building financial data mart in order to provide functionality for their reporting purposes.
• Created conceptual, logical & physical data models with Erwin and did design review meetings with other team members in order to finalize the model.
• Implemented advanced modeling concepts like Bus Matrix Architecture, Resolving Multi Valued dimensions, and Conform dimensions, Junk dimensions, Degenerate dimensions in designing multi-dimensional model.
• Created and developed Slowly Changing Dimensions tables SCD2, SCD3 to facilitate maintenance of history.
• To maintain the consistency and quality of the data worked with Data Governance, Data Profiling and Data Quality team that required managing the master data from all the business units as well as from IT and ensuring data quality standards across the enterprise.
• Developed and maintained enterprise data dictionary by interacting with data steward, data governance team.
• Divided model into subject areas for reflecting understandable view to business as well as data model reviewers.
• Created DDL for physical model using Erwin and handed over to the DBA team.

Environment: Orac1e 11g, ER Studio 9.0, Microsoft Visual Source Safe, SSIS, SQL Server 2012, T-SQL, PL/SQL, TOAD 8.5.

Confidential, Miami, FL

Data Modeler and Database Developer

Responsibilities:

• Analysis of functional Requirements and designing Conceptual data model.
• Involved in both Logical and physical data modeling.
• Developed stored procedures and complex packages extensively using PL/SQL and shell programs.
• Developed triggers, packages, procedures and functions using PL/SQL.
• Created Database Tables, Views, Indexes, Triggers and Sequences and developing the Database Structure.
• Data cleansing process on staging tables.
• Wrote a complex SQL, PL/SQL, Procedures, Functions, and Packages to validate data and testing process.
• Normalizing the Data and developing Star Schema.
• Performing Performance Tuning on the SQL Queries.
• Configuration Management (CM using Clear Case) and release management, Production Support (24X7).
• General DBA support including performance tuning, Oracle AQ management, migration plan execution.
• Gather, analyze, transform, and validate business requirements into system requirements.
• Handle daily operation and support and define standards, guidelines, and best practices.

Environment: Microsoft Visio, Erwin, Oracle 11g, MS SQL Server, MS Access 2010, Clear Case, Windows2000.

Confidential

Data Modeler/ Data Analyst

Responsibilities:

• Gathered and Translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Performed in team responsible for the analysis of business requirements and design implementation of the business solution.
• Developed logical and physical data models for central model consolidation.
• Worked with DBAs to create a best fit physical data model from the logical data model.
• Conducted data modeling JAD sessions and communicated data-related standards.
• Used Erwin r8 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities
• Developed process methodology for the Reverse Engineering phase of the project.
• Used reverse engineering to connect to existing database and create graphical representation (E-R diagram)
• Utilized Erwin’s reverse engineering and target database schema conversion process.
• Involved in logical and physical designs and transforms logical models into physical implementations.
• Created 3NF business area data modeling with de-normalized physical implementation data and information requirements analysis using ERWIN tool.
• Involved in extensive data analysis on Teradata, and Oracle Systems Querying and Writing in SQL and Toad.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle and SQL Server.
• Involved in different team review meetings.
• Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata.
• Developed Star and Snowflake schemas based dimensional model to develop the data warehouse.
• Performed unit testing and tuned for better performance.
• Involved in the critical design review of the finalized database model.
• Involved in the study of the business logic and understanding the physical system and the terms and condition for database.
• Worked closely with the ETL SQL Server Integration Services (SSIS) Developers to explain the Data Transformation
• Created documentation and test cases, worked with users for new module enhancements and testing.
• Designed and Developed Oracle database Tables, Views, Indexes with proper privileges and Maintained and updated the database by deleting and removing old data.

Environment: Erwin r8, Informatica 7.1,Teradata v2R6.1, Windows XP/NT/2000 servers, Oracle10g, SQL Server 2012, MS Excel, MS Visio, DB2, Microsoft Transaction Server, Crystal Reports, MS-SQL server analysis manager.

Confidential

Data Analyst

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement Specification document.
• Created a logical design and physical design in Erwin
• Created ftp connections, database connections for the sources and targets.
• Maintained security and data integrity of the database
• Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures and Collections.
• Worked extensively with XML schema generation.
• Participated in Performance Tuning using Explain Plan and Tkprof.
• Extensively used ERwin for developing data model using star schema methodologies.
• Created Unix Shell Scripts for automating the execution process.
• Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs.

Environment: Erwin, MS Excel, Oracle 10g, SQL, PL/SQL, MS VISIO, SQL*Loader and UNIX.