Senior Software Engineer
Resume:
Name: Kanika Arora
Mobile Number +91-976*******
Email Id *********@*****.***
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