Sql Server Client Communications

Stuti Praveen Katuri

Ph: - +1-704-***-****

Email ID: - *************@*****.***

LinkedIn: - www.linkedin.com/in/stuti-praveen-katuri-26641434b

Pega PDN: - https://accounts.pega.com/profile/PraveenKat

Professional Summary:

Over 13 years in IT along with 8 years of specializing, in Pega BPM applications, including PEGA PRPC versions 7.x, 8.8.x.

Defined business strategies, system architecture, and translated requirements into technical specifications.

Managed requirement gathering, use case development, project scopes, and client communications.

Designed architecture improvements, optimized software and database development, and implemented interface enhancements to improve system usability and performance.

Developed and integrated workflows, rules, decisions, activities, agents, and various services (SOAP, REST, JMS, SQL), including designing and enhancing system interfaces for seamless service integration.

Utilized J2EE technologies, including Web services, Spring, Hibernate, and JDBC.

Implemented PEGA frameworks, situational layer cake, and custom interface designs across domains like healthcare, banking, and financials.

Experienced with PEGA Platform tools such as Dev Studio, App Studio, Predictive, and Admin Studio.

Debugged and troubleshot applications using tools like Tracer, Clipboard, DB Trace, AES DB, and Dynatrace.

Hands-on experience in Pega UI, Constellation, Java, JavaScript, HTML, CSS, AJAX, and authentication methods (SSO, RBAC, ABAC, CBAC), with a strong focus on enhancing user interface functionality and accessibility.

Performed data modeling, integrated and queried databases such as Postgres, Cassandra, Oracle, SQL Server, and IBM WebSphere, Linux, Java, Oracle, and MySQL.

Knowledgeable in KYC/CRM/CPM/SD frameworks.

Worked with CI/CD tools, including Pega Deployment Manager, PEGA Cloud; conducted code reviews to ensure high-quality interface development and maintenance.

Extensive experience with PEGA Cloud, PEGA 8.1, PRPC 7.x, PEGA Smart BPM, and Direct Capture of Objectives (DCO).

Implemented PEGA, case lifecycle design, Agile methodologies (SAFe), and interface enhancements for scalability and usability.

Implemented full life cycle development, BPM application design, and large-scale BRE applications.

Skilled in Pega BIX reporting, API integration, file storage, secure file transfer technologies, and Business Process Management.

Production monitoring & Support deployments by collaborating with the operations team.

Triage and resolve alerts or issues that arise during 24x7 production support.

Contributed to the continuous improvement of deployment processes and procedures, including refining system interfaces for better operational efficiency.

Technical Skills:

BPM Suite:

PEGA PRPC, 7, 8.8, Pega v8, Case Management, Pega Customer Service Framework.

RDBMS:

Oracle, MySQL, SQL Server.

API’s & Integrations

SOAP/REST Connect & Services, JMS, Dx API’s, Security, and Interfaces

Language:

C#, Java, SQL

Web Technologies:

HTML, XML, Java Script, SOAP, WSDL. Application Server: Tomcat, WebLogic

Tools:

JIRA, TOAD, SQL Developer, Rally, Postman, Soap UI

Methodologies:

Agile/Scrum, Hybrid Agile, Waterfall

Operating Systems

Windows, Unix/Linux (Red Hat).

Educational Qualification and Certifications

M. Pharm. (Pharmaceutical technology) from Andhra University, Visakhapatnam, India.

B. Pharm from Malineni Lakshmaiah college of Pharmacy, Archarya Nagarjuna University, India

Certified System Architect (PCSA) in PRPC (7.1)

Certified Senior System Architect (PCSSA) in PRPC (7.4)

Professional Experience:

Pega Developer Sep 2024 – Till Date

Regions Bank-Birmingham, AL

Project Description: Regions Bank, in partnership with Pega systems have implemented PRPC and Smart Investigate for Payments Framework as the foundation for its Global Payments Investigations (GPI) programme, which is to provide Regions Bank with Global Payments Investigation capability. The core objectives of the GPI programme are to

Enable support of internal investigators for external customers

Deliver excellence in client service to Regions Bank external clients

GPI was built as a generic, easily deployable solution, which has the propensity for localization on an OU by OU based payment systems and accounting solutions differ from country to country. Operating Units, which are yet to migrate to GPI, currently have more functionality rich systems. But the systems are dated and severely limited in terms of scalability, the main among them is the US. As a part the programme of consolidation, the next phase of GPI is to implement the Advanced Functionalities of the Payments Investigation System to onboard the larger OUs in US and UK.

Responsibilities:

Development of the application enhancements based on the user stories assigned.

Defect and Bug fixing for the existing application.

Involved in the Business Requirements discussion and grooming the user stories for the future sprint.

Worked with Product Owners and Business Analyst on user stories and identifying the gaps between the requirements.

Worked on deployment changes using automated tool CICD.

Analysed Pega logs and WAS logs and having knowledge on Debugging and Tracing.

Fixed the high priority issues within the timeline Analysing the Business Requirements and Technical Requirements.

Created Activities Validations and Flow Actions for implementing core business logic.

Providing temporary work around in case of any concern.

Involved in preparation and execution of unit test cases.

Extensive experience in managing Pega platform upgrades, applying patches, and ensuring smooth

transitions to new versions while maintaining system stability and performance.

Automated email correspondence within business flows using Data-Email accounts to enhance

communication.

Developed REST integrations, data pages, and rules (e.g., system settings, DSS, decision tables, data transforms, report definitions) to enhance application functionality and streamline processes.

Developed job schedulers, extracted rules, and file listeners for seamless data extraction and transfer from Pega Cloud.

Supported production deployments and issue resolution.

Environment: Pega PRPC V8.8., Postman, Kibana

Pega Senior Developer Jun 2023 – Mar 2024

Sonata software Limited- India.

Project Description: The Next Generation Warranty Claims is PACCAR's in-house solution for managing warranties, claims, and inspection records. It serves PACCAR dealers and internal users across three US divisions (Kenworth, Peterbilt, KenMex).

Responsibilities:

Design and Development: Utilize Pega Rules Process Commander (PRPC) to design and develop according to the business requirements.

Involved in Effort Estimation of user stories targeted for a sprint.

Planning the deliverables in phases and allocating work to the team members and the coordinating with the other project stake holders.

Interacted with Business Analysts and Users to understand the business needs and requirements.

Involved in the design and development of Class Structure, Properties, Flow actions and Process Flows.

Designed and Created Data Model, Workflows, Sections, Flow actions, Activities, Activity Step Methods, Flows, Harness rules, Decision rules and Declarative rules.

Created Activities, Access groups and Access Roles, Decision Rules, SLA’s, Activity Rules, and Reports.

Debugged applications using Pega Tracer, Clipboard, and PAL.

Utilized Postman, Connect REST & Rest Services for simulation testing.

Implemented with Database Integration using Oracle, SQL.

Prepared and executed unit test cases.

Supported production deployments and issue resolution.

Resolved high-priority issues within deadlines based on analysis of business and technical requirement

Environment: Pega PRPC V8.4.6.

Pega Developer Aug 2021 – May 2023

Infosys - Telenet - India

Project Description: Telenet Group is the largest provider of cable broadband services in Belgium. Its business comprises the provision of analog and digital cable television, fixed and mobile telephone services, primarily to residential customers in Flanders and Brussels. In addition, Telenet offers services to business customers all across Belgium and in Luxembourg under its brand Telenet Solutions.

The application enables Telenet ADT strategy to transform customer service experience to drive higher customer satisfaction and efficiency across operations. The scope of this program is to enable systematic data integration with various Telenet systems to enable overall automation and improve average handle time for service requests.

Responsibilities:

Collaborated with business analysts and stakeholders to refine requirements, align them with business goals, and ensure interfaces met usability standards.

Involved in Effort Estimation of user stories targeted for a sprint.

Prepared technical design documents, user training materials, and provided post-implementation support.

Mentored a team of developers, assigning tasks and ensuring adherence to Pega best practices, particularly in interface design and integration.

Communicated technical updates and project progress to stakeholders.

Configured PSO workflows to handle single-fill and lifetime orders with delivery scheduling, incorporating enhanced user interfaces for order tracking.

Managed workflows for patient demographics, therapy records, and interaction handling with dynamic interface components.

Designed modular REST API integrations for data retrieval and updates, ensuring scalability and reusability, while enhancing the API response interface for better clarity and functionality.

Built backend logic for business processes using job scheduler and queue processors.

Configured decision rules, activities, and data transforms for seamless patient interaction flows, including updates to improve interface responsiveness.

Debugged and conducted performance testing using Rules Inspector, DB Tracer, PLA (Pega Log Analyzer), PAL (Performance Analyzer), and PDC.

Enhanced patient interaction views with dynamic sections for demographics, addresses, and contact details, focusing on accessibility and ease of navigation.

Improved the efficiency of data fetching and processing using optimized rules and pre/post-processing transforms, ensuring smoother interaction flows within the user interface.

Environment: Pega PRPC V8.7, Swagger, Postman

PEGA Support/Developer Dec 2018 – Feb 2021

Optum global solution – UHC, India.

Project Description: PhyCon Provider Termination project is for OPTUM to be able to create, submit, execute & track the requests End-to-End for Provider Terminations received from different channels. The request can be for multiple individual providers or multiple groups of providers (single record) or a combination.

The PhyCon solution focuses on Contracting, Data Maintenance and Termination transactions. To create a single, end-to-end solution to support physician contracting operations and provider data maintenance through improving processes and creating one common, end-to-end workflow tool using Pega.

Responsibilities:

•Production deployments of new application/enhancement/defect fixes and maintaining proper documentation (Approach Doc, Design Doc, KT Doc etc) to ensure Quality standards and for overall project benefits.

•Monitoring the various aspects of Production System (batch processes, log analysis, etc) and fixing production issues.

•Involved in efficient client communication to understand the business objective of various issues faced by client in the production environment and to come up with an optimum solution to fix it.

•Prepared technical design documents, user training materials, and provided post-implementation support.

•Communicated technical updates and project progress to stakeholders.

•Enhanced patient interaction views with dynamic sections for demographics, addresses, and contact details, focusing on accessibility and ease of navigation.

•Improved the efficiency of data fetching and processing using optimized rules and pre/post-processing transforms, ensuring smoother interaction flows within the user interface.

•Designed modular REST API integrations for data retrieval and updates, ensuring scalability and reusability, while enhancing the API response interface for better clarity and functionality.

•Built backend logic for business processes using job scheduler and queue processors.

•Debugged and conducted performance testing using Rules Inspector, DB Tracer, PLA (Pega Log Analyzer), PAL (Performance Analyzer), and PDC.

•Improved the efficiency of data fetching and processing using optimized rules and pre/post-processing transforms, ensuring smoother interaction flows within the user interface.

Environment: Pega PRPC V7.4

PEGA Test Coordinator Apr2016 – Dec 2018

Optum global solution – UHC, India.

Project Description: - PBM offers comprehensive pharmacy benefit services, including formulary management, inventory control, and claims processing, to over 10 million members nationwide, with a focus on optimizing system interfaces for enhanced usability and operational efficiency.

Responsibilities:

Involved actively working with Dev team for the defect life cycle and understanding the technical impacts of the fixes.

Analyzed the requirement/technical specification, business requirement and Functional documents and created detailed Test plan and Test Cases associated with the appropriate requirements.

Used Quality Center to create test cases, execute in test lab, log identified defects and retest defects once development team fixed.

Performed peer-to-peer review of test plan, test cases, test conditions, SQL script and logged defects.

Updated QA test status and submitted progress reports as appropriate to top management.

Validating the input data on Retail Renewal System and verify the members terminated in UnitedHealth Care system. Verifying reinstatement is not available for the members.

Successfully performed Test Management and created Test Strategy and Test plans.

Reviewed test cases, execution results/reports, defects and providing understanding of the application as needed to the team. Tracking the progress and maintaining deadlines and provided deliverables on time.

Involved in pointing User stories, designing test scenarios, performed execution, test data creation and defect management in environments like System & Integration Test, UAT and production for a cloud base application, web based and supported data migration process.

Environment: Pega PRPC V7.1, Performance Analyzer

Quality Analyst tester Jan 2013 – Apr 2016

United Health Group- India

Project Description: HealthCare Insurance - OptumRx, part of UnitedHealth Group takes care of the Pharmacy Benefit Management of the members who opted for Pharmacy services in their health plans. Being a part of OptumRx team, I have been working with several applications that support PBM services.

Responsibilities:

Analyzed functional specifications for AS/400 applications and identified opportunities for interface improvements.

Assisted with EHR and EMR issues using practice management solutions, focusing on improving interface alignment with healthcare standards.

Collaborated with teams to identify and implement enhancements to claims and benefits processing interfaces for improved user interaction and efficiency.

To perform the Quality Audit of the projects implemented based on the applied logic of Rx claim Pharmacy claim adjudication system. Analyze the benefit requests, review the quality and secure all necessary data to ensure appropriate.

Responsible for the configuration of RxCLAIM in order to support Pharmacy Adjudication by testing Plan Benefits, maintaining Drug Formularies, Member & Client records and pharmacy pricing.

Worked with client management to Implement new and maintain existing test cases for benefit plans and client pricing in the pharmacy claim adjudication system.

Maintain acceptable and appropriate Quality levels and production turnaround time.

Respond to internal inquiries regarding adjudication and/or system capabilities.

Proficient knowledge of US Health care provider Domain & familiar with facility & physician medicines processing.

Defect analysis and reporting.

Environment: AS400

Software Tester Apr 2011 – Dec 2012

Infotrack System- India

Project Description:

NASCO is a healthcare technology company dedicated to co-creating digital health solutions for

Blue Cross and Blue Shield companies. BCBSM is a call center application used by CSR to verify members who are enrolled for policies/contracts.

Responsibilities:

Actively participated in business discussions.

Understanding functional specifications document, created test cases, test data and executed test cases to

perform GUI, Functional, Integration, Regression testing, back-end testing by executing SQL queries.

Identified defects and maintained the defect life cycle using Bugzilla tool.

Coordinated with development team and business analyst to verify the functionality of application.

Environment: Bugzilla, tSQLt

Contact this candidate