SRIKANT CHANDRASEKHARAN HONE: 609-***-****

P

MAIL: acgclx@r.postjobfree.com

E

UMMARY

S

VER IGHT YEARS OF IT EXPERIENCE IN APPLICATION/DATABASE DESIGN, DATA MODELING, DATA INTEGRATION, WEB

O E

CLIENT SERVER APPLICATION DEVELOPMENT, REQUIREMENTS GATHERING, TESTING, IMPLEMENTATION,

AND

IGRATION OF ORACLE DATABASES AND SUPPORTING APPLICATIONS IN FINANCIAL AND MORTGAGE INDUSTRIES

M .

TRONG DATABASE PROGRAMMING SKILLS USING RACLE, SYBASE PL/SQL, SQL AND REPORTS WITH RACLE

S O O

RDBMS 11G, 10G, 9I THE BACKEND.

AS

EY STRENGTHS

K

● XPERT IN DEVELOPING TORED PROCEDURES, FUNCTIONS, PACKAGES

E S, TRIGGERS AND

TROUBLESHOOTING USING

PL/SQL AND

SQL.

● ROFICIENT IN

P TUNING OF APPLICATION FOR PERFORMANCE ENHANCEMENTS.

● XPERIENCED IN IMPLEMENTING ADVANCED FEATURES OF ORACLE LIKE UTONOMOUS TRANSACTIONS EF

E A, R

URSORS

C, PL/SQL TABLES, TABLE PARTITIONING(INTERVAL/RANGE/LIST/HASH/COMPOSITE), MERGE, MULTI

TABLE INSERTS, V ARRAYS ATERIALIZED VIEWS OLLECTION OBJECTS, GLOBAL TEMPORARY TABLES,M,C,

IPELINED/TABLES, FUNCTIONS, RESULT CACHE, WITH CLAUSE AND ULTI TABLE INSERTS

P M .

● UCCESSFULLY COORDINATED MANY

S ONSITE/OFFSHORE MODEL PROJECTS WHILE WORKING FOR LARGE CLIENTS

.

● XPERIENCED WORKING UNDER

E RIGID DELIVERY SCHEDULES AND

DEADLINES

.

IN

● ARTICIPATED IN

P REQUIREMENTS GATHERING WITH BUSINESS ANALYSTS FOR DEVELOPMENT PROJECTS

.

● TRONG DATABASE PROGRAMMING SKILLS USING RACLE PL/SQL, SQL AND REPORTS

S O WITH RACLE DATABASE AS

O

BACKEND.

THE

● ELL VERSED WITH OFTWARE DEVELOPMENT LIFE CYCLE (SDLC)

W S FROM

REQUIREMENTS GATHERING, ANALYSIS,

DESIGN, BUILD/CODING, TESTING, DOCUMENTATION MAINTENANCE

.

AND

● XPERIENCE WORKING WITH UTOSYS JOBS AND NFORMATICA

E A I .

● XCELLENT COMMUNICATIONS AND INTERPERSONAL SKILLS WITH DEMONSTRATED ABILITIES IN TRAINING & TEAM

E

BUILDING ACTIVITIES

.

EY SOFT SKILLS

K

PAGE 1 OF 7

OLID EXPERIENCE IN INTERACTING WITH BUSINESS TEAMS

S .

XTENSIVE TRAINING AND MENTORING EXPERIENCE

E .

OOD INTERPERSONAL AND COMMUNICATION SKILLS

G .

EY TECHNICAL SKILLS

K

ATABASES

D RACLE RDBMS 7.3, ORACLE 8.0/8I, ORACLE 9I, 10GR2 AND 11GR2

O

GL’S

4 QL*PLUS, PL/SQL

S

LATFORMS

P OS, UNIX, WINDOWS

D

OOLS

T OAD, RAPID SQL, WIN SQL, PL/SQL DEVELOPER

T,

ONFIG. MANAGEMENT ISUAL SOURCE SAFE, CVS, TFS, HARVEST

C V

EPORTING TOOLS

R CTUATE

A

DUCATION

E

ACHELOR OF ENGINEERING IN COMPUTER SCIENCE, JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY

B,

YDERABAD ANDHRA PRADESH, INDIA

H .

AST EXPERIENCE

P

ROJECT: PRODUCT MANAGEMENT URATION: AUG14 TO RESENT

P D P

OMPANY: BLOOMBERG BNA

C ROLE: DATABASE LEAD

PAGE 2 OF 7

ECHNOLOGIES: ORACLE, PL/SQL, UNIX, JAVASCRIPT

T

AS THE DATABASE LEAD DEVELOPER OF THE PRODUCT MANAGEMENT TEAM, I AM INVOLVED IN RE-ENGINEERING THE DATA

VISUALIZATION CENTER THAT REPORTS ANALYTICAL DATA OF THE US PTO STATISTICS.

I AM INVOLVED IN ENHANCEMENTS TO AND MAINTENANCE OF THE EXISTING WEBSITE (WWW.BNA.COM) OF THE BUREAU OF

NATIONAL AFFAIRS. THE APPLICATION IS PRIMARILY

ESPONSIBILITIES:

R

EAD DEVELOPER OF A TEAM WITH 3 PEOPLE

L

ORK DIRECTLY WITH BUSINESS USERS TO GATHER REQUIREMENTS

W

EAD AND PARTICIPATE IN DESIGN, DEVELOPMENT, UNIT TESTING, AND MAINTENANCE ACTIVITIES

L .

UPPORT QA TESTING/DEFECTS, UAT, PERFORMANCE TESTING, BREAK FIXES, PRODUCTION ISSUES

S .

ORK CLOSELY WITH UPSTREAM AND DOWNSTREAM SYSTEMS FOR INTEGRATION

W .

ROJECT: DOCUMENT MANAGEMENT – OPERATIONAL DATA SOURCE DURATION: APR13 TO UG14

P A

OMPANY: BANK OF AMERICA

C ROLE: DATABASE LEAD

ECHNOLOGIES: ORACLE, PL/SQL, UNIX

T

THIS WAS A START-FROM-SCRATCH DEVELOPMENT OF A DOCUMENT MANAGEMENT PRODUCT TO PROVIDE FULL SUITE OF

REUSABLE SERVICES ACROSS ALL MORTGAGE CHANNELS, PRODUCTS AND LOB. IT IS A CENTRALIZED OPERATIONAL

WAREHOUSE MODEL FOR DOCUMENT MANAGEMENT SERVICES LIKE DOCUMENT GENERATION, ROUTING, CAPTURE, STORAGE,

CLASSIFICATION, REFERENCE, AND PRESERVATION.

MY ROLE IN THE PROJECT WAS TO LEAD THE TEAM AND PARTICIPATE IN DESIGN AND DEVELOPMENT OF THE DATA STORE.

MATERIALIZED VIEWS, PACKAGES, STORED PROCEDURES, MULTI-TABLE INSERTS, PARTITIONING, WRITING ETL PROCESSES

USING PL/SQL, GOLDEN GATE REPLICATION ARE SOME OF ORACLE FEATURES WE’VE IMPLEMENTED.

ESPONSIBILITIES:

R

AVE BEEN THE SUBJECT MATTER EXPERT FOR THE PROJECT SINCE THE BEGINNING OF THE DEVELOPMENT

H .

EAD DEVELOPER OF A TEAM WITH 4 PEOPLE

L

ORK CLOSELY WITH BUSINESS/SYSTEM ANALYST TEAM TO GATHER REQUIREMENTS AND LAYOUT HLD

W

EAD AND PARTICIPATE IN DESIGN, DEVELOPMENT, UNIT TESTING, AND MAINTENANCE ACTIVITIES

L .

PAGE 3 OF 7

UPPORT QA TESTING/DEFECTS, UAT, PERFORMANCE TESTING, BREAK FIXES, PRODUCTION ISSUES

S .

ERFORMANCE TUNING – EXPLAIN PLANS, AWRS

P

UPPORT TABLES REPLICATED OVER ORACLE GOLDEN GATE REPLICATION BY CLOSELY WORKING WITH THE DBA

S

TEAM

ORK CLOSELY WITH UPSTREAM AND DOWNSTREAM SYSTEMS FOR INTEGRATION

W .

ROJECT: ALTERNATIVE INVESTMENTS

P DURATION: JUL 12 - PRESENT

OMPANY: BANK OF AMERICA MERRILL LYNCH

C ROLE: TECHNOLOGY ANALYST

ECHNOLOGIES: ORACLE, ACTUATE, UNIX, SQL, PL/SQL, AUTOSYS

T

THE PROJECT INVOLVES MAINTENANCE ALTERNATIVE INVESTMENT BANKING APPLICATIONS OF MERRILL LYNCH.

MY MAJOR WORK HAS PRIMARILY INVOLVED PRODUCTION SUPPORT AND MINOR ENHANCEMENTS AND DESIGN. MOST OF THE

WORK IS SURROUNDING THE HUGE DATABASES THE SYSTEM RELIES ON. EXPOSURE TO AUTOSYS HAS BEEN A PLUS WORKING IN

THIS PROJECT.

ESPONSIBILITIES:

R

ROVIDE ROUND THE CLOCK PRODUCTION SUPPORT FOR ALL DEPENDENT APPLICATIONS

P

ORK WITH THE OFFSHORE TEAM ON A DAILY BASIS TO ENSURE CLOSURE OF TICKETS

W

UPPORT AND MAINTAIN PROGRAMMATIC CHANGES AND ENHANCEMENTS

S

ROVIDE USER SUPPORT AND DELIVER USER & PROCESS DOCUMENTATION

P .

ORK EXTENSIVELY ON FIXING DEFECTS OF DIFFERENT COMPLEXITIES

W .

NDERSTAND AND REPLICATE THE DEFECTS, ANALYZE THE CAUSE OF THE DEFECT AND FIND THE CORRECT FIX

U .

ORKED WITH THE DBA TEAMS IN CASE OF PERFORMANCE TUNING DEFECTS

W .

O CODE REVIEWS OF CODE WRITTEN BY OTHER TEAM MEMBERS IN THE TEAM

D .

PAGE 4 OF 7

OMMUNICATE/WORK WITH THE CLIENTS IN ORDER TO UNDERSTAND HIGH LEVEL/ESCALATED DEFECTS AND ENSURE

C

THEY ARE RESOLVED QUICKLY.

RITE AND DELIVER QUICK FIX SOURCE CODE FOR CRITICAL CLIENT ESCALATION DEFECTS.

W

ROJECT: INTERNET BANKING APPLICATIONS

P DURATION: MAY08 TO FEB12

OMPANY: WACHOVIA/WELLS FARGO

C ROLE: TECHNOLOGY ANALYST

ECHNOLOGIES: ORACLE, ACTUATE, UNIX, SQL, PL/SQL

T

THE PROJECT INVOLVES MAINTENANCE OF WACHOVIA INTERNET BANKING APPLICATIONS LIKE OPENING A NEW ACCOUNT,

ENROLLMENT TO SERVICES, CHECK CARD ACTIVATION, ADVERTISEMENT TOOL, THIRD PARTY TOOLS LIKE KANA AND

TUMBLEWEED AND ALSO DEVELOPING REPORTS FOR THE APPLICATIONS IN ACTUATE USING ORACLE AND SQL SERVER AS

BACKEND.

MY MAJOR WORK HAS BEEN ON AN APPLICATION CALLED TARGETED COMMUNICATIONS TOOL. THE TOOL ENABLES THE

MARKETING TEAM OF WACHOVIA INTERNET BANKING TARGET CUSTOMERS AND DELIVERS ADS ON THE AUTHENTICATED SPACE.

THIS TOOL, PRIMARILY DATABASE INTENSIVE, WAS DEVELOPED BY US AND WE ARE CONTINUING TO MAINTAIN IT SINCE. MY

ROLE IN THE PROJECT WAS INITIALLY TO DEVELOP THE PL/SQL CODE; AND LATER – REQUIREMENT GATHERING, DATABASE

DESIGN, UI DESIGN; GRADUALLY, BECAME THE SME.

ESPONSIBILITIES:

R

AVE BEEN THE SUBJECT MATTER EXPERT FOR THE PROJECT SINCE THE BEGINNING OF THE SECOND PHASE

H .

UPPORT AND MAINTAIN PROGRAMMATIC CHANGES AND ENHANCEMENTS

S

NVESTIGATE, DESIGN, IMPLEMENT ENHANCEMENTS TO THE

I OLTP APPLICATION AND OTHER INTEGRATED

APPLICATIONS

ORK WITH END USER

W ORGANIZATIONS TO DETERMINE REQUIREMENTS AND COORDINATE TESTING OF

ENHANCEMENTS

ROVIDE USER SUPPORT AND DELIVER USER & PROCESS DOCUMENTATION

P .

MPLEMENTED THE AUTOMATED ONLINE ADS. THIS WAS DONE WITH MINIMAL DESIGN CHANGES

I .

ORKED WITH DBA ON CREATING THE DATA MODEL FOR THE OLTP AND THE REPORTING DATABASE

W .

ESIGNED AND DEVELOPED THE DATABASE OBJECTS ON BOTH THE DATABASES

D .

ORKED EXTENSIVELY ON FIXING DEFECTS OF DIFFERENT COMPLEXITIES

W .

NDERSTAND AND REPLICATE THE DEFECTS, ANALYZE THE CAUSE OF THE DEFECT AND FIND THE CORRECT FIX

U .

PAGE 5 OF 7

ORKED WITH THE DBA TEAMS IN CASE OF PERFORMANCE TUNING DEFECTS

W .

O CODE REVIEWS OF CODE WRITTEN BY OTHER TEAM MEMBERS IN THE TEAM

D .

OMMUNICATE/WORK WITH THE CLIENTS IN ORDER TO UNDERSTAND HIGH LEVEL/ESCALATED DEFECTS AND ENSURE

C

THEY ARE RESOLVED QUICKLY.

EAD DEVELOPER AND LATER TECHNOLOGY ANALYST OF A TEAM WITH 11 PEOPLE

L .

ERFORM UNIT TESTING AND SYSTEM TESTING

P .

NSURE CODE IS CHECKED INTO VERSION CONTROL SOFTWARE

E .

RITE AND DELIVER QUICK FIX SOURCE CODE FOR CRITICAL CLIENT ESCALATION DEFECTS.

W

RITE PROGRAM SPECIFICATIONS, DO CODE REVIEWS, PREPARE UNIT TEST PLANS, UTP AND TSPEC REVIEWS

W .

ROJECT: NEW FUNDS & INCOME ANNUITY PROJECT

P DURATION: FEB08 TO MAY08

OMPANY: FIDELITY

C OLE: DEVELOPER

R

ECHNOLOGIES: SYBASE, UNIX, PERL, ORACLE, SQL, PL/SQL

T

THE SYSTEM'S DATABASE WAS BEING MIGRATED FROM SYBASE ORACLE. WHILE

TO SOME OF THE EXISTING FUNCTIONALITIES

HAD TO BE RE-WRITTEN, SOME OTHERS HAD TO BE TUNED ON THEIR PERFORMANCE.

ESPONSIBILITIES:

R

E WRITE THE SYBASE CODE IN ORACLE FOR ALL OBJECTS LIKE STORED PROCEDURES, FUNCTIONS AND TRIGGERS.

R

NALYZE THE SYSTEM FOR ANY NEW ENHANCEMENTS PROPOSED

A

EVELOP CODE FOR NEW ENHANCEMENTS REQUESTS AND INCORPORATE IT INTO THE SYSTEM

D .

ROVIDE CODE REMEDIATION’S FOR ISSUES FOUND AFTER MIGRATING TO ORACLE

P .

UNE DATABASE QUERIES THAT PERFORMED BADLY

T .

PAGE 6 OF 7

ROVIDE CODE AND DATA FIXES TO RESOLVE ISSUES DETECTED IN THE SYSTEM

P .

EVELOP CODE FOR NEW ENHANCEMENTS REQUESTS AND INCORPORATE IT INTO THE SYSTEM

D .

ROJECT: POST TRADE PROCESSING

P DURATION: MAR 07 TO FEB 08

LIENT: FIDELITY

C ROLE: DEVELOPER

ECHNOLOGIES: SYBASE, UNIX, PERL, ORACLE, SQL, PL/SQL

T

IT DATABASE PERFORMANCE TUNING PROJECT. THE 12 YEARS. OVER

WAS A SYSTEM HAD EVOLVED OVER THE LAST THE

PERIOD OF TIME, DATA AND REPORTING REQUIREMENTS HAD ALSO INCREASED WITH GROWTH IN THE CUSTOMER BASE AND

TRADING VOLUMES RESULTING IN PERFORMANCE ISSUES. TO ADDRESS THIS, THE PTP DATA WAREHOUSE WAS CONSIDERED FOR

PERFORMANCE ENHANCEMENT ALONG WITH DATA CLEAN UP. THE DATABASE WAS ALSO BEING MIGRATED TO THE NEXT HIGHER

– FROM SYBASE 12.5 TO 15.

VERSION

ESPONSIBILITIES:

R

EFORE MIGRATION, CLEAN UP THE DATABASE BY IDENTIFYING THE UNUSED OBJECTS

B .

ROVIDE PARTITIONING AND INDEXING RECOMMENDATIONS TO ENHANCE OVERALL PERFORMANCE

P .

IGRATED THE DATA FROM SYBASE 12.5 TO 15 SERVER USING BCP.

M

WARDS RECEIVED

A

OST VALUABLE PERFORMER AWARD: HIS IS ONE OF PRIME AWARDS GIVEN OUT FOR OUTSTANDING PERFORMANCE

M T

INFOSYS

.

BY

POT AWARD: NFOSYS HAS AWARDED ME THE SPORT AWARD AS RECOGNITION FOR MY EFFORTS FOR MEETING THE

S I

PROJECT DEADLINES AND VARIOUS FACTORS THAT CONTRIBUTED TO THE HUGE SUCCESS OF THE PROJECT

.

OST VALUABLE PERFORMER AWARD: HIS WAS AWARDED TO ME FOR MY INITIATIVE EFFORTS THAT CONSIDERABLY

M T

REDUCED THE OVERHEADS AND IMPROVED THE OVERALL PERFORMANCE, WHICH MADE THE PROJECT A HUGE

SUCCESS

.

RIMA AWARD: HIS AWARD WAS PRESENTED TO THE ENTIRE PROJECT FOR EXCELLENCE IN PROJECT EXECUTION

P T .

PAGE 7 OF 7

Contact this candidate