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
2017.12 - 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
2010.05 - 2017.07
- 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
2008.08 - 2010.02
- 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
2008.01 - 2008.07
- 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
2006.06 - 2006.10
- 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
2005.11 - 2006.04
- 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 2005-05
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
2017.12 - Current
Tech Lead
Capital One
2010.05 - 2017.07
Application Developer
JPMorgan Chase
2008.08 - 2010.02
Application Developer
Global IT Inc
2008.01 - 2008.07
Web Developer
Mind Source Private Limited
2006.06 - 2006.10
Developer
Social Computer Solutions
2005.11 - 2006.04
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
Stephanie RamosStephanie Ramos
Quality Control Analyst at LoanCare, A Service Link CompanyQuality Control Analyst at LoanCare, A Service Link Company
Joseph KrogerJoseph Kroger
Mobile Notary Closer at Service Link & National LInkMobile Notary Closer at Service Link & National LInk