Ravi Raja Avuti

Senior-level Software and Application Developer passionate about creating cutting-edge products for Financial Industry. Strong work ethic and dedicated to quality assurance. Adept at working with teams or independently in fast-paced settings.

• Awarded topmost rating in the continuous appraisal cycle due to the appreciations received from Clients.
• Part of End-End Data Migration of Legacy Wealth Management Application Global Plus to SEI SWP using Snowflake.
• Received Kudos from clients and LOB for being calm and solution centric during a big mishap on our system which could have been a serious client and financial impact and successfully fixing it with the help from the team.
• Automated the client statement processing which is the most critical part of our work sphere.
• Implemented paper less environment project by creating an Add-on functionality in one of the applications which was on-hold due to no feasibility – achieved this by integrating a PDF tool with the application.
• Worked on number of Report/Extract transformations using Shell scripting and Perl Scripting for client needs.
• Delivered all the projects with no or minimum defects.

• Design and Develop data models using Snowflake Objects.
• Develop and Maintain ETL processes to move data from source systems to Snowflake and snowflake to Downstream.
• Create and Maintain views, Stored procedures, snow pipes, stages, and other database objects.
• Monitor and optimize query performance.
• Develop and Maintain data pipelines and data integration processes.
• Design and Implement data security and access control.
• Troubleshoot and debug data issues.
• Develop and maintain Data Warehouse monitoring, alerting and automation solutions.
• Develop and Maintain ADF pipelines.
• Development and Support of the Business Applications hosted on Unix/Linux and Windows Environment using Linux/Unix Shell and Perl Scripting, Batch Scripting, Oracle SQL, Azure cloud services, SNOWFLAKE and Java Basics.
• Issue resolution by analyzing the Shell, Perl, Java, and SQL scripts that run on Linux/UNIX production environment.
• Proposing Automation Designs and delivering them to improve existing application processing.
• Linux/UNIX Server maintenance and performance improvement by eliminating repetitive process that occupy the CPU of the server using the automations through Shell and Perl Scripting
• Patching and Upgrading of the applications hosted on Linux/UNIX Servers with the help of application vendors and server administrators.
• Formatting of the reports developed from the various applications using Shell and Perl Scripting.
• Developing automation Scripts using Linux/UNIX shell scripting, SQL and Perl Scripting for the auto generation and transfer of the extract/reports from one application to the other.
• Small Application development using Shell and Perl scripting to extract and transform data from one source to the other for the ease of data loading at the destination.
• Have provided automation solutions to the existing manual processes in the batch processing of the application, which in turn reduced the manual interventions and the errors.
• Upgrade and patching of applications.
• Have proved myself in exploring the opportunities of automation in the legacy systems and comforted users with the ease of getting the daily routine accomplished.
• Key point of contact in the team for the new automations using SQL, Shell scripting and Perl scripting.
• Maintenance of the Linux/Unix AIX and Windows servers on which these applications are hosted.
• Control M and Zeke Scheduling of the Application Batch Jobs.
• Application Batch Processing Improvements, Automation and Metrics preparation using Service Now.
• Adhering to all the compliance rules on these servers from time to time fixing all the vulnerabilities if any as per audit requests
• Delivery of projects using SDLC and Agile Methodologies as per requirement.
• Project requirements gathering, estimation and delivery.

• Technical Lead, HCL Technologies, Franklin Templeton Investments, 05/01/21, Present
• Consultant, Capgemini, Royal Bank of Canada, 09/06/16, 05/14/21
• Assistant Software Engineer, Franklin Templeton Investments, Investment and Wealth Management Technologies, 06/16/14, 09/02/16

• Playing Cricket
• Table Tennis
• Badminton
• Listening to music

Global Plus to SEI SWP:

Part of Core Team for complete Data and Functionality Migration of Legacy Accounting Platform FIS Global Plus to SEI SWP (Very Large Project) right from project initiation, requirements gathering, pilot testing, Design, data Modelling , Data Governance till project Implementation in Agile Methodology.

Skills Used : Snowflake and Snowflake Objects,ADF, SQL, Shell Scripting.

I hereby declare that the information provided above is true to the best of my knowledge.