SUMMARY:

• 16 years of IT professional experience specializing in the areas of Architecture, Design and Development on a variety of platforms, operating systems and databases.
• Lead Data Architect for Data Warehousing, application development and migration projects. 3 years of Project Management experience as a Technical Project Manager in data integration, data migration and data warehousing projects.
• Enterprise Data Architecture
• Data Modeling
• ETL - Data Integration
• Oracle & PL/SQL Development and Analytics
• Project Management
• Leadership skills - Excellent Communication
• Interpersonal & Knowledge Coordination Skills
• Insurance
• Reinsurance
• Banking - Regulatory Reporting
• Telecommunications

TECHNICAL SKILLS:

CASE Tools/Databases/Languages: ERwin Data Modeler, Model Manager, ERwin Examine, BPwin, Power Designer Oracle Exadata, SQL Server, DB2, AS/400, MS Access, and Sybase ASP, Java, Java Script, SQL, PL/SQL, PERL, CGI, HTML, C++, CSS, XML/XSL, DHTML, Visual Basic, Visual C++, Visual J++, VBA MS Office, Visio, MS Project Crystal Reports, Business Objects IBM (MDM, IGC, IA), Power Center, Data Stage

PROFESSIONAL EXPERIENCE:

Lead Data Architect / Solution Architect

Confidential

Responsibilities:

• Dodd Frank - RRDW (Lead Data Architect): Led a team of Data Modelers to build the Logical Data Model based on the Teradata FSLDM. Integration and Mapping of Data into the RRDW. Architected the framework for the transient staging area.
• Data Model Management: (Data Architect): Setting up Framework, Policies, Standards and Procedures for Data Model Management of Logical and Physical Data Models.
• Master Data Management (Solution Architect): Created Architectural Blue Prints for the MDM tool for upgrades for the Operational and Silver Instances. Created Presentations for GTAC and CIO approvals
• Data Quality (Solution Architect): Created architectural blueprints for implementation of the IBM IA tool with connections to multiple data sources.
• Meta Data (Solution Architect): Provided architectural support for implementation of the IGC tool and solutions for Point in time Repository for IGC for Regulatory Reporting

VP - Expert Information Engineer / Data Architect / Lead Data Analyst / Project Manager

Confidential, NY

Responsibilities:

• CMP-DWH: Managed Interfaces for 10 major systems to be integrated into the Enterprise Data Warehouse (CMP-DWH). Implemented new source systems and reduced the errors for existing sources. Designed the Meta Data Schema for the TAD implementation of the Data Model. Involved in all major architectural decisions.
• Migration of the DWH - CMS to MDM systems (Project Manager): Successfully migrated the data from the CMS to the SAP MDM and then back into the CMP-DWH. Ensured decommissioning of the CMS system and received Sign-off from all teams after ensure all data was successfully migrated.
• Prime Project - (Lead Data Analyst): JAD and Mapping sessions from the North American Specialty - Point system to LFD. Created DDS Scripts for the AS400 Common Landing Area (CLA) from Meta Data generated from the Power Designer data Model. Coordinated the changes of the new Release of the CLA with the core team and also assisted the Local Finance Database team with setting up interfaces. Tested the loads from the NAS CLA into the CMP-DWH.
• FIRE Project (Lead Data Analyst): Created and maintained of the Common Landing Area (CLA) on the Life & Health UK and US environments. Executed the scripts to populate the CLA from the OLTP application views. Tested the loads from the BoF CLA into the CMP-DWH. (Data Architect) JAD sessions with the business analysts and offshore team to design the data flow for the remittance requests.
• Fire Interface (Lead Data Analyst): Analyzed and studied the existing Life & Health database structures. Created complex views from the Life & Health system to be consumed by the Common Landing Area from the Data warehouse environment. Facilitated multiple Knowledge transfer sessions for the offshore teams.
• Message Management Archival (Lead Data Analyst):
• Led the development effort to implement a quick solution to archive data in the message management tables from the life and health system. Analyzed Oracle trace files to figure out where the queries were performing badly and then suggested recommendations to improve the performance.
• CRIS FAC/FIS Data Migration to GFS & CRIS TTY/TAS Data Migration to the iUF application (Lead Data Analyst):
• Performed data analysis and made data fixes on the source data in the underwriting systems. Assisted in the ETL Attribute as well as the value to value Mapping. Performed data analysis and made data fixes on the source data in the underwriting systems. Assisted in the ETL Attribute as well as the Value to Value Mapping. Advised the teams in a lessons learnt session on how to improve on the mistakes made in the prior ETL efforts
• Operational Data Store (ODS) (Data Modeler, Analyst, Developer)
• Successfully implemented the ODS to source data from various Underwriting Systems for the Accounting and Claim systems. Rolled out new major and minor versions during each year of the project. Interacted with business and system owners to design the ODS data model and map data elements to the ODS. (real time Operational Data Store with contract information)
• Coded the Extract procedures and Translate packages using PL/SQL to extract data from the source systems and translate them in the interface environment. Tested the logic to fragment contract data to be loaded into the ODS. Created materialized views with fast refresh capability and tuned SQL queries to improve performance. Performed analysis of extracted and translated data against existing source system data. Performed data analysis and data mapping (integration of key underwriting/claim/accounting systems in the organization). Back-fixed existing converted data in source systems. Created Live Control Reports for Auditors to inspect Data Quality. Analyzed migrated Accounting and Claims Information consisting of Millions of Rows of data.
• Interacted with the database administrator and lead data architect to implement changes to schema and the data model. Created database links to transfer data and analyze data. Monitored Unix and Tivoli Jobs for Production Support and created Issue Logs
• Common Codes (Data Analyst, Developer)
• Created an Excel master workbook with lookup values of 98 common lookup tables for the basis of the SDL (Swiss Re Data Language) concept. Mapped all source system lookup tables to the new Common Lookup tables Exported all data from spreadsheet into the Interface environment using Access and Power Center.
• Designed a robust ASP application which allowed the business users to view/modify data in the common lookup tables with an Audit Log
• HTML Models (Model Manager Administrator, Developer)
• Administered and maintained 32 corporate data models in model manager. Documented a Tutorial on how to read a data model for business users
• Developed a repository of data models in HTML using ERwin 4.1Developed a tree menu for detailed view of data models, data dictionaries and DDL scripts

Lead Data Modeler / Analyst / Developer

Confidential, NY

Responsibilities:

• FSDA (Lead Data Modeler, Data Analyst)
• Diagnostics, Analysis and Recommendations for the optimization of 123 Financial Systems
• Interacted with business and system owners to diagnose the financial systems.
• Generated Business Process Models for World Wide Systems
• Performed analysis of all systems with interfaces (input and output) and recommendations for optimization.
• PMDB (Lead Data Modeler, Developer)
• Integration of Visual Basic and MS Project
• Analyzed and documented the Client Requirements and Objectives
• Designed the Data Model and Created and Administered the Database in SQL Server 2000
• Prototyped and Refined the Program with clients approval
• Developed the Application using Visual Basic and SQL Server 2000

Data Modeler / Web Master / Network Administrator

Confidential

Responsibilities:

• Maintenance of the RFA (Remote Feature Activation) logical and physical Model using ERwin 4.0
• Publishing and Maintenance of HTML Data Models on the Web
• Documentation, Updates and Enhancements to the Data Model
• Resource to support the backup & recovery and database administration on Oracle 8i
• Development of SQL Stored Procedures & Triggers in Oracle using PL/SQL
• Contact Management System (Supporting Data Modeler, Developer)
• Gathered business requirements and rules for the Contact Management System (CMS)
• Designed the Data Model using ERwin 4.1 and created the Database in Access for CMS.
• Designed the application screen layouts (GUI) and developed client server and web Application using Visual Basic, ASP, HTML, Java Script.
• Documentation
• System (OS) and Hardware Requirements
• Data Flow and Process Diagrams
• Technical Documentation on code.
• Troubleshooting the Errors in Development of code and compilation. Maintaining a timeline for the completion of modules of projects. Research and Recommendation for Software and Technologies used. Technical Support and assistance.