Sql Server, SSRS, SSIS, Datawarehousing Sharepoint Concepts, Hadoop,C#

SHEMIL MOHAN

E-Mail: ********@*****.***/ ********@*****.***

Contact: 050-*******

A BRIEF OVERVIEW

An accomplished Software developer with more than 4 years of experience in customer driven industries like

BFSI, CRM and Sales. Key strengths include communicating directly with customers for requirements, analysis,

design, implementation and support. Possess the flexibility to accomplish projects independently or within a

diversified team of other IT professionals. I am a self-motivated individual with the desire and ability to conquer

new career challenges that will expand my technical and non-technical skill sets.

CAREER OBJECTIVE

To be a part of highly esteemed organization, where I can utilize my skills & abilities and grow with the

organization.

EMPLOYMENT HISTORY

Software Engineer

Hexaware Technologies Ltd., Mumbai from April 2010 – Till October 2013

Web Application Developer

RAUN GROUP, Mumbai from November 2009 – April 2010

Management Trainee

Millennium, Mumbai from October 2009 – November 2010

TECHNICAL SKILLS

Database MSSQL Server2008R2/2008/2005, MySQL, Hive

BI Tools SQL Server Integration Services (SSIS) 2008 R2/2008/2005, SQL Server Reporting

Services (SSRS) 2008 R2/2008/2005, Datawarehousing concepts

SharePoint (Basics) SharePoint Server 2010/MOSS 2007/WSS 3.0, SharePoint Designer

Languages & Web C#, HTML, JavaScript, Unix

Technologies

Version Controls TFS 2010, VSS

Platforms & Environment Windows 7/Server 2003/ XP, Hadoop, Ubuntu 12.04

IDE Microsoft Visual Studio 2010/2008/2005

EDUCATION

2009 MCA from IMSCD&R, Pune University; secured 61%.

2006 B.Sc.(I.T) from T.E.S College, Mumbai University; secured 64.8%.

2003 XII from T.E.S Junior College, Mumbai, Maharashtra board; secured 70.5%.

2001 X from C.P.V School, Mumbai, Maharashtra board; secured 74.4%.

PROFESSIONAL EXPERIENCE

Hexaware Technologies Ltd., Mumbai

Project 1:

Project Name : ARMS

Role : Lead/Developer

Team Size :5

Environment : SSRS 2008 R2, SQL Server 2008 R2

Duration : June 2013 - Till date

Tools Used : BIDS 2008 R2, SQL Server 2008 R2, Visual

Studio, Axure 5.6 RP

2010

Description: The client is one of the largest professional service firms in the world and one of the Big Four

accounting firms. It has 4 main services: Assurance service, Tax service, Advisory service and Transaction

Advisory service. For its ARMS (Resource Management System) module the Client wished to migrate the

application to MVC3 and its Crystal Reports to SSRS 2008 R2.

Role and Responsibilities:

Development of SSRS Reports by viewing the existing Crystal Reports.

Unit testing of the Reports on Development Environment.

Analyzing the Crystal Reports and assigning tasks to team members.

Migrating from SSRS 2008 R2 to SSRS 2008 due to sudden change in requirement.

Training the team members on SSRS to help them become comfortable to work on it.

Creating mockup screens and wireframes for client demo using Axure 5.6 RP.

Error Tracing and Bug Fixes.

Addressing Client’s issues and concerns.

Client Communication, Meetings, Calls, Mailings and WSR.

Project 2:

Project Name : Consultation DB

Role : Developer

Team Size :3

Environment : SSIS 2008 R2, SQL Server 2008 R2

Duration : May 2013 - Till date

Tools Used : BIDS 2008 R2, SQL Server 2008 R2, Visual

Studio

2010

Description: The client is one of the largest professional service firms in the world and one of the Big Four

accounting firms. It has 4 main services: Assurance service, Tax service, Advisory service and Transaction

Advisory service. For its Consultation DB module the Client wished to create the Consultation site through which

they can manage the entire consultation workflow process for their Consulting Department. This includes creating

the team for consultation, their approvers, users entering their observations, administration activities etc.

Role and Responsibilities:

Development of SSIS packages to load the data from different sources into the Consultation DB

as per the requirement.

Unit testing of the ETLs on Development Environment.

Design implementation plans and writing Stored Procedure.

Creating tables, views and indexes depending on the requirements.

Doing the DBA activities like backup, restore, attach/detach databases, Log shipping, database

clean up, configure database mails, Create DB Links, reviewing the scripts before running on the

production environment, deployments etc.

Error Tracing and Bug Fixes.

Migrate the unit tested SSIS packages from Development to UAT Environment.

Addressing Client’s issues and concerns.

Client Communication, Meetings, Calls, Mailings and WSR.

Project 3:

Project Name : Account Team Site (ATS)

Role : Developer

Team Size :3

Environment : SSIS 2008 R2

Duration : February 2013 - May 2013

Tools Used : BIDS 2008 R2, SQL Server 2008 R2

Description: The client is one of the largest professional service firms in the world and one of the Big Four

accounting firms. It has 4 main services: Assurance service, Tax service, Advisory service and Transaction

Advisory service. For its ATS module the Client wished to create the ATS site in a cloud environment that would

integrate data into ATS from the following source systems: CRM’s Interaction data (CII), GFIS, ARD, GHR,

Client Connection etc. For this SSIS 2008 R2 was used as an ETL to pull the data from the above mentioned

source systems into the ATS area.

Role and Responsibilities:

Development of SSIS packages to load the data from different sources into the ATS as per the

requirement.

Unit testing of the ETLs on Development Environment.

Design implementation plans and writing Stored Procedure.

Creating tables, views and indexes depending on the requirements.

Error Tracing and Bug Fixes.

Migrate the unit tested SSIS packages from Development to UAT Environment.

Addressing Client’s issues and concerns.

Client Communication, Meetings, Calls, Mailings and WSR.

Project 4:

Project Name : Proof Of Concept on Hadoop (POC)

Role : Developer

Team Size :2

Environment : SQL Server 2008, MySQL, Hadoop, Ubuntu 12.04

Duration : December 2012 – February 2013

Tools Used : SQL Management Studio, MySql WorkBench, Hue, Sqoop

Description: To understand the concept of Hadoop and its capabilities as compared to SQL Server and MySql in

terms of processing data. To identify the necessary requirements that is required to setup Hadoop and its

limitations. Test the performance of Hadoop as compared to MySql.

Role and Responsibilities:

Responsibilities were to understand the concept of Hadoop and its benefits as compared to SQL Server

and MySql.

To download the pre-requisites and installing them on the machines for the setting up of Hadoop

environment.

To make MySql queries and its equivalent query in Hive (RDBMS for Hadoop) and run them to make the

observations.

Document all the observations along with the steps that we had followed to create the Hadoop

environment.

Code Review, Unit Testing, Deployment Documents and Handling Deployments.

Project 5:

Project Name : CRM Reporting

Role : Developer

Team Size :2

Environment : SSIS 2005/2008, SSRS 2005/2008

Duration : April 2010 - December 2012

Tools Used : BIDS 2005/2008, SQL Server 2005/2008

Description: The client is a major Financial Institute in USA. For CRM module the Client had a set of reports

which was developed using SSRS as reporting tool. We had to generate reports for the products sold by the call

center agents and representatives for various clients. They also had a requirement of creating SSIS packages to

migrate data from Excel, Notepad to the SQL Server 2005/2008 database and vice versa.

Role and Responsibilities:

Responsibilities were to analyze work orders assigned to me, design technical documents, query logs,

impact analysis document and get them approved from the clients/on-site coordinator before getting into

the actual development.

Design implementation plans and writing Stored Procedure.

Creating SSIS packages like export data to excel file from the database and vice versa, move data from

one database to another, export data to csv files from the database etc.

Creating SSRS reports like drill-down reports, sub-reports, linked reports and charts.

Code Review, Unit Testing, Deployment Documents and Handling Deployments.

Client Communication, Meetings, Calls and mailings and WSR

Coordination with DBAs for deployments and any deployment related issues.

RAUN GROUP, Mumbai

Project 1:

Project Name : Payroll System

Role : Web Application Developer

Team Size :4

Environment : SQL Server 2005, HTML

Duration : November 2009 – April 2010

Tools Used : SQL Management Studio, Microsoft Visual Studio

Description: To develop the Payroll System for the organization so as to streamline the payroll process of the

employees within the organization.

Role and Responsibilities:

Responsibilities were to understand the requirements and create a document mentioning the same.

To develop the stored procedures and queries to help retrieve the appropriate data for the payroll system.

To write the HTML code for designing the User Interface (UI) and creating the Style Sheets (CSS).

Document all the observations along with the steps that we had followed to create the Hadoop

environment.

Millennium, Mumbai

Role : Management Trainee

Duration : October 2009 – November 2009

Description: Worked as a Third Party Sales Agent to raise funds for a well-known NGO in India.

Role and Responsibilities:

Responsibilities were to set targets for myself in terms of raising funds and going about to achieve it.

To visit both corporate offices (during weekdays) and residential buildings (during weekends) to raise the

funds.

Attend the weekly team meetings and discuss the progress and the plan of actions.

BEYOND ACADEMIA

Pivotal in various sports and cultural activities in school and college.

Excelled as a member of Sports Committee during post-graduation.

Winners of the volley-ball competition during post-graduation.

Winners of the cricket tournament in school.

PERSONAL DETAILS

: 18th June 1985

Date of Birth

Nationality : Indian

Languages Known : English, Hindi, Malayalam, Marathi

Address : C/o: Mr.M.A. Raghunathan, Post Box 6442, Dubai.

Passport Number : H1312332

Visa Status : Tourist Visa (valid until 24/12/2013)

Contact this candidate