SAKUNTALA VELCHURI

• The Mandated Reporter Application (MRA) is a secure web-based reporting system developed for Orange County’s Social Services Agency to streamline the legally required reporting of suspected child abuse, elder abuse, and dependent adult abuse. The system allows mandated reporters—such as educators, medical professionals, and law enforcement—to file, track, and manage their reports online after phoning the abuse registry.
• Developed the Admin Module with support for 5 distinct user roles, each having specific access permissions within the application.
• Implemented advanced search functionality for all three report types: BCIA 8572 (Child Abuse), SOC 341 and SOC 342 (Elder and Dependent Adult Abuse).
• Built the reporting history module to allow mandated reporters to view and track previously submitted reports.
• Developed a secure OTP verification system to authenticate mandated reporters before granting access to the application.
• Actively involved in bug fixing and implementing enhancements for all three report workflows to improve usability, accuracy, and compliance.

Project Name: Orange County Information System (OCIS2)

This is a rewrite of the OCIS application.

OCIS2 is a centralized web-based case management system developed for the Orange County Social Services Agency to manage a wide range of services and benefits for children, families, and dependent adults. The system is designed to enhance operational efficiency, improve case tracking, and ensure compliance with county, state, and federal regulations. It supports various SSA programs including Child Welfare Services, Adult Protective Services, and Public Assistance Programs.

• Developed Logbook Entry Form: Designed and implemented a dynamic web-based form that replicates the functionality of an Excel sheet, allowing users to add, edit, delete, and search entries seamlessly.
• Created Child Search Page: Developed a comprehensive search interface that retrieves child profile details including Name, Nickname, Age, Episode, Admitted From, Admitted To, Last Entry Date, and Final Entry Details.
• Additionally, supported other applications as well.

OCIS, 2. Perfect apps. MOB , EFMS and DRTs2,Snap Schedule.

• Developed custom solutions for clients based on their unique business requirements and objectives.
• Initiated code reviews within the team to improve overall code quality and minimize potential errors during deployment phases.
• Participated in design and planning exercises for future software rollouts.

Technologies: ASP.NET Core, C#, Entity Framework, JavaScript, SQL Server, Kendo UI, React (if applicable), REST APIs, Azure DevOps

• Fund station is the application where it processes the data and send the processed data to downstream applications. It take the funds data from upstream (IDH, CSTAR.Etc. ) and calculate the returns and send to downstream called RAPID.
• Rubix is reconciliation platform established to automate the identification of exception between various Capital systems. It leverages Duco technologies, it is cloudbased -vendor hosted cloud application.
• AES application is decommissioned, and it has only database and it hold MARS historical data.
• HARP is an application performance comparison of American funds mutual funds measured against peer funds and benchmarks.

Responsibilities:

• Involved in daily scrums and offshore meetings.
• Resolved Fundstation UI Access issues.
• Resolved Fundstation report generation issues.
• Involved in creating POC to call multiple parent classes for Synfund Hypo CITS calculations.
• Involved Datamod for Harp Calendar. Involved in Unit testing for Synfund CIT Hypo calculation.
• Involved in IT testing for and UAT testing Ldap Url.
• Involved in generating discrepancy reports between Security reference RDM and Security reference Final table. Involved production release and deployments.
• Gather information for AES cloud readiness.
• Involved in code reviews.
• Resolved Rubix job failures issues.
• Continuously updated skills through training courses, workshops, and self-study—staying current on industry trends and emerging technologies.
• Environments: Visual studio 2022, SQL Server 2019, Autosys, Perl, Python 3.10.x, ServiceNow, Toad 5.2, Access Central, Oracle

TSFT tool used to compare and source and Target systems data and any discrepancy is there it will store in shared folder called NAS drive in excel file format. The source systems are SAP, Aspen, Remedy and Target system is Powerbase Database.

Responsibilities: Analyzing the application and impacts.

• Provided technical support for end-users, resolving issues promptly and effectively.
• Meeting with stack holders to gather and define business requirements.
• Involved in preparing design document of DVT tool. Involved in preparing project plan for DVT tool and Data Migration projects.
• Involved offshore team and onsite team KT session for the DVT tool.
• Involved in creating the Interface development IN_6540 (FAIR&PRC), IN_6545B (Work Order), IN_6545A(Notification), IN_6593A(problem Statement),IN_6593G(equipment),IN_T705_ASP(ASPEN),PS(Protection Suite).
• Developed detailed technical documentation to facilitate knowledge sharing among team members and aid in future troubleshooting efforts.
• Involved in Unit Testing, Stress testing and Integration Testing.
• Involved in manual reports between ASPEN and SAP, protection suite and SAP and SAP orphan reports.
• Involved in Bug fixes. Involved Dev and Test Server deployments.
• Involved in creating the batch jobs.

Environments: Visual Studio. NET 2022, .net core 6.0, Sql Server Management Studio V17, remedy, IGAM, GitHub.

Software Engineer Sept 2017 – Jul 2021

Projects

· 1.Backoffice

· 2.Dashboard

· 3.Intranet Application

· 4.Senegence.com

· 5.Quick Order

· 6.NDS

Back office:

• Developed Back office for MX, NZ, HK upgrade projects.
• Involved Enhancements of CMS pages.
• Involved Back office updates for all countries US,CA,AU,MX,NZ, HK .
• Developed Site Map for MX country.
• Converted Event Calendar to MX translation.
• Maintaining monthly Newsletters and Sentiment Uploads.

DashBoard

• Involved In creating SeneSales and SeneSponsoring report from scratch MVC, C# and SQL
• Involved In creating enhancement of Fast Start and FastStart Downline Report which is built in Aspx and SQL
• Involved in Lips Trip Enhancements
• Involved Homepage Distributor Account Detail Page Enhancements.
• Involved Creating Dominion Reports from scratch using MVC, C# and S
• (Dominion Summary, Dominion SeneStar, Dominion Lips trip, Dominion SeneCar, SeneGranFather)
• Involved in Enhancement of Contest Reports (Lips, SeneCar, SeneStar..etc.)

· Intranet Application

• Involved Implementing the SeneSales and SeneSponsoring Report Using ASPX JavaScript, Ajax and SQL
• Implemented retail SeneSale and Retail Customer sign up reports Report Using ASPX JavaScript, Ajax and SQL
• Joni Dominion, Quickstep, Fast Start, Inner Circle Court, Lips Trip
• Created Batch jobs SeneBucksForSeneSposoring, Sene Builder, Quick step and Senebuck holiday batch jobs.
• Anniversary and Birthday gift Console Jobs.
• Created complex Store proc Finding Up line CP and Releam logic
• Created Complete application For Senebucks Request and SeneBucks Approval
• I have developed clone functionality for Product page
• Involved in maintenance of Product setups
• Created automated job for Qualified Fast Start Kit.
• Involved In Complicate Program by resolving the issue in Recognition rank program which runs every April 1st
• Involved in Acumatica Synch issues
• Created Alexa Demo piece for Reports
• Involved optimizing the Work Queue Page performance.

Quick Order:

• Involved Demo Drop Delete Address functionality. Created API and Model
• Involved enhancement in yearly renewal logic.
• Involved Fast Start pop menu for MX Distributors.
• Involved in sprint issues which comes

· NDS:

• Involved in free sign up and Regular price NDS Kit Set ups
• Involve UI related issues.(ex: some UI expect to type dist. Id only, Capital not accepting …etc)
• Resolved issue which has issue with regular expression.
• Resolve issue even Mandatory information is missing and able to submit application

Senegence.Com

• Involved issues in Finding Distributor Page.
• Resolved Image issue.
• Involved in hiding the old NDS and redirecting to the new NDS page.
• Involved in maintaining the page if any links got modified.

Environments:

Visual Studio .NET 2019, Asp.net MVC4, Windows 7, Sql Server Management Studio V17.3 GitHub, Azure Dev ops, LINQ JavaScript, JSON, .Net Framework 4.7.2, MVC 5.2.7.0,

SQL Server 2017, Angular 5.2.10, node js V14.15.1.REST API. ASP.NETcore. Postgress, Postman,

Asp.netCore3.1,EntityFramework5.0.5,WebAPI(RESTAPI),PostmanV8.1.0,SqlServer2017,C#,Vb.net

• Developed scalable and maintainable code, ensuring long-term stability of the software.

• Choice Builder makes it easy for you to build a benefits program with dental, vision, chiropractic and life benefits, all in one program, all at a price that makes sense to your business, your budget, and your employees.
• Involved in billing module tuning.
• Analyzed and debug database billing program to understand the flow of the Process.
• Worked on tuning table indexes using execution plan.
• Improved performance of database procedures for the group, policy and events.
• Worked on writing query for total process time of the billing process.
• Monitored database performance to keep workflows running smoothly.

Environment: C#, WPF, WCF services, Sql server 2012, TFS.

• Vermont Health Connect is a way to choose a health plan that fits your needs and your budget. All the plans offered through Vermont Health Connect offer the same quality benefits like doctor visits, hospital stays, preventive care, and prescription coverage – so there's no guesswork about what's covered.
• Involved in helping users/customers to resolve Medicaid, APTC and Federal Hub related issues.
• Good understanding on Medicaid eligibility. When users/customers will qualify and why they will qualify for Medicaid.
• Extensively worked on Medicaid related issues.
• Involved implementing logic for APTC calculation using C# for the renewal cases.
• Created ASP.net web form to validate APTC logic.
• Environments: ASP.net, Visual studio 2012, C#, oracle 11g, ONEGATE 4.0, SOA 11.1.1.6, Seibel 8.2.2.2 SIA, Citrix XenApp, SOAP UI5.0.0, ECM, XML, Windows 7, Life ray, and IDM, OPA, VMware cloud, HPSM, Tortoise SVN, selenium 2.8.0.

• HIX is Health Insurance Exchange project for Nevada. Using this portal where Individual can apply policies, Brokers, CAC and Navigator can help customers to apply the policy.
• Involved in creating SQL scripts to correct the data using T-SQL.
• Involved in portal enhancements using MVC4.
• Working on day-to-day production support issues.
• Resolved critical issue for Broker contamination and missing HIX Ids.
• Environments: Visual Studio .NET 2012, Asp.net MVC4, Windows 8, WCF, XML, SQLServer 2012, TFS, JavaScript.

• Eddi is the mobile and web based application, Where Individual can list their items and they can sell or buy Items.
• Involved in Agile scrum for design of application.
• Responsible for creating Web API using C# for Listing, Notifications, watch listing, Offers, transactions, Social Likes, User reviews, Abuse Reports Using C# Coding.
• Involved in creating data model and created stored procedure using T-SQL.
• Created Rich Admin pages using MVC4, Telerik Controls, HTML5, CSS3 and Entity Framework also created sorting and search facility for Admin pages using JavaScript and MVC4.
• Environments: Visual Studio .NET 2012, Entity Framework, Asp.net MVC4, Windows 7, Sql Server 2012, SmartSVN, Amazon Cloud Server, REST API, LINQ JavaScript, JSON, Amazon S3.

• Company Overview: Kaiser Permanente is America’s largest not-for-profit health care organization, serving 8.1 million members in 9 states and the District of Columbia.
• Benefit Enhancement and Tracking System (BETS) stores the benefits, group sub group and coverage details. It provides the functionality for benefits management, pricing, contacts and sales.
• Involved in Analysis, Design, Development and Testing of Web Forms using ASP.NET, C#, CSS and .NET Framework.
• Performed client side validation using JavaScript, JQuery.
• Involved in creating Batch jobs and scheduling batch jobs.
• Wide experience in production environment with 24/7 production support.
• Kaiser Permanente is America’s largest not-for-profit health care organization, serving 8.1 million members in 9 states and the District of Columbia.
• Environment: C#.net, Visual Studio 2003/2005/2008/Oracle 10g, Vb.net, Asp.net, Star team, Caliber, Remedy, pl/sql developer, Java script, HTML, CSS, XML Visual Source Safe 6.0, Web Services and windows XP.