Project Oracle
Resume:
K andasamy Ramanathan
Sr. Oracle Consultant
*********@*****.*** / 646-***-****
EXPER IENCE SUM MARY
• 7 years of experience in O racle Pl / SQL, Data Modeling, Database, Application and
R eports Development
• Strong customer interaction skills and good hands-on knowledge in Requirements
gathering, Analysis, Estimation and Capacity Planning
• Currently working as the Lead Consultant and overseeing the work of 6 offshore
developers
• H ighly skilled and shown eminence in a ll phases of a Software Life Cycle –
Requirements, Analysis, Documentation, Design, Build and Testing / Support – in the
p rocess of implementing a comprehensive Reporting Solutions
• Experienced to t ranslate reporting and analytical needs into technical solutions
• Involved in Performance maintenance and tuning, PL/SQL optimization of data oriented
B usiness Logic Reporting Stored Procedure and Conversion of Components from Oracle
9 i to 10g and 10g to 11g
• Sound functional expertise in R eporting Modules and Strong technical experience in a
variety of Reporting Tools – B usiness Objects, C rystal Reports – and in Databases
solutions involving O racle SQL and PL/SQL
• Experience in b uilding and maintenance of a Banking Reporting Application
• Possess expertise with Oracle stored procedures, packages, and functions
• Strong knowledge in Oracle Cursor management, Global Temporary Tables, Exception
H andling, External Tables and also Experience in performance tuning (PL/SQL) using
SQL Trace, Explain Plan, TkProf, Indexing and H ints and Optimizing the oracle reports
• Working knowledge in designing and developing data architectures using common
and standard data modeling techniques
• Experience with d ata flow diagrams, data dictionary techniques, Enti ty relation
modeling and design techniques, database normalization theory
• H ighly interested in working with ER tools and in Data Modeling.
1 Page
K andasamy Ramanathan
Sr. Oracle Consultant
*********@*****.*** / 646-***-****
• Involved in the analysis and solving of several A dhoc Production Request / i ssues
T ECHN ICAL SKILLS
Oracle 11g / 10g / 9i, SQL Developer 3.0.04, TOAD 9.6,
DATABASES &
SQL*Plus, Control M and Unix
T OOL
S
Crystal Reports 10/XI, Business Objects Enterprise XI
REPORT I NG TOOLS
( Designer, Desk-I, Infoview, Crystal Management Console)
SQL,PL/SQL
PROGRAMM I NG
L ANG
UAGE
S
EDUCAT ION
Degree U niversity
Bachelor Degree (B.E) in Electronic and Madras Institute of Technology –
Communication Engineering A nna University, Chennai, India
EXPER IENCE SUM MARY
PROJECT PROF I LE 1 (Cur rent)
Project Title Northern T r ust Global Investments ETF Hub and I ndex
Services
Duration Jun 2012 – Till date
Client Northern T rust Bank, USA
Location Chicago, I L
Databases & Tools Oracle 10g/11g, SQL Developer 3.0.04, SQL*Plus, Control M and
2 Page
K andasamy Ramanathan
Sr. Oracle Consultant
*********@*****.*** / 646-***-****
Unix
PROJECT DESCR IPT ION
The ETF Hub will manage ETF specific reporting requirements and ETF specific processes
t hat would interface with Northern Trust’s core Fund Accounting, Custody and TA systems.
E TFH will receive static data that includes Authorized Participant, Investment Manager
and Fund information from other systems. Users interact with ETFH through a Dashboard;
t he Dashboard interacts with an Oracle database through a collection of WCF services.
Data feeds will be received from and t ransmit ted to external systems through message
queue and ftp server.
R OLES AND RESPONSIB I L I T I ES I N T HE PROJECT
• Working as the Onshore Lead Developer and System Architect
• Coordinating with Clients in Requirements gathering, Analysis, Estimation and
Capacity Planning
• Preparing the H igh Level -Technical Design Document for offshore team to proceed
w ith the Code Development
• Coordinating with Data Base Administrators in creation of New Oracle 11g database
and porting components from an Oracle 10g Database
• Experience to work with Control M Jobs and Unix Scripts
• Involved in the optimization of various SQL and PL/SQL Indexes, Hints and other
basic tuning techniques
• Involved in creating and maintaining Partitioned Tables and Indexes
• Involved in Data M igration between different level of database
• Preparing Pseudo code for ini tiating the design model as per the standards
• Maintain data purity throughout all level of the database
• Doing thorough Design & Code review for the development work like PL/SQL
p rogram units, procedures, functions and packages
3 Page
K andasamy Ramanathan
Sr. Oracle Consultant
*********@*****.*** / 646-***-****
• Coordinating with Offshore Team for clarifications on requirements &
u nderstanding, effort estimation & consolidating the deliverables for managing the UAT
Sign-off.
• Reviewing Unit Test Plan & Results
• Delegating the task to the Team and preparing the check list for the same.
• Participating in the daily status call with the offshore team to work in sync with the
team on their understanding level by each individual i tem.
PROJECT PROF I LE 2
Project Title J P MC TS UCard Reports
Duration Jan 2012 – May 2012
Client JPMorgan Chase & Co., USA
Location Tampa, FL
Reporting Tools Crystal Reports Developer 2008
Databases & Tools Oracle 11g, SQL Developer 3.0.04, SQL*Plus
PROJECT DESCR IPT ION
JPMorgan EFS was awarded the contract to deliver government benefits for the State of
U tah on a single card. The Utah One Card program will help the State of Utah improve
customer service to clients receiving benefits and will improve our platform to enable us to
board new clients more efficiently. Ucard reports is nothing but Sourcing reports / extracts
f rom the Oracle ODS (Operational Data Store) tables in terms of defined layout or the
s tructure way of obtaining client data to the state of Utah government.
ROLES AND RESPONSIB I L I T I ES I N T HE PROJECT
4 Page
K andasamy Ramanathan
Sr. Oracle Consultant
*********@*****.*** / 646-***-****
• Worked as the Onshore Lead Developer for the Ucard Offshore Development Team
• Involved in the Database Modeling & Impact Analysis for the requirements given.
• Coordinated with Clients in Requirements gathering, Analysis, Estimation and
Capacity Planning
• Prepared the H igh Level -Technical Design Document for offshore team to proceed
w ith the Code Development
• Prepared Pseudo code for ini tiating the design model as per the standards
• Maintain data purity throughout all level of the database
• Done thorough Design & Code review for the development work like PL/SQL
p rogram units, procedures, functions and packages for the complex scheduled crystal
reports.
• Coordinated with Offshore Team for clarifications on requirements &
u nderstanding, effort estimation & consolidating the deliverables for managing the UAT
Sign-off.
• Reviewed Unit Test Plan & Results
• Delegated the task to the Team and preparing the check list for the same.
• Participated in the daily status call with the offshore team to work in sync with the
team on their understanding level by each individual i tem.
• Experience to deal with huge databases.
• Experience to work with jobs and Schedule handling
• Involved in the optimization of various SQL and PL/SQL Indexes, Hints and other
basic tuning techniques
• Implemented Exception Blocks and used Pragmas in stored procedures as part of
f ine tuning them.
• Involved in creating and maintaining Partitioned Tables and Indexes
• Involved in Data M igration between different level of database
• Made use of the REF CURSORS in stored procedures for report generation
PROJECT PROF I LE 3
Project Title J P MC TS Pillar 2
Duration May 2011 – Jan 2012
Client JPMorgan Chase & Co., USA
Location Tampa, FL
Reporting Tools Crystal Reports Developer 2008
5 Page
K andasamy Ramanathan
Sr. Oracle Consultant
*********@*****.*** / 646-***-****
Databases & Tools Oracle 11g, SQL Developer 3.0.04, SQL*Plus
PROJECT DESCR IPT ION
P illar2 release 3 deals with the migration of the data/reports from Tandem platform to
O racle source. Separate Tandem OLTP from batch reporting by creating a real-t ime 1:1
replicated Oracle data store using Oracle Golden gate (OGG) data replication software.
Sourcing reports / extracts from the Oracle ODS (Operational Data Store) will allow for
f uture volume capacity on the Tandem hosts, lessen disk contentions, and provide dedicated
scalable Transaction processing.
ROLES AND RESPONSIB I L I T I ES I N T HE PROJECT
• Senior Development Team Member for the Onshore Development Team
• Involved in the Database Modeling & Impact Analysis for the requirements given.
• Coordinated with Clients in Requirements gathering, Analysis, Estimation and
Capacity Planning
• Prepared the H igh Level -Technical Design Document for offshore team to proceed
w ith the Code Development
• Involved in creating Pseudo code documents for wri ting stored procedures.
• Involved in implementing business logic with Oracle Stored Procedures, Functions
and T riggers using PL/SQL.
• Implemented Exception Blocks in stored procedures as part of fine tuning them
• Done thorough Design & Code review for the development work like PL/SQL
p rogram units, procedures, functions and packages for the complex scheduled crystal
reports.
• Coordinated with Offshore Team for clarifications on requirements &
u nderstanding, effort estimation & consolidating the deliverables for managing the UAT
Sign-off.
• Reviewed Unit Test Plan & Results
• Delegated the task to the Team and preparing the check list for the same.
• Participated in the daily status call with the offshore team to work in sync with the
team on their understanding level by each individual i tem.
• Involved in comparing Production data with Test data for identifying and cleaning
corrupted data
6 Page
K andasamy Ramanathan
Sr. Oracle Consultant
*********@*****.*** / 646-***-****
• Involved in Creating Indexes and Materialized Views for better performance
PROJECT PROF I LE 4
Project Title J P MC CSX (Client Service eXchange)
Duration Oct 2008 – May 2011
Client JPMorgan Chase & Co., USA
Location New York, NY
Reporting Tools Crystal Reports 10 & Business Objects XI
Databases & Tools Oracle 10g/9i, TOAD 9.6, TkProf & SQL*Plus
PROJECT DESCR IPT ION
C lient Service Exchange (CSX) is a PeopleSoft 9.0 CRM Call Center application which
captures the service requests (cases) created for JPMC by its clients. CSX Reporter is a
reporting utility that gathers, quantifies and displays the data that CSX captures. The CSX
Reporter has Dashboard reports, Summary & Detail level reports and Adhoc Reporting
capability. The Dashboards are used for Organizational/Managerial decisions. The
Summary, Detail and Adhoc reports are used by call center managers, call center leads and
call center agents.
ROLES AND RESPONSIB I L I T I ES I N T HE PROJECT
• Played a vital role in the Requirement analysis & gathering, Capacity planning,
Estimation, Client Approvals, Design, Reviews, Testing and also development for new
reporting components.
• Conducted knowledge sharing sessions over the new requirements of an enterprise
release to offshore.
• Reviewed the functional and technical designs of the requirements directly with
C lients and t rack the approval for the same.
• Conducted bi weekly Code Review and Unit Testing status updates meetings with
offshore team in order to meet and maintain the product standards.
7 Page
K andasamy Ramanathan
Sr. Oracle Consultant
*********@*****.*** / 646-***-****
• Done testing and debugging of all Crystal report, Business Object and Oracle
Components in order to evaluate the performance and to check whether the code is
meeting the business requirement.
• Was responsible for migrations of the code from Development environment to QA,
QA to UAT and UAT to Production environment.
• Was responsible for SQL tuning and optimization using AWRs and Explain Plans.
• Involved the Development of a new reporting module from the scratch and also in
t he maintenance of an existing application.
• Coordinated cross team impacts and supported dependent teams in report
generations.
• Worked with the External WEBi team in Reporting BO Universe migrations and
maintenance.
• Worked with the DBAs in Monthly database refresh process which involves pumping
t ransactional tables & data across databases. Also coordinated with DBA in creating
and managing table, indexes, table spaces, t r iggers, db links and privileges and
validating the Job executions.
• Maintained consistent accuracy in Monthly BO Dashboard report generations which
is circulated to higher level LOBs directly every month.
• Played a significant role in the successful implementation of Oracle Upgrade from 9i
to 10g.
• Carried out Defect Analysis and fixing of bugs raised by the Users.
• Generated reports based on the adhoc user requests using Crystal reports / BO /
W EBi – Rich client.
• Involved in Development Change request and proactively addressing Client’s needs.
• Involved in the analysis and solving of several Adhoc Production Request / issues
• Experienced in working with jobs and scheduling
• Involved in Data M igrations between different Databases
• Made use of the REF CURSORS in stored procedures for report generation
• Exposure to .NET ASP team needs and analyzing the cross team impacts to frame
t he Reporting Front End Application
P ROJECT PROF I LE 5
Project Title J P MC CSX (Client Service eXchange)
Duration Jul 2006 – Oct 2008
8 Page
K andasamy Ramanathan
Sr. Oracle Consultant
*********@*****.*** / 646-***-****
Client JPMorgan Chase & Co., USA
Location Chennai, India
Reporting Tools Crystal Reports 10 & Business Objects XI
Databases & Tools Oracle 10g/9i, TOAD 9.6, TkProf & SQL*Plus
PROJECT DESCR IPT ION
C lient Service Exchange (CSX) is a PeopleSoft 9.0 CRM Call Center application which
captures the service requests (cases) created for JPMC by its clients. CSX Reporter is a
reporting utility that gathers, quantifies and displays the data that CSX captures. The CSX
Reporter has Dashboard reports, Summary & Detail level reports and Adhoc Reporting
capability. The Dashboards are used for Organizational/Managerial decisions. The
Summary, Detail and Adhoc reports are used by call center managers, call center leads and
call center agents.
ROLES AND RESPONSIB I L I T I ES I N T HE PROJECT
• Played a vi tal role in the analysis, design, development and implementat ion of 6
enterpr ise project releases which involved creation of around 10 new repor ts and
change requests for around 35 repor ts.
• Actively involved in documenting t he Functional and t he Technical specifications.
• Ensured the hygiene of all lower envi ronment databases on continuous support.
• Addressed Level 3 issues on pr iori ty basis.
• Was awarded as t he Star Performer for an Enterp r ise Release.
• Handled t raining sessions for the Ent ry Level T rainees on Crystal repor ts and
O racle.
• Provided updates on daily basis to Onshore Team and JPMorgan Report ing
m anager about t he status of daily activi t ies, key issues and also about the
environment up-t i me.
• Conducted Offshore cross team impact knowledge shar ing sessions of an ER.
• Worked on reports covered a vast logic of using the formula columns, summary
columns, grouping as per t he requi rement of the user.
• Worked closely wi th t he .NET Development team in designing and development of
t he F ront end repor t ing layouts and schedule processing for few Repor ts
9 Page
K andasamy Ramanathan
Sr. Oracle Consultant
*********@*****.*** / 646-***-****
10 P a g e
Contact this candidate