Data Analyst Business
Resume:
MANISHA
BASANI
**************@*****.***
Charlotte NC
Highly skilled and results-driven Business Data Analyst with extensive experience in the banking and healthcare industries. Proven expertise in data analysis, wrangling, visualization, and optimization using SQL and reporting tools like Power BI and Tableau. Adept at working in Agile and Waterfall environments, with strong project management and cross-functional team collaboration skills. Recognized for enhancing data accuracy, driving process improvements, and effectively translating complex data into actionable insights that support strategic decision-making. Diligent Business Data Analyst with solid background in data analysis and business intelligence. Proven track record of interpreting complex data sets to drive strategic decision-making and improve operational efficiency. Demonstrated ability in utilizing SQL to streamline data processes and deliver actionable insights. PROFESSIONAL SUMMARY
University of Mary Hardin Baylor
Belton Texas • 12/2017
Master of Science: Information
Technology
Relevant Course Work:
Database Development and
Administration, Applied
Programming, Analysis modelling
and Design, IT Infrastructure,
Project Management, IT and Supply
Chain Management, Enterprise
Systems, Development, and
Implementation.
EDUCATION
SKILLS
Tools: SharePoint, Visio,
JIRA,Rally,
•
Testing Tools: Post Office,
Postman, Jenkins, Swagger.
•
Methodologies: Waterfall, Agile
Scrum, Bug life cycle.
•
• Languages: SQL, PL/SQL
Database Systems: Teradata,
Oracle 12c/11g/10g, MS SQL,
MongoDB, Server, IBM DB2, Green
plum, PG Admin.
•
Wells Fargo - Data Management Analyst
Charlotte, NC • 01/2025 - Current
Project: H1 & H2 FR Y-14Q Data Validation and Regulatory Reporting Supported quarterly regulatory reporting by preparing, validating, and reconciling data for Commercial & Industrial Loans (CNI - H1) and Corporate Real Estate Banking (CRE - H2) FR Y-14Q reports, ensuring compliance with Federal Reserve requirements.
Florida Blue - Blue Cross Blue Shield Of Florida - Sr. Business Analyst Jacksonville, FL • 08/2021 - 01/2025
Project: Agent Portal Development for Targeted Marketing Developed a web-based portal to empower agents and agency owners with real-time access to customer data, supporting personalized sales and marketing campaigns.
WORK HISTORY
Developed and optimized complex SQL queries using Teradata to resolve data conflicts and validate data accuracy across quarterly FR Y-14Q submissions.
•
Translated detailed business logic from front-end teams into precise SQL to ensure data adherence to regulatory rules and business requirements.
•
Utilized Enterprise Defects Quality Data Management (EDQDM) tools to identify residual risk issues, analyze data defects, and implement corrective actions to improve report quality.
•
Ensured consistency and alignment of report data with business rules and regulatory guidelines, reducing errors and audit findings in critical regulatory reports.
•
Collaborated with cross-functional teams to verify and document data flows, supporting compliance and audit readiness.
•
Reporting Tools: Power BI,
Tableau.
•
Project: Cross-Platform Data Integration & Standardization Project Led a critical initiative to standardize and integrate data across heterogeneous platforms to support unified analytics and reporting. Project: Open Enrollment Sales Analytics & Dashboarding Created executive-level dashboards to monitor sales performance and forecasting trends during the ACA Open Enrollment period. Florida Blue - Blue Cross Blue Shield Of Florida - Business Analyst Jacksonville • 08/2019 - 08/2021
Project: Agent Sales Enablement Platform
Gathered and translated stakeholder requirements into Business Requirement Documents (BRDs) and collaborated with technical teams to produce Technical Design Documents (TDDs).
•
Worked with UI/UX designers to create user-friendly wireframes and mockups.
•
Defined and prioritized user stories in JIRA; led grooming, sprint planning, and backlog refinement sessions.
•
Coordinated testing efforts with QA teams, reviewed test cases, and supported UAT with business stakeholders.
•
Conducted weekly stakeholder demos and incorporated feedback into product iterations.
•
Identified and resolved data type mismatches across Oracle, PostgreSQL, MongoDB, and IBM DB2, reducing integration issues by 25%.
•
Collaborated with data engineering teams to build transformation logic and define metadata standards.
•
Performed data profiling and validation using SQL, Hive, and NoSQL queries.
•
Conducted regression testing and data quality checks across environments.
•
• Documented technical mapping and data lineage for ETL processes. Designed and implemented Power BI and Tableau dashboards for sales, channel performance, and enrollment tracking.
•
Integrated data from multiple sources (SQL Server, DB2, and internal APIs) to support real-time reporting.
•
Improved sales forecast accuracy by 10% by enabling near real-time visibility into trends.
•
Collaborated with business leaders to define KPIs and automate recurring reports.
•
Managed performance tuning of SQL queries and implemented incremental refresh logic.
•
Led end-to-end delivery of a web-based application enabling agents, agency owners, and delegates to access member data for targeted sales and marketing outreach.
•
Gathered and translated business requirements into comprehensive BRDs and collaborated with tech teams to develop TDDs.
•
Project: Data Integration & Analytics for Member Outreach MUFG Union Bank - Business Data Analyst
Los Angeles • 11/2018 - 08/2019
Project: Data Infrastructure Modernization & Governance for Banking Operations
Led a strategic initiative to enhance the bank's data infrastructure, ensuring scalable, governed, and high-integrity data to support analytics across customer accounts, loans, and transaction monitoring. Ally Bank - Data Analyst Consultant
Charlotte, NC • 02/2018 - 11/2018
Project: 360-Degree Customer View for Cross-Sell & Behavioral Analytics
Led the data analysis and documentation efforts for a 360-degree Facilitated UI/UX workshops to design mock-up screens aligned with user experience goals and branding guidelines.
•
Defined and prioritized user stories in Rally, led grooming sessions with dev/QA teams, and ensured accurate story estimation and sprint planning.
•
Conducted weekly stakeholder demos, collected feedback, and refined features before UAT sign-off.
•
Supported QA by reviewing test cases, ensuring test data coverage, and verifying requirement traceability during SIT and UAT.
•
Spearheaded cross-platform data integration initiative combining claims, eligibility, and enrollment data from Oracle, Hive, MongoDB, and DB2 for analytics-driven outreach.
•
Conducted gap analysis and implemented reconciliation logic to resolve data mismatches across systems.
•
Performed regression testing and data validation for ETL pipelines to ensure clean and accurate data delivery.
•
Developed ad hoc SQL reports to support provider performance analysis and targeted member communications.
•
Utilized advanced SQL across Oracle, SQL Server, and PostgreSQL for data analysis, profiling, and mapping, including writing complex joins, aggregations, and transformation logic.
•
Collaborated with the data governance team to maintain enterprise data models and metadata standards using tools like Collibra and Analytix, ensuring alignment with regulatory and internal policies.
•
Defined and documented comprehensive business and technical requirements by working closely with product owners, data engineers, and compliance teams.
•
Created detailed technical specifications and mapping documents to guide development and ETL processes.
•
Enforced data quality rules and reference data standards, reducing inconsistencies and improving the trustworthiness of analytics outputs.
•
Played a key role in streamlining data flows and improving the efficiency and accuracy of reporting pipelines across business units.
•
customer view initiative, aimed at consolidating data across multiple Lines of Business (LOBs) to create a unified customer profile. The goal was to enhance cross-sell opportunities and enable targeted marketing based on customer behavior and transaction patterns. Extarc Software Solutions - Business Analyst Intern Hyderabad, India • 06/2013 - 12/2015
Project: Business Process Modeling & Requirements Documentation As a Business Analyst Intern, I developed core competencies in business process analysis, documentation, and stakeholder collaboration while supporting a business transformation initiative.
Analyzed and profiled data from multiple source systems to identify customer touchpoints across banking products, transactions, and services.
•
Built and documented data lineage, ensuring complete traceability from source to final output tables based on a unique customer key.
•
Converted business requirements into detailed technical specifications for the development and reporting teams.
•
Created and maintained metadata documentation to support enterprise data governance and improve transparency across stakeholders.
•
Worked closely with BI and QA teams to validate data transformations, ensuring reporting accuracy before production deployment.
•
Enabled insights into customer banking behavior to support product recommendations, increasing cross-sell effectiveness and campaign personalization.
•
Created detailed Use Case Specifications, Business Flow Diagrams, and Sequence Diagrams to document system interactions and process flows from multiple stakeholder perspectives.
•
Collaborated with senior analysts and business stakeholders to gather requirements and translate them into clear, structured documentation for technical teams.
•
Contributed to requirements validation sessions, helping ensure alignment between user needs and functional specifications.
•
Gained hands-on experience in process modeling tools and developed a strong foundation in SDLC and stakeholder communication.
•
Contact this candidate