Support Analyst Business

PRATHYUSHA PATINJARYIL

862-***-**** **************@*****.***

SUMMARY:

•Over 12 years of extensive professional experience in various capacities including Analysis & Design, Development, and Maintenance of Web Based Business Applications using cutting edge software solutions with roles including Lead Applications Developer and Sr Business Analyst

•Proficient in validating requirements, analyzing process flows, and leveraging AI tools such as Microsoft Copilot.

•Proficient in using UML for Business Process Modeling, Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Collaboration Diagrams, Class Diagrams and document them using MS Visio.

•Strong expertise in creating test cases in JIRA based on product features, client requirements, and technical documentation.

•Developed, executed and maintained Test Scripts. Reviewed and documented system Test Plans.

•Worked on different SDLC Methodologies including Waterfall and Agile and Automated QA tools like Load-Runner.

•Experience in writing complex SQL queries and optimizing the queries in Oracle, and SQL Server.

•Experience in Data-Driven Applications, Enterprise Applications & Business Integration, and N-Tier Application architectures.

•Good knowledge of OO Programming Methodologies and Design Patterns .

•Expertise in developing applications using C#, ASP.NET, ADO.NET, Visual Studio.NET, XML Web Services, Ajax and JavaScript, PHP.

•Extensive experience in conducting Data Analysis, Data Mapping, Data Profiling, Gap Analysis.

•Good knowledge in Data Modeling; Proficient in Oracle, SQL, PL/SQL, and T-SQL

•Excellent skills in analyzing user’s requirements, modeling the system, and ensuring the functionality, with client satisfaction as the primary focus

•Able to effectively converse, relate and liaise with multifunctional teams, including business owner, stake holders, mangers, architects, developers and testers at all levels.

EDUCATION:

•Certified Product Owner Scrum Professional (CPOSP)- Sep 2022

•Masters in Computer Science, University of Houston- Clear Lake, Houston, TX

•Bachelors in Computer Science, Mahatma Gandhi Institute of Technology, India

TECHNICAL SKILLS:

Methodologies

SDLC, Rational Unified Process, Agile Unified Process, Joint Application Development JAD

AI Productivity Tools

Microsoft Copilot (MS Visio, MS Word, MS Project, MS Excel).

Databases

SQL Server 2000/2005/2008, DTS, Oracle 8i/9i, MS Access 2000-2007, MySQL

Testing Tools

Win-Runner, Quick Test Pro, HP ALM & SOAP

Rational Tools

Rational-Rose, Requisite-Pro, Clear-Case, Clear-Quest and Test Mgr.

Requirement Gathering Tool

VISIO, JIRA, BALSMIQ WIREFRAMES, LUCID CHARTS. RACI CHART.

Operating System

UNIX Solaris, Linux, & Windows NT/2000/XP

Development Tools

Toad & Aqua Data Studio, Infosphere, SharePoint, Visual Studio 2005/10, ASP.net, C#

Deployment Tools

Active Directory

Reporting Tools

PULSE, Zoho Analytics.

PROFESSIONAL EXPERIENCE:

Corporate Client: ImageFIRST Healthcare Laundry Specialists.

Role: Sr Business Analyst February 2023 –Sep 2025

Job Duties:

•Contributed to the Digital Transformation Phase 1 initiative, focused on transitioning from ADP systems to the Dayforce HRIS system.

•Led data migration efforts for multiple Dayforce-integrated applications, including Concur, Principal and Cornerstone On Demand, ensuring seamless transition and system interoperability.

•Completed administrative training for Dayforce systems, gaining hands-on expertise in configuration, user management, and operational workflows.

•Collaborated with HR and Payroll teams to support the successful implementation of Dayforce, ensuring accurate data migration and system configuration aligned with organizational policies.

•Worked cross-functionally with HRIS teams to resolve payroll data mapping issues and streamline employee record transitions.

•Led requirements gathering through stakeholder interviews, SME consultations, and collaborative workshops in Sales & Service.

•Developed process documentation including Visio diagrams, Balsamiq wireframes, and Lucid chart, RACI Chart workflows to support system design and validation to capture current processes.

•Assess current vs. future state to uncover inefficiencies and improvement opportunities for new Salesforce CRM.

•Define and validate business rules, workflows, and conditional logic for system enhancements for the new CLM.

•Worked on Traceability Matrix Creation – Ensuring requirements are linked to test cases and business objectives for validation and auditability.

•Creating JIRA userstories from service desk tickets and stakeholder requirements.

•Facilitating prioritization meetings with senior leadership from Sales and Service departments to align on ticket resolution and strategic issue management.

•Authored and executed SQL scripts to generate usage reports, enabling data-driven decision-making across business units.

•Collaborated cross-functionally to ensure alignment between business needs and technical solutions.

•Collaborate with teams to ensure smooth adoption of new systems and processes.

•Worked on Executive-Level Reporting by Summarize findings and recommendations in concise, decision-ready formats for leadership.

•Completed specialized training in medical terminology to support healthcare laundry-related operations.

Corporate Client: 1-800 Spirits.

Role: Sr Business Analyst February 2019 –Sep 2022

Job Duties:

•Working with sponsor of the project to develop project roadmap

•Gathering & documenting business requirements to provide inputs to solution & technical architects of the project.

•Decomposing requirements to business processes, entities, operations and activities performed by personas across different functional modules.

•Documenting & optimizing customer journeys, merchant journeys, and Internal operations journeys

•Created data for customer and sales facing tool by combining data from various sources using SQL.

•Designing dashboards for business analytics.

•Setup customer support model to ensure – Self-service, collaboration, and constant improvement in call deflection rates.

•Worked with Office 365.

•Developed Test Cases and SQL Queries to perform various Validations.

•Understand and evaluate best suitable integration choices to bring in capabilities, and help engineering team with Merchant Payments, Location Services, Shopping cart as service

•Reviewing system, data, and integration architectures for to meeting current requirements and future proofing.

•Defect Reporting and Defect Tracking using Jira.

•Preparing test cases for functional testing.

•Assisting Quality engineers of the team with automating regression testing.

•Participate & contribute in developing checklist for deployment.

•Collaborate with Program management team to prepare release and rollout plan.

Corporate Client: King & Cardinal Bakers and Confectioners

Role: Sr Business Analyst January 2015 – December 2017

Job Duties:

•Gathering Business requirements and specifications from Clients to document and determine the functionality of the application.

•Preparing test case scenarios.

•Implementing Agile Work environment for Project accomplishment.

•Conducting bi weekly sprint meetings with developers and line of business.

•Designed visually enhancing ecommerce website for online cake delivery for Bakery.

•Made Analysis of the entire website workflow after taking requirements.

•Managing a team of 6 developers in offshore location.

•Worked on creating the Presentation, Business layer and Data Access Layer thereby generating a 3-tier architecture application.

•Designed new Database schema structure along with re-creating stored procedures and functions in SQL Server 2008.

•Was solely in charge of deploying the source code to both beta and test environment servers.

•Created Admin modules for the application for users to mark cake delivery completion.

Corporate Client: Citizens Bank, RI

Role: Sr Business Analyst / Data Analyst May 2012 – October 2013

Job Duties:

•Working with large data sets for analyzing data.

•Analyzing business requirements and design specification document to determine the functionality of ETL processes participating in test strategy and test plan preparation.

•Preparing Test Plan and Test Cases based on business requirements and functional specifications on QC and upgrading.

•Used Storyboard/Flowchart to illustrate navigation between various pages in the application website.

•Preparing requirement traceability document.

•Used MS Office suite components for project tracking, documentation, and presentation to senior management including SharePoint.

•The conduit for the Risk Data Platform (RDP) and represented the RDP on a larger scale with customers and stake holders' information.

•Designed and implemented basic SQL queries for testing and report/data validation.

•Involved in mapping efforts to revamp the entire mapping documentation of all the 16 downstream data feeds.

•Involved in the Comprehensive and data quality Analysis and Review (CCAR) to map the required fields to our database to ensure data quality and standardization.

•Developed Project Status metrics for weekly evaluation of Project Status and impact of the Change Request on the time line.

•Preparing test scripts, test environments, and test data for testing.

•Executing the test cases using sample source documents as inputs and ensuring that the outcomes of the tests are recorded.

•Wrote SQL scripts extensively to identify data quality and integration issues.

•Performing the necessary regression testing and reporting new issues.

•Part of the triage team to analyze and prioritize the defects.

•Initiated, developed and created defect score card template and score cards for scoring and categorization of all defects.

•Attending the daily defect triage meetings.

•Experience with the SOAP tool to perform back end functional testing on the DB to test application performance, response time & stability. Providing updates to management on testing status and issues.

Environment: MS SQL Server, Oracle 9i, ETL, MS Access, SSRS, MS Office, HP ALM, TFS.

Client: Softmart, Downingtown, PA

Role: Sr Business Analyst, Lead Software Developer March 2011 – November 2011

Job Duties:

•Gathered and collected requirements resulting in detailed business rules, functional requirements and process design.

•Created Wireframes to depict information, navigation and interface design of application.

•Prepared graphical depictions of use cases activity diagrams, system context diagrams, sequence diagrams, use case diagrams.

•Analyzed and identified system, data and process dependencies for upstream and downstream application data flow.

•Supported the quality assurance testing and ensured that business requirements were being addressed in the test plans.

•Concisely and effectively communicated business requirements to developers.

•Worked closely with data architects, developers, test managers, business stakeholders and project managers to achieve project objectives in defined time frames.

•Worked on Major UI design page layout using elements of CSS, HTML5.

•Analyzing business requirements and design specification document to determine the functionality of ETL processes participating in test strategy and test plan preparation

•Providing updates to management on testing status and issues.

•Preparing requirement traceability document.

•Worked on transitioning the current ASP ecommerce application into .NET.

•Also worked on incorporating new web pages from the scratch.

•Used Infosphere DataStage tool to create jobs that run against the central Softmart’s Data repository.

•Preparing test scripts, test environments, and test data for testing.

•Executing the test cases using sample source documents as inputs and ensuring that the outcomes of the tests are recorded.

•Performing the necessary regression testing and reporting new issues.

•Created scripts in TOAD for querying against Oracle Database.

•Preparing requirement traceability document

Environment: C#, ASP.NET 3.0, 3.5, HTML/DHTML, VB Script, JavaScript, CSS, MS SQL Server, TFS, Oracle 9i, ETL, Infosphere, DTS, MS Office, SharePoint, Load Runner

Client: Schlumberger, Houston, TX

Role: Business Analyst / Sr .NET Developer May 2008 – Jan 2011

Job Duties:

•Facilitated Joint Application Development (JAD) sessions by convening project sponsors, end-user representatives, development team members, subject-matter experts, technical personnel, and different stakeholders to communicate their perspectives with each other, resolve any issues and come to consensus.

•Conducted requirement workshops among all project stakeholders to verify and validate the business requirements.

•Conducted walkthroughs with end users, developers, managers and other analysts.

•Developed Project Status metrics for weekly evaluation of Project Status and impact of the Change Request on the time line.

•Assisted QA department to write and execute Test plans and Test Cases.

•Conducted User Acceptance Testing (UAT).

•Reporting of information and data management controls and quarterly assessments

•Worked in designing web pages for better efficiency overcoming performance issues.

•Incorporated Single Sign On (SSO) Design Analysis for this application

•Suggested better methods of data retrieval and implemented strong Object-oriented concepts.

•Worked closely with the field Users/ End Users to take inputs on the new requirements and enhancement requests after every new deployment of the application

•Used Load Runner in QA testing.

•Used IBM Rational Clear Quest for tracking bug fixes and compliance management.

Environment: C#, ASP.NET 3.0, ADO.NET, C#, HTML/DHTML, VB Script, JavaScript, CSS, MS SQL Server 2005, DTS, MS Office, Microsoft Visual SourceSafe, Load Runner

Client: Kinetic Concepts Inc (KCI), San Antonio, TX

Role: Jr Business Analyst, .NET Developer Feb 2008- April 2008

Job Duties:

•Assisted project managers with the development of project schedules. Developed requirements and preliminary design for client applications.

•Performed analysis and design projects using a systems development methodology.

•Worked on a major release fixing bugs and new implementations.

•Coding, Implementation and Testing of various web forms and Win forms.

•Built complex interface using Composite UI Application Block. Various parts of the disconnected version have multiple collaborating parts, each one addressing specific aspects of a business like, Events, Opportunities, or Therapies. These parts interact with different database servers. But they are integrated to provide a consistent user experience, share information between each other, and communicate to help the end user complete a specific task

•Worked on writing In-Line Oracle (PL/SQL) scripts.

•Involved in developing various stored procedures for different reports and web forms using

T-SQL.

•Worked on PL/SQL Developer for Oracle database and SQL Developer 2005.

•Used Query Design Command to build and run queries in MS Access 2007.

•Worked on Implementing Ajax Toolkit Panels for delivering efficient web forms.

•Used Share Point Server for information sharing and collaboration capabilities.

•Testing the Applications through Quality Check for error free installation

•Maintained a fully locked down environment and assigned permissions only where needed.

Environment: C#, ASP.NET 2.0, ADO.NET, C#, HTML/DHTML, VB Script, JavaScript, CSS, MS SQL Server 2005, DTS.

Client: JPMorgan Chase, Westerville, OH

Role: Jr Business Analyst, .NET Developer August 2007- Feb 2008

Job Duties:

•Worked closely with project manager to plan and implement all the programming phases.

• Coding, Implementation and Testing of various web forms.

•Analyzed and reported the data change to Line of Business.

•Involved in developing various stored procedures for different reports and web forms using T-SQL.

•Used ADO.Net objects for data retrieval and database updates.

•Developed a SQL Server 2005 Data Transformation Services (DTS) package to execute some tasks.

•Applied JavaScript and VBScript to validate user inputs at server side and client side.

•Assisted in developing a Windows Service Application for the project.

•Modified and improved applications according to users’ feedback.

Environment: C#, ASP.NET 2.0, ADO.NET, C#, HTML/DHTML, VB Script, JavaScript, CSS, MS SQL Server 2005, DTS.

Contact this candidate