Business Analyst Senior
Resume:
Thomas Bonomo
*********@*****.***
Tampa,fl
Senior Business Analyst with experience working in all types of software development environments.
•PMP - Project Management Professional
•Database experience – SQL server
•Data modeling, logical and physical design experience
•BRD, FRD, Data Mapping
•Software - Rally, Jira, Word, Excel, Powerpoint
•Documentation –Process and Data flow diagrams
Businesses
•Healthcare
•Financial
•Utilities
Professional Experience
Caresource (Contractor) August 2024–Present
Senior Business Analyst
As a business systems analyst in the UM All Markets domain. I worked on demand requests submitted by the Caresource business community.
Responsibilities:
•After a demand is created and approved, I create a feature and user story.
•After the user story is created, I set up a meeting with the business to discuss the following.
•Requirements
•Preferences-file location, notifications, file format, etc.
•Priority, Impact on business
•Scope-other teams required for fulfillment
•Timing – Next steps and time estimated (due dates) to fulfill the demand.
•Set up meetings with business, tech leads and developers to confirm requirements and get developer input.
•Set up grooming session with developers and SQA to estimate work effort, assign story points and assign developer.
•Filled as Scrum master when unavailable.
•Worked on several demand requests from different business domains
•LTSS (Long term support services) Power BI dashboard – worked with business and tech lead, SME and power BI specialist to determine claims data to be extracted and formatted for dashboard.
The focus was on Unplanned Hospital visits.
•Admission, Discharge and transfer counts and percentage ratio of success
•Readmission counts
•Top 10 diagnosis codes
•Hospital facilities
•Top 10 DRG codes
•Care Coordination Power BI Dashboard for AR PASSE
•HEDIS (Health Effectiveness Data and Information Sets)
•PCSP (Patient Centered Specialty Plan)
•DCFS reports
•Healthcare reports – pregnancy, pre-diabetes, etc.
•Clinical Operations reports
•Medicare and Medicaid reports
•Regulatory and Compliance reports
•Audit reports
•Finance reports
Truist Bank (Contractor) June 2023–June 2024
Senior Business Analyst
•Requirement gathering and documentation focused mostly on requests from the brokerage team
•Set up workflow request configurations for multiple systems.
•Created SQL queries and designed SSIS packages to load, transform and move daily client account data.
•Created SQL queries to validate data.
•SQL queries to provide data used for data analytic reporting.
•Troubleshooting solutions for workflow efficiency
•Weekly companywide meetings with business community, business analysts, product managers and test team.
•Created workflow design documents and workflow diagrams using Visio.
•Track issues with Excel spreadsheets
Citigroup North America Event Master Central (Contract) Jly 2022–Apr 2023
Senior Business Analyst
•As a Senior BA, I was responsible for understanding, testing and documenting business processes and data flows for North America Event Master Central (EMC). EMC was responsible for creating and managing corporate events (CA).
•Attended weekly meetings with Product management, Business analysts, Ops, Unified Test team (Partner acceptance testing).
•Used JIRA and Defect tracker to track issues.
•Created SQL queries to search for events in SIT, UAT and Production environments and verify EMC event execution results.
•Created Test excel documents with Scenarios and corresponding detailed test Steps and expected results including screenshots for each test case.
•Conducted testing in SIT, UAT and Production environments using the above test case documents.
•Created Corporate Events for testing purposes using Manual Templates and files from various sources (DTCC (Depository Trust Clearing Corporation), SSIS packages, Corporate Action Upload Console, Operations console)
•Created and ran SSRS reports for various event types, e.g. Mergers, Spinoffs, Dividend Options, Stock Splits, Liquidations, Bond Redemptions, etc.
•Created Visio diagrams documenting the Partner Testing Process flows including the following roles: EMC BA, Partner testing Admin, Product manager, Unified testing team, NAM Custody Ops team
•Worked with Operations to develop FRD to make a change to the logic for Eligibility Date to capture certain Mandatory Events where there can be a Ex-Date that goes beyond the Payment Date to capture the Event if the event is considered as Held.
Montefiore IT Care Management (Contract) Oct 2021–June 2022
Senior Business Analyst/EDI developer
•Worked on all phases of project to standardize file layouts that can be used by new customers to transfer initial enrollment and subsequent maintenance information to Montefiore for processing by Epic and QNXT.
•Worked on loading 834 enrollment files into Montefiore’s system.
•Involved in validating 837 claims data.
•Worked with CMO, development, software architects and other business analysts and Product Manager to update Business Requirement and Design documents for Standard Eligibility Epic and QNXT processing.
•Created files to test the running of the standard eligibility files through the QNXT preload and prod load processes as part of Phase III.
•Created SQL scripts to update various configurations and set up tables. Scripts were created to inspect and modify various tables during testing.
•QNXT is a cloud-based healthcare administration platform that helps payers manage claims, enrollment, and other processes. It's designed to improve efficiency and compliance, and reduce costs.
•Worked with the following QNXT features
•Claims management: Automates the process of prioritizing, triaging, and routing claims
•Utilization management: Helps manage the inventory of Utilization Management (UM) documents
•Member enrollment: Manages member enrollment and eligibility details, including supporting the enrollment process for new members and updates for existing members
•Provider networks: Manages provider networks
•Billing: Manages billing
•Care management: Supports value-based initiatives and drives care management
•Division of Financial Responsibility (DOFR): Simplifies the process of determining which party is financially responsible for services rendered
American Systems, Virginia (Contract) Mar 2021–Sep 2021
Senior Database Developer
•Delivered quality designs and data models for rollout of militaryChildcare.com. The website was used by military members to seek childcare for their families.
•Involved in rollout of Program and Family side of militaryChildcare.com from pilot program to implementation.
•Worked in an agile environment (JIRA), created user stories and acceptance test criteria.
•Created SSIS packages to enroll Military families by State and Zones for childcare.
•Updated complicated Stored procedures called by SSIS packages.
•Involved in Split testing of the Web interface.
•Performed Code reviews and identified areas of improvement, efficiencies and areas of performance improvements
Publix, Lakeland, FL (Contract) Mar 2020–Mar 2021
Data Warehouse Analyst/EDI developer
•Designed process to move production files and tables to Access Verification Entitlement Warehouse (AVEW) using SSIS.
•Worked with SMEs, QA, Operations and Project manager to identify obsolete data and data to be moved to new system using SQL queries, SSIS and SSRS
•Documented data dictionary in excel spreadsheets
•Documented process flow and data flow diagrams using VISIO.
•Identified and documented current stored procedures, scripts, TSQL queries, etc.
•Created templates used for each table moved to data warehouse.
•Added error handling and logging to process flow templates.
•Mapped database, SPs, Packages, vb.net scripts and TSQL scripts using Excel.
•Developed Acceptance criteria, created test plans and test cases with QA.
Blue Cross Blue Shield, Jacksonville, Fl (Contract) July 2019–Feb 2020
Senior Business Data Analyst on Data Analytics team
•Meetings with business and customer service on Medicare Advantage enrollment, fulfillment and member services processes.
•Agile Scrum process from grooming, planning, daily standups, sprint reviews and sprint retrospective. Created user stories and acceptance criteria.
•Gathered KPI requirements for Power BI interface.
•All KPI data loaded using SSIS packages.
•KPIs displayed summary data with number and percent of applications in and out of compliance using pie charts and bar graphs and included the ability to drill down to individual members and corresponding PHI data.
•KPIs tracked fulfillment request letters for applications eligible for Medicare Advantage for Annual and Open enrollment.
•KPIs for aging of fulfillment requests to determine compliance.
•KPIs to identify plan membership types, requirements and dependencies.
•Documented prod workflow, manual processes not defined and data flows
•Created RTM Excel sheet by sprint to verify all requirements were tested.
•Recommended solution used to remove duplicates in leadership KPIs.
•Coordinated UAT testing with users and scheduled regression testing.
•Tracked requests sent to Wipro for data quality validation.
•Tracked requests sent directly to CMS and responses received from CMS.
Baycare, Clearwater, Fl (Contract) Sep 2018-June 2019
Senior Business Analyst/EDI developer
•Worked on government mandated Financial and Services Accountability Managements Systems (FASAMS). Worked with Process Improvement group to write use cases, gather requirements and design system to process claims submitted to the Department of Children and Families (DCF) via managing entities provider network.
•Designed Episode of Care Architecture to group and process related treatment episode transactions.
•Designed reports displaying clinical transaction and event data, demographic data, amounts, totals and counts.
•Designed process to merge Sorian financial and Cerner clinical encounter data with claims to be submitted to managing entities for validation to be forwarded to DCF.
•Designed SSIS packages for treatment episode data, client data and service event data as part of the process to submit data to DCF.
•Designed templates to move data from database, excel and flat files to the managing entities for further validation.
•Created SSRS reports to validate treatment episode data, client data and service event data as part of process to submit data to DCF.
•Coordinated with Process Improvement to develop system to handle errors and resubmit transactions.
PODS, Clearwater, Fl (Contract) Apr 2017-Aug 2018
Senior Business Analyst
•In collaboration with the business community and other members of my team including other SQL developers, I developed business requirements for Residential and Commercial customers, Franchisees and Franchisors and third party vendors.
•Designed template to move data to data warehouse based on the sequence of dependencies outlined in the business requirements. Used to develop the SSIS packages.
•Used SSIS packages and stored procedures to move data to the data warehouse.
•Designed reports to display Residential and Commercial Customers, Franchisees and Franchisors and third-party vendors.
•Created detailed mapping documents for ERP conversion
•Added user stories, features, bug requirements using Jira
•Designed process to migrate Customer, Order, Invoice, Subsidiary, Chart of Accounts, Invoices and Payment Term data to destination tables to be imported to the financial accounting system.
Citigroup, Inc., Tampa, Fl (Contract) Oct 2016-Apr 2017
Senior Business Analyst
•Database developer and SQL resource for major systems and subsystems.
•Created Conceptual, Logical and Physical database models based on formal and informal meetings with business analysts, quality assurance and other stakeholders.
•Finalized database model with developers, QA and business community.
•Assisted with updating BRD and Functional requirements for federally mandated 871 regulations.
•Transaction data was loaded into SQL Server and used to generate reports. Scheduled and executed SSIS Packages for clients using SQL Server Agent.
•Created SSRS report of transactions for accounts inactive greater than 12 months.
•Created indices for large tables in Custody database that greatly improved performance. Used Set IO/Time Statistics and SQL profiler to monitor stored procedures and sql statements to identify changes to improve performance.
•Developed stored procedures and SQL scripts for testing.
•Updated stored procedures for Microsoft 110 compatibility.
•Stored procedures read Accounts, Transactions and Holdings from daily files into a SQL Server database. Solution validated incoming data and performed notifications when jobs completed or produced errors, which were subsequently written to history and error tables.
•Provided input to Functional Requirements document.
HealthESystems, Tampa, Fl (Contract) Aug 2014–Sep 2016
Senior Database Developer
•Maintained clinical integration databases.
•Added third party payers to database driven application based on business rules for payers. Updated patient/clinician lookup, patient, case and medication tables as part of cost containment, uncovering fraud and ensuring patient health.
•Wrote SSIS packages and SSRS reports to track health insurance claims.
•Created Stored Procedures, User Defined functions, & Triggers to update tables and perform validation when third party payers were added to the database.
•Developed test plans and tested 837 claims using inhouse claims processing system.
TCS Consulting, Inc. (Nielsen, Oldsmar, FL) (Employee) Apr 2013-July 2014
Application DBA/Applications Developer
•Involved in reverse engineering Nielsen in Review and Global Model applications. Intimate knowledge of data model, data access and business layers for related projects.
•Worked on production support issues and bug fixes for stored procedures and reports. Involved understanding how several applications interfaced with each other and how they impacted external systems.
•Migrated data from legacy system to Nielsen in Review platform. Scheduled master and on demand data loads to synchronize data with legacy system using SQL server agent jobs, SSIS packages and SQL scripts.
•Wrote stored procedures to improve application performance.
Pharmerica, Tampa, Fl (Contract) Aug 2011-Mar 2013
Application DBA/Database developer
•Designed and developed Data Model for new Returns application.
•Application determined and identified medication to be destroyed and allowed reverse destruction for certain reasons. Return and destruction logic was built into the same interface.
•Added prompts to allow user to dynamically reconfigure cost threshold for each RX to determine if it was cost effective to return medication and to allow user to specify if a drug was a partial return if it could not be determined automatically.
•Created customized SSRS reports by Resident, Facility and Pharmacy for Returns project.
Tampa Bay Electric Company, Tampa, Fl. (Contract) July 2010–Aug 2011
System Architect/Team Lead/Senior Application/Web Developer
•Created customer complaint database of residential and commercial properties to be accessed by web application by customer service when customers called in to file a complaint. Pulled data from another SQL Server database.
•Created Revenue database to as part of an overall company desktop optimization effort. Data loaded from excel spreadsheet, mainframe, Access and other SQL Server database.
•Interfaced with business contacts in Billing and Payment services department to gather requirement for revenue recap project.
•Added ability to reconcile revenue daily instead of having to wait until month end to reconcile out of balance conditions. Rolled up Monthly data daily.
•Developed SSIS packages to download historical data and merge with daily revenue data. Created SSIS packages to download various residential and commercial adjustment transactions to be used by billing services as part of the revenue balancing process.
•Created central location for revenue reporting and added new reports to aid in year-end balancing.
Education/Training:
•Career Institute of Florida - .Net Curriculum
•Project Management Institute, Villanova University – PMP Certificate
•JPMChase – Cash Management Course, Banking and Treasury Securities courses, Oracle
•New York University – Data Processing Diploma program
•State University College at Oneonta, NY – Bachelor of Science
Contact this candidate