Looking for a job

Poornima Mahesh

@poornimamahesh

Message

IT Analyst at Tata Consultancy Services building Oracle PL/SQL solutions and reports for core banking data.

India

Message

At Tata Consultancy Services, I develop and maintain reports using Jaspersoft, querying Oracle and DB2 databases with SQL.

I design database tables, views, and indexes, and write PL/SQL procedures, functions, triggers, and packages to support application development and business logic.

I tune queries and reports using database indexing, EXPLAIN PLAN, and SQL Trace, and test reports for accuracy and reliability.

My work also includes analyzing data for business decisions, gathering reporting requirements, and supporting end users. I have experience in the core banking domain.

Experience

Work history, roles, and key accomplishments

Current

IT Analyst

Current

Tata Consultancy Services

Jan 2025 - Present (1 year 9 months)

Worked as IT Analyst at Tata Consultancy Services.

Current

Information Technology Analyst

Current

Tata Consultancy Services

Apr 2021 - Present (5 years 6 months)

● Developed and maintained reports using Jaspersoft, extracting data from oracle,db2 databases using SQL queries.
● Designed and optimized database tables, views, and indexes
● Wrote complex SQL queries, stored procedures, functions, views, triggers to support application development.
● Wrote optimized SQL queries to handle large data sets, ensuring the efficiency of data retrieval and manipulatio

System Engineer

Tata Consultancy Services

Apr 2021 - Jun 2025 (4 years 2 months)

*Designed and executed PL/SQL Procedures,Functions,Triggers,Views and Packages to address specfic data manipulation and business logic requirements.
*Expert in creating database objects like tables,views,cursors and sequences using Oracle SQL Developer Tool.
*Report Design and development using Jasper Soft Studio.
*Developed complex sql queries and PL/SQL code for efficient data retrieval in Repo