Team Lead Database Development/Architecture

Confidential

• Lead Architect involved in logical and physical data modeling, design, development and implementation of Health Care application. Engaged in key CIO initiative
• Lead team of 12 oracle developers to develop, customize and enhance applications including Asthma Disease Management, Member Auto Assignment, Medical SPD, Medicare SNP, Member and Provider Incentive programs. Grievance and Appeal program, Pharmacy cost claim data, Health Benefit Exchange, Provider and Member web portal application, MPSS, HEDIS data extract. Ancillary Provider data workflow. Capitated hospital and C-CAP system implementation.
• Led the delivery of a key project for Pharmacy on time and high quality, as a POC for a Make or Buy analysis. By developing in-house this project can save 30K/year to the company. Received accolades from the business unit for the same.
• Developed standards, guidelines and best practices for database design, Identify and define the master data domains across the enterprise.
• Provided strategy to implement Enterprise Data Warehouse EDW for business units integrating with databases and delivering artifacts that includes Enterprise Conceptual Model, Logical Model, Functional Model, Metadata dictionary.
• Presented Enterprise Conceptual Data Model to the Review Board that includes CIO and IT management. Defined the enterprise database architecture to support data management initiatives.
• Collaborate with application teams, key stakeholders, external vendors and executive leadership to ensure successful product delivery.

Environment: Oracle 10g/11g, SQL, PL/SQL, ER Studio, EA Studio, CVS, Visio, TOAD, UNIX, Linux

Principal Data Architect, Team Lead

Confidential

Project: Order Capture for eCommerce web application

• Led the data architecture team to develop and implement the order management system that increased revenue for the Gateway by providing web-based customers ability to configure and order servers. Reviewed and assessed architecture with business users to ensure meeting requirements. Managed multiple project phases, including assessment and feasibility studies, time and budget estimates, and impact analysis and design approaches.
• Received top recognition from the Project Management and Business Stakeholders for delivering high quality work, on time, and for providing diligent and revolutionary solutions to complex problems.
• Spearheaded the design team for creation of the enterprise Logical and Physical Data Model, Entity Relationship Diagram, and Data Flow Diagram.
• Managed data migration efforts that led to successful conversion of 1 million existing customer from SQL Server database into new ORACLE database.
• Improved database performance by 30 using best techniques of complex queries, packages, procedures, functions and database triggers.
• Provided data extraction capability for marketing campaign that targeted revenue of 750,000 per month.
• Mentored and trained developers and architects for database development best practices, data modeling and performance tuning.

Environment: Oracle 10g, SQL, PL/SQL, ER Win, Win CVS, Visio, TOAD, UNIX, Linux

Data Architect Team Lead, Consultant

Confidential

• Identified conceptual architecture solutions and determined need for Proof of Concept led POC efforts for multiple modules such Service Order Management, Capacity Inventory management.
• Managed design and development of data warehouse and web-based dash board application that provides real-time data to capacity planner and service provider for BellSouth broadband services.
• Collaborated with internal teams to architect and develop ODS/data warehousing solution to manage Network Management System information for robust reporting tools and improved decision making regarding DSL services.
• Led large data conversion and migration activity of more than 400 GB accounts onto new DSL technology platform. Created logical and physical Data model for NRS application.
• Increased system performance by 50 by enhancing the current system with good database design techniques thus leading to improved customer satisfaction.
• Supervised production deployment, technical support for the Network Reporting application.
• Mentored and trained group of 10 team members for database development, data modeling and performance tuning strategy. Developed Stored Procedure, Function, Packages, Materialized view

Environment: Oracle9i/8i, PL/SQL, Designer 9i/6i, SQL Navigator, UNIX, Precise/SQL, and Serena ChangeMan Dimensions, PVCS

Sr. Data Architect, Consultant

Confidential

• Delivered a very complex field-level security application and Data Conversion/Load process between Dun Bradstreet and Gulfstream customer data.
• Developed and tuned many complex Forms, database triggers, stored procedures, functions, packages and several user interfaces with web enabled Forms 6i.
• Reviewed database architecture, created logical/physical data model. Conducted Design review, Code reviews and System Test plan and business requirement review.

Environment: Oracle Application Server, Forms/Reports 6i, PL/SQL, SQL, Oracle9i, Designer 6i, SQL Navigator, UNIX, HTML

Sr. Database Architect, Consultant Confidential

Project: Supply Chain Management - Menlo Logistics

• Developed user interface for Sales Order-Shipments, Vendor-Ship Points, Part Master Modules
• The project was to develop a new module for the major retail chain organization. The major functions of the new module are dropping the daily sales delivery details and inter store transfer details from GE Retail System GERS into Menlo In-Transit Merge System ITM and Menlo Sales Order Management System SMS depending on open, new, updated, cancelled, finalized status for delivery planning and management.
• Streamlined the database by revamping the Data Model for Sales Order Extract System SOES ,
• Exported and imported application into other schemas and databases. Created Complex Queries, stored Procedure, Packages, Functions, database triggers, views, Forms and Reports for the system.

Environment: Oracle 8i, Forms/Reports 6i, Developer/2000, HTML, SQL, PL/SQL, UNIX, Designer9i

Database Architect/Developer, Consultant Confidential

• This system was developed to allow the Global Test Operation GTO sites to use a single, common inventory system to control and track the different types of inventories that the sites use. Inventories that the GENISYS System supports include the following: Maintenance, Repair, and Operation MRO , Production Parts, Experimental Parts, Production Tire, Experimental Tire, Tool Inventory and ON-Off Inventory. The GENISYS System limits access to various portions of the system based on the roles.
• Participated in creation of data model, setting up physical database and prepared design documents.
• Created views, stored procedures, packages, functions and triggers, Forms and Reports.

Environment: Oracle 8.0, Forms/Reports 6.0, Developer/2000, HTML, PL/SQL, UNIX Server, Designer 2000