Name: Kanika Arora

Mobile Number +91-976*******

Email Id accy5d@r.postjobfree.com

Educational M.S. in Software Engineering from BITS, Pilani via

Qualifications: Wipro's work integrated learning program called

WASE.

Professional Overview

. Working with Wipro Infotech Pvt. Ltd. as a Senior Software Engineer since

last 5.2 years.

. Seasoned Web Application Developer with 5 years of experience developing

web based applications using ASP, VS.NET, C#.NET, ASP.NET, AJAX, CSS and

JavaScript.

. Database handling experience of 5 years in SQL Server 2005/2008 and

Oracle (TOAD, SQL Developer).

. 2.5+ years experience in MSBI Tools like SSIS, SSRS.

. Well versed with all coding standards.

. Experience in building 3-tier Architecture applications.

. Coordinate with other team members in activities of different projects to

ensure that objectives are accomplished within prescribed time frames.

. Well versed with technical and functional requirement gathering and

analysis.

. Possess analytical, creative and problem solving skills.

. Enthusiastic learner who quickly grasps new concepts and technical

skills.

PROFESSIONAL EXPERIENCE

Wipro Infotech Pvt. Ltd., Mumbai Oct 2008 -

Till date

Role: Senior Project Engineer

Job Profile:

. Responsible for design, development, support and maintenance of Windows

and Web based Applications using C#.NET, ASP.NET, ASP, AJAX, JavaScript.

. Handled the security audit issues in web applications independently.

. Designed database for new applications, customized and created Stored

Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins,

Cursors.

. Created Data Integration and Workflow Solutions for Oracle Financials

using SSIS (BIDS 2008).

. Performance tuning of high cost SQL queries.

. Creation of reports using SQL Server Reporting Services (SSRS) 2008

. Design and Developed Web Applications using ASP, ASP.NET, C#.NET, AJAX,

JavaScript.

. Guided peers and junior software developers to resolve problems.

. Responsible for reporting to the project manager and completing all the

assigned duties within timelines.

. Responsible for understanding all the requirements of clients and meeting

all these requirements.

. Handled the task of identifying and fixing bugs that are reported by the

users, in the stage of maintenance.

. Efficiently maintained configuration management.

Certification

. Oracle Certified Associate (OCA):

o OCA - paper 1 with 86%.

Training Attended

. .Net, Sql/Pl Sql, Oracle Reporting, Java, J2EE for 2 Months organized by

Wipro LTD., Gurgaon at the time of joining.

. Represented my team at SEP (Service Excellence Program) presentation and

won 2nd position. Later attended training for 1 day in Wipro LTD Gurgaon

for the same.

Training Name

Start Date (dd.mm.yyyy)

End Date (dd.mm.yyyy)

Hands On Leadership Program

23.05.2013

24.05.2013

Service Excellence Program

21.08.2009

22.08.2009

Communication Skills

10.12.2008

10.12.2008

Campus to Corporate

08.12.2008

08.12.2008

Highlights of Technologies Known

Technology Tools

Domain Specialization Web Applications Designing and Development

using VS 2005/2008

Databases Oracle 9i,10g and SQL Server 2005/2008

Web Technologies ASP.NET 2.0/3.0/3.5, AJAX, XML, CSS,

JavaScript

Programming Languages SQL, PL/SQL, ASP, C#.NET, ASP.NET, ADO.NET

MS BI SSRS, SSIS

Reporting Crystal Report

Front End Tools Visual Studio 2008/10/12, Toad, SQL

Developer, SQL Server 2005/2008/ R2, BIDS

Operating Systems Windows 2000/2007/7 Enterprise, XP, Windows

Server

Projects Handled

. Six Sigma and Feedback Tool

. Reconciliation Tool

. Apwebtracker, Straight Through Processing

. Medical Manager

. Alert

. KC Issue Management

. CCTNS

Project Detail

Project Name 1: Six Sigma and Feedback Tool:

Project Description: This application is used globally in a reputed MNC by

users for applying for Six Sigma courses and tracking their details and

status from Training, Testing, and Project Submission/Mentoring/Approval

till Certification is granted. The application is integrated with HRMS,

OLMS and Kintana to fetch employees' details, their certification details

and project details respectively. This application includes roles like

Admin, User. The Admin maintains all the application masters where as

user's login to take tests for registered course. This application includes

a Feedback Tool using which users need to provide feedback for training

received for the course. This tool tracks the rating for course material

and Trainer. The reporting module contains several reports used by Admin,

Trainer for downloading user's certification, training and project data.

Also, reports can be downloaded for feedbacks given by users for trainers

and course. The functionality of email trigger (Reminder Emails and

Escalation Emails) is provided for notification of exam start and left

duration, to give feedback, project approval/completion and certification

completion.

Tools: ASP, ASP.Net(C#), Oracle Pl/Sql (Toad), AJAX/AJAX Toolkit, Java

Script, Integration with other source databases.

Contribution:

. Supported and enhanced various modules in Six Sigma.

. Application earlier supported GB, BB, MBB and QL only 1 program active

at a time according to its qualifying level. Hence, developed various

new modules like addition of new course called Lean Program which was

supposed to be activated for all employees and had to make it

available along with their existing course enrolled. Another module

added was Feedback Tool to track feedback given by employees for

training received on training course material and trainer, which

included several aforesaid reports. This included the following steps:-

1. Requirement gathering for the enhancements.

2. Feasibility analysis of the requirement shared.

3. Preparing the supporting documents for the enhancement.

4. Making changes in UAT.

5. Migrating change from UAT to Production.

6. Do the testing before rollout on production.

. Solely handled Database (DB) migration from Oracle 9i to Oracle 10g

and later from Oracle 10g to Oracle 11i for backend.

. Also have mentored and monitored juniors and support team.

Project Name 2: Reconciliation Tool:

Project Description: This application is used by several process users for

reconciliation purpose. There are several roles like Admin - To manage all

masters and upload monthly reconciliation data, reconciler - one who

monthly reconciled account related, First Reviewer, Second Reviewer, Third

Reviewer - Reviewed and approved the reconciliation and gave comments, post

the final review of reconciled account it was closed.

Tools: ASP, Oracle Pl/Sql (Toad), Java Script.

Contribution:

. Supported and enhanced various modules in Recon Tool.

. Also have mentored and monitored juniors and support team.

Project Name 3: Apwebtracker/ Straight through Processing

Project Description: This application is used by AP Teams across several

poles. This application tracks the creation, checking, processing till

closure of invoices at Oracle Financials by taking timely invoice status

feed and PO details from Oracle Financials. The Straight through processing

module was later added to the application to further enhance its usage by

reducing manual efforts for users and increasing accuracy of Invoice

tracking and management. This module further integrates with Oracle

Financials to keep it as a source for major master data, and some required

transaction related data. The application works on series of status for an

Invoice starting from Creation to Closure post the payment is done details

tracked in Oracle. This is done by users in several roles like Admin,

checker, processor. Several schedulers (integration services) run

periodically to keep Apwebtracker and Oracle Financials in sync. The

application supports various reports like Invoice Status, Closure, and

Dashboard etc.

Tools: ASP, ASP.Net, Sql Server 2005, Java Script, SSIS, SSRS.

Contribution:

. Supported and enhanced the application completely.

. Added a new functionality to the application called "Straight through

Processing" which helped increase application usability, data capture

and status accuracy, considerably reducing the user manual efforts in

Oracle.

. Also have mentored and monitored juniors and support team.

Project Name 4: Medical Manager

Project Description: This application maintained 2 modules basically user,

Admin. Every medical room had a generic id used by all medical team members

of that location to login and record visit details of patients. There is an

Admin for each location which used separate SSO login id to login with

Admin rights that included all masters (like Add, Update, Delete Nurses,

Doctors, Diseases, Reason for disease etc.). Several logical reports were

used by Admin in reporting module like Dashboard report that captured coe-

wise visit count corresponding to diseases etc., indent report that

maintained the opening stock and current stock details basis of

consumption, borrowed/lent medicine across locations etc.

Tools: ASP.Net, C#.Net, Sql Server 2008, SSIS, Crystal Reports

Contribution:

. This application was developed from scratch by a team of 2 members

including me.

. Supported and enhanced the application in the later phase.

. Also have mentored and monitored juniors and support team for further

support.

Project Name 5: Alert Tool

Project Description: This application was constrained to be used only by

higher authoritarians under situation of 100% downtime or productivity loss

or any other severe situation to alert all the stakeholders and involved

important people and higher hierarchy of that process. This application is

used to Log new alerts, update alerts, check status of old or already

logged alerts. On logging and updating an Alert an auto-generated mail is

sent to concerned people to alert them of the logged alert or current

status respectively. Employee information was fetched from source database

of all employees of the organization i.e. BOHR. This application has

features like Sql Caching, log maintenance etc.

Tools: ASP.Net, C#.Net, Sql Server 2008, SSIS

Contribution:

. Supported and enhanced the application in the later phase.

. Also have mentored and monitored juniors and support team for further

support.

Project Name 6: KC Issue Management

Project Description: This application is used by KC customers to raise an

issue in case they face any trouble in the process. The raised cases will

be tracked to closure by the creator. The creator will keep the case status

updated, incase of case being stuck at any point due to third party the

auto-generated mail will be triggered periodically to concerned authorities

to keep them aware of the issue. Reporting module will have option to view

the raised issue details like Aging etc.

Tools: ASP.Net, C#.Net, Sql Server 2008, Crystal Reports

Contribution:

. This application was developed from scratch solely by me.

. Supported and enhanced the application in the later phase.

. Also have mentored and monitored juniors and support team for further

support.

Project Name 7: Banking and Insurance Project:

Project Description: Developed and supported several applications used by a

big and reputed Banking MNC. The applications where designed on .NET

Platform using Oracle in the backend.

Tools: ASP.NET (C#), Oracle Pl/Sql (Toad), AJAX/AJAX Toolkit, Java

Script, JQuery

Contribution:

. Supported and enhanced and developed various modules in CC, SAM.

Project Name 7: CCTNS - Crime and Criminal Tracking Network System

(Presently under development)

Project Description: The Central government has implemented an ambitious

scheme called "Crime and Criminal Tracking Network System (CCTNS)". The

goals of the system are to facilitate collection, storage, retrieval,

analysis, transfer and sharing of data and information at the police

station and between the police station and the State Headquarters and the

Central Police Organizations.

Tools: ASP.Net, C#.Net, Sql Server 2008 R2, SSRS

Contribution:

. Solely handled entire data migration activity from legacy systems to

the CCTNS system.

. As the application was already developed at the center level in Delhi,

the development of certain enhancements and state level reporting in

SSRS was done by me for Maharashtra CCTNS.

.

Academic Records

Course Institution Board/Universit Year of Marks

y Passing

M.S. Bits, Pilani in BITS 2012 7.89 cgpa

Collaboration with

Wipro(via WASE

program)

B.Sc.(Co Jai Hind College, Mumbai 2008 65%

mputer Mumbai University

Science)

XII St. Conrad's Inter ICSE 2005 65%

College

X St. Conrad's Inter ICSE 2003 73%

College

Personal Details

Date of Birth 02nd November 1987

Passport details Passport Available : Yes

Passport Validity Till : 2018

Address Present Location: Mumbai, Maharashtra.

Permanent Location: Agra, U.P.

Contact this candidate