Subhramanyam Pantula

A core database developer is responsible for the analysis, design, and development of data solutions across both SQL Server,ETL.

Client :- CitiBank

• Built intricate SQL queries to extract, aggregate, and analyze financial data, optimizing performance for large datasets.
• Developed SQL and PL/SQL scripts to migrate and transform data between different database systems and formats.
• Developed SQL and PL/SQL scripts to handle large batch processing jobs, improving efficiency, and reducing processing time.
• Developed indexes to improve the performance of queries.
• Designed and implemented PL/SQL stored procedures and functions to automate complex business logic and data validation.
• Developed Unix shell scripts based on business requirements.
• Developed Splunk dashboards.
• Developed ETL graphs to migrate the data from different databases, and generated reports to downstream.

I served as a Consultant Package Implementation at LTIMindtree, where I played a pivotal role in implementing packages, designing interfaces, and leading data analysis and development initiatives within SQL, Oracle, and Unix environments.

Client: UBS Taiwan.

• My responsibilities encompassed the full project lifecycle, from analysis and design to implementation and optimization.
• Interface Design: Designed and developed efficient, user-friendly interfaces that facilitated data exchange between different systems.
• These interfaces streamlined data flows.
• Data Analysis: Conducted in-depth data analysis to extract valuable insights and inform decision-making processes.
• Utilized SQL to query, manipulate, and transform data sets.
• Development: Leveraged SQL and Oracle to develop robust data solutions that met clients' evolving requirements.
• Optimized database structures, queries, and procedures to enhance performance and ensure data integrity.

Client: CAIXA

• Developed SQL queries employing inner, left, right, and full outer joins to consolidate data from disparate tables for comprehensive reporting.
• Engineered subqueries and correlated subqueries to extract specific data subsets based on complex business logic.
• Utilized Common Table Expressions to simplify complex queries and improve readability.
• Responded to and resolved escalated database incidents and service requests.
• Developed and maintained SQL scripts for data correction and maintenance.