SUMMARY

• 5+ years of Professional experience as a Data Modeler, Data Analyst and SQL Programmer Analyst in IT Management, Health Care Insurance, Finance and Software domains and intuitive conceptual,logical,relational and physical data models.Versatile and a proven fast learner, problem - solver.
• An IT professional withextensive experiences in all phases of software development life cycle (SDLC) including system analysis anddata modelling.
• Excellent knowledge of waterfall and Agile methodologies of software development life cycle(SDLC).
• Having good experience as a Data Modeler, Data Analyst and SQL Programming Developer.
• Solid experience in designing the conceptual, logical and physical data modeling using Erwin, ERstudio and IBM Infosphere Data Architect data modelling tools.
• Good experience in business analysis, reviewing, analyzing, evaluating business systems and user needs, business modeling.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, Star and Snowflake Schema Modeling.
• Excellent experience in Data Modeling using Erwin r9.7/9.6/r9.1/r8.2
• Coherent with normalization / DE normalization techniques for improved database in relational / dimensional environments.
• Experience in using and maintaining Metadata Management Tools for maintaining Business and Technical Metadata.

TECHNICAL SKILLS

• Data Modeling Tools: ERwin r9.7/9.5, 9.6, ERwin r8.2, Embarcadero ER/Studio, IBM InfoSphere Data Architect, Oracle Designer.
• OLAP Tools: Microsoft Analysis Services, Business Objects and Crystal Reports 9.
• Programming Languages: SQL, PL/SQL, HTML, CSS, XML, C, C++, core java, UNIX and Python scripting(basic)
• Databases: Microsoft SQL Server 2012/2014 MySql, Oracle 11g/10g, DB2, Netezza and Teradata V2R6.1.
• SQL Programming Tools: Toad, Sql Developer, Aginity Workbench For Netezza,Microsoft Server Management Suite.
• Packages: Microsoft office Suite, Microsoft Project 2010 and Microsoft Visio.
• ETL Tools: Informatica 7.1/6.2, Data Junction, Data Stage.

PROFESSIONAL EXPERIENCE

Confidential, SAN FRANCISCO, CA

DATA MODELER / DATA ARCHITECTURE

Responsibilities:

• Participated in project planning session with business users and sponsors to understand and document the business requirements (scope documents) in alignment to the financial goals of the company.
• Design the Data model scope documents in the planning phase and translated business requirements into detailed, production-level technical specifications and created conceptual modelling.
• Design the Logical and Physical data model from data requirement. created Logical and Physical Data Models for central model consolidation.
• Worked with Web Portal Development Team, AIP, DBAs to create a best fit physical data model from the logical data model.
• Involved in Logical and Physical Designs and transforms logical models into physical implementations.
• Created Canonical Data Models for Directional purpose to Web Portal Development and AIP Team.
• Created 3NF business area data modeling with de-normalizedphysical implementation data and information requirements analysis using ERwin tool.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Have good Experience in Designing the Enterprise Data model.
• Provide leadership, mentorship and advisory services to IT and project teams to ensure that solutions for Enterprise Data model are in line with the architecture direction and business strategies.
• Highly collaborative, work across the company to drive adoption of technical standards, design principles and understand the architecture patterns for Enterprise Database Enhancements.
• Influence and communicate effectively with non-technical audiences including senior product and business management team with Design of Enterprise Data Model.

Environment: ERWIN r9.7/8.2.3, IBM InfoSphere Data Architect, Oracle 11g, Toad, SQL Developer,Aginity Workbench for Netezza, DB2, Microsoft Server Management Suite, SQL Server 2012/2014, DB2, Business Objects, IBM Information Governance catalog, JIRA,GRID.

Confidential, MN

INTERMEDIATE DATAMODELER

Responsibilities:

• Participated in requirement gathering session with IT Business Analysts, Subject Matter Experts (SME's), business users and Sprint Teams to understand and document the business requirements as well as the goals of the project.
• Consulted with client management and staff to identify and document business needs and objectives, current operational procedures for creating the conceptual data model.
• Determined data rules and conducted logical and physical design reviews with Business analysts, DBAs and developers.
• Worked as member of data governance and defined corporate metadata definitions for all Enterprise Data Supported Databases (Operational Source Systems, Data Stores and Data Marts).
• Extensively using the Erwin Design Tool&Erwin Model Manager to create and maintain data models.
• Assisting the programmer to upgrade the systems and programs as per organization requirements.
• Upgrading the Database design tools such as Erwin, SQL Developer, Toad
• Used Forward Engineering to enhance the Data Structures of the Existing Database and Create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Took a leadership role when working with the Data Warehouse Development (ETL) team to research and define existing source to target mapping for the corporate Data Warehouse.

Environment: : ERwin r9.1, Teradata v2R5/v2R6, Windows XP servers, Oracle11g, SQL Server 2012, MS Excel, MS Visio, DB2, Microsoft Transaction Server, Crystal Reports, MS-SQL Server Analysis Manager.

Confidential, PITTSBURGH, PA

DATA MODELER

Responsibilities:

• Participated in requirement gathering session with Subject Matter Experts (SME's), business users and owners.
• Consulted and have a JAD session with client management and staff to identify and document business needs and objectives.
• Determined data rules and scope of the reporting requirement and gathering all information to design the Conceptual model with Entity definitions.
• Worked with data governance team and defined corporate metadata definitions for all Enterprise Data Data warehouse and Marts.
• Extensively using the Erwin Model Manager to create and maintain data models.
• Assisting the SQL developers to deploy the DDL in to Dev Environments as per organization standards.
• Upgrading the Database design tools such as Erwin, SQL Developer, Toad
• Used Forward Engineering and Reverse Engineering to enhance the Data Structures of the Existing Database and complete compare the old database with new enhanced model.

Environment: : ERwin r8.2, Teradata v2R5/v2R6, Windows 7, Oracle11g, Netezza, SQL Server 2012, MS Excel, MS Visio, DB2, Microsoft Transaction Server, MS-SQL Server Analysis Manager.

Confidential

Intern Data Modeler /SQL Developer

Responsibilities:

• Worked with identified business users to define data requirements.
• Understood existing data model and documented suspected design affecting performance of the system
• Initiated and conducted JAD sessions for various teams to finalize the required data fields and their formats.
• Created logical data model from the conceptual model and its conversion into the physical database design.
• Developed Logical and Physical Data models by using Erwin r9
• Extensively used Star Schema and SnowflakeSchema methodologies in building and designing the logical data model into Dimensional Models.
• Aided and verified DDL implementation by DBAs, corresponded and communicated data and system specifications to DBA, development teams, managers and users.
• Applied second and third NF to normalize existing ER data model of OLTP system.
• Written Stored Procedures and Triggers extensively and working very closely with developers, business analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems.
• Created and modified stored procedures, triggers and cursors.

Environment: Erwin r8.2, Oracle 11g, SQL Navigator, PLSQL, Pro DB2, SQL server 2001, MS SQL server Analysis Manager, Sybase, Rational Requisite, Windows NT, Crystal Reports.