Quality Assurance Project
Resume:
RAVI KUMAR NARALA
Summary
. Around * years of experience in Database Development with proficient in
design, develop and maintenance of database applications and Database
Design with an exposure to various platforms and software systems.
. Excellent experience in database development using Database Technologies
(SQL, PL/SQL, T-SQL).
. Certified Sybase Developer Professional (Version 15) from Sybase
. Certified Oracle Certified Associate (OCA) from Oracle
. Extensively worked on Sybase, Oracle and MS-SQL.
. Good experience in using Oracle 10g & 9i, Sybase, MS Access, SQL Server
databases.
. Good experience on Performance and Tuning (P&T) across databases Sybase,
Oracle, SQL Server
. Experience working with Autosys and Auto stat tool
. Experience in writing Unix Shell scripts
. Exposure to Oracle Warehouse Builder (OWB)
. Experience working with Hyperion consolidation tool
. Experience working with HTML, JavaScript
. Expertise working in SQL *Plus, PL/SQL Developer, Embarcadero DB Artisan,
Embarcadero RapidSQL, SQL Advantage
. Expertise in gathering Requirement analysis
. Good Experience in preparing Functional and Technical Specifications
. Client interfacing and Implementation support.
. Effectively debugging the code
. Expertise in resolving the production issues
. Good Experience in production support
. Attended External and Internal trainings on Sybase, Oracle and Unix
. Attended Hyperion training from Hyperion
. Good team player with excellent communication, written and presentation
skills.
. Got Certificate of Excellence from SOCIETE GENERALE
. Gold medalist in College during MCA Academic Course
. Conducted internal trainings on Sybase and Oracle
. Worked in different domain areas like Insurance, Investment Banking and
Managerial Information Systems(MIS)
SKILL SET
Programming Languages SQL, PL/SQL, T-SQL
Operating Systems UNIX, Windows (2000, XP) and DOS
Databases Sybase, ORACLE 10g, 9i, MS-Access, SQL Server
Source Control SVN, VSS, PVCS
Development Environment SQL *Plus, PL/SQL Developer, Embarcadero DB
Artisan, RapidSQL, SQL Advantage, SqlDbx
Web Technology HTML
Application Packages PL/SQL Developer, Embarcadero DB Artisan,
RapidSQL, MS Visio
Office Software MS Word, Excel, PowerPoint
Projects
Project: Disability Claim Management System( DCMS)
Aug 2009 - till date
Client: Prudential, NJ
Role: Application Developer
DCMS is a web based application, where users can enter the details of
the disability for the period they have taken the leave. Depending on the
rules set in the Rules engine for the clients, the claim can be evaluated
and the status can be shown to the user.
This system is used to enter all the details for the particular
disability including, pre and post submission of leave, medical
certification from Physician and employer or supervisor approval. This
System also has reports that can be viewed by the client and some reports
can be viewed by DCMs.
Responsibilities:
. Involved and Responsible in elicitation of requirements from client
. Prepared Conceptual, Functional, Technical and detailed design
documents
. Responsible for gathering all project related information
. Working as development DBA to take back up and restore back up and
user permissions
. Created tables and indexes
. Developed complex and critical stored procedures, views, triggers
. Worked on performance tuning of procedures.
. Used the following technologies to implement this project:
Sybase, Database Design, UNIX and Autosys
. Used PL/SQL to get data from Oracle and BCP into Sybase database
. Responsible for Code Review and Quality Assurance of Development
. Performed Unit testing on different modules
. Issue Resolution and bug fixing
. Responsible for post-implementation, enhancement and maintenance of
the application
. Working on production support
. Worked on Shell scripting as well
. Responsible for integration testing
. Appreciations from counter part
Project: FinOps Reporting Application
Apr 2008 - Jul 2009
Client: SOCIETE GENERALE, NYC
Role: Senior Developer
FinOps Reporting application is used by SG Americas for reporting purpose.
This involves multiple reports like ALDOP, Security Lending and Borrowing,
Security Haircut Calculations, Repos and Reverse Repos, Customer cash,
FTR/FTD and Regulatory reporting (i.e. 15c3-1, 15c3-3 and Focus reports).
FinOps Application takes data from different source systems will
consolidate the data for this application and will run the application for
the SG Americas for their reporting purpose.
This application also provides data to other source systems.
Responsibilities:
. Involved and Responsible in elicitation of requirements from client
. Designed database modeling with Erwin tool
. Prepared Conceptual, Functional, Technical and detailed design documents
. Responsible for allocation of task to team members
. Responsible for gathering all project related information
. Created tables and indexes
. Developed complex and critical stored procedures, views, triggers
. Worked on performance tuning of procedures. Brought down the response
time from 15 minutes to 30 seconds by fine tuning the procedures
. Used the following technologies to implement this project:
Sybase, Database Design, UNIX and Autosys
. Used PL/SQL to get data from Oracle and BCP into Sybase database
. Worked as development DBA to take backup and restore back up and user
permissions
. FinOps Reporting Application is in Windows 2003 server
. Responsible for Code Review and Quality Assurance of Development
. Performed Unit testing on different modules
. Issue Resolution and bug fixing
. Responsible for post-implementation, enhancement and maintenance of the
application
. Worked on production support
. Worked on Shell scripting as well
. Responsible for integration testing
. Appreciations from counter part
. Received certificate of excellence for performing the excellent work
Environment: Windows NT /XP, UNIX, Shell Scripting, Autosys, HTML, ASP,
Oracle 10g, PL/SQL, Sybase, SQL Server
Project: Accounting Consistency Reconciliation Reporting (ACRT) Application
Apr 2009 - Jul 2009
Client: SOCIETE GENERALE, NYC
Role: Senior Developer
ACRT is used by SG Americas for reconciliation purpose.
This involves multiple reconciliations between GL and Inventory, DEVL rules
and Pyramid Rules and Inventory and Risq. Data will come from different
systems like GL, SML, STO, and Collecte. ACRT takes this data and processes
this and shows to the users for reconciliation. Once the data is reconciled
it will be submitted to SGAS reporting
Responsibilities:
. Developed the Automation of process
. Responsible for the application development
. Prepared Conceptual, Functional, Technical and detailed design documents
. Created tables and indexes
. Developed critical stored procedures, views, triggers
. Worked on performance tuning of procedures
. Using the following technologies to implement this project:
Sybase, Database Design, UNIX and Autosys
. ACRT Application is in Windows 2003 server
. Responsible for Code Review and Quality Assurance of Development
. Performed Unit testing
. Responsible for writing Shell scripts in Unix
. Responsible for Autosys Jobs using JIL
. Issue Resolution and bug fixing
. Involved in integration testing
. Responsible for Production support
Environment: Windows XP, UNIX, Shell Scripting, Autosys, HTML, ASP,
Sybase, SQL Server.
Project: Human Resource Management Systems (HRMS)
Jul 2007 - Apr 2008
Client: UBS, NYC
Role: Senior Developer
HRMS is one of the modules for the UBS to maintain the employee/ associate
data information for UBS. It holds all the information related to employee/
associate/ contractor. HRMS module helps the management to find the people
and their technologies and how they are allocated and where they are. It
also helps people to find more details related to a particular employee.
This module is used to store the details of a person starting from review
of details till the time he gets into organization.
Responsibilities:
. Responsible for creating Stored Procedures, Functions, triggers
. Created tables, Views and Synonyms
. Involved in Unit testing
. Worked on Performance Tuning of the application
. Code Review and Quality Assurance of Development
. Issue Resolution and bug fixing
. Involved in integration testing
. Coordination, investigation and resolution of data related issues
Environment: Oracle 9i, PL/SQL, Sybase, People soft, VSS, UNIX, Shell
Scripting, Windows XP.
Project: Asset Data Base (ADB)
Apr 2007 - Jul 2007
Client: Lehman Brothers, NYC
Role: Senior Developer
Asset data base is a long term endeavor by the GAE eServices group to
catalog the technology Assets of Lehman Brothers and the dependencies
between these different assets. The objective of the Asset Database is to
be the authoritative source of information for Lehman Brothers Applications
and its dependencies and a source of information for existing and future
decision support systems as well as a source for Notification systems. If
an asset is affected by downtime or a disaster, personnel and management
can be notified if they will be affected by this disaster. The Asset
database is intended as a resource for Asset attributes and asset
dependencies that will support other downstream systems. As such, several
API's have been built that will support HTTP calls and return XML
structured data that support the W3C standards. In addition, a full set of
User friendly interfaces exist to enable the modeling of Applications and
Sources for which ADB is considered the authoritative source. This list
will grow once the need and demand for these services are well defined and
realized respectively.
Responsibilities:
. Understanding user Requirement and designed User Interface
. Design and development of the project.
. Creation of Stored Procedures, Functions, triggers
. Created Materialized Views
. Created tables, Views. Synonyms
. Involved in Unit testing
. Involved in writing shell scripts in Unix
. Worked on Performance Tuning of the application
. Code Review and Quality Assurance of Development
. Point of contact for the project
. Allocation of work for team members
. Issue Resolution and bug fixing
. Involved in integration testing
. Coordination, investigation and resolution of data related issues
. Created reports for the daily updating of records in real time
Environment: Sybase, Oracle 9i, PL/SQL, Embarcadero DBArtisan VSS, Windows
XP, UNIX, Shell Scripting, HTML, Windows XP.
Project: S2K and TRAX Optimization
Nov 2006 - Mar 2007
Client: Lehman Brothers, UK
Organization: TATA Consultancy Services Limited, Bangalore, India
Role: Developer
Sequal 2000 (S2K) and TRAX are sub-systems in Trade Reporting and
Confirmation (TRC) that processes trades for reporting purposes. TRAX
subsystem facilitates the flow of Fixed Income Trades from the Front End
Systems to TRAX - a regulatory reporting system for the International
Markets.
S2K facilitates the trade flow to Sequal 2000 - a matching and Reporting
system owned by Thomson ESG. The trades processing in the S2K and TRAX
systems are performed by a set of stored procedures termed as the Queue
processors (QP). The individual trades of these sub-systems are currently
processed in a sequential manner by the QPs. This has resulted in increased
usage of the database resources.
The business logic for rejecting Trades is currently present in the later
stage of the processing. This has ended in the reject trades taking the
valuable processing time and hence reduction in throughput. Also, there are
some QP stored procedures with complex queries containing joins, cursors,
loop that can be optimized to improve the performance.
Responsibilities:
. Creating Stored Procedures, Views and Indexes
. Changed Sequential logic code to batch logic code
. Worked on optimization of the project
. Involved in Unit testing
. Worked on Performance Tuning
. Code Review and Quality Assurance of Development
. Issue Resolution and bug fixing
. Involved in integration testing
. Coordination, investigation and resolution of data related issues
Environment: Sybase, Oracle 9i, PL/SQL, Embarcadero DBArtisan, VSS,
Windows XP, UNIX Shell Scripting
Project: HP3000 takedown JP Morgan and Chase (Chase Home Finance),
Aug 2006 - Nov 2006
Client: JPMC, NYC
Organization: TATA Consultancy Services Limited, Bangalore, India
Role: Developer
HP3000 takedown project is a re-engineering project. Chase Home
Mortgage has many applications & functionalities running on HP3000 system.
HP has plans to retire & withdraw support for HP3000 platform by the 2008
Year End. Application & functionality running on Chase Home Mortgage (CHM)
central system HP3000 cannot be made available on strategic platform till
year 2008. CHM HP3000 System is a 25+ years old legacy system. HP3000
system receives transactions from Loan Origination systems, stores loan
applications and loan closing data until the loan is transferred to the
Servicing system. It maintains history of the loan. It provides integration
among Origination, Central and Servicing systems and external vendors for
functions Flood, Rata etc. It houses multiple applications to support
mainly Inventory Control, HMDA functions, and various financial
functionalities.
As HP3000 application receives loan transaction from LOS system, the new
HP3000 Take Down application also needs to be integrated with LOS systems.
On the LOS side, legacy LOS applications are being replaced with new LOS
systems.
So HP3000 Take Down application will receive loan information from New LOS
systems and as well as Legacy LOS system (till the time legacy LOS system
is not phased out) and hence needs to be integrated with both New LOS and
Legacy LOS Systems.
Responsibilities:
. Understanding existing process, and creating prototypes.
. Requirement collection and Analysis
. Worked for Proof of Concept
. Developed prototype of the project
. Achieved in time
. Got appreciations from onsite for the work done.
. Created Stored Procedures, Functions, Materialized Views, Snapshots
. Created tables, Views. Synonyms
. Responsible for Unit testing
. Performance Tuning
. Code Review and Quality Assurance of Development
. Issue Resolution and bug fixing
. Involved in integration testing
. Coordination, investigation and resolution of data related issues
Environment Oracle 10g database, OWB (Oracle Warehouse Builder), PL/SQL,
Visual Source Safe (VSS), Sybase, Windows XP
Project: Ultimatix - MIS
Jul 2004 - Jul 2006
Client: TCS - Internal
Organization: TATA Consultancy Services Limited, Bangalore, India
Role: Developer
MIS is Managerial Information System which is widely used by TCS
management. The access to the users is based on the Role of the user. The
reports on MIS help the user to make the decisions in a right and correct
manner. It involves 3 major different modules like Billing, Expense and HR.
Each module has many reports which help the user to perform the task in an
efficient manner. Billing module is used to know who are the clients to
whom the invoice is generated and from the invoices are pending and other
details can be known. Expense module shows the expenses that are incurred
at project level as well as at organization level. HR module helps the
management to find the people and their technologies and how they are
allocated and to what time
Responsibilities:
. Creating Stored Procedures, Functions, Materialized Views, Snapshots
. Creating tables, Views, Synonyms
. Working on optimization of the project
. Creating tables, Views. Synonyms
. Involved in Unit testing
. Performance Tuning
. Code Review and Quality Assurance of Development
. Issue Resolution and bug fixing
. Involved in integration testing
. Enhancement of the application
. Coordination, investigation and resolution of data related issues
Environment: Windows XP, Oracle 10g database, Oracle 9i, JSP, PL/SQL, VSS
Project: Ultimatix - Hyperion Financial Management (HFM)
May 2005 - Aug 2005
Client: TCS - Internal
Organization: TATA Consultancy Services Limited, Bangalore, India
Role: Developer
HFM Consolidation tool is used to consolidate the Financial Statements of
TCS and its 47 subsidiaries across the globe to produce the Quarterly and
Annual reports. It is used to publish the results to Public. By this tool
all sorts of manual intervention is eliminated while generating the reports
that are needed.
Responsibilities:
. Achieved in time
. Got appreciations from Senior Management.
. Creating Stored Procedures, Functions, Materialized Views, Snapshots
. Creating tables, Views. Synonyms
. Unit testing
. Designing, writing DDL, DML statements and populating oracle database
Environment: Windows XP, Oracle 9i database, JSP, HFM Suite, PL/SQL, VSS
Project: Ultimatix - Global Opportunity Dash Board
May 2004 - Jul 2004
Client: TCS - Internal
Organization: TATA Consultancy Services Limited, Bangalore, India
Role: Developer
This Project is used to know at which stage the deal is in. This is used by
the RMs, BRMs and some other members of TCS to know how well they are doing
and what new deals they are going to get. This has so many things like
RFCs, RFPs and Pipeline etc to view, so that the users can come to know
what the status of each deal.
Responsibilities:
. Achieved in time
. Got appreciations from Senior Management.
. Creating Stored Procedures, Functions, Materialized Views, Snapshots
. Creating tables, Views. Synonyms
. Unit testing
. Designing, writing DDL, DML statements and populating oracle database
Environment: Windows XP, Oracle 9i database, JSP, PL/SQL Developer, VSS
Project: Computer Education in School
Oct 2002 - May 2004
Client: Ram Informatics - Internal
Organization: Ram Informatics, Chennai, India
Role: Junior Developer
This project was done as a part of M.C.A Degree course
individually. In this project there are 3 modules namely Administrator,
Teacher and Student.
In Student module, the student can have the menu to perform his work.
The menu consists of e-book, Tutorial, Practical, Theory exam, results. In
e-book he can have the theory to learn. In tutorial he can have the
navigation to see how to perform the operations. In the practical he can
have the test to be written. In theory exam he can have the questions to
answer.
In theory different random questions like theory based, Icon based,
Image based, general are asked. After the exam there will be a feed back
for the student to know where he is lagging in the subject. In results he
can have all the results corresponding to his name. One student is not able
to see other student results.
In teacher module, the teacher can register new student, modify
student details, can view reports of the students depending on name, class,
place, exam etc. the teacher can also have the rights to add lesson to the
question bank, modify question bank, delete the questions from the question
bank. The teacher can also decide the syllabus for the exam and also the
category for the exam.
In administrator module, he/she can have the total rights to operate
the system. The administrator can register new teachers, modify teacher
details and view reports of the teachers depending upon his need. Along
with this he has also the rights of a teacher to perform the operations.
Responsibilities:
. Achieved in time
. Got appreciations from the Management.
. Involved in Unit testing
. Involved in integration testing
. Responsible for inputting questions and answers for Exams on the
database.
. Wrote DDL, DML and DCL commands
Environment: Windows 98, Oracle 9i database, VB, PL/SQL Developer, VSS
Project: Web Designing for Lanco
Aug 2001 - Sep 2002
Client: Lanco Industries, Srikalahasti, India
Role: Trainee
This project was done as a part of M.C.A Degree Course Curriculum
individually. This is done for Lanco industries, kalahasti. This software
deals with online booking for dealers and feedback from the visitors. The
administrator has the rights to view the feedbacks and booking. He / She
have the right to delete, add information for customers. After seeing the
bookings, the admin can inform the related department of the order so that
the order can be sent. Only registered dealers can make the order bookings,
others can just view and can provide the feedback on the site.
Responsibilities:
. Achieved in time.
. Learnt how to design the application
. Involved in Unit testing
. Involved in integration testing.
. Wrote DDL, DML and DCL commands
Environment: Windows 98, Oracle 9i database, HTML, VB Script, PL/SQL
Developer, VSS
Education
Master of Computer Applications (MCA) - University of Madras, India.
Bachelor of Science (Computer Science) - Sri Krishna Devaraya University
(SKU), India
Contact this candidate