OBJECTIVE

• To obtain a Product ownership / Technical lead in the field of database Architecture, development, Operational Support and administration in OLAP/OLTP system.

SUMMARY

• Over 21 years of experience in the IT/Scientific computation, with full project life cycle, from user requirements to implementation and testing in Application Processing /Work - flow processing, /ETL processing, MI/BI/Data Warehouse/Data Mart Repository with Analyzing new business requirement to determine business solution, enhance new system to accommodate new business requirement to improve Reliability and system Performance, Rollout planning and Support both OLTP and OLAP system
• Strong noledge of both SQL and Financial Business troubleshooting and performance tuning skills
• ETL Processing from legacy system to NT and back to mainframe in Stored Procedures, SQL Scripting (Bulk Insert and BCP) and SSIS with Web Sphere/XML based messaging
• Knowledgeable in Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling
• Experience working with offshore project team management and mentoring work force.

TECHNICAL SKILLS

Databases: MS SQL Server 4.5-2016, 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

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

PROFESSIONAL EXPERIENCE

Confidential, New York

Senior Lead in SQL DBA Developer

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 dash board 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
• Planning migration, mentoring, per-release code reviewing impact analysis
• Suggesting performance related re-architecture, index strategy, code review and mentoring

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

Confidential, Journal Square, NJ

Senior SQL Architect and Developer

Responsibilities:

• Developed SSIS package for Stock Report Form Balance(SRFB) ETL process from legacy system
• Developed client specific interface for T-SQL faxing module. Created WebSphere based and RightFax based SQL Agent Jobs Using VB Script
• Developed T-SQL Based ETL Module that talked to mainframe in a real-time basis using Web Sphere/Biz Talk and maintain integrity of the database using transactions to the OLTP workflow databases
• Developed XML/XSLT based package for New Account PDF Forms
• Developed XML Based Archive Reporting Modules
• For Multidimensional PNS trade imbalance problems used pre-calculated Cube/Rollup value of Trades Data set.
• For more complex trade balancing rules for 1-1 to 1-Many scenarios used SSAS package as rule engine. Supporting Client Maintenance of code/Module. 

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

Confidential, New Port, NJ

SQL Data Modeler and Developer

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 Confidential 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 Wat-if tool that make use of the pre/post aggregated time-series data
• Implementations of Add-hock Queries for the business people
• 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 Wat-If grid data in a configurable/ costumed way

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

Confidential, Journal Square, NJ

SQL Developer

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 rule 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

Confidential, New York

Senior SQL Developer

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

Confidential, Phoenix, AZ

Expert Programmer/Analyst

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, Robohalp 2002 iNEt Procure, New Brunswick, NJ Mar 2001- Aug 2002

Confidential, New York

Programmer/Analyst System

Responsibilities:

• Extensive use of class component-based design and OO Architecture
• Restructure a couple of Front-end module 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

Confidential, Living Stone, NJ

VB Programmer

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

Confidential, New York

System Tester/Analyst 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