Data Project

NABA KISHORE PRADHANI

Phone # 518-***-****(Home)/518-***-****(Cell)

Personal Synopsis

Nature of Projects Managed as Lead Data Architecture/Data Modeler:

Federal funded WICSYS (Women Infant Child State wide Enterprise Benefit Systems) for New York State.

Federal Funded JSY (Just Say Yes) towards Obesity prevention web based project for New York State.

Federal Funded EWPH (Eat Well Play Hard) towards Obesity prevention web based project for New York State.

Investigation & Security Mobile Applications for Bureau of Special Investigation for New York State.

Data Warehousing Project – NY State –DOH-DON

On-line Stock Trading Projects.

Financial Banking Projects – Home Mortgage Risk determination System..

Marketing System for Insurance Sector- Both Life and Health Care Insurance.

ERP Projects in Manufacturing Industry in India.

Disaster Recovery Management Projects.

Experiences

15+ years of experiences as Sybase ASE 15.0.3/12.5.0.3/12.x/11.9.2/11.x, Database Administration with dual expertise in both Production and Developmental Database level administration.

More than 10 years of experiences in Project Management Planning, Project tracking, Interaction with clients for business process gathering, Preparation of requirement gathering documents, Sign off the requirement documentation, Activities scheduling and allocation of activities, Monitoring of activities and scheduling weekly meeting with team members and clients for monitoring the progress of project.

Strong experiences in handling, managing the Software application Projects within scheduled time applying project management tools like Risk Management, Task-Breakdown and allocation, project scheduling and Monitoring by using MS-Project and MS-Office tool.

More than 15 years of experiences to work as Data Architecture/Data Modelling to design and develop both OLTP as well as OLAP application software in various business domains like Finance, health, Investigation, Home Mortgage and manufacturing.

Certified SYBASE DBA.

Supported 500 GB of data in more than 15 multiple servers and multiple platforms.

More than 15 years experiences to design both normalized (3NF) data modeling and Dimensional (Star Schema) data modelling for data warehousing project using tools like ER-WIN and Power Designer.

15 years of experiences in preparing Data Flow diagram, Conceptual and data process diagram for both OLTP and OLAP (DW) projects in both Financial & Insurance sectors.

15 years of experiences in Database DDL scripts that includes Data Dictionary, Reverse and forward engineering of the large database.

15+ years extensive experiences of supporting and managing large databases in Financial Institute (Both Investment banking and Home Mortgage), Insurance, Healthcare & Manufacturing sectors.

15+ years of extensive experiences in Performance and tuning of Application Database in complex environment and Query optimization tools like update statistics, Show plan, dbcc trace on, optdiag, Statistics IO etc.

15+ years of strong experiences in 24x7 Production support for Large databases in the organization like Finance, Insurance & Manufacturing.

15+ years of experiences in Database design (Both physical and logical ) by using ER diagram tools like ER-Win, Power Designer and Rational Rose.

10 Years of experiences in Data base design or Architecture in both logical and physical design of both OLTP and Data Mining /warehouse based applications.

10 years of experience with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.

More than 15 years of strong experiences in writing Sybase database objects like Stored Procedures, Triggers, Cursors using T-SQL, Embedded SQL, UNIX Shell & PERLScripting, DB-Lib & CT-Lib, C functions etc.

15+years of strong experiences in UNIX OS Administration and Shell & Perl scripting for automating the jobs.

Technologies

Languages

C

VB, .NET

SHELL SCRIPTING

ISQL, SQR

PERL

HTML

JAVA SCRIPT

T-SQL

PL/SQL

SQL

XML

Operating Systems

UNIX (SUN SOLARIS 2.6/7/8.0

AIX 4.X

HP UNIX

OS/390

WINDOWS NT

MS-DOS 6.22.

Technologies

SYBASE CENTRAL

ORACLE ENTERPRISE MANAGEMENT

DBI2

TOAD 7.X

RAPID SQL

ERWIN

RATIONAL ROSE

POWER DESIGNER

DB ARTISAN.

LOTUS NOTES R5

DIRECT CONNECT

SYBASE OPEN CLIENT, GATEWAY

ER DIAGRAM

NORMALIZATION

OBJECT MODELLING

STAR SCHEMA.

SQL BACKTRACK 4.X

RECOVERY MANAGER (RMAN)

VERITAS VOLUME REPLICATOR

POWERBUILDER 6.0/7.0 /10.5

PFC

NOTES R5 (DOMINO SERVER)

SP-DEBUGGER

Communication Protocols

TCP/IP

FTP

TELNET

SMTP

HTTP

POP3

Databases

SYBASE ASE 10/11/12.0/12.5/15.03

SYBASE OPEN SERVER 12.X, SYBASE ASA V5.5/7.0

SQL SERVER 6.0/7.0

ORACLE 8I

DB2 V5/6

SQL IANYWHERE 11.X

MS ACCESS

SYBASE REPLICATION SERVER 11.5,11.9.2 & CI

Software

MS OFFICE

MS PROJECT

Hardware

SUN SPARC SERVER

IBM MAINFRAME

PC PENTIUM

DIGITAL ALPHA SERVER

ALTOS 1100 SERVER

References & Achievement

Debra L. Hathaway/BSI/DON/CCH/OPH/DOH

11/25/2009 08:23 AM

To

Guido Quattrocchi/BITS/DON/CCH/OPH/DOH@NYSDOH

cc

Naba K. Pradhani/BITS/DON/CCH/OPH/DOH@NYSDOH, Marc Nickford/BITS/DON/CCH/OPH/DOH@NYSDOH, Sylvia N. Maimone/BSI/DON/CCH/OPH/DOH@NYSDOH, Frank Coleman/BSI/DON/CCH/OPH/DOH@NYSDOH, Patricia A. Hess/DON/CCH/OPH/DOH@NYSDOH, Mary W. Cowans/DON/CCH/OPH/DOH@NYSDOH

Subject

CARS II Rollout

Guido - I would like to recognize the fine work and valuable assistance Naba Pradhani & Marc Nicford provided to Sylvia to get the new CARS system up and running. The rollout of the new CARS system has gone fantastic. I know that Naba, Marc & Sylvia have worked very hard on this project & appreciate all of their efforts. We never would have had this success without the IT support.

Thank you to you & your staff. Have a Happy Thanksgiving!

Debra L. Hathaway, Executive Deputy Director

Bureau of Special Investigations

Division of Nutrition

NYS DOH

Experience:

NY State Health Dept., NY, USA June’03 –Till Date

Lead Data Architecture/Data Modeler

Worked as Data Base manager for the following projects for New York State - DOH .

1.WICSYS (Women Infant Child State wide Enterprise Benefit Systems) Client-Server.

2.JSY (Just Say Yes) towards Obesity prevention Web based project.

3.EWPH (Eat Well Play Hard) towards Obesity prevention Web based project.

4.Investigation & Security Mobile Applications for Bureau of Special Investigation.

5.Data Warehousing Project for WIC Application.

Installed, Maintained, Upgraded and configured Sybase ASE 15.O.3/12.5.0.3/ 12.0/ 11.9.2 on both UNIX and Windows NT.

Interact with business stakeholders and project management team to gather project scope and requirement.

Prepare high level business models and presented to the stakeholders.

Develop the schedule using MS Project

Maintain the schedule using MS project to track progress

Ensure adherence to project management standards and methodologies.

Interact with users for analyzing the business requirement.

Designed and Customized data models for Data Mart supporting data from multiple sources on real time. Designed the Data Mart defining Entities, Attributes and relationships between them.

15 years of experiences on Data modelling and data architecture for large database like Teradata.

Segmentation & object placement.

Interact with Business analyst to understand the business process and prepared the database design document.

Developed both physical and logical database design.

Developed process and conceptual data models.

Developed dataflow diagrams of the various databases of the organization.

Maintained and developed the data dictionary of the databases.

Used the Star Schema data modeling concept for Data warehousing database for the organization to provide/generate the Business Intelligences reports or data mining.

Designed and Customized data models for Data Mart supporting data from multiple sources on real time. Designed the Data Mart defining Entities, Attributes and relationships between them.

Designed and developed Informatica Mappings to load data.

Prepared and generate the ER diagram for the application by using Power Designer.

Designed both the physical and logical design of the database by using Normalization rules.

Prepared the capacity planning report for the applications.

Moved the application to Production server.

Tune and scheduled the Batch jobs.

Wells Fargo, Frederick, MD Oct,02 – May’03

Data Architecture/Data Modeler

Worked on Application Development and Production support for a project of Wells Fargo’s Secondary Marketing System (SMS) on Sybase 11.9.2 & 12.5 on Sun Solaris 2.5 & 2.8.

Responsibilities:

Installation of Sybase 12.5 ASE server in Production, Test and Development server.

Interact with Business analyst for requirement gathering and understanding the complete business processing.

Prepared Data Modeling diagram and document for the application by using Entity Relationship tools like ERWIN 4.0 & Power Designer.

Converted the ER-Diagram to both physical and logical design of databases by using Normalization and denormalization techniques.

Creation of Databases and database objects like tables, views, triggers, cursors and indexes in the server.

Interact with business stakeholders and project management team to gather project scope and requirement.

Prepare high level business models and presented to the stakeholders

Make PowerPoint presentation to the higher authority and design the high level documents.

Lead the design, development and implementation of client-server application by adopting System Development Life Cycle (SDLC) methods.

Maintain and release the application codes by using Configuration Management tool like PVCS

Monitored the Disk space and transaction log space by using Sybase threshold technique.

Monitored the health of the database using DBCC.

Wrote numbers of stored procedures and triggers by using T-SQL for maintaining the referential integration of the database.

Installation and configuration Veritas Cluster Volume Manager.

Performance tuning the database by resolving/tracing Deadlock & Lock, cache optimization, index removing and rebuilding.

Made application tuning by optimizing query technique like show plan, statistic io, dbcc trace on, update statistics and optdiag utilities etc.

Wrote number of UNIX Shell scripts for automating the batch jobs.

Porting the client applications to the server.

Prepared Disaster Recovery planning by using Warm Standby Sybase Replication installation and configuration.

Moved the application to Production server.

Tune and scheduled the Batch jobs.

AegonUSA- Frazer, PA USA Feb. 01- Sept. 02

Data Architecture

He worked on Application Migration Project from Sybase ASE 11.9.2 server to Oracle 8i & DB2 UDB servers in MNC Life Insurance Company of USA.

Responsibilities:

Installation and Up gradation of Oracle server in Test, Model & Production servers.

Interact with Business analyst for requirement gathering and understanding the complete business processing.

Prepared Requirement specification analysis and discussed with business analyst for final sign on the documents.

Prepared Data Modeling diagram and document for the application by using Entity Relationship tools like ERWIN 4.0.

Converted the ER-Diagram to both physical and logical design of databases by using Normalization and de normalization techniques.

Prepared a Capacity planning report to estimate the level of Database sizes for application packages.

Prepared the detail database schema for the applications.

Prepared Backup, recovery plan and disaster recovery plan for all the Database servers by using archived logs and third party tools like EMC & BMC PATROL.

Has configured the Sun Solaris Unix clustering of devices for database allocation.

Participated in the re-designing of databases and data modeling with senior developers, data modelers and business analyst.

Provided 24x7 full Production support for maintaining the databases.

Created Database files, table spaces, users, and roles for all designed applications.

Wrote packages, functions, Stored procedures, triggers and cursors for database security and performances by using PL/SQL.

Designed and coded procedures that uploaded data via a Database Link, on a daily basis, from one Oracle 8i database to another.

Fine-tuned certain SQL queries in the existing applications that were causing performance bottle-necks for optimum performance using tuning tools like EXPLAIN PLAN/TKPROF

Replication from Sybase Data to Oracle and DB2UDB 7.0 using Direct Connect and configuring CI Server.

Configured the server for replication of data from Oracle server to Sybase server and DB2 and allowing some users to access remote server data.

Made Database tuning by configuring database parameters and enhanced the performance of databases by using techniques like Partitioning the tables, indexes, Cache management & configuration, Segmentation and object placement.

Prepared Data conversion and migration planning from Sybase Database and DB2 database to Oracle database by using tools like BCP, SQLLDR, SPUFI, BMC Utilities and Load.

Performed monitoring, analysis and maintenance of all production databases.

Analyzed Query by using tools like Explain plan and SQL Auto trace and assist developers for writing the stored procedures in efficient way.

Replicated data from Sybase to Ms SQL server using Direct Connect and SQL Remote Connect.

Wrote Stored procedures, triggers and cursors for database security and performances by using T-SQL and PL/SQL.

Wrote Perl scripts for batch/ Cron jobs

Wrote lot of backend interface files by using Shell scripts & C for handling multi vendor data files and inserting/updating data in the different tables.

ABN AMRO BANK, Chicago,USA Jun. 00 – Jan. 01

Database Administrator

This project included database administration support for production trading systems for world’s one of the largest financial institute in North American operations. These critical applications were used by traders to enter trades from within the bank and also by clients using the Internet for trading.He worked as primary DBA for Trade desk, and Fixed Income and secondary DBA for few other applications. These applications interacted with several other applications and receive/feed data to other banks and financial organizations.

Responsibilities:

Installed, Maintained, Upgraded and configured Sybase ASE 12.0/ 11.9.2/ 115x on both UNIX and Linux OS.

Provided Production support for multiple applications and maintained database Systems, responded to the user requests and managed multiple projects.

Interact with Business analyst to understand the business process and prepared the system requirement documentation.

Prepared and generate the ER diagram for the application by using Power Designer.

Designed both the physical and logical design of the database by using Normalization rules.

Prepared the capacity planning report for the applications.

Installation and configuration Veritas Volume Replicator for data replication for disaster recovery..

Estimate the database estimation.

Create the databases, schemas, indexes, views and triggers for the application.

Create roles, user, groups in the server for the security of database and application.

Used Sybase Server utilities for performance tunings on the databases.

Handled and documented trouble shooting problems. Provided support in development and testing of applications.

Monitor and troubleshooting the Sybase Database.

Installed, configured tuned and troubleshooted the Sybase Replication server 11.50 for replicating the data from Chicago to NY & NJ site.

Involved in the functional test specifications of Sybase SQL product, also actively participated in life of the product (Alpha, Beta and GA).

Analyze Query by using tools like Showplan and DBCC traceon, statistic io and assist developers for writing the stored procedures in efficient way.

Lead team of S/W engineers assigned tasks, mentored and attended team meetings.

Developed new Schemas, Stored procedures, Cursors for the existing Test Results Database.

Configured, tuning and troubleshooting the Sybase replication server 11.5 at various Sybase locations.

Developed ct-lib programs to run C-based client applications.

Developed Perl /Shell scripts for Report Generation.

Prepared the shell scripts to take the object level and database backup using BMC PATROL utilities.

Used Sybase utilities (Unix) bcp (fast/slow), DBCC, Isql, defncopy and dsedit and Sybase Power Designer for Data Modelling.

Created performance indexes, referential constraints and triggers

Performed and set up regular restores and backups using cron jobs

Tested the Stored Procedures and SQL queries written by QA person

Visa Status: US Citizens

Education:

Master in Business Administration Indira Gandhi National University.

Govt. Engineering College Ravishankar University, India

Bachelor in Engineering

Certification

SYBASE Database Administration.

Training & Workshop

Sybase 11.x Database Administration

Computer Simulation

Internet & Networking

Project Management

Contact this candidate