Aparajitha Duvvuru

Seasoned and results-driven IT professional with 15+ years’ demonstrated success in designing and delivering innovative Application Support solutions for Healthcare, EDI, Automotive, Insurance, Financial and Business Intelligence systems. Technically astute leader with strong history of proving best practices to optimize solution quality and consistently align development efforts with business requirements. Proven track record of implementing refined technical expertise to streamline operational workflows while continually contributing to improvement efforts. Possess superior collaboration talents, partnering knowledgeably and efficiently with cross-functional teams, peers, customers, and management, in addition to liaising with stakeholders across all levels. Adept at conveying complex technologies to diverse skill levels and delivering training to multifunctional teams.

• PowerBuilder
• Oracle SQL
• Microsoft SQL Anywhere
• Microsoft SQL Server
• Jira/Cloud JIRA
• Splunk
• JavaScript
• Salesforce
• Wiki
• Box
• ServiceNow (ITSM)
• Dynatrace
• Business Objects
• SSAS/SSIS/SSRS
• Root Cause Analysis
• G-Suite Products
• Microsoft Office Suite
• VDI
• GitHub
• Validation Testing
• Power BI
• Opsgenie
• Business Analysis
• Informatica
• XL Release
• Linux/Unix
• Autosys
• Central Management Console (CMC)
• Sybase
• Data Modeling
• Data Profiling
• Data Analysis
• Azure Cloud Infrastructure
• SaaS solutions
• PowerBI

• UnitedHealthGroup/Optum Services, MN, MN, True, Technical Support Analyst, 01/01/22, Present, Technical Support Analyst for Optum Insight Provider Squad – Computer Assisted Coding Professional Product Implementation and Support – ServiceNow, Salesforce, Database Scripting using SQL Server Management Studio for Validation, PowerBI, TechXL CRM Tool, Doc Control, StoProx, Configuration Manager, File Z Manager, User Manager, Billing Export Module, Claims Data and Explanation of Benefits., Client Data Analysis and Validate client specific programming and configuration for client implementations and production modifications., Analyze system requirements and technical specifications to create and execute implementation and support plan., Execute, implement and support within a SAAS environment., Log, track, report and Incident Management using Jira, Cloud Jira, ServiceNow, Salesforce., Establish and maintain test cases, test plans, test scripts using Jira/Salesforce., Team Orientation, communicate process and interact with various teams on issues, updates, and enhancements that may impact customer data, workflow, and/or functionality., Analyze, Build, execute and create database SQL queries with the ability to troubleshoot issues found in stored procedures and/or customer data., Provide production application support to Optum clients through incident management portal by performing root cause analysis., Responsible for accurately triaging, prioritization and troubleshooting incidents while utilizing critical thinking skills., HL7 raw data, health information management, or health insurance., Involved with Salesforce Migration of CRM System and effectively utilizing the application by creating team dashboards for result-oriented metrics in support of clients by working with internal and external teams., Proficient with Data Analysis, Data Modeling, Data Profiling, Data Quality Profiling, Data Validation for Provider Market data using SQL and ETL tools., HIPAA regulations, or other similar industry standard, security, and privacy requirements., Collaborate as needed with partnering teams in a timely manner with appropriate sense of urgency and utilizing resources to drive effective and timely resolution., Follow standard operating procedure to escalate urgent issues where appropriate., Identify trends and participate in development and implementation of new procedures, and refining of existing procedures for addressing production support, demonstrate initiative to seek opportunities to create and maintain support documentation., Identify and resolve operational problems using defined processes, expertise, and judgment., Demonstrate flexibility and ability to adapt to a fast-paced and evolving environment; learn new topics, retain knowledge, and effectively manage time with minimal supervision., Ensure consistent adherence to meet and/or exceed department metrics and expectations as well as other duties and tasks as assigned.
• Medecision, Dallas, TX, True, Application Support Analyst, 01/01/21, 12/31/21, Develop and manage cloud-based infrastructure., Oversee software automation and technical troubleshooting for installed, hosted and SaaS products while supporting improvement efforts., Manage data transformation and information mapping of various codes., Maintain and upgrade care coordination and care management applications by working within L1, L2 and L3 support levels., Devise and institute user test cases to verify test results., Track and assess incoming issues and problem tickets from end-users, and address application issues within servers, databases, and mission-critical systems., Provide resolutions for errors at data and code levels to customers and coordinate with senior teams to handle escalations of larger code-based issues., Assist in the planning, development and delivery of ACC and ACM application-training programs., Contribute to product deployments and application checkouts with minor and major release involving bug-fixes, enhancements, and new features., Liaise with business owners, stakeholders, and internal teams to provide effective technical solutions.
• American Society of Interventional Pain Physicians, Paducah, KY, True, Application Support Analyst, 01/01/19, 12/31/19, Collaborated with Centers for Medicare and Medicaid Services (CMS) and Laboratory Information Systems (LIS) teams to retrieve EHR patient data from large flat-file databases., Developed and implemented Oracle SQL and PL/SQL scripts such as stored procedures, functions, and packages., Orchestrated root cause analysis to identify and curtail defects., Delivered key reports to project managers and development teams to boost workflow efficiency., Supervised data processing and development activities to uphold quality., Conducted research studies to effectively modify scripts for scheduling data imports and exports from/into the Research Study Database., Evaluated application data to assess effectiveness and identify errors., Partnered with test and research-team end users to execute code fixes and enhancements for future releases and patches., Coordinated with cross-functional teams to conduct testing activities.
• Advisory Board Company, Chicago, IL, Implementation Support Specialist, 01/01/12, 12/31/17, Built, updated, and retained databases, data workflows, modeling and analytical processes, and reporting products to strengthen company operations and program performance., Executed automate testing, version control, packaging, and deployment of applications along with patient data validation, correction and reconciliation., Defined baseline performance measures and trends by assessing operational and clinical data using Agile and Scrum methodologies., Performed multiple data extracts for loading into PIC systems and generating patient-note files and contractual-adjustment files using Informatica., Formulated Referential Integrity reports and complex UNIX shell/Perl scripts based on ETL standards., Streamlined ICD9 to ICD10 transition for Member Hospitals by converting required codes., Created technical documents for Member Consultant and Data Load procedures, and member-specific customizations., Aided product-support teams in troubleshooting data loads by reviewing session logs, Splunk, Cron tab., Assisted in drafting of ad hoc reports for specific issues.
• AmerisourceBergen, Buffalo Grove, IL, Software/Application Developer Analyst, 01/01/12, 12/31/12, Formulated, tested, and deployed PowerBuilder (Powerscript) code in compliance with business regulations, technical system requirements, and client security standards for AmerisourceBergen pharmaceutical distribution solutions., Upgraded diverse range of layouts, products, devices, components, methods, and procedures., Coordinated with client IT staff to execute technical data transfers., Provided technical assistance to management and multifunctional internal teams., Strengthened user-acceptance training and testing.
• Volkswagen credit Inc., Libertyville, IL, Software/Application Support Lead, 01/01/08, 12/31/12, Served as subject-matter expert and lead developer for executing projects in collaboration with project managers, business stakeholders and systems analysts., Spearheaded creation of ETL daily, weekly, monthly and quarterly loads using Informatica PowerCenter client tools., Built and improved Loan Center and Tax Base and implemented dynamic calculation into the business logic for corresponding tax population based on primary/secondary loan applicant parameters., Conducted full-cycle production-support operations for the remarketing system and maintained technical documents within developmental MS SharePoint site., Oversaw conduction of application unit and system tests, and recommended updates to uphold quality., Created mappings, mapplets, workflows, worklets to transform data in accordance with business rules for nightly and weekly data load processing., Operated Enterprise Logger (in-house logging software) to enable prompt troubleshooting of problems and used HP Service Manager to prioritize critical incidents., Performed data extractions from Oracle, Sybase, and flat files as well as performance tunings at source and target levels., Coordinated with database group to optimize processes of the remarketing system and revitalized SDLC phase., Assisted in crafting of Autosys job-scheduling tool and small- and large-scale deployments., Supervised and coached junior developers and trainees in the best practices of development and coding standards.
• The EPITEC Group (Daimler Chrysler), Auburn Hills, MI, Programmer Analyst, 01/01/02, 12/31/07, Supported high-end (FAST/ISP)/Fleet/Scheduling Application Systems projects in new developments, enhancements and bug-fixes using PowerBuilder 6.5, C++ and J2EE technologies and Sybase Adaptive Server Enterprise 12.5 Transact SQL., Developed and instituted architectural framework to enable migration of customer production applications from PowerBuilder to Java/J2EE component-based system while using IBM WSAD 5.1 as interface., Curtailed complexity and smoothened internal connection of front-end screens using XML and XSL., Utilized HTML, XML and JS to build innovative and easy-to-use Graphic User interface., Produced Generic Component for general functionality., Integrated Core Java and Java Servlets in the framework to craft business logics which track and validate data., Applied User Objects, Windows, Menus, Data Windows, Data Stores, functions, structures, Powerscript and various Object-Oriented features such as overloading, overriding, and inheritance to develop new screens in PowerBuilder., Enabled version control of application source code by using PVCS., Standardized various SQL and Transact SQL to produce automated reports., Designed user worksheets with OLE formula-one controls., Systematized and managed complex system storing 300+ tables and 100+ stored procedures., Introduced effective RMI methods to enable easy access to essential data.