Professional info​:
 

Result-focused, 4-year degree, quality-driven Reports and Data Analyst with extensive experience in financial modeling, creating and implementing sound business solutions.  Industries served include U.S. government, manufacturing, distribution, nonprofit, marketing, finance, and telecom.  Works with all levels of management and peers with the ability to change, and effectively do my part to get the job done right.  Provide support, documentation and training.  Highly skilled in MS Access custom software development for process improvements with a background encompassing:
 
CORE SUMMARY:
 Power-User Microsoft Applications | Web-based front-back-end Interfaces | Graph Financial Information Pivot Tables | Normalization & relationships of Data Analysis | ODBC or SQL Server Client/Server Transfer Macros and VBA for Access | Front-back-end Interfaces | Process Improvements | SharePoint Document Libraries, Lists and Views | Design | Workflows, Web Parts and Site Developer | Schema Outline and Objects Design
SHARE 
SKILLS

  • Microsoft Word

  • Microsoft Access

  • Microsoft Excel

  • Microsoft PowerPoint

  • Microsoft Outlook

  • Microsoft Publisher

  • Microsoft Project

  • Social Media

EXPERTISE
  • Project Management

  • Process Improvement

  • System Maintenance

  • Strategy Identification

  • Consulting

  • Software Support

  • Issue Resolution

  • Customer Service

  • Conducting Meetings

  • Time Management

  • Team Orientation

  • Software Training

  • Employee Evaluations

EDUCATION & TRAINING​:
:
Notre Dame of Maryland University
  • Bachelor of Arts in Business; Concentration in Accounting
  • Virtual Training Online University, Certifications & Continuing Education
  • Ability to obtain Secret Security Clearance
 
Web based Interfaces Skills​
  • Administrator - SharePoint 07-2010: Configuration, Lists, Libraries, Views, Tables. Work flows
  • Developer - MS Access: Online Analytical and Transaction Programming (OLAP) & (OLTP)
  • Designer - Object Oriented Programming (OOP) and normalization and data modeling
  • Database Manager - Relational database objects including: tables, views, forms, reports, macros, and modules
  • Power User - Microsoft Office, Enterprise Edition   
.

2010 - present

2010 - present

Work History:​
Synergy Access Inc., / Access Developer/Data & Reports Analytics / Alexandria, VA                         Present
                                                             
Data and Reports Analyst Project driven tasks for Human Resource Management System (HRMS)
  •  
  • Designed and developed from-the-ground-up a full-cycle prototype HMS catering to the needs of small to  medium-size companies. Features include: Employee Data Management; Job Opening Management;  Applicants Management; Employee Training; Database Management; Project Management; Documents Management  
  • Migration of Access database to higher more robust platform while designing automated reporting processes
  • Creation, maintenance, support of MS Access applications that help drive business processes and decisions
  • Supporting environments to include front and back-end Object Oriented Programming (OOP) to include migration into SharePoint 2007-2010 web base interface.
 
Volunteer
Foundation for Successful Solutions / Volunteer / Washington, DC  Present                                                
 
  • Partnering with talented professionals to provide solutions for success to traditionally underserved/disadvantaged
  • Providing enhanced coaching communication, and leadership skills for both personal and professional growth
  • Fostered the next generation to literacy by helping to become avid readers while serving as role model
 
 
MS Access Developer
United States Naval Air Command (NAVAIR) / MS Access Developer / Washington DC                    2012
 
  • Project driven tasks for Security Professional Education Database (SPēD)
  • Independently migrated data from Excel spreadsheets and designed a new database system
  • Spear-headed initiative to track, monitor, and report employee education and certification status by designing (SPēD) which streamlined processes by 70% compared to previous approach
  • Gathered requirements and wrote technical specifications to produce an optimal and sustainable application; Automated (SPēD) reports to track and monitor percentage of certification requirements (met and not met) by enterprise, business unit, department, employee and tier level
  • Presented scalability in the application to allow multiple users to edit the same data without collisions 
 
 
MS Access Developer
United States Coast Guard (USCG) / MS Access Developer / Washington DC  2011                            
  • Project driven tasks for Resource Education Quota Build Database (REQBD)  
  • Led efforts to track cost of coursework quota requirements for active and inactive military personnel by developing   the REQBD coupled with support and training on new system for end users
  • Defined queries to calculate cost of coursework quotas by business unit, department, students, and instructors
  • Assisted and administered helpful updates to SharePoint web portal, which increased customer volume by 40%
  • Developed new innovative processes to track change request approval work-flows cutting time from weeks to days
 
Data and Reports Analyst
United Stated Security Exchange Commission (SEC) / Data Analyst / Washington DC                      2010
 
  • Insured integrity and accuracy of SEC payroll data manipulation, extraction, storage, and analysis
  • Provided management with on-demand ad hoc reports used to assist in long and short-term budgeting and planning
  • Successfully reported solutions using Hyperion Planning Application Programming Interface (API) interfaced with  MS Access database processes; Reporting efficiency gained 40% from previous reports generation
Program Analyst
United States Department of Agriculture (USDA) / Program Analyst  / Washington DC                 2009
  • Directed state agencies and prime recipients who received federal grants regarding guidelines, policies and procedures for special reporting requirements of the American Recovery and Reinvestment Act of 2009 (ARRA)
  • Ensured compliance of state agency’s reported ARRA dollars with an unprecedented level of transparency and accountability governed  by U.S. Government Accountability Office (GAO) allocated and tracked tax dollars spent
  • Allocated, reconciled, and monitored a total budget of $500 million in grant programs and $100 million established to improve or administer Management Information Systems (MIS);  Included changes necessary to meet new legislative and regulatory requirements set forth by Office of Management and Budget (OMB)
  • Developed web-based application, and process using SharePoint Services as a front-end data collection tool interfaced with MS Access back-end tables; The system conducted real time updates of detailed and summary reports resulting in increased efficiency and accuracy and saved 95% in man-hours
MS Access Developer - Business Analyst
The Coca-Cola Company / IT Business Analyst /MS Access Developer / Atlanta GA                          2008
  • Project driven tasks for Total Executive Compensation Database (TECD)Designed and developed TECD, which ultimately led to cost savings of $55,000 per year
  • Created automated reports to summarize merit increases, annual incentives, and stock equity programs along with compensation for all executives, which provided Coke’s Compensation Committee and Board of Directors with a concise view of each executive’s proposed compensation; timely reporting enabled managers to quickly review the recommended compensation award resulting in increased internal and external client satisfaction
 
 
Financial, Data and Reports Analyst / MS Access Developer
Ameritech/SBC Communications Inc. / Financial Analyst / MS Access Developer / Alexandria VA    2000 - 2007                                                                                                   
  • Established new technology-based solution that captured activity for 30 call centers; solution calculated results metrics to determine measurements in the time/cost for each call handled relational to products, services and customers  driving the call volume, by state, region, and profit center; cost-per-hire expenses fell 35% reduced year-over-year
  • Mapped and aligned budget codes of both parent and subsidiary company; increased accuracy rates by 80%
  • Unraveled long-standing problem by taking the initiative to write procedures for newly developed system  
  • Met all monthly deadlines under tight time constraints reported re-classed, journal entries, and account analysis

 

© 2020 ~ Designed and Developed by PATRICE CONNOLLY a professional who will proudly represent your efforts...