Sandra Agolia

314-***-****

ad0zkw@r.postjobfree.com

PROFESSIONAL SUMMARY

Results-oriented leader with excellent leadership and analytical skills, recognized for superior customer and stakeholder orientation

20+ years of IT experience, 13+ years consulting in Telecommunications Industry

Proven track record in project and program management with extensive experience in the management, defect management, implementation management, environment management and reporting utilizing Excel and other Microsoft tools.

Experience in presenting issues and solutions in a clear and concise manner to a variety of audiences (Senior management, executive management, technical / non-technical)

Managed complex customer and vendor relationships

Proven ability to lead, motivate, mentor, and train project teams

Experience in performing across traditional functional organizations to define business processes and deliver new initiatives.

Hands on experience with all areas of CMM Methodologies

PROFESSIONAL EXPERIENCE

US Cellular August 2012

Consultant – Defect Manager Chicago, Illinois

Managed and coordinated defects for testing, development, and infrastructure for System Test and User Acceptance Test phases.

Prioritized and assigned defects, tracked status through closure, and oversaw retesting to ensure corrections were successfully completed.

Amdocs Systems Integration

Project Lead

04/01 to Present

Clients

ATT Lightspeed, ATT Yellow Pages, CMM Quality Engineer, Sprint, RCC, DexOne

Projects Summary:

Feb 2010 – March 2012

Artifact Management for AT&T client

Work with management on new database systems

Reports for management on approvals missing from database system for artifacts delivered

Extract non-approval report for client for escalation

Extract and post Scope files

Extract and post IPP file

Follow-up with non-approvers for OMS internally, Telegence internal & external

Nov 2010 – Feb 2010

Work hours Time Management

Skills Management

Sept 2010 – Nov 2010

System Test GL for DexOne account

System Test and UAT reports for Management

System Test and UAT defect management

July 2010 – Sept 2010

Work hours Time Management SI

Skills Management for SI

March 2007- Jan 2010

Defect Management Lead for AT&T Lightspeed

Management and Defect Coordination of ST, UAT, CRT and VRT for Sprint, RCC, AT&T Yellow Page and AT&T Lightspeed

Database and data management for wireless telecommunications Customer Care and Billing software system.

January 2006 – March 2007

CMM Level 3 for Infrastructure – create, maintain, support and implement the methodology for CMM

Expert in the management of Software Configuration Management (SCM) lifecycle for a development cycle of versions.

April 2001 – March 2007

Responsible for CR and IA review with development teams in order to ensure database changes are managed correctly, effectively and efficiently.

Responsible for management of internal source code builds, database patches and refreshing environments with most recent code.

Environment and data coordination for AT&T Yellow Pages and Sprint

Effectively managed issues, risks and presented contingency plan with pros and cons

Managed execution of war rooms on client site

Accomplishments

Creation of Corporate Methodology for Infrastructure to be used as the baseline for all infrastructure groups worldwide.

Creation of project plans for division accounts to maintain tailored methodology based on CMM Level 3 requirements, goals and activities

Internal and External Client management of delivery and implementation of the software and data changes in the customer’s environment from Acceptance Testing through production go-live.

Initiated the training plans for the division in order to ensure all employees were receiving the training to enhance their abilities.

Implementation of Action Base as a tool for meeting minutes and open items

Aug 1996 – March 2001 The M/A/R/C Group – Targetbase Division

Mar. 2001 Dallas, Texas

Database Manager

Clients

Honda

Acura

Coke

Thomasville Furniture

Glaxo/SmithKlien Pharmaceutical

Nestle Baby Formula

Sony

Key Projects Summary: Managed the marketing of multiple clients based on requirements the client utilizing multiple systems and software.

Project Management of various customized marketing campaigns for client working with user end developers in project planning for in house system with a WebLogic front-end and Informatics back-end.

Responsible for project alerts via client requirements for analysis and reporting for implementation projects working with infrastructure group for hardware capacity, disk space, and usage

Provide client with customized OLAP Reporting to support analysis created in the BRIO OLAP reporting tool.

Ensure all OLAP data presentations are in compliance with data standards from a defect perspective where problems are accruing.

Work directly with DBA, developers, and Analytics Group for various data source to ensure changes made in the data system are reflected in the data presentations.

Responsible for Quality Assurance of the processes performed by Production Analysts.

Responsible for business and requirements analysis and documentation of client needs for marketing production projects and database implementation management.

Responsible for set-up of customized campaigns to provide back-end analysis to the client.

Responsible for improving/optimizing the processing methods.

Perform workload management for 7 Production Analysts.

Senior Implementation Analyst

Assisted in the creation of Business Rules, Data Model, and client customizations required to bring clients up in the ARM™ marketing database.

Verified that Business rules and customizations were correctly implemented by developers/DBAs.

Responsible for conversion and analysis of vendor data into the marketing database system via in-house customized CRM front end software.

Responsible for the kind of data that would be maintained in customer database based on data value to the marketing potential of client.

Responsible for analysis feedback meetings with client.

Trained Production Analysts on client specific customizations prior to release.

.

Group Leader - Database Production

Supervised Production Analysts working on several client accounts.

Established Quality Assurance procedures that Production Analysts used to ensure that processes met the requirements of the clients.

Responsible for training, personnel reviews, and department procedures.

.

Database Production Analyst

Performed ad-hoc procedures, based upon client specifications, to pull mail files to support directed marketing efforts.

Prepared demographic data files received from various sources to update the client database.

Accomplishments

Extra Mile Award – Relational Database Implementation (Nestle, GlaxoWellcome), 1999

President’s Award – GlaxoWellcome Implementation, 1999

Extra Mile Award – Database Production, 1998

President’s Award – Honda/Acura 1998

President’s Award - ARM™ Team New Systems Software, 1998

Jan. 1996 Southwestern Bell Mobile Systems

Mar. 1996 Dallas, Texas

Jr Programmer Analyst

Developed and maintained the Service Desk application to track production trouble tickets. This application was developed in a client/server environment utilizing Microsoft Access V2.0. Responsible for installing application throughout the company.

Developed MACC system (Market Agent Compensation Consolidation) package to track activations sold by retail firms. This application was developed in Microsoft Access V2.0.

Responsible for conversion of several SAS reports to COBOL.

Responsible for maintenance of COBOL Reports in the Message Processing System.

All COBOL applications developed in an OS/MVS environment utilizing JCL and PROCS.

Developed procedures and continued support of all Production Source code libraries.

Developed procedures for migration of code to Production.

Maintained the tracking system for trouble tickets.

All source code resided in TSO Partitioned Datasets or Panvalet libraries.

Mar. 1993 Information Retrieval Methods

Sept. 1994 Dallas, Texas

Data Control Analyst

Perform cataloging and validation of data received from American Tobacco retail sales representatives.

Monitored reports from the validation process.

Responsible for creation of procs and submission of job streams that produced coverage reports using the valid data from the editing process.

Performed customer service role, responding to inquiries regarding coverage reports.

Feb. 1983 Page Drug Stores

Sept. 1992 Dallas, Texas

Assistant Store Manager/Pharmacy Technician

Cost Expense Analysis, customer service, store security, supervision of store personnel, inventory purchasing and maintenance, merchandise promotion and display.

Supervision of business offices for Dallas and Ft. Worth facilities, all Accounts Receivables, prepare invoices for Accounts Payables, purchase orders, customer relations, operating statement, reconciliation of general ledger, billing, physicians order program, state Medicaid program, 3rd party insurance billing, collections, pharmacy tech supervisor.

Order and maintain medications required, all inventory processes, prefill regularly filled Rx’s, maintained narcotic records, compound prescriptions, refill verification with physician offices, assisted pharmacist as required and needed.

Accomplishments

Page Drug Stores Employee of the Year 1988, 1990

Contact this candidate