INDU Kodali
Frisco,TX
Summary
Experienced and results-driven IT professional with over 12 years of expertise in software development, database design, data integration, and data warehousing across Financial, Manufacturing industries. Proficient in RDBMS systems, OLAP/OLTP, and delivering end-to-end solutions for complex projects. Skilled communicator with strong analytical abilities and a proven track record in system analysis, performance optimization, and leading technical teams.
Overview
12
12
years of professional experience
Work History
Data Engineer
Fidelity Investments
03.2021 - 07.2025
- Collaborated with cross-functional teams to define data requirements and ensure alignment with business goals.
- Collaborated with system architects, design analysts and others to understand business and industry requirements.
- Developing or enhancing APIs in PL/SQL according to the business requirements.
- Designed and implemented ETL workflows using Informatica to integrate data from multiple sources.
- Created CI/CD pipelines for database and ETL deployments using Jenkins and UDeploy.
- Led end-to-end implementation of multiple high-impact projects from requirements gathering through deployment and post-launch support stages.
- Migrated 90+ Autosys jobs across applications, ensuring minimal downtime and high data integrity. Created shell scripts in CSH, KSH for managing/executing the AutoSys jobs, Python scripts, etc.
- Migrated legacy systems to modern big-data technologies, improving performance and scalability while minimizing business disruption.
- Created a data integration framework end-to-end to support the application for ETL pipelines.
- Worked in Linux-based systems to debug the issues for deployments and executions of CI/CD jobs and ETL jobs.
- Collaborated with QA teams to prepare test data, and validate software performance.
- Optimized database performance by using function-based indexing, table partitioning, and AWR reports.
- Coordinated and implemented data validation processes to ensure data accuracy and integrity in production systems.
- Conducted peer reviews of technical designs and code to maintain high-quality standards.
- Created technical documentation for ETL workflows, database schemas, and deployment processes.
- Provided support as a Tableau administrator and designed, deployed Tableau dashboards for advanced data visualization and reporting.
- Coordinated with business users to gather requirements for Tableau report enhancements and modifications, ensuring that the reports were successfully tested and published in the production environment upon completion.
- Supported DevOps initiatives by enhancing release automation pipelines, and troubleshooting build failures.
- Provided post-production support, and resolved critical incidents to maintain high system availability.
- Oversaw monthly production deployments, including the creation of comprehensive release plans derived from JIRA issues. Developed and executed detailed validation scripts to ensure the accurate deployment of all required objects.
- Developed UT (Unit Test) packages to comprehensively test PL/SQL packages, ensuring full coverage of functional and technical requirements through robust test cases.
- Designed and implemented CI/CD pipelines by configuring Jenkins and Udeploy for seamless end-to-end deployment of multiple applications, collaborating effectively with cross-functional teams.
- Modified existing OBIEE reports to incorporate necessary enhancements, ensuring thorough testing before publishing them to the production environment.
- Organizing monthly team-building activities, including team games, to foster collaboration and strengthen team dynamics.
- Creating, enhancing, and decommissioning packages and stored procedures in accordance with project requirements.
- Conducted extensive troubleshooting to identify root causes of issues and implement effective resolutions in a timely manner.
- Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
- Created Python scripts to create KR's Tests to support our applications using REST APIs and scheduled using Crisp Airflow.
- Created SQL queries from a Snowflake-based data warehouse to support Tableau reports and Python-based tests for our applications.
- Conducted code reviews to maintain high standards of code quality and adherence to project specifications.
- Worked closely with Quality Assurance teams throughout development to ensure a high level of code quality and adherence to requirements.
- Utilized agile methodologies to develop software of varying complexity and business needs.
- Performed code refactoring and optimization to improve performance.
Sr.Oracle PL/SQL Developer
Wells Fargo Advisors
08.2018 - 02.2021
- Acts as a lead in providing application design guidance and consultation.
- Acts as an expert technical resource for modeling, simulation, and analysis efforts.
- Documented technical specifications and design decisions for future reference, enabling efficient knowledge transfer within the team.
- Verifies program logic by overseeing the preparation of test data, test scripts for testing, and debugging of programs.
- Mentored junior developers on SQL best practices and troubleshooting techniques.
- Provided technical support for end-users by addressing SQL-related issues, enhancing overall user satisfaction with the application.
- Involved in production deployment and in post-production support of the applications.
- Developed custom database objects, stored procedures, and delivered application support.
- Worked closely with Quality Assurance teams throughout development to ensure a high level of code quality and adherence to requirements.
- Resolved complex business issues, proposing long-term solutions to avoid repeat problems.
- Developed complex SQL scripts for data analysis, leading to deeper insights and supporting strategic planning.
- Working with the DBA and data modelers for the ongoing production issues.
- Performed code refactoring and optimization to improve performance.
- Enhanced database performance by optimizing SQL queries and indexes, significantly reducing response times.
- Supported large-scale data migrations to new platforms, minimizing downtime and data inconsistencies.
- Debugged problems caused by hardware, operating systems software, application programs and network failures.
- Migrated the legacy applications from DB2 to Oracle.
- Maintained high-quality code standards through rigorous testing and peer code reviews, minimizing potential bugs and security vulnerabilities.
Oracle PL/SQL Developer
US Bank
08.2012 - 01.2013
- Develop queries/stored procedures to analyze and correct issues in the Oracle OIM/OIA provisioning system.
- Data analysis to determine discrepancies between the two systems and generation of SQL to correct issues as they are found as well as reporting trends in those discrepancies.
- Cleanup of data initiative for the mainframe. This involves data ETL of both data from mainframe reports and OIM/OIA data.
- Analysis and generation of mainframe commands to add users to missing mainframe groups as well as analysis of RACF permission sets and reporting of access that users may lose based on the cleanup process.
- Develop other ad hoc queries based on need for OIA/OIM clean up.
- Created and maintained Tables, procedures, and Indexes.
- Tuned PL/SQL Stored Procedures/Functions to improve the performance by creating function-based Index, Optimizer Hints, Explain plan and analyzing the tables.
- Involved in creating DYNAMIC SQL that will update or insert data into the tables on the run.
- Exporting and importing the data into the database as and when user provided the data and do analysis.
- Worked closely with the ETL Team to provide database information .
- U.S. Bank is the fifth-largest bank in the country and its core businesses include Consumer & Business Banking, Corporate & Commercial Banking, Payment Services and Wealth Management & Financial & Investment Services.
- Environment: Oracle database 11g, TOAD 9.5, SQL Developer, SQL
- PLUS, MS SQL SERVER ,T-SQL,MS SQL Server Integration/Reporting services (SSIS/SSRS) ,AIX Unix operating system, Windows 2008, Tivoli Workload Scheduler, WinSCP, Filezilla, Putty and MS Visio 2010,Java 1.7
Database Developer/Analyst/Application Developer
ITC Limited-Paper Boards & Specialty Papers Division
06.2006 - 09.2010
- Designed, developed, and enhanced custom forms and reports according to the functional specification.
- Developed complex SQL queries for data analysis, supporting decision-making processes across departments.
- Provided expertise to development managers in designing or preparing proof-of-concept testing.
- Established strong working relationships between different departments by effectively communicating database requirements and changes.
- Resolved critical production issues within established SLAs, thus minimizing the impact on end-user experience and business operations.
- Delivered complex business requirements without any issues by leveraging strong troubleshooting skills and extensive oversight.
- Created various feeds, downloads, nightly batch jobs, and other daily or monthly reports.
- Tuned batch jobs and other daily, monthly reports, and downloads.
- Developed and enhanced around 200 reports using 10g/6i to meet the business needs.
- Developed critical Reports that helps the business users.
- Development of dynamic reports by using lexical parameters to run the generic reports.
- Developed complex Oracle Forms, providing extensive GUI features (multi-selects, drag and drop, graphical charts, automated system alerts, and notifications, etc.).
- Tuned SQL queries and performed refinement of the database design, leading to significant improvement in system response time and efficiency.
- Preparing a test plan for QA for testing before moving from the preproduction to the production environment.
- Troubleshooting the day-to-day problems in the areas of costing, process raw materials and raw material accounting, security systems, stores, private vouchers, and OptiVISION (OTIF).
- Providing data to corporate auditors and to the users, as per their requirements.
- Modifying forms, reports, stored procedures, packages, triggers, functions, etc., to meet the business requirements.
- Developed a website internal to a department in ITC using HTML5, CSS3, Flash, Adobe Photoshop, and JavaScript tools.
- Preparation of unit and integration test scripts for testing, to perform testing in all the testing environments, and creating the required documentation.
- Involved in production deployment and in post-production support of the project.
Education
Bachelor of Technology - Computer Science Engineering
Jawaharlal Nehru Technological University
Hyderabad, India05.2006
Skills
- Database Development: Extensive experience in SQL/PLSQL, query optimization, performance tuning, indexing, partitioning, and data modeling using tools like Erwin
- ETL & Data Integration: Expertise in Informatica and data migration between heterogeneous systems
- Data Warehousing: Proficient in Dimensional Modeling, Fact-Dimension schema design
- Technical Leadership: Skilled in mentoring teams, conducting code reviews, leading deployments, and coordinating with cross-functional teams
- Tools & Technologies: Proficient with Oracle (19c/12c/11g), MS SQL Server, Snowflake, Jenkins, GitHub, and UDeploy
- SDLC Methodologies: Experienced in Agile and Waterfall frameworks
- Cloud Technologies: Hands-on experience with AWS and Snowflake
- Databases: Oracle 19c/12c/11g, MS SQL Server, DB2
- Tools: SQL Developer, TOAD, Informatica, SSIS, Tableau, Power BI,OBIEE, Jenkins, UDeploy, GitHub, VSS
- Languages: PL/SQL, SQL, Java, JavaScript, HTML5, VBNet, Shell scripting
- Data Modeling: Erwin, Dimensional Modeling, Normalization / Denormalization
- Reporting Tools: Tableau,Power BI, OBIEE , Oracle Reports,Crystal Reports
- API development
- SQL performance tuning
- CI/CD pipelines
- Code review processes
- Business requirements gathering
Timeline
Data Engineer
Fidelity Investments
03.2021 - 07.2025
Sr.Oracle PL/SQL Developer
Wells Fargo Advisors
08.2018 - 02.2021
Oracle PL/SQL Developer
US Bank
08.2012 - 01.2013
Database Developer/Analyst/Application Developer
ITC Limited-Paper Boards & Specialty Papers Division
06.2006 - 09.2010
Bachelor of Technology - Computer Science Engineering
Jawaharlal Nehru Technological University