Vimal Arora

Technical Analyst

Contact

+91-916*******

adpqfm@r.postjobfree.com

linkedin.com/in/vimalarora/

Skills

Oracle 10g/11c/12c

SQL / PLSQL

Oracle Forms / Reports

Unix/Shell Scripting

Python

Flexcube Retail

PRIME

MySQL / Microsoft SQL Server

MS Access

VBA programming

Oracle Technical Analyst with over 11.5 years of successful experience in analysis, designing and implementing solution using oracle database SQL/PLSQL scripts, performance tuning features as query optimizer, execution plan, indexes and other related tools. Recognized consistently for performance excellence and contributions to success during the career while working across different teams and client locations. Being a technical enthusiast, currently learning AWS cloud platform which would provide better career opportunities and also have worked on individual projects in which explored other databases, scripting and interpreted languages. Career Timeline

2019 Current 201*-**-****-**

TSYS Barclays Zensar Tech Capgemini OFSS

Work History

Sep’19

Current

Business Technical Services Analyst

TSYS, Global Payments Company, Noida

Working as techno functional analyst for PRIME, an issuing and acquiring payment solution.

Managing client's requirements from analysis of functional and technical feasibility of solution to finalizing scope and estimating efforts of work.

Oversee daily operations with support team to ensure high level of productivity and increased customer satisfaction by resolving product issues.

Used oracle advanced features such as Bulk Collect, GTT, Records, Collections (nested tables and arrays), query optimization etc. in different projects across clients. Apr’18 –

Aug’19

Oracle Analyst

Barclays Global Service Center, Pune

Worked as oracle analyst for in house investment banking product MOTIF, a central sub ledger system for loading, accounting and reporting feed files from different sources.

Developed solutions using different oracle features Procedures/Functions/Packages, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Performance tuning with help of Explain Plan, Hints, Indexes. Writing shell scripts for daily automation and reporting tasks.

As a Scrum Master, managed daily standup, taking project updates, helping to remove roadblocks in tasks facing during sprints to achieve closure.

Feb’16 –

Mar’18

Senior Software Engineer

Zensar Technologies, Pune

Worked as oracle developer for in house vehicle leasing product of WesBank used for maintaining customer

applications, loan schedules etc. and interacted closely with other development teams for 6 months in South Africa to deliver high quality solutions.

Developed and customized Oracle Forms/Reports across different modules and writing scripts using advance oracle concepts like collections, analytical functions etc., along with fixing bugs in core module as reported by business users. Sep’14 –

Jan’16

Consultant

Capgemini, Pune

Worked as oracle developer for Barclays Capital's solution used for data integration and manipulation.

Developed and customized oracle packages using advance features in PLSQL that enhanced performance. Involved in query optimization and writing Unix shell scripts based on different needs of the project.

Lead a small team in the project while collaborating with other members during code development and bug fixing exercises. Mar’10 –

Aug’14

Associate Technical Analyst

Oracle Financial Services Software Ltd., Pune

Worked as developer/support analyst for FLEXCUBE banking product in its Retail and UBS (v. 11) version across different modules like CASA, Term Deposit, Online, GL and EOD.

Managed support activity across different modules of product in the maintenance team at bank's data center for 2 years Canara Bank and Skye Bank, Nigeria – handled client’s maintenance requests, bug fixes, clarifications, EOD support tasks, high severity incidents.

Technical and functional recommendations provided based on first level analysis and collaborated with different teams and client for activity closure.

Developed and fixed packages using oracle advanced concepts, analyze explain plan and ASH/AWR reports and writing SQL scripts for data extraction/manipulation.

Education

Graduated in

2009, 74.3%

Bachelor of Technology: Computer Science

United College of Engineering & Research, UPTU Allahabad Passed in

2004, 74.6%

Higher Secondary (XII): Science

Mary Lucas School & College, ISC Board Allahabad Passed in

2002, 73.6%

Secondary (X): Science

Mary Lucas School & College, ICSE Board Allahabad

.

Contact this candidate