SUMMARY:

• Experienced in Design, Analysis and Modeling of Master Data Management (MDM) application for Aon Risk Services (ARS) with business benefit approximating $100M US revenue per year and spanning over 40 countries across the globe.
• Worked as a Data Modeler in IBM Party Data Model implementation for Agent data for Erie Insurance.
• Overall experience of 9+ years working for IT projects in Insurance Brokerage (Property and Casualty) domain.
• Extensive experience in data analysis, manipulation and extraction, transformation and loading (ETL) of data for large scale, highly complex and highly normalized relational database management systems (RDBMS).
• Trained and experienced in AGILE methodologies of project development (Scrum).
• Strong understandingof data modelingtechniques, with the ability to create process flow diagrams and the ability to read data flow and entity relationship models.
• Created logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Optimized and updated logical and physical data models to support new and existing projects.
• Have maintained conceptual, logical and physical data models along with corresponding metadata.
• Performed reverse engineering of physical data models from databases and SQL scripts.
• Well Versed in server side and/or client side technologies.
• Strong experience in Oracle and in depth hands - on knowledge on advanced PL/SQL.
• Have worked on Stored Procedures, Functions, Packages, Views, Cursors, Bulk Collect, PL/SQL Collection Types, Synonyms, DB Links, Triggers- Oracle 10g and 11g.
• Proficient in writing Sub Queries/Inline Queries/XPATH Queries/Hierarchical Queries and queries involving complex joins.
• Fine Tuning of Sql Queries and usage of EXPLAIN PLAN.
• Loading data from .CSV and Flat Files into relational tables through
• SQL* Loader using control files. Also maintain sanity of data by loading right character set data.
• Oracle External Tables.
• Worked on Data Mapping: XML Structure, Flat File to Relational Format of Database (Oracle).
• Knowledge of Basic Unix commands and creation of simple shell scripts.
• Possesses exceptional communication skill, as well as ability to work effectively independently or with a team.

TECHNICAL SKILLS:

Tools: Erwin Data Modeler, IBM Data Studio 4.1.0.1,IBM MDM Infosphere, Purisma 4.1.3 MDM Tool, Enterprise Architect 9.3, IBM Blueworks Live, Softerra LDAP Browser 4.5, BMC Service Desk Express SDE, Rally, OpTier,MS Visio, Toad, WinScp, Putty, MS project, IDM Filenet

Technologies: PL/SQL, Shell scripting(basic),VB.NET, ASP.NET, Silver light, EnterpriseLib 4.0, MSMQ, Aspose

Databases: Oracle 10g and 11g, MS Access, SQL Server

Reporting/ETL Tools: BO XI R2, Crystal Report 11.5,SSIS, IBM Infosphere DataStage 8.5

Version Control Tools: VSS, TFS, SharePoint, CA Harvest Software Change Manager

Methodologies: Waterfall, Agile, RDBMS

Issue Tracking Tools: Clear Quest, HP Application Lifecycle Management Quality Center

Scheduling Tools: Autosys, Indesca

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Oracle 11g 11.2.0.4.0, IBM MDM Infosphere, IBM Infosphere DataStage 8.5, Enterprise Architect 9.3, IBM Blueworks Live, Oracle Sql Developer 4.0,Erwin Data Modeler, IBM Data Studio 4.1.0.1,Softerra LDAP Browser 4.5, CA Harvest Software Change Manager, HP Application Lifecycle Management Quality Center, BMC Service Desk Express SDE, Rally, OpTier, Crystal Reports.

MDM Data Modeler

Responsibilities:

• Involved in, Design, Modeling and execution of work streams to support the Confidential solution using the IBM MDM Party Model.
• Load sole-proprietors as individuals in MDM
• Create fields for individual contact information in MDM
• Extract specific data from Agent Master(Legacy Mainframe Agency application) and load it in MDM
• Load not-appointed Agency employees into MDM
• Support the real time synchronization program
• Facilitated design workshops with key stake holders (including the in house Enterprise Architects Team and Solution Engineers as well as the Business Analysts and the end users) to gather functional requirements and reporting needs.
• Single handedly designed and modeled the database objects required for the ETL solution that extracts data from Source table (Oracle) and populates an existing set of target staging tables (Oracle).
• Created standard abbreviation document for logical, physical and dimensional data models.
• Developed best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Designed and created data reports using Microsoft Excel and Crystal Reports to help Sales and Agency business team in their decision making.
• Played the role of Scrum Master in our agile methodology project (bi weekly sprints), facilitating daily stand ups and syncing the story board with Rally tool.

Confidential

Environment: Oracle Sql Developer 4.0, Toad, Putty, WinScp, PL/SQL, Oracle 10g Client, Visio 2007, Purisma 4.1.3 MDM Tool, SSIS

MDM Application Modeler

Responsibilities:

• Primarily involved in modeling key business entities like Carrier, Client, Product, and Industry to maintain data integrity and eliminate redundancy
• Worked with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Recommended opportunities for reuse of data models in new environments.
• Performed reverse engineering of physical data models from databases and SQL scripts.
• Created a data governance workflow which standardized stewardship processes and reduced time required for data governance and distribution between data source and data consumption systems.
• Mapping and tracing data from source system to downstream applications to maintain the lifecycle of an entity.
• Analyzed data-related system integration challenges and propose appropriate solutions
• Managed requirements from blueprint to business sign-off, directly presented design in senior leadership steering committee meetings throughout project.
• Facilitated workshops with key stake holders and converted functional specification documents into technical design documents.
• Closely involved in the support activities that include performance tuning, job scheduling, resolving deadlocks, managing data space utilization and periodic patching of the application and database servers.
• Involved in full lifecycle activities including requirements analysis and design, developing analysis and reporting capabilities, and continuously monitor performance and quality control plans to identify improvements

Confidential

Environment: NET Framework 2.0,Oracle 10g,VSTS,VB.NET, ASP.NET,PL/SQL(Oracle), NET Framework 3.5, Enterprise Lib 4.1, Oracle 11g, MSMQ,Aspose,SilverLight

Technology Lead

Responsibilities:

• Managed a team of 5 developers and 2 Quality Analysts for the Office Upgrade project to enable ‘Bridge’ application support to Office 2007/2010.
• Involved in the design and architecture for the solution developed in SharePoint 2010 and Silver light platform.
• Interacted with client, gathered the requirements and steered the development effort.
• Estimated the timelines for each change request and conducted sessions to help defect prevention.

Confidential

Environment: Toad, Putty, WinScp, PL/SQL, Shell Scripting, Oracle 10g Client, Visio 2007, VS 2008, EL 4.0,Crystal Reports

Technology Analyst/ Technology Lead

Responsibilities:

• Involved in complete development of the MDM framework from inception and progressed into the role of a Developer, Technology Analyst and Team Lead over the span of 3 years.
• Developed and managed MDM application data deployment in over 30 countries.
• Created processes to adhere to Service Level Agreements (SLAs) for Level 3 application support team.
• Designed Commission Grid that provided negotiated commission rates with Carriers available to ARS offices nationally by certain markets, by line of business. This facilitated current systems, processes and reports to capture the total commission leakage by 31% representing $11M in annualized potential revenue lost.
• Involved in transitioning the legacy Rosetta ETL application to the MDM framework (using Purisma 4.1.3 MDM Tool) that retired approx. 50-70% of the custom database scripts and automated the data stewardship environment.
• Worked closely with the client, developing complex reports involving PL/SQL procedure, VBA macros and Crystal Reports.

Confidential

Environment: NET Framework 2.0, Oracle 10g, VSTS Testers Edition, VB.NET, Infragistics 2006, Component One, IDM FileNet, PL/SQL (Oracle).

Module Lead

Responsibilities:

• Involved in support and enhancements of ‘Bridge’ application by leading a team for working on the Change Requests.
• Involved in Performance Testing of the application using VSTS Tester’s Edition.
• Involved in estimation for future opportunities that are in scope of Bridge and related functionalities.
• Worked as a KM Prime and CC and responsible for managing KT sessions and configuration controller related activities.

Confidential

Environment: NET Framework 2.0, Oracle 10g, VB.NET, Infragistics 2006, Component One, PL/SQL (Oracle), Citrix Client

Developer

Responsibilities:

• Implementation and testing of code changes required in the application for deploying it on Citrix.
• Involved in fixing issues raised during User Acceptance Testing and production rollout support of the ‘Bridge’ VB.Net application

Confidential

Environment: NET Framework 2.0, Oracle 10g, VB.NET, Infragistics 2006, Component One, PL/SQL (Oracle), VS 2005, Crystal Reports 11.5, Business Objects XI

Developer

Responsibilities:

• Contributed to development effort for ARS proposed migration of Bridge (Aon’s Policy Management System) from VB 6.0 to VB.NET.
• Responsible for development and unit testing of key modules of Bridge.
• Integrated Business Objects XI Reporting Framework with the new .NET application.