Purushotham Palli Email & Phone Number

Mumbai, Maharashtra, India

Hyderabad, Telangana, India

o Membership, Claims and Settlement data management of Finance & Accounts (Specialty Benefits segment) process for United Health Care.o Maintain data in multiple financial data systems stored on SQL Server, DB2, SAS Enterprise Guide tables.o Monitor & Co-ordinate data loads or imports/update/deletion activities of IT Data management team.o Monitor & ensure accurate GL tagging of the data according to pre-defined GL mapping ruleso Data collection, cleansing, formatting for historical data updates in case of New/modified Mapping rules (Reversal & Corrections)o Reconciliation/Validation of accurate data flow between multiple financial data systems i.e. Source System till General Ledger data system (Flow sequence Facets (MY SQL) -> FTS (MY SQL) -> FSDB (DB2) -> UDW (Data warehouse) & PeopleSoft (Oracle).o Exceptions handling/variance analysis, Root cause analysis, escalations and resolution management.o Develop LCD-10 & LCD Dashboards using MS Excel/Power BI.o Project support for all the internal, process level and organizational projects implemented for F&A Process.o UAT & SIT support for new applications, version upgrades, by providing test cases, and providing scrum/project call updates and acting as SME/SPOC from F&A side for the project assigned. o Adhoc Data/Reporting/MIS support for Finance and accounting teams using SQL, SAS EG, MS Excel, MS Access and Advanced Excel. o Design and develop Reporting templates, Dashboards and Data flow validation templates using Advanced MS Excel for Management Reporting.o To meet the data needs of the F&A team, Create, Modify and Edit multiple layers of filters in fine tuning the query for data extraction from multiple complex/large datasets.

Hyderabad Area, India

o Reconciliation data management for TACC team (Book vs Bank data reconciliation team)o Raw (flat/csv) files monitoring & loading/importing, bulk reconciliation (book vs bank data) and escalation management.o Variance analysis, root cause analysis, exceptions handling, escalations and resolution management.o MIS Reporting, Weekly/Monthly/Annual Analysis, Dashboard development and adhoc reporting.o Design, develop, manage, monitor & administration of scheduled jobs on Frontier (Fiserv) tool for data import/bulk reconciliation.o Defining auto-match criteria, designing and development of Auto-match scheduled jobs.o Data, schedule jobs & reports priority handling, escalations and working with relevant teams on calls, bridge calls and service now tickets with appropriate severity levels.o Project support for all the internal, process level and organizational projects implemented for TACC team.o UAT & SIT support for new applications, version upgrades. o Disaster recover & Business continuity exercise management for TACC data process.o Administration, maintenance (user creation, modification, deletion and passwords) and system support for the applications used by TACC team

Hyderabad, Telangana, India

o Manage a team of 7 MIS executives o Data analysis, mining, extraction, import/exportso Data management for Credit Shield Team o Design & Develop MS Excel & VBA automationso MIS Reporting & Analysis o Ensure data backup, restore & recovery of datao Recruit & Train new hires o Design & Develop dashboards & templates

Hyderabad, Telangana, India

o Support TL to manage Service Activations team o Handling dealer related issueso MIS Reporting & Analysis o Conducting education sessions to dealerso Recruit & Train new hires o Escalating issues to clients about dealer issues

B.Tech, Electronics And Communications

8Th, Maths,Science