SUMMARY:

• Over 20 years of extensive managerial and hands on experience in implementing Enterprise data Warehouses, Data Architecture, Analytics, Business Intelligence, Big Data, metadata and application development.
• Building high performing teams, people management, hiring and mentoring/coaching, performance management, organization skills, staffing, budgeting and planning, full lifecycle delivery, implementing cutting edge technology solutions.
• Financials, retail, eCommence, manufacturing, healthcare, and pharmaceuticals.
• Managed design and delivery of one of the largest Enterprise Data Warehouses in the world. Implemented brand new Enterprise Data Warehouse from concept to production.
• Experience in implementing big data using Hadoop, Teradata and NoSQL.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Sr. Architect (Data and Analytics)

Responsibilities:

• Developed data architecture for Site Builder, HOM Platform auditing based on PostGreSQL, and MongoDB. Evaluated Hadoop, HBase, and MongoDB for the architecture options.
• Provided technical leadership for CLEM (Cardiovascular Lab Efficiency Management) database and application design. Developed estimates, plans, implementation approach working with team. Developed scalable, extensible architecture. Collaborated with team and facilitated implementation of complete new product within 10 months.
• Developing data architecture and providing technical management of Data Architecture and DBA team for the Asset Performance Management suite implementation on Cloud platform.

ENVIRONMENT: Oracle, PostGreSQL, MongoDB, Hadoop, HBase, Riak, Redis, ERWin, Talend, ETL tools, Pivotal Cloud Foundry, Python, Java

Confidential, CA

Data Warehouse/Big Data Architect

Responsibilities:

• Responsible for leading implementation of new Big Data and Data Warehouse environment for the Real World Data and Analytics.
• Implement DW/Analytics support plan, new data areas, and enhancements of existing areas, data integration and dashboards.
• Support enterprise data modeling and architecture activities, design and development of ETL, dashboards, and scorecards.

ENVIRONMENT: Teradata, Aster, Informatica ETL, Tableau, Erwin Data Modeling Suite, Hadoop, HDFS, SQL, SAS High Performance Analytics, Linux, shell scripts. TOAD.

Confidential, CA

IT Manager Data Modeling & Data Architecture

Responsibilities:

• Responsible for managing company’s centralized data modeling / data architecture group. Leading a team of Senior and Lead level data modelers, to support data architecture and modeling design, development for all major OLTP, Data Warehouse/Analytics, Data Marts, and Business Intelligence applications.
• Manage end - to-end data architecture for variety of applications.
• Implemented Analytics / BI environment on new Netezza Data Warehouse appliance.
• Lead development of conceptual, logical and physical data modeling for Health Care Reforms/Heath Exchanges, ODS, EDW and Data Marts.
• Lead a team of data modelers to support company’s corporate website consisting of multiple integrated portals.
• Successfully completed a POC of enterprise metadata solution, and working on pilot.
• Managing demand and resource planning for 20 to 30 parallel running complex projects.
• Interviewed, hired, on-boarded high performing full time and contract modeling professionals to expand the team and support growing needs of the enterprise. Responsible for training, mentoring, career planning, development of resources and performance reviews.

ENVIRONMENT: Erwin Data Modeling Suite, Oracle RDBMS, Netezza, Teradata, Informatica Metadata Manager, Informatica ETL. SQL, Business Objects, SAS, TOAD.

Confidential, San Jose, CA

Sr Staff Architect - Data

Responsibilities:

• Responsible for Confidential ’s Data Warehouse architecture design and development. Led a team of architects and developers to design one of the largest data warehouses in the world.
• Managed the development and sustenance of Metadata Repository Application, and integration with BI tools.
• Implemented BI solutions for dashboards, scorecards, ad-hoc analysis, and enterprise reporting.
• Proposed a brand new architecture to take the Business Intelligence and Data Warehouse to the next generation, and to implement Self Service Analytics and Community Intelligence infrastructure.
• Planned and executed parallel domains development project tracks working with many development managers, business system analysts and architects.
• Implemented Hadoop, HDFS and HBase environments. Designed data sets on HDFS, developed data sets design for HBASE.
• Leading a team of architects and developers to design and develop the project tracks. Managing resources in US, China and India.
• Presented the project proposals to JAD, ARB, Steering Committee and other forums.
• Implemented new Data Architecture Standards, Strategy and Guidelines, to enable enterprise wide scalable solutions, avoid duplication of efforts and silo approaches.
• Managing the development of application modules for integration of Metadata Repository Application with MicroStrategy, EWA, and Electronic Assets Repository applications, and Hadoop.
• Led an effort to create a core team of development managers, MicroStrategy Managers, BSAs, and developers to put a fast track implementation of multi-domain data areas, and build MicroStrategy ad-hoc analysis.

ENVIRONMENT: Teradata RDBMS, Hadoop, HDFS, HBase, Map reduce, MicroStrategy 9, Sybase Power Designer 12, SQL Tools, XML, Java, Visual Basic, Informatica ETL, Ab Initio. TOAD.

Confidential, Dublin, CA

Sr. Data Architect

Responsibilities:

• Responsible for data architecture and data model design for all major in-house developed applications.
• Designed company’s largest Operational Data Store, and Enterprise Data Warehouse. Lead a team of architects and developers to design subject areas of the Enterprise Data Warehouse.
• Designed data architecture for company’s corporate web site. Lead a team of architects and developers to develop data models for various subject areas. Also designed the data architecture and model for the Canadian business web site.
• Evaluated and implemented a cutting-edge Enterprise Metadata Application for corporate metadata. Lead evaluation and implementation of ASG Rochade Metadata application. Lead development of a web front end using Java/Java Server Faces/JavaScript/XML/XSLT. Managed development of user interface design, use cases, and wireframes. Managed the entire application lifecycle from evaluation, design, system testing, UAT, and production deployment. Currently manage production support and next phases of the project to deploy the metadata application for additional business areas.
• Developed Data Management Strategy for the entire organization. As an owner of the strategy also responsible to in corporate new advances in technology in the strategy.
• Designed data architecture and data models for major Confidential systems including ODS, Enterprise Data Warehouse, company online transactions web sites.
• Implemented the Metadata Repository Application within budget, on time, and with existing resources and two additional contractors. Leveraged offshore resources to achieve optimization of timeline and costs. Similar implementations have taken much larger timeline and resources at other organizations.
• Developed and deployed processes to request, track and implement change requests and data model requests efficiently. Designed and implemented data architecture and modeling standards for the organization.
• Developed data marts for Investment Management reporting applications.
• Developed data mart for Sales Campaign Management applications that uses SAS for Campaign analysis.
• Managed development of Enterprise Data Model for Transfer Agency business.

ENVIRONMENT: Oracle 10g, Sybase Power Designer Data Modeling Repository, PL/SQL, Java, J2EE, JavaScript, Java Server Faces, XML, XSLT, XMLSpy, Eclipse, Apache Tomcat, Linux, Solaris, shell scripts, ASG Rochade, Repository Information Model, Content Management Toolkit, Repository Reconciliation Toolkit, Rochade Data Warehouse, Rochade APIs, TOAD, Oracle SQL Developer, Bugzilla, Subversion, JIRA, Informatica ETL, Microstrategy, SAS.

Confidential, San Francisco, CA

Lead for Database Design & Development/Systems Analyst

Responsibilities:

• Designed the data model for large Online Credit Card Servicing application.
• Lead a team of engineers to design and develop server side PL/SQL packages.
• Designed and developed ETL processes for Data Warehouse.
• Lead a team of engineers to manage new projects as well as project enhancements.

ENVIRONMENT: Oracle8i, PL/SQL, Erwin, Informatica, NetDynamics5, Java

Confidential, CA

Technical Project Lead / Project Manager

Responsibilities:

• Lead implementation and customization of Oracle HRMS 11.03.
• Developed custom modules and interfaces using PL/SQL, Oracle Developer and SQL.
• Oracle HRMS 11.03 REL, Oracle Financials 11.03 REL, Oracle, Oracle* Designer, Developer. PL/SQL, C

Confidential, San Francisco, CA

Project Leader / Business Analyst

Responsibilities:

• Responsible for requirement analysis, design, customization, development and implementation of Data Warehousing Quality Application.
• Created process diagrams, E-R diagrams and database-diagrams.
• Responsible for implementation of Oracle Financial Applications. Designed custom modules for Late Payment Finance charge processing. Designed Transaction Import module to transfer and process accounting entries from GL to Project Billing.

ENVIRONMENT: Oracle Financials 10.7 NCA, Oracle, Oracle* Designer, Developer. PL/SQL, C

Confidential, Redwood City, CA

Software Engineer

Responsibilities:

• Worked on development of Oracle.
• Human Resources product, which is a part of Oracle Applications.
• Responsible for design and development of all the seed data modules for the product.
• Seed data is the core definition data installed as a part of the product that governs the functionality of the application.
• Developed PL/SQL modules for Application Program Interface.
• Solely responsible for creating and modifying all the key flexfields, descriptive flexfields, value sets, lookups, special information types, benefit elements for the product.
• Solely responsible for designing and implementing seed data modules. Responsible for implementing the design changes in seed data modules.
• Responsible for monitoring and fixing product bugs.

ENVIRONMENT: Oracle Applications 10.7 SC161 (SmartClient), Application Object Library 7.5, Oracle Gov. Human Resources 1.0, PL/SQL 2.3, Oracle Forms 4.5, Oracle Reports

Confidential, Pleasanton, CA

Software Engineer, System Design Engineer

Responsibilities:

• Responsible for designing the TMALE Telemarketing application.
• Developed E-R model for the application.
• Lead a development team of two engineers.
• Designed and developed the input data module.
• Created process diagrams and process specifications.
• The company receives calling lists and prospective customer lists, telemarketing transactions data from its clients.
• The data content and formats are different.
• Developed a generic processing engine that reads data in any format and processes the transactions.
• The processing rules and format can be specified dynamically.

ENVIRONMENT: Sun Sparc Server, SunOS 5.5.1, ERWin, Informix, 4GL, esql, isql, C

Confidential, San Ramon, CA

Software Engineer, DBA

Responsibilities:

• Responsible, as a lead for the analysis, design, development and enhancements of a Healthcare application called PEERx Hospitals Benchmarking system.
• Prepared the functional specifications, designed database tables and tablespaces.
• Coded and implemented the application using SQL*Forms, PRO*C, PL/SQL. Designed and coded the data bridging modules to bridge the data to other healthcare applications.
• PEERx application is used for performing the productivity benchmarking of client hospitals.
• Responsible for analysis, table design and preparing functional specifications. Solely responsible for the enhancements and maintenance of the MECON-PEERx system.
• Designed and developed modules using PL/SQL, PRO*C, SQL*Plus, SQL*Forms, PowerBuilder.
• Performance tuned the database queries, forms and reports.
• Responsible for creating and managing production databases. Responsible for regular maintenance activities like efficient space management, objects management, managing the rollback segments, performance monitoring and tuning, fine tuning of instance initialization parameters etc.
• Responsible for UNIX system administration. UNIX file-system management, printers/print queues, installation of patches, Backups. Responsible for TCP/IP networking.

ENVIRONMENT: HP9000 G40, Sun Sparc 10, HP/UX, UNIX SunOS, Oracle and Oracle tools, C, PRO*C, Oracle Developer*2000, Oracle CASE/Designer*2000, PowerBuilder 4.0.

Confidential

Senior Systems Analyst

Responsibilities:

• Responsible as a team member for design, development and implementation of the Bill of Material application.
• Lead a team that maintained and customized the application for different divisions.
• Prepared system documentation and user manuals.
• The system assists designers in releasing the Technical Pats List for manufacturing.
• Once design release request is received the associated assembly is exploded down to leaf level for which the requirement exists.

Confidential

Senior Systems Analyst

Responsibilities:

• Responsible for the design, development, implementation and maintenance of system.
• The Engineering Change conveyed the changes in design detail after release of work orders to the procurement agencies that may have already initiated the action.

Confidential

Systems Analyst

Responsibilities:

• Responsible as a team member in requirements analysis, specification analysis, development, and maintenance of system.
• Developed the database design and coded programs to update the daily issues and returns.
• Developed screens and reports.
• The MPLP system keeps track of the bought-out material requirements.
• Due to the new Work Orders released and subsequent Design Changes, the requirement of bought-out parts changed.

ENVIRONMENT: MicroVAX 3500, VMS, C, PRO*C, Oracle 6.0 and Oracle Tools.