Managing the Reporting and Analytics Services team Daily program management throughout the program life cycle - reporting and digital dashboards Managing risks and issues and taking corrective measurements Coordinating the projects and their inter-dependencies Managing and utilizing resources across projects Managing the main program documentations Design Reviews Solution Demos Project Governance Project Planning Team Management Scrum Master Finance and Budgeting

Responsibilities:• Stakeholder management.• Team management.• Training and mentoring new resources• Monitor the ETL cycles to ensure that the data is delivered on time• Monitor all the instances, batches and applications, analyze the root cause of job failures or batch or applications and act according to SLA.• Liaising with downstream applications if there is any delay in the delivery of data• Generating and delivering weekly, monthly and quarterly reports. • Automation of daily cycles report and checks for delivery of data to downstream

Responsibilities:• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.• Created and modified several UNIX shell scripts according to the changing needs of the project and client requirements.• Generated PL/SQL scripts for data manipulation and validation • Created PL/SQL stored procedures.• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.• Performed SQL and PL/SQL tuning using EXPLAIN PLAN• Involved in using hints to direct the optimizer to choose an optimum query execution plan.• Partitioned the fact tables to enhance the performance.• Created entries for framework tables.• Built the job flow diagram and Control M Schedule.• Created unit test plans and system test plans• Performed peer review and system testing.• Training and mentoring new resources.

Responsibilities:• Involved in creating and modifying UNIXshell scripts according to the changing needs of the project and client requirements.• Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.• Experience in DatabaseApplicationDevelopment, Query Optimization, Performance Tuning andcomplete SystemDevelopmentLifeCycle.• Worked on SQL*Loader to load data from flat files• Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target datastructures.