Data Architect And Lead Resume Example Fidelity Investment Management Tech

DATA ARCHITECT AND LEAD

Summary

14 years of Software architecture, design and development experience on a wide variety of platforms, operating systems and databases. 7 years of experience as database lead and data architect in application development and migration projects. 5 years of project management experience as technical project manager in managing team size up to 30 in data conversion, data quality, data migration and data warehouse projects.

Highlights

Systems analysis and design
Data Modeling
Data Architecture
Oracle SQL and PL/SQL Development
Project Management
Leadership skills
Business communication

Asset Management
Fixed Income
Institutional investments
Healthcare
Life Insurance

Accomplishments

Received MVP (Most Valuable Player) for project achievements in Fidelity Fixed Income.

Received Stellar Performance Award for FPP Product Trading Platform in Fidelity Asset Allocation.

Rationalized and enterprised end user application footprint by 70% for Fidelity Investments Fixed Income division.

Architected and designed enterprise solution for Rolodex portfolio application for Fidelity Investments Fixed Income division.

Delivered trading platform for FMR Co Asset Allocation FPP Product. Delivered Index and Benchmark subject area in FMR Co initiative Common Data Environment (CDE).

Experience

Data Architect and Lead
February 2011 to December 2012Fidelity Investment Management Tech － Merrimack, NH

Project: End User Application Migration Description: The objective of this program is to migrate and remediate applications to MS Office 2007 and convert database from SYBASE to ORACLE.
Infosys is required to perform inventory gathering, incompatibility analysis, migration of application to be compatible with Office 2007, migration of database from Sybase to Oracle, testing and delivery of solutions in target environment.
Responsibilities: Complete ownership of end user apps reengineering and migration Architected enterprise solution for Rolodex portfolio application Working on enterprise architecture for Mortgage desk Flexiview product Presented data architecture and Oracle solutions for complex user applications like Money Market Security Exceptions, Competitor Holdings, Muni Bond Trader's Notebook Rationalized end user app footprint on Sybase by 50% provided solution on enterprise Oracle database Data modeling and design of tables, views and packages Created data flow, system context diagram.

Principal Software Engineer and Lead
April 2010 to January 2011Fidelity Asset Allocation － Boston, MA

Project: Common Data Environment Buildout Description: Common Data Environment (CDE) is intended to serve as a centralized Operational Data Store (ODS) and Data Warehouse for common data storage, access and distribution across asset management functions.
It will provide the data access layer consisting of Stored Procedures & Views.
CDE provides a highly-available, operational data environment with an integrated view of all common subject areas used by Asset Management.
Data for individual subject areas will be sourced from their respective systems of record.
CDE will be implemented in a highly available infrastructure, using Oracle RAC, 3DNS, Virtual IP, Clustered file systems to provide high resiliency.
Responsibilities: Complete ownership of database design and development of Index subject area Data modeling of tables Created data flow and system context diagrams Architected and designed CDE Index data status UI using Oracle APEX Represented Index subject area in architecture and database review.

Data Architect and Lead
May 2009 to March 2010Fidelity Asset Allocation － Boston, MA

Project: UMA / PPS Trading Application Development Description: Strategic Advisors is working on an initiative to build and launch a product in strategic wealth management space.
This new Order Management System (OMS) will automate trade submission and management.
It should be developed so that it can be expanded in the future to accommodate additional product and support integration with different trading platforms.
Responsibilities: Complete ownership of database design and development Data modeling of tables for FPP (Fidelity Personalized Portfolio) Product Created activity, data flow, system context, state machine diagrams Participated in product architecture review meetings as database lead Participated in Architecture, Design and Code reviews.

Technical Project Manager
April 2007 to April 2009Fidelity Institutional Investments － Smithfield, RI

The Database Development team within the Fidelity Institutional Database Technology group provides a comprehensive solution offering integrated wealth management products and services through an easy-to-use interface.
I worked with Fidelity's Institutional Database Technology (FIDT) group on the National Financial platform, Advisor Channel platform and OSG area - Alerts, Wealth Central and ECT Enhancement projects.
Under the scope of this project, Responsibilities: Design and development of database Onsite Offshore co-ordination Offshore project management Design and Code reviews.

Technical Project Manager
March 2006 to April 2009Fidelity Institutional Investments Services FIIS － Smithfield, RI

FIIS Technology was building their Data Warehouse application.
I worked with Management Information Systems (MIS) team of FIIS in building and maintaining their Data Warehouse system.
Responsibilities: Design and development of Warehouse application Onsite Offshore co-ordination Offshore project management Design and Code reviews.

Systems Analyst
February 2003 to March 2006Fidelity Employer Services Co － Merrimack, NH

Triage and HOBS Maintenance Description: Health and Other Benefits System (HOBS) is benefits plan record-keeping application that enables comprehensive management and tracking of information related to employee's benefits.
Project involves maintenance of Health & Other Benefits system.
It requires resolving the issues in Oracle Advanced Benefits (OAB) application.
Responsibilities: PL/SQL Development and Unit Testing Debugging OAB application Resolving configuration issues in OAB for different clients Providing reports as requested by FESCo clients Coordination between offshore and onsite teams.
Project management related activities (including billing and resource management).

Software Developer
October 2002 to January 2003Fidelity Employer Services Co － Merrimack, NH

FESCo Offers Benefit outsourcing plan to various companies in US.
Initially FESCo used Benesoft for the system.Now due to increased requirements whole system is being shifted to Oracle Apps.
This Project deals with New Implementation, Conversion project from Benesoft to OAB (Oracle Advanced Benefits) and Support Project from FESCo OAB implementation (Maintenance).
Responsibilities: Building Technical Specification Sheets (Detailed Level Design) from PAM (Plan Administration Manual).
Configuring Oracle Apps using Oracle Forms.
Building Rules (PL-SQL Code) Testing and Implementation of Configured Module.

Database Administrator
July 2002 to September 2002New York Life Insurance NYLI DBA

STAR TECH DB Operations Description: A browser enabled application to handle NYLI's insurance operations in Taipei, Taiwan.
The Project involves building an application for handling end-to-end insurance transaction processing activities together with providing detailed documents and reports with minimum human effort.
The application also supports multilingual processing, User-friendly browser based interface.
The system can be customized as per the insurance business requirements in different countries.
The application is build using Amarta toolset for Database Interactions and HTML and JavaScript for User Interface.
Responsibilities: Creation of the databases for development and testing Maintaining the database Version control of the sources Database performance and tuning practices.

Software Developer
August 2001 to June 2002New York Life Insurance NYLI

A browser enabled application to handle NYLI's insurance operations in Taipei, Taiwan.
The Project involves building an application for handling end-to-end insurance transaction processing activities together with providing detailed documents and reports with minimum human effort.
The application also supports multilingual processing, User-friendly browser based interface.
The system can be customized as per the insurance business requirements in different countries.
The application is build using Amarta toolset for Database Interactions and HTML and JavaScript for User Interface.
Responsibilities: As a programmer/Designer, responsible for developing and designing of Three Modules of STAR*TECH System for NYLI-TAIWAN.
Development of front-end interface of the Policy Servicing (POS), General Enquiry and Inte.

Education

MS : Software Systems, 2006BITS PilaniIndia

Highest Honors

B Tech : Chemical Engineering, 1999HBTI KanpurIndia

Highest Honors. Received Ministry of Human Resources Scholarship for being top 10% of class.

Resume Overview

Companies Worked For:

Fidelity Investment Management Tech
Fidelity Asset Allocation
Fidelity Institutional Investments
Fidelity Institutional Investments Services FIIS
Fidelity Employer Services Co
New York Life Insurance NYLI DBA
New York Life Insurance NYLI

School Attended

BITS Pilani
HBTI Kanpur

Job Titles Held:

Data Architect and Lead
Principal Software Engineer and Lead
Technical Project Manager
Systems Analyst
Software Developer
Database Administrator

Degrees

MS : Software Systems , 2006
B Tech : Chemical Engineering , 1999

Data Architect and Lead Resume Example

Resume Score: 60%

Resume Overview

Create a job alert for [job role title] at [location].

Similar Resumes