Jan 2020 – Aug 2021 · 1 yr 7 mos · Mumbai, Maharashtra, India

Sep 2014 – Jan 2020 · 5 yrs 4 mos · Mumbai, Maharashtra, India

• Lead techinal and data analyst working in the Wealth management division within Morgan Stanley.
• Extensive use of visualization tools like Tableau, Qlikview, Business Objects to cater to the reporting and dashboarding needs of various verticals within Wealth Management

Jun 2012 – Sep 2014 · 2 yrs 3 mos

• Working as part of the FRO Business Intelligence team on URL Project.
• Aim of the project is to have a Uniform Reporting Layer capable of fetching Data from any of the underlying financial systems used in Citi.
• My main responsibilities include working on Web I 4.0 to build the Reports for the Senior Management of CITI.
• Also involved in the Development of Pearl Dashboard using Dashboard Builder (Previously known as Xcelsius in 3.1) used by the management.
• Extensive Use of BO 4.0 for creating numerous reports for bank which includes various complicated month and Quarter end reports.

May 2010 – Jul 2012 · 2 yrs 2 mos

• Technology : Business Objects,Informatica, Oracle and HP Neoview.
• Clients : Bank of India
• Projects : Loan and Deposit Analytics.
• Involved as a part of the Datawarehousing team working in the BFSI domain.
• I am working at the Client side (Onsite) at Bank of India and involved in the end to end implementation of datawarehousing projects using Informatica as an ETL tool for extracting data from Finacle CBS to the Neoview server and transforming the data and making it available for analysis purpose.
• My Main responsibilities include development of SQL Scripts for meeting the Bank requirements and extensive use of Informatica for carrying out ETL extraction process.
• Successfully delivered the Loans and Deposits Module for our first Client i.e. Bank of India (BOI)
• Also involved in Business Reporting using Business Objects as a Reporting tool.
• Created numerous complicated reports using BO XI 3.1 for RBI reporting.

Oct 2009 – May 2010 · 7 mos

• Technology : Informatica, Oracle,
• VB Script and Java script.
• Clients : Cisco system, Star TV
• Projects : AD Sales Analytics.
• Vistaar is a leading product company in the pricing and Analytics domain.
• Involved as a part of the Professional Service Organization (PSO) team which is responsible for building customized solutions for the clients as per their requirements.
• My work involved extensive knowledge and use of OLAP Concepts.
• Was majorly involved in the ETL process using Informatica and working on Oracle databases for data extraction for Star TV and development of Dashboard for business analytics for use by the Upper Management of STAR TV India.
• My Main responsibilities include working on Oracle database as part of ETL process using Informatica for extracting the data from Oracle database to make it available to our application and developing modules in JavaScript/VBScript.