• Responsible for managing entire ETL Process for one of the Bank’s Internal Application.• Responsible for maintaining, managing and architecting entire Database design (EMDB) for the Application.• Responsible for data discovery, analysis, Integration and reporting of various Assets and Configuration Items of the bank Infrastructure by means of different discovery tools and through various System of records.• Responsible for creating and managing Autosys batch process, developing new dashboards and reports.• Responsible for setting up new database and reporting environment including building ETL servers.• Responsible for data modelling, data architecture, SQL Performance tuning for existing and new products.• Developed several Infrastructure Asset reporting dashboards like Server, Network, Load Balancer, Risk, Datacenter, Storage, Server Backup, Workstations, Mobile devices, Host Monitoring, NPT Infrastructure etc.• Responsible for creating plans and Migrating existing NPT (Non-Permitted Technologies) Infrastructure to new Non-NPT Infrastructure (Cloud Infrastructure). • Creating and managing SQL scripts to Identify unknown IP’s in the bank, aligning them to Device types, Host names, Application owners ultimately reducing bank’s exposure to unidentified network, reducing risks to the overall network, enabling efficient and faster means to remediate vulnerabilities on the network.• Planning and managing annual database Application Resiliency Testing exercise of failing over to contingency nodes and failing back to Primary nodes.• Identifying operational and infrastructure risks and creating mitigation plans.• Providing consultation in setting up new database operational environment.• Advising cross teams in data modelling and data architectural design of new products.• Responsible for developing ETL process using SQL Server, (Rest API’s) using C# and SSIS. • Responsible for gathering project requirements, planning deliverables and executing tasks.

• Gained knowledge about the Bank Structure, different LOB's in the Bank.• Creating and transforming data into meaningful information in data visualization tools like Tableau• Creating Dashboards and reports using advanced Tableau functionalities like Geo-tagging, Maps,Drill-down reporting.• Presenting these reports to the Executives.• Automation using Excel Macro likewise saving time and effort and improving accuracy and efficiency by reducing human intervention in processing huge amounts of data• Working extensively on Microsoft SharePoint and improving certain processes in the Bank.• Actively involved in different forums in the bank to share and gain knowledge about different tools and technologies used within the Bank.• Understanding the business flow, simultaneously analyzing vital data and finding out ways to improve business value for internal and external clients.• Network with various Executives across various LOB's and getting to know the kind of projects they work on and the kind of issues they encounter on daily basis.• Having fun meeting new people during networking events and exploring opportunities within the Bank.

• Finding ways and means of improving process to increase business value• Suggesting innovative strategies and ways to retain existing customers and increasing customer base, ultimately improving business value and increasing revenues• Designing the User Interface for faster access and user friendly navigation across the portal• Developing an insurance product from rating of policy to issuance, endorsement, renewal, cancellation, reinstatement and claims• Keeping the response time of the policy portal (UI) under check also reducing downtime• Interacting with the clients and collecting user requirements for new and existing products• New Auto and Home Insurance product setup and implementation• Mapping functional requirements with designers and converting into technical specification• Creating and modifying PLSQL packages, procedures, and functions, collections and cursors and advance PLSQL objects• Creating and improving user interfaces for different product modules• Following Test Driven Development (TDD) approach. • Writing and Executing test cases for Unit testing • Supporting CIT and E2E teams during issues (Fixing Bugs). • Resolving functional/technical queries of the team and the customers• Providing 100% support in deployment and pre-deployment activities • Providing support in Deployment of the code in Production. .• Following all the quality activities during coding such as CQM (Code quality management) & TDD (Test Driven Development) using QTP (Quick Test professional) tool.• Handling of Code Review and tuning of the PLSQL code for faster and efficient execution.

As a OBIEE, OWB Developer/ ETL Analyst• Managing the entire ETL life cycle.• Coordinating with the designers for understanding new requirements and change requests.• Creating OBI Repository (RPD) and Dashboard (Reports/Webcat) based on user requirements.• Giving presentations of reports to the clients for their final sign-off and constantly seeking ways and means to improve report quality.• Creating dynamic reports, charts, graphs, pivot tables using Oracle Business Intelligence• Worked on SAP Business Objects and Web Intelligence for object mapping, creating universes and reporting.• Created and modified OWB mappings• Cleansing and cleaning data from the source systems • Using Tableau as a tool for creating business reports for clients.• Analyzing data and applying required business rules As a PL-SQL Developer• Coordinating with designers for new requirements and enhancement. • Tuning existing PLSQL code for efficient query runtime and execution• Creating and modifying indexes for faster execution• Creating MOM and documenting issues, bugs and solutions for future use• Supporting CIT and E2E teams during issues (Fixing Bugs). • Supporting in deployment and pre-deployment activities• Following all the quality activities during coding such as CQM (Code quality management) & TDD (Test Driven Development) using QTP (Quick Test professional) tool• Handling of code review and preparing performance sheets which gives the time estimate and predicts performance statistics for the new code on production environment