Lead, Develop and Execute project plan on NYISO database market system. Responsible for Design, Development and Management of in house and outsourced activities including Deployment and knowledge transfers. Responsible to creating detailed project plans and work estimates.Coordinate the project activities between NYISO and consultant companies to ensure smooth delivery of complete solutions. Performed Business Analysis, creating User Requirements, Functional Requirements and Design Specification documentation utilizing data gathered from both external and internal users.Created and conducted major training initiatives for several projects/systems for both internal and external users.Created process flow diagrams detailing the MIS functional process for market bids.Relational database modeling for system changes to the Oracle database for various projects. Code PL/SQL and SQL in Oracle 9i environment. Utilized PL/SQL to created procedures, functions, packages and views for various projects. Develop data warehouse applications including: ETL programming using Oracle Warehouse Builder, testing, debugging, backfilling data and implementation. Responsible for ensuring software design requirements are met in development life cycle.Created detailed test plans and use cases for QA testing in several projects.Assisted in QA role with testing and setup of environments for several projects.Created the Data Dictionary for the NYISO database systems.Responsible for coordinating detailed knowledge transfer sessions for employees before contractors are phased off projects. Provided support to departments outside of IT, in order for them to obtain the necessary data for analysis.

Created and maintained SAS programs to extract data from large flat files from the Oracle database. Developed and updated various reports tracking price trends and bid patterns for all New York State market participants. Monitored price trends for market participants.Developed a system flow chart which tracks data for the market participant's bids to the actual energy.