career objective                              

results-driven management reporting consultant eager to contribute superior analytical, organizational, and communication skills toward supporting the employer in optimizing financial and operational performance as a motivated and productive team member

profile                                                

ø  nine years of progressive business operations analysis and project management experience, with expertise in delivering cost effective, high performance technology and business solutions

ø  facilitate client-focused, service-oriented environment vital to maximizing customer satisfaction and retention

ø  proactively monitor industry trends and developments to identify opportunities to penetrate and expand highly competitive markets

ø  strategically plan and coordinate workflow and human resources for optimal coverage while containing labor costs

ø  dynamic organization, prioritization and time management skills; consistently achieve critical deadlines while maintaining high quality standards

 

~ technical proficiencies ~

languages:                   c, sql, unix, visual basic, javascript, html, asp      

software:                      ms office, project, visio, sql server, oracle

tools:                           sap bw, sap bi, business objects, bex analyzer, crystal reports

os:                              windows 98/2k/nt/xp/server, unix, aix          

hardware:                     ibm/mainframe, printers, palms

professional experience                

oc , insert location                                                                                                                     2007 c present

management reporting consultant

• perform a broad scope of functions for this leading global provider of document management, printing, and outsourcing services
• drive full project lifecycle from gathering requirements, conducting architectural reviews, high- and low-level design, coding, peer walkthroughs, testing, and acceptance
• provide critical analytical support and continuous communication regarding multiple concurrent projects to key stakeholders; serve as liaison for corporate hq, business process managers, and operating companies
• collaborate on major upgrades, implementations, migrations, and user trainings; projects have included serving as business object implementation team manager, managing the creation and delivery of diverse technical training programs, and participating in bw project for patch and plug in upgrades
• generate analytical reports instrumental to senior management in assessing business performance; developed flexible queries using filters, navigational attributes in bex analyzer to facilitate data analysis in a drill-down or summarized fashion to provide detailed information

 

pepsi, valhalla, ny                                                                                                                          2001 c 2007

equipment management analyst, pepsi north america (2005 c 2007)

• in recognition of outstanding performance, steadily progressed within company to attain position entrusted with managing relationships between franchise bottlers, 3^rd party installers, and suppliers and reducing all bottler suspense activities from equipment installations to returns and redeployment of fountain equipment
• analyzed business processes by developing customized solutions to reduce overall suspense costs and improve delivery of equipment management data to financial and accounting staff

 

continued

yyyyyy x. yyyyyy                                                                                                                                                                                       page 2

 

• managed and administered a one-time water filtration refurbishing program, with accountability for reconciliation and depletion of inventory, as well as working with 3^rd party suppliers to ensure all pepsico outlets received water filters and poured product with the correct filtration systems.

o          oversaw the rga (returns) and redeployment by analyzing which action, return or redeployment offered the least financial risk; designed and implemented a fully automated equipment return management system providing reporting functionalities to senior management to increase process efficiency, added value to the business by turning a paper and pen business process into a completely automated business model by formalizing the current business processes into an integrated database, and developed a sub-system for the ordering team enabling instantaneous submission of equipment requests  and significantly improving rga response time

• played key role in designing and executing 180-day plan to reduce outstanding equipment suspense balance from $18m to less than $11m; created and implemented automated call management application to verify installs with the customer and activate customer contact agreements for depreciation purposes, worked with pepsi business solution group and anchor bottlers to obtain key access to their inventory system to activate outstanding suspense agreements, and cultivated strong relationships with bottlers and vendors to improve equipment installs and the efficient return of redundant equipment

technical associate, pepsi business solution group (2001 c 2005)

• supported the human resource group in overseeing and managing the operational flow of employee heath and welfare data from pepsico divisions through the pepsico enterprise reporting database to health and welfare vendors; additionally reported on termination of employee ids and provided quarterly performance scorecard for the chief personnel officer to ensure data integrity
• led numerous initiatives to analyze business processes and identify opportunities to reduce operating costs and increase efficiency; recommended, implemented, and trained team members on new technological solutions
• spearheaded the conversion of all hr mainframe processes to a new file utility; partnered with the mainframe technology team, coordinated testing, and resolves outstanding issues

• directed, planned, and developed new unix test environment, coding to main control programs, test environment, versioning, and implementing processes to keep unix and oracle environments in sync
• assisted in the rollout the star team code version management application to the hris team; implemented business process to manage code migration from the development to production environments, developed video presentation and documentation of migration process, and provided user training
• pioneered upgrade of all hris applications to windows xp; coordinated test schedules and application upgrades within established timeline and budget
• added security controls to proprietary enterprise reporting database and unix server required by sarbanes-oxley (sox), with accountability for planning, design and oversight
• steered cost-saving project with merrill lynch to convert a ftp transmission protocol to a new platform for smooth and timely interoperability of file transmissions
• led the pepsico group security and continuity initiative for the hris team by developing disaster recovery plans for all priority 2 & 3 applications systems; authored and implemented backup and recovery strategies for mainframe and unix processes, trained  team on the policy and procedures required for disaster recovery, and served as hris team representative on the pepsico business continuity team

 

~ additional experience ~

financial marketing assistance intern, usb paine webber, white plains, ny                                              2001

information technology intern, mbia insurance corporation, armonk, ny                                        2000 c 2001

customer support center intern, ciba specialty chemicals, tarrytown, ny                                      1999 c 2000

summer intern, philip morris international, rye brook, ny                                                                          1999

student consultant / assistant programmer, pace university, white plains, ny                               1997 c 2001

education                                           

pace university, pleasantville, ny

master of science in information systems                                                                                        insert year

bachelor of business administration in finance                                                                               insert year