KUMARA SWAMY PIRLA

Systems Engineer with 4.1 Years of Programming Experience as a Oracle PL/SQL Developer in Analysis, Design, and Implementation of Business Requirements.

Expert in RDBMS Concepts , Procedures, Functions, Dynamic SQL, Partitions, Indexing, Cursors, Collections, Oracle Views, Triggers, Joins, Analytical and Aggregate functions.

Currently working as Digitization and Automation project named ISOMetrix.

Have a good knowledge in Retail Domain, Financial Operations of an organization with comprehensive understanding and practical knowledge.

Have good debugging skills.

Have been a Finance module lead for last two year contributed.

Basic knowledge and Hand-on experience on Core Java, Spring Boot, Angular 4,and basic Python Data Analysis Using Pandas and Numpy Concepts.

Current role involves creation of new Procedures, Data analysis, Creating logics based on user Requirements.

Gained Knowledge on Business and functional logics of Financial Operations of Current Organization.

ISOMetrix Finance:

It is an Internal Business Digitization and Automation Project following Agile Methodology and Scrum framework, which helps in generating Business Reports, Dashboards to the Higher Management team. It also assists BFM team by automating time consuming processes like generating PPT's indifferent visual representations and for better tracking of key performance indicators , Generating Quarterly performance Decks, Monitoring performance of Different units through out the organization and Automating different corporate mails that includes multiple structures . Responsibilities: Developing PL/SQL Packages, Stored Procedures and reusable Function to analyze various key performance indicators and worked in Agile environment. Creating User stories based on the requirement.

Automated the process of sending Bulk mails and Remainder mails for critical responses in the corporate.

Data Analyzing and Validation to provide correct information to the users.

Creating Guidance document on the processes implemented and User manuals so that they can use properly with out help. Involved in design, development, and testing phases of software development and maintenance life cycle.

Admin Tracking System:

It is a Automated product Developed for the Admin Management and HR Team. to Automate the attendance Tracking and invoice pay wages calculation for Non Technical Support staff and Security staff through out the branches in Chennai.

It includes Clocked hours tracking based on Swipe records and etc.