Sql Server Electrical Engineering

B IPLAB G ANGULY

Tel: 201-***-****. Skype num +1-609-***-**** E-mail: ******.*******.***@*****.*** / ******.*******@*******.*** https://www.linkedin.com/in/biplab-com-9076bb99/ EDUCATION: B.E. (Electrical Engineering) - RE College (Now NIIT), Durgapur, India Ph.D. (Physics and Mathematics) - IZMIRAN, Russian Academy of Sciences, Moscow Profile:

15+ years of progressive IT/Scientific computation experience with major financial and pharmaceutical organizations

Full life cycle experience in architecture and implementation of OLTP, data ware- house system using Microsoft technologies.

Implemented high throughput ETL solutions for data from various source systems

(mainframe, various flat file formats) in RDBMS

Demonstrated ability to design, develop and implement analytic systems. Coordi- nated onshore – offshore developments

Having diverse technical and business expertise in SQL, Financial Engineering, Data Modeling (Dimensional and Normalized) and Microsoft SQL Server, SSIS, SSAS, SSRS.

Industrial Experiences associated with Established Financial Corporation like: 1 Broadridge Financial Inc., JSQ/Newark, New Jersey 2 Experian Marketing Services, New York

3 Cheetah Digital Inc., New York

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-2019, 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, VB/C#/.Net, Python LAST 15+ YEARS OF PROFESSIONAL EXPERIENCE DETAILS: Broadridge Financial Corp, Newark, NJ April 2019- Jun 2023 Senior SQL Developer:

Worked in the last 4 years in Broadridge Ascendis Applications like PNS and ACAT ACAX/CDS) for both US and Canadian clients

Summery of Responsibilities:

Enhanced and Re-designed PNS ETL Load process for large files by segregating in .Net components

Implemented and Re-designed ACAT’s TMX Modernization requirements in T-SQL

Enhanced application performances using indexes and Modifying code algorithm.

Analysis of possible integration of non-Broadridge clients with different architectures with Broadridge ACAT workflow system as seamless as possible with minimum changes

Development SQL based innovative load testing tools in T-SQL Framework for Performance tuning.

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

Re- designed back-end 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:

Had been actively engaged in Developing and evaluating Performance & Scalability of the existing Cross Channel Marketing product Experian / Cheetah Digital. Responsibilities:

Enhanced and Supported dacpac/SQL based ETL process to Data Mart for cross channeling Marketing of multiple clients

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.

Re-deigned stored procedure for digital campaign responses with clustered servers

Developed a generic data Purging/Monitoring module that leverage DBA writing Multiple Scripts.

Configured Replication for campaign metadata in different clusters

Designed custom data obfuscation module and regularly executed in Development environment.

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

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

Day to day production support for BI application besides main OLTP application Database

Re-designed Digital Campaign Load process using Partitioning tables that supports multi threading and performance benefit up-to 7+ times

Suplied BI data from SQL Server to Map/Reduce Hadoop version of BI application using Python scripts daily basis to other overseas developer group

Environment: MS SQL Server 2012/20124/2016, Jasper, Python Broadridge Financial Corp, Journal Square, NJ January 2006-Feb 2013 Senior SQL Architect and Developer:

Had been actively engaged Designed databases for NewApplications Workflow project besides development / Support / Enhancement of OLTP type Workflow projects like PNS, Reorg, Dividend, Margin. Responsibilities:

Developed an innovative pdf417 Bar-code generation solution in native T-SQL Framework that will remove gray code for enlargement in a real-estate and remove automatic routing error in scanning.

Defined data model for workflow applications

Re-designed existing SQL based ETL and Business Rules with SSIS

Designed various routine database processes such as Faxing, report generation to achieve no huan touch automation using VB Scripts.

Developed utility to integrate DocuSign in pdf file using native T-SQL in innovative way to gen- erate Adobe pdf files which is configurable to include any structures Environment: C#, ASP.NET, MS SQL 2000/2005, SQL Server 2008, WebSphere, RightFax, SSIS 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 regions 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

Implementation 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.

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 application.

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

Contact this candidate