Project Data
Resume:
Holly Buzgo
Cary, NC *****
E-mail: **********@*******.***
KEY SKILLS
Operating Systems
Windows NT/2000/XP UNIX MVS
Software/Applications
Visio DB2 SQL Server
Business Objects SAP (FI, PS, MM, CO) C/C+
SQL Lotus Notes Oracle (Toad, OBIEE)
Oracle Financials ERP Oracle Projects MS Office Suite (Front
Page, Project, MW, Excel,
Methodology Access, PP)
CMMi, Agile
EXPERIENCE
Cisco, Durham, NC 9/2010- To Present
Financial Business Analyst
. Participate in close related functions such as forecasting, preparing
journal entries with related reconciliations and the generation of key
month end reports.
. Partner with Sales Controllers to determine appropriate revenue
recognition treatment in compliance with the Company's revenue
recognition policy and US GAAP.
. Experience in revenue accounting, including SOP 97-2 and EITF 08-1
guidance for complex revenue deals.
. Manage revenue for multi-element arrangements.
. Reconciled deferred revenue accounts
. Programmed tool that flagged product revenue risk when Advanced
Services lacked evidence arrangement.
Sensus Metering, Raleigh, NC 11/2008- 9/2010
Lead Manufacturing Data Analyst
. Perform data analysis and implementation of new process analytical
applications.
. Determine root cause of data anomalies as it pertains to the
manufacturing process
. Create data feeds consisting of RF binding information and
calibrations
. Act as liaison between programmers and Manufacturing Project Managers
Cisco, Durham, NC 6/2007- 8/2008
Consultant Business Analyst
. Create business and functional .net requirements for partner portal
and applications.
. Source and analyze data, develop reports, develop key metrics and
present analysis to business management.
. Created new business processes and documented new workflow
responsibilities.
. Heavy data analysis using Oracle 11i database, Toad, and OBIEE tools.
. Responsible for data quality projects which required creating and
manipulating tables in Oracle and My SQL.
. Lead Analyst in charge of cleansing service contracts for customers
using the Know the Network process and Cisco Network Asset Collector
inventory tool.
. Worked cross functionally with international theater teams.
Wachovia Bank, Charlotte, NC 11/2004 - 8/2006
Business Analyst
. Developed sustainable processes for governance, compliance, and on
going method to identify an inventory all databases enterprise wide.
. Member of the Risk Data Strategy team for governance of Basel II
accord involved with selecting Business Intelligence tools and
reporting.
. Created project plan, statement of work, communications plan, referral
for proposal, scorecards, business requirement documentation.
. Researched/Defined/Documented/Evaluated/Designed/Managed requirement
specifications defining business status regulations).
. Create data mappings and gap analysis for data mart and metadata tool
population.
. Coded business rules using JavaScript, XML, and SQL Server.
. Created detailed testing scripts using SQL queries.
. Created test plans; developed use cases and executed business/production
and systems acceptance testing as it related to UAT and QA Testing in
both test and live environment.
. Liaison between business unit and IT, gathered and documented
requirements, mapped data and report requirements, led meetings and
developed workflow processes.
ABN Amro, Boca Raton, FL 4/2003 - 11/2004
Database Manager
. Lead Business Analyst on risk analysis project, developed requirements to
enable the calculation of the probability of default and other risk
components associated with credit risk.
. Collected and stored asset and equity data associated with clients in
order to create a weighted average credit risk calculation.
. Designed and coded a screen, which automatically calculated the credit
risk of a client BEFORE the salesperson entered a trade.
. Managed database and validated database for incorrect or missing data.
. Responsible for mapping database components from one system to another.
. Created automated reports for sales staff and management.
. Lead team in conversion project from Access to SQL Server.
. Determined scheduled/actual balances and researched curtailments with the
Loan Administration Department.
. Reconciled Blotter and trade positions.
. Designed Capital Investment Second Mortgages Inventory System using SQL
Server and Crystal Reports.
JP Morgan Chase Investor Services, NY, NY 10/2000 - 12/2002
Senior Technical Officer
. Project Leader using CMMi methodology, developed detailed plans, project
testing.
. Managed UAT testers on data warehouse conversions.
. Developed process flows for various business units including WINS Core
Accounting, Global Trading, and Pricing Systems.
. Create MS Project plans and managed projects, meetings, produced
timelines and managed critical dates.
. Facilitated meetings with key stakeholders; facilitated group meetings
for project planning, information gathering, and design review.
. Defined data integrity rules for new data warehouse tables.
. Performed and coordinated new software releases
. Responsible for loading asset, liability, equity, and detailed holdings
information for global securities.
. Designed and documented reconciliation processes to ensure data quality
between the data warehouse and core accounting system.
. Considered a subject matter expert on accounting feeds (trial balance,
NAV data) from warehouse to clients.
. Research data integrity issues using SAP and Vantive core accounting
software.
. Created ad hoc reports using E.piphany tool.
. Managed the WINS Warehouse system, which contained over 6 billion dollars
of the world's assets.
. Gathered and translated business requirements into functional/technical
documentation.
. Analyzed integration points with other applications.
. Performance tuned data population of over 70 percent of the DB2 warehouse
data.
Prudential Health Care, Vineland, NJ 10/1997 - 10/2000
Senior Business Analyst
. Managed project planning, task estimates, special DBA requests such as
unloads, reorganization, performance tuning.
. Project Lead in the development of data warehouse applications.
. Designed, documented and developed a Case Build system for hospital
inpatient data for metrics.
. Trained technical staff on change control procedure and basic data
storage concepts for COBOL, DB2 data warehouse.
. Created and implemented all Y2K compliance test plans and test cases.
Office Depot, Boca Raton, FL 10/1995 - 9/1997
Senior Business Analyst
. Created functional scope documents, detailed program specifications, and
training documents for a new physical inventory system.
. Project Lead in the conversion of inventory of record from AS400 to
mainframe platform.
. Coordinated the project transition and handoff to the support team.
. Designed screens, database tables, and reports using COBOL, DB2 and CICS.
. Coordinated development tasks with other teams.
. Reconciled inventory on hand with those at distribution centers, in
warehouses, and in transit amounts.
. Maintained a Store Inventory System which processes included inventory
receipts, returns to vendor, store transfers, on hand adjustments, and
general ledger feeds.
. Managed a staff of five.
Lever Brothers, NY, NY 10/1989 - 10/1995
Senior Technical Specialist
. Researched, analyzed and documented business requirements (training
manuals, workflow/process diagrams, use cases, technical documentation,
data analysis and test scripts).
. Aligned training resources with end users and internal development team
to develop implementation and training requirements.
. Designed a Marketing Financial Planning System using client/server and
distributed computing environment technologies.
. Marketing Financial Planning System used PowerBuilder as the front-end
GUI running under windows. The servers were on UNIX. Server code is
written in C. Data is stored in Oracle and retrieved using SQL.
. Successfully migrated an MVS based Cost Analysis and Planning System to
UNIX platform.
. Led team that automated the filing of State and Federal taxes through
magnetic media.
. Established a LAN based Pension Management System.
Merck, West Point, PA 4/1985 - 10/1989
Programmer Analyst
. Implemented an on-line Call Reporting System using COBOL, ADABASE and
NATURAL.
. Frequent user interface and new program development for daily processing,
database conversions, on-line screen input and requests.
. Provided technical support for entire system.
. Implemented corporate-wide procedures for disaster recovery for all
backup systems.
Education
Bachelor of Science in Accounting, Pennsylvania State University,
University Park, PA
Contact this candidate