LOKESH DUVVURU

Analysis & Planning
• Analyze application requirements and provide effort estimates for software development
and enhancement tasks.
• Review functional requirements, specifications, and wireframes to support application
development activities.
• Maintain strong knowledge of assigned application domains to support effective software
implementation and maintenance.
Software Development
• Design, write, modify, integrate, and test application-level software code according to
defined requirements and specifications.
• Translate functional requirements and wireframes into working software applications and
features.
• Refactor and update legacy application code to improve performance, functionality, and
maintainability.
• Develop and maintain real-time and batch application interfaces to support business
operations.
• Develop small to mid-sized software applications and enhancements where no suitable
commercial solution exists.
• Write programs to extract, transform, validate, and process data using messaging and
integration tools (e.g., Kafka).
• Develop application programs to support data conversions, corrections, and routine data
processing tasks.
• Configure and support SaaS and COTS (Commercial Off-The-Shelf) software applications
with appropriate training.
• Follow established development tools, coding standards, guidelines, and conventions.
• Develop code using modern development practices, including Continuous Integration,
Continuous Deployment, and agile methodologies.
Testing & Documentation
• Participate in secure code reviews to ensure software quality and compliance with
standards.
• Develop unit test cases, execute tests, and validate results during the software testing
process.
• Test and debug applications in collaboration with business and testing teams to resolve
defects.
• Utilize test-driven development and automated testing frameworks where applicable.
• Prepare and maintain technical documentation for newly developed or modified software
programs.
• Provide input into user guides and training materials related to supported applications.
Support & Maintenance
• Participate in triage meetings to review application defects, issues, and required fixes
identified during testing or production use.
• Investigate, troubleshoot, resolve, and escalate application-related problems as required.
• Assist users by responding to application-related questions and supporting issue
resolution.
• Identify when additional technical assistance is required and escalate issues appropriately.
• Participate in application upgrades, maintenance activities, and ongoing software support
tasks and Escalates issues as appropriate

• Designed, developed, and maintained SQL-based application components to support enterprise
systems and business operations.
• analyzed business and technical requirements and translated them into structured SQL code,
stored procedures, functions, and triggers.
• Developed and optimized complex Transact-SQL queries, views, and database objects to
support application functionality and reporting needs.
• Integrated database logic with enterprise applications to ensure seamless data processing and system performance.
• Improved existing SQL code to enhance performance, efficiency, and maintainability of applications.
• Developed data processing routines to support batch jobs, workflows, and system integrations.
• Participated in software testing, debugging, and validation to ensure reliability and accuracy of
database-driven applications.
• Implemented database and application updates in coordination with development teams.
• Followed coding standards, secure development practices, and version control procedures.• Provided production support by troubleshooting SQL-related issues and optimizing application performance.
• Collaborated within Agile/Scrum teams throughout the full Software Development Life Cycle
(SDLC), utilizing version control systems (e.g., Git/TFS) and participating in peer code reviews to ensure code integrity.
Deliverables and Achievable
• Optimization of SQL queries and stored procedures
• Strong knowledge of Transact-SQL
• Experience with developing complex SQL queries, stored procedures and materialized views
• Anticipating Assist developers and end-users with database usage, query development and tuning.
• Ability to partner with teams such as developers, vendors, analysts, and project managers
• Excellent verbal and written communication skills with the ability to work effectively in a group setting. Consistent and proper communication to management and team.
• Must be able to provide after hours on-call support for 24/7 mission critical applications.
• Experience of Scripting in Microsoft and/or Linux environments
• Strong understanding of SQL Tuning
• Review SQL logs

• Analyzed large-scale business and transactional datasets using SQL and Base SAS 9.4 to support
  reporting, analytics, and decision-making.
• Developed and executed SAS programs using DATA steps, PROC SOL, PROC SUMMARY and PROC
  REPORT to extract, transform, and validate data from relational databases.
• Wrote and optimized complex SQL queries, joins, and aggregations for data validation, reconciliation, and
  reporti ng requ irements.
• Performed data quality checks, reconciliations, and anomaly detection to ensure accuracy and consistency
  across multiple data sources.
• Supported Power Bl reporting by preparing, validating, and structuring datasets, KPls, and calculated
  measures for dashboards.
• Translated business requirements into technical data logic, validation rules, and reporting specifications, and
  supported UAT and defect resolution
• Proficient in designing, creating, and maintaining SQL/SAS databases
• Skilled in developing database schemas, tables, views, and stored procedures
• Strong expertise in writing complex SQL/SAS queries to extract and manipulate data effectively
• Experience in data selection, updating, deletion, and insertion operations
• Demonstrated ability to analyze extensive datasets using SQL/SAS for insightful reports
• Experience in generating routine and ad-hoc reports using tools like SAS Visual Analytics
• Experience with data visualization tools such as Power BI, or SAS Analytics for creating insightful reports and dashboards
• Optimizing database performance by resolving bottlenecks and fine-tuning SQL queries
• Proficiency in implementing indexing strategies for improved efficiency
• Skilled in designing and implementing ETL processes for data movement and transformation
• Experience in data cleansing, validation, and transformation
• Collaborative team player with the ability to work alongside data analysts, scientists, and stakeholders
• Commitment to staying updated with the latest SQL/SAS technologies and best practices
• Strong troubleshooting and debugging skills to identify and resolve database-related issues
• Experience in project planning, task estimation, and meeting deadlines
• Adherence to coding standards and best practices throughout project execution.

• Gathering and documenting business and regulatory reporting requirements and

translating them into structured database and data processing specifications for banking

information systems.

• Assisting in the design, enhancement, and maintenance of relational database

structures and data models to support reporting applications, ensuring efficient storage,

retrieval, and consistency of data.

• Developing, modifying, and optimizing SQL queries, stored procedures, and database

scripts to extract, validate, transform, and reconcile large volumes of transactional and

financial data.

• Operating and analyzing datasets using SAS 9.4 tools (DATA steps, PROC SQL, PROC

SUMMARY, PROC REPORT) t o generate analytical outputs, perform data mining

activities, and support regulatory reporting processes.

• Performing comprehensive data validation, reconciliation checks, exception handling,

and documentation of data definitions, access rules, and reporting logic to maintain data

integrity and governance standards.

• Supporting system testing, database refresh cycles, backup validation activities, and

collaborating with I T and reporting teams to ensure secure, compliant, and reliable

database operations.