SUMMARY:

• 20+ years of project management and technical consulting experience in Fortune 500 companies using established project management methodologies and processes from end - to-end
• 20+ years’ expertise in design and implementation of enterprise-wide complex on-line, client/server, data warehousing, Business Intelligence and web-based systems.
• 5 years’ experience in managing multiple teams, strategic planning and serving as lead technical advisor to senior executives.
• 20+ years’ experience in Software Development Lifecycles (SDLC) with active involvement in Software development, deployment, quality assurance and support
• 5 years’ experience working with and managing diverse teams locally or virtually, internal and external partners, out-sourcing teams and vendors
• Proven track record of motivating, energizing, supervising and directing work of technical staff
• Strong leadership skills with ability to promote teamwork within diverse groups. Solid project management skills as well as sound cutting-edge technical knowledge.
• Strong experience in working with and managing Virtual teams, internal and external partners, out-sourcing teams and vendors
• As Chair of PMI’s Technology Forum, actively involved in mentoring and evangelizing emerging technologies, trends and best practices
• Oversee the development of the architecture framework for ACMS in accordance with SOA, MITA and CEAF frameworks. Assist with the evaluation and selection of software product(s), integration, architecture and security approach as well as the design of the software configurations
• Assisting with transitioning OSI/ACMS from Waterfall to Agile including adoption of State Agile Development framework and readying staff on Agile based implementation
• Technical Project Manager implementing $18 Million Appeals Case Management system for State Hearings Division
• Mentoring and leading collaboration across several OSI teams on adopting new technologies in Schedule management and reporting. Evaluated options for ACMS Project status reporting; Mentoring teams in CALHEERS, eWIC, CWSNS on Project Online and Power BI; Developed and rolled out interactive Power BI dashboards on project data;
• Worked as the Enterprise Lead Development Architect to prepare CAISO’s operational readiness to take over the MRTU project from the SI Vendor. Oversaw the implementation of ITIL processes and tools such as BladeLogic and Remedy.
• Project Manager of the Project Management Tools Project: Analyze, evaluate and implement a tool to manage Risk, Issues, Change Control, Deliverables and Decision tracking processes within FI$CAL
• As Project Manager, completed Portal Assessment, Taxonomy, Road map, Project plan and Deployment plan for a leading-edge Marketing Group implementing a brand new MOSS2007 Portal and Enterprise Content Management System
• BI architect responsible for architecting and developing ETL processes: validation, loading of data from 17 different Legacy energy applications to a central data repository; Performance tuning of SQL database, SQL Stored procedures and optimizing ETL processes
• Provide Technical leadership and driving force to customize and implement Windchill (Parametric product lifecycle management ERP solution) for Ireland and Singapore businesses of HP’s Image and Printing Group
• Execute Claims and Insurance Operations projects for Confidential based on the 2006 Business Plan. Track issues to completion, risk analysis and mitigation. Liaise with Business owners and IT on project priorities and manage complete lifecycle development (SDLC) through Release
• Worked as Release Manager for Confidential ’s insurance web sites for new states
• Worked with the development team in performance tuning of ORACLE PL/SQL, ETL, incremental loads, shadow table loads and other performance improvements. Assisted with the configuration and setup of OLAP environment for the business users of EDR
• Provide Technical leadership and driving force to develop and deliver a leading edge and business-critical application within the Product Generation IT space. ROCKET was a complex application development project with very aggressive timeline and complex components:
• J2EE, BEA Weblogic, ORACLE DB, Informatica ETL, ORA-XL, Hyperion (BRIO) reporting, MS OLAP Cubes, Siteminder authentication
• Manage/supervise application development projects through complete SDLC lifecycle: Meter Data Repository UI, Customer Interface, Employee Interface (Portals), Integration with TIBCO Workflows
• Worked as a Data Modeler/DBA for implementing enhancements to Power Billing System for Confidential Admin (Federal agency)
• Rocket Project: Performance Tuning of Brio reports - led the efforts to identify, quantify, research solutions and implement performance improvements for Brio queries and Enterprise data reports that were underperforming
• Manage upgrade of IPG (Image & Printing Group) Boise's PDM (Product Development Management application (Web application) from an unsupported environment to HP-UX11i, ORACLE 9i
• ETL Architect/lead: Implemented the data warehouse, performed ORACLE DBA tasks, and developed the extract/load/transform tools to load data from source systems in Europe, Americas and Asia/Pacific. Supervised the development of Cold fusion based web interfaces to the data warehouse

PROFESSIONAL EXPERIENCE:

Confidential

Project Architect/Technical Project Manager

Responsibilities:

• Provide PM oversight in the Agile implementation for Appeals Case Management system for State Hearing Division. Lead the testing efforts including test strategy, regression testing, UAT Plan and oversee scripts development.
• Completed the Privacy Impact Assessment for ACMS project - this became a model for other PIA’s within OSI
• Leading the efforts in transitioning from Waterfall to Agile including the adoption of State Agile Development framework and readying staff on Agile based implementation
• Assisting in the RFP process, act as the technical expert on the RFP, respond to bidder questions on ACMS requirements, participated in Bidders evaluations, demonstrations, final selection and contract
• Oversee the development of the architecture framework for the ACMS to ensure interoperability and reusability capabilities in accordance with SOA, MITA and CEAF
• Lead the Project Management Plans development, review and update efforts and setup procedures and processes for update, review and final signoff of PM Plans
• Assisted the Project Director in developing and refining formal governance structure and provided consulting on key activities such as business process documentation i.e use cases, and managing First Data contract resources.
• Actively worked with the team in developing, coordinating and obtaining final approvals from CDT on project documents including SPR #1, SPR #2, Spring Finance Letter, and BCP
• As the schedule expert, developed schedule management plans and processes, maintain/update project schedule, report to management, sponsors on schedule and risks.
• Developed Strategies on leveraging BI and Data Analytics for OSI:
• Evaluated Project Reporting and BI solutions for OSI PMO and ACMS project; prototyped Power BI interactive reports and dashboards for ACMS
• Mentoring CDSS BI team on strategy for incorporating Power BI into CDSS Enterprise Reporting
• Mentoring CALHEERS, eWIC, CWDS PMO team on using Power BI to create interactive dashboards on Project Schedule data and strategic planning for Project Online
• Evangelist on Technology Trends:
• Spoke at the PMI Technology Forum on Data Visualization and Business Intelligence using Power BI
• Presented at the PMI Scheduling Forum on creating interactive and mobile dashboards on Project Schedule data using Power BI

Confidential

PMO: Project Server Technical Lead/Master Scheduler

Responsibilities:

• Provided Schedule expertise during the development of RFP, BID evaluation and negotiation with vendors in the Procurement phase towards of the $880 Million FI$CAL SI contract
• Developed the Enterprise FI$CAL Master schedule comprising of over 14 work plans (> 15000 tasks). Lead the initial planning, conducted workgroup sessions within department teams to identify deliverables, scope, detailed tasks for each work stream. Analyzed risks, issues, task dependencies and developed the processes and procedures for managing and updating the enterprise schedule
• Architect, Design, Develop Business Intelligence and Reporting solutions for the FI$CAL PMO using SQL Server, Business Intelligence Studio, SSRS and OLAP. Developed over 25 complex SQL and OLAP Reports
• Lead staff in the decomposition and development of FI$CAL sub-project work plans with diverse stakeholders from sponsors, Partner Agencies and facilitated successful development of schedules overcoming conflicting requirements. Liaise with independent oversight, develop and coordinate audit responses
• Core team member in migrating from Desktop MS Project to Project Server 2010 - involved start to end in the design, rollout, migration, and standing up of Project Server 2010 at FI$CAL
• Key member of the Project Server Team, providing leadership and execution in the Technical areas including Business Intelligence, SQL Server Reporting, SQL Server and Project Server administration
• Performed schedule and resource analysis and generated views/reports needed to track and manage the project. Collaborated on implementing a reporting strategy, framework and management reports that enables effective management of the project at the Project Director/executive level; and provide visibility and direction for the staff. Identify, report on variances, ‘At risk’ tasks and set up a weekly Schedule Variance process to work with schedule owners on mitigating variances and escalate as needed to executive teams. Developed the schedule components for the Project Director’s report and integrated them into the weekly publishing cycle
• Replaced 3rd party reporting system with custom developed SQL Server Reports and Dashboards for Project Reporting Portfolio management - resulted in annual savings of > $200K.
• Performed Project Server administration, analyzed and classified data, mapped user security and implemented role based user access
• Participated in one of the very few successful Earned Value management processes in State of CA; Implemented the @Risk schedule risk modeling tool using advanced statistical modelling techniques
• Developed release strategy and plans; Managed testing, deployment and release of Project Server software patches and cumulative updates
• Created course materials, developed and delivered to end users, project managers and Resource managers.
• Special assignment: Project Management Tools Project - Analyze, evaluate and implement a tool to manage Risk, Issues, Change Control, Deliverables and Decision tracking processes within FI$CAL

Environment: Project Server 2010, Project Pro 2010, MS SQL Server, BI/Visual Studio 2008, SharePoint 2010, Kovair PM Tools, .NET

Confidential

Enterprise Lead Development Architect

Responsibilities:

• Developed Enterprise Architecture principles and programs. Established and provided guidance on technology architecture requirements, standards, and governance.
• Analyze Integration Architecture for ITIL Implementation and recommend scope of ITSM 7 Remedy, HPOV and Blade Logic
• As Integration Architect, drive implementation teams on the linkages between ITSM 7 Remedy, Blade Logic and HPOV; Create Integration Roadmaps and project plans
• ITIL Implementation: worked as the Lead Architect to define operational readiness policies, processes, procedures for Incident Management, Problem, Change, Configuration and Asset Management
• Lead workshops/meetings with process owners to disseminate ITIL Processes and procedures
• Lead CMDB 2 implementation: define scope, charter for CMDB integration, evaluate and recommend discovery process for CMDB
• Since Oct 07, lead the Enterprise Data Repository project as a QA lead responsible for validation, loading and fine tuning of data from 17 diverse energy applications to a central data repository. The data repository is the central BI source for Market Operations, Data Management groups. Collaborated with the DBA Team, Business Analysts, SME’s, developed and refined the data model for the EDR (Enterprise Data Repository) project at Confidential .
• Worked with the development team in fine tuning of ORACLE PL/SQL, ETL, incremental loads, shadow table loads and other performance improvements. Assisted with the configuration and setup of OLAP environment for the business users of EDR.
• Project managed the gathering of business requirements and supervised the development of Portals for business teams. Created Portals for Business teams to keep track of daily data migration, data integration, setup dashboards for use by Market operations, compliance, data management and other business teams.
• Assisted in developing long term strategic plans to reduce overall development and maintenance costs for .NET and J2EE application platforms through selection of architecture designs, framework and tools

Environment: ITIL, ITSM 7 Remedy, HPOV, BMC CMDB 2.0, SOA ORACLE 10G, Project Server 2003, Blade Logic

Confidential

Project Manager/SharePoint Architect

Responsibilities:

• Portal Assessment, Taxonomy, Road map and Project plan for a leading-edge Marketing Group implementing a brand new MOSS2007 Portal
• Identify scope, Schedule & conduct Business user meetings, Gather Business requirements, implement Departmental portal sites; Evaluate & Select 3rd party web parts and integration options - Microsoft CRM, Org Chart and Roll-up event Calendar, Cognos web part; Migration options for migrating SP 2003 sites to MOSS 2007;
• Evaluate Document management solutions using 3rd party tools such as Knowledge Lake. Develop searching solution for accessing data stored by team sites. Developed proof of concept system for migrating legacy workflow applications to web based Windows Workflow system.
• Install, setup, configure and administer SharePoint - worked with Infrastructure on server/software configurations and deployed in Dev, Test Staging and production environments. Work with the developer and network/infrastructure group on back up/restore processes.
• Implemented MOSS2007 sites for Client Services, Creative, HR, Marketing, Quality, Sales, IT and Corporate Portal. Worked with CIO on identifying quick wins for each department such as Roll-up Org Chart for HR, Dev Wikis/blogs for IT, Dashboards for Client services etc.
• Each department web site was created using 3 rounds of requirements gathering, demo and formal approval process. Migrated legacy sites and SP2003 sites to SP2007. Administered the portal sites - setup user access, security, and trained Portal Administrators.
• Analyzed options and solutions for Doc-star replacement, Cognos web part. Setup HIPPA compliant web sites for HR. Developed milestone, progress checklist charts to communicate with CTO and Stakeholders. Coordinate with Microsoft CRM implementation team and integrate CRM requirements in MOSS2007 rollout.
• Provide MOSS 2007 Orientation to IT & key stakeholders; Develop Release Management, Transition, Communication, and Acceptance test plans for going live with the new Intranet Portal

Environment: .NET, Web Services, Windows SharePoint Services 3, COGNOS, SharePoint 2007 (MOSS 2007), SQL 2005, Microsoft CRM 4.0, MS Project

Confidential

Program Manager/Technical Architect (contract)

Responsibilities:

• Initially responsible as a Data Modeler/DBA for implementing enhancements to Power Billing System per project plan for Confidential Admin (Federal agency), contracting through PPI. Lead a development team of 4 JAVA developers in the PBS project. Responsible for project scheduling, team communication, architectural consulting and technical leadership for the team to meet an aggressive schedule.
• Promoted in June to Program Manager on-site for the contracting agency (PPI). Liaise with Federal client (WAPA) on project, service, (performance based) contract and staff management issues; provide oversight.
• Manage/supervise application development projects through complete lifecycle: Meter Data Repository UI, Customer Interface, Employee Interface (Portals), Integration with TIBCO Workflows
• Supervising a staff of 17 people and responsible for resource recruitment and staffing process for PPI.

Environment: J2EE, BEA Web logic, ORACLE 9i, TIBCO, STRUTS, HIBERNATE, Portal(s), SharePoint 2003

Confidential, CA

Development Manager, Claims and Insurance Operations Software

Responsibilities:

• Execute Claims and Insurance Operations projects for Confidential based on the 2006 Business Plan. Track issues to completion, risk analysis and mitigation. Liaise with Business owners and IT on project priorities and manage complete lifecycle development (SDLC) through Release
• Release Manager for Confidential ’s Insurance application web site

Environment: .NET, Web Services, Interfaces with ChoicePoint, DuckCreek and ISO, XML/XSL/XSD, .NET, SQL 2000, VB.NET, ASP.NET, SharePoint 2003

Confidential, Roseville, CA

Technical Lead

Responsibilities:

• Responsible for overall management and implementation of project from start to finish
• Created project proposal (PDS) per HP Standard Business processes, determined project objectives, review with Sponsors and obtained approval; Assisted with POR planning - provided input to Business sponsors; Created WBS and Project Schedule with MS Project
• Negotiated SOW and PO with supplier (CoCreate) and assisted sponsors in the approval process
• Liaise with Infrastructure team, manage and track development with internal and external vendors (CoCreate), consistent with IPG’s IT development and implementation methodology
• Assembled project team (with the help of resource manager), engaged core team and part-time resources, assigned and monitored work of team members and provides guidance and leadership
• Facilitated requirements gathering, business analysis and acceptance test plans
• Prepared progress reports (project dashboards), activity reports from team and external vendors
• Tracked and communicated project status on a weekly basis to IT program management, Business sponsors and key stakeholders
• Provided issue management (identify, track) and facilitated resolution
• Developed contingency plans to mitigate and address risks
• Problem solving: Helped facilitate and resolve numerous roadblocks; when the technology conversion for the PDM access tool failed, acted quickly and engaged appropriate resources in time to complete the task. Won kudos from Business sponsors for the effort.
• Preserved project learning and intellectual capital by uploading all project documents to the Knowledge management repository
• Participated in project retrospective and communicated learning back to project sponsors, stakeholders

Environment: MS Project (WBS), PMBOK, ORACLE 9i database and toolset, J2EE, JBoss, UML

Confidential

Technical/Test Lead

Responsibilities:

• Assist in review of ISB reporting user requirements; Review reporting requirements and use cases, create functional specifications, and review detailed design specifications from offshore team. Liaise with offshore team on code development, coordinate code deployment, regression testing and facilitate issue resolution
• Engage and coordinate End User Acceptance Testing with business leads and key technical resources; Plan and Schedule code releases, notify EUAT schedule to stakeholders
• Track issues, prioritize, coordinate resolution with developers, regression test team; report daily EUAT status to project team and stakeholders
• Work with resource manager of outsourcing vendor in India on resource planning, schedule, priorities and issue resolution
• Manage Change requests - Analyze change requests, validate with technical team and business, facilitate Change review process at the Change Review Board (CRB), and coordinate implementation of change requests with developers in India. Participate in Architectural and Lifecycle reviews to ensure solution is consistent with HP’s Methodology

Environment: MS Project (WBS), J2EE and Java client, JBoss, WindChill (PDM application), Oracle 9i, Oracle 10g (evaluation), PMBOK, TOAD, UML, RUP, SAP

Confidential

Test Architect/Lead

Responsibilities:

• Create EUAT Test Plan, establish EUAT Success (Closure) criteria based on criteria from Business Sponsors and Technical Team
• Manage test activities, coordinate and engage test resources from the Global Businesses (Singapore, Ireland, India and US)
• Coordinate work with virtual, global teams (> 20 people) on a daily basis; work with technical team and EUAT test team to ensure completion of test plans
• Keep track of progress (Use Case Scorecard (EUAT metrics), weekly EUAT status reports) and report to Program Management, Project Team, Business and Sponsors
• Manage and track QA/Test issue list, facilitate issue resolution and communicate issues status on a daily basis
• Goal of the project was to help Product Generation IT develop a vision and strategy to improve reporting implementations that will enable greater predictability, usability and achieve overall user satisfaction
• As a core team member, contributed to the Report Strategy process and the creation of artifacts such as RACI, Engagement model, Tool selection, reporting strategy for Data warehouses, Application reporting, Data Mart reporting and guidelines on tool selection

Environment: Hyperion Performance Suite, MS OLAP (Cube), BRIO Reporting tool, Business objects, MS Project, PMBOK

Confidential

Technical Architect/Lead

Responsibilities:

• Facilitate completion and approval of all Application related documentation - Software Requirement Specifications, Architecture, Migration and User Interface requirements and design documents
• Coordinate and Liaise with IT infrastructure partners (GDIS, SASU), platform architects (Data), support organization, offshore resource teams and Business during Rocket’s development and implementation process.
• Lead Architecture review of all software specifications requirements - Ensure that the Architecture Lifecycle checkpoints and HP standard Architectural processes are followed.
• Actively participated in design and facilitated design reviews for all the technical areas of ROCKET: Use cases, UML Diagrams, Data Model, Data Architecture, Data Migration, ETL, BRIO Reporting, Java front-end, Site minder (Security) and Infrastructure/Support.
• Coordinate Application Development, unit testing, code build and release activities with out-sourcing vendor
• Worked closely with Quality Logic (QA vendor) on the scheduling, deployment and testing of code releases from offshore vendor from India. Track progress in QA testing (use cases and other deliverables) and report on metrics to Program team.
• Coordinate user testing, Track defects, issues, determine priorities with Business and coordinate problem resolution
• Coordinate data migration and ETL development & testing - work with offshore developers on Informatica migration workflows; work with key business users, data architect and DBA on data migration design reviews and test plan ; monitor and report progress to program team; facilitate problem and issue resolutions
• Facilitate user acceptance testing - work with technical and business on user acceptance testing plan, coordinate user acceptance testing activities
• Contribute to project status reporting at the weekly project dashboard meetings
• Manage and Schedule Stress (Load) and Performance testing - negotiate contract with GDIS on stress test, supervise test plans and coordinate tests; Organize analysis of results and performance tuning tasks
• Facilitate Support Transition - work with Support, Business and IT on support requirements, conduct weekly meetings, facilitate SLA signoff process, Support and DRP Planning.
• Create and execute RTT, RTP plan with the assistance of Technical and Infrastructure teams
• Coordinate on user requirements and development plan for Business Intelligence module for Rocket (BRIO dashboard reports and SAP BW). Facilitate architecture and CUBE design reviews, create WBS, liaise with developers, business and reporting infrastructure team, coordinate EUAT and roll out/implement code releases.
• Facilitate Change management - work with IT and Business on Change management strategy for Rocket, Analyze change requests, validate with technical and business, facilitate Change review process, coordinate implementation and resolution of change requests
• Performance Tuning of Brio reports - led the efforts to identify, quantify, research solutions and implement performance improvements for Brio reports that were underperforming
• Participate in Architectural and Lifecycle reviews, project retrospectives consistent with HP’s Methodology
• Problem solving: helped resolve complex technical, organizational and personnel issues through the course of the project: friction with outsourcing vendor, front-end performance issues, Siteminder authentication problems, very slow report development and resource issues

Environment: MS Project (WBS), UML, J2EE, BEA WebLogic 8.1, Informatica (ETL), ORACLE 9i, Siteminder, ORA-XL EXCEL Import/Export tools, Hyperion (BRIO) Suite, SAP R/3, SAP BW 3.0

Confidential

Technical Lead/ Analyst

Responsibilities:

• Participated in gathering requirements and data/reporting needs from end users and management to address escalation monitoring and reporting.
• Customized Contract, Employee Info cubes and ODS objects for data staging in BW. Implemented escalation Info Cubes.
• Created queries for power users and support the BW and R/3 reporting applications
• Worked on BEX Analyzer / Query designer to create and run reports, define queries, define variables, filters, calculated key figures, raise exceptions

Environment: ORACLE 9i database and toolset, SAP R/3, SAP BW 3.0B, and Data Warehouse generated from Clarify CRM (100 GB)

Confidential

ORACLE DBA/Data Architect

Responsibilities:

• Provided Technical consultation (Oracle Expertise) to the SCA development team on the testing, execution and enhancements to the migration scripts.
• Coordinate with outsourcing team in China on the development and implementation of migration scripts
• As a Consultant, helped oversee Sybase to ORACLE migration, installation and Database tuning efforts for the SCA ORACLE deployment phase

Environment: ORACLE 9i database tools, Sybase 11, Oracle 9i (25GB database generated from SAP 5.0 Contracts database ), Broadvision Middleware, PL/SQL, UNIX Shell scripts, DBArtisan, ORACLE OEM tools, ORACLE tuning Expert

Confidential

Technical Team Lead/Application DBA

Responsibilities:

• Performed roles of a Project Manager, Solutions Architect and Technical Team Lead. Responsible for migrating the application from a SQL Server database to Oracle 8; Transitioned web-based application to a fully supported Global platform. Prepared Project WBS, engaged resources, coordinated development and deployment.
• Worked with users and Business owners on requirements, application specs and design, enhancements. Planned and implemented application changes, coordinated testing and performed release to production tasks.
• Application maintenance: Coordinated change requests, bug fixes, application fixes to the ASP code with development staff in Europe and managed/implemented back-end (ORACLE, ASP, VBS Script) changes.
• Completed major enhancements including, adding a search capability for users to search for Consultant’s skills from within the ORACLE database and resume documents.
• Transitioned as primary ORACLE DBA from outgoing Contract staff. Performed ORACLE DBA tasks - create/maintain database instances, perform upgrades, support database.
• ORACLE developer tasks - Integrated Application with HP Services Directory, developed the ETL (extract/transform/load) scripts to load data from source systems in Europe, Americas and Asia/Pacific into a single Global instance. Evaluated and selected suitable load tools for the process including ORACLE import/export, SQL*Loader and 3rd party utilities.
• Migrated data from ORACLE and other databases using SQL Server’s DTS to SQL Server databases
• HP Consulting’s Resource Managers saw huge benefits from the application, helping reduce the turnaround time for Resource placement requests from several weeks to a few days.

Environment: ORACLE 8i database tools, SAP5 instances, Oracle Migration Workbench, IIS 5, Index Server, ASP, Unix scripts, ERWIN, DBArtisan, PL/SQL, XML, ASP.NET, C#, MS Project (WBS), MS SQL Server, DTS

Confidential

Data Warehousing Architect/DBA, Confidential Consulting IT

Responsibilities:

• Lead a development team of 3 developers. Participates in the initial project setup, worked on the application architecture with the team. Worked with Business owners and user council on requirements.
• Performed Dimensional modeling and analysis, designed and developed the data model (team work) and specified the overall architecture and ETL processes for of the data warehouse.
• Worked with Global IT group on the selection of the ETL vendor and purchase of software.
• ETL Architect/lead: Implemented the data warehouse, performed ORACLE DBA tasks, and developed the extract/load/transform tools to load data from source systems in Europe, Americas and Asia/Pacific. Supervised the development of Cold fusion based web interfaces to the data warehouse.
• With the help of the EMR warehouse, HPC Finance was able to reap substantial benefits annually by being able to identify and eliminate bad engagements
• Also contributed as a ORACLE performance testing and tuning consultant for the Knowledge Management team going live with large ORACLE databases and Livelink application as part of the K-Net program.

Environment: ORACLE 8 database tools, CONSTELLAR Data Transformation/Load tools (ETL), Informatica. Cold Fusion Web development environment, PL/SQL, ERWIN, DBArtisan, Livelink (Knowledge Management)

Confidential

Technical Team Lead/DBA, Confidential Consulting IT

Responsibilities:

• User Liaison, Support, Maintenance and enhancements to the Insight application.
• Perform all DBA tasks for the Insight (ORACLE) database. Develop extract/transform/load tools/scripts to refresh data from HP’s Order Processing warehouse and Employee Directory
• Supervise and Manage Y2K upgrade of Insight application, web tools and reports.

Environment: Visual Basic (Client), Inprise OEC (Middleware), ORACLE 8 database, SAP (warehouse). ASP (Active Server Pages), PL/SQL, ORACLE stored procedures/Packages, Cold Fusion web-based front-end and reports

Confidential

Senior Consultant (Contract Assignment) WFM Application

Responsibilities:

• Built major intranet web, deployed across the division, to support HP Consulting in tracking customer engagements, with comprehensive information available on-line regarding project revenues, costs, and schedules (ASP, VBScript, JavaScript, ADO, Oracle)
• Create prototype webs to demonstrate to management the effectiveness of moving traditional client/server applications to the web platform (Visual Interdev, ASP, ADO, Oracle)
• Mentor HP developers on the basics of creating web applications though Active Server Pages technology, JavaScript, and back-end server databases.
• Perform Database Administration, Capacity Planning, and Performance tuning /optimization tasks related to the Clarify (Customer Care applications) implementation projects for HP’s WFM group. Make customizations to Clarify (SoftwareExpress Project).
• As a member of the "Load Tools" project, wrote stored procedures, administer/tune/optimize SYBASE databases for batch load processes and maintained/enhanced LOAD (PERL) scripts. Perform Sybase DBA tasks for all Performix (SYBASE) SQL Servers.
• Responsible as the technical lead on a project to measure the performance and scalability of the Clarify customer support applications. Worked with business users on performance issues, identified key transactions for performance monitoring and tuning.
• Involved in the selection and evaluation of performance monitoring and automated test tools. Installed and configured stress simulation software - Performix from Pure Atria. Planned (created test plans), captured user transactions, created test scripts and conducted tests simulating 4000 users. Scheduled execution of stress tests and automated the capture of performance metrics. Created an Intranet/Web based reporting system to report the stress test results to stakeholders. Coordinated with vendors and provided support to production systems by using the simulation systems to isolate and remove problems.

Environment: Clarify (CRM) applications on HP-Unix, Clear Support, ClearBasic, UIEditor, Ddeditor, Windows NT 4.0 workstations. Sybase System 11, Clarify 4.54, Delphi 3, PERL, Crystal Info & Reports, Performix, Rational Test Suite, JavaScript, ASP.

Confidential, Roseville, CA

Consultant

Responsibilities:

• Developed a Facilities Shutdown application for NEC's Facilities department to help track and plan all the shutdown tasks for the yearly shutdown. Role involved work as a system designer liaison with end-users on detailed requirements, DBA tasks in developing and maintaining the database, writing stored procedures and triggers as well as the application developer. MS SQL Server 6.0, Delphi and Crystal Report, ODBC were the suite of development tools.
• Team member of the pilot Intranet project - Prototype development using Windows NT, IIS, Active Server Pages and JavaScript. Also evaluated Intranet development tools such as Borland’s JBuilder and IntraBuilder
• Developed an on-line extract system for feeding NEC Roseville’s Shipping, Production Summary and Overseas database systems with replicated data from Corporate SQL Servers (SYBASE System 11/ODBC).
• Created the Generic Error Handling component, a Delphi component to trap, manage and report application exceptions. This component is now incorporated into more than a dozen mission-critical applications.
• Developed the Cost Production Summary System, delivering to senior finance staff and planners a tool for the exact analysis and tracking of production costs, inventory and shipment activity around the world. Role involved liaison with users, writing user requirements and functional specification, system analysis/design, DBA tasks and developing the application. Database designed with ERWIN. Application developed using ORACLE 7 database, MS Access and Delphi.

Environment: Windows 3.1, Windows NT, Delphi, VB, MS ACCESS, ORACLE 7, MS SQL Server 6.0, SYBASE System 11, Novell 3.11, TIBCO (messaging system), ODBC, ASP (Active Server Pages), JavaScript.

Confidential

Essential Software Engineering (OOA & OOD Techniques)

Responsibilities:

• Worked on a part time consulting engagement at Confidential, trouble-shooting and tuning a MS SQL Server/ Paradox for Windows application (Feb 95).
• Worked as Consultant to TurboPower Software in the evaluation and selection of a suitable back-end SQL server for Delphi applications.
• Developed custom courses and trained developers in Delphi Client/Server development:

Confidential

Consultant

Responsibilities:

• Goods Receipt Processing Module
• Invoice Processing Module
• Data Transfer to ACCPAC Module
• SQL Server Performance Optimization

Environment: Windows 3.1, VB, Microsoft C++, MS SQL Server

Confidential

Consultant

Responsibilities:

• Member of application development group, developed, maintained and supported applications for Finance, Network, Sales, Marketing and Customer Services.
• Performed several role: User Support Consultant, Senior Technical Analyst, Database Designer, Analyst/Programmer, Systems Analyst and Project Leader

Environment: WANG PACE, COBOL