Rajashekar Shekar

• Individual contributor with complete ownership of multiple process assigned under FDM-
• Fin360 and Projects providing more support towards growth of United health Group
• Take care of career progression of team members and make sure the growth is charted and achieved in line with Optum goals
• Responsible for development and support of SAS projects and make sure of zero defects and best programing practices are followed
• Digitalization of manual efforts through designing and implementation of new projects
• Provide regular updates to leadership both onshore and offshore.
• Updated old code bases to modern development standards, improving functionality.
• Discussed issues with team members to provide resolution and apply best practices.
• Participated in software field testing to verify performance of developed projects.
• Collaborated on stages of systems development lifecycle from requirement gathering to production releases.
• Developed software for desktop and mobile operating systems.
• Translated customer requirements into written use cases.
• Architected data engineering pipelines to support machine learning performance.
• Documented software development methodologies in technical manuals to be used by IT personnel in future projects.
• Tested functional compliance of company products.
• Inspected equipment, assessed functionality and optimized controls.
• Developed next generation integration platform for internal applications.
• Developed conversion and system implementation plans.
• Tuned systems to boost performance.
• Investigated new and emerging software applications to select and implement administrative information systems.
• Estimated work hours and tracked progress using Scrum methodology.
• Created proofs of concept for innovative new solutions.
• Tested troubleshooting methods and documented resolutions for inclusion in knowledge base for support team use.
• Designed and developed analytical data structures.
• Coordinated deployments of new software, feature updates and fixes.

• Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs, and enhancements.
• Built databases and table structures for web applications.
• Corrected, modified and upgraded software to improve performance.
• Authored code fixes and enhancements for inclusion in future code releases and patches.
• Coordinated deployments of new software, feature updates and fixes.
• Tested and deployed scalable and highly available software products.
• Designed and developed forward-thinking systems that meet user needs and improve productivity.
• Designed and implemented scalable applications for data extraction and analysis.
• Tested troubleshooting methods and documented resolutions for inclusion in knowledge base for support team use.
• Designed and developed analytical data structures.
• Supervised work of programmers, designers and technicians, assigned tasks and monitored performance against targets.
• Investigated new and emerging software applications to select and implement administrative information systems.
• Developed conversion and system implementation plans.

• Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs, and enhancements.
• Built databases and table structures for web applications.
• Corrected, modified and upgraded software to improve performance.
• Authored code fixes and enhancements for inclusion in future code releases and patches.

· Requirement document preparation as per the higher management reporting requirements.

· Coding of SAS scripts for Extraction of data from delimited flat files using Base SAS and SAS/Macros and PROC SQL.

· Cleaning the data using SAS functions and required Datasets creation for reporting.

· Generating reports as per clients request using Base SAS, proc report.

· Involved in testing the correctness of the data before the delivery.

· Identify SAS datasets needed for the report. Manipulating the data as per the current requirements.

· Generating the reports on SAS EG as per the requirements.

· Extracted information from the Data warehouse (Oracle), using SAS/ACCESS and created SAS data sets

· Extensively used SAS procedures like means, frequency and other statistical calculations for Data validation

· Prepared flowcharts indicating the input data sets, sorting and merging techniques and wrote SAS code accordingly

· Used Proc Tabulate and Proc Report for reporting purpose and extensively used macros for automation and standardization

· Data manipulation by merging, Appending, Concatenating, sorting datasets.

· According to the requirements, created metadata for the analysis datasets.

· Generated output files in HTML, RTF and PDF formats using SAS/ODS.

Worked on writing, editing and debugging code using BASE SAS and Macros

· Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQl.

· Loaded the data into database tables using SQL loader from text and excel file.

· Developed data model, SQL Queries, SQL Query tuning process and Schemas.

· Worked with bulk collect to implement the performance of multi row queries.

· Data loaded from legacy systems using PL/SQL and SQL Loader.

· Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.

· Involved in logical modeling and physical modeling of application.

· Wrote various kinds of SQL queries involving correlated Sub queries, UNION, Inner and Outer Joins.

· Developed Procedures for efficient error handling process by capturing errors into user managed tables.

· Generated various analytical reports using Microsoft Access.

· Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.

· Created partitioned tables, partitioned indexes for manageability and scalability.

· Used Toad for creating PL/SQL (trigger, sequence, stored procedure).