SUMMARY

• System data analyst with 9+ years of rich experience in US Healthcare domain claims data analysis and DBMS Tools like Oracle SQL, PL - SQL, MS-Access, SSIS, SAS, Python and Data visualization using Tableau. Good knowledge in Informatica Power center ETL Tools. Adept of handling multiple projects, works well within a team environment, and holds a highly desirable data analysis and management skills.
• An Oracle Certified Professional with around 9 years of total experience in Design, Development and Implementation of Business Applications using teh Oracle Relational Database Management System (RDBMS).
• Expertise in Oracle 11g/10g/9i, PL/SQL, SQL *PLUS, TOAD, SSIS, Access, SAS and Neteza.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Good experience in working with cursors, parameterized cursors, for update clause, cursor variable like strong ref cursors, weak ref cursor, Table views, Constraints, Index (B Tree, Bitmap and Function Based).
• Good knowledge in user defined functions and application oriented procedure and function into SSIS packages.
• Can work with collections like PL/SQL records and PL/SQL tables and very good knowledge in joins, sub queries and hierarchical queries.
• Has very good knowledge in US Healthcare
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Has very good knowledge in Python Data structures and Functions
• Good knowledge in Python packages like Pandas, Numpy and Matplotlib
• Experience in importing/exporting data between different sources and destinations like Oracle/Access/Flat files etc. using SSIS/Informatica Power Center.
• Good exposure in data extraction, Transformation, loading, analysis and reporting using different tools.
• Good ability to quickly grasp and master new concepts and technologies.

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Analyst

Responsibilities:

• Recognizing areas for automation and create automation reports using SSIS for weekly/monthly runs.
• Work with business users and project managers to understand inefficiencies in existing business applications and recommend solutions.
• Handle High complex data analytical requests.
• Help offshore team in automation and guide them in.
• Building basic tableau dashboard reports for business analytics team.
• Load vendor data files and schedule them on needed basis using SSIS Packages
• Create tableau clinical selection model dashboards for clinical team.
• Automate excel reports using Python libraries.

Confidential

Senior Developer

Responsibilities:

• Extract, transform, and load data utilizing SSIS tool. Responsible for analyzing health data and producing, verifying and interpreting client reports with very little oversight. Performing teh analyses of health care data, including medical and pharmacy claims, membership files and health advisory/coaching interaction, to better understand teh quality and level of care delivered and measure teh effectiveness of teh organization's services as it relates to both clinical quality and financial returns.
• Handle High complex queries and High priority legal reports, Adhoc reports and refresh around 600+ monthly/weekly queries and move teh respective claims to audit and collections.
• Involved in analyzing, mapping, transforming and writing complex procedures in SQL, to migrate large volumes of transactional data.
• Work with teh concept generation team, gather requirements and analyze requirement and present/translate teh CCRO/FRAC team requirements to offshore development team and ensure active communication between client and off shore development team.
• Act as Onsite manager for all teh Communications and escalation for Humana Client.
• Help offshore team in Query tuning and guide them in
• Work with SCIO Internal Payment Integrity teams and halp them with concepts and share ideas on improving recovery.
• Developed report automation processes using Microsoft Access to improve turnaround time and reporting capabilities.
• Developed comprehensive and user-friendly databases using queries and macros in Access.
• Monitor team productivity & quality, organize KSS sessions, plan training schedule for teh new hires, coordinate with on-site resource

Confidential

Project Lead

Tools Used: PL/SQL Developer, TOAD, Netezza, EFR ID Prod, CAS, CIS, SIU tool and Query Doc

Responsibilities:

• Assure dat teh team members has teh necessary education and training to effectively participate on teh team.
• Create automated monthly reports for Confidential . using SSIS/SAS.
• Provide necessary business and technical information to team.
• Involved in QAT App(Query Assignment Tracker) tool development in Business, application and development levels.
• Work with large and complex databases (DB2 environment) fordataextraction, manipulation and validation.
• Adept and experienced in problem solving and providing solutions
• Conducted code reviews as a major step for maintaining high coding standards.
• Conducting scrum meetings for tracking progress in agile environment.
• Provides encouragement toteammembers and identifying new training dat may be needed to achieve theteamgoal
• Demonstrated ability to handle multiple tasks as ateamleader, providing motivation and training & leading by example. Utilize sound judgment when making decisions.
• Prepared reports and presentations.
• Analyzing teh business requirement given by teh client, identify potential gaps and provider clear logic to team.
• Comparing SQL results with data pulled from SIU front end application while in teh process of review teh output.
• Delivering teh reports on day to day basis with high importance and good quality of results.
• Reducing number of change requests by giving appropriate observations
• Completed ad-hoc projects relating to data investigations, follow-ups on analysis results, or other client requests. Documented tasks in a timely and accurate basis including delineation of tasks, and estimation of effort.
• Create automated monthly reports for CTI Reports using SSIS/SAS.
• Conducting scrum meetings for tracking progress in agile environment.
• Maintained and updated project status report and conducted weekly status report meetings and creating meeting minutes.
• Working adhoc requirements on PPNO customer requests
• Attend status calls with client & cascade updates/instructions to teh team
• Provide necessary business and technical information to team.
• Prepared documents for transition.

Confidential

Programmer Analyst

Responsibilities:

• Handled low and medium complex queries by using unique query optimization techniques.
• Participate in round table discussion with senior developers and SME in understanding teh client requirements and also provide technical coding related support.
• Play a key role in successful delivery of queries within teh given Turn-Around-Time and SLA’s .
• Help Project lead in preparing team reports related to process & operational metrics for teh internal management and client, as required.
• Achieved individual productivity with quality and also halp new team members shadow processing and review and halp them and team to achieve project goals in an efficient & effective manner.
• Dedicated individual with a reputation for consistently achieving production goals with high quality standards.
• Participated in team status call and ideation & brainstorm sessions to enhance teh scope of achieving increasing client expectations.