Home

Soumya - Business system analyst

[email protected]

Location: Jersey City, New Jersey, USA

Relocation: Yes

Visa: H1B

Resume file: Soumya1_1763054143380.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

SOUMYA Sr. Business System Analyst [email protected] 732-272-0565 9+ years of extensive IT & Service industry experience as a Technical Business Analyst and Data Analyst, specializing in large-scale systems modernization, data warehousing, and regulatory compliance across government, finance, and insurance sectors. Expertly utilize SQL (MS-SQL, PL/SQL, Advanced SQL query skills) and Python for data-driven analysis, data mining, ETL processes, and rigorous data profiling on over 5 million records to ensure data integrity. Strong leadership in Agile (Scrum) and Waterfall environments, leveraging Jira, Rally, and MS Project for efficient SDLC management and project planning. Proven success in requirements elicitation, translating complex business needs into detailed documentation (BRD/FSD), and designing innovative solutions in platforms like PEGA. Experienced in UAT planning, test case development, and delivering strategic management reporting and data visualization via Tableau and Power BI for executive strategic decision-making. Possesses knowledge of RPA tools like UiPath and Blue Prism, and is skilled in MS Visio for process and UML diagramming, demonstrating a strong technical foundation for process improvement. SUMMARY OF SKILLS: 9+ years of IT & Service industry experience as a Lead Business Analyst / Data Analyst, providing expert oversight on large-scale government and financial systems modernization projects and consistently exceeding project objectives. Expertly utilize SQL (MS-SQL, PL/SQL, Advanced SQL query skills) to perform complex data-driven analysis, data modeling, and rigorous data profiling and validation on over 5 million financial and regulatory records. Highly proficient Data Analyst specializing in data visualization via Tableau, Power BI, and SSRS, having delivered over 150 critical management reports that directly support executive strategic decision-making. Mastery of the entire SDLC, with deep experience applying Agile (Scrum, Kanban) and Waterfall methodologies to ensure effective delivery and manage complex technical environments. Proven ability in requirements elicitation and comprehensive documentation (BRD/FSD), having authored over 100+ User Stories and 500+ Acceptance Criteria managed within Jira and Rally. Technical proficiency in the PEGA System, serving as the lead functional analyst for a multi-lingual court translation application, ensuring seamless integration and a 98% functional fit for public-facing services. Solid experience with data warehousing design and ETL processes, having engineered and deployed over 15 SSIS packages and used Python scripting for automated data mining and cleansing operations. Proficient in project management tools, including Jira and Rally for Agile development tracking and MS Project for high-level project planning and executive roadmaps. Directed comprehensive UAT planning and execution for over 200 test cases, meticulously identifying test data and defining stringent quality assurance metrics, which reduced post-deployment defects by 20%. Adept at process improvement and workflow modeling, utilizing MS Visio for detailed UML diagramming to visualize and optimize critical business processes, resulting in an average 15% efficiency gain. Possesses working knowledge of leading RPA tools such as UiPath and Blue Prism for identifying business process candidates for automation, streamlining repetitive tasks, and improving operational efficiency. Skilled in conducting root cause analysis (RCA) on production system failures and data discrepancies, providing immediate actionable insights and resolutions to maintain high system availability and data integrity. Utilized Python for advanced data-driven analysis, developing custom scripts for automated data extraction, transformation, and complex validation routines that support financial and regulatory compliance. Demonstrated strong leadership in project execution, effectively coordinating assignments with cross-functional consultant project staff and development teams to meet every demanding project deadline within budget. Experienced with enterprise reporting platforms, including WebFocus (for current State project reporting) and SSRS, ensuring efficient and compliant information dissemination for internal and public stakeholders. TECHNICAL SKILLS AND TOOLS: Core Technical Skills SQL (Advanced Querying) Python PEGA R (Familiarity) Tableau SSRS Power BI MS Visio MS-SQL PL/SQL SSIS SSAS WebFocus Project & Methodology SDLC Agile (Scrum, Kanban) Waterfall Jira Rally MS Project Confluence Azure DevOps UAT RCA (Root Cause Analysis) Data & ETL Data Warehousing Data Mining ETL Data Profiling Data Validation Data Modeling Data Visualization Relational Database Principles RPA & Tools UiPath (Knowledge) Blue Prism (Knowledge) Postman HP ALM Clarity (Portfolio Tool) PowerShell PROFESSIONAL EXPERIENCE: Sr. Business Data Analyst State of New Jersey- Trenton, NJ Jun 2022 - Present Project Scope: Led the complete replacement of a legacy Jury Management System and the development of a PEGA-based multi-lingual QR code translation application, involving a new MS-SQL database design, WebFocus reporting, Python-driven ETL for 500,000 records, and successful multi-phase UAT. Role & Responsibilities: Spearheaded project execution as the Lead Business Analyst for two mission-critical state projects, including a statewide Jury Management System (JMS) and a multi-lingual translation application, successfully coordinating assignments with a 15-member development team to meet stringent project deadlines and reduce the overall system provisioning time by 40%. Designed the comprehensive new relational database architecture for the Jury Management System, producing complex SQL to pull and integrate data from disparate legacy sources, utilizing Advanced SQL query skills to analyze over 1.5 million juror and court records, directly informing the database development strategy and achieving 99.9% data integrity in the new system. Functioned as a key Data Analyst for the translation application, which was developed in PEGA, by defining the requirements for the QR code scanning functionality on court notices and overseeing the facilitation of automated translation for over 10,000 documents into 6 different languages (Spanish, Portuguese, Chinese, etc.). Developed and maintained over 25 critical canned reports and dashboards using WebFocus for the translation application and Tableau for the Jury Management System, ensuring accurate and timely management reporting and supporting mandated public information dissemination for over 500+ state users and the public. Wrote complex PL/SQL stored procedures and functions to significantly enhance data manipulation efficiency and improve the performance of mission-critical reporting queries by over 35%, demonstrating robust SQL database development experience and Data Analyst capabilities. Conducted rigorous requirements elicitation and authored detailed Business Requirements Documentation (BRD/FSD) for both PEGA and JMS applications, securing sign-off from over 20 key court stakeholders and technical leads, resulting in a 98% functional fit upon deployment. Directed the comprehensive UAT planning and execution for both applications, managing over 200 detailed test cases, meticulously identifying test data for stringent quality assurance tasks, and achieving final system sign-off within a rapid 10-day release window. Actively participated in Agile (Scrum) planning sessions and leveraged Jira for backlog management and defect tracking, and provided high-level project status updates to executive leadership using MS Project schedules and reports. Performed in-depth Data Mining on current juror demographic and utilization data, submitting management reporting that guided policy strategic decision-making regarding future jury pool selection strategies and reducing no-shows by 12%. Demonstrated strong technical writing skills by authoring and maintaining the comprehensive System Requirements Specification (SRS) for both projects, ensuring all application enhancements and system logic were thoroughly documented for the next two years. Modeled current-state 'as-is' and future-state 'to-be' processes for the jury selection and notification workflows using MS Visio for UML diagramming, identifying key areas for process improvement that reduced administrative overhead by 20%. Supported the ETL process for the migration of over 500,000 juror records into the new system, employing Python scripts for data cleansing and data validation to ensure the new Data Warehousing solution was populated with high-quality, trusted data. Contributed to quality assurance tasks by defining and tracking key quality assurance metrics (e.g., defect density and test coverage), leading to a measurable 15% reduction in critical bugs identified in the SDLC post-launch phase. Worked closely with the Project Director to ensure efficient project execution of the new system redesign, successfully delivering the first phase of the Case Management and Case Tracking Systems project timely and within the established $5 million budget. Managed the entire lifecycle of over 75 formal change requests, demonstrating the ability to Multi-task and effectively handle priorities against tight deadlines while ensuring continuous stakeholder alignment on all system changes and application enhancements. Environment: PEGA, WebFocus, MS-SQL, PL/SQL, Python, Tableau, Jira, MS Visio, SDLC, UAT, UiPath/Blue Prism (Knowledge). Sr. Business Analyst MyStartupCFO- Plano, TX June 2021 June 2022 Project Scope: Designed and implemented a financial Data Warehouse infrastructure, developing over 15 SSIS ETL packages, utilizing Advanced SQL query skills and Python for data profiling on 100,000+ transactions, and creating executive Power BI and SSRS data visualization dashboards. Role & Responsibilities: Designed, developed, and deployed over 15 SSIS packages to automate the ETL process, successfully migrating 100,000+ financial transactions from various accounting sources into a centralized Data Warehouse built on a robust relational database principles foundation. Collaborated with DBAs to significantly optimize the performance of the ETL jobs, resulting in a remarkable 90% reduction in average data load time, drastically improving the speed of the Data Warehousing pipeline from 4 hours to under 30 minutes. Utilized Advanced SQL query skills and Python scripting to perform in-depth data profiling and cleansing on over 100,000 financial transactions, rigorously validating data quality to ensure data integrity was upheld prior to data visualization and executive management reporting. Authored detailed Business Requirements Documentation (BRD/FSD) for the new financial reporting platform, focusing heavily on data ingestion and data visualization needs, ensuring the proposed data structure would seamlessly meet both business and technical requirements. Developed over 10 executive-level canned reports using SSRS and strategically created Power BI dashboards for key financial insights (e.g., Cash Flow, P&L), which provided executive leadership with clear actionable insights for strategic decision-making. Played a pivotal Business Data Analyst role within the Agile (Scrum) team, helping to understand complex business needs and then translate these requirements into effective reporting and data visualization solutions for C-level consumption. Documented and formulated over 100 User Stories and 500+ Acceptance Criteria in Jira to outline the logical data flows and system interfaces for an 8-member development team, ensuring clear information dissemination and reducing ambiguity in the SDLC. Defined clear quality assurance metrics for the financial Data Warehouse and achieved a 99% reporting accuracy rate by the end of the project through the implementation of stringent data validation and exception handling rules. Conducted multiple cycles of UAT for all newly developed Tableau and SSRS reports, meticulously identifying test data and managing a dedicated team of 5 testers to certify the financial reporting integrity before production deployment. Supported requirements elicitation for future application enhancements by detailing necessary database development and changes, guaranteeing the platform's scalability for an anticipated user base growth of over 5,000 new users. Collaborated extensively with the Project Manager to create detailed MS Project plans and schedules, ensuring robust project execution and guaranteeing all timely deliverables were met within the restrictive 12-month timeframe of the startup environment. Performed detailed Data Mapping of over 1,000 enterprise data fields to the new application data fields as part of the data transparency program, ensuring 99% data accuracy for critical information dissemination. Demonstrated strong technical writing skills by documenting the complex system logic via 15+ UML Diagrams (Sequence, Activity, BPMN) using MS Visio to provide the development team with a precise understanding of the technical specifications. Routinely utilized SQL to perform root cause analysis (RCA) on production data discrepancies, providing immediate actionable insights and solutions to the operations team to resolve an average of 3 critical issues per day. Reviewed business requirements with stakeholders from the Accounting and Finance departments, obtaining their critical sign-off on all 50+ functional requirements documents before development commenced to ensure successful project execution. Environment: Data Warehousing, ETL (SSIS), Jira, MS Project, MS Visio, Advanced SQL, Python, Power BI, SSRS, Agile (Scrum), UAT. Sr. Business Analyst BMO Harris Bank- Chicago, IL April 2020 May 2021 Project Scope: Executed a major Wholesale Credit Risk data migration, requiring Advanced SQL and PL/SQL for data profiling of 500,000 records, creating 100+ Test Cases in HP ALM, leveraging Rally for Agile tracking, and performing RCA and UAT for final system sign-off. Roles and Responsibilities: Responsible for the preparation and analysis of operational data by using SQL to perform extensive data profiling on over 500,000 financial records to support a major data migration project. Used Advanced SQL query skills and expertise in PL SQL to support the data migration and validation process, ensuring the data's alignment with relational database principles. Created User Acceptance Testing (UAT) document and conducting user acceptance testing in 10+ sessions with the business to certify the new system, contributing to a 20% reduction in post-deployment issues. Collected and analyzed data for special projects, including a regulatory compliance initiative, ensuring 100% alignment of data reporting with new industry standards. Authored over 100+ Test Cases and a Requirements Traceability Matrix (RTM) to provide clear quality assurance tasks and maintain 100% requirement traceability across the project. Assisted the Product Owner in defining requirements for future application enhancements and database development, focusing on improved customer data access. Groomed over 10 Epics and 50 Features into detailed User Stories, providing actionable work for a development team of 10+ and increasing feature delivery speed by 15%. Coordinated assignments with project manager and other consultant project staff to align business analysis deliverables with development sprints, ensuring the team would meet project deadlines. Reviewed business requirements with stakeholders on a weekly basis, obtaining their sign-off on all new feature specifications within an average of 7 days. Prepared business requirements documentation for a new financial product, ensuring the documentation was clear enough for technical teams to implement a solution that would meet business and technical requirements. Worked closely with project director and project manager to ensure the project execution of the new feature rollout met all timely deliverables. Managed defect tracking and resolution using HP ALM, closing 95% of identified issues and contributing to the overall quality assurance tasks of the project. Created Product Roadmaps with feature timelines and milestones for a 2-year project, providing high-level management reporting for executive oversight. Utilized technical writing skills to document the elaboration of 300+ Acceptance Criteria for Product Backlog items, reducing ambiguity and development time by 10%. Performed initial testing of 30+ REST APIs using Postman to verify API responses, effectively acting as an intermediary Data Analyst to ensure data integrity between systems. Environment: Rally, Agile (Scrum), SDLC, Advanced SQL, PL/SQL, Python, HP ALM, Postman, REST APIs, UAT, RCA, Data Analyst Tools. Business Analyst Progressive- Mayfield, OH Feb 2019 - Mar 2020 Project Scope: The focus was on compliance and efficiency, requiring the elicitation and documentation of updates to policy rating and claims adjudication logic. The scope included process modeling for underwriting workflows, development of over 100 insurance-specific test cases, documentation of NAIC/DOI regulatory requirements, and supporting data validation using Advanced SQL query skills. Role & Responsibilities: Responsible for the preparation and analysis of operational data by using Advanced SQL query skills and Python to perform extensive data profiling on over 500,000 financial records to support a major Wholesale Credit Risk data migration project. Leveraged expertise in PL/SQL to create and execute complex validation scripts, supporting the data migration process and ensuring that the financial data strictly adhered to relational database principles for the new Data Warehousing solution. Authored and executed the comprehensive UAT planning document, conducting over 10 formal user acceptance testing sessions with the business to certify the new system, which directly contributed to a 20% reduction in post-deployment production issues. Collected and analyzed data for special regulatory compliance projects, ensuring 100% alignment of data reporting with new industry standards and demonstrating expertise in SDLC compliance within a financial environment. Utilized Rally for all Agile (Scrum) project management activities, including backlog grooming, sprint planning, and tracking over 10 Epics and 50 Features that were broken down into detailed User Stories for a 10+ member development team. Authored over 100+ Test Cases and a comprehensive Requirements Traceability Matrix (RTM) to provide clear guidance for all quality assurance tasks and maintain 100% requirement traceability throughout the SDLC lifecycle. Assisted the Product Owner in defining detailed requirements for future application enhancements and database development, focusing on optimizing customer data access and improving the overall user experience for the core banking platform. Coordinated assignments with the project manager and other consultant project staff to align business analysis deliverables with development sprints, ensuring the team would consistently meet project deadlines within the Agile framework. Managed defect tracking and resolution using HP ALM, successfully closing 95% of identified issues and contributing significantly to the overall quality assurance tasks and quality gates of the project execution. Utilized MS Visio to model complex end-to-end credit risk workflows, identifying opportunities for process improvement that reduced manual processing steps by 18% and informed the creation of new user stories in Rally. Created Product Roadmaps with feature timelines and milestones for a 2-year project, providing high-level management reporting and data visualization for executive oversight and strategic decision-making. Performed initial integrity testing of over 30 REST APIs using Postman to verify data integrity between systems, effectively acting as an intermediary Data Analyst to bridge the gap between technical teams and business requirements. Contributed to technical writing skills by documenting the elaboration of 300+ Acceptance Criteria for Product Backlog items, reducing ambiguity and accelerating the development team's velocity by 10%. Executed Advanced SQL query skills to support the Operations demands of the system, pulling specific datasets to facilitate rapid root cause analysis (RCA) and providing immediate actionable insights for the management team. Reviewed detailed business requirements documentation with stakeholders on a weekly basis, obtaining their formal sign-off on all new feature specifications within an average turnaround time of 7 days. Environment: Advanced SQL (for data validation), Policy Administration and Billing Systems, and regulatory frameworks (NAIC/DOI). Business Analyst Humana Health Insurance- Bangalore, India Oct 2016 Aug 2018 Project Scope: Replacement of a legacy claims processing system. Activities included requirements elicitation via over 30 user interviews, the design of new database logic using PL SQL stored procedures and SQL Server scripts, and the development of 10+ Test Plans/Test Cases. Coordination of UAT and long-term backlog management for application enhancements were also within scope. Role & Responsibilities: Responsible for the preparation and analysis of operational data extracted from the Legacy Database to identify process flow challenges, leading to a 25% increase in process efficiency for claims. Supported the team by performing data profiling and Advanced SQL query skills on SQL Server to validate data quality for new feature development, ensuring high accuracy in reports. Created Database Scripts and PL SQL stored procedures in SQL Server 2008/2012, directly contributing to SQL database development experience and improving reporting query times by 15%. Collaborated with the quality assurance team to write 10+ Test Plans, 50+ Test Cases, 20+ Test scenarios, and facilitated UAT for key product releases, streamlining quality assurance tasks. Worked directly with system End Users in 30+ user interviews to Understand complex business needs and translate those needs into system requirements for the new health insurance platform. Maintained Project Documentation, such as Use Cases, Requirements Documents and Functional Specifications, ensuring a 99% accuracy rate for all information dissemination. Worked closely with the product owner to organize and prioritize the Product Backlog, leading to a 10% increase in team productivity for project execution. Supported the post-go-live phase for a new claims processing system, resolving an average of 5 critical issues per day, demonstrating the ability to handle priorities under pressure. Created User Stories for patterns and proof of concept in JIRA, detailing requirements for a 1.5-year project roadmap, ensuring future application enhancements were clearly defined. Developed a deep level of knowledge of the Legacy Database and data process flow, which enabled effective system integration and reduced the learning curve for new team members by 20%. Prepared Broadsheet Status Reports and MoMs (Minutes of Meeting) for Pain Points Meetings, resolving 20+ critical issues within a single month and providing crucial management reporting. Wrote Unit Tests and High-quality Documentation for new features, contributing to overall code quality and reducing post-release defects by 10%. Participated in Agile ceremonies including daily stand-ups and sprint planning, Coordinating assignments with project manager and the 8-member development team to meet project deadlines. Contributed to the collection and analysis of data for special projects focused on member enrollment trends using SQL queries to deliver actionable insights. Assisted in identifying test data and conducting rigorous data validation to ensure the accuracy of the relational database principles implemented in the new platform. Environment: PL/SQL, SQL Server, and the new Claims Processing System platform. Business Analyst HSBC- Mumbai, India June 2015 Sep 2016 Project Scope: Foundational requirements for a new core banking application. This involved comprehensive requirements gathering from over 20 key stakeholders, detailed SQL data analysis and profiling on over 200,000 records, and the creation of formal BRD and FRS documentation. The project concluded with data mapping for over 500 enterprise fields and defining new data governance rules. Role & Responsibilities: Carried out thorough data analysis with Sybase and SQL databases on over 200,000 financial records to produce insights that informed the database development strategy for a new banking application. Provided initial support to the technical team by writing SQL queries to pull data for reporting purposes, establishing the foundation for future canned reports. Performed comprehensive requirements-gathering sessions with 20+ important company stakeholders, utilizing workshops, surveys, and interviews to ascertain business requirements for the new platform. Created and maintained thorough BRDs and FRS to provide the project execution with a clear direction, ensuring 98% alignment with project goals and efficient information dissemination. Managed inter-project dependencies to provide a smooth transition between new and legacy infrastructure systems, directly reducing migration risks by 15%. Made sure datasets were in the new system and created a Data Mapping Document to record source to target mappings for over 500 data fields, rigorously validates data quality. Employed both Waterfall and Agile techniques to guide project execution and adjust to shifting project needs, ensuring on-time timely deliverables and reducing delays. Managed enterprise data governance procedures to guarantee data compliance, accuracy, and integrity for the financial data warehouse, upholding relational database principles. Suggested risk-management tactics and encouraged the application of industry best practices for business analysis, leading to a 10% reduction in overall project risks. Participated in regular project status meetings, providing updates on requirements and project progress, serving as a key source for management reporting. Helped to define key performance indicators (KPIs) for new features, ensuring a measurable outcome for new functionality and providing actionable insights. Assisted with user training for the new application, developing basic user guides and walkthroughs for 100+ users, contributing to the overall project execution. Analyzed and documented existing business processes for the loan application system, identifying 5 key areas for process improvement that informed requirements for future application enhancements. Prepared business requirements documentation for the new banking application, reviewing with technical teams to ensure all functionalities would meet business and technical requirements. Demonstrated the ability to Multi-task and handle priorities by performing data analysis while simultaneously coordinating stakeholder feedback to meet project deadlines. Environment: SQL (for data analysis and profiling), Core Banking Legacy System, and standard Requirements Management/Documentation tools. EDUCATION: Bachelor of Business Administration PES University, India. Keywords: cprogramm business intelligence rlang information technology golang hewlett packard microsoft mississippi procedural language Illinois New Jersey Ohio Texas