summary

A results-driven and customer-focused information technology professional, with experience in managing and leading a broad range of successful IT initiatives aligned with sustaining business objectives. Possesses extensive expertise in planning, analyzing, designing, and implementing complex enterprise solutions in direct support of business strategy. Directs all stages of system development, including scope and requirements definition, project planning, design, architecture, quality assurance, and support. Manages corporate applications through the System Development Lifecycle SDLC .

technical skills

• Languages: SQL, Oracle PL/SQL, Active Server Pages ASP , JavaScript, HTML, Java, Software AG SAG Natural, C, Clipper, COBOL
• Software: Microsoft Office Suite, Microsoft Visio, Microsoft Project, Microsoft SharePoint, Business Objects, Documentum eRoom, Agile Document Management, Quality Center, Borland Caliber, Borland StarTeam, Microsoft Visual Studio, Microsoft Visual Interdev, TOAD, Informatica, Crystal Reporting, ePAC Computerized Maintenance Management System CMMS , Camstar Manufacturing Execution System MES , SYSPRO Enterprise Resource Planning ERP , Oracle Business Intelligence OBIEE , PaintShop Pro, Lotus Notes, TSO/ISPF, SPF/PC, OS/MVS JCL, U/ACR, Software AG SAG Natural 2, SAG Construct, SAG Predict, SAG Natural DB2
• OS: Windows, UNIX, Mainframe, OS/MVS
• Database: Microsoft SQL Server, Oracle, Sybase, dBASE II
• Server: Microsoft IIS, Microsoft LDAP/Site Server, SiteMinder Netegrity Security

experience

Confidential

Senior Business Intelligence Analyst

• Managed business critical Oracle Business Intelligence OBIEE reporting applications for Sales and Order Management.
• Managed SDLC process from gathering requirements through implementation with internal and external resources.
• Facilitated and led requirements gathering meetings with stakeholders.
• Created Business Requirement BRD and Functional Requirement FRD documentation.
• Introduced best practices and process improvements to optimize the existing SDLC.
• Mentor existing staff for process improvements.

Confidential

Business Analyst

• Supported Wells Fargo Advisors and Brokerage lines of business.
• Remediated business critical brokerage applications for Windows 7 Operating System compatibility.
• Participated in Agile SDLC Methodology.

Confidential

Senior Business Analyst

• Managed and administrated business critical applications, which included SYSPRO ERP General Ledger, Accounts Payable, Accounts Receivable, Purchase Order, Inventory, EFT, Sales Orders, Work In Progress , ePAC CMMS, Crystal Reporting.
• Managed and successfully implemented Electronic Funds Transfer EFT Automated Clearing House ACH function in SYSPRO ERP application.
• Created real time MS Excel pivot table reports for Balance Sheet and Income Statement with direct SQL database access.
• Executed full SDLC process phases Project Feasibility, Project Preparation, Business Blueprint, Realization Design/Construct/Test, Final Preparation, Go Live Support, Project Closure .
• Facilitated and led requirements gathering meetings with stakeholders.
• Created Business Requirement BRD , Functional Requirement FRD , and Technical Design TDD documentation.
• Delivered projects successfully, on time, on budget, and frequently ahead of schedule.
• Managed successful deployment of SYSPRO ERP system for international office location.
• Managed and coordinated business application software level upgrades.
• Managed I/T Sarbanes-Oxley reporting requirements and documentation.
• Participated in external audits of I/T Sarbanes-Oxley reports and documentation.
• Internal auditor for ISO 9001 Quality Management Systems and ISO 14001 Environmental Management Systems.
• Coordinated and documented software licensing with vendors and resellers.
• Managed reporting application enhancements and new development from gathering requirements through deployment.
• Facilitated and led meetings with developers, business stakeholders, and vendors. Provided upper management with summary level project status reports.

Confidential

Business and Technical Analyst, Project Lead

• Coordinated Windows 7 operating system and Microsoft Office 2010 upgrade as part of enterprise initiative.
• Coordinated the Oracle database upgrade from Version 10g to Version 11g.
• Managed the PepsiCo customer master file project in support of financial sales reporting applications.
• Managed reporting application enhancements resulting from the PepsiCo and Pepsi Bottling Company merger.
• Supported and led development and enhancements of eight Business Objects reporting applications of sales data and equipment inventory repairing and tracking.
• Documented business application requirements to ensure product delivery on time and as required, which included resource allocation, budgeting, project plans, cutover plans, and functional, non-functional, and detailed data design requirements.
• Facilitated training sessions and business requirement meetings as liaison between business partners and IT.
• Led team of six on-shore and off-shore vendor resources of Business Objects application developers to ensure delivery of critical reports essential for accurate reporting of company sales, invoicing, and financial information.
• Facilitated and led team status meetings of developers and support staff. Provided upper management with summary level project status reports.
• Managed and coordinated support of six Pepsi-Cola Foodservice reporting applications, consisting of financial, sales, equipment service systems, and contract management.
• Coordinated upgrade of Business Objects reporting software from Version 5.1 to Version XIR2. Aligned upgrade with business needs and corporate period close processing cycles. Coordinated Business Objects upgrade from Version XIR2 to Version XIR3.

Confidential

Senior Specialist

• Managed Foodservice Division sales and marketing website, which was utilized to communicate marketing promotions to employees, bottlers, customers, and vendors.
• Maintained and provided technical leadership for Foodservice Web application and Pepsi Information Exchange ePIX websites.
• Directed and executed all project lifecycle phases of insourcing and upgrade to Foodservice Web and ePIX applications architecture and infrastructure.
• Coordinated and executed retirement of 24 Foodservice Web application components.
• Created disaster recovery plan and procedures for Foodservice Web and ePIX website applications.
• Integrated Foodservice Web components with ePIX website application.
• Led and facilitated requirements gathering and website design meetings with PCNA customers, including ARAMARK, Compass, Walmart, Big Boy, Marriott, and Fuddruckers.
• Managed and maintained customer collaboration website, which was accessible by bottler organization and staff, customer locations, and company employees.
• Coordinated and executed retirement and archiving of Marketing Information and Tracking System MITS , Funds Management System FMS , and Media Advertising System.
• Coordinated MITS application back-end database conversion from Sybase to Oracle.

Confidential

Senior Programmer Analyst

• Created disaster recovery plan and procedures for bottle and can, as well as fountain beverage sales reporting system.
• Served in full project lifecycle for version upgrades to the Marketing Department's web-based application tool.
• Improved functionality of corporate beverage division bottler case sales reporting system.
• Enhanced functionality and productivity for management of brand, package, and product information application.
• Programmed computer application enhancements to prevent any downtime and loss of revenue to the company.
• Completed after-hours support call issues until resolution. Partnered with operations staff to restart batch processing to complete on time for next business day.
• Partnered with technology teams to resolve problems and answer customer concerns, as well as those of bottler organizations.
• additional experience

Confidential

Programmer and Technical Specialist Served in project lifecycle development for new retirement account payment request and settlement processing system. Performed process modeling and data modeling associated with new retirement system.

Confidential

Senior Programmer Analyst, Participated in Joint Application Design JAD sessions utilizing Information Engineering Methodology IEM . Performed process modeling and data modeling utilizing Knowledgeware's ADW. Provided 24x7 support, operational continuity, and enhancements to improve accuracy, efficiency, and productivity of insurance claims processing system. Participated in application development and software upgrade of insurance claims processing system to record, adjust, and make payments on submitted insurance claims, utilizing joint application development methodology, process modeling, and data modeling. Automated manual balancing procedures used in claims processing batch reports.

Confidential

Database Analyst, Programmer Analyst

Created and maintained application database tables and data dictionary. Served in all phases of project lifecycle, with emphasis on development of sales orders, invoicing, inventory management, and purchase order components of company merchandise order entry system.

Confidential

Programmer

Managed computer application source code libraries and hardware disk space allocation. Assisted the System Administrator with computer hardware maintenance and metrics. Developed customer mail merge system applications.

Confidential

Personal Computer Consultant Developed personal computer applications for sales orders, invoicing, inventory management, and purchase order functions in Clipper and dBASE III .

professional development

• Oracle Database and Query Language, 2006
• SAP Business Objects Reporting WebIntelligence and Desktop Intelligence, 2006
• Borland Caliber Client Software, 2006
• Borland StarTeam Client Software, 2005
• Informatica, 2005
• Microsoft Visual Studio, 2000
• Microsoft Visual Interdev, 2000
• Microsoft ASP, 2000
• volunteer and community service experience

Confidential

Partner with high school administration and staff to develop and implement a program to promote literacy among the students and the community.

Confidential

Attended meetings with members of New York State Senate and Assembly at the federal level to advocate for education of students at the annual National School Boards Association Federal Relations Network Conference.

Confidential

• Chairperson of Legislative Action Committee.
• Served as mentor to newly elected Board of Education Trustees.
• Panelist and Presenter at the Annual Prospective Board of Education Candidate Training.

Confidential

• Chairperson of Legislative Committee and Member of Audit, Finance, Special Education, Technology, and Transportation Committees, 2008-2009.
• Chairperson of Legislative and Audit Committees, and Member of Buildings and Grounds, Finance, Technology, and Transportation Committees, 2009-2010.
• Chairperson of Legislative Committee and Member of Finance, Human Resource, and Technology Committees, 2010-2011.
• Participated in developing annual school district budgets in excess of 110,000,000.
• Received New York State School Board Achievement Award for 2010-2011.
• School District Voting Delegate at the New York State School Boards Association Annual Business Meeting.
• Attended meetings with members of New York State Senate and Assembly at the state level to advocate for education of students at the annual New York State School Boards Association State Issues Conference.

Confidential

Co-Chairperson of the school yearbook committee, responsible for collecting yearbook orders, typing and formatting of yearbook content, proofreading, and content validation.