BIPLAB GANGULY

Tel: 201-***-****. E-mail: adzo6o@r.postjobfree.com / adzo6o@r.postjobfree.com / adzo6o@r.postjobfree.com

Profile:

Over 25 years of progressive IT/Scientific computation experience with major financial and pharmaceutical organizations

Full life cycle experience in architecting and implementing OLTP, data warehouse system using Microsoft technologies.

Implemented high throughput ETL solutions to source data from various source systems (mainframe, various formats) in RDBMS

Demonstrated ability to design, develop and implement analytic systems.

Co-ordinated onshore – offshore development

Diverse technical and business expertise in SQL, Financial Engineering, Data Modeling (Dimensional and Normalized) and Microsoft SQL Server, SSIS, Analytics Services, SRS.

Industrial Experiences associated with Established Financial Corporation like:

1

Cheetah Digital Inc., New York

2

Experian Marketing Services, New York

3

Broadridge Financial Corporation Inc., JSQ, New Jersey

4

HSBC Bank, Newport, New Jersey

5

Automated Data Processing (ADP), JSQ, New Jersey

6

Goldman Sachs, New York

7

American Express Inc., Phoenix, Arizona

8

Prudential Financial, Living Stone, New Jersey

9

SIAC, Brooklyn, New York

10

New York CITY, New York

11

Pfizer Pharmaceutical Inc., New York, etc.

TECHNICAL SKILLS:

Databases: MS SQL Server 4.5-2016, MS Azure, Sybase 4.9/-12.5, DB2/UDB2, Oracle, MS Access

Data Modeling Tools: yEd, Erwin 7.2/4.5/4.0, MS Visio 2003/2007, Solar Wind

IDE & BI Tools: SQL Server BI Development Studio (BIDS), MS Visual Studio 2008/2013

Version Control: Team Foundation Server (TFS), Visual SourceSafe (VSS), Git, JIRA

Programming Languages: T-SQL, PL/SQL, C, C++, HTML, XML, XSL, XSLT, VB/C#/.Net, Python

Operating System: All version of MS Windows, Open VMS, UNIX, Sun Solaris 2.5.x, Linux, BSD, X Window

Packages: Microsoft Office 2013/2010/2007/2003/2000, Open Office, Tex/Latex

EDUCATION: B.E. (Electrical Engineering) - RE College, Durgapur, India

Ph.D. (Physics and Mathematics) - IZMIRAN, Russian Academy of Sciences, Moscow

LAST 25 YEARS OF PROFESSIONAL EXPERIENCE DETAILS:

Broadridge Financial Corp, Newark, NJ April 2019- Jun 2023

Senior SQL Developer:

Working in the last 4 years in Broadridge Ascendis Applications like PNS, specifically in Account Transfer (ACAT) for Agile Enhancement, Performance improvements etc. in all of stages in SDLC. ACAT is a Broadridge Workflow Application that supports both US and Canadian ACAX/CDS mainframe systems and supports rich client solutions using MS SQL Server, Service-broker, ASP .Net solutions in a multithreaded environment.

Responsibilities:

Implemented TMX Modernizations requirements for Canadian Clients

Enhanced application performances using indexes and Modifying code algorithm.

Continuous Product support and bug fixes.

Analysis of possible integrations of non-Broadridge client with custom clint specific architectures with Broadridge ACAT workflow system as seamless as possible

Development SQL based load testing tools

Enhancement of Service Broker based application architecture to supports multi-threaded environment

Re-architected back environment for better performance for API based solutions.

Environment: MS SQL Server 2017, Service Broker, ASP.Net, SSIS

Experian/Cheetah Digital, New York Sept 2013- May 2018

Senior Lead in SQL DBA Developer:

Have been actively engaged evaluating Performance & Scalability of the existing Cross Channel Marketing product Experian/Cheetah Digital Marketing Suit and Marketing Intelligence (MI).

Responsibilities:

Enhanced and Supported dacpac/SQL based ETL to Data Mart process for Marketing for various client for cross channeling Marketing

Designed and executed, monitored and supported channeling specific data mart cubes for reporting.

Designed customer Health/Customer Migration dashboard data cube structure of various granularity for slice/dice reporting.

Designed generic configurable data Purging/Monitoring module.

Designed custom data obfuscation module and regularly executed.

Designed and developed push-pull operation from BI data with MS Azure Email-Inside data

Planning migration, mentoring, per-release code reviewing impact analysis.

Suggesting performance and locking, blocking and deadlock related re-architecture, index strategy, code review and mentoring.

Day to day production support for MI application besides occasionally to OLTP application

Day to day monitoring production performance and locking, blocking and deadlock using SolarWinds

Finished Corporate Technical training on Hadoop/python in NY Data Academy

Environment: MS SQL Server 2012/20124/2016, Jasper, Python

Broadridge Financial Corp, Journal Square, NJ January 2006-Feb 2013

Senior SQL Architect and Developer:

Have been actively engaged Architecting databases for new Applications from ground up and tuning of performance, data maintenance and development / Support / Enhancement of OLTP type Workflow projects like PNS/Reorg/Dividend/SRFB/Margin/Cash and New Accounts. With the use of innovative design and coding, solved crucial problems related to automation of process like Faxing, Report generation etc. directly from the database. Also developed Custom pdf generation with pdf417 barcode, MS Excel Formatted report generation using native T-Sql code for better integration to that database avoiding .net sp. Used all the product and tools in MS Business Intelligence studio. Occasionally supported ASP.Net Code for the front-end application.

Responsibilities:

Architected and implemented solution for PNS/Reorg/Dividend/SRFB/Margin/Cash and New Accounts workflow projects.

Defined data model for workflow applications

Designed various routine database processes such as Faxing, report generation to achieve no human touch automation.

Developed utility for pdf generation with pdf417 barcode, MS Excel Formatted report generation using native T-Sql code for better integration to that database avoiding .net sp

Designed and Developed ETL processes using SSIS package for Stock Report Form Balance (SRFB), XML/XSLT based package for New Account PDF Forms

Designed and implemented Analytic Services based cube for PNS trade imbalance problems.

Environment: C#, ASP.NET, MS SQL 2000/2005, SQL Server 2008, WebSphere, RightFax

HSBC, New Port, NJ June 2005-January 2006

SQL Data Modeler and Developer for Credit-Spread Pseudo Data Warehouse, What-If

Designed an in-house application for global HSBC business analysts that help them determine credit-limit for clients, graphically study What-if type analysis and get/publish ad-hoc business reports in corporate intranet system. Financial credit-spreads are complex mathematical models that need multidimensional historical data with variable number of dimensions depending on the models and region-specific netting rules. The system uses data pump in a staging area by corporate workflow processes and implementation of credit-spread model specific cubes that will subsequently be used by mining process and what-if analysis.

Responsibilities:

Analyses of Spread-Models, specific to region like USA, Europe and Asia Pacific etc. and design and model pseudo-OLAP Data structure in a Sybase Relational Database staging system.

Extensive liaison with both the end user and theoreticians and modelers of the HSBC Global risk analysis team across globe that uses different rules of Risk analysis and adjust the staging data structure.

Creations of cubes from model specific fact tables that store structured binary data.

Creation of graphical interactive What-if tool that make use of the pre/post aggregated time-series data

Implementations of Add-hock Queries for the businesspeople.

Created XML controlled and XML configured components (DLL) that will be called by Unix based Control-M job scheduler that pushes data in COGNOS system.

Control-M job scheduler that pushes data in COGNOS system.

Created tools for business analyst to retrieve/review What-If grid data in a configurable/ costumed way

Environment: VB 6.0, SYBASE SQL SERVER, MS XML, Control-M, Window Script Host.

ADP, Journal Square, NJ March 2004 – June 2005

SQL Developer ADP Workflow

Worked from ground up in ADP's Workflow System Purchase & Shell (PNS) after proof-of-concept phase. Involved in complete software development life cycle SDLC including testing and customer-support. Occasionally worked on other workflow products like Margin, Reorg, etc. for ASP page and T-SQL object performance tuning.

Responsibilities:

Re-architect the OLTP/OLAP mixed type PNS database and model the data from front-end application point of view using MS SQL Server RDBMS.

Assimilate and organize the VB /VC++ component-oriented data modules into more logically and functionally grouped stored procedures for better performance and code management in a Hybrid model for BI drilldown Reporting.

Wrote generic ETL parser module that will parse any (both EBCDIC and TEXT) data-file in packed (COMP-3) and unpacked form and load to user table that is customizable.

Wrote generic PNS rule processing that can be configured to almost hundreds of different rules using static data-entry using T-SQL

Wrote generic archiving module that will produce text file in customer defined format efficiently directly from the database to network-drive.

Helped writing Complex SQL query for Data Visualization tools and Reporting Services

Wrote generic stored procedures that will be used for messaging using IBM’s MQSeries to any mode.

Wrote generic email module that will produce customer and user defined mail from database directly.

Worked and solved stored-proc based module for encrypting mail data and decrypting at the user desktop using dynamically generated Java scripts.

Responsible for maintaining database and server security.

Occasional Writing and testing ASP pages

Environment: VB 6.0, MS SQL 2000, ASP 3.0, MQ Series, Java Script,

NY CITY, New York 11/03 – 03/04

Senior SQL Developer CTS System

Worked in New York City department for Contract Management System that keeps track of the various vendors’ bidding history and reporting using C#, ASP.NET, SQL Server 2000. VB based components were re-written for cross-application maintainability. Wrote Java Script DHTML code along with ASP.NET -based server-side computing.

Responsibilities:

Data-model the application using ER-WIN and forward engineer in a MS SQL Server RDBMS

Modularized the OLTP database using T-SQL Stored Procedures and wrapped the complex validation business logic.

Modularized the thin-client ASP.Net for better reuse and management.

Followed a method implementing database-oriented application logic so the ASP pages needs less or no changes in a changing business requirement.

Extensive documentation

Environment: C#, ASP.Net, VB 6.0, MS SQL Server 2000, Java Script

American Express Inc, Phoenix, AZ Apr 2002 – Nov 2003

Expert Programmer/Analyst: Project: TravelBahn wGateway

TravelBahn wGateway is an American Express travel product that communicates with the Worldspan GDS (Global Distribution System). This product encompasses all the elements an agent requires to book a traveler’s entire itinerary, like air, hotel, car/limousine, Amtrak, traveler profiles and preferences, ticketing and invoicing, maintain user access and privileges.

Responsibilities:

Key role in the development of TravelBahn wGateway

Took part in the requirement gathering phase.

Responsible for daily builds & VSS maintenance.

Making a Conversion Tool, that translates unique commands from one GDS to another GDS.

Responsible for CBT macro media flash Integration.

RoboHelp HTML, integration with the application.

Responsible for the packaging and deployment of the application.

Use of MS WinSocket to communicate with another application called gateway written with C# application communicates with Worldspan using Worldspan Active-X Control.

Environment: Win X 2000, XP, Visual Basic 6, Winsock, Worldspan, Saber, Robohelp 2002

iNet Procure, New Brunswick, NJ Mar 2001- Aug 2002

SQL Developer: DocView intranet application

Responsible for documenting and implementing SQL Server Disaster recovery models. Work with database and server security. Design analyzes and implemented a web-based application designed for administering backup of database dump. The application automatically transferred the database dump from Unix box to an Access mdb file and after validation check loaded it to an MS Access 2000 database for further managerial activities. This ASP based Intranet application being currently used at multiple credit unions.

Environment: VB Script, Java Script, MS SQL 7.0, ASP, ADO and Visual Interdev.

Goldman Sachs, New York July 2000 - Mar 2001

Programmer/Analyst System

Lead a team of implementing the enhancement to existing VB4 Realm application for global Resource Reservation System (Customarily called REALM). RE architect the application in the framework of object orientation. Implemented the waiting list feature, Audio-log for change in the Reservation, and automatic notification mechanism to various service providers. Modified and extended the existing Sybase database and wrote cursor based complex search facilities using store procedures.

Took part in the Web based solution for the existing System. Used MTS based components and ASP for IIS hosted e-solution.

Involved with Complete software development Life Cycle (SDLC).

Responsibilities:

Extensive use of class component-based design and OO Architecture

Restructure a couple of Front-end modules to suit the new Database change.

Designed and implemented the new requirement for OLPT RDBMS database.

Resolved Concurrency, blocking and contention handling in OLTP system.

Improve and fine-tune Existing time-consuming complex proc and improve performance in an OLTP system.

Wrote ASP version of the existing for intranet use.

Used WEbLoad to measure the performance of ASP pages.

Wrote perl script for region specific implementation ETL process.

Interface with clients to gather and document business and system requirements.

Provide customer support as and when required.

Environment: VB 6.0, MTS, ActiveX, Sun Solaris/Win NT, MS IIS, ASP, Sybase 11, Perl 5.0

Prudential Financial, Livingstone, NJ July 1999 - Jun 2000

VB Programmer ADR Demut Work-flow Monitor

As part of Prudential's Demutualization Project developed Work-Flow Monitor VB front-end application. The Application is part of Prudential's Demutualization Process with particular emphasis on the ADR (Alternate Dispute Resolution) Cases. It comprises of processing basic raw data or information from various sources like RKS, AOS, ADRCk, CMS including existing paper only transaction. In this connection, to Manage, Monitor, Control (by distributing various role-driven responsibilities among users or maybe group of users) and used Crystal reports to generate status reports of the groups of cases, or the productivity of various user’s groups, the ADR Demut Work-Flow Monitor (ADWM) Utility Program was designed.

Responsibilities:

Designed the OO architecture and the specification of ADR DEMUT Drill-Down Graphical Reporting System to monitor various processes taking part in Demutualization Process so that the users can monitor performance various systems elements in a hierarchical fashion.

Extensive of graphical base VB coding

Designed a full context sensitive and on-line Help System for the said application using ROBO Help tool.

Maintained and created the user’s Guide and program Specification Document for the above-mentioned application.

Reverse Engineered the ADR Database from Funding Work Sheet (FWS) point of view using ER-Win Case tool identifying all the tables and their column and when and how they are affected by the application functions.

Analyzed and Documented ADR DEMUT Project Manual.

Environment: DB2, MS SQL6.5, ER-Win, Visual Basic, DCOM, ActiveX, IBM Mainframe

Pfizer Pharmaceutical Inc., New York Nov 1997 - May 1999

System Tester/Analyst Adverse Regulatory Reporting System

Worked as a system tester for Adverse Regulatory Reporting system.

Responsibilities:

Created Full System Test script.

Wrote all functional test script.

Automated the script using testing tools.

Designed a plane for Data-consolidation.

Wrote PL/SQL Based extensive codes for data consistency/integrity checking, data validation.

Discovering, managing system defects

Extensive Documentation

Environment: Oracle, Developer 2000, Actuate Reporting, Automated Testing tools

SIAC, Brooklyn, NY Mar 1997 - Nov 1997

System Tester and risk Analyst: Amex Order File

Analyzed Test mechanism for upgraded Amex Order File (ASOF) database application from Sybase 4.9 to Sybase 10. Designed and implementing test plane for the fallback mechanism form DEC. Alpha to DEC VAX. Also designed and analyzes the test plane and created the scripts for upgrade version of Amex Order File (AFO) database application from Sybase 4.9 to Sybase 10.

Environment: Sybase 4.9/10, Open VMS, DEC VAX 4500, Alpha

Contact this candidate