ABHISHEK PUROHIT

MBA, LONDON, UK

B.TECH, INDIA

CELL: (0091) 808-***-****

E-MAIL: jnc2ts@r.postjobfree.com

ADDRESS: N0 425.9th Main Vijaynagar Bengalore- 560040

D.O.B : 08/02/1986

EXPERIENCE SUMMERY

Abhishek Purohit has almost 3 years of experience in Microsoft SQL SERVER 2008 Maintenance and Development.

His technological forte is Microsoft Technology namely SQL SERVER Reporting Services 2008/2005/2000 and his last project responsibilities involved gathering client requirement, analysis of business requirement, effective client communication, development/Support and maintenance of applications.

He has extensive exposure on creating numerous simple to complex queries involving Join, correlated sub-queries, CTE’s(Common Table Expression) and XML techniques for diverse business requirements, also Tuning and Optimizing queries by altering database design, analyzing different query options and indexing strategies.

CERTIFICATION

SQL server 2008, Database Development global certification from Microsoft.

SQL server 2008, Implementation and Maintenance global certification from Microsoft.

SQL server 2008, Business Intelligence, Maintenance and Development global certification from Microsoft.

SQL server 2008 international seminar organized by ODEON and approved by Microsoft in 2010, London.

QUALIFICATION

MBA (FINANCE)

University OF Wales, Institute of Cardiff, United Kingdom.

B.TECH (Computer Engineering)

West Bengal University Of Technology, Kolkata, INDIA.

TECHNICAL SKILLS

• Operating Systems : Windows XP / Vista

• Databases : SQL Server

• Languages : C, C++, Java, HTML, JSP

• Tools : MS FrontPage 2000, MS Access 2000, SQL Server

2000/2005/2008, SQL server 2008 reporting server, Business

Intelligence, Visual Studio 6, Crystal Report 8.5, Rational Rose 2003.

PROFESSIONAL EXPERIENCE

ODEON Pvt Ltd. London, UK December 2009 – October 2012

SQL SERVER 2008

Job Profile (Development)

Create Entity Relationship (ER) Diagrams to the proposed database.

Create database objects such as tables, views, stored procedures, Triggers etc.

Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.

Identify columns for Primary Keys in all the tables at the design time and create them.

Create functions to provide custom functionality as per the requirements.

Be aware of potential blocking, deadlocking and write code to avoid those situations.

Endure that the code is written keeping in mind any security issues such as SQL Injection.

Develop reports in SQL Server Reporting Services.

Design, Develop and Deploy SSIS Packages.

SQL SERVER 2008

Job Profile (Maintenance)

Daily check the SQL Error logs for any errors that may have occurred overnight. Check available physical Disk space (stored procedure). Check the Event Viewer. Periodic tuning and maintaining databases.

Daily check the jobs for failed completion. Check backups and log sizes. Monitor performance with PERFMON. Check for outstanding active or blocked transactions. (Stored procedure)

Weekly Run Indexing, Run Integrity checks.

Monthly perform monthly security audits on all logins and users to SQL Server. Perform physical disk fragmentation on data drives.

KEY ASSIGNMENT IN ODEON

Project Business Intelligence and Data Services

Customer Odeon (UK)

Period Feb 2010 – June2012

Description Automation of manual/Client reports on Cognos and data

Validation using DB2. This project required knowledge of SSRS

and based on same reporting was implemented.

Role Developer / Team Member

Highlights • Requirements gathering/analysis, designing and developing system database objects and Reports.

• Involved in the confidential User Details Testing, Bug Fixing and support.

• Periodically Integrity check and backup log files.

Language SSRS, SQL Server and DB2.

Tools Used Microsoft Team Foundation Server, IBM DB2 Server

Solution environment • SQL Server Business Intelligence Development studio (SSRS)

• MS Visual Studio 2008

• Server Edition: SQL server 2008/2005, DB2 2008

REFERENCE

Available upon request

Contact this candidate