Kausalyananda Vardhan Tirumalapallerlamudi

Atlanta, GA • 815-***-**** • ad43lv@r.postjobfree.com• linkedin.com/in/k-vardhan-tirumalapallerlamudi

Professional Summary

8+ years of IT experience predominantly working in the Retail domain, in Oracle SQL, PL/SQL, SSIS, Core JAVA, Restful Web Services in various applications.

Requirement gathering and analysis of data for various applications in various projects and played a key role within the teams.

Strong technical expertise in creating and maintaining data objects like Views, Indexes, Sequences, Triggers, Functions and Procedures using Oracle 12c/11g.

Creating shell scripts in Unix for performing CRUD (Create, Read, Update, Delete) operations and sharing exported reports to business users.

Experience in handling production support for various applications.

Demonstrated proficiency in recognizing issues, evaluating potential solutions, and selecting the optimal course of action to achieve objectives.

I have the privilege of handling a team from both offshore and onshore, collaborating continuously with business users and end users of the applications and working towards providing solutions within the specified timelines.

With the experience gained from the projects, I see myself mingling easily with the diversified teams and working for the deliverables on-time.

SKILLS

Operating Systems: Linux, Microsoft Windows10

Database Technologies: MongoDB, MySQL, Oracle, SQL Server

Tools/Packages: ERWIN, Confluence, Eclipse 3.2/3.7/4.2, Git, Google Analytics, Jenkins, JIRA, Oracle SQL Developer, Informatica Power Center, Putty, ServiceNow, Splunk, Microsoft SharePoint, SSIS, Microsoft SQL Server Management Studio, Microsoft Project management, MS Office, RoboMongo, Visual Studio

Development Methodologies: Agile - Scrum Planning

Programming Languages: C# basics, Core Java, CSS basics, HTML basics, Restful Webservices, Data Modeling, SQL and PL/SQL, Unix Commands, Basic Python and Shell scripting

CERTIFICATIONS

SAP TERP10 Integration of business processes • 04/2018 - 05/2018

Python Certified Associate Programmer by Python Institute

MongoDB Developer by MongoDB University

Oracle Database SQL Certified Associate by Oracle

Oracle Database PL/SQL Developer Certified Professional by Oracle

WORK EXPERIENCE

Oracle PL/SQL Developer - Macy's - Atlanta - Since July 2019

Technologies – Oracle 12c, Unix Shell Scripting, SSIS, TSQL, ERWIN

Responsibilities –

•Improved “Stella application” performance by 30% by analyzing existing applications and creating Oracle PL/SQL procedures for data processing, resulting in increased efficiency and productivity for business users.

•Enhanced data update process by 50% through the creation of automated Unix shell scripts, leading to improved data accuracy.

•Worked on ~50 stories and tasks in JIRA, addressing the application issues and improving the system functionality according to the business user needs.

•Worked with the system architect in designing the data model for the new integrated module responsible for processing price information from upstream application into the system.

•Used CTE, regular expressions and Dynamic SQLs – Execute Immediate as part of work.

•Implemented performance tuning techniques for database objects including procedures, cursors, and triggers.

•Worked with business users and product team in understanding the requirements and provided solutions in time.

•Created technical documentation on database designs and SQL, shell scripts to trace solutions in future.

•Worked with the system architect in designing the qualified solutions and ensuring the overall quality of project deliverables and timely information sharing with business users, resulting in better decision-making.

•Developed ETL workflows using SSIS to extract data from various sources and load it into targeted database.

•Worked collaboratively with both upstream and downstream application team members to optimize and enhance the implementation process.

•Worked in supporting multiple test cycles of System Integration Testing (SIT) and User Acceptance Testing (UAT) to facilitate the successful deployment or go-live of the project.

•Worked in providing post-production go-live support and handling change requests and helped in attaining the stability and reliability.

•Proactively addressed and resolved customer inquiries and technical issues with a commitment to delivering exceptional service, resulting in a 20% increase in customer satisfaction ratings.

•Demonstrated strong verbal and written communication skills, effectively conveying technical information to diverse audiences including stakeholders, and non-technical users, resulting in improved collaboration and resolution of issues.

Oracle PL/SQL Developer - Staples - Chennai (2014-17)

Technologies – Oracle 12c, Java Restful Web services

Responsibilities –

•Collaborated with both business stakeholders and internal application teams to gather product data, consolidating it within the “Magnus application” for centralized storage.

•Developed PL/SQL procedures along with the restful web services in Java, reducing manual efforts and ensuring efficient promotion execution, leading to increased financial success for the business.

•Created resource endpoints to handle HTTP requests (GET, POST, PUT, DELETE) for CRUD operations, providing access to application data and functionality in a stateless manner.

•Effective in grasping and interpreting business requirements.

•Implemented validation and error handling logic to enforce data integrity and provide meaningful feedback to clients, improving the robustness and reliability of the API.

•Created Oracle PL/SQL packages to process and manage, ~2Million product records, resulting in streamlined data management and improved core data publishing framework for the Enterprise Merchandising Portal.

•In this process, I have worked in creating DML triggers for the audit purpose.

•Involved with database administrator in creating the data model for the application.

•Implemented performance optimization strategies for database objects such as procedures, and triggers.

•Proficient in comprehending the underlying database structure and adept at crafting necessary views to facilitate data access and manipulation.

•Demonstrated adaptability in managing diverse tasks within the project environment, efficiently addressing both planned and unplanned assignments throughout the day.

•Assisted database administrator with tasks related to data backup and documenting the data models and SQL scripts.

•Documented unit testing processes, guidelines, and test cases to support knowledge sharing and onboarding of new team members, ensuring consistency and scalability across projects and teams.

• Worked with Quality Analyst to ensure the application is meeting high standards by fixing the issues through JIRA.

•Maintained the release notes, checklists, and project documentation.

Jr Developer - Tata Consultancy Services Ltd - Chennai (2013-14)

Technologies – Oracle 12c, RoboMongo

Responsibilities –

•Contributed to the development of a project “Know yourself” that delivers essential internal course videos, enhancing employee learning and development opportunities within the company.

•Collaborated with senior developers and project stakeholders to understand project requirements, contributing actively to database design discussions, and proposing solutions to meet business needs effectively.

•Participated in the testing phase of the project by creating and executing SQL scripts to validate data integrity, ensure functional accuracy, and troubleshoot any issues, resulting in a robust and reliable database system.

•Contributed to the optimization of database performance by identifying and resolving inefficiencies, tuning SQL queries, indexing tables appropriately, and implementing database maintenance tasks, enhancing overall system responsiveness and scalability.

•Worked in creating procedures and functions in structured database to perform CRUD operations.

•Worked in writing queries in the unstructured database to show up data in the front-end UI.

•Created documentations of the requirements gathered for the project.

•Involved with database administrator in creating the data models for the application.

•Collaborated with cross-functional teams, including developers and quality assurance testers, to integrate database components seamlessly into the overall application architecture, ensuring compatibility and reliability across the system.

•Engaged in continuous learning and professional development initiatives, actively seeking opportunities to expand knowledge.

EDUCATION

Masters in Management Information Systems

Northern Illinois University • Dekalb • GPA: 3.8 • 09/2017 - 05/2019

Bachelors in Computer Science and Engineering

MVGR College of Engineering • Andhra Pradesh • Percentage: 72.7% • 09/2008 - 04/2012

Contact this candidate