• Developing ETL scripts for data retrieval and migration from different data sources to build a data warehouse• Conceptualization, development and maintenance of ETL solution/Data warehouse using in-house developed BI framework• Making changes to existing ETL scripts to enhance their performance• Responsible for maintaining the Data warehouse derived from multiple application databases• Creating reports using the BI Data warehouse for business users

• Developing, improving and implementing both client specific reports using Oracle SQL and PL/SQL to retrieve business and end-user data• Developing migration scripts, modeling client’s existing data for their usage in our system• Developing SQL*Loader and PL/SQL scripts for data conversions• Handling developments/enhancements raised both internally and by client using Oracle SQL, PL/SQL, Java, and UNIX Shell scripting• Developing database objects i.e. Stored Procedures… Show more • Developing, improving and implementing both client specific reports using Oracle SQL and PL/SQL to retrieve business and end-user data• Developing migration scripts, modeling client’s existing data for their usage in our system• Developing SQL*Loader and PL/SQL scripts for data conversions• Handling developments/enhancements raised both internally and by client using Oracle SQL, PL/SQL, Java, and UNIX Shell scripting• Developing database objects i.e. Stored Procedures, Functions, Packages, triggers, views using SQL and PL/SQL for the system• Performing SQL and PL/SQL tuning of the application using Explain Plan, Hints package• Designing Dimensional Model Creation, Partitioning, creating ETL tasks and Materialized Views• Helping QA during the testing phase with their general project related and other functional and technical queries• Proactively solving customer issues (both Production and Test environment) by addressing their concerns as well as conducting meetings with stakeholders• Liaising with Business Analysts, Team leads, QA analysts and other key stakeholders for the changes involved during the project and development walkthroughs Show less

• Helped peer students who were facing difficulty in courses related to Oracle Database object development, PL/SQL, Java, Web development, XML and JavaScript• Provide specific methods to students for time and stress management• Experience of installation, configuration and implementation of Oracle Business Intelligence Suite (OBIEE)• Worked closely with peer students to help them in designing and developing Oracle databases

• Worked with clients majorly Banking Institutions like Citibank, ICICI Bank Ltd. India, State Bank of India, State Bank of Mauritius, Religare Finvest Limited, etc., which involved understanding the requirements, developing them and then finally taking them for User Acceptance Testing (UAT) and Production being a part of Implementation team• Handled developments/enhancements/issues raised by clients, which involved working extensively with SQL, PL/SQL, Core Java, JSP, and Struts•… Show more • Worked with clients majorly Banking Institutions like Citibank, ICICI Bank Ltd. India, State Bank of India, State Bank of Mauritius, Religare Finvest Limited, etc., which involved understanding the requirements, developing them and then finally taking them for User Acceptance Testing (UAT) and Production being a part of Implementation team• Handled developments/enhancements/issues raised by clients, which involved working extensively with SQL, PL/SQL, Core Java, JSP, and Struts• Created Database objects – Schemas, Tables, Indexes, Views, User Defined Functions, Cursors, Triggers, and Roles• Created and maintained logins, roles and permissions on the SQL instances and databases and provided required privileges according to the user’s requirements• Parsed and validated XML data to perform SQL, PL/SQL database operations• Worked within organization as Software Developer/Tester of FinnOne CAS (Customer Acquisition System), LMS (Loan Management System) and Forecaster modules• Actively participated in Sprint planning meetings, Daily Stand-up meetings and Retrospective meetings• Developed an interface to interact with CIBIL (Credit Information Bureau (India) Limited) for obtaining the Credit Information of Corporate Customer, to help identify the credit history of the Corporate seeking for credit Show less

• Worked as a part of intern team to develop GUI Interface which automated the process of sending promotional messages to the customers• Gained some valuable experience working with IT team on handling UNIX based servers which involved some basic Shell scripting