Kanchan Mala
Email: ****.*******@*****.***
SkypeId: Kanchan_06
Cell:+1-610-***-****
PROFILE SUMMARY
Total 9.5 years of rich IT experience in System Analysis, Design,
Development, Testing, Implementation and Maintenance of Business
Applications.
Excellent programming skills and strong Object Oriented programming
concepts
Experience in working ASP.NET, C#.NET, VB.NET Win Forms, Web Forms, Web
Services, .Net 2.0/3.5 /4.0 framework, Classic ASP.
2 Yrs Experience in working MVC 3.0 with TDD (Test Driven Development).
Experience in Object Oriented Analysis and Design methodology with strong
knowledge and experience with the Design Patterns including Structural,
Creational and Behavioral Patterns like Model viewer Controller (MVC).
Experience in Writing code and debugging skills with ASP.NET, WCF, C#, Web
services.
Experience in Language Integrated Query (LINQ) Providers for data
manipulation.
Proficient in developing Client/Server applications in 3-tier and N-tier
Architecture
Experience in Visual Basic 6.0, ASP, VBScript, JavaScript.
Strong relational database background in SQL Server 2000/05/08 MS-Access
and ADO.NET
Experience with Data Accessing including using Data Adapter, Data Reader
and Dataset in ADO.NET
Extensive knowledge and experience in creating DTS, SSIS packages in SQL
for data extraction from File System to main database.
Handled source code in each projects in version control tools like TFS and
VSS.
Hands-on experience Insurance, Telecom and Retail Domain Application
Development.
Good exposure towards Commercial insurance industry in US market, worked
into Commercial Insurance Policy decision product where exposed to various
Line of Business mainly Property & casualty, Homeowner, Inland Marine and
successfully executed various project where the involvement starts from
initial phase of project-kicked off to completion
2+ Yrs of experience in Scheduling and executing Control-M job on Windows
environment.
Excellent working experience using with Internet Information Server (IIS),
Windows/NT Server.
Experience in Application maintenance and production support (24 * 7)
within a strict Service level agreement time frame, was also part of a
Change management team and Co-coordinated with multiple vendors as a part
of Change Management Role
Experience of End-to-End Implementation of the SDLC; including finalization
of Specifications, Design, Development, Testing and Implementation.
Worked in Waterfall and Agile Software Development methodologies which
makes easy for both Developer and Client to know current status of
applications.
Microsoft Certified Technology Specialist (MCTS) for .net framework 2.0 web
applications
INS 24 Certified
TECHNICAL SKILLS:
Languages ASP.Net, VB.Net, C#, C, ASP and VB, JavaScript, VBScript,HTML and
SQL
Technologies C#.NET, VB.NET, ASP.NET, ADO.NET, Web forms, HTML, WCF, MVC Web
Services, XML.
Operating Windows 2000/XP/NT/95/7
Systems
Databases SQL Server 2000, SQL Server 2005,SQL Server 2008
Tools/Technologi Visual Studio.NET ( 2005, 2008, 2010, 2012), Visual Studio 6.0,
es CONTROL-M
Web Servers IIS 7.0/6.0/5.0
Version Control TFS 2012, SVN,STAR TEAM
Tools
PROFESSIONAL EXPERIENCE
Publix, Lakeland, FL Dec-
2014 to April-2015
Programmer Analyst
Project Description:
AccessVia/ Retail
AccessVia is an interface for Retail Store system which gets triggered
by store manager whenever any changes in price occurs for an Item the
corresponding changes of price are done in all stores for an Item. The
Interface has a list of Windows services that executed consecutively to
update an item price in all stores, System includes WCF web services to Get
and update price for store Item based on new Item Price the tag request get
generated for an Item, those request are sent to other interfaces by MQ
request.
Responsibilities:
Developed multiple services - GenGateMaintenace, UpdateRetailItemPrice,
SignDataRefresh, SynManagerSpecial for an AcessVia Interface using C# 3.5
and 4.0.
Developed and consume WCF web service.
Programmed to send request to other interface using IBM WEB MQ.
Developed a Logger utility to log errors in Flat file and Event Viewer
using Enterprise Library 4.0.
Customised the Microsoft Command line parser API.
Used TDD for unit testing.
Created Store Procedures, User defined function.
Applied best design patterns such as n-tier, Singleton, command for
designing key reusable components.
Build DTS and SSIS packages to transfer the data.
Used ADO.NET to connect to backend and stored procedures to manipulate
data.
USED NFX TOOL FOR APPLICATION CONFIGURATION.
INVOLVED IN DESIGN REVIEW AND CODE REVIEW.
INVOLVED IN UNIT TESTING AND INTEGRATION TESTING.
Provided timely progress report on project to Project Manager.
Environment: C#.NET 3.5/4.0, WCF WEB service, Visual Studio.Net 2010,
Visual Studio 2012, NFX 4.0, SQL 2008, IBM MQ, Enterprise Library 4.0
Insurity, Hartford, CT (Offshore-Onshore)
Mar-2010 to Feb 2014
Senior Software Engineer
Project Description:
Policy Decision/Commercial Intellisys
Policy Decision is a policy administration solution that supports the full
policy lifecycle for all major commercial, personal and dozens of specialty
and proprietary lines, the product has used by clients ranging from MGAs to
niche providers to 15 of the top 20 US insurers, The feature of product
has:-
Automated rating and issuance support for all major commercial lines of
business and numerous proprietary lines.
Full policy lifecycle transaction support
Full maintenance of ISO and customer-specific rates, forms, and rules
changes.
Enhanced underwriting decision-making with point-of-sale application data-
capture, third-party data integration, scoring, and referral-management.
Commercial Intellisys Commercial Intellisys provides commercial Property &
Casualty policy rating, issuance, and statistical coding for all lines of
business in all 50 states of US. The system is used to update the rating
rules and policy form. The system also provides MVRs,credit scores,
telephone verification, and/or on-site surveys; logical information-
ordering that allows underwriters to review initial information before
requesting additional verification; and reference materials that provide
information such as city-file features, NCCI manuals, NAIC codes, address
verifications, and SICs.
Responsibilities:
Participating in full project lifecycle with focus on defining standards
for technical solutions, documentation, unit testing and deployment
utilizing knowledge of Microsoft TFS, 3-tier web application development,,
ASP.NET, C#,, WEB SERVICE and SQL Server2008.
Interacted with the client during requirement gathering phase
Triaging of issues to resolve it effectively
Designed the application using various patterns including MVC and
Singleton.
Developed Web forms for Insurance related activity (Add/Modify Coverage,
Rating rules) in Policy Decision application.
Implemented View Model and Controller class to fetch and compute customer's
insurance quote.
Used TDD for unit test.
Developed core functionality with the ASP.NET, MVC Framework (C#.NET,
ADO.NET)
Implementation of client side validations using JQuery and ASP.NET MVC
Validation implemented at Controller level.
Implemented Commercial Insurance business rating and stat coding rules for
various line of business (Property & casualty, BOP, Inland Marine) using
C#NET, Visual Basic 6.0 and SQL server 2008.
Used ADO.NET to connect to backend and stored procedures to manipulate
data.
INVOLVED IN RESOLVING BUGS WHICH ARE ADDED BY QA TEAM OR RAISED BY USERS
AND CLIENT.
Worked on onsite-offshore model.
Extensive use of Web Services, WCF Services and SOAP protocols using .NET
Generic classes.
Utilized Microsoft Team Foundation Server (TFS) to manage the team's
software development lifecycle
Used Xpath Navigator for finding the Nodes and elements in the XML
Document.
Used Node List to read XML document data.
Worked on providing and consuming information from Web Services using WCF
for parts arrival, dispatch and internal movements.
Consumed XML Web Services using ASP.NET.
Providing application support, troubleshooting bugs, developing and
implementing emergency fixes.
INVOLVED IN DESIGN REVIEW AND CODE REVIEW.
Involved in Unit Testing and Integration Testing.
Provided timely progress report on project to Project Manager and Client
Environment: ASP.NET 2.0/3.5, C#, VB.NET, MVC 3.0, VISUAL BASIC 6.0,
Classic ASP, SQL Server 2008, ADO.NET, WEB Service, WEB Form, IIS
7.0,Visual Studio.Net 2010, WCF, Web Services, TFS, XPATH.
Telstra, AUSTRALIA (Offshore-Onshore)
Nov-2005 to Feb-2010
Software Engineer, Sr. Software Engineer
Project Description:
SOROBAN/ BRSS Plus (Bill Reporting Self-Serve Plus)/MSDS
BRSSPlus Bill Reporting and Analysis system is an application owned by
leading Telecom Company in Australia. This application is targeted to serve
their corporate customers. These customers have large number of call
records and require detailed reporting and analysis for their voice, mobile
and data usage. The customers subscribing to use BRSSPlus can view and
analyze historical usage records in detailed report format
SOROBAN (known as Call Charge Analyser) is a web-based application with two
main functions Call Cost Calculation and Bill Comparisons. Call Cost
Calculator performs the calculation of call rates and values based on a
short list of possible/selected pricing/rating plans. It provides
descriptions of the pricing/rating plans and information on how they work.
Bill Comparisons will display comparative Business and Residential charges
and Inbound One Rate comparative charges. SOROBAN is having upstream and
downstream interfaces and it communicates with those interfaces in bi-
directional manner. There are some batch jobs in the production run on
control-M server, these jobs are used to cleanup the SOROBAN database and
update the SOROBAN database on fortnight basis.
MSDS application is an intranet-based, with the help of this application
Telstra takes care of tracking of provisioning activities for its corporate
customers. The provisions are in terms of telecom services and products.
The application is aimed at providing a Single Point of Contact for all
customer services. It also provides facility of single invoice for all
contracted services tracked through the system. Contract specific
information e.g., the priority levels, the job stages, the standard fault
symptoms etc are tracked through the system. The application is customized
to cater to these contract-specific details while defining the workflows
for various products.
Responsibilities:
Participating in full project lifecycle with focus on defining standards
for technical solutions, documentation, unit testing and deployment
utilizing knowledge of Microsoft VSS, 3-tier web application development,
ASP using VB and SQL Server2000.
Implemented Business Layer for hiding the business logic rules from the
presentation layer
Implemented Presentation Layer (ASP, HTML, VBScript, and JavaScript) which
will use the Business Layer components to present the info on the client's
browser.
Interacted with the client during requirement gathering phase.
Designed Requirement document, Technical specification, Implementation
document.
Scheduled and monitor Control-M Jobs.
Created DTS package to import Billing Data from delimited text file to
Database.
Used SQL Profiler to monitor query execution.
Automated the Monthly bill load process using .NET 2.0, SQL 2000, Stored
Procedure.
Triaging of issues to resolve it effectively
Developed and modified business rules using Visual Basic 6.0 and SQL server
2000.
Involved in resolving bugs which are added by QA team or raised by Users
and Client.
Worked on onsite-offshore model.
Utilized VSS to manage the team's software development lifecycle.
Used STAR TEAM to maintain the versions of project document.
Used XML to interact with downstream interface.
Provided application support (24*7), troubleshooting bugs, developing and
implementing emergency fixes.
INVOLVED IN DESIGN REVIEW AND CODE REVIEW.
Involved in Unit Testing and Integration Testing.
Interacted with multiple vendors to implement a Change Request.
Provided timely progress report on project to Project Manager and Client.
Environment: Classic ASP, ASP.NET 2.0, C#, VISUAL BASIC 6.0, SQL Server
2000, ADO, WEB Form, XML, IIS 6.0,Control-M, VSS.
CIPLA, India
Mar-2005 to Nov-2005
Associate Software Engineer
Project Description:
Time, Attendance and Leave Management System
Time, Attendance and Leave Management System is user friendly parameterized
attendance and leave tracking software. The software facilitates:-
To create any number of shift roster
Track in-Out time of employees
Create Overtime, Leave rules
Raise and approve leaves.
Responsibilities:
Involved in the analysis and development of functional specification.
Experience in Design and Development of User Interfaces (UI)- Web Forms,
Desktop Applications
DESIGN AND DEVELOPED REPORTS USING CRYSTAL REPORT 7.0.
Deployed and configure the application.
Interacted with the client during requirement gathering phase.
Interacted with the Client, vendors whenever required to resolve the
issues.
Environment: Classic ASP, VISUAL BASIC 6.0, MS-Access, Crystal Report 7.0,
IIS 5.0, VSS.
1 EDUCATION
Master of Computer Application- Banasthali Vidyapith University, India,
July 2004
Bachelor of Science - Banasthali Vidyapith University, India, July 2001