Business Analyst Senior

Lolita Owens

678-***-**** Dallas, GA *******.*****@*****.*** www.linkedin.com/in/lolita-owens

Senior Business Analyst

SQL DEVELOPMENT DATA ANALYSIS REPORTING STAKEHOLDER COLLABORATION

Results-driven Business Analyst with 14+ years of experience in Information Technology, specializing in data analysis, business process improvement, and Agile methodologies. Adept at gathering business requirements, analyzing complex datasets, Quality Assurance testing, and bridging the gap between stakeholders and technical teams to drive successful project execution. Proven expertise in SQL, ETL processes, cloud platforms (AWS, Azure, Snowflake), and BI tools (Tableau, Power BI, SSRS), delivering actionable insights to optimize operations. Experienced in healthcare (EHR data) and finance sectors, with a strong background in data governance, compliance, system automation and .net development.

PROFESSIONAL HIGHLIGHTS

Played a key role in the end-to-end project lifecycle by gathering and analyzing business requirements for a marketing eCommerce site, translating business needs into detailed functional documentation, process flows, and technical specifications ensuring seamless communication between business and technical teams, leading to successful project delivery and improved operational efficiency.

Increased team productivity by 25% by serving as Agile Scrum Master for a team of 12 developers by streamlining project processes, identifying and removing impediments, optimizing workflows, and managing stakeholder expectations to minimize scope creep.

Participated in data analysis using SQL and ETL process for a healthcare data migration project, extracting and transforming large data sets from disparate systems into Snowflake, to optimize data integrity and enable seamless business continuity.

Analyzed and wrangled complex datasets to create insightful Tableau dashboards and reports, empowering stakeholders with data driven insights for informed decision-making.

EXPERIENCE

Shaw Industries 04/2024 – 01/2025

BUSINESS SYSTEMS ANALYST, Remote

Collaborated with stakeholders, developers and UI/UX designers (FIGMA) to document functional and technical requirements and groom backlog for the eCommerce marketing website redesign, ensuring alignment throughout the Project Life Cycle.

Created process flow diagrams and analyzed business process and workflows, resulting in 15% increase efficiency through identified optimization opportunities.

Performed API testing (Postman) and coordinated with QA and UAT team to analyze, test, and resolve reported defects to ensure delivery of scalable web solutions.

Communicated risks, conducted GAP Analysis, created process flow diagrams and participated in architecture reviews to ensure alignment with business requirements.

Delivered ad-hoc reports and conducted in-depth SQL based analysis for resolving live data issues.

Configured and optimized CRM integrations to streamline lead generation, tracking, and follow-up processes for inquiries and sales.

Inovalon 06/2022 – 11/2023

SENIOR BUSINESS ANALYST, Remote

Served as the Agile Scrum Master for the healthcare data lake team, orchestrating scrum ceremonies using the Azure DevOps board to ensure successful sprint execution and team alignment throughout SDLC.

Collaborated with internal Product Owners to elicit and document business requirements, created user stories and groomed product backlog removing risks and impediments for the development team.

Served as the initial point of contact for all reported issues, troubleshooting utilizing SQL to research and resolve issues with data and ETL processes of large data sets for healthcare clients to maintain data integrity and process efficiency.

Troubleshooted and provided support across the business utilizing Snowflake cloud platform and wrote medium to complex SQL queries on large data sets to support development of data governance practices.

Performed QA testing, identifying and resolving defects to ensure data quality for the healthcare software application and enhance the user experience.

Created Root Cause Analysis documents, removed impediments and coordinated release planning schedule with cross-functional teams.

Created dashboards, reports (Power BI) and KPIs to track project progress, sprint velocity, and team performance, increasing stakeholder transparency and alignment for data-driven decision-making.

Conducted User Acceptance Testing (UAT) for real-time healthcare medical records retrieval (SaaS) system ensuring system accuracy and compliance.

Nordstrom 12/2021 – 05/2022

BUSINESS SYSTEMS ANALYST, Remote

Collaborated with accounting/finance team to research and analyze the invoice matching system process in ReIM, identifying and document findings to support reconciliation efforts and optimize process affecting accounts payable.

Developed insightful dashboards using Tableau by analyzing and wrangling large Excel and SQL datasets to identify key revenue loss drivers, enabling stakeholders to take strategic action.

Unum 03/2020 – 11/2021

DATA ANALYST II, Atlanta, GA

Contributed in all phases of the ETL process for the healthcare claims data migration project, successfully extracting and transforming large data sets from various sources to the cloud.

Facilitated productive meetings with business stakeholders to elicit business requirements ensuring alignment between data initiatives and organizational goals throughout SDLC.

Conducted data profiling, cleansing and data mining of the healthcare claims data (IBM InfoSphere).

Spearheaded the creation and maintenance of comprehensive documentation (metadata), the data catalog utilizing informatica, and kept data dictionaries up-to-date.

Created logical and physical data models for system design and database creation.

Utilized Jira for tracking project tasks and maintained documentation in Confluence for seamless team collaboration.

Created, modified and optimized SQL stored procedures, and performed DDL and DML operations to support business requirements and maintain data integrity.

The Krystal Company 10/2019 – 02/2020

BUSINESS SYSTEMS ANALYST, Dunwoody, GA

Led middleware integration projects by managing the extraction and loading of data from stores resulting in 20% increase in process efficiency and accuracy.

Documented business rules and processes to maintain operation continuity and served as escalation point for high-priority support issues while creating and optimizing reports (Power BI) that led to increased efficiency by 25%.

GFMH, LLC/Generation Mortgage 10/2009 – 12/2018

SENIOR APPLICATION DEVELOPER, Atlanta, GA

Designed, developed, and enhanced mortgage servicing applications using C#.net and VB.net.

Collaborated end users to troubleshoot and resolve application issues, implement feature enhancements, and served as the Subject Matter Expert (SME) for the mortgage servicing application.

Partnered with Business Analysts and Project Managers to define detailed specifications for new features and functional requirements.

Created automated monthly, yearly, audit, month-end, and ad-hoc reports using SSRS and Excel.

Developed and optimized SQL stored procedures, functions, triggers, and views. Managed and monitored scheduled SQL jobs. Performed ETL processes using SSIS and DTS to extract, transform, and load data from Excel, CSV, and flat files.

Provided leadership and strategic direction, serving as both Business Analyst and Project Manager during IT department reorganization.

Produced deployment and run book plans, participated in Change Management meetings, facilitated team release plannings for software deployments.

Led reporting projects and application rewrites while managing offsite consultants in designing, developing, and integrating reports (SSRS) into mortgage servicing applications.

Supported closeout processes by assisting DBAs, BI teams, and Project Managers in technical design, data transfer, QA testing, and report creation using BI Development Studio.

EDUCATION

Albany State University, Albany, GA

Bachelor – Computer Information System

Oracle Database SQL Certified Associate

TECHNICAL SKILLS

Database & SQL: SQL Server, Oracle, Snowflake, Teradata

BI & Reporting Tools: Tableau, Power BI, Cognos, SSRS

Cloud & ETL: AWS, Azure, SSIS

Project Management: Agile (Scrum, Kanban), Jira, Confluence

Tools & Technologies: ServiceNow, Zendesk, SharePoint, Visio, Salesforce, .Net Framework

Data Governance Tools: Informatica, IBM InfoSphere

Programming Languages: VB.net, C++.net, C#.net, HTML, Javascript

Contact this candidate