 Participation in requirement gathering and translate business needs to technical specifications. To design, build and deploy BI Solutions (Reports and dashboards) using BI tools like Noetix, MSBI (SSIS, SSRS), MS Power BI to support business decision making and performance monitoring. Participated in data warehouse design, data modelling and develop database objects like Stored procedure, functions, packages in different databases such as Oracle and SQL Server. To regularly monitor BI reports, dashboards and their performance and tune them when performance degrade by analyzing trace files and tools such as SQL profiler as a part of system health check process. To create new ETL pipelines and jobs to fetch data from different sources and perform data transformation tasks such as data wrangling, data cleaning by creating stored procedures and T-SQL scripts. To regularly monitor ETL Jobs and tune them, if required, using different methods for the timely delivery of data to business users. To conduct unit testing and perform troubleshooting while creating new BI Solution. To coordinate with different teams to provide efficient solution (existing or new) to business users as per requirement. To frequently collaborate with business users, stakeholders, and clients across the globe. Working closely with project manager to analyze the problem and to propose related solution in a timely manner under an agile environment. Daily scrum meetings to discuss the issues and progress made on the current project/assignments and update the tasks in Azure DevOps regularly. Involved in Data Analytics project using Microsoft Azure Synapse wherein performed data ingestion activities from various sources to Azure Data Lake Storage using Azure Data Factory, data transformation using PySpark, SQL Pool and Spark Pool and generated reports and dashboards for business

• To do the modification in packages and procedures as per client’s requirement.• Involved in Logical & Physical Database Layout Design.• To make changes in database object such as indexes, table partitioning, views to keep them efficient.• Involved in performance tuning of multiple packages and procedures to increase the efficiency of the database using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.• Used Bulk Collections for better performance and easy retrieval of data.• To take database backup regularly using Oracle data pump utilities.• Involved in handling production support issue and doing root cause analysis.• Regularly created and modified Unix shell scripts as per client’s requirement.• Collaborated with developers and peers to enhance supportability and identify the performance bottlenecks.

• Developed PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic.• Involved in creating UNIX shell Scripts. Table partitioning, indexing for improved performance and efficiency.• Involved in the continuous enhancements and fixing of production problems and provide root cause analysis.• Create and modified the SQL files to create the tables in database.• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

• Worked with Sql*Loader for data migration from legacy database to oracle database.• Participated in the development of new PL/SQL procedures, functions and triggers and updating the old database objects as per change request.• Created various DML and DDL Statements using Oracle PL/SQL and SQL.• Worked with SQL Trace, TKPROF in generating statistics to find queries which degrade performance and tune them.• Participated in creation of database objects table, views, cursor, procedures using SQL*PLUS, SQL Developer tools and handled exceptions.• Worked closely with client to create custom reports using Jasper soft tool.• Participated in providing support to client and fixing issues after deployment in production environment.