SUMMARY

• 7+ years in IT with expertise in data modeling for data warehouse/ data mart development, SQL, data analysis for online transaction processing (OLTP) and data warehousing (OLAP) and business intelligence (BI) applications.
• Experience in all phases of software development lifecycle (SDLC) including system analysis, design, data modeling, implementation and support of various applications in OLTP, data warehousing and OLAP applications.
• Data modeler with strong conceptual and logical data modeling skills and has experience with requirements gathering, creating data mapping documents, queries.
• Different domain experience like banking, healthcare, insurance, etc. as a data modeler.
• Strong working experience in oracle 9i, 10g and 11g database programming using PL/SQL and standard built in oracle packages in UNIX and windows environment.
• Worked extensively on reverse and forward engineering processes. Created DDL scripts for implementing data modeling changes.
• Created data models in data marts, created naming conventions files, co - coordinated with DBA’s to apply the data model changes.
• Extensive experience in relational and dimensional data modeling for creating logical and physical design of the database and ER diagrams using data modeling tools like ERWIN and ER studio.
• Implemented slowly changing dimensions (SCD) type I and type II in dimensional modeling as per the requirements.
• Extensive experience in understanding functional specifications, translating business requirements to technical specifications, maintained and modified database design document with detailed description of logical entities and physical tables.
• Possess strong documentation skills and knowledge sharing among team, conducted data modeling review sessions and participated in requirement sessions to identify requirement feasibility.
• Good knowledge in designing data marts using Ralph Kimball’s and Bill Inmon’s dimensional data mart modeling techniques.
• Interacted with the teams involved in reporting and ETL and also interacted with oracle developers regarding querying and database designing and involved in master data management (MDM) and data profiling.
• Extensive experience working with business users and senior management.
• Strong understanding of principles of data warehousing, fact tables, dimension tables, star and snowflake schema modeling.
• Understanding of IBM BDW.
• Experienced in writing SQL and PL/SQL queries using stored procedures, functions, triggers, views, indexes and partitioning, and joins.
• Have a working knowledge in performance tuning using execution plan in oracle databases.
• Worked on oracle parallel queries, bulk collect, FOR ALL, regular expressions, MERGE, etc.
• Proficient in oracle tools and utilities such as TOAD, SQL*PLUS and SQL Developer.
• Excellent analytical, inter-personal and communication skills with a strong technical background.

TECHNICAL SKILLS

Data modeling tools: ERWIN 7.x, ER Studio

Reporting tools: Oracle Reports, Business Objects, and Crystal Reports

ETL tools: Informatica Powercenter 8x, 9x

OLAP Tools: Business Objects, Crystal Reports 9

Programming languages: SQL, PL/SQL, HTML, perl

Databases: Oracle 10g/11g, Teradata, DB2, MS access, SQL server

Operating systems: Linux, UNIX, Windows

Others: MS Office, Toad, and SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Warren, NJ

Sr. Data Modeler

RESPONSIBILITIES:

• One on one session with business users to gather data warehouse requirements.
• Developed conceptual model based on the requirements analysis.
• Involved in creating the solution definition document (SDD), which provide the basic source of information for project requirement document.
• Developed normalized logical and physical database models to design OLTP system for applications.
• Part of team conducting logical data analysis and data modeling JAD sessions with management, SME (Subject matter experts), vendors, users and other stakeholders.
• Created dimensional model for the reporting system by identifying required dimensions and facts.
• Data modeling was performed using ERWIN tool to built logical and physical models.
• Recommended opportunities for reuse of data models in new environments.
• Map business needs/requirements to subject area model and to logical enterprise model.
• Used forward engineering to create a physical data model with DDL that best suits the requirements from the logical data model using Erwin.
• Worked on Ralph Kimball methodologies.
• Participated in DRB reviews.
• Worked on data governance for improvement of the data quality.
• Data profiling for examining the data available in an existing data source and collected statistics and information about that data.
• Assessed the risk involved in integrating the data for new applications.
• Worked with architecture team to get metadata approved for the new data elements that are added for this project.
• Conducted the design reviews and validated the developed models by interacting with database administrators, business analysts and was involved in master data management (MDM).
• Created mappings for type 2 slowly changing dimensions (SCD) for updating and inserting of records and inturn maintaining the history.
• Understanding on IBM BDW.
• Ensured production data being replicated into the ODS and the data warehouse without any data anomalies from the processing databases.
• Used teradata fast load and fast export to load large volumes for the initial and reporting purposes respectively.
• Generated the ad-hoc SQL queries using joins, database connections and transformation rules to get the data from oracle databases.
• Improved data integrity by adding foreign keys and normalizing the underline data structure.
• Performed Oracle 11g optimization, performance tuning,
• Worked on PL/SQL collections, bulk collect, FOR ALL, etc.
• Utilized SQL to developer new and debug existing ad-hoc reports.
• Utilized PL/SQL to write stored procedures, functions, triggers, views, etc.
• Coordinated with DBA’s and generated SQL code from the data models.
• Model mart of ERWIN was used for effective model management of sharing, dividing and reusing model information and design for productivity improvement
• Facilitated in developing testing procedures, test cases and user acceptance testing (UAT)

Environment: ERWIN 7.3, oracle 11g, SQL, MS Excel, Microsoft windows, TOAD from Quest software

Confidential, Atlanta, GA

Sr. Data modeler

RESPONSIBILITIES:

• Identified entities and attributes and built conceptual, logical and physical models using Erwin.
• Data modeler performing business area analysis and logical and physical data modeling using Erwin for data warehouse/data mart applications as well as operational applications enhancements and new development.
• Data warehouse/data marts design was implemented using Ralph Kimball methodology.
• Worked on multiple projects and gathered various reporting requirements from the business analysts.
• Reverse engineered the reports and identified the data elements, dimensions, facts and measures required for new enhancements of the reports.
• Design discussions and meetings to come out with the appropriate data mart at the lowest level of grain for each of the dimensions involved.
• Interacted with the SOA teams.
• Worked on data profiling, data quality, assessing the risk involved in integrating data for new applications.
• Understanding data challenges early in any data intensive project.
• Assess whether metadata accurately describes the actual values in the source database.
• Overview of and enterprise data for uses such as master data management (MDM).
• Worked on data governance for improving data quality.
• Designed a star schema for the detailed data marts and plan data marts involving confirmed dimensions
• Created and maintained the data model repository as per company standards.
• Creating and ensuring the feasibility of the logical and physical design models using Erwin.
• Generated ready to implement DDL for oracle DBMS implementation by the DBA group.
• Created reports using SQL Server reporting services (SSRS), business objects, crystal reports.
• Worked on various databases like Oracle, DB2 and Teradata.
• Interacted with DBA for improving performance of queries.
• Involved in indexing, partitioning of the database.
• Worked extensively on oracle analytical functions like ROW NUMBER, LEAD, LAG, RANK, DENSE RANK
• Understanding of the Teradata SQL assistant.
• Generated ad-hoc queries using SQL joins, etc.
• Utilized PL/SQL to write stored procedures, functions, triggers, views.
• Worked on PL/SQL collections, index by table, varrays, bulk collect, FOR ALL, etc.
• Performed updates and enhancements to the already existing data models as required by using ERWIN/CA

ENVIRONMENT: ERWIN, Oracle 11g, Crystal Reports, Toad, Erwin, Windows OS, DB2, Teradata, SSRS, business objects

Confidential, Westfield Center, Ohio

Data modeler

RESPONSIBILITIES:

• Interacted with business analysts to get functional requirements.
• Interact with end users and find out the reporting needs.
• Built the conceptual model as per the requirements.
• Create standard abbreviation document for logical, physical and dimensional data models.
• Creating logical, physical and dimensional data models using Erwin and documenting it.
• Generating reports from the data models
• Review the data model with functional and technical team
• Assisting developers, ETL, BI team and end users to understand the data model.
• Worked on master data management, data governance and data integration for improving the data quality.
• Maintain change log for each data model.
• Normalized tables up to 3NF.
• Create SQL code from data model and co-ordinate with DBA’s.
• Check to see whether the data models and databases are in sync
• Generated PL/SQL code and created procedures, functions, views, etc.
• Adding data objects like indexes, partitions in oracle databases for performance and then generating the reports.

ENVIRONMENT: oracle 10g, Toad, ERWIN, Crystal reports 9, Windows XP, DB2, Teradata

Confidential, Foster City, CA

Data modeler

RESPONSIBILITIES:

• Understand and translate business needs into data models supporting long -term solutions.
• Worked with SME’s and other stakeholders to determine requirements to identify entities and attributes to build conceptual, logical and physical models using Erwin.
• Identified and compiled common business terms for the new policy generating system
• Created a high level industry standard, generalized data model to convert it into logical and physical model at later stages of the project using ERWIN
• Enforced referential integrity for consistent relationship between tables and efficient database design in OLTP data model
• Worked on data profiling and assessed whether metadata accurately describes the actual values in the source database.
• Worked on Master data management (MDM) and data governance for improving data quality.
• Worked on Bill inmon methodologies for modeling.
• Created tables, views, procedures and SQL scripts and mapping documents.
• Worked on slowly changing dimensions (SCD) and hierarchical dimensions
• Worked on conversion process of data, which is stored in flat files into oracle tables.
• Created documentation and test cases, worked with users for new module enhancements and testing
• Worked with DBA’s to create best-fit physical data model from the logical data model in Erwin.
• Worked on multiple databases like oracle 10g, Teradata and DB2.
• Generating ad-hoc reports using crystal reports 9.

ENVIRONMENT: oracle 10g, Toad, ERWIN, Crystal reports 9, Windows XP, Teradata, DB2

Confidential

Data modeler/SQL Developer

RESPONSIBILITIES:

• Create logical and physical models using best practices to ensure high quality and reduced redundancy
• Optimize and update logical and physical data models to support new and existing data models
• Recommend opportunities for reuse of data models in new environments
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Validate business data objects for accuracy and completeness
• Examine new application design and recommend corrections if required.
• Write SQL code and debug them, unit testing was performed.
• Extensively used star schema methodologies in building and designing the logical data models into dimensional model.
• Written stored procedures and triggers extensively and working very closely with developers, business analysts and end users to generate various audit reports and troubleshoot their query problems.
• Provided maintenance and support to customized reports developed in crystal reports.
• Gathered statistics on large reports and redesigned indexes.

ENVIRONMENT: Oracle 10g, DB2, Teradata, SQL Server, SQL, Pl/SQL, crystal reports, windows XP, SQL *PLUS

Confidential

Oracle Developer

RESPONSIBILITIES:

• Created PL/SQL code for functions, stored procedures
• Created SQL unit test scripts and test database for testing
• Gather business requirements from business analysts and understand the used cases.
• Generation of entity diagrams and relationship diagrams and modeling cascade delete/update/insert for maintaining referential integrity.
• Worked of application enhancement projects.
• Interacted with DBA regarding performance tuning, indexing and partitioning of the database.
• Wrote queries using Toad for oracle and analyzed ER diagrams using ER studio.

ENVIRONMENT: Oracle 9i, ERWIN 5.0, ER Studio, SQL PLUS, Toad, SQL, PL/SQL, Windows XP.