top of page
PATRICE CONNOLLY
Professional info:
Results-focused four degree, quality-driven Reports and Data Analyst with extensive experience in financial modeling, creating and implementing sound business solutions. Industries served to 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:
KEY WORDS:
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
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:
F-35 Strike Fighter Lightning II., /Joint Program Office (JPO) / Enterprise Senior Data Analyst Crystal City / VA Present
-
Data and Model Owners and users across the Bank -- Strategic/Operational
-
Model Validation external vendors, Data Governance networks -- operational/tactical
-
Compliance -- strategic/operational
-
Collaborate with business stakeholders to develop and document policies and procedures surrounding Data Governance
-
Develop best practices, standards, and methodologies to assist in the implementation and execution of Data Governance
-
Lead the Data Governance Committee, recruit data stewards from the lines of business and departments, and work with them to ensure data standards across the organization
-
Determine the rules and workflows that define and monitor the process of creating, modifying, storing, and deleting data for the Master Data Solution and audit data to ensure it is under the Master Data Governance program
-
Develop and deliver management dashboards that describe the state of master data health across the company
-
Build and maintain Enterprise Data Dictionary
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-based 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 a 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 the previous approach
-
Gathered requirements and wrote technical specifications to produce an optimal and sustainable application; Automated (SPēD) reports to track and monitor the percentage of certification requirements (met and not met) by the 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 the cost of coursework quotas by business unit, department, students, and instructors
-
Assisted and administered helpful updates to the 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 States 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 the 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 the newly developed system
-
Met all monthly deadlines under tight time constraints reported re-classed, journal entries, and account analysis
bottom of page