SUMMARY

• Senior Data Modeler/Analyst with 71/2 years of experience in requirement gathering and data modeling including design and support of various applications in OLTP, Data Warehousing, OLAP and ETL Environment.
• Excellence in delivering Quality Conceptual, Logical and Physical Data Models for Multiple projects involving various Enterprise New and Existing Applications and Data Warehouse.
• Experienced in identifying entities, attributes, metrics, and relationships; also assigning keys and optimizing the model.
• Proficient in data mart design, creation of cubes, identifying facts & dimensions, star & snowflake schemes
• Expert in developing transactional enterprise data models that strictly meet normalization rules, as well as Enterprise Data Warehouses using Kimball and Inmon Data Warehouse methodologies.
• Extensive experience in using ER modeling tools such as ERwin and ER/Studio.
• Excellent SQL programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL/PL SQL. Performance tuning and query optimization techniques in transactional and data warehouse environments.
• Extensive experience with Normalization (1NF, 2NF, 3NF and BCNF) and De - normalization techniques for improved database performance in OLTP and Data Warehouse/Data Mart environments.
• Involved in the maintenance of therepositories for the metadata
• Experience in logical/physical database design and review sessions to determine and describe data flow and data mapping from source to target databases coordinating with End Users, Business Analysts, DBAs and Application Architects.
• Experience in generating DDL scripts and creating indexing strategies.
• Oracle administration on 10g, 9i versions. Backup and Recovery strategies using RMAN, Cold\Hot backups, Replication and other data migration strategies.
• Proficient in Data Cleansing and Data Profiling based on standards.
• Excellent analytical and communication skills with clear understanding of business process flow, SDLC life cycle and facilitated JAD sessions.
• Good interpersonal and human relation skills to interact with clients and co-workers
• Involved in the preparation of Detailed Design Documentation.

TECHNICAL SKILLS

• ERwin 4.1/7.2/7.0, 8.0, r9
• Oracle Designer
• BPwin
• Rational Rose
• ER/Studio
• MS Visio. Informatica Power Center 8.6.1/8.1/7.1
• Data Stage 7.5. MS SQL Analysis Manager
• DB2 OLAP
• Cognos Powerplay. SQL
• PL/SQL
• XML
• HTML
• C
• C++
• MS SQL Server 2008/2005/2000
• Oracle11g/10g/9i/8i
• DB2 V9.5
• Teradata V2R6.1
• MS Access 2000clients

PROFESSIONAL EXPERIENCE

Senior Data Modeler/Analyst

Confidential, Plano, TX

Responsibilities:

• Gathered 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
• Did extensive analysis on data, profiled it before moving forward with building marts
• Worked on the Payment business mart which basically generated report of payments done by customers in various facilities
• Involved increating entity relationshipdiagrams and then converting theminto logical and physical model
• Involved inNormalization of data to remove the redundant data
• Involved in gathering data from OLTP systems and creating ER diagrams
• Worked on generating a report on ‘Customer Analytics’ project, which calculates the average expenses of a customer in the past and predicts the future demand.
• Interacted with the front end customers and resolved BI tickets as accordingly
• Created a list of domains in Erwin and worked on building up the data dictionary for the company
• Created a Data Mapping document after each assignment and wrote the transformation rules for each field as applicable
• Create and maintained Metadata, including table, column definitions
• Worked with Oracle Data Integrator tool to help load and develop the tables I designed
• Generated a separate MRM document with each assignment and shared it on SharePoint along with the PDF of updated data models
• 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 Model Mart of Erwin r9 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• UsedErwinfor reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Assisted the ETL Developers and Testers during the development and testing phases

Environment: Oracle 11g, Microsoft 2008, SQL Developer, SQL Manager, ER Studio, SQL Developer Data Modeler, Visio, Oracle Data Integrator(ODI), SAP Business Objects, Informatica, Crystal Reports.

Senior Data Modeler

Confidential, Salt Lake City, UT

Responsibilities:

• Closely worked with business analysts in the process of requirements gathering for various application specific databases
• Worked on two sources to bring in required data needed for reporting for a project by writing SQL extracts
• Worked on building up the data model for Mobile Banking in the data warehouse
• Worked on building up a SQL query for extraction of data from the warehouse for a reporting schedule(Call Report) for Federal Government
• Worked on designing a Relational Model and Dimensional Model for Interactive Services such as Internet Banking, PC banking and Bill Pay for the bank
• Worked on building a conceptual and logical model starting from basic fields analysis spreadsheet of Credit Mart as a part of one of my projects.
• Worked on Metadata Repository(MRM) for maintaining the definitions and mapping rules up to mark
• Worked on unstructured modeling for NBO(Next Best Offer) which involved modeling of various marketing strategies involving emails, pictures and marketing material
• Was involved in fulfilling all the end users request which fell under the general maintenance work such as adding and removing columns and tables from data base not without the prior approval from BA’s and Data Modeling Team
• Used Graphical Entity-Relationship Diagramming to create new database design via easy to use, graphical interface.
• Conducted GAP analysis and data mapping to derive requirements for existing systems enhancements for a project.
• Designing and customizing data models for Data warehouse supporting data from multiple sources on real time
• Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets.
• Developed the logical data models and physical data models that confine existing condition/potential status data fundamentals and data flows using ER-Studio
• Ensured that the logical model is compliant with the conceptual model and all the high-level business rules and integrated and document.
• Defined the Primary Keys (PKs) and Foreign Keys (FKs) for the Entities, created dimensions model star and snowflake schemas using Kimball methodology
• Facilitated JAR/JAD sessions to determine data definitions and business rules governing the data, and facilitated review sessions with subject matter experts (SMEs) on the logical and physical data models.
• Applied data naming standards, created the data dictionary and documented data model translation decisions and also maintained DW metadata.
• Used data profiling tools and techniques to ensure data quality for data requirements.
• Extensively used SQL for performance tuning.
• Developed and executed queries in SQL for reporting using SQL Manager

Environment: ER Studio 9.1.0,, DataStage, Microsoft SQL Server 2008,IBM Data Studio, EMC Greenplum, Oracle RAC 11g, IBM DB2, Business Objects XI 3.1,pgAdmin III, DB Visualizer 8.0.10

Data Modeler/Analyst

Confidential, New York, NY

Responsibilities:

• Part of the team responsible for the analysis, design and implementation of the business solution.
• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Involved in gathering user requirements along with Business Analyst.
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation
• Conducted logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Used ModelMart 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) using Informatica to load it into a single data warehouse repository of Teradata
• Created data mapping documents from source to target systems.
• Used Star Schema and Snow flake schema methodologies in building and designing the logical data model in the dimensional Models.
• Developed Conceptual, Logical and Physical data models for Central Model consolidation.
• Redefined many attributes and relationships in the model and cleansed unwanted tables/columns as part of Data Analysis responsibilities.
• Identified and processed the facts and dimension tables.
• Worked with report developers for building OLAP CUBEs for ad hoc reporting.
• Integrated the work tasks with relevant teams for smooth transition from testing to implementation phase
• Assisted end users, operations and testing teams by providing them with the necessary documents

Environment: Erwin r7.1, Informatica 7.1.3, Teradata v2R5/v2R6, Windows XP/NT/2000, SQL Server 2000/2005, SQL, Oracle RAC 10g, MS Excel, MS Visio, Rational Rose, Requisite Pro

Data Modeler

Confidential, Pittsburgh PA

Responsibilities:

• Involvedwith the Business Analysts’ team in requirements gathering and based on provided business requirements, defined detailed Technical specification documents.
• Analyzed the Business information requirements and examined the OLAP source systems to identify the measures, dimensions and facts required for the reports.
• Performed the data source mapping.
• Utilized Power Designer’s forward/reverse engineering tools and target database schema conversion process.
• Documented logical, physical, relational and dimensional data models. Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Redefined attributes and relationships in the model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Review the data model with functional and technical team.
• Worked on the reporting requirements and involved in generating the reports for the Data Model.
• Assistdevelopers,ETL, BI team and end users to understand the data model.

Environment: ERWIN 4.1.4, DB2 Version 9.0, Teradata 6.2, Oracle 10g, Microsoft Visio, Rochade Metadata Repository

Data Modeler

Confidential

Responsibilities:

• Extracted data from Oracle and SQL Server and DB2 using Informatica to load it into a single data warehouse repository.
• Created entity relationship diagrams and multidimensional data models, reports and diagrams for marketing.
• Used Model Mart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Developed and implemented measurements for various marketing campaigns.
• Created a net loss model, which analyzes the impact of loan defaults and recoveries.
• Created a relational model and dimensional model for online services such as online banking and automated bill pay.
• Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets.
• Developed logical data models and physical data models using ER-Studio

Environment: Erwin r7.1, MS Excel, MS Visio, Windows XP, DB2, Oracle.

Data Modeler

Confidential

Responsibilities:

• Worked with business analyst to gather information on requirements
• Documented Technical & Business User Requirements during requirements gathering sessions.
• Analyzed conceptual into logical data and had JAD sessions and also communicated data related issues and standards.
• Involved in modeling business processes through UML diagrams.
• Maintained and build data models based on ACORD standards
• Created entity process association matrices, functional decomposition diagrams and data flow diagrams from business requirements documents.
• Conducted model walkthroughs and validation sessions.
• Used IBM framework (IAA) for developing the conceptual design for my models
• Used Sybase Power Designer tool for relational database and dimensional data warehouse designs.
• Worked alongside the database team to generate the best Physical Model from the Logical Model using ERwin
• Developed Cleansing and data migration rules for the Integration Architecture (OLTP, ODS, DW).
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Used Crystal Reports to generate Ad-Hoc Reports

Environment: Erwin, Data Maker, Model Manager, SQL-Server, DB2, Oracle, SSIS, Cognos, Windows XP