SEARCH

Data Architect and Lead Resume Example

Resume Score: 60%

Love this resume? Build Your Own Now
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 2012 Fidelity 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 2011 Fidelity 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 2010 Fidelity 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 2009 Fidelity 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 2009 Fidelity 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 2006 Fidelity 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 2003 Fidelity 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 2002 New 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 2002 New 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, 2006 BITS Pilani India

Highest Honors
B Tech : Chemical Engineering, 1999 HBTI Kanpur India

Highest Honors. Received Ministry of Human Resources Scholarship for being top 10% of class.
Build Your Own Now

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

Advertisement

Similar Resumes

View All

Lead Data Architect

United Health Group

Irvine, California

Posted 1096 days ago