尊敬的 微信汇率:1円 ≈ 0.046166 元 支付宝汇率:1円 ≈ 0.046257元 [退出登录]
SlideShare a Scribd company logo
Oracle Certified Associate
Arunprakash Alagesan
Email: arun.prakash.alagesan@gmail.com, Phone: +1 8134201694
Experience Summary
• 9 years of IT experience with TATA Consultancy Services Ltd working on application
development & support project for the client CITI Bank.
• Experience with all the phases of software development lifecycle (SDLC) including
requirements gathering, design, development, testing & deployment
• Sound coding knowledge of Oracle 11g coding with performance tuning skills.
• Hands on experiance with Oracle SQL, PL/SQL coding (Packages, procedures, functions,
triggers, cursors,indexes,tables , views, tuning, ....etc)
• Good problem solving skills and ability to work independently
• Good communication skills
• Currently working with Citi bank client for the corporate actions in the BaNCS application
development and maintenance project.
• Previously I worked with Bank of America client for the Finance Data warehouse application
development and production support project.
• Also I worked with Tata consultancy services internal application named Integrated Project
Management system where associates time sheet entry captured for billing and financial
process.
• Sound knowledge of quality management process .
• Got the Best team Award from TCS GEMS for delivering the Normalisation solution for the
timesheet with no defects.
• I have done lots of performance tuning in the FDW project . I have received an award for
tuning the 8hours long running job from the Bank of America client. The job runs less than 5
minutes after tuning which saves lots of time and resources. The performance tuning was
performed in the PL/SQL code.
• I have received the Technical Excellence Award from TCS GEMS for the monthly jobs tuning
in FDW.
• I have automated few failing AUTOSYS jobs which requires user’s manual user intervention.
• I develop and debug Unix shell scripts.
• I worked in NDM setup between two nodes in the Unix servers. Also i can make Unix scripts
to send/receive the files between two nodes via NDM.
Technology
Below is a list of important hardware, software products, tools and methods that I have
worked with.
Page 1 of 7
Operating Systems Software Products Tools
Windows XP, Windows 7 Oracle PL/SQL, SQL
Developer, HTML, C+
+ ,WinSCP, Unix ,MQs,
Jasper reports ,Autosys
scheduler configuration,
Unix shell scripting,
BaNCS product for
corporate action,
Websphere 8.0, Nightly
Cycle
PLSQL developer 7.0, SQL
Developer 2.1.1.64, Microsoft Visual
SourceSafe, EditPlus, Putty ,IBM
MQ client 7.0, Nightly cycle, Tera
data, Autosys R11, iReport 3.6,
BaNCS V4.0, MS Office, Connect
direct
Oracle Certified Associate
Certifications
Professional Society / Certification Member Since / Date Certified
Oracle PL/SQL Developer certified Associate October-2009
SQL (ANSI) Fundamentals - Assessment - E2 February-2009
ORACLE PL/SQL – TCS Assessment-E2 February-2011
Qualifications
Degree / PG Name of University Specialization
Place of
University
Year of
passing
Bachelor of
Engineering
Anna University
Chennai (Madras
Institute of
Technology, Chennai)
Electronics And
Instrumentation
Engineering
Chennai MAY-2007
Diploma
State board of
Technical education
and Training
Computer Technology Chennai APRIL-2004
Project Thesis
Project Title BaNCS Application development and support
Customer CITICORP NORTH AMERICA, INC
Description BaNCS replaces Stock and Bond Security Systems (SBSS) and CMO as the main
Income processing system for US Asset Servicing within the Global Transaction
Services (GTS) business. BaNCS does income processing for CMO, MBS, Agency,
TIPS, RBI and Dividends for Income and Tax team. BaNCS is a product of Tata
Consultancy Services and CITI bank requires it for corporate actions. We have
PROD/UAT(QA)/SIT environments which require the BaNCS component
deployment and ensuring the environment availability to our clients. BaNCS system
connected to CAPRI, CCF, security master, DTC/FED/GCA, CAIN, GIW, MQs,
Page 2 of 7
Oracle Certified Associate
NRA, Tax minder, EDS, CSD, DUBLIN, EERS, ASTRA and SWIFT gateway.
BaNCS receives/sends the SWIFT messages to the various applications for the
event of corporate action during the intraday and end of day cycle.
Role Project leader
Tools BaNCS V4.0, AUTOSYS R11.3, Oracle PL/SQL Developer , Unix Putty,
iReport 3.6 ,WinSCP and IBM MQ client 7.0, NDM, Websphere 8.0
Responsibilities • BaNCS component development and deployment in the various instance
like SIT/UAT/DEV.
• Writing the PL/SQL , Unix scripting codes for the new requirement.
• Creating jobs in Autosys and scheduling as per the requirement
• Monitoring and fixing the failure jobs in Autosys
• Modifying the existing code for the defects raised by the application user.
• Loading the user provided feeds in the environment for testing.
• Providing the requested event feed for the various application.
• Analyzing the Business Requirements and System Specifications to
understand the application
• As a team member responsible for Application monitoring, Bug fixing, and
Enhancements.
• Conduct Unit Testing to ensure the Individual Application
Component/Module is working
• Involved in giving induction for new joiners in the project
• System Integration Testing is to ensure whether the complete solution is
working under the integrated System and Application Component
• Code Review-Internal Code Review Process and mitigation strategies for
the project.
• Using IPMS, manage, implement and maintain different phases of the
software life cycle including bug fixing, maintenance and support activities.
• Fieldglass onboarding and billing activities.
Highlights  Performance improvement of one of the long running BaNCS job.
The BaNCS job stuck after 3hours of long running. I have tuned the
SQL query and after tuning the same job completes few minutes.
 Delivering the defect free code to our client
Solution
Environment
Oracle Pl/SQL, UNIX, IBM MQ client, BaNCS V4.0, IReport, Connect Direct,
Autosys R11.3
Project Title BOA Finance Data Warehouse production support and enhancement
Customer Bank of America, Charlotte, U.S
Description The FDW and the FTP application system are housed in Oracle, currently
version 9.0. The server is HP, running UNIX Tru 64. The warehouse
receives data from approximately 75-80 different application systems
covering a wide range of bank products, including loans, commitments/lines
of credit, demand and time deposits, letters of credit, credit card, safe
deposit, bonds, trading assets/liabilities, sweeps, fed funds and other
Page 3 of 7
Oracle Certified Associate
securities. Data sources include the bank’s central warehouse (The “W”),
other data marts such as PIMS and CTDM, and direct feeds from source
systems. Extracts are created from the FDW and sent to downstream
applications (Regulatory Reporting and Tax) or other value-added
processing occurs on the FDW/FTP application system.
Role Team Member
Tools PL/SQL Developer , putty, Tera data sql assistant and Nightly cycle.
Responsibilities • Analyzing the Business Requirements and System Specifications to
understand the application
• Convert the business requirements into high level language and
create solution documents with technical changes.
• As the team member , responsible for coding , application
monitoring, Bug fixing, and Enhancements.
• Also responsible for creating test cases and executing the same.
• Conduct Unit Testing to ensure the Individual Application
Component/Module is working
• Code Comparison and Upload the Code Comparison Report to
Server
• Involved in giving induction for new joiners in the project
• System Integration Testing is to ensure whether the complete
solution is working under the integrated System and Application
Component
• Code Review-Internal Code Review Process.
• Deploy IRIS, the Integrated Relationship Information System that
gives the details of the back up process, risk management and
mitigation strategies for the project
• Using IPMS, manage, implement and maintain different phases of
the software life cycle including bug fixing, maintenance and
support activities.
• FieldGlass billing and Ultimatix billing activities on month end.
Highlights  Performance improvement of different PL/SQL batches (A job
which was running more than 8 hours now taking only 5mins after
performance tuning ). Tuned the four monthly jobs which was
running in hours now runs in min.
 Delivering/Deploying the code on time
Solution
Environment
Oracle 9.2.0.3 database, UNIX
Page 4 of 7
Oracle Certified Associate
Project Title Ultimatix Service Delivery.
Description Ultimatix is an Enterprise-wide integrated information system solution and a
PORTAL that is based on industry standard products like Oracle
Applications 9i, SAP etc and custom modules together integrated as an
ERP for TCS. Integrated project management System (IPMS) which is a
part of Ultimatix project, is an innovative tool developed by Tata
Consultancy Services (TCS) to automate project management activities as
well as Integrated Quality Management System (iQMS).
Role Team member
Responsibilities Involved in development, maintenance and enhancement of the project with
dynamic business requirement. Initiated and successfully implemented
process improvement CRs. Below is the key Responsibilities handled by
me.
 Gather Business requirements and analyze the impact on
applications.
 Create High Level Solutions pertaining to the requirements and
discuss it with Customer, TCS Business Analysts and related
applications.
 Create a Detailed Design Solution for the requirements, specific to the
code level.
 Developed the code based on the requirements, conforming to TCS
Coding Standards
 Create Test cases for Unit Testing, Integrated Unit Testing and Sub-
system Testing level.
 Support System Testing, User Acceptance Test and ensure smooth
implementation of the application in production.
 Fix defects encountered in any of the testing phases.
 Ensure quality in coding and testing, conforming to Standard TCS
Protocol.
 Production Support of all issues arising in the system.
 Process Improvement of the existing system.
 Actively mentor newcomers in the team, provide technical and
functional trainings to help them understand the application in a better
manner.
 Coordinate with other teams for the timely resolution of the issues.
 Successfully execution of monthly timesheet freezing process.
Solution
Environment
Windows XP, Oracle 9.2.0.3 database, Unix
Tools PL/SQL Developer , Edit Plus , Visual SourceSafe 6.0, HTML and putty
Page 5 of 7
Oracle Certified Associate
Highlights  Got the Best team award from TCS Gems for successfully rolling
out a major CR.
 Developed timesheet freezing PL/SQL packages code .
 Automated the timesheet freezing process.
 Performance improvement of different PL/SQL batches with
considerable reduction in execution time.
 Got the GEMS appreciation for tuning the database view in such a
way to improve the record fetching time .
 Successfully handled and implemented the project with new
business requirement.
 Execute timesheet freezing process monthly.
Key Competencies & Skills
Skill Proficiency (E0 to E4)
Analytical Ability L2
Continual Learning L2
Team Skill L3
Lean Six Sigma (LSS) E1
Oracle 11g E2
Sun Solaris Distributed Server
Management - (IT IS)
E1
Oracle Developer 6i - Forms E1
Lean Six Sigma_Inactive E1
PL/SQL E3
Training / Continuing Education Summary
Program or Course Coverage Dates
Unix Korn Shell Scripting - Brainbench
Assessment - Basic
Brain bench- Unix 16-Feb-2010
Oracle Apps- Financials_General
Ledger (Oracle Apps_Financials_GL)
Instructor led session on Oracle
Apps
2-Jul 2009
Integrated Quality Management
System (iQMS) Case Study For Team
Members
Instructor lead session on IQMS 20-Nov-2008
Initial Learning Program Two months initial training provided
by TATA Consultancy Services
Limited.
Aug 2007-Sep
2007
Career Profile
Page 6 of 7
Oracle Certified Associate
Dates Organization Role
July- 2007 to till
date
TATA Consultancy
Services
Assistant Consultant
Personal Details
Date of Birth 11-April-1984
Sex Male
Nationality Indian
Marital status Married
IT Experience start date July-2007
Designation Assistant Consultant
Visa Details
Visa type Expiry Date Country/State/City
H1B 28-Nov-2016 USA / Florida / Tampa.
Page 7 of 7

More Related Content

What's hot

Satish_Rayala_Updated_v2
Satish_Rayala_Updated_v2Satish_Rayala_Updated_v2
Satish_Rayala_Updated_v2
Satish Rayala
 
NeilBrittleton Current CV
NeilBrittleton Current CVNeilBrittleton Current CV
NeilBrittleton Current CV
Neil Brittleton
 
A Software Factory Integrating Rational & WebSphere Tools
A Software Factory Integrating Rational & WebSphere ToolsA Software Factory Integrating Rational & WebSphere Tools
A Software Factory Integrating Rational & WebSphere Tools
ghodgkinson
 
Read Curriculum vitae of Shwetabh Kumar as Project Manager at Deloitte
Read Curriculum vitae of Shwetabh Kumar as Project Manager at DeloitteRead Curriculum vitae of Shwetabh Kumar as Project Manager at Deloitte
Read Curriculum vitae of Shwetabh Kumar as Project Manager at Deloitte
shwetabhkumar
 
Resume of Shwetabh Kumar, Project Manager at Deloitte
Resume of Shwetabh Kumar, Project Manager at DeloitteResume of Shwetabh Kumar, Project Manager at Deloitte
Resume of Shwetabh Kumar, Project Manager at Deloitte
shwetabhkumar
 
Oracle R12 Upgrade Lessons Learned
Oracle R12 Upgrade Lessons LearnedOracle R12 Upgrade Lessons Learned
Oracle R12 Upgrade Lessons Learned
bpellot
 
10 Tips for Successful 12.2 Upgrade
10 Tips for Successful 12.2 Upgrade10 Tips for Successful 12.2 Upgrade
10 Tips for Successful 12.2 Upgrade
OAUGNJ
 
Supriya_Bhide
Supriya_BhideSupriya_Bhide
Supriya_Bhide
Supriya Pathak
 
RamPravesh_Kumar
RamPravesh_KumarRamPravesh_Kumar
RamPravesh_Kumar
Ram pravesh kumar
 
Resume
ResumeResume
Resume
rajeswari p
 
AvinashBhat_Resume
AvinashBhat_ResumeAvinashBhat_Resume
AvinashBhat_Resume
Avinash Bhat
 
Sr. QA Eng. with 8.2+ Yrs of Exp.in ERP_Manual_ Functional _System_Integrat...
Sr. QA Eng. with  8.2+  Yrs of Exp.in ERP_Manual_ Functional _System_Integrat...Sr. QA Eng. with  8.2+  Yrs of Exp.in ERP_Manual_ Functional _System_Integrat...
Sr. QA Eng. with 8.2+ Yrs of Exp.in ERP_Manual_ Functional _System_Integrat...
vaibhav pawar
 
Madhu_Resume
Madhu_ResumeMadhu_Resume
Madhu_Resume
madhu latha pulimi
 
Working effectively with primavera support
Working effectively with primavera supportWorking effectively with primavera support
Working effectively with primavera support
p6academy
 
Rajasekkar
RajasekkarRajasekkar
WSI32 - IBM WebSphere Performance Fundamentals
WSI32 - IBM WebSphere Performance FundamentalsWSI32 - IBM WebSphere Performance Fundamentals
WSI32 - IBM WebSphere Performance Fundamentals
Hendrik van Run
 
Bharat+anjna test+engineer updated
Bharat+anjna test+engineer updatedBharat+anjna test+engineer updated
Bharat+anjna test+engineer updated
Capgemini india pvt ltd
 
IT Application Decommissioning - Application Retirement Services
IT Application Decommissioning - Application Retirement ServicesIT Application Decommissioning - Application Retirement Services
IT Application Decommissioning - Application Retirement Services
AvenDATA
 
Cooper, Mark Resume.Final.8.2.16
Cooper, Mark Resume.Final.8.2.16Cooper, Mark Resume.Final.8.2.16
Cooper, Mark Resume.Final.8.2.16
Mark Cooper
 
Ganesh_Resume_2016
Ganesh_Resume_2016Ganesh_Resume_2016
Ganesh_Resume_2016
Ganesh Babu Gullapudi
 

What's hot (20)

Satish_Rayala_Updated_v2
Satish_Rayala_Updated_v2Satish_Rayala_Updated_v2
Satish_Rayala_Updated_v2
 
NeilBrittleton Current CV
NeilBrittleton Current CVNeilBrittleton Current CV
NeilBrittleton Current CV
 
A Software Factory Integrating Rational & WebSphere Tools
A Software Factory Integrating Rational & WebSphere ToolsA Software Factory Integrating Rational & WebSphere Tools
A Software Factory Integrating Rational & WebSphere Tools
 
Read Curriculum vitae of Shwetabh Kumar as Project Manager at Deloitte
Read Curriculum vitae of Shwetabh Kumar as Project Manager at DeloitteRead Curriculum vitae of Shwetabh Kumar as Project Manager at Deloitte
Read Curriculum vitae of Shwetabh Kumar as Project Manager at Deloitte
 
Resume of Shwetabh Kumar, Project Manager at Deloitte
Resume of Shwetabh Kumar, Project Manager at DeloitteResume of Shwetabh Kumar, Project Manager at Deloitte
Resume of Shwetabh Kumar, Project Manager at Deloitte
 
Oracle R12 Upgrade Lessons Learned
Oracle R12 Upgrade Lessons LearnedOracle R12 Upgrade Lessons Learned
Oracle R12 Upgrade Lessons Learned
 
10 Tips for Successful 12.2 Upgrade
10 Tips for Successful 12.2 Upgrade10 Tips for Successful 12.2 Upgrade
10 Tips for Successful 12.2 Upgrade
 
Supriya_Bhide
Supriya_BhideSupriya_Bhide
Supriya_Bhide
 
RamPravesh_Kumar
RamPravesh_KumarRamPravesh_Kumar
RamPravesh_Kumar
 
Resume
ResumeResume
Resume
 
AvinashBhat_Resume
AvinashBhat_ResumeAvinashBhat_Resume
AvinashBhat_Resume
 
Sr. QA Eng. with 8.2+ Yrs of Exp.in ERP_Manual_ Functional _System_Integrat...
Sr. QA Eng. with  8.2+  Yrs of Exp.in ERP_Manual_ Functional _System_Integrat...Sr. QA Eng. with  8.2+  Yrs of Exp.in ERP_Manual_ Functional _System_Integrat...
Sr. QA Eng. with 8.2+ Yrs of Exp.in ERP_Manual_ Functional _System_Integrat...
 
Madhu_Resume
Madhu_ResumeMadhu_Resume
Madhu_Resume
 
Working effectively with primavera support
Working effectively with primavera supportWorking effectively with primavera support
Working effectively with primavera support
 
Rajasekkar
RajasekkarRajasekkar
Rajasekkar
 
WSI32 - IBM WebSphere Performance Fundamentals
WSI32 - IBM WebSphere Performance FundamentalsWSI32 - IBM WebSphere Performance Fundamentals
WSI32 - IBM WebSphere Performance Fundamentals
 
Bharat+anjna test+engineer updated
Bharat+anjna test+engineer updatedBharat+anjna test+engineer updated
Bharat+anjna test+engineer updated
 
IT Application Decommissioning - Application Retirement Services
IT Application Decommissioning - Application Retirement ServicesIT Application Decommissioning - Application Retirement Services
IT Application Decommissioning - Application Retirement Services
 
Cooper, Mark Resume.Final.8.2.16
Cooper, Mark Resume.Final.8.2.16Cooper, Mark Resume.Final.8.2.16
Cooper, Mark Resume.Final.8.2.16
 
Ganesh_Resume_2016
Ganesh_Resume_2016Ganesh_Resume_2016
Ganesh_Resume_2016
 

Viewers also liked

CV - Sasikumar M
CV - Sasikumar MCV - Sasikumar M
CV - Sasikumar M
Sasikumar Madakkannu
 
Kenneth Glover DTC - Ops - Settlements - reconciliations
Kenneth Glover DTC - Ops - Settlements - reconciliationsKenneth Glover DTC - Ops - Settlements - reconciliations
Kenneth Glover DTC - Ops - Settlements - reconciliations
Kenneth Glover
 
ADITYA PARMAR Resume
ADITYA PARMAR ResumeADITYA PARMAR Resume
ADITYA PARMAR Resume
Aditya Parmar
 
Sachin Gangadhar Emmiganur
Sachin Gangadhar EmmiganurSachin Gangadhar Emmiganur
Sachin Gangadhar Emmiganur
Sachin Emmiganur
 
sundararajan - Design
sundararajan - Designsundararajan - Design
sundararajan - Design
Sundar Rajan
 
Paul Casey CV
Paul Casey CVPaul Casey CV
Paul Casey CV
Paul Casey
 
IT Convergence
IT ConvergenceIT Convergence
IT Convergence
Claudio Anfossi
 
Exchange Operations
Exchange OperationsExchange Operations
Exchange Operations
Anurag Singh
 
Anavaratham Resume_updated
Anavaratham Resume_updatedAnavaratham Resume_updated
Anavaratham Resume_updated
anavaratham arunachalam
 
Eltelevisor
EltelevisorEltelevisor
생중계바카라//FUN7。ASIA//모바일바카라 사이트
생중계바카라//FUN7。ASIA//모바일바카라 사이트생중계바카라//FUN7。ASIA//모바일바카라 사이트
생중계바카라//FUN7。ASIA//모바일바카라 사이트
ghjdfsg
 
Certificate of analysis jahoon
Certificate of analysis jahoonCertificate of analysis jahoon
Certificate of analysis jahoon
jahoonkr
 
Chest 2009-detterbeck-260-71 (2)
Chest 2009-detterbeck-260-71 (2)Chest 2009-detterbeck-260-71 (2)
Chest 2009-detterbeck-260-71 (2)
Jessie Martinez
 
Who is god
Who is godWho is god
Who is god
Colin Cidence
 
스타카지노 ''SX797.COM'' 실전마작
스타카지노 ''SX797.COM'' 실전마작스타카지노 ''SX797.COM'' 실전마작
스타카지노 ''SX797.COM'' 실전마작
gdjfksd
 
모바일바카라¸¸¸FUN7。ASIA˛˛˛인터넷바카라 사이트
모바일바카라¸¸¸FUN7。ASIA˛˛˛인터넷바카라 사이트모바일바카라¸¸¸FUN7。ASIA˛˛˛인터넷바카라 사이트
모바일바카라¸¸¸FUN7。ASIA˛˛˛인터넷바카라 사이트
gdjfksd
 
Amplexor Customer Experience Management seminar Technical overview Euroclear ...
Amplexor Customer Experience Management seminar Technical overview Euroclear ...Amplexor Customer Experience Management seminar Technical overview Euroclear ...
Amplexor Customer Experience Management seminar Technical overview Euroclear ...
Amplexor
 

Viewers also liked (17)

CV - Sasikumar M
CV - Sasikumar MCV - Sasikumar M
CV - Sasikumar M
 
Kenneth Glover DTC - Ops - Settlements - reconciliations
Kenneth Glover DTC - Ops - Settlements - reconciliationsKenneth Glover DTC - Ops - Settlements - reconciliations
Kenneth Glover DTC - Ops - Settlements - reconciliations
 
ADITYA PARMAR Resume
ADITYA PARMAR ResumeADITYA PARMAR Resume
ADITYA PARMAR Resume
 
Sachin Gangadhar Emmiganur
Sachin Gangadhar EmmiganurSachin Gangadhar Emmiganur
Sachin Gangadhar Emmiganur
 
sundararajan - Design
sundararajan - Designsundararajan - Design
sundararajan - Design
 
Paul Casey CV
Paul Casey CVPaul Casey CV
Paul Casey CV
 
IT Convergence
IT ConvergenceIT Convergence
IT Convergence
 
Exchange Operations
Exchange OperationsExchange Operations
Exchange Operations
 
Anavaratham Resume_updated
Anavaratham Resume_updatedAnavaratham Resume_updated
Anavaratham Resume_updated
 
Eltelevisor
EltelevisorEltelevisor
Eltelevisor
 
생중계바카라//FUN7。ASIA//모바일바카라 사이트
생중계바카라//FUN7。ASIA//모바일바카라 사이트생중계바카라//FUN7。ASIA//모바일바카라 사이트
생중계바카라//FUN7。ASIA//모바일바카라 사이트
 
Certificate of analysis jahoon
Certificate of analysis jahoonCertificate of analysis jahoon
Certificate of analysis jahoon
 
Chest 2009-detterbeck-260-71 (2)
Chest 2009-detterbeck-260-71 (2)Chest 2009-detterbeck-260-71 (2)
Chest 2009-detterbeck-260-71 (2)
 
Who is god
Who is godWho is god
Who is god
 
스타카지노 ''SX797.COM'' 실전마작
스타카지노 ''SX797.COM'' 실전마작스타카지노 ''SX797.COM'' 실전마작
스타카지노 ''SX797.COM'' 실전마작
 
모바일바카라¸¸¸FUN7。ASIA˛˛˛인터넷바카라 사이트
모바일바카라¸¸¸FUN7。ASIA˛˛˛인터넷바카라 사이트모바일바카라¸¸¸FUN7。ASIA˛˛˛인터넷바카라 사이트
모바일바카라¸¸¸FUN7。ASIA˛˛˛인터넷바카라 사이트
 
Amplexor Customer Experience Management seminar Technical overview Euroclear ...
Amplexor Customer Experience Management seminar Technical overview Euroclear ...Amplexor Customer Experience Management seminar Technical overview Euroclear ...
Amplexor Customer Experience Management seminar Technical overview Euroclear ...
 

Similar to Arunprakash Alagesan

GouthamLaveti
GouthamLavetiGouthamLaveti
GouthamLaveti
Goutham Laveti
 
Pooja 4yr exp
Pooja 4yr expPooja 4yr exp
Pooja 4yr exp
POOJA BANSAL
 
Resume
ResumeResume
Resume
Arun Kumar
 
Resume_Sep_16
Resume_Sep_16Resume_Sep_16
Resume_Sep_16
Uma Annamalai
 
Mayank-Tamrakar
Mayank-TamrakarMayank-Tamrakar
Mayank-Tamrakar
Mayank Tamrakar
 
BAKKIYA_4YR
BAKKIYA_4YRBAKKIYA_4YR
Verizon
VerizonVerizon
Verizon
Stretchdata
 
Resume
ResumeResume
Resume
rahul kumar
 
Renuka Devi with 4+ yr Exp
Renuka Devi with 4+ yr ExpRenuka Devi with 4+ yr Exp
Renuka Devi with 4+ yr Exp
Renuka Devi
 
Delia_J_Micu_resume_arch_Jan_2015
Delia_J_Micu_resume_arch_Jan_2015Delia_J_Micu_resume_arch_Jan_2015
Delia_J_Micu_resume_arch_Jan_2015
Delia J. Micu
 
Renuka Devi with 4+ yr Exp
Renuka Devi with 4+ yr ExpRenuka Devi with 4+ yr Exp
Renuka Devi with 4+ yr Exp
Renuka Devi
 
Ravi_Nelluri_QA
Ravi_Nelluri_QARavi_Nelluri_QA
Ravi_Nelluri_QA
nelluriravi
 
JeanDStPaul Resume LinkedIn
JeanDStPaul Resume LinkedInJeanDStPaul Resume LinkedIn
JeanDStPaul Resume LinkedIn
Jean Saint Paul
 
Sachin Kumar Resume
Sachin Kumar ResumeSachin Kumar Resume
Sachin Kumar Resume
SACHIN KUMAR
 
Yogesh Keshaowar_Profile
Yogesh Keshaowar_ProfileYogesh Keshaowar_Profile
Yogesh Keshaowar_Profile
Yogesh Keshaowar
 
CV_Mudit IBM MCA 10+ years MSBI, SQL, .NET
CV_Mudit IBM MCA 10+ years MSBI, SQL, .NETCV_Mudit IBM MCA 10+ years MSBI, SQL, .NET
CV_Mudit IBM MCA 10+ years MSBI, SQL, .NET
Mudit Saxena
 
Bill Rin
Bill RinBill Rin
Bill Rin
billringel
 
Bill Ringel Resume
Bill Ringel ResumeBill Ringel Resume
Bill Ringel Resume
Stretchdata
 
.Net 7.1 years Vijay_Thakare
.Net 7.1 years Vijay_Thakare.Net 7.1 years Vijay_Thakare
.Net 7.1 years Vijay_Thakare
Vijay Thakare
 
Sunny_Resume
Sunny_ResumeSunny_Resume
Sunny_Resume
Sunny Gupta
 

Similar to Arunprakash Alagesan (20)

GouthamLaveti
GouthamLavetiGouthamLaveti
GouthamLaveti
 
Pooja 4yr exp
Pooja 4yr expPooja 4yr exp
Pooja 4yr exp
 
Resume
ResumeResume
Resume
 
Resume_Sep_16
Resume_Sep_16Resume_Sep_16
Resume_Sep_16
 
Mayank-Tamrakar
Mayank-TamrakarMayank-Tamrakar
Mayank-Tamrakar
 
BAKKIYA_4YR
BAKKIYA_4YRBAKKIYA_4YR
BAKKIYA_4YR
 
Verizon
VerizonVerizon
Verizon
 
Resume
ResumeResume
Resume
 
Renuka Devi with 4+ yr Exp
Renuka Devi with 4+ yr ExpRenuka Devi with 4+ yr Exp
Renuka Devi with 4+ yr Exp
 
Delia_J_Micu_resume_arch_Jan_2015
Delia_J_Micu_resume_arch_Jan_2015Delia_J_Micu_resume_arch_Jan_2015
Delia_J_Micu_resume_arch_Jan_2015
 
Renuka Devi with 4+ yr Exp
Renuka Devi with 4+ yr ExpRenuka Devi with 4+ yr Exp
Renuka Devi with 4+ yr Exp
 
Ravi_Nelluri_QA
Ravi_Nelluri_QARavi_Nelluri_QA
Ravi_Nelluri_QA
 
JeanDStPaul Resume LinkedIn
JeanDStPaul Resume LinkedInJeanDStPaul Resume LinkedIn
JeanDStPaul Resume LinkedIn
 
Sachin Kumar Resume
Sachin Kumar ResumeSachin Kumar Resume
Sachin Kumar Resume
 
Yogesh Keshaowar_Profile
Yogesh Keshaowar_ProfileYogesh Keshaowar_Profile
Yogesh Keshaowar_Profile
 
CV_Mudit IBM MCA 10+ years MSBI, SQL, .NET
CV_Mudit IBM MCA 10+ years MSBI, SQL, .NETCV_Mudit IBM MCA 10+ years MSBI, SQL, .NET
CV_Mudit IBM MCA 10+ years MSBI, SQL, .NET
 
Bill Rin
Bill RinBill Rin
Bill Rin
 
Bill Ringel Resume
Bill Ringel ResumeBill Ringel Resume
Bill Ringel Resume
 
.Net 7.1 years Vijay_Thakare
.Net 7.1 years Vijay_Thakare.Net 7.1 years Vijay_Thakare
.Net 7.1 years Vijay_Thakare
 
Sunny_Resume
Sunny_ResumeSunny_Resume
Sunny_Resume
 

Arunprakash Alagesan

  • 1. Oracle Certified Associate Arunprakash Alagesan Email: arun.prakash.alagesan@gmail.com, Phone: +1 8134201694 Experience Summary • 9 years of IT experience with TATA Consultancy Services Ltd working on application development & support project for the client CITI Bank. • Experience with all the phases of software development lifecycle (SDLC) including requirements gathering, design, development, testing & deployment • Sound coding knowledge of Oracle 11g coding with performance tuning skills. • Hands on experiance with Oracle SQL, PL/SQL coding (Packages, procedures, functions, triggers, cursors,indexes,tables , views, tuning, ....etc) • Good problem solving skills and ability to work independently • Good communication skills • Currently working with Citi bank client for the corporate actions in the BaNCS application development and maintenance project. • Previously I worked with Bank of America client for the Finance Data warehouse application development and production support project. • Also I worked with Tata consultancy services internal application named Integrated Project Management system where associates time sheet entry captured for billing and financial process. • Sound knowledge of quality management process . • Got the Best team Award from TCS GEMS for delivering the Normalisation solution for the timesheet with no defects. • I have done lots of performance tuning in the FDW project . I have received an award for tuning the 8hours long running job from the Bank of America client. The job runs less than 5 minutes after tuning which saves lots of time and resources. The performance tuning was performed in the PL/SQL code. • I have received the Technical Excellence Award from TCS GEMS for the monthly jobs tuning in FDW. • I have automated few failing AUTOSYS jobs which requires user’s manual user intervention. • I develop and debug Unix shell scripts. • I worked in NDM setup between two nodes in the Unix servers. Also i can make Unix scripts to send/receive the files between two nodes via NDM. Technology Below is a list of important hardware, software products, tools and methods that I have worked with. Page 1 of 7 Operating Systems Software Products Tools Windows XP, Windows 7 Oracle PL/SQL, SQL Developer, HTML, C+ + ,WinSCP, Unix ,MQs, Jasper reports ,Autosys scheduler configuration, Unix shell scripting, BaNCS product for corporate action, Websphere 8.0, Nightly Cycle PLSQL developer 7.0, SQL Developer 2.1.1.64, Microsoft Visual SourceSafe, EditPlus, Putty ,IBM MQ client 7.0, Nightly cycle, Tera data, Autosys R11, iReport 3.6, BaNCS V4.0, MS Office, Connect direct
  • 2. Oracle Certified Associate Certifications Professional Society / Certification Member Since / Date Certified Oracle PL/SQL Developer certified Associate October-2009 SQL (ANSI) Fundamentals - Assessment - E2 February-2009 ORACLE PL/SQL – TCS Assessment-E2 February-2011 Qualifications Degree / PG Name of University Specialization Place of University Year of passing Bachelor of Engineering Anna University Chennai (Madras Institute of Technology, Chennai) Electronics And Instrumentation Engineering Chennai MAY-2007 Diploma State board of Technical education and Training Computer Technology Chennai APRIL-2004 Project Thesis Project Title BaNCS Application development and support Customer CITICORP NORTH AMERICA, INC Description BaNCS replaces Stock and Bond Security Systems (SBSS) and CMO as the main Income processing system for US Asset Servicing within the Global Transaction Services (GTS) business. BaNCS does income processing for CMO, MBS, Agency, TIPS, RBI and Dividends for Income and Tax team. BaNCS is a product of Tata Consultancy Services and CITI bank requires it for corporate actions. We have PROD/UAT(QA)/SIT environments which require the BaNCS component deployment and ensuring the environment availability to our clients. BaNCS system connected to CAPRI, CCF, security master, DTC/FED/GCA, CAIN, GIW, MQs, Page 2 of 7
  • 3. Oracle Certified Associate NRA, Tax minder, EDS, CSD, DUBLIN, EERS, ASTRA and SWIFT gateway. BaNCS receives/sends the SWIFT messages to the various applications for the event of corporate action during the intraday and end of day cycle. Role Project leader Tools BaNCS V4.0, AUTOSYS R11.3, Oracle PL/SQL Developer , Unix Putty, iReport 3.6 ,WinSCP and IBM MQ client 7.0, NDM, Websphere 8.0 Responsibilities • BaNCS component development and deployment in the various instance like SIT/UAT/DEV. • Writing the PL/SQL , Unix scripting codes for the new requirement. • Creating jobs in Autosys and scheduling as per the requirement • Monitoring and fixing the failure jobs in Autosys • Modifying the existing code for the defects raised by the application user. • Loading the user provided feeds in the environment for testing. • Providing the requested event feed for the various application. • Analyzing the Business Requirements and System Specifications to understand the application • As a team member responsible for Application monitoring, Bug fixing, and Enhancements. • Conduct Unit Testing to ensure the Individual Application Component/Module is working • Involved in giving induction for new joiners in the project • System Integration Testing is to ensure whether the complete solution is working under the integrated System and Application Component • Code Review-Internal Code Review Process and mitigation strategies for the project. • Using IPMS, manage, implement and maintain different phases of the software life cycle including bug fixing, maintenance and support activities. • Fieldglass onboarding and billing activities. Highlights  Performance improvement of one of the long running BaNCS job. The BaNCS job stuck after 3hours of long running. I have tuned the SQL query and after tuning the same job completes few minutes.  Delivering the defect free code to our client Solution Environment Oracle Pl/SQL, UNIX, IBM MQ client, BaNCS V4.0, IReport, Connect Direct, Autosys R11.3 Project Title BOA Finance Data Warehouse production support and enhancement Customer Bank of America, Charlotte, U.S Description The FDW and the FTP application system are housed in Oracle, currently version 9.0. The server is HP, running UNIX Tru 64. The warehouse receives data from approximately 75-80 different application systems covering a wide range of bank products, including loans, commitments/lines of credit, demand and time deposits, letters of credit, credit card, safe deposit, bonds, trading assets/liabilities, sweeps, fed funds and other Page 3 of 7
  • 4. Oracle Certified Associate securities. Data sources include the bank’s central warehouse (The “W”), other data marts such as PIMS and CTDM, and direct feeds from source systems. Extracts are created from the FDW and sent to downstream applications (Regulatory Reporting and Tax) or other value-added processing occurs on the FDW/FTP application system. Role Team Member Tools PL/SQL Developer , putty, Tera data sql assistant and Nightly cycle. Responsibilities • Analyzing the Business Requirements and System Specifications to understand the application • Convert the business requirements into high level language and create solution documents with technical changes. • As the team member , responsible for coding , application monitoring, Bug fixing, and Enhancements. • Also responsible for creating test cases and executing the same. • Conduct Unit Testing to ensure the Individual Application Component/Module is working • Code Comparison and Upload the Code Comparison Report to Server • Involved in giving induction for new joiners in the project • System Integration Testing is to ensure whether the complete solution is working under the integrated System and Application Component • Code Review-Internal Code Review Process. • Deploy IRIS, the Integrated Relationship Information System that gives the details of the back up process, risk management and mitigation strategies for the project • Using IPMS, manage, implement and maintain different phases of the software life cycle including bug fixing, maintenance and support activities. • FieldGlass billing and Ultimatix billing activities on month end. Highlights  Performance improvement of different PL/SQL batches (A job which was running more than 8 hours now taking only 5mins after performance tuning ). Tuned the four monthly jobs which was running in hours now runs in min.  Delivering/Deploying the code on time Solution Environment Oracle 9.2.0.3 database, UNIX Page 4 of 7
  • 5. Oracle Certified Associate Project Title Ultimatix Service Delivery. Description Ultimatix is an Enterprise-wide integrated information system solution and a PORTAL that is based on industry standard products like Oracle Applications 9i, SAP etc and custom modules together integrated as an ERP for TCS. Integrated project management System (IPMS) which is a part of Ultimatix project, is an innovative tool developed by Tata Consultancy Services (TCS) to automate project management activities as well as Integrated Quality Management System (iQMS). Role Team member Responsibilities Involved in development, maintenance and enhancement of the project with dynamic business requirement. Initiated and successfully implemented process improvement CRs. Below is the key Responsibilities handled by me.  Gather Business requirements and analyze the impact on applications.  Create High Level Solutions pertaining to the requirements and discuss it with Customer, TCS Business Analysts and related applications.  Create a Detailed Design Solution for the requirements, specific to the code level.  Developed the code based on the requirements, conforming to TCS Coding Standards  Create Test cases for Unit Testing, Integrated Unit Testing and Sub- system Testing level.  Support System Testing, User Acceptance Test and ensure smooth implementation of the application in production.  Fix defects encountered in any of the testing phases.  Ensure quality in coding and testing, conforming to Standard TCS Protocol.  Production Support of all issues arising in the system.  Process Improvement of the existing system.  Actively mentor newcomers in the team, provide technical and functional trainings to help them understand the application in a better manner.  Coordinate with other teams for the timely resolution of the issues.  Successfully execution of monthly timesheet freezing process. Solution Environment Windows XP, Oracle 9.2.0.3 database, Unix Tools PL/SQL Developer , Edit Plus , Visual SourceSafe 6.0, HTML and putty Page 5 of 7
  • 6. Oracle Certified Associate Highlights  Got the Best team award from TCS Gems for successfully rolling out a major CR.  Developed timesheet freezing PL/SQL packages code .  Automated the timesheet freezing process.  Performance improvement of different PL/SQL batches with considerable reduction in execution time.  Got the GEMS appreciation for tuning the database view in such a way to improve the record fetching time .  Successfully handled and implemented the project with new business requirement.  Execute timesheet freezing process monthly. Key Competencies & Skills Skill Proficiency (E0 to E4) Analytical Ability L2 Continual Learning L2 Team Skill L3 Lean Six Sigma (LSS) E1 Oracle 11g E2 Sun Solaris Distributed Server Management - (IT IS) E1 Oracle Developer 6i - Forms E1 Lean Six Sigma_Inactive E1 PL/SQL E3 Training / Continuing Education Summary Program or Course Coverage Dates Unix Korn Shell Scripting - Brainbench Assessment - Basic Brain bench- Unix 16-Feb-2010 Oracle Apps- Financials_General Ledger (Oracle Apps_Financials_GL) Instructor led session on Oracle Apps 2-Jul 2009 Integrated Quality Management System (iQMS) Case Study For Team Members Instructor lead session on IQMS 20-Nov-2008 Initial Learning Program Two months initial training provided by TATA Consultancy Services Limited. Aug 2007-Sep 2007 Career Profile Page 6 of 7
  • 7. Oracle Certified Associate Dates Organization Role July- 2007 to till date TATA Consultancy Services Assistant Consultant Personal Details Date of Birth 11-April-1984 Sex Male Nationality Indian Marital status Married IT Experience start date July-2007 Designation Assistant Consultant Visa Details Visa type Expiry Date Country/State/City H1B 28-Nov-2016 USA / Florida / Tampa. Page 7 of 7
  翻译: