Data Analyst Database Developer

Dear Sir/Madam,

Please accept this cover letter as an introduction of myself and my personal resume. I am an individual who upholds ethical work habits while maintaining job responsibilities. Though I have experience working with various systems, processes, and programming languages, I seek to improve my knowledge and skills within your organization. As a professional in the IT industry for over 15 years, it is my personal duty and responsibility to learn the standards of the organization I work with. Therefore, I offer you my undying motivation, my thrive to succeed, my commitment towards ethical work practices, and my ability to amplify my career opportunities within your organization. I am eager to learn new skills and become more knowledgeable while working with the professionals associated with your organization.

I own the acquired skills to utilized current computer technology and peripherals to perform a variety of duties within the IT Industry including programming and systems analysis. In turn, you will receive unique talents from an individual who conveys a positive image of himself and his employer through excellent communications skills, independent decision making and a high level of professionalism. I look forward to your reply.

Thank you.

Lance Broderick

SUMMARY

Systems Analyst, Database Developer, Application Support Programmer for multiple industries, responsible for the development, deployment and maintenance of several databases using Microsoft Access, Excel, InfoPath, Oracle, MS Office, Office 365, SharePoint, VBA code, SQL and VBScripts. Experience includes working 15 years encompassing Information Technology, educated with a Bachelor degree in IT and a Master of Education degree in Instructional Technology; utilized for developing new strategies and techniques as projects needs become more complex and specialized. Currently studying Tableau, Python 2.7.13 and BI information related to SSIS, SSAS, and SSRS.

EXPERIENCE

7/2021 – 10/2022

Business Systems Analyst, Tang & Company

Create and track business requirements using Jira and Confluence, share with other team members and submit tickets to programming/engineering in Jira tasks.

Create full spectrum projects in Confluence requiring business requirement document to include scope, summary, stake holders, project road map, project notes, business requirements, functional requirements, assumptions, creating watch lists and other functions available within the application. Data is analyzed via SQL.

Working in the medical services sector, I interface with Operations, Billing, IT, and Operational Excellence to review, assess, analyze current business systems, and suggest improvements. Maintain business requirement documents (BRD) to document changes or new processes that need to take place. Act as acting technical project manager to oversee the direction of bringing new systems online.

Design SharePoint forms via PowerApps, utilize SQL Server and automate certain reports to reduce workloads throughout several departments.

Utilize additional tools such as Power BI for dashboard reports linked to external sources such as SQL Server or stand-alone excel files.

1/2021 – 6/2021

Database Developer, Appworth Data Management – contactor, part time

Troubleshoot computer issues and database systems consisting of MS Access, SQL (SSMS), Forthshift, and DB files.

Develop QA and six sigma databases for product workflow improvement process.

Link all departments from sales, raw material, production, and shipping department.

Provide daily on-time delivery reports as well as weekly and monthly updates.

1/2020 – 1/2021

Medical disability during 2020

9/2017 – 12/2019

Business Analyst, Vincent Benjamin (Contractor), Kaiser Employee Conversion Worked with Kaiser Permanente in Rancho Cucamonga working in Accounting/Claims department to automate accounting processes and automated email notifications.

Review current systems and utilize Access, Excel and PeopleSoft to import, export, convert file formats, and make reports available in central locations including SharePoint.

Assist with closing books for month-end to assure payroll, expenses, and journal entries are reconciled.

Used Tableau to upload Excel or other flat files to build dashboard reports to showcase status of projects, amounts and dates of overtime and expenses.

6/2015 – 5/2017

Application Support Programmer, Film LA, Hollywood, CA

Work as an MS Access, MS Excel, MySQL, database developer and VBA programmer for entertainment industry regarding the filming permits.

Apply code to current databases and apply enhancements where needed with downloads from Office 365 and application installations.

Adopt programming techniques from previous developers to maintain functionality and consistency in operational databases.

Apply external methods to database applications such as automated email notifications.

Generate reports and check accuracy for submission to internal and external customers as well as various city council districts.

Monitor helpdesk tickets via SysAid and assign/reassign responsibilities as pertains to work orders.

Provide City Council reports as requested as information can be shared publicly on various media formats.

9/2006 – 6/2015

Systems Analyst II, WorleyParsons, Arcadia, CA

Worked as a database administrator/VBA programmer at WorleyParsons for various project including AFG Program, BP Projects, Liberty, SAMREF, Conoco Phillips, and Point Thomson.

Develop and maintain MS Access, SharePoint, and SQL Server databases and MS Excel spreadsheet for formal review action items, lessons learned, overtime requests, and interface management.

Used programming languages that include VBA, C#, .NET, Batch Scripts, HTML, and SQL to create customized programs depending on project purposes.

Create routines and procedures for utilizing SharePoint in database applications.

Create/Program Databases – Create MS Access Databases to track progress of construction, design and procurement of internal and external interfaces.

Create company wide recognition input forms with InfoPath, capture data with SharePoint, and designed InfoPath reports for multi-user environment for Employee Recognition Project.

Maintenance and Improvements – Modify and regression test MS Access databases for use to track design interfaces and formal design reviews.

Assure data is updated and accurate by utilizing proactive work ethics.

Maintain document library and lists on SharePoint sites for easy retrieval and review.

Work closely with IM department to assure hardware and software conflicts are identified and resolved before deployment of new databases.

Supervise and guide others as they offer support to the development of systems on various projects.

Additional duties include photographing materials to determine composition and corrosive breakdown.

Photographer for individuals and locations for use in company/project newsletters and digital image editing using Adobe Photoshop.

Assist HSE for explosion proof tablets and cameras and other intrinsically safe equipment. Research ballistic protection for refinery explosions.

2004 - 2006

Data Analyst/Data Conversions, San Bernardino, CA, Olympic Staffing

Project placement at various companies, including San Bernardino City Unified School District and Lewis Homes, to carry out planned processes during new implementation phases using SAP and JD Edwards

These phases include the responsibilities of training newer staff members and reporting findings consisting of miss allocated funds affecting future budgets.

Utilize resources to track funds and assets to establish new protocols for improved accountability with soul usage of MS Excel.

2004 - 2005

Financial Aid Advisor, Westwood College, Ontario, CA

Held workshops for new college students and their parents to explain the details regarding federal and state financial aid funding for educational purposes.

Mentored students on their artistic creations (pencil drawings, computer graphics, and 3D models).

Coached students on the pursuit of their artistic dreams by providing resources and realistic expectations. Enrolling students by utilizing my abilities of persuasion through encouragement and instilling reachable goals.

1999 - 2004

Financial Aid Advisor, University of Phoenix, Ontario, CA

Educated adult students on the utilization of their federal financial aid benefits.

Maintained accounts for approximately 280 students.

Made collection calls when students’ balances were not cover by financial aid funds.

Maintained company account receivable goals by adhering to internal policies.

1997 - 1999

Accounts Receivables-Accounting Coordinator

Post and deposit checks for title insurance and county recordings via AS/400 Great Plains.

Verified accuracy of billings, payments, and deposits.

Researched credits and debits and refunded where applicable.

Record, post and update real estate tax refunds via MS Excel.

EDUCATION

Master of Education, Instructional Technology, American Intercontinental University, Hoffman Estates, ILL

Bachelor of Science, Information Technology, University of Phoenix, Ontario, CA

SPECIFIC TECHNICAL EXPERTISE/SPECIALIST COURSES

Certified in First Aid/CPR/AED by American Red Cross (up for renewal), Expert/Certificate MS Access, Expert/Certificate MS Word, Expert/Certificate MS Excel, Expert/Certificate MS PowerPoint, Expert/Certificate MS Outlook, GOC.Net Database course, Python 2.7.13, MS SharePoint, Office 365, MySQL, SQLYog UI, MySQL, SQL Server 2008 & 2012.

Contact this candidate