RESUME

MAHESH KUMAR S

Address :#***,**** ****, ******** ***** ,BSK 3rd Stage,Bangalore-50

Phone : 096********

E-Mail : xp28vw@r.postjobfree.com

Experience : 1 Years 8 months

Current Company:HCL Technologies (Hyderabad, Microsoft Account)

Career Objective

• To work in an inspiring environment where I can learn new things and enhance my skills that are useful to promote the growth of the Organization and my career.

• To work in a challenging environment and gain experience in working as part of a team to research and develop new software products.

• To use my skills in the best possible way for achieving the company’s goals.

• To build a long-term career in IT profession with opportunities for career growth

Experience Summary

1. Working as Software engineer in HCL Technologies in BIS domain(MSBI) from Sep 2010 to till date.(17 Months)

2. Worked as Project trainee as a part of Academic project for 3 Months in

Tech Mahindra.

3. Currently Working as BI developer in Microsoft Project.

4. Currently working in Multiple Microsoft development projects

5. Possess good understanding and hands-on SQL Server 2008 R2.

6. Possess good understanding and hands-on SSIS, SSRS and SSAS.

7. Good Understanding of Data warehousing and ETL concepts.

8. Good Understanding of Development of SSRS , Power Pivot Reports.

9. Got twice Customer appreciation for successfully handling the critical issues on time.

10. Got Outstanding rating in the recent Annual performance and development review.

11. Presented a Technical White Paper on 'Excel Automation from a Survey Site'

Educational Qualification

BE (Computer Science and Engineering) from RNSIT ,Bangalore in the year 2010

Course College Sem Percentage

BE

RNSIT,Bangalore 1 86.19%

2 86.19%

3 83.22%

4 80.22%

5 76.00%

6 73.55%

7 76.22%

8 81.90%

12th std GPUC,Sagar 80.33%

10th std JuniorCollege,Sorab 85.28%

Project Experience:

Project 1 :

Company : HCL Technologies

Name : Microsoft OurBI

Client : Microsoft

Team Size : 6(4 Offshore and 2 Onsite)

Role : BI Developer

Duration : Jan-2011 to Oct-2011

Description : Microsoft OurBI is an Production Support/Enhancement project. It includes complete end to end enhancement of existing servers which include development of new SSIS packages, changing the existing Cube , changing the existing Report Model, Development of new SSRS Reports as per the client requirement.

• Involved in the Enhancement of the existing data Model.

• Involved in the Architecture design and data model design for the existing data model.

• Implemented the Error handling and auditing by creating the new SSIS packages for the existing data model.

• Involved in Development of many SSRS reports based report model, reports based on cube as per client request.

• Created the stored procedures for doing the SLA calculation for the existing data model.

• Also gained the knowledge of share point server, TFS, writing scripts using C#

• Worked with a SQL server Agent to create and schedule SQL server jobs

• Involved in Unit Testing and preparing test cases.

• Created many SSIS packages for incremental data load.

• Created SSRS reports for monitoring SharePoint reports.

• Single handedly created many SSRS chart reports and Matrix reports which are based on report model

• Also gained the knowledge of SSAS by adding the new attributes, doing the changes to the existing attributes in a Cube.

• Involved in unit testing of Cube and Report model

• Developed a dashboard reports which comprises of different types of chart reports.

• Did Analysis for the many TFS items which are critical and solved these TFS items within a SLA defined.

• Created the Many power Pivot Reports as per the Client Requirement.

Excel Automation:

Planned and implemented an alternative solution to FTP setup to transfer/copy files from a survey website to the desired physical location. Proposed solution consists of subscribing in a survey website with a specific account which has access to it and schedule the excel sheets So that every day we will get all the required excel sheets as an attachment in a mail to the account that we used for subscribing. Then create a Rule in an outlook that will automatically call the MACRO script whenever it receives mail from the survey site. This macro script will rename the excel sheets and saves these files in physical location. After these files are saved, ETL will pick up these files , it does validation of these files and finally it loads the data. Finally it sends the mail to the users which tells the count of records which are loaded from each excel sheet

• Wrote a Macro script that will be automatically called whenever the Outlook configured with some account receives mails with excel attachments. This macro will automatically renames attachment and saves in a physical location.

• Developed an SSIS package which has script task that will check whether the attachments are received for that particular day or not, if not it will send the notification to the user for the missing files.

• Developed an SSIS package that will load the data once all the attachments are received and also it sends the notification mail containing the details of record count.

Project 2 :

Company: HCL Technologies

Name : IEB-DQP (Interactive Entertainment Business-Data Quality Project)

Client: Microsoft

Team Size :5(4 offshore and 1 onsite)

Role : BI-Developer

Duration : October-2011 to till Date

Description : DQP is a complete development project. Requirement is to provide a .Net front end to set up data quality rules among the different servers and to create SQL server agent jobs which includes these rules. Main requirement is to provide an MSBI solution to achieve the data quality.

• Involved in the complete analysis of requirement and understanding of the requirement.

• Involved in the complete Architecture design as per the client requirement.

• Created prototype for the different business template like Null validation, Data freshness, Aggregation, Row Count, Range Validation, Value distribution etc.

• Wrote many stored procedures to process different Business templates like Null validation, Data freshness, Row Count, Range Validation, Value distribution etc.

• Also wrote Master stored procedures to handle the parallel execution of rules to improve the performance.

• Created the SSIS packages to integrate all the Business templates and to handle the dependency among the rule execution.

• Created the Master package to handle the job dependency and execution.

• Involved in the complete testing of the MSBI solution provided to handle the Data Quality.

Technical Skills:

Operating system :windows xp,Fedora.

Languages :C,C++,C#, T SQL ,Basics of Java and .net

Tools Learnt :

• SQL Server 2008 R2

• SQL Server Integration Services (SSIS)

• SQL Server Reporting Services (SSRS)

• SQL Server Analysis Services (SSAS)

• Knowledge of working with Share point, Report Builder and TFS

• Also have knowledge on PL-SQL,ETL tools like OWB

• Also have Knowledge on Power Pivot Excel report

Academic Project Experience:

Project1

Company : Tech Mahindra

Tattle : Network watcher

Description : Net watcher is a remote desktop application, it involves remote monitoring of all the systems connected in a network.

Team Size : 2 number

Project2

Title : Aircraft Collision detection using GPS data file

Description : Design a simulator to monitor the various aircrafts using a GPS data file, determining the various parameters of aircraft and generating an alert when an aircraft approaches to a collision.

Team size : 2 Number

Project3

Tittle : Brahmanda

Description :Design a Graphical simulation of solar system and providing a 3D view of Solar system which includes some features such as zoom in, zoom out of planets.

Team Size : 2 number

Guide : satishkumar

Personal Information:

Father’s Name : Chandrappa S

Date of Birth : 10-08-88

Nationality : Indian

Languages Known : English, Hindi, Kannada

Strengths:

1.Creative,Curious,consistant,Commited to work.

2.Ability to successfully handle and deliver any task that is assigned to me despite of time constraints or resource crunch.

Achievements:

1.Topped taluk in 10th exam and got many awards for that.

2.Represented school team in badminton and cricket.

Contact this candidate