Project Manager Sql Server

KISHOR T. MAHADULE

Nagpur-**. Email: - **************@*****.***,

Maharashtra, India Mo. No.:- 097********

-----------------------------------------------------------------------------

OBJECTIVES

To build a career with leading corporate of hi-tech environment, which can offer me a lot of scope for learning and growth and help me to explore myself fully and realize my potential. I am willing to work as a key player in challenging & creative environment.

PROFESSIONAL EXPERIENCE

• Software Analyst (SQL Support\DBA) at Shams Healthcare Software Pvt. Ltd in Nagpur from January 2009 to till date.

• Lecturer at Seth Kesarimal Porwal College, Kamptee (2008 Aug – 2009 Jan).

PROFESSIONAL SUMMERY

• 3+ Years of total professional experience and 2.6 years experience in Software industry as a Software Analyst. My domain expertise includes Healthcare and Enterprise Resource Management in Microsoft Technologies.

• Worked as a Software Analyst (SQL Support) at Orange Softsys Pvt.Ltd, Nagpur (2009 Jan-2009 Nov). (A company governed by The Shams Group, TSG, Dallas, TX, USA.)

• Transferred to Shams Healthcare Software Pvt.Ltd, Nagpur, working as a Software Analyst (2009 Nov-Till date)

• Also have a 6 months experience of a Lectureship in a Seth Kesarimal Porwal College, Kamptee(2008 Aug – 2009 Jan)

• Strong ability in identifying problems, developing new ideas and finding the best solutions to suit in the prescribe environment.

• Good logical, analytical and interpersonal skills. Commitment to perform quality work and an excellent team player.

• Excellent capability to learn new technologies in a very short period of time.

• Good learner and good performer both in team and independent environment.

PROFESSIONAL QUALIFICATION

M.Sc. (Information Technology) From Seth Kesarimal Porwal College, Kamptee (July-2008)

CERTIFICATIONS

Microsoft Certified Professionals: SQL Server 2005 Implementation and Maintenance.

(70-431)

Have successfully completed a training of Microsoft Certified Professional (MCP) in C#.Net

COMPANY PROFILE

Shams HealthCare Software Pvt LTD is the sister concern of The Shams Group (TSG) a workflow-based software and consulting firm specializing in Data Warehousing/ Decision Support Systems, Document Imaging/Object Archiving, EMPI, and EHR based knowledge management solutions. As one of the premier vendors in the healthcare marketplace, they provide ‘open’ system, web-based, and integrated solutions for progressive hospitals to leverage their IT investment Located Head Office in Dallas, Coppell TX, United State of America and Research and Development Office in Maharashtra (Nagpur), India.

For more information please visit http://www.shamsgroup.com/

AREA OF EXPERTISE

Performance Monitoring, Backups and Restore.

Monitoring disk space and memory usage.

Backup in house SQL databases.

Database Replication.

Troubleshoot SQL Maintenance Jobs.

Quarterly systems and security maintenance.

Developed a packages to save all the SQL Server packages to folder.

Developed a packages to restore all the packages from folder to SQL Server.

Handling SQL jobs and DTS Packages.

Importing and exporting data using DTS.

Meditech Upgrade Task.

Fixing DTS Upload issues.

Handling all the Download and Upload process.

Handling Mediscripting and SQLCM process.

Analyzing and Fixing Oversize, DT mismatch, Duplicate Exceptions.

Monitoring & resolving the issues related with HL7Client and HL7Server.

Working on Real time sites.

Working Customized packages and saving.

Working on SQL Server 2000 and 2005 and tasks done are SQL Job Scheduling.

Setup/Troubleshoot client connections.

Support central paging system and monitor SQL and SI related E-pages.

Modifying SQL server to optimize server performance or resolve server issues.

Work 24x7 during SQL conversions/recovery events.

PROJECT #1: ASTRO INTERFACE MANAGER

Description Astro Interface manager is an interface to download data from Meditech server to the warehouse Database. This product is used in different hospital in U.S.A. According to medical standard in U.S.A the running data should be stored only in Meditech server. This interface down load data form Meditech using text format. This product can used download data in indexed and non-indexed way. Non-indexed interface download all data from Meditech and indexed interface download data using parameters.

Role Team member

Domain Healthcare

Environment SQL Server 2000 and 2005

Operating System Windows 2000 Advanced service Pack 4

Tasks Setup Interfaces, Schedule interfaces, Check download part

Period 10 Months

Team Size 8

PROJECT #2: SQL Support

Description Each interface can set up tables and indexing of each table or group indexing is possible. When start the interfaces, data are downloaded in text format and stored in mentioned destination folder. Indexed interfaces updated the parameter after running the interface. Next time data will download using updated Parameter and it can avoid the downloaded data again. The Meditech tables have some hierarchies and this should be follow in this interface. Downloaded text file uploaded using DTS Packages. Each table have DTS package for uploading file in to the ware house database. The DTS Package checks different type of Exception, constraint and finally record uploaded in the ware house table. If any exception occurred, the exception record stored in exception database.

Role Software Analyst

Domain Healthcare

Environment SQL Server 2000 and 2005

Operating System Windows 2000 Advanced service Pack 4

Tasks Fixing Exceptions, Fixing upload process

Period 10 Months

Team Size 8

PROJECT #3: Automated Information System

Description I have worked on AUTOMATED INFORMATION SYSTEM which serve information needs of organization’s users round the clock automatically without any human intervention. The system answer the user’s query in three ways, via

Interactive Voice Response System (IVRS)

Electronic Mail (E-mail)

Short Message Service (SMS)

I have developed SMS module for the system, which will answer the queries through SMS, means by sending a dynamically generated SMS from user query.

It accepts input from users message (SMS), and after analyzing the text; it sends required response to the user from Database in the form of messages (SMS).

It is a generic system which will provide information about the organization whose database is currently attached with it.

I am required to do this project as a part of Masters Degree in Information Technology .It is my second year second semester six months project.

I have developed this project under the guidance of Mr. Manish Peshkar (Project Manager), Micropro Software Solutions & Private Limited, Nagpur.

Role Module Lead

Domain Insurance\Banking

Environment MS .Net 2.0, C#.Net 2005

Operating System Windows XP With Service Pack 2

Tasks Automated Generation of SMS

Period 6 Months

Team Size 3

KEY COMPETENCIES & SKILLS

My competency profile includes the following

Skill Proficiency (E0 to E4)

SQL E3

PL/SQL E2

C++ E2

C#.Net E2

Java E1

SPECIAL ATTRIBUTES

Pursued my graduation as well as post graduation in Information Technology, with all over First class records.

Attended National Conference in Innovations in Information Technology 2007 Gondia.

I am a quick learner, a self-starter and willing to work in dynamic environment.

I am a team player, can establish and maintain good relations with everybody.

PERSONAL PROFILE

Father Name : Mr. Tejram Mahadule.

Gender : Male.

DOB : 02-Feb-86.

Nationality : Indian.

Marital Status : Single.

Languages Known : English, Hindi & Marathi.

I hereby declare that all the information provided by me in this resume is factual and correct to the best of my knowledge.

Kishor Mahadule.

Place.

Contact this candidate