SUMMARY

• Proficient in all phases of the Software Development Lifecycle (SDC).
• Extensive knowledge in banking, insurance, pharmaceuticals, healthcare and retail domains with maintaining respective databases.
• Extensive IT experience in Data Modelling, Data warehouse Design, ER Modeling, Canonical Modeling, Dimensional Modeling (Star Schema. Snowflake Schema Modeling) and good understanding of Online Transaction Processing and Online Analytical Processing (OLTP & OLAP).
• Articulate with Data Conversion, Data Qualilty, Data Profiling, Performance Tuning and System Testing and implementing RDBMS features.
• Immense Experience in Customer Interaction, Collecting and Handling Customer Requirements.
• In a data warehouse environment, designed the staging area based on OLTP concepts, cleansed and profiled before loading into data marts.
• Expert in creating Canonical modeling repository that can be reused for generating schema for the current and future applications operations.
• Coherent with Normalization/Denormalization techniques in relational/dimensional environments and have performed normalizations upto 3NF (Third Normal Form).
• Competent knowledge in Data Modeling tools like ERWIN, IBM Rational Software Architect (RSA) and Embarcadero ER/Studio.
• Experienced as both an onsite and offshore project member.
• Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions and Strong understanding of principles of data warehousing, fact tables, dimension tables, Slowly Changing Dimensions (SCD) Type I and Type I
• Well versed in Forward and Reverse Engineering principles.
• Conversant in oracle tools and utilities like Toad, SQL PLUS, SQL Developer.
• Created data mappings to load data from traget using different transformations and executed workflows for data loads to target systems.
• Good understanding of Ralph Kimball’s and Bill Inmon’s modelling techniques.
• A good expertise in Extract Transform and Load (ETL) data from spreadsheets, database tables and other sources using Informatica.
• Well - versed in writing SQL queries to perform end-to-end ETL validations and support Ad-hoc business requests.
• An excellent experience in generating ad-hoc repots using Crystal Reports.
• Excellent analytical, communication skills with clear understanding of business process flow, SDLC life cycle. Quick starter with ability to master and apply new concepts. Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.

TECHNICAL SKILLS

Data Modeling Tools: IBM RationalSoftwareArchitect 7.1, ERWIN 7/8/9, MS Visio2006/2007/2010, IgniteXML4 ER studio

Statistical Tools: SPSS-Modeler

Reporting Tools: Oracle Reporting,Crystal Reports9,, SAP Business Objects 5.x/6.5,SSRS

ETL Tools: Informatica percentage 8x,9xSSIS,Data Stage

Languages: SQL, C, C++,MATLAB

Databases: Oracle 8i/9i/10g/11g, MS SQL Server2005/2008, MS Access, Teradata,DB2

Operating Systems: Microsoft Windows 9x/NT/2000/XP/Vista/7 and UNIX

Other Tools: MS Office, TOAD,SQL Developer,VISIO

PROJECT EXPERIENCE

Confidential, New Hampshire

Data Modeler

Responsibilities:

• Interact with the business partners, functional analysts, SMEs and scrum masters to gather business and technical requirements and understanding the flow of the process.
• Data modeling activities for Surety Work Bench for the line of business LIU.
• Gathering and understanding the business requirements as the part of the Integrated Change Log (ICL) process for accomplishing database changes.
• Creating and maintaining the ICL change log.
• Developing the Logical and Physical modeling for Surety Work Bench (SWB).
• Creating and maintaining data models for SWB- Admin, Underwriter (UWB), Bonds (WBB), Surety Agency Management (SAM) and QPCC.
• Generating the DDL as a part of the changes of the ICL process and attaching the DDL to the specified JIRA Story.
• Generating customized metadata reports using Report Designer using Erwin9.6.
• Maintaining sync between the Data Model and the Database (RAILS).
• Data modeling activities for regulatory reporting system requested by Peru regulatory department of LM.
• Upgrading tool to 9.6 and performance testing for Erwin9.6- template binding, standards and name hardening.
• Worked exclusively as a part of the Data Governance (DG) team for Data Management Center of Excellence (DMCoE).
• Track conformity across Global Specialty by way of dashboards, audits and data quality scorecards
• Ensure that shared data within Global Specialty is appropriately governed, is reliable and can meet business objectives
• Collaborate with other internal organizations and groups such as Legal & Compliance, Data Security & Privacy, Architecture, Quality Assurance, and PMO etc. to ensure greater synergy in data management efforts.
• Maintain & own the business information models (that capture the flow of data within business functions and processes) for the system domains in scope for Data Governance
• Work with Data Architecture and Data Governance groups to ensure adherence to standards and processes
• Ensure alignment of critical data elements in the business information model with Business Glossary
• Work with the project delivery teams to ensure that conceptual, logical and physical data models are consistent with the business information models for corresponding data domain.
• Worked to establish standardization and consistencies across Surety WB exclusively as well as other LOBs (LIU, LIM etc.).
• Created technical metadata standards for GSIT.
• Created documentation in the form of presentations, Visio diagrams and flow diagrams for data modelling center of excellence from a DG perspective.
• Assisted and participated in working sessions for Metadata standards.
• Generating reports to support the development of the Business Glossary for Surety work Bench.
• Worked closely with the development team for RAILS as a part of the ICL process.
• Supported the migration team from a data modeling and an ICL perspective.

Environment:, Erwin,9.x, Informatica business glossary 9.6.1, MS Excel, Java, Ruby on RAILS, SQL Server, MS Excel.

Confidential, New Jersey

Data Modeler

Responsibilities:

• Interact with the business partners to gather the services in application systems across the organization.
• Gathering requirements for all services at enterprise/Project level by communicating with project service leads of the project.
• Harvesting a directory of a canonical view of organization data across main domains.
• Creating enterprise canonical object structures in IgniteXML Organizer and publishing to ICS for creating schema's for services.
• Created Data Asset catalogue for easy accessible inventory of organization terms and definitions for reusing in development of new applications and services.
• As Foundational approach, discussed with Domain owners to gather high level Core components across the domain that can be reusable in future applications.
• As part of review board member provided suggestions and strategy on ISO data standards.
• Worked closely with development team to generate WSDL’s for applications using ICS.

Environment:, Ignite XML 5.6.3.4, ICS, Altova XML Spy 2015,MS Excel

Confidential, Warren, New Jersey

Sr. Data Modeler

Responsibilities:

• Communicated with the Information Architecture (IA) team, source business unit (SBU) team, ETL Team, Chubb Commercial Insurance (CCI) for understanding the functionality, structure and flow of the business working as a part of Data Management and Modeling (DMM) services team.
• Interacted with Business Analysts to understand the business requirements. Gathered the necessary information for Property Predictive Modeling and Claim Path Modeling.
• As a part of the working sessions with the Business Analysts, Data Architects, Data Analysts and identified the requirements and designed data models using Erwin9.
• Designed logical and physical data model based on the requirements for property predictive Modeling (PPM) project and Claim Path Business Intelligence Predictive Modeling initiative (Claim PMBI).
• As a part of PPM and Claims systems, designed property risk model for risk reporting and analysis.
• Worked on various models new and already existing for various business units- CCI, CLM, EBA,
• Designed new logical and physical models for external data sources like Accuweather, ISO, CPI matrices, BLS, etc., as part of the PPM project.
• Worked extensively with XML modeling team to make them understand the Enterprise message schema and Enterprise modeling data standards.
• Worked closely with Data Architects, ETL team and IA teams for various project related tasks.
• Worked with DBAs by issuing DBCR (Database change request) forms to make changes on already existing models as required by the customers, as a part of the DMM service requests.
• Generated DDLs as a part of the DBCR system.
• Generated various reports like pinned reports and metadata reports for business units using the report designer and pinned reports or the ODBC tool in Erwin9
• Developed the Wiki page for the ISG team and generated wiki presentable model PDF’s for various business units.
• Performed Erwin upgrade for models in 7, 8 and ER1 to Erwin 9.5.
• Generated report solutions for easy accessibility and faster generation of presentable reports for business units, using report designer in Erwin 9.5.
• Worked actively in the model mart initiative for the ISG team.

Environment:, Erwin7.x,8.x,9.x, MS Excel, Oracle 11g, DB2,Netezza.

Confidential, Columbus, Ohio

Sr. Data Modeler/ Service Modeler

Responsibilities:

• Communicated with the Service Integration (SI) team for understanding the functionality, structure and flow of the Middle Tier Integration (MTI) services for the Consumer Business Banking (CBB) line of business.
• Interacted with Business Analysts to understand the business requirements. Gathered the necessary information for Canonical modeling/Business object modeling (BOM).
• As a part of the working sessions with the Business Analysts, identified the logical names as per the Integrated Frame Work (IFW) standards.
• Closely worked with the Index modeling team to get the physical level information.
• Part of the daily sessions with Data Architects to review the work.
• Developed the canonical model objects and relationships between them to represent the business requirements of the services using the IBM Rational Software Architect (RSA).
• Performed mapping from SI services (source) to Canonical model repository (target).
• Created Canonical business attributes, classes and relationships using the RSA tool.
• Created class diagrams for the specific services.
• Worked extensively with XML modeling(SI) team to make them understand the schema and data standards
• Using the compare option in the RSA tool, performed merging on different Canonical (BOM) files from different projects and created a unified Canonical BOM model.
• Created and maintained the Canonical log (BOM log) for all the MTI services, withholding package level, class level, and physical level information for the attributes.
• Created logical data model from the canonical model (BOM).
• Created the physical data model from the logical data model.
• Worked as a part of the review and collaboration sessions regarding business processes, canonical (BOM) modeling.
• Conducted business meeting sessions for addressing discrepancies and resolving them.
• Assisted the Interface Design Model (IDM) team in understanding the Business Model.
• Participated in the Data Review Board (DRB) reviews as a part of the Data Architecture Team by playing the role of a secondary and email reviewer.
• Provided recommendations as a part of the DRB review sessions, to see if the attributes at the physical and logical level abide by the naming standards.

Environment: IBM Rational Software Architect 7.1s, Erwin8.x, MS Excel, Oracle 11g, DB2Celgene Corporation

Confidential, New Jersey

Sr. Data Modeler/Data Analyst

Responsibilities:

• Interacted with End user community to understand the business requirements and in identifying data sources.
• Closely worked with Business Users and acted as the source for IT with the complete business knowledge of the Projects.
• Gathered business requirements through interviews, surveys and observing from account managers and UI (User Interface) of the existing system.
• Prepared High level logical data models and BRDs (business required documents) supporting the documents containing the essesntial business elements and the description between the entities.
• Played an active role as a member of Project team to provide business data requirements analysis services, producing logical and Physical data models.
• Developed conceptual models based on requirement analysis.
• Defined and processed facts and dimensions.
• Designed the Data Marts using Ralf Kimball’s Dimension data mart modelling methodologies using ERWIN.
• Designed different type of STAR schemas using ERWIN with various Dimensions like time,services, customers and FACT tables.
• Worked with end users to collect business data quality rules and worked with the development team to establish technical data quality rules.
• Identified the Entities and relationships between the Entities to develop a logical model and later translated the model into physical model.
• Created Source to Target mappings and Transformations. Mapped data between Source and Targets.
• Widely used Normalization methods.
• Coordinated with DBA’s and generated SQL code from the data models using.
• Worked closely with the ETL SQL Server Integration Services (SSIS) Developers to explain the Data Transformation.
• Supported UAT (User Acceptance Testing) by writing SQL queries.
• Created SQL tables with referential integrity and developed SQL queries using SQL Server and Toad.
• Performed extensive data analysis and data validation on Teradata.
• Helped reporting team by creating Semantic layer for OBIEE.
• Worked with the Reporting Analyst and Reporting Development Team to understand Reporting requirements.
• Involved in Generating ad-hoc reports using crystal reports 9.
• Designed and Developed Oracle database Tables, Views, Indexes with proper privileges and Maintained and updated the database by deleting and removing old data.

Environment: Microsoft Windows Vista / Unix, ERWIN 8.x, oracle 11g, SQL, MS Excel,SSIS, OBIEE,Teradata, DB2, TOAD from Quest software.

Confidential, Atlanta,GA

Data Modeler/Data analyst

Responsibilities:

• Interacted with Business Analysts to get the functional requirements and conducted discussions with project team to gather more information.
• Gathered requirements and created ER (entity-relationship) diagrams as part of requirements analysis using ERWIN.
• Analysed and evaluated existing system for assessing how it supported functions.
• Designed the data marts using the Ralph Kimball’s Dimensional Data Mart modelling techniques.
• Identified the Facts and Dimensions.
• Created documents for logical, physical and dimensional data models.
• Created logical, physical dimensional models using ERWIN.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Created physical data models using forward engineering principles.
• Implemented Star Schema methodologies in designing and modelling the logical data model into Dimensional Models.
• Performed design sessions with Business Analysts and ETL developers and came up with design that satisfies the organization’s business needs.
• Worked with Database Administrators (DBAs) to finalize the physical properties of the tables such as Partition key.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Used various kinds of Data sets with SSRS.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Formatted the report layout for the requirement of the end users using SSRS.
• Member of Data model and Design Review group that overviews data model changes and system design across Enterprise Data Warehouse.

Environment: Erwin7.x,Oracle 8i, SQL Server, ER/STUDIO, TOAD and UNIX.

Confidential

Data Modeller/SQL Developer

Responsibilities:

• Worked in close association with the Business Analysts and DBAs for gathering requirements, business analysis, and testing and project coordination.
• Interacted with end users and acquired the reporting needs.
• Consulted with client management and staff to identify and document business needs and objectives, current operational procedures for creating the logical data model.
• Created logical, physical and dimension models.
• Created entity diagrams and relationship diagrams and modelled cascade to maintain referential integrity.
• Used Erwin to create tables using forward engineering.
• Generated Reports from data models.
• Reviewed the data model with the functional and technical team.
• Assisted the ETL staff, developers and end users to understand the data model.
• Maintained a change log for each of the data models created.
• Created SQL codes from data models and interacted with DBA’s to create development, testing and production database.
• Wrote store procedures and triggers.
• Added database objects (like indexes, partitions in oracle database) for performance.
• Checked to see if the data models and the databases are in sync.

Environment: Erwin7.x, Oracle 8i, SQL Server 2005, ER/STUDIO, Informatica, TOAD and UNIX.