Ajay Kumar Kolli
McKinney,TX
Summary
Experienced IT professional adept at delivering customized solutions to enhance business operations. Skilled in translating growth plans and specific requirements into improved system designs. Utilized knowledge of new technologies to suggest enhancements to existing systems and hardware.
Overview
19
19
years of professional experience
Work History
Systems Analyst
LoanCare Service Link
McKinney, TX
12.2017 - Current
- Provided efficient automation solutions using VisualCron RPA, SharePoint, MSP scripts, and Microsoft Power Automate.
- Identified potential areas for automation in existing manual processes.
- Successfully contributed to the development of multiple director scripts.
- Implemented demo script solutions for the operations team
- Advised on viable RPA alternatives to enhance operational efficiency.
Tech Lead
Capital One
Plano, Texas
05.2010 - 07.2017
- Developed data models in Excel/VBA for loan decision tools.
- Ensured close collaboration between M&A teams and Tools for alignment with credit intent.
- Transformed legacy toolset into modernized software environment using C#, MVC technology stack.
- Created and implemented a range of Director Scripts (VBScripts).
- Conducted extensive research to identify optimal solutions for diverse business cases.
Application Developer
JPMorgan Chase
Columbus, OH
08.2008 - 02.2010
- Managed development, test, and production environments for Director Scripts.
- Created procedures for Director Script naming, coding, and code review processes.
- Directed and enhanced the technical aspects of Director Scripts to optimize performance and functionality.
- Incorporated MS-Access for efficient retrieval of Oracle Client based InfoOne data.
- Successfully migrated Director Scripts through the stages of development, SIT, UAT, and Production.
Application Developer
Global IT Inc
Irving, TX
01.2008 - 07.2008
- Designed and developed user interface using VB.NET, while implementing code based on business logic.
- Created and executed SQL Server stored procedures for efficient back-end processes.
- Provided subject matter expertise for project development analysis and service request analysis.
- Delivered day-to-day IT support to the business sector.
- Retrieved data from SQL server and created/managed MS-Access database using MS-Access.
Web Developer
Mind Source Private Limited
Bengaluru, Karnataka
06.2006 - 10.2006
- Incorporated CSS files to establish visual consistency across all web pages.
- Implemented validation controls using JavaScript to improve alert functionality.
- Developed efficient stored procedures, user-defined functions and triggers as required.
- Utilized ASP.NET for front-end application development
- Contributed to unit testing and functionality testing.
Developer
Social Computer Solutions
Guntur, Andhra Pradesh
11.2005 - 04.2006
- Collaborated with business users to gather requirements.
- Created Windows applications using MS Visual Studio and VB.Net.
- Utilized SQL Server to create tables, functions, views, and stored procedures.
- Collected user requirements through meetings with stakeholders
- Enhanced validation process through the implementation of validation controls.
Education
Bachelor of Science - Information Science
Bellary Engineering College
Bellary 05-2005
Skills
- End-user support
- Application Design
- User Acceptance Testing
- Data Modeling
- Technical Documentation
- Software testing
- Software troubleshooting
- Systems Automation
Affiliations
- interested in playing chess, pickle ball, gardening
Languages
English
Professional
Telugu
Professional
Hindi
Professional
Timeline
Systems Analyst
LoanCare Service Link
12.2017 - Current
Tech Lead
Capital One
05.2010 - 07.2017
Application Developer
JPMorgan Chase
08.2008 - 02.2010
Application Developer
Global IT Inc
01.2008 - 07.2008
Web Developer
Mind Source Private Limited
06.2006 - 10.2006
Developer
Social Computer Solutions
11.2005 - 04.2006
Bachelor of Science - Information Science
Bellary Engineering College
Similar Profiles
Sylvia McchristianSylvia Mcchristian
Mortgage Servicing Specialist at LoanCare Service LinkMortgage Servicing Specialist at LoanCare Service Link
Catrina S. HasanCatrina S. Hasan
Closing Specialist at LoanCare Service LinkClosing Specialist at LoanCare Service Link
Zelda Marie McCantsZelda Marie McCants
Escrow PMI Specialist II at LoanCare Service LinkEscrow PMI Specialist II at LoanCare Service Link