PROFESSIONAL SUMMARY:

• Seven years of extensive experience in the complete Software Development Life Cycle (SDLC) covering Requirements Management, Data Analysis, Data Modeling, System Analysis, Architecture and Design, Development, Testing and Deployment of business applications.
• Strong Data Modeling experience using ER diagram, Dimensional/Hierarchical data modeling, Star Schema modeling, Snow-flake modeling using tools like Erwin, ERStudio.
• Created DDL scripts for implementing Data Modeling changes. Created ERWINreports 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.
• Strong Knowledge in Conceptual and Logical Data Modeling skills has experience with JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications, queries.
• Created, maintained and modified database design document with detailed level description of logical entities and physical tables as per the business requirements.
• Effective use of features like model mart, design layers, complete compare, split model, model sources and transforms(sub type, super types and hierarchical layers).
• Performed system design with Entities, attributes, logical relationships (identifying, non-identifying) Preliminary database design, obligatory and non-obligatory analysis, and validation of a model using Normalization techniques.
• Excellent knowledge of waterfall, spiral and Agile methodologies of Software Development Life Cycle (SDLC).
• Experienced in Financial / Finance, Mortgage, Supply-Chain, Material Management and Health Care.
• Expertise in Software Development Life Cycle Process (SDLC), Use Cases and Rational Unified Process (RUP).
• Extensive Experience working with business users/SMEs as well as senior management.
• Strong understanding of the principles of EnterpriseData warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Experience in creating schema and table design, stored procedures, Triggers, Views, and Indexes.
• Possess a strong analytical, verbal, inter-personal skill that helps in communicating with developers, team members.
• Optim Proficient in using MS Office including MS Visio and MS Project
• Experience in working with ETL - Extract, Transform, Load transactions using DataStage.
• Experience in using HTML, ASP, Visual Basic and JavaScript for developing web based database applications with Oracle 9i, MYSQL and MS Access databases.
• Assisted developers, ETL, BI team and end users to understand and maintain change log for each data model. Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Designed the Partitioning for tables according to business logic. Creation of Local/Global indexes depending on the types of queries to be performed on the tables.
• Energetic and self-motivated team player with excellent communication, interpersonal, and leadership skills, both independent and collaborative work environments.
• experience with Canonical Data Model Management

TECHNICAL SKILLS:

Data Modeling Tools:

ER/Studio 8.5, Erwin 3.5/ 4.1.4/ 7.5.3, Power Designer 12.1, Rational Rose, and Visio

Database Systems:

Teradata, Oracle (11g/10g/9i/8i/7.x), SQL Server (2005/2000/7.0), Microsoft Access 2007, DB2, MySQL

Data Warehousing:

Informatica Power Center 8.1/8.0/7.1/7.0/6.2/6.1/5.2, InformaticaPowerMart 4.7, PowerConnect, Power Exchange, Data Profiling, Data cleansing, OLAP, OLTP, SQL*Plus.

Software Engineering:

UML using Visio

Office Applications:

MS Office 2007 (Word, Excel, PowerPoint)

Configuration Management:

Clear case, Visual Source Safe and Concurrent Version Control, Remedy

Operating Systems:

Windows95/98/2000/XP, Solaris, Linux, AIX

Quality Assurance:

Business and Software Process and Procedure Definition, Quality Models and standards (ISO 9001:2000 ,CMM,CMMI,TQM Principles, Six Sigma concepts), Quality tools (Ishikawa diagram, Pareto analysis, histogram Process), Measures and Metrics, Project Reviews, Audits and Assessments

Testing:

QTP, Quality Center

Confidential, KY Dec 2011 - Till Date
Data Modeler

Confidential, develops and manufactures printing and imaging products, and provides businesses of all sizes with a broad range of printing and imaging software, solutions and services including laser printers, multifunction products, printing supplies, and business services for businesses and enterprises. The work will be support oriented and it will not require separate controls. The goal of the project is consolidated and complete Mortgage data in one repository including account.

Responsibilities:

• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Conducted analysis and profiling of potential data sources, upon high level determination of sources during initial scoping by the project team.
• Coordinated data profiling/data mapping with business subject matter experts, data stewards, data architects, ETL developers, and data modelers.
• Worked on Bank Data ware house and Mortgage Data ware house.
• Developed logical/ physical data models using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
• Normalized the database to put them into the 3NF of the data warehouse.
• Involved in dimensional modeling, identifying the Facts and Dimensions.
• Maintain and enhance data model with changes and furnish with definitions, notes, reference values and check lists.
• Worked very close with Data Architectures and DBA team to implement data model changes in database in all environments. Generate DDL scripts for database modification, Teradata Macros, Views and set tables.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop different solutions for challenging client needs.

Environment: Teradata, SQL Server 2000/ 2005, Erwin 7.5.2, Windows XP, XML, Excel, Access, Visio.

Confidential, IL July 10 - Nov 11
Data Modeler

Confidential, is the world\'s leading manufacturer of construction and mining equipment, diesel and natural gas engines, industrial gas turbines and diesel-electric locomotives. The company also is a leading services provider through Caterpillar Financial Services, Caterpillar Remanufacturing Services and Progress Rail Services. One of the sub-projects, which were an offshoot of the bigger Sphere of Influence (SOI), is the creation of the Meta Data Repository (MDR). MDR is a data repository, which is expected to house all the relevant information about the various pieces of data (metadata) structures into one single platform.

Responsibilities:

• Updated and captured latest Metadata and reconciled existing Data Dictionaries for Organization, Integrity Checks and Relationship Accuracy.
• Managed Data Content by researching existing Data Flow Diagrams, Data Stores, Data Models, Data Qualification and Standardization rules, and Systems Documentation.
• Developed WKPS Master Lists and Data Dictionaries of Pharmacy (Rx), 837 Institutional (Hx) & 837 Professional (Mx) Business Elements with tightly coupled derivative fields and grouped them logically within the Standard Data Context within the organization.
• Reverse-Engineered and Linked the Business Element Names from the various Master lists back to the (expected) Physical Instance Names in multiple Data Stores.
• Captured and highlighted key elements for Core Business Functions such as Practitioner Matching, De-Duplication, and Qualification; referenced Data Quality Constraints and rules for key elements wherever appropriate.
• Interviewed Technical Staff with regard to the Data Content, Data Standards, Data Services and Data Rules.
• Researched existing data models, data structures, table content (using Toad) excel mapping files, and various data sources for dimensional and transaction data to build the metadata mapping in E/R Studio.
• Utilized E/R Studio to create comprehensive mapping documents and data lineage.
• Exported new or existing Data Mappings and Database Schema changes from Logical Data Models (LDMs) in E/R Studio into Physical Data Models (PDMs) and worked closely with DBAs to translate and implement these models.
• Conducted Structured Review sessions to reconcile model updates and related work with Senior Data Architects and Data Governance/Data Architecture Manager.
• Organized and Published Detailed Data Content SharePoint Knowledge Base Peer-Review, Consensus and Sign-off.
• Published the mapping from E/R Studio in a form for non-technical viewing such as in JPEG, PDF formats.

Environment: Main Frames, COBOL, DB2, ORACLE Exadata, ER Studio 8.5, Windows XP, XML, Excel, Access, Vision

Confidential, New Jersey Dec 08 - Jun 10
Data Modeler

Confidential, is a global financial services company which provides Investment Banking, Asset Management, and Wealth Management services for private, corporate, and institutional clients worldwide. Wealth Management services are designed for high-net-worth and affluent individuals around the world, whether investing internationally or in their home country. UBS Provides tailored, unbiased advice and investment services ranging from asset management to estate planning and from corporate finance to home financing. The goal of the project is Architect and populates the Enterprise Data Model (EDM) for UBS WMA which gives a consistent, structured view of the data for front-end Applications. Build a foundation for Business Intelligence, leveraging the Target State Architecture.

Responsibilities:

• Involved in Source code scanning and analysis.
• Derived logical data model from source systems.
• Obtained DDL of Production Data Stores.
• Mapped physical to logical definitions.
• Created logical data model with physical mapping for Financial Instrument subject area.
• Abstract EDM from physical data model.
• Standardize naming conventions to better reflect business needs, e.g. Address, etc…
• Assign primary keys to all tables; evaluate use of multiple dates in the primary keys.
• Evaluate use of 'Blank' and 'Null' as valid attribute values in entity definitions
• Eliminated repetitive attributes (e.g. numbered codes in tables should go to a separate table), levels and type codes, (e.g. simplify product table to make it more manageable through normalization; eliminate redundancies across databases, price and classification)
• Reduced total number of tables (e.g. avoid single attribute tables, many Issue tables)
• Developed logical models for Transaction - Events affecting client holdings or accounts, Client Account - Holding vehicle for assets, Products & Services - Firm service or offering, e.g. check writing, debit cards, etc. Party - Individual or organization of interest to UBS WMA,Position - The intersection of a client account with a financial instrument, Financial Instrument - Reference data & pricing for WMA instruments, Corporate Action - Any event that brings material change to a financial instrument, Operational Position Keeping - Real-time position and balances, General Ledger - Accounting books of business for UBS WMA
• Defined EDM for Subject Areas such as Financial Instrument, Party, Client/Account, And Operational Position Keeping.Defined mappings from EDM back to physical for the following subject areas:
• Financial Instrument to PDB, FPM, KAR
• Party to CRDB
• Client/Account to CRDB
• Operational Position Keeping to RPB
• Exported EDM to Virtualization-friendly format.
• Provided a consistent, structured view of the data for front-end applications.

Environment: Main Frames, COBOL, DB2, VSAM, ORACLE, Erwin 7.5.3, Windows XP, XML, Excel, Access, Vision.

Confidential, Pittsburg Oct 07 - Nov 08
Data Modeler

Confidential, is a global financial services company which provides Investment Banking, Asset Management, and Wealth Management services for private, corporate, and institutional clients worldwide. PNC Bank is one of the nation\'s largest full-service providers of consumer and commercial banking, trust, securities brokerage, mortgage and insurance products and services.
Project was to develop financial analysis data warehousing for analyzing customers, their transactions, accounts, balances and their authorizations between accounts of its customers. This project is a sub-project to Master PNC Investment and Retirement Initiative. The project will track all activities related to the Technology team support of the "Bold Moves" in the Investment and Retirement area specifically related to metrics and reporting. Build and deploy an Investment and Retirement data model and reporting capability set to enable the development of PNC I & R Business Dashboard and provide data access for "on demand" reporting.

Responsibilities:

• Worked at conceptual and physical database level to implement and build corporate enterprise information strategies.
• Analyzed existing logical data model (LDM) and made appropriate changes to make it compatible with business logic.
• Created Physical Data Model (PDM) for the OLTP application using ER Studio.
• Designed a data model for storing various documents in Oracle Database
• Involved in data model reviews with internal data architect, business analysts, and business users with in depth explanation of the data model to make sure it is in line with business requirements.
• Extensively involved in various data modeling tasks including forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas, publishing model to PDF and HTML format, generating various data modeling reports etc
• Performed Analysis and designing of Star Schema Data Mart with Facts and Dimension.
• Analyzed different options for heterogeneous database connectivity and defined policies for dealing with different source databases with ETL team.
• Worked with cross-functional teams and prepared detailed design documents for production phase of current customer database application.
• Performed Data Analysis and Data validation by using TOAD against the Oracle database. Documented the application, implementation and day-to-day maintenance, configuration procedures of the system.

Environment:ER Studio, Toad, ORACLE, ER Studio 8.5, Windows XP, XML, Excel, Access, Vision

Confidential, Hyderabad,India Oct 2006 - Aug 2007
Role: Data Analyst/Modeler

Responsibilities:

• Gathered Business requirements by organizing and managing meetings with business stake holders, development teams and analysts on a scheduled basis.
• Analyzed different Data Sources like DB2, SQL Server, Oracle and Flat files from which movies, sales data, contract and billing data is coming and understand the relationships by analyzing the OLTP Source.
• Designed an Oracle OLTP database in 3NF to handle the day-to-day needs of the business, and database performance is tuned for those needs.
• Involved in the entire SDLC (System Development Life Cycle) process that includes implementation, testing, deployment and maintenance.
• Designed Catalog Data Management system using Retail technology standards.
• Exclusively used Erwin for Logical, Physical modeling and reverse- engineering.
• Identified Multiple Dimensions and Fact tables. Used advance data modeling concepts of Degenerated dimension, sub-dimension, Fact less fact table, Aggregate fact tables in Multidimensional model.
• Used advanced dimensional modeling concepts like Multi Valued Dimensions to resolve many to many relationships using Bridge or associative identity between tables for the star schema model.
• Performed Data Profiling to assess the risk involved in integrating data for new applications, including the challenges of joins and to track data quality.
• Applied Master Data Management to create and maintain consistent, complete, contextual, and accurate business data for all stakeholders.
• Designed Star Schema data warehouse for fast retrieval of data and to generate reports.
• Conducted Data Model design review meetings to get approval from cross-functional teams.
• Involved in creating Enterprise data dictionary and data standards to ensure data quality and consistency.
• Implemented Data Archiving strategies to handle the problems with large volumes of data by moving inactive data to another storage location that can be accessed easily.
• Created Source to Target mapping document in excel spread sheet which contains the transformation logic and worked closely with ETL Team and developed various complex transformations.
• Involved with Business Intelligence team in preparing and delivered a variety of interactive and printed reports by using Business Objects.

Environment: Oracle 9i, Erwin 6.5, Mainframes, SQL server 2000/2005, DB2, Informatica 6.0, BusinessObjects

Confidential, Hyderabad, India Jan 06 - Aug 06
Oracle Developer

Responsibilities:

• Modification of PL/SQL code and created databases in Oracle 9i, SQL.
• Involved in designing physical and logical data model using ERwin Data modeling tool.
• Designed the relational data model for operational data store and staging areas, Designed Dimension & Fact tables fordata marts.
• Extensively used ERWIN data modeler to design Logical/Physical Data Models, relational database design.
• Created Stored Procedures, Database Triggers, Functions and Packages to manipulate the database and to apply the business logic according to the user's specifications.
• Created Triggers, Views, Synonyms and Roles to maintain integrity plan and database security.
• Designed screens using Oracle forms, Packages for the application using PL/SQL.
• Creation of database links to connect to the other server and Access the required info.
• Used Reports 6i to build reports. Used various functionalities provided by the reporting tool like the parameter fields, Formulas, running totals, Sub reports etc. .
• Integrity constraints, database triggers and indexes were planned and created to maintain data integrity and to facilitate better performance.
• Libraries and standard objects were created using Forms 6i, Front end Forms using Forms 6i.
• Used Advanced Querying for exchanging messages and communicating between different modules.
• Reports were created using Reports 6i, some client server reports were modified and web enabled.
• Worked on day-to-day technical issues on Forms, Reports and PL/SQL.
• Created SQL Queries using Toad tool and scheduled some of the Common Reports.
• System analysis and design for enhancements Testing Forms, Reports and User Interaction.
• Designed the survey with the help of Subject Matter Experts
• Analyzed the standard ways and best practices of content presentation for the website which contained the information about agencies.

Environment: Oracle 8i, Forms 6i and Reports 6i, SQL* Plus, PL/SQL, Developer 2000, PL/SQL, ERWIN, TOAD, Mainframes, Stored Procedures.