Project Sql Server

Abhijit Patnaik

Personal Details

Full Name (First Abhijit Patnaik

Last)

Mailing Address 4 SANDALWOOD DRIVE, APT 9, NEWARK, DE-19713

Contact Number 302-***-**** (Cell)

Email ID ***************@*****.***

Nationality Indian

Resident Status Permanent Resident (US Green Card)

Current Employer Cognizant Technology Solutions (www.cognizant.com)

Experience Summary

Over 10 years of experience in IT industry involving architecture,

analysis, design, programming, and implementation expertise. Has excellent

and proven track record in delivering high visibility products successfully

with efficient team and project management.

Core Skills Profile

o Extensively experienced with RDBMS skills in Oracle (5+ years), Sybase

(5+ Years), SQL Server (4+ years). Unix Shell scripting (6+ years).

o Experience in Web application development involving JAVA (2+ years), JSP

(2+ years), JAVA Script, XML.

o Efficient in PL SQL programming, Optimizing, Debugging and testing SQL

queries, views and Stored procedures.

o Excellent Batch scheduling(4+ Years) experience using tools like IBM

Tivoli Job Scheduler (Composer commands), CA Unicenter (cautil scripts),

CA Autosys

o Experience in ETL tools/utilities like Informatica Power Center 7.1, SQL

Server 2000 DTS and reporting tools Business Objects XIR2

o Excellent domain knowledge in Banking and Financial Systems (Investment

Banking, Card Services).

o Extensive Project management experience in implementation of software

releases.

o Managed team in Project execution and handling Production support

activities for business critical systems (24X7 Onshore-Offshore models).

o Proficient in business process documentation and end-user

training/knowledge transfer. Proven ability to complete multiple

assignments simultaneously and maintain high standards at client

organizations. Willing to learn and master new concepts and technologies.

o Excellent communication and inter-personal skills, motivated, excellent

team player and passionate to learn new technologies very quickly.

Education

Degree Bachelor Of Technology in Mechanical Engineering (B.

Tech)

University College of Engineering & Technology, O.U.A.T,

Bhubaneswar, INDIA in 1999.

Technical Skills

RDBMS ORACLE 10g (PL SQL), Sybase 12.0 (T-SQL), SQL-Server 2000

Web Technologies Core Java, JSP, HTML, XML, Java Script, XML, CSS, HTML,

DHTML, ASP, VB

SQL Tools SQL Navigator, Toad, DBArtisan, SQL Developer, SQL

Enterprise Manager

ETL Tools Informatica Power Center 7.1, SQL Server 2000 DTS

Reporting tools Business Objects XIR2 (Web Intelligence, Crystal Report),

Seagate Info 7, Crystal Report 7

Web Tools Weblogic 10, IBATIS Framework, IBM Rational Application

Developer, Eclipse

Scripting Unix Shell scripting (Korn Shell), AWK, Perl, VBA

Batch Scheduling IBM Tivoli Job Scheduler (Composer commands), CA

Tool Unicenter (cautil scripts), CA Autosys

Version Control Harvest, Sub version, Visual SourceSafe, PVCS, CVS

Hardware/OS Pentium , Sun-Solaris, Windows XP/2000/NT 4.0

Professional Experience

Employment Duration

Cognizant Technology Solutions US Corp Aug 2004 - Till date

Cognizant Technology Solutions India Sep 1999 - Jul 2004

Pvt Ltd.

Relevant Project Experience

Project Campaign Planning (CPLAN)

Title

Customer JPMorgan Chase, Wilmington, Delaware, US

Duration December 2008 - Till Date

Technology Oracle, Unix shell scripting, Java, JSP, Tivoli Job

scheduler, Web logic 10, IBATIS Framework, Tools(Eclipse,

Harvest, F-Secure, HP Quality Center, SQL Navigator)

Project CPLAN is the main offer management tool used in Chase Card

Abstract Services to Group marketing offers, Build source codes, check

numbers and BT source ID's, provide critical marketing offer

information to downstream interfaces and facilitate the

launch of marketing campaigns.

Role Worked on the CPLAN module that handles file transmission to

outbound interfaces through Tivoli batch streams.

Functional analysis and track down data elements to be sent

to downstream systems. Mapping of functional data elements to

database fields and come up with database view design.

Design and develop Oracle package and views to produce the

files in desired layouts. Developed UT packages for the

respective database objects.

Design and develop Unix shell scripts that would use the

Oracle package and generate files in the application file

systems.

Design and develop Java batches and incorporated call from

Unix shell scripts using in house middleware package call.

Design and develop Tivoli scripts to schedule overnight batch

streams that would use the Unix KSH.

Enhancing web interface using JSP with Weblogic and IBATIS

Framework.

Project PB Fee Workstation

Title

Customer JPMorgan Chase, Newark, Delaware, US

Duration September 2007 - November 2008

Technology Java, JSP, Sybase 12.0, Business Objects XIR2 (Crystal

Report, Web Intelligence, Infoview, CMS)

Project JPMC maintains a mainframe based application called Automated

Abstract Commission Environment (ACE) which calculates fees for a

private banking accounts. PB Fee Portal project is an attempt

to Integrate fee information into the workstation(Web based

environment for all major Private bank functionalities) so

that front-office and service teams can view client and

account level fee amounts, calculation methodology, and

schedules in order to provide better visibility into client

profitability.

Role One of the requirements for PB Fee Workstation was to convert

the legacy reports into Business Object environment.

Abhijit was primarily involved in :

Setting up connectivity from Mainframe DB2 zOS to BO

infrastructure (Solaris) through JDBC type-4 driver.

Installation of JDBC driver in BO Solaris environment as we

as local developer PC.

Study legacy report utility being used and analyze the

feasibility of those in BO. Coming up with proof of concepts

and providing demo / presentation to front office.

Report design in Crystal report using JDBC and Java Bean data

sources. Also reports involving combination of DB2 and Sybase

data sources.

Business Object Universe design analysis for WebI reports to

support user for ad hoc query capabilities. Analysis has been

done to Design the Universes and assigned them to respective

domains.

Deployed and scheduled reports through CMC and Infoview.

Training front office users for various BO features.

Project Private Bank Data Services (PBDS)

Title

Customer JPMorgan Chase, New York, NY, US

Duration March 2004 - August 2007

Technology Unix, Informatica, Sybase 12, SQL-Server 2000, SQL Server

DTS, CA Unicenter / Autosys

Project Private Bank Data Services project deals with an application

Abstract called Operational Data Store which is a central data

repository to various Private Bank applications. This is a

feed based system with data loaded by mostly overnight batch

processes. The input feeds are from Mainframe and other

source systems and received in the form of Unix flat files.

The datastore is in Sybase with batch written in Unix shell

scripts and Informatica for ETL. A scheduling tool called CA

Unicenter is used for schedule and running the batch

processes. It also feeds the data to another Windows based

vendor product application in SQL Server for Fee calculation

and maintenance. This requires batches involving SQL Server

2000 DTS and store procedures.

Role Abhijit is the Onshore Project lead.

Project lead for Cognizant. Team includes onsite members as

well as Cognizant team in India.

Complete understanding of the batch processes so that it can

be fixed in case of failure.

Work on enhancement and conversion projects, involving Unix

shell scripts and Sybase store procedures.

Analysis and development of Informatica ETL processes used in

Sybase/Unix batch programs.

Developed ETL procedures using SQL Server's DTS and T-SQL

package to provide a way to update/insert/delete data from

multiple heterogeneous sources.

Designed DTS packages for excel reports used by front office.

Transition knowledge to India team who monitors the US night

time batch process. Formulate support and escalation

guidelines

Design, develop and implement various monitoring processes

that can used to automatically detect and alert in case of

failures.

Analyze batch issues and handling client queries.

Design and analyze various new enhancements to the system and

co-ordinate to get it done by team in India.

Conducting team meeting with JPMorgan Client manager to

discuss project issues.

Inducting and training new member to the team by arranging

client interview and subsequent training programs.

Project POS2000

Title

Customer FDMS (First Data Merchant Services), MD, USA

Duration March 2002 - March 2004

Technology Unix, Shell Scripting, Oracle 8i

Project The Primary business of FDMS (First Data Merchant Services)

Abstract is to provide services on the Credit Card Transactions to

merchants all over USA. Merchant could be an individual

retail unit or a chain retail unit. FDMS is like a business

unit between Merchants providing credit card transactions and

the Banks issuing Credit Cards. So merchants instead of

claiming their credit card dues directly from the card

issuing banks goes via the FDMS, essentially to get benefits

like faster processing time, minimizing risk (to some

extent), etc...

For providing credit card transactions the retail unit needs

various kinds of equipment (Terminals with Credit Card

Reader, Pin Pad, etc) to allow purchase of items using Credit

Cards, authorizing the validity of the cards. POS2000 system

is used by FDMS to maintain all information about Vendor,

Equipment and Merchants.

Role Abhijit is the module lead.

Knowledge Acquisition & Transfer: In initial phase, he was

involved in detail knowledge gathering of the application at

client site. After returning back to offshore, he transferred

the knowledge to other team members.

Production Support: The team supports around 100 overnight

batch processes from offshore location, User-call support and

also doing enhancements. The batch processes includes oracle

procedures as well as UNIX shells scripts.

Development & Maintenance: The team has implemented various

new batch processes. Abhijit is primarily involved in

analysis, design and development of the oracle procedures as

well as Unix shell scripts.

Project Control: Abhijit also does the usual project control

activities.

Project Facets Implementation

Title

Customer Lifeguard, USA

Duration Feb 2001 - Feb 2002

Technology Visual Basic 6.0, Sybase 11, Unix, Seagate Info 7, Crystal

Reports

Project Lifeguard is one of Northern California's leading independent

Abstract health plans. The Facets Implementation Project involved

providing complete solution & support in Migrating from the

HSII legacy management system to Erisco's Facets client/

server solution for managed care administration.

Role This purpose of this project was to Migrate from the Existing

Legacy Application to the Erisco Facets Client/Server

Application. It involved Data Mapping & Migration from Legacy

to Facets, Developing Interfaces with the existing

Applications across the Organization and developing a custom

built reporting Application. This was a full lifecycle

Project involving Requirements Analysis, Functional and

Technical Design, Development, Full scale testing and

complete Data Migration to the Facets Production Environment.

Analysis: Abhijit is responsible for reviewing the report

specifications as provided by client and then mapping them

into pseudo logic for Sybase stored procedures.

Coding and Testing: Developed Sybase stored procedures to be

used as a source to the reporting interface. Designed and

developed report layouts using Seagate crystal report.

Developed the report parameter screens using Visual Basic.

Implementation: Provided support during implementation from

Offshore.

Project Single Source P&L

Title

Customer Brinker International Inc, Dallas, TX, USA

Duration June, 2000 - Jan, 2001

Technology ASP 3.0, MS SQL Server 2000, VBScript, Java script, HTML,

XML, Transact-SQL

Project Brinker International operates a chain of restaurants across

Abstract the United States of America. About 800 outlets across USA,

Canada and Puerto Rico. One of the largest casual-dining

operations in the US, It has started off with a project

titled "Single Source P&L Phase II" that aims to provide

A common interface and a centralized repository for entering

transactions (Invoices, IHTs, PCRs and Estimates) at the

Store level and use these transactions for the Corporate

Office purposes.

The facility to generate the Profit and Loss (P&L) report by

merging data out of this centralized repository with

additional data collected from various interfacing systems.

The objective is to create a common view of the P&L report

for the restaurant, district offices, and the corporate

office.

Role Abhijit was involved in developing some POC and thereby

proposing the architecture of the application.

Coding & Testing: Abhijit took the sole responsibility to

handle a module (involving maintenance of all the master

tables of the system through some common interface(s).)

starting from the analysis phase to the user acceptance

testing support. Successfully programmed and implemented

generic store procedures, user-defined functions and asp

pages to facilitate the requirement for all the tables.

Performance Improvement: Abhijit had an active role in

developing a generic middle-tier component to reduce the

stress during data loading and subsequent operations.

Project Application System Maintenance

Title

Customer Brinker International Inc, Dallas, TX, USA

Duration December 1999 - May 2000

Technology Visual Basic 6.0, MS SQL Server 6.5, SQA Robot

Project Brinker has a chain of restaurants based in Dallas, Texas,

Abstract USA. Brinker chains called Concepts, run two mission critical

systems for their daily operations: Brinker Store System

(BSS) and Brinker Catering System (BCS). Abhijit was involved

in maintenance of the BCS application. BCS is a MS VB based

application using Access front-end and SQL Server back-end.

It began in an effort to support the different concepts

operating a catering business.

Role Abhijit was involved in:

Bug fixing and Enhancement: This includes developing

interfaces using Visual Basic and preparation of unit test

procedure.

Design and Development: Design and implementation of store

procedures/data migration scripts.

Testing: This project involved various round of testing using

testing tool like SQA Robot. Abhijit was coordinating the

system testing from offshore.

Deployment and support: Abhijit was a part of the

implementation team. Revised all relevant documentation like

process flow, design and program specifications. Provided

support after production implementation and handed over

support to a dedicated maintenance team.

Contact this candidate