Sr Business Analyst/ Web Developer

NIKHIL R KSHIRSAGAR

**** ********* ****, *** #****, Richardson, Texas 75080

Ph no: 972-***-**** E-mail: ******.***********@*****.***

EXECUTIVE SUMMARY:

I am a sound professional with an experience as Microsoft SQL server Database Administrator.

I have worked on various time bound projects with 24 * 7 * 365 live support. I am well versed with the knowledge of SQL, Certified professional. Proficiency has provided quality work with the values like

Integrity, Teamwork, Innovation, Commitment and Excellence.

CERTIFICATION:

Microsoft Certified technology Specialist, Microsoft SQL server 2005 (Exam 70-431)

EDUCATIONAL SUMMARY:

Currently pursuing Masters Degree at University of Texas at Dallas (Graduation in Aug 2011)

GPA 3.767 out of 4.0

COMPLETED COURSE WORK:

Business intelligence, Advanced Business Intelligence, Business Data warehousing with SAP, Spreadsheet Modeling, Enterprise Resource Planning, Information Technology Strategy and Management, Database Management Systems, System Analysis and Project Management, Quantitative Introduction to Risk and Uncertainty in Business, Operations Management

ACADEMIC PROJECTS COMPLETED:

Analysis of H1-B Data.

The year 2009 H1-B data with almost 2,68,000 records was categorized using various predictors like employer, state, city, salary etc and applied various BI techniques to explore interesting and unfound facts about the data using XL Miner.

Pet Store system.

Project was created using Microsoft Access 2007 at The University of Texas at Dallas for Database Management Systems. Entity Relationship Diagrams were drawn using Microsoft Visio.

Deals2buy analysis.

This system was analyzed and new system was proposed. USE Case Diagrams, Class diagrams and Sequence Diagrams were constructed to analyze the system using Rational Rows and Microsoft Visio.

SKILLS SUMMARY:

Databases: MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008, MS Access.

BI Tools: XL miner, SAS Enterprise Miner 9.2

Office Packages: MS Office xp/2003/2000/97

Languages Known: SQL, C, C++, C#.net, CORE JAVA, HTML, XML, UML

Others: Entity Relationship Diagram, Relational Model, Normalization, Object Oriented concepts, Visual Studio, Microsoft Visio, Spreadsheet Modeling

SPECIALIZATION:

• SQL Server Integration Services (SSIS)

• SQL server Reporting Services (SSRS)

• Log shipping

• Replication and Clustering

• Lite speed (Database Maintenance Tool) is a tool used to take backups, restore and general maintenance of the server

WORK EXPERIENCE:

Company: The Shams Group (May 19, 2011 – Present)

Position: Intern – IT Support

Responsibilities Handled:

• Database Administration and Support

• Resolution of SQL and Operating System related issues on Production.

• Handling space issues, by shrinking databases.

• Monitoring jobs and disks space.

• Troubleshooting SSIS, SSRS and SQL job errors.

Company: Center of Information Technology and Management (CITM) at The University of Texas at Dallas. (January 28, 2011 to May 18, 2011)

Position: Database Analyst / Developer.

Client: Ericsson.

Professional Project:

IMOP system’s back end was designed with understanding of clients need. The project is to design

web based system to update Methods of Procedures (MOP).

Responsibilities Handled:

• Analyzed System requirement and designed modules for the database.

• Designed ER Diagram.

• Designed the System layout based on various levels of research and also Implemented design

for ETL Process.

• Image storing in database.

• Performance tuning and Database management.

Company: Clover InfoTech Private Limited, India (March 2008 to June 2009)

Position: Microsoft SQL server Database Administrator.

Clients Handled: Edelweiss India Private Limited, Ambit, Euronet Pvt ltd, Paternoster, Angel Broking,

MFGlobal, Kotak Securities.

Responsibilities Handled:

• Created and executed Stored Procedures, Triggers using T-SQL.

• Backed up & Restored databases and Server Migrations.

• Administrated Databases and provided live Support for MS SQL Server 2000, MS SQL Server 2005.

• Installed, Configured, upgraded and Maintained SQL servers.

• Created DTS Packages, Logins and Roles and provided grant rights.

• Managed scheduled jobs by initializing and checking its status. Troubleshooting errors.

• Index management in offload hours. Performance monitoring and Performance tuning.

• Implemented and monitored Logshipping and Replication.

• Prepared Monthly Service Reports for all servers. Provided detailed Reports using SSRS.

• File group management and space management. Scheduling and Running jobs

• and troubleshooting using SSIS

Contact this candidate