Business Analyst Technical Program

ROHINI CLARA

Product Owner Technical Program Manager Senior Business Analyst

Business Systems, Data and Business Analyst

******.*****@*****.***

Phone#: 914-***-****

SUMMARY

PROFESSIONAL SUMMARY

Experienced and results-driven professional with a background in Product Ownership, Business Analysis, Technical Program Management, and Software Development using SQL Server. Skilled in leading cross-functional teams, managing product lifecycles, and delivering high-quality solutions. Adept at identifying business needs and transforming them into actionable technical requirements. Passionate about driving innovation and improving processes in fast-paced environments. Proven expertise in developing and maintaining software solutions using SQL Server, ensuring efficient data management, and creating reporting systems.

KEY SKILLS

Product Management: Requirements gathering, roadmap development, backlog management, sprint planning, stakeholder management, feature prioritization.

Technical Program Management: Cross-functional coordination, risk management, schedule management, agile methodologies (Scrum, SAFe).

Business Analysis: Process modeling, user stories, use case diagrams, data analysis, process optimization.

Data Analysis & Reporting: SQL, Excel, data visualization, reporting tools (Power BI, Tableau).

Software Development using SQL Server: Database design, T-SQL, stored procedures, query optimization, data modeling, ETL processes.

Project Management: Agile project management, Jira, Confluence, MS Project, Asana, PMP principles.

Leadership & Collaboration: Mentoring, team leadership, communication with stakeholders, cross- functional team collaboration.

EDUCATION & TRAININGS

Bachelor of Arts, University of Mumbai (formerly Bombay University), G.N. Khalsa College, India 1993 – 1998

Diploma in Computer Science, Datapro Information Technology, India 1995 – 1998

Full-Time Training in Windows-Based Application Development using Microsoft Visual Basic .NET, Soft Origin Technical School 3-month program

Comprehensive Training in Relational Database Management Systems (RDBMS) with Microsoft SQL Server 2000, NIIT 6-month full-time program, 2001

PeopleSoft – PeopleTools 8 Training, Enterprise Technology Solutions In-house training, Sept – Nov 2004

Tame Big Data to Drive Big Insight, Stanford Continuing Studies, Palo Alto, CA Fall 2017

Workshops and Boot Camps in Data Analytics, Project Management, and Product Management, General Assembly, San Francisco Completed 6 intensive sessions

Certified SAFe® 6.0 Product Owner/Product Manager (POPM), SAFe Studio

TECHNICAL SKILLS

Windows Server 2008 R2 Windows 8/7 Enterprise DOS Windows NT/2000/2003/XP/98 UNIX Programming Languages & Frameworks: Visual Basic 6, ASP.NET, Visual Studio .NET 2003, JavaScript, HTM, CSS, XML, UNIX Shell Scripting

Databases & Data Tools: MS SQL Server (2000, 2005, 2008 R2, 2012, 2016), MySQL, MS Access, T-SQL, SAP HANA, PeopleTools 7.5

ETL / Reporting / BI Tools: SSRS, SSIS, Tableau, Power BI, Excel (Advanced), SQL-based Data Analysis Project & Product Management Tools: MS Project, MS Visio, JIRA, Bugzilla, Buganizer, TFS, Confluence, MIRO, Figma, ServiceNow

CRM & Business Applications: Salesforce, Microsoft Dynamics CRM, SAP Hana, Postman Other Software/Platforms: MS Office Suite, Visual Studio, Salesforce Lightning, API Documentation & Testing Tools WORK EXPERIENCE

Project Experience – Modernization Support - System/Data Migration/UAT Project/Client: Ventura County - Probation Agency (Law Enforcement)/VCIJIS Role: Business Systems Analyst/QA Analyst

Duration: Jan 2025 – Till Date

Collaborated with business and testing teams to develop and execute detailed UAT plans tailored to different user groups and business needs.

Defined business requirements and translated them into test plans, ensuring coverage of core business scenarios, workflows, and edge cases as currently is in the In-house application - PRISM

Facilitated communication between stakeholders and development teams, clarifying functional and technical requirements.

Managed UAT sign-off, ensuring business requirements were met and obtaining final approval from end users post-testing.

Analyzed system functionality against business requirements, providing feedback for system optimization and user experience improvements.

Collected feedback from users to enhance system performance and usability, driving continuous system improvements.

Identified and documented defects, coordinating resolution with development teams to ensure system quality.

Worked with developers to optimize UAT processes, ensuring timely delivery of business-critical features.

Supported Agile methodologies, contributing to sprint planning, and collaborating with cross- functional teams to meet project timelines.

Key skills: Business Requirements Analysis, UAT, Agile Methodologies, Stakeholder Communication, Process Improvement, Data Validation, SQL Employer : Sonus Software, Inc.

Project/Client : St. Jude Children’s Research Hospital - Memphis, Tennessee Role: Sr. Business System Analyst/ Product Owner/ Scrum Master - ALSAC Duration: 03/2024 – 12/2025

Product Ownership & Roadmap Development:

Results-oriented Product Owner with strong client engagement skills, responsible for defining product vision, managing roadmaps, and collaborating with solution architects and vendors on financial reconciliation and payment processing products for ALSAC. Actively gathered requirements, managed backlogs, and prioritized features based on client needs and usability feedback.

Agile & Scrum Leadership:

Facilitated all Scrum ceremonies including sprint planning, daily stand-ups, reviews, and retrospectives. Worked closely with development teams to remove blockers, ensure smooth deployments, and improve team communication, collaboration, and delivery efficiency.

Stakeholder Communication & Executive Reporting: Communicated complex product and system issues in a clear, structured way, crafting executive- level and board-level presentations and reports using PowerPoint and data analysis to drive informed decision-making.

Business Analysis & Technical Collaboration:

Translated business needs and functional specs into detailed business process requirements. Wrote ad hoc SQL queries to support data analysis, reporting metrics, data mapping, and occasionally assisted with ETL specification refinement.

Documentation & Process Modeling:

Reviewed and edited technical documentation including workflows, use cases, user stories, and test cases. Ensured clarity, accuracy, and consistency of technical content and authored step-by- step process documentation aligned with business goals and user needs.

System Optimization & API Management:

Collaborated with IT and cross-functional departments to optimize data workflows and sharing across business systems. Led planning efforts to sunset legacy web services and implement modern APIs aligned with industry best practices.

Employer : Sonus Software, Inc.

Project/Client : Office of Juvenile Justice - State of Louisiana – Baton Rouge, LA Role: Sr. Business & Program Management Analyst/Scrum Master Duration: 02/2020 – 02/2024

Project & Program Management:

Led Business Process Re-Engineering efforts for the Office of Juvenile Justice (OJJ) in collaboration with IT teams; performed Program Manager duties across enterprise applications, coordinated cross-functional teams (analysts, developers, testers), managed solution delivery, and oversaw full project lifecycles using tools like JIRA, Slack, Teams, and Confluence.

Scrum Master & Agile Leadership:

Facilitated Agile ceremonies, including sprint planning and backlog grooming; conducted project- related meetings with development teams; updated backlogs, created detailed user stories, and coordinated UAT efforts including functional test plans and test cases, following Agile Scrum methodology.

Business Analysis & Stakeholder Engagement:

Worked closely with business teams to understand functions, document requirements, define scope/objectives, perform risk assessments, evaluate alternative solutions, and gather report requirements. Interfaced between business stakeholders and technical teams to define and manage the project lifecycle.

Technical Contributions & Development Support:

Supported development of client/server-side web applications, APIs, and services using Microsoft Visual Studio. Designed system solutions using JavaScript, built user interfaces/workflows with HTML/CSS, and created wireframes, prototypes, and mockups with MIRO, Figma, and PowerPoint.

API & Integration Management:

Used Swagger for technical API documentation, Postman for API testing, and coordinated with internal and external vendors to ensure seamless integration and implementation for projects/releases. Ensured all integrations met functional, performance, and security requirements.

Reporting & Data Analytics Support:

Prepared technical reports using data from daily, weekly, and monthly reviews; validated and supported OJJ team’s data analytics work using SQL queries; helped schedule and prioritize system maintenance; and supported approval workflows, reporting formats, and process improvements.

Employer : Sonus Software, Inc.

Project/Client : Google - California

Role: Technical Program Manager - Adoption Program Duration: 08/2019 – 01/2020

Supported the Adoption Program within the Data Works portfolio as a TPM, leading multiple scrum teams’ day-to-day activities, understanding project requirements, driving scope discussions, and aligning project priorities with program-level goals.

Created project plans and partnered with product managers, BSAs, and engineers for effort estimations, identifying dependencies, and managing prioritization to ensure alignment with program goals.

Managed backlog grooming, sprint planning, and stand-up meetings for global teams (US and India), holding team members accountable and ensuring timely delivery, while preparing and sending regular sprint and program updates to stakeholders.

Proactively identified assumptions, dependencies, issues, and risks, facilitating discussions to develop mitigation plans and drive the execution of cross-functional projects, providing insights and processes to manage risks.

Worked with key stakeholders across multiple teams to execute scheduled tasks during each development cycle in accordance with the SDLC, providing continuous support for entities in data management domains such as master data management, BI & Analytics, ETL, metadata management, data quality, and reporting.

Managed all aspects of program deliverables for multiple interdependent projects, balancing internal and external factors to propose solutions, create wireframes and prototypes, and communicate effectively with product and engineering teams for implementation and dependency mapping.

Employer : Sonus Software, Inc.

Project/Client : Scan Health Plan - Long Beach, CA Role: Sr. Technical Business Analyst - MedHok Implementation Duration: 08/2018 – 07/2019

Proactive and reliable professional with Agile SCRUM experience, providing routine updates, communicating project expectations, and ensuring timely documentation of progress and goals.

As a Technical BA with Software Engineer expertise, used MS SQL to write SQL queries to extract data to Capture User Requirements, review SSRS reports, created User Stories/ Screen Mockups, process flows and Mock-up dashboards using Tableau. Work with database objects on current Data Architecture to conduct thorough Data analysis on the Data Warehouse side by review of changes to reference meta-data specifications and provide Regulatory SME input to data standards, data quality, and data modeling teams.

Configured custom fields, forms, objects, dashboards, and workflows within systems to improve business user efficiency and streamline processes.

Led user requirement and rationalization sessions on as-is v/s MedHOK processes, documented detailed business processes, and prepared Business & Functional Requirements Documents, test cases, and solution designs by Facilitating meetings with Business users, technical team and Quality Assurance teams for test plans

Collaborated with technical and QA teams to develop test plans and validate results per success criteria, while using MS SQL for data extraction and reviewing SSRS reports.

Developed wireframes, mockups, process flows, and dashboards using Tableau; facilitated communications, coordinated tasks, and managed dependencies using project management tools like MS Project, Visio, JIRA, and TFS.

Employer : SQL Data Solutions

Project : Department of Health California - Sacramento Role: Technical Business Analyst - FDaaS

Duration: 03/2018 – 08/2018

Worked as a Business Data Analyst for DHCS on the Medi-Cal Program Integrity Data Analytics team at Pondera Solutions, supporting report gathering.

Contributed to the enhancement of Fraud Detection as a Service (FDaaS) by integrating additional third-party data sources such as public records and criminal history to assess Medi-Cal program risks.

Performed operational data analysis and validation of third-party vendor datasets - LexisNexis, Appriss, Thomson Reuters, etc., assessing data quality and alignment with project requirements.

Conducted data comparisons and quality checks to ensure data integrity and accuracy, running batch ETL processes as part of data validation.

Collaborated with clients to design and develop Salesforce solutions, leveraging Marketing Cloud for a comprehensive 360-degree customer view.

Employer : SQL Data Solutions

Project : Sutter Health - Sacramento

Role : Salesforce Business Analyst

Duration: 05/2017 – 02/2018

Designed, created, and validated routine reports for NGO and gift processing requests, ensuring accuracy and consistency.

Developed Salesforce reports and maintained Access databases for philanthropy reporting.

Created and maintained tools for business operations to allow Finance to pull data on demand, while gathering and documenting business requirements for various projects.

Collected and documented business processes and rules for Salesforce Lightning UI, creating components and apps to support business needs.

Refined automated processes in MS Access, tracking issues and documenting changes for process improvement.

Employer : Sonus Software, Inc.

Project/Client : Medtronic - Carlsbad, CA

Role: Data Analyst

Duration: 09/2016 - 04/2017

Conducted testing using SQL queries and generated T-SQL/Access queries and charts for analysis of complaint data.

Provided backup support for CTS administrators and corporate monthly metric reporting.

Contributed to Data Mapping and ETL documentation for Data Warehouse, and assisted with analytic projects (data mapping, validation, etc.).

Delivered project presentations and reports to higher management, while gathering, analyzing, and writing business requirements documents.

Assisted the Project Manager in setting realistic expectations, evaluating the impact of changes, and preparing/updating BRDs & FRDs as needed.

Employer : Sonus Software, Inc.

Project/Client : Applied Materials - Santa Clara, CA Role: Technical Business Analyst

Duration: 09/2015 - 07/2016

Managed medium-sized projects, from gathering requirements to presenting mock-ups, scheduling, and ensuring successful sprint deliverables with the Scrum Master.

Collected and documented business processes, rules, and requirements for Salesforce Lightning UI, creating components and apps.

Collaborated with stakeholders to document business needs, provide recommendations, and ensure smooth implementation.

Managed JIRA for BIM Services, applying Agile methodology to track issues and project progress.

Led requirements gathering sessions, creating comprehensive Business Requirements Documents and defining metrics for early development.

Conducted data mining and ad-hoc analysis across data sources, creating Tableau dashboards for BI reporting and actionable insights.

Managed and facilitated requirements gathering sessions with business and IT stakeholders resulting in moderated, orderly, and efficient meeting to Identify and define concise, cohesive, and comprehensive Business Requirements Documents.

Created sequence/process flows, Mock-ups and use cases documenting functional (FRDs) and system requirements (SRDs) & define business metrics so the team starts development phase ahead of schedule.

Employer : Sonus Software, Inc.

Project/Client: PALO ALTO NETWORKS, Inc. - Santa Clara, CA Role: Sr. Data/Business Analyst (Teams: DQ/On-Off boarding /FICO/SAP) & DBA (Team: IAD) Duration: 08/2014 - 08/2015

Application Support & Ticket Management:

Served as an Application Support Analyst, managing and triaging ServiceNow tickets by determining appropriate business processes based on request types. Logged, tracked, and communicated support issues clearly to internal and external customers across Business Intelligence and System teams.

Database & Query Execution:

Executed and created ad-hoc queries for data analysis using MySQL, Access, Salesforce, and SAP Hana. Collected and managed datasets from stakeholders, supported business needs, and conducted deep data analysis on production servers to identify gaps, anomalies, and trends.

Data Quality & BI Support:

Provided administrative and data quality support to SAP Hana BI, Revenue Reconciliation, and On-boarding/Off-boarding teams. Analyzed sensitive data since December 2014, supporting initiatives related to data validation and ensuring the accuracy and integrity of business-critical information.

Agile Project Coordination & Stakeholder Interaction: Acted as Business Analyst and Project Coordinator for On-boarding/Off-boarding processes, working with HR, Facilities, and Security teams. Followed Agile Scrum methodology, managed approval workflows, tracked project status accurately, and contributed to HRIS version update testing.

DevOps & System Integration:

Collaborated with DevOps to align business requirements with the CI/CD pipeline and worked with PMs and developers to track/report issues, define scope, and support system changes in PAS. Contributed to Active Directory migration through data entry and coordination with Client Services.

BI Reporting & Revenue Reconciliation:

Worked on Data Services by creating jobs per SAP Hana ad-hoc requests, analyzed large datasets for Waterfall comparison, and prepared bi-weekly revenue reconciliation reports for the FICO team (Jan–Aug 2015), supporting financial accuracy and audit readiness. Employer: VENIO LLC d/b/a KEANE - NYC, NY.

(Asset/Wealth Management – for Banks, Brokerages, Transfer Agents & Mutual Funds) Role: SQL Developer & Business/ Data Analyst - Production Support Duration: 10/2009 - 08/2014

ETL & Data Integration:

Loaded data from financial clients (Banks, Transfer Agents, etc.) using ETL processes, working with diverse data sources (Excel, Access, SQL Server, CSV, Flat Files). Automated SSIS 2012/2008R2 package execution via SQL Server Agent; supported legacy DTS processes and transferred data across SQL Server versions (2000–2012). Created Hive tables and loaded data into HDFS using AWS for test runs.

Database Development & Reporting:

Designed database objects such as tables, views, stored procedures, and triggers for analysis. Created and deployed over 20 SQL Server Reporting Services (SSRS) reports (2008R2/2012) for internal, departmental, and executive use, resulting in $1M in saved revenue and 40% reduction in report processing time. Supported marketing and audit teams with automated exception and weekly reports.

Data Quality, Analysis & Financial Reconciliation: Conducted detailed SQL analysis and batch/online testing for production and disaster recovery environments. Ensured accurate data exchange between systems by aligning with data mapping specs, transforming data from EDW to SQL Server fact tables. Conducted financial reconciliation for Corporate and Mutual Fund issuers and performed Fund Merger/Corporate Action analysis for inventory management.

Audit & Compliance:

Acted as lead contact since 2009 for on-site SSAE 16 II external audits at the NY office. Conducted walkthroughs with auditors and successfully completed both Type I and Type II level exams, confirming internal controls and operational effectiveness over six consecutive calendar months.

Application Support & CRM Systems:

Provided support and troubleshooting for internal MS CRM applications workflow management tools. Created business rules, performed advanced data source views for quality and business analysis, and worked on backend logic to support business applications by doing requirements gathering, design discussions, and technical document reviews.

Training, Migration & Ad Hoc Projects:

Played a key role in the migration of business processes from NY to PA, including coordinating testing, documentation, and training sessions for Data Analysts, BAs, and Relationship Managers. Created macros and ad hoc queries using SQL/Access to support executive leadership requests, ensuring efficient data retrieval and accuracy.

Project/Client: EQUISEARCH, Inc. - White Plains, NY

(Asset/Wealth Management – for Banks, Brokerages, Transfer Agents & Mutual Funds) Role: Software Developer

Duration: 07/2006 - 09/2009

ETL Development & Data Integration:

Created initial ETL packages to integrate financial data from external files received from financial clients, using SSIS 2008R2 and SQL Server Agent for automation. Designed data sourcing and built data source views and flows to support ongoing data mining and analysis.

Database Design & Development:

Developed tables, indexes, stored procedures, functions, and triggers in SQL Server 2000/2005 environments. Created and maintained DTS packages for server-to-server data transfers, ensuring efficient data flow and robust back-end support.

Testing & Quality Assurance:

Created test plans, test cases, and test scripts to validate systems for data corruption and SQL errors. Reviewed developer SQL code for adherence to best practices and client standards, documenting bugs and ensuring data integrity.

Reporting & Business Intelligence:

Used SSRS 2008R2 to build reports based on business and client requirements, including identifying and configuring report parameters. Supported marketing teams with data needs and managed change requests (CRs) related to marketing systems.

Audit & Compliance:

Participated in SAS 70 (Type II) audits in 2007 and 2008 by conducting system walkthroughs with external auditors. Ensured documentation and processes were aligned with audit requirements and internal controls.

Stakeholder Coordination & Application Support:

Collaborated with IT teams from various Transfer Agents to understand business needs and configure database objects accordingly. Provided application support for internal users of the Equisearch Services platform, working closely with Accounting, Sales, and Research teams to implement and maintain effective business rules.

Project/Client: BERLITZ INTERNATIONAL - Princeton, New Jersey Role: Software Developer

Duration: 04/2006 - 06/2006

Berlitz International is a company that works as a source needed for effective language instruction, whether for business or personal enrichment.

Involved in the Designing & Development using C# interface for LDAP database using Novell Netware & .Net technology with the Onsite/Offshore model, developing the site using Microsoft Content Management 2001

Developed Scripts for replicating the data from Sybase Database to SQL Server Database.

Performed SQL Backup and Restore tasks on Various SQL Servers. NON-US WORK EXPERIENCE

PRUDENTIAL (PPMS) UK. India. Aug 2005 - Feb 2006

Software Developer & Tester

ORREX TRANSPORT PVT LTD. Jun 2005 - Jul 2005

Programmer Analyst

PRUDENTIAL (PPMS) UK. India. Oct 2004 - May 2005

Jr. System Administrator

VMCI. India. Dec 2001 to Dec 2003

Developer / Training & Documentation Specialist

Contact this candidate