Jul 2024 – Present · 1 yr 8 mos

• With expertise in development, maintenance, and post-implementation support, I have extensive experience in PL/SQL programming, debugging PL/SQL code and UNIX scripts, and conducting root cause analysis to enhance Oracle PL/SQL packages, procedures, triggers, and functions. I have resolved 95%+ of technical issues proactively, reducing resolution time by 30%, and ensuring 100% data accuracy through in-depth SQL analysis. Skilled in modifying functions based on PRCRs, I also create complex SQL queries using CTEs and develop optimized DAX expressions for advanced calculations and data modeling in Power BI. My work includes designing interactive dashboards to track KPIs and security metrics, increasing user engagement by 20%, and enabling seamless data navigation through dynamic visuals. Proficient in Excel for advanced data analysis, I also manage Change, Problem, and Incident Management using ServiceNow and effectively estimate requirements for efficient planning and execution.

Oct 2023 – Jun 2024 · 8 mos

• Experienced in data analytics and reporting support using SAP Business Objects with an Oracle PL/SQL database, specializing in maintaining and modifying reports as per business needs. Proficient in executing DML operations, designing efficient stored procedures, functions, and PL/SQL packages to enhance data processing speed by 75% and improve system performance. Adept at conducting impact analysis with 360 Eye Suits, optimizing report performance, and enhancing existing universes based on user requirements. Skilled in identifying and resolving database errors, managing service requests and incident tickets through Cherwell and JIRA, and ensuring timely issue resolution with minimal downtime. Strong in business logic implementation, requirement analysis, and stakeholder communication. Highly proficient in Microsoft Excel for in-depth data analysis, leveraging advanced functions such as VLOOKUP, HLOOKUP, PivotTables, and custom formulas to organize, interpret, and present data effectively.

Oct 2022 – Sep 2023 · 11 mos

• Experienced in Windows application development and support on AutoCAD (C#) with Oracle PL/SQL as the backend, including maintaining and modifying ETL packages. Skilled in planning deployments across DEV, SAT, and production environments, collaborating with development teams for enhancements and bug fixes, and providing support for new code changes as well as existing applications. Adept at handling user tickets, maintaining knowledge transfer documents, and delivering KT for newly added modules. Worked on GIS technology concepts within AutoCAD applications and actively participated in Agile practices such as daily stand-ups, sprint planning, and retrospectives. Committed to delivering clean, modular, and well-documented code, achieving a 75% reduction in post-deployment defects while ensuring scalability and ease of maintenance, along with comprehensive technical documentation for complete requirement traceability and regulatory compliance.

Jun 2021 – Sep 2022 · 1 yr 3 mos

• Experienced in Windows application development and support on AutoCAD (C#) with Oracle PL/SQL as the backend, including maintaining and modifying ETL packages. Skilled in planning deployments across DEV, SAT, and production environments, collaborating with development teams for enhancements and bug fixes, and providing support for new code changes as well as existing applications. Adept at handling user tickets, maintaining knowledge transfer documents, and delivering KT for newly added modules. Worked on GIS technology concepts within AutoCAD applications and actively participated in Agile practices such as daily stand-ups, sprint planning, and retrospectives. Committed to delivering clean, modular, and well-documented code, achieving a 75% reduction in post-deployment defects while ensuring scalability and ease of maintenance, along with comprehensive technical documentation for complete requirement traceability and regulatory compliance.

Mar 2021 – May 2021 · 2 mos