Sahil Mehta

Mumbai, India

adcjep@r.postjobfree.com,

+91-986*******

Career Objective

Seeking a challenging role in IT as a Project Manager / Analyst to contribute towards organizational success.

Summary

Young, energetic and result driven technical professional with over 8 years of experience in the field of software development in Advent Geneva: RSL/RDL Development & Geneva Production Support; Possess strong analytical and domain knowledge necessary for the satisfactory performance of all assigned responsibilities; Deep understanding of technology with focus on delivering business solutions; multitasking ability to sketch the plan, prioritize the work and manage complex tasks under aggressive timelines; highly ethical and trustworthy.

•Proficient at learning new concepts quickly, working well under pressure and communicating ideas clearly and effectively.

•Dedicated and highly ambitious to achieve personal goals as well as the organizational goals.

•Excellent decision making skills with a positive approach.

•Possess technical as well as functional knowledge.

Professional Experience

•Fascet LLC (October’18 - Present)

•Team Lead – Geneva reporting services

•Gravitas Technologies (April’15 – September’18)

•Senior Specialist - Advent Geneva RSL/RDL Development

•SS&C GlobeOp Financial Services (May’11 – April’15)

•Senior Associate – Advent Geneva RSL/RDL Development

Technical Skills

•Programming Languages: RSL, Python, Shell, & Perl Scripting

•Reporting Tool: SSRS/RDL

•Database: SYBASE, SQL

•Operating System: Windows, Linux, Unix

•Version Control: CVS

Achievements

Scored 100 on 100 in Financial Accounts in HSC board examination.

Best performer in the team with 5/5 rating for 2013 and 2014 at SS&C GlobeOp.

Educational Qualification

•Master of Computer Applications (MCA) from K. S. O. U with second class.

•Bachelor of Computer Applications (BCA) from Tilak Maharashtra Vidyapeeth with first class.

•Bachelor of Commerce (B. Com) from M.K. Sanghvi College of Commerce, Mumbai with first class.

•To pursue CFA I, June 2020

Projects at Fascet LLC

Project: Portfolio Migration

Duration: 3 months

Platform/OS Used: Python 3.7 / Geneva 16.2 / MS Visual Studio 10 (SSRS) RDL

Overview: Migrating approx. 150 old portfolios to new portfolios in Geneva

Responsibilities:

•Creating specifications and workflow document.

•Developing RSL (Geneva) to fetch open tax lots from the existing old portfolios

•Developing loader formats for new portfolios such as Delivers, Receives, Spots, Forwards, etc with appropriate mappings.

•Loading the data into new portfolios.

•Developing a python script to automate the complete process

•Run reconciliation to make sure there are no discrepancies.

Project: Reporting Development

Duration: On-going

Platform/OS Used: Geneva 17.2 / MS Visual Studio (SSRS) RDL

Overview: Developing Geneva reports for Bank Debt / Credit Facility (revolver / term loans).

Responsibilities:

•Gathering requirements from the client

•Documenting / creating specifications of the requirement.

•Co-ordinate with the Business Analyst and perform the below steps:

a) Define credit facility

b) Define global facility amount (loan amount)

c) Define credit contracts

d) Record contract activity.

e) Purchase the credit facility investment.

f) Record additional contract activity

•Developing RSL (back-end) and SSRS (Geneva UI report) to make sure the all values such as Borrower, Investors, Contracts, Global Facility Amount, Funded Portions, Unfunded Portions, etc. are correctly reflected.

•Testing the report across different portfolios and accounting periods with test scenarios.

•Once approved by the client, deploying the report into production.

Project: Data Warehouse Extracts

Duration: On-going

Platform/OS Used: Geneva 17.2 / MS Visual Studio (SSRS) RDL

Overview: To replace client’s existing accounting application (Portia) and migrate data and other reporting services with Geneva.

Responsibilities:

•Gathering requirements.

•Documenting / creating Specifications of the existing reports and data points from the current system.

•Creating an end-to-end work-flow diagram to demonstrate the data flow.

•Analysing impact on downstream applications.

•Creating Geneva extracts from scratch to load data in the data warehouse.

•Creating custom Geneva reports.

•Liaising with client and business analyst for data sanity.

Projects at Gravitas Technologies

Project: Rebranding Reports

Duration: 2 months

Platform/OS Used: Geneva 10.0 / MS Visual Studio (SSRS) RDL / Python 2.7

Description: On account of a client getting acquired by a new entity, over 1000 reports had to be re formatted as per new standards.

Responsibilities:

•Leading as project manager.

•Modifying over 1000 RDL’s via a python script.

•Making sure the RDL’s work as expected by co-ordinating within the QA team.

•Deploying RDL’s into production.

Project: Datawarehouse Upgrade

Duration: 2 months

Platform/OS Used: Client Data warehouse / Geneva / MS Visual Studio (SSRS) RDL

Responsibilities:

•Leading as project manager.

•Understanding the impact of upgrade on the system and downstream applications.

•Understanding new functionalities and issues.

•Co-ordinating with the Data warehouse vendor to address all issues.

•Making sure the upgrade works out smoothly to achieve the Go Live date.

Project: RSL/RDL development

Duration: Ongoing

Platform/OS Used: Geneva RSL / MS Visual Studio (SSRS) RDL / Geneva GUI v10.2

Responsibilities:

•Developing reports from scratch based on client requirements.

•Getting the requirements from the client in form of BRD for the change on existing reports.

•Understanding the requirements and liaise with the client.

•Changes are done at the RSL, RDL or a separate Data warehouse.

•Performing internal testing and sending it across to the client.

•Once approved deploying on production.

Project: RSL to SQL CLR migration

Duration: 3 months

Platform/OS Used: Geneva RSL / SQL

Responsibilities:

Understanding the RSL logic from scratch and creating a document for easy understanding.

Implementing the logic in SQL

Running tests to make sure the SQL output matches with the RSL output

Projects at SS&C GlobeOp

Geneva Version (8.5 and 10.0)

Project Name: RSL/RDL Development

Duration: Ongoing

Plat form/OS Used: UNIX/ Visual Studio 2008, Windows Server

Description: Developing new RSL/RDL and customizing existing RSL/RDL for new or existing reports as per client’s requirement.

Responsibilities:

•Analysing and understanding the business requirement and develop the RSL/RDL as per the requirement

•After development, carrying out the developer testing and pass it for Business Analyst Testing and make changes according to the BA’s Feedback

•Get the BA and Client’s approval on the report change and move it to Prod

Project Name: Footprints, Advent Geneva Support and Maintenance

Client: Internal

Duration: Ongoing

Description: Resolving 6-8 Geneva related issues per day

Responsibilities:

•Proactively picking up and resolving footprint requests and answering important client’s emails

•Resolving critical issues with immediate attention

•Stay alert for monit emails, take necessary steps in checking / maintaining smooth flow of deals into Geneva and inform respective team accordingly

Project Name: Geneva Report Scheduling

Client: Internal

Duration: Ongoing

Plat form/OS Used: UNIX

Description: Developing shell scripts to automate the Geneva reports on FTP or Email requested as per the client and internal business team.

Responsibilities:

•Collect the requirement from the internal business team

•Develop the script and test it on my side

•Send it to Business team for testing

•Get the feedback and make the change if required/asked by testers

•Implement the script after testing approval

Project Name: Whole loan

Duration: Daily/Ongoing

Plat form/OS Used: UNIX

Languages/Tools Used: Java, Shell, Sybase

Description: It is an application which works on principle of ETL process. Gets data from different servicer; loads them into separate tables and then aggregate them into a single master table; run various reports.

Responsibilities:

•Collect requirements from the client and work accordingly

•Provide support and development to this project

•Generate Daily & Month End reports

Project Name: MMIF RSL development

Duration: Quarterly

Plat form/OS Used: UNIX

Description: A report submitted to the Central Bank of Ireland on a quarterly basis.

Responsibilities:

•Liaise with the project manager on the changes required each quarter.

•Make required changes at the RSL and RDL level.

•Make sure the report matches with the norms provided by the Central Bank of Ireland.

•Maintain data accuracy.

Apart from the above-mentioned projects, have also worked on few Java, xslt and perl projects.

Additionally, have been a part of the Geneva upgradation from 9.0 to 14.2.

Personal Vitae

•Date of birth: 19th January 1991

•Languages: English, Hindi, Marathi and Gujarati

•Permanent Address: C-202, Sunder Park, Veera Desai Road, Andheri West, Mumbai 400053.

Contact this candidate