Microsoft Azure Services
Upen Gandhi
Principal Software Engineer
Plano,TX
Summary
Technical Architect offering 31 years' experience in comprehensive design and development of software and architecture for software projects. Attentive collaborator and communicator from project conception to completion. Creative in devising solutions to improve business operations and meet clients' technical needs. Seasoned team leader possessing the technical and interpersonal skills to provide exceptional project deliverables.
Overview
31
31
years of professional experience
1
1
Certification
Work History
Systems Architect (Senior Consultant)
Citigroup Inc
- Tribeca Global Management is a wholly owned subsidiary of,
- It is a major hedge fund company specializing in multi-strategy hedge funds
- Tribeca Global Management is one of the few hedge fund companies incorporating state-of-the trading and technology platforms
- Designed, customize and integrate 3rd party software solutions to work effectively within Citigroup infrastructure
- Designed and developed common framework of routines
- Designed System security Architecture utilizing Object Oriented principles
- Provided Technical support for all installed software
- Analyze, Design, and deploy batch feeds from one system to another system
- Managed Vendor Relationships; Service level Agreements, and Vendor Technical support
- Design and Code software interfaces utilizing VB.Net and C#
- Led software Proof-of-Concept and Application Development efforts
- Recommend, and Evaluate Software solutions based on User requirements
- Documented Technical Feasibility, Coding Standards, Functional Specifications, Program specifications, Architectural designs, and other system deliverables
- Windows 2000 server, SQL Server 2000, VS.Net 2003, MS .Net Framework, .Net Components, Autosys, and Visual SourceSafe, Axys, Geneva, Microsoft CRM, Bloomberg Gateway, Bloomberg TOMS, EZE Castle, Monis Risk Analyzer, Panorama Risk Analyzer, and Security Master.
Systems Integrator
BusinessEdge Solutions
- Is a Consulting and, having offices worldwide
- Involved with two major projects CIT Internet website www.CIT.com and Claims Management System at Liberty Insurance
- Technical Lead Guiding/Mentoring up to 5 developers
- Project Lead for 2 distinct projects while at BusinessEdge Solutions
- Designed a Highly Scalable 3-tier Architecture for the two projects
- Documented Technical Feasibility, Coding Standards, Functional Specifications, Program specifications, Architectural designs, and other system deliverables
- Extensive Hands-On Coding utilizing ASP 3.0, VB 6.0, VBScript, JavaScript, DHTML, etc
- Designed and developed COM/DCOM components running under Com+ Enterprise services
- Created Data Models and table designs to effectively Normalize system data
- Extensive backend database development of Stored Procedures and Triggers in T-SQL; 95% of all Database Calls were stored procedure calls
- Scheduled data deliveries using DTS: nightly feed (customer information, invoices, etc.), weekly feed (code files) and monthly feed (currency exchange rate, etc.)
- 5.0, ASP 3.0, COM+, COM/DCOM, VB 6.0, Active X, VBSCRIPT, JAVASCRIPT, HTML and SQL Server 2000, XML, XSLT, Visual InterDev, Visual SourceSafe.
Vice President
Bank of America
01.2009 - Current
Vice President, Lead Product Engineer
Merrill Lynch
05.2006 - 12.2008
- For the Enterprise Instant Messaging space
- Architect, engineered, and customized Microsoft OCS 2007 Platform / Akonix L7 Enterprise Platform within Merrill Lynch Infrastructure
- Designed an IM User registration / provisioning / reporting process utilizing web services, IIS, LDAP, AD, and SQL
- Provide 3rd level Technical support for all installed products / software
- Created architectural standards for all bot integration with Lync and OCS 2007
- Managed Vendor Relationships; Service level Agreements, and Vendor Technical support
- Designed and Code bots to monitor IM infrastructures, utilizing C#
- Led Product Proof-of-Concept
- Led Application Development efforts
- Recommend, and Evaluate Software solutions based on User requirements
- Documented Technical Feasibility, Coding Standards, Functional Specifications, Program specifications, Architectural diagrams, and other system deliverables
- Environment: Lync 2010, OCS 2007, Akonix, SQL, LDAP, IIS, Web Services, Windows 2003 server, SQL Server 2008
Business Intelligence
Bank of America
- 01.2007
- Merrill Lynch is one of top Global Bank / Wealth Management Company incorporating state-of-the technology platforms
- Mentored and guided an experienced team of developers to provide robust, solution
- Provided over 200 business analytical reports on a SharePoint dashboard
- Architect and Engineered a BI Server Infrastructure that provided redundancy for Prod and Dev environments
- Designed multiple data warehouses for each product (Active Directory, Lync, Group Chat, SharePoint, Exchange, etc.) platform
- Designed ETL solutions involving hundreds of different packages
- Designed analytical data models utilizing both Tabular and Multi-Dimensional solutions
- Designed BI delivery solution involving Reporting Services / Excel Reporting / Power Pivot solutions utilizing SharePoint as the dashboard
- Automated prod deployment, Jobs and monitoring services within SQL and Visual SourceSafe
- Environment: Visual Studio 2012/2010, SQL Server 2014/2012, SharePoint 2013/2010, Excel 2013/2010/
Member
Citigroup / TRIBECA GLOBAL MANAGEMENT LLC, Citigroup Inc
10.2004 - 04.2006
Technical Lead/Architect (Senior Consultant)
KPMG
04.2003 - 04.2004
- LLC is a leading provider of assurance, tax, legal, and financial advisory services
- Worked on critical financial based systems to manage and track auditing information for KPMG’s client base
- Designed a Web based Content management system for KPMG's Assurance auditors
- Documented Business Specifications, Technical Feasibility, Coding Standards, Functional Specifications, Program specifications, Architectural designs, and other system deliverables
- Led a team of 6 people for system development
- Created Data Models and table designs to effectively Normalize system data
- Designed and developed common framework of routines
- Designed System security Architecture utilizing Object Oriented principles
- Designed and developed Stored Procedures and Triggers in Microsoft SQL Server 2000; 95% of all Database Calls were stored procedure calls
- Designed and Created a Standard Data Access Layer which utilized ADO.NET as the standard interface for data access
- Designed and developed common framework of routines for the business layer
- Designed System security Architecture utilizing Object Oriented principles
- Extensive report development using Crystal Reports.Net
- Nvironment: Windows 2000 server, Share Point Portal Server 2001, BizTalk Server, WebForms, WinForms, SQL Server 2000, VS
- Net 2002, MS .Net Framework, .Net Components, Web Services, VB.Net, C#, SQL Stored Procedures, JAVASCRIPT, HTML, XML, MS Project, CrystalReports.Net, and Visual SourceSafe.
Senior Consultant
WEICHERT REALTORS INC
05.2002 - 04.2003
- Established a brand new Call Center for Realty
- Establish a single point of contact for all Wiechert customers and redirect the customer, if necessary to the appropriate channels
- The application managed large volumes with very quick response times
- System provided fast Customer Lookup/Tracking; Customer Demographics and Real Estate Property Inventory
- Extensive Hands-On Coding utilizing ASP.Net, VB.Net, JavaScript, HTML/DHTML, etc
- Designed and developed the right architecture to incorporate middle-tier components (business logic) as either Web Services, .Net Remotable Objects or Serviced (Com) Components running under Com+ services
- Created Data Models and table designs to effectively Normalize system data
- Architect and design dynamic ASP.Net Web screens to support customer interaction through phone, email, web chat and US mail
- Provided a data store to archive all customer interaction for marketing purposes
- Environment: Windows 2000 server, IIS 5.0, SQL Server 2000, VS
- Net, MS .Net Framework, Com+, Global Assembly Cache, XML Web Services, .Net Components, Win Services, ASP.Net, VB.Net, SQL Stored Procedures, Crystal Reports
- Net, JAVASCRIPT, HTML, XML, Rational Rose, and Visual SourceSafe.
Senior Consultant
BUSINESSEDGE SOLUTIONS, CIT and Liberty Insurance
08.1999 - 05.2002
Lead Technical Specialist
PRUDENTIAL FINANCIAL
09.1997 - 08.1999
- Is a leading financial/brokerage/trading organization with worldwide operations
- Involved in the project supporting Mutual Funds/Annuities Literature Ordering System
- Technical Lead Guiding/Mentoring up to 4 developers
- Led the design effort to transform a legacy Client/Server system to highly scalable 3-tier web-enabled system
- Hard-core ASP coding in conjunction with Visual Interdev, VB Script, Data Model Analysis of corresponding schemas in Sybase (the old system) and SQL Server (the new system)
- Made extensive use of Microsoft DTS (Data Transformation Services) to import and export database objects, including indexes, stored procedures and referential integrity constraints across computers to distant databases
- Used VBScript to write the data transformation scripts
- Used DTS to simulate OLE DB on native ODBC interfaces such as that for ASCII Data Sources
- Scheduled data deliveries using DTS: nightly feed (customer information, invoices, etc.), weekly feed (code files) and monthly feed
- Developed programs (VB) and scripts (SQL) to import data from Sybase
- Developed reports using Cognos (Transformer) OLAP tool
- Developed User Documentation
- 5.0/6.0, Active X, SYBASE 10.0/11.0, SQL SERVER 7.0, HTML, ASP 2.0, IIS 4.0, MTS 2.0, VBSCRIPT, JAVASCIPT, Cognos, Window NT 4.0, COM
Member of Technical Staff
AT&T
09.1990 - 08.1997
- AT&T is a major Telecommunications company with revenue in the billions
- Involved in AT&T Business Billing and Public Telephone marketing systems
- Programmed extensively in UNIX & Mainframe Environments
- Acquired Extensive experience in Database Technologies using Oracle and DB2
- I.e
- Data Modeling, Stored Procedures, PL-SQL, Table Normalization, Database Optimization, Referential Integrity etc.,
- Acquired Extensive Experience with Client Interaction and Software Development Life Cycle
- Participated in systems analysis and systems design
- Mentored 5 other programmers involved in the project
- System Documentation
- Training of users
- Environment: DB2, SAS, COBOL II, VSAM, CLIST, REXX, ISPF, JCL, PL-1, Dialog Manager, and EasyTrieve on IBM ES/9000 with TSO/MVS
Education
B.S - Computer Science
New York Institute of Technology
Old Westbury, NYSkills
Technical Analysis
Cloud services
Technical Architecture Design
Communicating with clients
Redesigning system architecture
Proficient in C#
Software
Microsoft Power Platform
Microsoft 365 Platform
Certification
Microsoft Azure
Timeline
Vice President
Bank of America
01.2009 - Current
Vice President, Lead Product Engineer
Merrill Lynch
05.2006 - 12.2008
Member
Citigroup / TRIBECA GLOBAL MANAGEMENT LLC, Citigroup Inc
10.2004 - 04.2006
Technical Lead/Architect (Senior Consultant)
KPMG
04.2003 - 04.2004
Senior Consultant
WEICHERT REALTORS INC
05.2002 - 04.2003
Senior Consultant
BUSINESSEDGE SOLUTIONS, CIT and Liberty Insurance
08.1999 - 05.2002
Lead Technical Specialist
PRUDENTIAL FINANCIAL
09.1997 - 08.1999
Member of Technical Staff
AT&T
09.1990 - 08.1997
Systems Architect (Senior Consultant)
Citigroup Inc
Systems Integrator
BusinessEdge Solutions
Business Intelligence
Bank of America
- 01.2007
B.S - Computer Science
New York Institute of Technology