Professional Summary

• Over 8 years of experience in Software development and consulting industry involving and support project in Client Server, Data warehouse, Data modeling and Web application environments.
• Expert knowledge in SDLC Software Development Life Cycle .
• 5 Years of Experience in Designing the Data models and developing the Database Schemas using Erwin.
• Experience in Data warehousing DW , Master Data Management MDM , Dimension data modeling in different environments like Healthcare, Food services, Telecoms, Airlines and Banking.
• Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering, Publishing ERWIN diagrams, analyzing data sources, and proficient in Relational Database Management Systems RDBMS ..
• Experience in working with industry standard analysis techniques to uncover client requirements and identifying the roles and deliverable in the Organization by creating Use Case Models, Data Flow Models, Work flow Analysis, Functional decomposition Analysis, Object Modeling along with Activity Diagrams, Sequence Diagrams, Report Flow and State Diagrams using Rational Rose and Microsoft Visio.
• Experience with Business Process Modeling, Process Flow Modeling, Data Flow Modeling
• Proficient in designing Star Schema, Snow Flake Schema, OLAP and OLTP Data Modeling using Erwin modeling tool.
• Experience in both Inmon and Kimball methodology for a data warehouse environment.
• Strong RDBMS concepts and well experience in creating database Tables, Views, Sequences, triggers etc by taking the Performance and Reusability into consideration.
• Optimal in performing Database Tuning in reducing the Cost and Cardinality of the SQL Queries by using various Hints and Optimizers on looking at the Explain Plan and using TKprof and AWR.
• Experience in creating Normal, Unique and Bitmap Indexes to improve the performance of the SQL Queries, Functions, Procedures, Packages and Database.
• Experience in Relational, XML, DTD, XML Schemas in Oracle 11g/10g/9i/8i, SQL Server 2000-2005, SQL Server-2008, DB2, Sybase and Teradata databases.
• Experience in performance optimization at Database level for SQL and PL-SQL scripts.
• Excellent problem solving and communication skills.

Technical Skills:

Professional Experience:

Confidential

Sr. Data Modeler/Analyst

Responsibilities:

• Involved in JAD sessions with the Business Analyst, Subject matter expert, Product Owners and Application Team in gathering Business Requirements.
• Designed the LDM and PDM models using Erwin 8.5 data modeling tools for Order Provisioning System, Data warehouse project Star Schema .
• Designed the ILDM Implementation Logical Data Model and ELDM Enterprise Logical Data Model packet for the projects and Enterprise respectively.
• Involved in reviewing the model with the project team and product owner, LDDM Lead Division Data Modeler and getting approval from LDDM.
• Involved in reviewing the model with Peer review team.
• Carried out Reverse Engineering of the source database, attached naming standards, data domains and Complete comparing the two models to identify the differences.
• Involved in implementing the DDL scripts in the Development, Testing Environment and moving code to production environments.
• Involved in writing transformation logic in the ILDM packet and reviewing with ETL team.

Environment: Erwin8.x, MS Word, MS PowerPoint, MS Access, TOAD, MS Excel, Visio, Oracle, Oracle SQL developer, SQLSERVER 2012

Confidential

Enterprise Data Modeler

Responsibilities:

• Involved in JAD sessions with the Business Analyst, SME, Product Owner and Application Team in gathering Business Requirements.
• Designed Logical and Physical Model for REA Regional Elite , Technician Self Assessment, Threshold Manager, Campaign Model, VSOW Vendor Scope of work Application, FABTR Fare Base Award Ticket Redemption Project using power designer and visio.
• Normalized the Data and also developed the Relational database for the different Subject areas Order, Finance, Information Technology, Inventory, Pricing, Sales .
• Generated database scripts using Forward Engineer in using Data Modeling Tool.
• Created Domains and Metadata reports using Erwin 7.5 data modeler.
• Experience in check-in and check-out of models using Documentum and Model Manager and updating the MDCD file for auditing purposes.
• Provided support to application team in all environments Development, Testing, and Production .

Environment: Erwin7.3, Microsoft Office, Oracle 10g/11g.

Confidential

Data Analyst

Responsibilities:

• Involved in JAD sessions with the Business Analyst, SME, Product Owner and other management team in the finalization of the Business Requirements
• Involved in designing the LDM and PDM models in Data Modeling Tools like Erwin.
• Involved in creating high performance Data marts Star Schema in Data warehouse which consists of high volumes of CRM, Loans, Customers and financial account data, Sales Data, ERM, and Customer Credit Card Data..
• Assisted in the design of the services that will send data across the Enterprise Data in support of Application.
• Translated Business Requirements into Technical Requirements i.e Logical and Physical Model for the MTN, AIRTEL and VISAFONE project.
• Created and maintained Logical Data Model LDM and Physical Data Model PDM for the projects which include documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms

Environment: Oracle 10g, Erwin r7.x, Visio, Informatica Power center 8.x, Unix

Confidential

IT Analyst

Responsibilities:

• Involved in JAD sessions with the Business Analyst and other management team in the finalization of the Business Requirements
• Experience in the Creating tables, triggers, sequence and synonyms by forward Engineering in Erwin tool.
• Involved in design changes in Event Management Projects and generating the tables with Alter scripts and moving to all Environments.
• Experience in creating the Data Flow diagram and AADD documents for Event Management.

Environment: Oracle 9i/10g, Visio, MS office, Putty, FTP, Linux