Systems Analyst Information Technology

Dear Hiring Manager,

I am pleased to submit to you my resume to illustrate my working experience, the depth of my knowledge and to understand how I can be a good fit for your company. I have worked as an independent contractor most of my life, and I have unique skillsets, organizational methods, technical expertise and superior customer service. Think of me not only as a systems analyst professional, but as a collaborator, observer, a team player and an agent of continuous improvement.

Let us set up some time to talk so you can discover how my distinctive perspectives, knowledge, and progressive thinking can bring additional value to your office. I am confident that my skills and experience can be integrated with your practice, making me a valuable addition to your team. I understand various systems and can facilitate, train, and collaborate with other individuals and teams.

I am enthusiastic to exercise my skills within your organization where I can contribute to the success of your projects and initiatives. I am dedicated to upholding a positive image of myself and my employer through excellent communication, independent decision-making, with a high-level of efficiency.

I look forward to your response.

Sincerely,

Lance Broderick

Summary

Serving in multiple contractor roles such as Acting Project Manager, Systems Analyst, Business Systems Analyst, Database Developer, and Application Support Programmer in energy/resources, manufacturing, healthcare, and entertainment industries.

Working with enterprise case management systems and mission-critical systems.

Developing, deploying, and maintaining databases using tools like Microsoft Access, Excel, Oracle, SharePoint, SQL Query Designer, and more.

Managing Business Requirements Documents (BRD), Functional Requirements Documents (FRD), and Technical Requirements Documents (TRD).

Gained experience with Power BI, Power Apps, Power Automate, integrating workflows, and their integration with Office 365.

Handling asset management, tracking and tagging of office equipment.

Executing all aspects of Power BI implementations, including Dataflows, Development Pipelines, Report Generation, Error Resolution, UAT, UI and UX, requirements and testing.

Familiarity with Python, SSIS, SSAS, SSRS, JavaScript, and CSS.

Managing Attorney Client case software systems such as LawMatics and Clio.

Managing online training modules with Clickview to support employee training.

Photo/Video surveillance analysis and interpretation.

Experience

11/2024 – present Intake Coordinator/Consultant, Vogel Law Offices, APC (part time)

• Interview prospective new clients, receive testimonies, and write chronology/timeline for use in court filings.

• Prepare analysis of potential legal claims.

• Conduct witness interviews, obtain statements, schedule therapy/doctor appointments for clients, coordinate depositions, arrange for service of process, and conduct skip trace services.

• Communicate with opposing counsel and court officers.

• Subject Matter Expert (SME) on legal case management software such as LawMatics and Clio.

• Research court documents and conduct legal research mainly for technical cases involving information technology.

• Review surveillance video recordings for analysis and interpretation.

3/2023 – 10/2024 Business Systems Analyst III, Contech Systems, Inc., Pompano Beach, FL

• Contracted out to Horizon Blue Cross Blue Shield of New Jersey.

• Maintain HIPPA compliance and adhere to data governance requirements.

• EDI transactional knowledge with ability to update and/or audit values: 837 and 835 transactions.

• Worked on payer and provider side of mission critical systems for Availity Provider Portal Transition Project to facilitate meetings between different departments such EDI, API, Audit team, and Enterprise Case Management Applications to troubleshoot reported errors from providers.

Review test cases with the User Acceptance Testing (UAT) team, test UI and UX requirements, manage testing system server and coordinate with developers and document issues.

• Create business requirements for project scope toward Business Requirements Document (BRD) development. Coordinate meetings with front desk reps to ensure functional requirements are also met to create Functional Requirements Document (FRD).

• Gather rules and requirements for BRDs in Agile environment using Confluence, Jira with Kanban board using ERP and other business systems/applications such as PlanView, ClearQuest and ServiceDesk.

• Filled in as acting project manager to facilitate meeting and assure Contract Lifecycle Management (CLM) strategy continued in focus and to resolve technical issues.

• Supported Fee Schedule Inquiry Module by Creating a GitHub account, React programming, and module configuration.

• Write SOP and Operation Support Plans (OSP) and present to other BSAs, developers, managers, and directors to describe details of such processes.

• Maintain SharePoint sites and shared directories and create specialized reporting using Availity Insights.

• Used Clickview as an online training module.

• Reviewed mission critical systems as Professional Risk Management Services (PRMS) during weekly status updates.

• Experience supporting IT solutions or projects related to Utilization Management, Care Management or Clinical Data Initiatives.

12/2022 – 1/2023 IS Business Systems Analyst, Intratek Computer, Inc.

• Contractor for Orange County Transit Authority (OCTA), short term fill-in assignment.

• Served as point of contact/subject matter expert (SME) for one or more business applications used for tracking and communicating information for city buses and their routes.

• Worked with command/dispatch centers to assist with backing up or imaging of main computer consoles that deal with IP addresses and bus routes.

• Work closely with Sheriff Department to assist in incidents that affect regular buses or para-transit buses and the schedules.

• Worked alongside business users and developers to identify and analyze their needs and define business requirements for new or existing systems.

7/2021 – 10/2022 Business Systems Analyst, Tang & Company, Torrance, CA

• Filled in as Acting Technical Project Manager to oversee the status of each phase of the project.

• Create and track business requirements using Jira and Confluence.

• Agile methodology to ensure mission critical systems are designed with federal, state, and local regulations and procedures.

• Focus on business process improvements to eliminate unnecessary items from the legacy system.

• Create full spectrum projects in Confluence requiring business requirement documents to include scope, summary, stake holders, project road map, project notes, and assumptions.

• Interfaced 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.

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

• Utilize additional tools such as Power BI for dashboard reports and Power Automate for report automation.

• Build requirement for UI with user stories, UX wireframe, Coordinate UAT with programmers.

• Using Microsoft Project to track status and progress of a total system rewrite.

• Tracked the business requirements, workflows, data process maps, mocks ups and technical requirements to cross reference with programmers.

• Expertise in the EPIC Medical software application (EMR, EHR) as it relates to hospital workflows and setting up the infrastructure for software implementation in a clinic environment.

1/2020 – 7/2021 Database Developer, Philatron International, Santa Fe Springs, CA

• Create mission critical database systems and user interfaces for sales, accounting, manufacturing, and shipping departments to track orders and deliveries.

• 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.

• Worked with Sales department using Salesforce for potential customer tracking and sales, and created reports as needed with backend data.

• Link all departments from sales, raw materials, production, shipping and delivery, and created automated processes for weekly and monthly reports.

9/2017 – 12/2019 Business Analyst, Vincent Benjamin, Rancho Cucamonga, CA

• Contracted out to Kaiser Permanente.

• Worked in the Accounting/Claims department to automate accounting processes and automated email notifications. Maintained data governance as critical health information needed to follow a set of guidelines to avoid HIPAA violations.

• Created a continuous improvement environment to cut down on man hours and increase productivity.

• 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.

• Used Microsoft SQL Server Management Studio to view large datasets and write queries with SQL Query Designer as needed TSQL queries to process data.

• Configure SQL queries via SQL Query Designer to connect to PowerBuilder forms, analyze and design large scale applications and troubleshoot technical issues in healthcare technology solutions.

• With Tableau, linked to OBDC tables such as SQL Server tables and views, to create dashboards for management to present breakdown of divisions cost such as overtime, overhead, resubmittals and distribute the dashboards to certain individuals to access live linked dashboards. Any updates to the data will be seamless to the end users as results are displayed on their screens.

• Experience supporting IT solutions or projects related to Utilization Management, Care Management or Clinical Data Initiatives

6/2015 – 5/2017 Application Support Programmer, Film LA, Hollywood, CA

• Work with media clients of all major and minor movie studios in Hollywood.

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

• Write SQL and TSQL queries via SQL Query Designer depending on the function needed within the user interface modules.

• 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.

• Work with Residual IT systems to know when residual payouts need to be maintained.

• 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.

• Used Slack for interdepartmental communication and collaboration.

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

9/2006 – 6/2015 Systems Analyst II, WorleyParsons, Arcadia, CA

• Worked as a database developer/VBA programmer for various projects construction projects including AFG Program, BP Projects, Liberty, SAMREF, Conoco Phillips, and Point Thomson.

• Wrote training manuals of databases and held training sessions to teach the end users how to use the new applications.

• Developed and maintained MS Access, mission critical SharePoint sites, SQL Server databases tables and views, and MS Excel spreadsheets for formal review action items, lessons learnt, overtime requests, and interface management on construction oil, gas refinery projects.

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

• Worked with IT for asset management tracking and tagging of computers, printers, copiers, and other office machinery.

• Created routines and procedures for utilizing SharePoint in database applications and maintain enterprise management systems Oracle database for document control routines.

• Created ETL processes, with most processes being manual to extract data from one system, clean the data and load pertinent information into another database system to allow engineers access to perform their analysis.

• Create/Program Databases – Created databases with data repository and front-end user interfaces to track progress of construction, design and procurement of internal and external interfaces.

• Create audit procedures and reviews that were consistent with the CLM strategy and ISO 9001 standards for legal operations leadership team.

• Created company wide recognition input forms with InfoPath, captured data with SharePoint, and designed InfoPath reports for multi-user environment for Employee Recognition Project to allow 450 users at a time across spanning 3 satellite buildings.

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

• Assured hardware and software conflicts are resolved before deployment of new databases to keep systems online 99% of the time.

• Supervised and guided others as they offer support to the development of systems on various projects via proprietary software and with Oracle databases.

• Writer for company’s official newsletters and special events.

• Consult on various projects involving drilling for gas and oil, natural gas, refinement, hydrogen, electricity, and solar energy regarding project tracking and auditing requirements systems.

• Assist HSE researching ballistic protection for refinery explosions.

• Adhere to data governance as engineering teams reside in different offices in countries around the world. The proper unit system of measurements had to be maintained to ensure modules can fasten properly.

EDUCATION

Master Degree, Instructional Technology, American Intercontinental University, Hoffman Estates, IL

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

Certificates

SQL for Data Analysis, Certificate code :8514480, Simplilearn SkillUp, June 2025

AI Agents for Beginners, Certificate code: 8520459, Simplilearn SkillUp, June 2025

Project Management 101, Certificate code: 8543981, Simplilearn SkillUp, June 2025

AWS Cloud Practitioner Essentials, currently enrolled

Coursera, Google AI Essentials Specialization, currently enrolled

SPECIFIC TECHNICAL EXPERTISE/SPECIALIST COURSES

MS SharePoint • Office 365 • MySQL • SQLYog UI • MySQL • SQL Server 2008 & 2012 • Relational Databases

Contact this candidate