SUMMARY:

• Around 7 years of extensive experience in Data Modeling, Data Analysis for Online Transaction Processing OLTP , Data Warehousing OLAP /Business Intelligence BI applications.
• Expert in Transactional/Dimensional Data Modeling.
• Experience in various Pharmaceutical, Financial and Banking Sector domains.
• Experience in gathering, analyzing the business requirements and creating Business Requirement Document BRD , Technical Specification Document.
• Proficient in Enterprise Data Warehouse. Worked extensively in several projects in both Forward Engineering as well as Reverse Engineering using data modeling tools.
• Experience in modeling OLTP and OLAP using tools like Erwin r9.5.1r8/r7.1/7.2/7.3,Sybase Power designer 12.1 and E-R Studio.
• Well versed in Kimball/Inmon data warehouse Philosophies. Experienced in Normalization/De-normalization techniques for optimum performance in OLTP and OLAP environments.
• Proficient in Software Development Life Cycle SDLC , Project management methodologies and Microsoft SQL server database management.
• Experience working on creating models for Oracle/Teradata/ SQL Server/DB2.
• Experience in working with BI Reporting teams which use tools such as Micro-Strategy, Business Objects and SSRS as well as development of ETL mapping and scripts.
• Experience in Data Extraction/Transformation/Loading ETL , Data Conversion and Data Migration by using SQL Server 2005 Integration Services SSIS and PL/SQL Scripts.
• Expert in using Agile Data Modeling methodologies.
• Efficient in data mart design and creation of cubes using dimensional data modeling and identifying Facts and Dimensions, Star Schema and Snowflake Schema.
• Developed the data warehouse model star schema for the proposed central model for the project.
• Exhaustively collected business and technical Metadata and maintained naming standards.
• Good in Data warehouse loads, determining hierarchies, building various logics to handle Slowly Changing Dimensions.
• Experience in dealing with different data sources ranging from flat files, Excel, Oracle, Sybase, SQL server. Experience in data cleansing, data transformation, data mapping from source to target database.
• Facilitated and participated in Joint Application Development JAD sessions, whiteboard sessions to resolve the revolving issues and facilitated the coordination between the teams
• 1 Experience with Teradata using database commands and Teradata utilities such as BTEQ, SQL Assistant, Fast Load, Multi Load, Fast Export etc. Worked extensively on XML Schema designs.
• Experience in design reviewing and validation of final data models.
• Possesses strong Communication Skills always understood Business Requirements appropriately and quickly. Good in Time Management, highly Organized.

Professional Experience:

Confidential

Sr. Data Modeler

This is one of the largest biopharmaceutical company where they discover different drug therapies on cancer and inflammatory diseases. Here as data modeler one can be responsible for taking a role in business intelligence BI and data warehousing DW solutions including but not limited to: dimensional modeling, logical and physical data model design, database tuning/optimization, design and development of ETL processes, business intelligence tool / solution architecture design and deployment strategy, report creation and distribution. As a Sr. data modeler I am involved in the analysis, design, and operation and troubleshooting of enterprise business intelligence applications that source data from multiple source systems.

Responsibilities:

• Worked closely with the Business users and Involved in gathering the business questions and the requirements.
• Used Health and Human Services Industry model as a reference for the Enterprise Data Warehouse.
• Worked with multiple source system SME's to understand the Source Data models and tailor them to fit in to the HHS industry model.
• Analyzed on the enhancements required on the source systems. Worked in Iterative based as well as agile environment.
• Maintained complete metadata in the Erwin model and used Erwin as a source for all the documentation.
• Used API Application Programming Interface tool to modify Physical structures in Erwin tool.
• Wrote Queries in Erwin tool to generate reports on the data model as per the adhoc requests from the clients and the users.
• Created a Normalized logical model for the business to understand the relationships and at the deeper level of granularity.
• Derived the De-normalized physical model out of normalized logical model. Generated the DDL's and handed to the DBA.
• Created the detailed Source to Logical to Physical mapping document. Worked with Business SME's and documented the Business rules for ETL Development.
• Worked with Quality Assurance team to develop Test Scenarios and Test Scripts. Highlighted the areas where they have to show extra care in testing and supported them throughout the testing phase.
• Provided design inputs and assisted ETL Architect and Senior Developers to come up with Optimal ETL Design Solution
• Conducted several Physical Data Model-Training sessions with the ETL Developers. Worked with them on day-to-day basis to resolve any questions on Physical Model.
• Played a key role along with the Semantic Modeler in building the Reporting Views. Was responsible in assisting semantic modeler with knowledge about the tables and their relationships.
• Worked with Cognos Team in building the Business Reports. Helped them to understand the Semantic model as well as the underlying Physical model.
• Conducted Training sessions for the stakeholders/sponsors about the model and the Cognos reports. Helped them to understand the complete EDW architecture. Resolved their questions and made them feel good about the entire system.
• Worked with DBA in facilitating performance tuning. Helped identifying columns for collecting statistics. Assisted in Query tuning by suggesting Optimal Join Conditions.
• Helped Project Managers in developing the Project Plan and providing estimates for the deliverables.
• Used TMM Teradata Mapping Manager which helped the team where all the mapping documents are integrated, used xml schema while designing.
• Created harmonized structures between different source systems loading in to EDW.
• Created Protegrity encryption functions and data types for the physical tables.
• Conducted design reviews with business analysts, Enterprise data architect and solution lead to create proof of concept for the reports.
• Used standard State Of Ohio naming convention file for the physical model.

Environment: Teradata 13, Erwin 9.5, Informatica, xml star schema, Cognos, Oracle, TMM, Oracle SQL developer.

Confidential

Sr. Data Analyst/Data Modeler

Responsibilities:

• Conducting the meetings with business users to gather data warehouse requirements
• Conducted team meetings and Joint Application Design JAD session
• Gathered requirements and created use case diagrams as part of requirements analysis.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Consulted with client management and staff to identify and document business needs and objectives, current operational procedures for creating the logical data model.
• Developed normalized Logical and Physical database models to design OLTP system for education finance applications.
• Created dimensional model for the reporting system by identifying required dimensions and facts using ERWIN r8.2.
• Used forward engineering to create a Physical Data Model with DDL, based on the requirements from the Logical Data Model.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Worked with the Business Analyst, QA team in their testing and DBA for requirements gathering, business analysis, testing and project coordination.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle and SQL Server database systems
• 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.
• Identified the Facts and Dimensions.
• Identified and tracked the slowly changing dimensions and determined the hierarchies in dimensions.
• Used Model Mart of ERWIN for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Involved in Data Mapping.
• Participated in performance management and tuning for stored procedures, tables and database servers.

Environment: Erwin r8.2, SQL, SQL Server 2000/2005, Rational Rose, Windows XP, Oracle 8i, Windows XP/NT/2000

Confidential

Data Modeler

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality.
• Involved in gathering user requirements along with Business Analyst.
• Interacted with end users to identify key dimensions and measures that were relevant quantitative.
• Created the Source System Analysis documents and Architectural Solution documents.
• Developed the logical and physical data model for the proposed solution.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Involved in the complete life cycle of the product from requirements gathering to end of system testing.
• Created views to support the Business Objects.
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
• Extensively used the dimensional normal form for the data warehouse design, and used xml schema while designing models.
• Involved in many of the integration projects.
• Created Indexes and capacity planning and worked closely with the DBA's.
• Created Summary and Aggregate tables for better performance of the query.

Environment: Oracle Database 10g, Teradata 12.0, xml schema, Windows XP, TOAD for Data Analysis, Erwin r7.3, Teradata SQL Assistant 13.0. 2

Confidential

Data Modeler

Responsibilities:

• Gathered various reporting requirements from the business analysts.
• Designed conceptual and logical data models of databases and tables.
• Identified entities and relationships and how those all fit together in logical model, these are then translated into physical model using ERWIN tool.
• Created databases for OLAP Metadata catalog tables using forward engineering of models in Erwin.
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
• Developed system flow and data flow diagrams for the proposed systems. Involved in the critical design review of the finalized database model.
• Helped in migration and conversion of data from the TERADATA database into Oracle 8i database.
• Involved in Complete Compare in Erwin to make a difference between the existing model and the target database using forward engineering.
• Designed mappings using Informatica7.1 coming from different sources like databases, flat files into oracle staging area.
• Extensively worked on the naming standards which incorporated the enterprise data modeling standards and generated reports to verify the model against the pre-defined enterprise standards.
• Involved in test plans and test cases for QA Unit Testing, System Testing and Enterprise testing.
• Exposure to stored procedures, functions, database triggers and packages as per the business needs for developing adhoc and robust reports. Incorporated dynamic SQL for generation of the where clauses dynamically based on the lexical parameters passed.
• Responsible for development and testing of conversion programs for importing data into Oracle database utilizing PERL shell scripts SQL Loader.

Environment: Oracle Database 8i, ERWINr7.2, Linux, Windows XP, Windows NT servers, SQL server, Informatica7.1, Teradata.

Confidential

Data modeler

• Worked with the Business Analyst and DBA for requirements gathering, business analysis, and testing and project coordination.
• Gathered requirements and created use case diagrams as part of requirements analysis.
• Analyzed and evaluated existing system for assessing how it supported functions.
• Designed the data marts using the Ralph Kimball's Dimensional Data Mart modeling techniques. Identified the Facts and Dimensions.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Consulted with client management and staff to identify and document business needs and objectives, current operational procedures for creating the logical data model.
• Created physical data models using forward engineering.
• Involved in creation of use cases using UML and managed the entire functional requirements life cycle using Rational Unified Process, Requisite Pro, Rational Clear Case and Rational Clear Quest.
• Conducted GAP analysis and data mapping to derive requirements for existing systems enhancements.

Environment: RUP, UML, IBM rational Rose, Clear Quest, Clear Case, Requisite Pro, Erwin r7, Model manager, Model navigator, Oracle 9i, Content db, SQL, PL/SQL, Toad, Business Objects

Confidential

Data modeler

Responsibilities:

• Involved in the entire system study, analysis and design.
• Requirement gathering from the users. A series of meetings were conducted with the business system users to gather the requirements for reporting.
• Requirement analysis was done to determine how the proposed enhancements would affect the current system.
• Provide ER diagrams via Erwin.
• Prepared logical and physical data models by recognizing the proper entity and the attributes and implementing a proper relationship between them.
• Involved in writing the SQL codes and utilizing analytical, aggregate functions.
• Used different types of joins, helped build indexes, partitioning of the tables, etc.
• Performed user unit testing and interacted with the testing team and helped debug the code.
• Involved in documenting the entire technical process.
• Supported technical teams involved with Oracle issues and operations.
• Involved in the maintenance of the database.
• Design and developments of the changes and enhancements. The existing submission and refining programs were enhanced to incorporate the new calculations.
• Designed XML schemas using Unified Modeling Language UML translating business concepts into XML vocabularies
• Interacted with end users to identify key dimensions and measures that were relevant quantitative.
• Experience in SSIS, SSRS, SPSS in solving business problems environments: Oracle 9i, SQL Server 2005, SQL Loader, XML, Erwin, Windows 2000/NT, UNIX. COGNOS