Sql Server/MCA/MCITP/10+ Yrs Exp
Resume:
CURRICULUM VITAE
Kaushik Mitra
Present Address:
PNo: 15, Sripuri Colony, Kakaguda. Karkhana. Secunderabad: 500015
Telengana.
India.
Permanent Address:
**/*/*, ***** **** Road. Behala. Kolkata: 700034.
West Bengal.
India.
Date of Birth : 28thDecember 1976
Mobile: +918*********
Email: ************@*****.**.**
Objectives
My objective is to venture into any kind of Application. Always looking for a Challenging Software
Development group and want to be a part of Development unit and committed to grow with the
latest in Technology, where expert technical skills, extensive knowledge of Web application,
excellent interpersonal, analytical skills, team management skill and project management skill will
be fully utilized and further developed.
Synopsis
BOARD / COUNCIL /
EXAMINATION NAME YEAR
UNIVERSITY
Madhyamik Parikhshya. West Bengal Board Of Secondary
1992.
(Standard 10 ) Education.
West Bengal Council Of Higher
Higher Secondary. ( 10 + 2 ) 1994.
Secondary Education.
Bachelor Of Science. ( B.Sc. ) 1996. University Of Calcutta.
Diploma In Computers In Office 1999 Indira Gandhi National Open
1
Management ( DCO ) University.
Diploma In Hardware Technology Webel Informatics Ltd (Govt. of West
2000
(DHT) Bengal Undertaking).
Post Graduate Diploma In Computer Indira Gandhi National Open
2001
Application (PGDCA ) University.
Advance Diploma In Computer Indira Gandhi National Open
2004
Application. (ADCA) University.
Master In Computer Applications. Indira Gandhi National Open
2004
( MCA ) University.
CERTIFICATION CERTIFICATION NO
MCTS: E1487929
MCITP: E1995447
I am Software Engineer & Project Lead developing solutions (Online and Offline) for last 10+
years.
Proficient with Onsite and Offshore delivery model and methodology.
Ability to execute complex projects/programs on time and within budget.
Possess strong client facing skills and delivery focused and Proficient in managing multiple
crossfunctional teams/projects and ability to identify, understand and give priority to urgent
issues.
Believe strongly in excellent analytical, logical and programming skills. Always try to go deep
in the requirement of the client to provide him the right solution.
Always to excel more in life with gathering all kind of experiences and learning.
Domain I worked: CRM, Payment process, CODA
Currently: Rental Application System, Address Verification, Order
Assure, Sim Tracking.
Technical Skills
Primary Proficiency Level :
SQL Server 2000 2008
Advance
MSVisio Advance
Tools
Bizagi BPM Advance
Tools
Experience : 9+ Years
2
Current Company & Role
From MAR 2014 Till Date
INTENSE TECHNOLOGIES LIMITED (HYDERABAD, INDIA).
Designation: Sr. SW Engineer
Location: Hyderabad/Secunderabad
Responsibilities:
TSql script, Sql patch, Data Analysis
Data migration using SSIS.
Linked Server, DTS, Scheduling, Performance factor Maintenance and support the database
(Sql Server) for the existing Rental Application (RAM) for US client ATLANTICUS is utilizing.
Also participate for revamping the existing application.
Preparation of Project Plan and Tracking of the plan.
Stake holder Management (Internal).
Preparing and presenting proposal to senior management
Coordinating with individual project leads and guiding them with
planning and scheduling of different projects to ensure that all milestones are achieved within
the agreed timeframes.
Coordinating with understand the feasibility of implementing
Holding internal meetings on progress.
Producing project definitions to include validated functional requirements, use cases, scope,
roles, responsibilities, timescales and resources.
RAM(Rental Application & Management):The RAM System software package is designed to
give rentalpurchase companies a secure, flexible, comprehensive system that improves
efficiency and profitability. Renting inventory, managing accounts and taking payments are all
important functions. However, tracking the day to day operations of rental store is just part of
what The RAM System can do.
The system also provides a powerful set of performance evaluation and business management
tools. Analyzing customer accounts, inventory, and Forecasting sales and income potential will
help to make those important management decisions and identify areas needing improvement.
Client: Atlanticus
UNISERVE 360(Telecom Management)enhancement with new feature list like Address
Verification, SIM Tracking, Centralized Alerts & Notification Engine, Order assurance along with
multiple CRM integration and Video Bill Solution. And existing Uniserve 360 application to cloud
compatible.
3
ORDER ASSURE (Telecom ECommerce): This solution is to address the major data and
customer handling challenges with multiple Order Management Systems scenario in an
enterprise. The solution will help streamline Enterprises serve their customers better, especially
for Telecoms.
Client: Infosys
ADDRESS VERIFICATION SOLUTION: This solution is proposed to BSNL(Telecom) and
AirTel(Telecom) and it is meant to address the problem of quickly and accurately performing
address verification of a new subscriber as part of the onboarding or activation process. This is a
combination of mobile app and server side application that will streamline and help agents
perform this activity within 34 hours time instead of days.
Client: AirTel
CENTRALIZED ALERT & NOTIFICATION SOLUTION: Alerts & Notifications engine is a
powerful twoway communication Web based application, designed to help Organizations to
communicate more rapidly and effectively. This application can ensure that everyone involved in
the business is fully aware of
critical events at all times. It enables realtime alerts based on specific events and also for
campaign. The customized notification rules, defines when & how a customer needs to be
informed. Each alert is custom designed through rules engine to notify customer(s) when certain
criteria are met. The algorithm monitoring customer account in real time can be used to enroll
specific event(s). When predefined levels or trends are detected, it notifies the respective
customer. Alerts can also be sent on a predetermined date and time through email and SMS.
Reminder alerts can be set to support on the task assigned.
Client: HDFC, Self Proposed From Market Research
SIM TRACKING SOLUTION: Telcos are facing major challenges in tracking SIM cards through
Distributors, Retailers, POS and subscribers. This solution will enable Telcos to track and monitor
SIM cards across all their circles and manage SIM cards distribution in an optimal manner
through overall visibility and control of allocation.
Client: Self Proposed From Market Research
VIDEO BILL SOLUTION: It is highly personalized video bill with rich graphics and
variable data through template designs. Prototype Software for Video bill has been
created using video rendering and parsing with text to speech feature.
Client: Self Proposed From Market Research
4
Previous association with IT World :
Comtel Technologies Pvt Ltd, KOLKATA (From Apr 2008 to Mar 2014)
Designation : Project Manager.
Location: Kolkata & UK
Application Handled: Installation Commission, CODA, CRM, IFS, FMS, LMS
Responsibilities:
Requirement Analysis & Preparation of Functional Specification Document (FSD).
Linked Server, DTS, Scheduling, Data Migration, SSIS, Linked Server Maintenance, Analysis, Performance
factor Maintenance and support the databases(Sql Server) for the applications
Impact analysis, Effort estimation, Resource Management.
Providing the technical solution for the production issues.
Onsite Offshore Coordination.
Quality Management.
Weekly status meetings with project stakeholders from customer as well as internal management.
INSTALLATION COMMISSION: It is a part of payroll process to pay specialized employee
weekly basis with calculating their taxes, overtime, retention so forth.
CODA: Third party support for Financial Management software and services that help
organizations streamline and automate their finance processes.
IFS: IFS is being used to record daily activities and to process resource allotment to serve any
recorded order and provide different reports to the management.
FMS: Facility Management System is used to maintain asset register. And it would provide
assets information along with the rented information.
LMS: Lead Management System to record leads, generated from sales and marketing team from
campaigning and thru internet promotion.
CRM: Customised in house developed CRM application to record the customer information as
well as maintain the survey and installation of products thru Oracle Side winder Application.
Client: Safestyle UK
Ezytech Pvt Ltd(Vision and solution Pty Ltd), KOLKATA (From Jun 2007 to Mar 2008)
Designation: Sr. Software Engineer & Team Lead, Web & Intranet Solutions . Role was basically to Develop,
Design architecture for Web Application, Database Maintenance, Data Transfer, Lead a Team.
Virtual Ghana Microsystem Ltd, West Africa, Ghana (From Sep 2006 to Jan 2007).
Designation: Sr. Software Engineer Project Lead, Access Controller Solution.
5
Twister Software Solution (From Feb 2005 to Aug 2006)
Designation: S/W Developer.
Important Project Brief Description
Rental Information System DOMAIN: CRM
Project started on Mar 14
Basically, It was designed to attach customer records to
inventory records via an agreement record. Each
agreement was designed to track a balance and that
Brief Info
balance is reduced each time the customer makes a
payment.Its front end is made of C#.net 2010(Windows
Application) and Sql Server 2005
Item Management Processing the details of
Items in Inventory.
Agreement Management Agreement
Process Management.
Payment Management: Complete
validation of the contracts docs and
Functionality
credit the payment to the respective
borrowed Item.
Item Service Management: In warranty Sevice,
Exchange item with the earlier delivered item
and balance
3rd Party Service Integration for store
management and Payment process
Active participation in db design documentation for
revamp application, core development of modules and
manage the change request.
My Role
Analyze the requirement with CODEVELOPERS, URA
User requirement Acceptance; build development
methodology as per user perspective.
C#.NET 3.5, SQL 2005.
Platform
THIRD PARTY RTTM Services
Installation Commission DOMAIN: PAYROLL UNIT
Project started on Sep 08
Brief Info Basically, It is a business processing package used
in the commission calculation of Fitters,
Installation Engineers and Service Engineers which
is being daily used by the client. Its front end is
made of C#.net 2005(Windows Application) and
6
Sql Server 2000
Fitter Management Processing the details
from different application (IFS) and keeping the
related information to process.
Order Management Order Process
Management.
Payment Management: Complete
Functionality
validation of the contracts docs and
credit the payment to the respective
engineers.
User Management: LDAP Authentication
management for the user and the
module permission.
Active participation in designing the class structure, db
design, core development of modules and manage the
change request.
Analyze the requirement with CO
My Role
DEVELOPERS, URA User requirement
Acceptance; build development methodology
as per User perspective and guide team of 8
persons.
C#.NET 2.0, SQL 2005.
Platform
CRYSTAL REPORTS 10.0
Reporting Tool
IFS APPLICATION BASED ON ASP.Net
THIRD PARTY
SDMS APPLICATION BASED ON DELPHI
CODA Domain : Accounts ERP
Project started on : Jan 2007
Financial Management software and services that help
organizations streamline and automate their finance
Brief Info processes (from accounting and procurement to reporting
and analysis) and to achieve better compliance and corporate
governance.
Raise Purchase Order to the manufacturing Unit when an
order initiates at CRM
Raise sales invoice to customer when order completed at
Functionality
CRM, Profit Maker (Third Party Application).
Banking Module to evaluate business for residual payment
Survey fee and deposit receive management.
Safestyle, U.K.
End Client
7
ASP.NET 2.0 (C#) and SQL Server back end. SQL Server
Technology
Scheduler Application, Linked server services.
Active participation in designing the structure, db design, core
development of modules and manage the change request and
support to the existing earlier developed module.
My Role
Analyze the requirement with CODEVELOPERS, URA User
requirement Acceptance; build development methodology as per
User perspective and guide team of 8 persons.
Domain: Order Processing.
Web Bookstore
Project started on : 7/11/2007
Team Strength : 5
It includes Books, Music and Movie database and windows
application where publisher will maintain their sell over
Brief Info : windows application and there after order will be generated
and thru the web service. It would be uploaded and
maintained thru web application.
Library management from ADMIN Panel which includes
the uploading the book/ music / movie.
Functionality
Order Processing Management.
Invoice Management.
Books Emporium, AUS.
End Client
ASP.NET 2.0 (C#) and SQL Server 2005 back end.
Technology Web Service (C#) and Windows Application for processing and
generating the invoices and Crystal Report as reporting tool
Assigned as Sr. Developer cum TL. Develop the entire solutions.
My Role Design and develop the database design to workflow management
and codify the modules and develop the web services.
Big Love Domain : Entertainment
Project Started On : 17 Jun 2007
Duration : 6 months
Team Strength: 7
Brief Intro : Australian dating website
End Client : Public News Pty Ltd.
CMS management from ADMIN Panel which includes the
creation of dynamic pages and the categories.
Functionality : email Management.
News letter management.
sms Management.
Technology ASP.NET 2.0 (C#) and SQL Server 2005 back end.
My Role Team Lead
8
Domain : Access Controller Based Time Attendance
BioStudio
Project Started On : 20Sep 2006
Duration : 6 months
Team Strength: 7
It is a Payroll module. It Works with Nitgen
NAC3000/NAC2500 Biometric Access controller machine
Brief :
for employee tracking And Overtime Calculations and
Payroll system.
John Bitar Company Ltd, Logs & Lumber Ltd, AG Ltd, STP
End Client :
Ltd.
C#.Net and SQL 2005, Crystal Reports
Technology
My Role Project Lead
Project Name:WMIS, QUANTUM, AIA
Other Projects in brief :
Role : Project Leader
Clients : Australian Client
Responsibility: Developing New Module/ Client end modification/
database design
Environment : C#.Net, MsSql Server, Web Service, Crystal
Report. Active Report
Overview Of Project:
WMIS: It is a warehouse invoicing system for the retailer.
QUANTUM: It is an eye testing software.
AIA: It is a production and calculating software for different types
of rubber and metal belts.
WDS: Retailing Windows application Software to track the entire
retailing and billing process for Australian transport people.
Personal Memoranda
Nationality : INDIAN
Social Status : Married Male
Passport Details :
Having Passport : Yes
Date of Issue : 01 June 2005
Date of Expiry : 30July 2025
Current Location : Hyderabad, INDIA.
BRADFORD UK.
Previously Posted :
Accra, Kumasi, Takoradi Ghana.
Ready for Relocation : ANYTIME
9
NOTICE PERIOD : 60 Days.
Cities: Kolkata, Bangalore, Hyderabad, Chennai,
Preferred Location In India :
Mumbai, Pune, Delhi, Noida, Gurgaon
Onsite Preference : Anywhere in the World.
I hereby solemnly declare that the above particulars furnished are true to the best of my
knowledge and belief.
Yours Sincerely,
Kaushik Mitra
10
Contact this candidate