Business Systems Analyst, Team Lead
14+ years of comprehensive IT experience as a Business Systems Analyst, Team Lead and Software Developer with extensive recent experience in requirements gathering, analysis, and business processes management with strong knowledge of Software Development Life Cycle (SDLC). Well-versed in preparing Business Requirements Document (BRD) and Functional Requirements Document (FRD). Proven ability in functioning simultaneously as a BSA, team lead and manager as needed.
Areas of Expertise:
Onsite and Offshore Global Team Lead
Project Management from Inception to Implementation
User Relationship Management
Adept at Requirements Documentation (BRD/FRD)
Proven Ability to Multi-Task
Defining Testing Life Cycle and User Acceptance Testing
Software Development Life Cycle
Waterfall and Agile Methodology Implementation
Strengths and Weakness Analysis
Operating Systems: MS Windows (Win 2000, Win XP, Win 7, Win 10), UNIX
Databases: MS SQL Server, Sybase, Oracle
Analysis/PM Tools: MS Word, MS Excel, MS Project, Visio, JIRA, HP ALM, Synkronizer, Gliffy
Languages: C# and Visual Basic .NET, XML
Development Tools: Visual Studio .NET 2003/05/08/10/13/15
Web Programming: ASP .NET, HTML, CSS, XSL, Java Script
Reporting Tools: SSRS 2005, Crystal Reports 8/9/10
Source Control Tools: VSS 6.0, Perforce, Git, AccuRev
Other Tools: MS Paint, MS SharePoint, VB .NET 2002/3/5, ADO .NET, VB 6.0, ADO, IIS 5.0, Visual MainWin, WPS 220.127.116.11, Tomcat, AJAX, Excel VBA 2003/7, Electric Commander, TeamCity, SpreadsheetGear 2010, Business Objects
Morgan Stanley New York, NY 2009 – Present
Business Systems Analyst and Team Lead (2015 – Present)
Project: MB+, Salesforce, Investor Portal
Merchant Banking Plus (MB +) is a client database and administrative tool that contains key client contact and coverage personnel information, client documents, and client interactions from inception till date. MB+ covers many modules viz. Fund Raising, Communications Manager, Deal Pipeline, ICOMM Checklist, Reporting, Asset Management, Vendor Management, Entitlement Engine etc.
Salesforce-IR CRM tool provides Investor Services team access to investors, their contacts and correspondence preferences for these contacts, funds, legal entities and investments.
Investor Portal is a client-facing application available internally within the Firm and also externally over the Internet. It can be accessed by internal employees and by end-clients and investors. It provides them access to various documents produced by the funds in which they are invested.
Gathered release requirements from Business, created wireframes, communicated requirements to developers and QA, conducted QA status meetings, garnered status updates culminating into QA signoff and UAT coordination with BU. Conducted UAT trainings and procured UAT signoffs for UAT items and participated in the production go-live.
Coordinated reporting requests from BU, led weekly status calls, assigned tasks to reporting team, got UAT signoffs and delivered report changes and fixes into production via reporting turnover cycle.
Acted as SPOC for all ad-hoc BU requests and issues.
Coordinated tasks with support team and stayed connected via weekly call to review open items.
Liaison Officer (SPOC) (2015 – Present)
Project: Hygiene (Madison)
Firm-wide initiative ensuring that all Firm hardware and software that is EOL is retired and remediated across all platforms for e.g. SQL Server, Windows OS, MS Office and SharePoint upgrade.
Managed weekly updates to Hygiene Bible off of Hygiene dashboard, followed up with leads on ongoing work-streams, acted as a SPOC between Hygiene team and leads, attended biweekly status calls with the team and stayed aware of all migrations.
Coordinated Win10 remediation with all leads, identifying applications that should be remediated and initiating decommissioning of items that will not be migrated to Win10.
Project Management Officer (PMO), Reporting (2017 – Present)
Led weekly status reporting with leads and generated a consolidated weekly status update report.
Created monthly project summary status report for all projects for senior management review.
Software Developer and Team Lead (2009 – 2015)
Project: BEAM & BEAM-R
BEAM is a multi-interfaced application that allows Asset Managers and Investment Controllers to do cash flow modeling for AMs, extraction of cash flows from Excel models and creation of reports to monitor fund performance and share investment and fund level IRRs with investors.
BEAM-R plugin connects to multiple source systems (like BEAM) to extract and load data into Excel.
Created various screens based on user requirements and implemented end-to-end functionality.
Program lead for the database migration project from SQL Server 2005 to 2008 R2 and from SQL Server 2008 R2 to 2014. BEAM was amongst the first few teams to use SQL Server 2014 in the Firm.
Program lead for Windows Server 2003 migration to Windows Server 2008.
Coordinated migration of MS Office 2003 and MS SharePoint 2003 to 2010 and Win XP to Win 7.
Seer Group New York, NY 2008 – 2009
Software Developer – Macquarie Bank Ltd. (Projects: Deal Maker, iTrade, Markit, Historical Parser)
Capgemini Consulting India Pvt. Ltd. Mumbai, India 2007 - 2008
Software Developer/Team Lead – Marks & Spencer UK. (Project: Salary Planner and Tracker (SPT))
Hexaware Technologies Ltd. Mumbai, India 2005 – 2007
Software Developer – Ernst & Young
Projects: Global Assurance of Service Quality 2.0 (gASQ 2.0), Portlet Development using Visual MainWin for J2EE™, E&Y Partnership Application VB 6.0 to VB. net upgrade
Sigmasoft Consulting (I) Pvt. Ltd. Mumbai, India 2004 – 2005
Software Developer – Umang Pharmatech Pvt. Ltd, (Projects: SigmaPro, SigmaAccounts, Printsmart)
Caliber Infotech Mumbai, India 2003 – 2004
Software Developer – STS Chemicals/PCPL/Eftec Shroff Ltd, (Project: Caliber ERP)
Bachelor of Laws and Bachelor of Commerce (Mumbai University, India)
Diploma in Systems Management (GNIIT), NIIT (Mumbai, India)
French Level 1 Diploma A-1, French Institute Alliance Française (FIAF – Mumbai, India)
Certifications and Patents:
MCSD.NET Certification in VB .NET 2003
United States Patent (US 8,601,360 B2) for BEAM application in Dec 2013 (Link)