SUMMARY:

• 8+ 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.
• Data modeler with strong conceptual, logical and physical data modeling skills and has experience with requirements gathering, creating data mapping documents, queries.
• Well Versed in capturing the service related to consolidated enterprise level DFD and usage statistics between the database and all other applications
• Different domain experience like banking, healthcare, insurance, etc. as a data modeler.
• Worked on various databases including oracle, DB2, SQL Server, etc.
• Worked extensively on reverse and forward engineering processes. Created data models in data marts, 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.
• Strong understanding of principles of data warehousing, fact tables, dimension tables, star and snowflake schema modeling.
• Experienced in writing SQL queries.
• Strong Knowledge of Data Warehousing, ETL and Business Intelligence Reporting Architecture.
• Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS architecture by using tools like Erwin 7.0/4/0, Power Designer, Embarcadero ER Studio and Microsoft Visio.
• Proficient in Normalization (1NF, 2NF, 3NF and BCNF)/ De-normalization techniques for effective and optimum performance in OLTP and OLAP environments.
• Experience in Normalization and De-Normalization techniques for optimum performance in relational and dimensional database environments.
• Strong experience working with conceptual, logical and physical data modeling considering Meta data standards.
• Experience working with Requirement Gathering, Conceptual Data Modeling, Logical Data Modeling.
• Experience working with Agile and Waterfall data modeling methodologies.
• Experience in Ralph Kimball and Inmon approaches.
• Experience in OA Framework personalization for Self Service Web pages.
• Extensive experience analyzing and documenting business requirements and system functional specifications including use cases facilitated and participated in Joint Application Development (JAD) sessions, white board sessions to resolve the revolving issues and facilitated the coordination between the teams.
• Experience working with Physical Data Modeling.
• Involved in the critical design review of the finalized database model.
• Worked extensively with XML schema designing and XML data.
• Expertise in UML (class diagrams, object diagrams, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using Rational Rose and MS-Visio.
• Worked with various RDBMS like Oracle 9i/10g/11g/12c, SQL Server 2005/2008, DB2 UDB, Teradata.
• Extensive experience in development of Oracle PL/SQL Scripts, Stored Procedures and Triggers for business logic implementation.
• Experienced in Data loading using PL\SQL Scripts and SQL Server Integration Services packages (SSIS 2005/2008).
• Experience with DBA tasks involving database creation, performance tuning, creation of indexes, creating and modifying table spaces for optimization purposes.
• Performed extensive Data profiling and analysis for detecting and correcting inaccurate data from the databases and to track data quality.
• Very Good exposure to ETL tools like Informatica, Micro Strategy and IBM Data Stage and SSIS 2008/ 2005.
• Excellent communication skills, self-starter with ability to work with minimal guidance.

TECHNICAL SKILLS:

Data modeling tools: ERWIN 7.3x 8.x, 9.5.2, ER Studio

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

ETL tools: Informatica Power center 8x, 9x, SSRS, Microstrategy

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

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

Operating systems: Linux, UNIX, Windows

Others: MS Office, MS Visio, MS Excel, Toad, and SQL Developer

WORK EXPERIENCE:

Confidential, NYC, NY

Data Modeler/ Sr. Application Developer

RESPONSIBILITIES:

• Developed a service to capture the consolidated enterprise level DFD and usage statistics between the database and all other applications
• Developed the backend framework for Central Security Server which acts as an authentication bridge between central DB and the applications that enable users to directly manage their healthcare data using Procedures, Packages, Functions and Cursors.
• Designed the Logical Data Modelling and Physical Data Modelling for the Central DB
• Developed the Person View which is an aggregation of the person concept based on demographics using Procedures, Packages etc.
• Worked on Erwin r7.3 Marts and Web Portal and was in the Enterprise architecture team and maintained the models on web portal for the North America division.
• Used version control feature in Erwin Web Portal to control the model versions and incorporated the ALTER scripts into the current model.
• Was involved in reverse/forward engineering 20+ databases mostly Oracle SQL Developer, TOAD, Microsoft SQL Server, MS access etc.
• Improved performance of SQL Queries to retrieve client’s data by using the Explain Plan. The retrieval times went from 0.15 seconds to 0.04 seconds
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Coordinated with DBA’s and generated SQL code (DDL) 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
• Lead the interactions as a data modeler with the reporting team, BI specialist’s, etc. to analyze requirements and the data from the transactional systems to get migrated into the data warehouse by the ETL teams using Datastage and model the structure according to the business requirements to be reported.
• Worked with SME’s and other stakeholders to determine requirements to identify entities and attributes to build conceptual, logical and physical models using Erwin.
• Enforced referential integrity for consistent relationship between tables and efficient database design in OLTP data model.
• Worked on conversion process of data, which is stored in flat files into oracle tables.

ENVIRONMENT: Erwin r7.3, Enterprise Architect Tool (Sparx), Oracle SQL Developer, TOAD, Oracle 11g, Informatica, MS Visio, MS Excel, MS Windows, SQL Server 2008/12, OLTP Data Model, Java, .NET etc.

Confidential, Minneapolis, MN

Data Modeler

RESPONSIBILITIES:

• Working on the enterprise level modules for the insurance client to perform the data modeling and data architectural related tasks and providing solutions for the data migration on various platforms from hierarchical to relational databases to unstructured databases.
• Working on the OLAP for datawarehouse and datamart developments using Ralph Kimball methodology as well as OLTP models, both and interacting with all the involved stakeholders and SME’s to derive the solution.
• Working on facts and dimensions for the dimensional modeling data architecture as well as relational data modeling for the transactional systems like in-house applications and policy, claims applications, etc.
• Working on policy and claims applications to model the tables according to the 3NF modeling and working on resolving many to many relationships, bridge tables, reference tables, master data, etc.
• Lead the modeling efforts on multiple enterprise level projects.
• Created logical and physical models and ER diagrams using PowerDesigner modeling tool for the relational and dimensional data modeling.
• Working on forward and reverse engineering the DDL for the SQL Server 2012, DB2 and Teradata environments.
• Collected technical and business metadata and maintained naming standards by working along with the architects, data governance, business analysts and developers, SME’s, etc.
• Interacted with the solutions architects for the framework analysis for multiple modules like claims, policy, etc. for timely delivery of the data into the new system for transactional analysis for .NET framework team and then to redirect the output to the reporting platform on to the Teradata.
• Working with the third party vendors like Guidewire developers to lead the data migration projects in order to make the new systems more efficient and the design the model to get the data from Guidewire to the data warehouse for reporting using Microstrategy.
• Lead the interactions as a data modeler with the reporting team, BI specialist’s, etc. to analyze requirements and the data from the transactional systems to get migrated into the data warehouse by the ETL teams using Datastage and model the structure according to the business requirements to be reported from Microstrategy.
• Providing solutions for the business issues and overcoming the technical difficulties by providing the optimum model to solve those issues to satisfy all the stakeholders involved.
• Working on multiple area’s like Auto, policy, claims, life insurance, etc.
• Interacting with the business analysts, architects, ETL teams using Datastage to build a sophisticated modeling solution for the customers.
• Lead discussions on designing the models on enterprise level.
• Worked on SQL Server, DB2 and Teradata platforms.

ENVIRONMENT: PowerDesigner 15, SQL Server 2008,2012, Teradata 12, MS Excel, MS Windows, Datastage, Microstrategy, etc

Confidential, St. Louis, MO

Sr. Data Modeler

RESPONSIBILITIES:

• Lead the project for gathering requirements for the data element mappings and analyzing earlier models for all the LOB’s.
• Communicating with business stakeholders to understand the reporting requirements and identifying the source to certify the elements.
• Lead in the data certification process as a POC data modeler for certifying the elements in all LOB’s throughout Chase on the migration project.
• A centralized role involving working on multiple logical and physical data models to find the authoritative source for shared data elements across the LOB’s.
• Worked on forward and reverse engineering for certain oracle databases to identify certain data elements in use and study their relationships to analyze their use in the old and the new data warehousing systems.
• Exhaustively collected business and technical metadata and maintained naming standards
• Worked on 3 layered Teradata architecture: staging, integration and semantic and consulted on naming standards and the modeling issues to the business stakeholders.
• Utilized data warehousing concepts and worked on normalized/de-normalized table structures in dimensional modeling and created aggregate tables.
• Interacted with multiple BSA’s, SME’s for all LOB’s to discuss possible overlap of the information to be taken into consideration to build the one ‘true source of information’.
• Interacted with BI developers for business requirements gathering to generate the report elements.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Worked on IBM banking data warehouse industrial logical model on multiple subject areas.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models
• Analyzed aggregate tables and semantic layer modeling with BI developers and business SME’s to come up with the physical design.
• Using Erwin’s roll up and Roll down features after analyzing the business requirements.
• SQL querying for data profiling and data analysis was used to verify the data and the volumes.
• Worked on IBM banking data warehouse model to normalize all the entities and then de-normalize them for the customer consumption in the semantic and shared semantic layer of the architecture to be consumed by multiple LOB’s.
• Analyzing the data elements mappings and the data dictionary for the physical models and submitting to the central hub for metadata repository.

ENVIRONMENT: Erwin 7.3, Oracle 11g, Teradata 12, MS Excel, MS Windows, SAS, Cognos, Informatica etc.

Confidential, Washington, DC

Data Modeler

RESPONSIBILITIES:

• Leading the project in requirement analysis, design, enhancements and implementation and working with the data governance group.
• Worked on Forward and Reverse engineering using Erwin 9.5. Simultaneous modeling on OLTP and OLAP projects.
• Worked on Canonical modeling for OLTP projects and interacted with the principal software architects to conduct the design reviews.
• Creating and ensuring the feasibility of the logical and physical design models using Erwin 9.5.
• Worked on creating star and snowflakes schemas.
• Worked on Master data Management (MDM) Hub and interacted with multiple stakeholders.
• Fast paced environment demanded solution delivery on multiple modules simultaneously going live, like Taxing, Sales Audit, Retail, Merchandising, etc.
• Working with BSA’s, solution architects, developers and other stakeholders to gather the data requirements.
• Lead the modeling efforts on multiple enterprise level projects.
• Worked on BI requirements for Teradata environment and mapping documents for the ETL tool (ODI) using Erwin Data Modeler 9.5. Communicated with the reporting team (Microstrategy) for their requirements on staging to BTT, SLT tables and views.
• Worked with the SOA (Service Oriented Architecture), PIM (Product Information Management) for MDM Hub as well as Java developers.
• Interaction with BI developers and BSA’s to understand the reporting requirements and proving the appropriate source information with data profiling and analysis on the transactional systems for the Data warehousing.
• Conducting the review sessions with the architects and modelers and transferring the knowledge to the Technical leads and the software engineers.
• Delivering optimum solutions on data migration and enhancing model design as per the business and IT requirements and issues.
• Interacting with the third party service providers for software solutions for the client to provide the most efficient and cost effective solutions.
• Interacted with the solutions architects for the framework analysis for multiple modules like sales audit, retail, etc. for timely delivery of the data into the new system for transactional analysis for .NET framework team and then to redirect the output to the reporting platform on to the Teradata.
• As a supplementary part of data review board, interacted with the multiple customers for the true source of the data and its profiling.
• Lead discussions on designing the models on enterprise level.
• Worked with a team on certain projects as well as solo on some projects like sales auditing, taxing for the international retail, etc.

ENVIRONMENT: Erwin 9.5.2, SQL Server 2008/12, DB2, Mainframe z/OS 9.1/ LUW, Oracle 11g, Teradata 12, MS Excel, MS Windows, SQL Server Management Studio 2012, ODI, Microstrategy, Java, .NET etc.

Confidential, Bloomfield, CT

Data Modeler

RESPONSIBILITIES:

• Working and analyzing entities and relationships for billing and policy administration for the insurance domain.
• Developed Logical and physical models according to the requirements.
• Was involved in reverse/forward engineering 40+ databases mostly SQL server, MS access, Mainframe z/OS 9.1, DB2, SAS, etc.
• Worked on Erwin 9.5 Marts and Web Portal and was in the Enterprise architecture team and maintained the models on web portal for the North America division.
• Used version control feature in Erwin Web Portal to control the model versions and incorporated the ALTER scripts into the current model.
• Interacted with DBA’s, architects, managers, business analysts, data analysts, conducted interviews with SME’s
• Used forward engineering feature in Erwin for generating the DDL’s using the physical data model.
• Used Erwin Query tool for generating the customized reports and also generated data dictionary.
• Involvement in enterprise architecture for POC’s like big data analytics.
• Interacted with business analysts to get functional requirements.
• Built the conceptual, logical and physical model as per the requirements.
• Create standard abbreviation document for logical, physical and dimensional data models.
• Maintain versions of the models.
• Review the data model with functional and technical team
• Assisting developers, ETL, BI team and end users to understand the data models.
• Worked on dimensional modeling and maintained the star schema.

ENVIRONMENT: Erwin 8.0 & 9.5.2, SQL Server 2008/12, DB2, Mainframe z/OS 9.1, SAS, MS Excel, MS Windows, SQL Server Management Studio 2012, Crystal Reports 9, JIRA, TFS, oracle 10g, Toad, ERWIN 8.1, Crystal reports 9, Windows XP, DB2

Confidential, Raleigh, NC

Data Modeler

RESPONSIBILITIES:

• One on one session with business users to gather the requirements to develop the conceptual models.
• Developed normalized logical and physical database models to design OLTP system for applications using Erwin.
• 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 IBM BDW and was involved in dimensional modeling.
• Conducted the design reviews and validated the developed models by interacting with database administrators, business analysts and involved in master data management (MDM).
• Coordinated with DBA’s and generated SQL code (DDL) 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
• 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.
• 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 slowly changing dimensions (SCD) and hierarchical dimensions
• Worked on conversion process of data, which is stored in flat files into oracle tables.
• Worked with DBA’s to create best-fit physical data model from the logical data model in Erwin

Environment: ERWIN 7.3, oracle 11g, SQL, MS Excel, Microsoft windows, TOAD from Quest software, OBIEE, oracle 10g, Toad, ERWIN, Crystal reports 9, Windows XP, Teradata, DB2

Confidential

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.
• Reverse engineered the reports and identified the data elements, dimensions, facts and measures required for new enhancements of the reports.
• Designed a star schema for the detailed data marts and plan data marts involving confirmed dimensions
• Was involved in the enterprise level architecture and provided inputs on certain database changes.
• 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.
• Performed updates and enhancements to the already existing data models as required by using ERWIN/CA

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

Confidential

Data modeler

RESPONSIBILITIES:

• Create logical and physical models using best practices to ensure high quality and reduced redundancy
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Extensively used star schema methodologies in building and designing the logical data models into dimensional model.
• 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.

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