Database Administrator Quality Assurance
Resume:
Joseph J. Mauras
Pottstown, PA
Phone: 610-***-****
Email: *********@*****.***
PROFESSIONAL EXPERIENCE
Database Administrator Aug 2014 – Jul 2024
Gallagher Fluid Seals, Inc King of Prussia, PA
Experienced Database Administrator with 10 years of expertise in managing and optimizing complex database systems, ensuring high availability and performance.
SQL Programming: Strong skills in writing complex SQL queries for data manipulation, analysis, and reporting.
Data Integrity: Implemented quality assurance processes to ensure data accuracy and consistency across multiple sources. Proven expertise in ensuring data integrity and delivering actionable insights to drive business decisions.
Data Analysis Tools: Proficient in [e.g., SQL, Power BI, SSRS, Excel, Salesforce] for data extraction, transformation, and visualization. Excel: Advanced skills in Excel, including pivot tables, VLOOKUP, VBA, macros, and data visualization techniques.
Developed and maintained interactive dashboards in SSRS, Power BI and Salesforce enabling real-time data analysis and decision-making for key stakeholders.
Scripting and Automation: Proficient in scripting languages for automating database tasks and maintenance.
Security Management: Experience in enforcing security policies, user access controls, and data encryption techniques.
Led multiple projects to consolidate databases during acquisitions, resulting in reduction in overhead and improved data accessibility across multiple companies.
Collaborated with companywide departments to design database solutions and reporting requirements.
Executive Recruiter Oct 2012 – Sep 2013
The Mergis Group, A Randstad Company King of Prussia, PA
Ran a full desk in where primarily responsibilities were to acquire and develop client relationships as well as source and recognize Executive Level candidates in Finance and Accounting including degreed accountants to CEOs.
Responsible for identifying Executive Level candidates for various industries including Manufacturing, Financial Services, IT, Healthcare, Pharmaceuticals, Public Accounting, etc.
Performed marketing efforts through various means including social media, cold calls, ad calls client visits and networking events.
Advanced user in LinkedIn (currently connected to 2400+ unique users) and advanced knowledge in the LinkedIn Recruiter Module.
Acted as a liaison between clients and candidates.
Responsible for candidate interviews, preparation and offer proposals and negotiations.
Payroll Supervisor Feb 2011 – Oct 2012
New Penn Financial, LLC Plymouth Meeting, PA
Responsible for the biweekly processing, accuracy and integrity of 4 multistate payrolls in the mortgage industry using ADP’s Workforce Now and HRB.
Responsible for the complete overhaul of payroll policies, procedures and reporting capabilities.
Directed Payroll Specialist and Human Resource Admin in their contributions to payroll processing while suggesting and implementing procedures to make the process easier and more efficient.
Coordinated with the accounting department in many aspects including the balancing of payroll expenses, commission, commission overtime calculation and accuracy.
Acted as a liaison between employees and numerous benefit representatives.
Worked closely with ADP sales and implementation representatives to continually explore and implement their newest services to the company’s advantage.
Responsible for the reporting of payroll activity to division managers, CFO and CEO/President.
Reported and collaborated directly with the Vice President of Human Resources.
Senior Accountant / Payroll Administrator May 2008 – Feb 2011
Medcomp / Martech Medical / Point Medical / Jet Medical Harleysville, PA
Worked closely with Controller and Human Resources Manager with financial and payroll matters.
Performed tasks as an accountant for four company locations which includes compiling financial statements, analyzing and maintaining general ledger accounts, performing monthly and year-end closes, account and bank reconciliations, preparing and submitting tax forms, managing accounts payable and accounts receivable, and ensuring accuracy and integrity of said financial information.
Directed all aspects of payroll for three company locations for over 600 interstate employees processed semi-monthly.
Processed documents relating to wage assignments, employee acquisitions/terminations, 401(k), performance evaluations, insurance benefits, commissions, direct deposits and vacation accruals.
Responsible for the total reform of the company’s payroll process ultimately maximizing efficiency.
Wrote the company’s procedures for the accounts payable, receivable and payroll processes.
Staff Accountant / Network Administrator June 2006 – May 2008
VideoRay, LLC Phoenixville, PA
Performed complex and specialized work related to the preparation, processing, and maintenance of payroll handled through ADP.
Solely responsible for day to day accounting activities in QuickBooks including accounts payable, accounts receivable, and bank reconciliations.
Performed monthly book closing and account analysis.
Verified integrity of journal entries and general ledger accounts.
Reconciled accounts and performed projections of company performance.
Addressed a complexity of customer and vendor issues requiring immediate attention.
Executed data entry, order processing functions, generating sales orders and packing lists.
Documented and distributed all financial matters for management.
Administered and maintained business network through the use of Microsoft Small Business Server 2003 and Microsoft Exchange.
Maintained company phone network using Asterisk and trixbox.
EDUCATION
East Stroudsburg University Graduation Date: August 2006
Bachelor of Arts in Business Management with concentration in Accounting, Computer Science Minor
COMPUTER SKILLS
Microsoft: Excel, Word, PowerPoint, Access, Outlook
Programming Languages: SQL, VBA, Python
Accounting/Payroll Software: ADP (various versions), SAP, Evo, Mapics, Mapics XA, FRX, Peachtree
Social Media/Recruiting: LinkedIn, LinkedIn Recruiter Module, CareerBuilder, Monster, Indeed
Proficient in building PCs and troubleshooting hardware and software.
Contact this candidate