Project Manager Sales

Marcella A. Cole

*** ******** **** ******, ******* 30269 770-***-****

abms5b@r.postjobfree.com

Accountant / Business Analyst / Compliance Auditor

Conscientious and reliable accountant and business analyst. Bachelor's in

computer information systems; completing a bachelor's in accounting in

spring 2010 (core curriculum is complete). Pursuing CPA certification.

Quick learner. Strong work ethic. Great attention to detail. Excellent

leadership and communication skills. Proven ability to plan and organize to

achieve goals. Core competencies include:

. Accounting: Demonstrated ability to bridge the gap between IT and

accounting. Proven success in data analysis and data mining. Familiar

with GAAP, GAAS, PCAOB, AICPA and SOX. At BellSouth, for instance, served

as the liaison between finance and accounting and the contract management

group; provided trend analysis of E-rate checks. Ensured that the

Universal Service Fund (USF) grants were applied to the correct telecomm

service.

. Business analysis: Proven expertise in systems and data analysis to

include requirement gathering, testing, documentation and deployment.

Responsible for revenue and account mapping. After AT&T acquired

Bellsouth, part of a seven member team who managed and grouped 750K

customers into sales segments. Processed field requests for customer

transition submitted through SWIMS and maintained a monthly 95%

completion rate.

. Compliance and corporate tax returns: Possess strong attention to detail

in the examination and auditing of corporate and estimated tax returns.

As a tax examiner at the Georgia Department of Revenue, part of team that

audited S and C corporations' tax returns and ensured that tax credits

and deductions were legitimate. At MCI, conducted multiple phases of

testing to ensure that all hardware and software was Y2K compliant.

Professional Experience

April 2006 - August 2009 AT&T (as a consultant through MD&E)

Atlanta, Georgia

Sales Operations Team Lead

. Performed account assignment and revenue tracking functions in the SAART

database (an AT&T system that deals with compensation). One of seven

specialists who reconciled commissions; I was responsible for the largest

group. Ensured that 270 account executives (AE's) in nine southeastern

states were compensated correctly.

. Key member of the seven member team who managed and grouped 750K

customers into different sales segments after the AT&T acquisition.

. Served as subject matter expert (SME) for the customer regarding their

data, data structures and data flow between the customized systems.

. Researched accounts to determine the appropriate customer hierarchy

utilizing tools such as Dunn and Bradstreet, Hoover's, customer websites

and documents provided by the sales department.

. Defined data strategies that solved critical business problems resulting

in IT system changes for key tools including Siebel and other customized

sales tools that track channel and territory results.

. Performed ad-hoc analysis and developed reports of customer data for

field sales team using Siebel Analytics.

. Processed field requests for customer transition submitted through SWIMS,

and maintained a monthly 95% completion rate.

March 2003 - March 2006 Bellsouth Atlanta, Georgia

Application System Analyst (BIOS)

. Extracted and provided timely status workflow reports for the DSG Call

Center.

. Identified, analyzed and tracked trends of day-to-day call center

operations; noted cause-and-effect of abnormal activities, resolved

variances and reported findings to senior management (SOEG, CRM, SOCS,

JJBOS, NMS).

. Performed ad-hoc analysis and generated daily, weekly and monthly reports

as requested by senior management.

. Maintained (WFA/C) queries for the DSG/call center. Investigated,

documented and reported system errors and data inconsistencies.

. Performed data reconciliation operations by executing web applications

via Win runner 7.x.

Database Analyst (LB)

. Managed the Universal Service Fund (USF) Access database; generated

reports for The Schools and Libraries Program. Performed daily server

backup and administration.

. Developed weekly regional progress reports by state, of Grids (Form 474

Bellsouth form used to invoice the SLD for E-rate discounts given) and

BEARS (Billing Entity Applicant Reimbursement Form); submitted for USF

Funding Year 2003 benefits. Reconciled and posted reports to the sales

information website.

. Developed, designed and implemented improvements and enhancements to the

USF database using for extracting, transforming, cleaning and loading

data feeds received from the SLD into the USF funding databases.

. Provided trend analysis of E-rate checks; determined key measurement

impact based on data collected and compiled by team members each month

(CBR / BOCRIS integrity).

. Provided level II production support and served as liaison to finance,

accounting and contract management group.

. Ensured that schools in rural areas are applying for Federal USF funding,

which helped increase our revenues.

June 1998 - August 2002 MCI WorldCom Atlanta, Georgia

Project Manager / Developer

. Worked closely with the project director in identifying necessary

resources for strategic development and business planning, focusing on

how best to implement and integrate new systems into their environment.

. Designed, developed and implemented the FRAD (Fraud Reporting Application

Database) web-based application developed in SQL Server 2000, JavaScript,

VBScript and HTML.

. Developed password-protected administration module using Microsoft

Access.

. Responsible for weekly wireless fraud reports utilizing SQL.

. Participated in a major conversion and migration of the legacy billing to

the Amdocs' Ensemble billing system involving over 40,000 customers with

monthly revenue totaling $25 million.

. Wrote and executed test plans including regression testing for Y2K.

Software Systems Engineer

. Managed software development life cycle (SDLC) from business requirements

phase through deployment.

. Analyzed and defined systems requirements; executed system reviews,

inspections and walkthroughs.

. Developed, implemented and tested disaster recovery plan for Network

Desktop Services (nDS).

. Responsible for daily maintenance of the nDS system; this includes weekly

NT server backup and administration.

July 1988 - May 1998 Georgia Department of Revenue Atlanta, Georgia

Tax Examiner

. Examined and audited estimated and corporate tax returns to determine

correct state tax liabilities. Reviewed 2000 to 2500 companies per year.

. Conducted examinations relating to compliance with technical requirements

imposed by the State Revenue Code.

. Assisted taxpayers by helping them understand and meet their tax

responsibilities and by applying the state tax law with integrity and

fairness to all.

. Assisted customers in filing corporate tax returns and estimated taxes;

answered questions on tax law.

Education and Professional Development

B.B.A., Accounting Georgia State University Atlanta, Georgia

expected completion Spring 2010

B.B.A., Computer Information Systems Georgia State University

Atlanta, Georgia 1997

Professional Development

Certificate - Database Management Southern State University

Marietta, Georgia

WorldCom University Knowledge Services

Certificates in Oracle Database Administration, JavaScript Programming,

Unix Shell Scripting, Unix Programming, SQL Programming and Project

Management

Honors

Georgia State University Atlanta, Georgia Dean's list school year

Royal Society of Arts Pitmans College London, England

Certificate of Honor

Annie Walsh Memorial School Freetown, Sierra Leone Orange Belt

(similar to honor role)

Key Words / Glossary

GAAP, Generally Accepted Accounting Principles

GAAS, Generally Accepted Auditing Standards

PCAOB, Public Company Accounting Oversight Board

AICPA, American Institute of Certified Public Accountants

SOX, Sarbanes-Oxley Act of 2002

Contact this candidate