Sales Data
Resume:
Cindy Corcoran
*** ******* ***** ** ****** (*19)
Durham NC 27712
**************@*****.***
Focus
Dynamic systems professional with over fifteen years experience working in
a fast paced, complex global environment with an emphasis on data and
financial analysis. Focused on improving the quality of data and making it
readily accessible in a clear, meaningful format.
Core Competencies
Creative SQL and Report Writer Exploit MS Excel Functionality
Innovative Problem Solver
Effective Process Improver Provide Excellent Customer Support
Persuasive Negotiator
Skilled Data Analyst Investigate Root Causes
Competent Financial Analyst
Experience Summary
As a proven self-starter, adapts to a constantly changing environment.
Provides on-going support to finance and sales teams by reporting results
from multiple repositories using MS Excel, MS Access, Business Objects, and
SQL. Analyzes trends and metrics, scrutinizes results, identifies
variances, recommends solutions, and uncovers root cause issues. Supports
the business by providing expertise, training, and instruction. Finds
innovative ways to improve system and process efficiency, accuracy, and
data integrity.
Professional Profile
Professional Profile
Anticipates and delivers results in large scale, complex projects.
Effectively partners with cross functional teams by bringing sound
understanding of the intricacies and interdependencies of data. Meets
deliverables, communicates change, prioritizes assignments and multi-tasks
in fast paced, challenging environments. Elicits customer needs and
translates them into technical specifications, develops and implements
effective system controls and procedures, documents sound test cases,
analyzes results and makes adjustments as necessary. Creates clear and
understandable training documentation, provides excellent on-going customer
service support, resolves production issues and control weaknesses.
With determination completes assignments effectively and diligently.
Adaptable to changing business needs while retaining focus on overall
objective. Aims to learn new techniques and gather ideas to understand and
develop improved business solutions. Personable team member who values and
respects others, honors deadlines and commitments, performs with integrity
to influence change in the pursuit of common goals.
Formulates innovative solutions using limited resources. Uncovers and
resolves root cause issues. Automates manual work and develops solutions
that increase efficiency. Adeptly leverages existing technology and
expertise in order to accomplish goals. Constantly evaluates existing
functionality looking for ways to improve system or process efficiency.
Professional Experience
Proof of Performance and Achievement Highlights:
Skills Building (2009-Present)
> Developed a small MS Access 2007 database.
> Created Business Intelligence reports using some of MS Excel 2007 new
functions, formulas and macros.
Nortel Networks, Research Triangle Park, NC (1994-2009)
Callidus Implementation and Support - Global Sales Compensation Systems
Analyst (2007-2009)
> Created data maps that were used as the model for the database design
of the Extract, Transform and Load (ETL) for the Sales Compensation
System, Callidus. Worked extensively with the developer on the
conceptual and physical data model for the entire ETL process.
> Gathered, validated and documented the data requirements for the ETL
design and performance of the Callidus Sales Compensation System which
successfully implemented a complete system replacement in 4 months.
> Liaised between the business user group and the technical team for
capturing requirements and interface analysis. Created the "as is"
and "to be" processes for the ETL.
> Designed multiple interface files for Callidus down to the column
level for data modeling. Encompassed the feed creation, timing,
validation, reconciliation, documentation, error handling, root cause
analysis, issue resolution, modifications, training and data
profiling.
> Developed an innovative way to combine thousands of direct and
indirect customer records using the master data in two different
databases into one hierarchy which enabled the data to be
standardized, enriched and more usable for sales compensation.
> Working without data models, designed and extracted critical
information from the database. This data was used by the analysts in
lieu of system-generated reports. Created a Brio report that was used
in lieu of the complex revenue recognition feed.
> Transferred knowledge and trained other members of the team and
business users.
Legacy System Enhancement and Support - Global Sales Compensation Systems
Analyst (2004-2007)
> Automated manual processes, revised and updated feed functionality and
documentation. Eliminated obsolete and redundant data, rescheduled
and re-sequenced job execution by enhancing the existing metadata
rules. Archived millions of records, indexed key fields, reworked
view and snapshot table requirements.
> Worked with code developers and database administrators to create SQL
queries that allowed independent analysis and troubleshooting of
system functionality, ease of use for routine requests to insert,
modify and delete data.
> Reworked and updated the extract conditions for the feeds sourced from
the Global Data Warehouse.
> Continually examined existing business processes for ways to increase
efficiency.
> Revised Sarbanes-Oxley processes for inbound feeds.
> Created, maintained, revised Business Objects reports for the inbound
data.
SAP Implementation and Support - Revenue Recognition Business Analyst (2003-
2004)
> Served as a Super User for Revenue Recognition during a global SAP
implementation. Accountable for the design execution, the fulfillment
of end-user requirements, testing, training and documentation.
Partnered with cross-functional organizations including Order
Management, Logistics, Product Line Finance, Compliance, Services,
Repair, and Control Finance to facilitate system and process
modification. Coordinated system requirements with IT department.
> Defined business goals, identified capabilities, indicated gaps and
control weaknesses for SAP releases. Designed, developed and
documented procedures and ensured all deliverables were on-time and
accurate and that no other organizational requirements were adversely
effected.
Business Process Prime - Revenue Recognition Business Analyst (2000-2003)
> Part of the Change Management Team that developed change control
methodologies by identifying change and how they would be regulated
and managed for the existing ERP system and the adherence to GAAP.
> Communicated ERP design solutions for current releases to the user
community. Addressed the nature of the change and the impact it would
have on the business operation
> Facilitated a process-driven business workshop with 60 attendees,
prepared agendas, created presentations, acquired executive support,
motivated peers, coordinated speakers, and assigned tasks.
BaaN Implementation and Support - Recognition Business Analyst (1998-2000)
> Revenue Recognition Subject Matter Expert for the optical business,
responsible for the implementation of Baan which increased in sales
from $250 million to $2 billion in that year.
> Produced and incorporated various MS Access queries supporting the on-
going operation and creating the ad hoc reports used for analysis.
> Advised customers by providing guidance, resolving issues and
training towards self-sufficiency. Continued to support operations
during month-end, quarter-end and year-end close processes.
Various Nortel Positions in Finance (1994-1998)
Education
. Master of Science in Business Administration - Boston University, 1993
. Bachelor of Science Computer Information Systems - NC Wesleyan College,
1991
. Associate in Applied Science Electronic Systems Technology - Community
College of the United States Air Force, 1988
Technical Skills
MS Office Oracle databases SQL queries Business Objects
Reporting
Brio Reporting MS Excel Business Intelligence Reporting MS
Access databases
Advanced MS Excel Oracle General Ledger
Contact this candidate