May 2010 – Sep 2014 · 4 yrs 4 mos · Mumbai, Maharashtra, India

• IOS is the business division responsible for implementing outsourcing arrangements with investment management clients. HiPortfolio, a fund accounting solution delivering trade and investment cycle, was used as the source to capture the security trade information, which is then sourced into Sybase. Investment management and reconciliation reports are then generated for the client using Actuate.
• Responsibilities:
• Worked as an IC (Individual Contributor)
• Interaction with Business Analysts and Stakeholders
• Estimation, Analysis & Design, Development, UAT support
• Technology : Actuate, Java, Sybase, Unix, Perl, Tcl/Expect
• Contributions:
• Worked as a Solution Architect with the local operations team and automated actuate report generation, thereby saving 4 hours of their daily time. 100+ parameterized reconciliation actuate reports had to be run on a daily basis, and then subsequently downloaded in pdf and excel report. Created a tool using Java and Actuate IDAPI, that triggers all the reports and downloads the pdf and excel output without any manual intervention. Built the tool from scratch.
• Worked in Actuate reporting tool and Sybase. Developed complex reports and stored procedures. Optimized existing long running queries and stored procedures.
• Developed shell scripts in ksh and perl that processes data to/from HiPort.
• Developed investment management and reconciliation reports in Actuate. * In depth knowledge of Actuate reporting tool, iServer, management console, active portal.
• Well versed with Autosys (development and deployment both).
• Well equipped with Agile methodology.

Jan 2009 – Apr 2010 · 1 yr 3 mos · Mumbai, Maharashtra, India

• SSTL Workstation is a Java based application, integrated with Actuate reports to generate Investment Fund reports to the investment management clients, and allows them to add/modify/delete a Fund and its corresponding NAVs.
• Responsibilities:
• Development of new enhancements in the existing application.
• Development of new reports that are completely dynamic in nature, and integrating them into the application.
• Technology : Actuate, Java
• Contributions:
• Stabilized the project amidst escalations.
• Developed a Java based tool that processes SWIFT messages.
• Developed Stored Procedures, functions, fix scripts to aid in reporting task.
• Performance Tuning and Optimization of existing reports.

Aug 2005 – Dec 2008 · 3 yrs 4 mos · Pune, Maharashtra, India

• GNSNIC is a Data Warehouse wherein all the proprietary and the partner Credit cards, issuer and acquirer, transactions are stored in a Mainframe application from live feeds. These transactions afterwards are stored in the corresponding tables in DB2 database on AIX platform. Actuate eReports, Information Objects, eSpreadsheets are then developed as per the business requirements. These reports are then triggered from a Struts based web application.
• Responsibilities:
• Estimation, Analysis & Design, Development, supporting the UAT for new reports and enhancement of existing reports as per the business requirements.
• Technology: Actuate, Java, DB2
• Contributions:
• Developed a Struts based application that enabled the business to view the Actuate reports online.
• Developed complex Actuate eReports, that had PLS, Report Bursting, IDAPI call, Information objects, eSpreadsheets with Matrix Scripting.
• Developed stored procedures for the reports and Unix shell scripts to populate data marts.
• Customized the Actuate Active Portal (Struts based) as per business requirements.
• Created test cases, disaster recovery documents.