Sql Server Developer
Resume:
Experience Profile
Experienced MSBI developer with 4.3 years in building, maintaining and troubleshooting business intelligence solutions built using Microsoft Business Intelligence Platform (MSBI).
Core skills include
Experience in ETL (Extracting, Transforming and Loading) development using SSIS (SQL Server Integration Services)
Have worked in multiple projects as Business Intelligence Developer in Designing ETL Packages and implementation stages of the Project according to client requirements.
Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, FTP Task, File System Task, Send Mail Task and Data Flow Task in Designing packages.
Experience in creation of complex reports using SSRS (SQL Server Reporting Services) and knowledge in creation of Cubes using SSAS (SQL Server Analysis Services).
Knowledge in Dimensional Data Modeling, Star Schema modeling, fact and dimension table design.
Experience with Database Backup and Recovery procedures along with creation and Configuring jobs using SQL Job Agent.
Educational Qualification
Post Graduate Diploma in Information Technology (PGDIT) [68.65%] from Symbiosis Centre for Distance Learning, Pune, India.
Bachelor of Engineering (BE) [79.85%] from Vishweshwaraya Technological University, Belgaum, Karnataka, India.
PLUS-TWO [81.66%] from Smiore Vyasapure College, Hospet, Karnataka, India.
SSLC [84.16%] from Deepayan English Secondary School, Hospet, Karnataka, India.
Professional Experience
1)Worked as Module Lead at Mindtree limited from Dec 2012 – August 2015.
2)Worked as Senior Developer at Sporting Mindz Technologies from Jul 2010 – Mar 2011.
3)Worked as Software Engineer at Pioneer Computing Technologies from Nov 2008 – Sep 2009.
Skill Set Summary
Programming Languages:
T-SQL
RDBMS & Tools:
SQL Server 2005/2008, SSIS, SSAS, SSRS
Experience Summary:
Project Name: AmEx ARC
Client : American Express, Gurgaon, India
Dates : Apr-2014 till May-2015
Technologies: Microsoft Business Intelligence Studio, SSAS, SSIS, SSRS, SQL Server 2012, Transact-SQL.
Description: To build end to end MIS Reporting system for various markets
Role : Senior BI Developer
Activities undertaken:
Understand requirements as stated in the Business Requirement document
Develop SSIS packages, SSAS cubes and Reports with MDX and SQL queries.
Independently handled the project.
Have taken knowledge sharing sessions in the team.
Project Name: Realogy
Client: Realogy Services Group, USA.
Dates : Jan- 2013 to Apr - 2014
Technologies: Microsoft Business Intelligence Studio, SQL Server, Transact-SQL, SSRS.
Description: The project was to create complex SSRS reports for the client which included showing Maps for the different listings selected.
Role: Senior Developer
Activities undertaken:
Understand requirements as stated in the Business Requirement document
Developed Business Reports for the Project (SQL). Unit Testing of the Reports. Given support in UAT and SIT.
Implemented Change Requests. Written advanced SQL queries for the report development.
Created reports which included MAPS to show the address of a property. Worked on graphical charts in reports of a property.
Project Name: SVG Diamond Reports
Client : SVG Advisers Limited, UK
Dates : Feb-2013 to Jun-2013
Technologies: Microsoft Business Intelligence Studio, SQL Server 2008, Transact-SQL.
Description: This project is the second phase of SVG’s “Management Information (MI) Phase 3 - Dashboards and Reporting Project". The main objective of the project was to elicit the detailed requirements to automate critical reports and dashboard for SVG.
Role : Senior Developer
Activities undertaken:
Understand requirements as stated in the Business Requirement document
Developed Business Reports for the Project (Both MDX and SQL).
Unit Testing of the Reports.
Given support in UAT and SIT.
Implemented CRs.
Written advanced MDX queries for the report development.
Created re-usable functions in SQL Server.
Project Name: flikVAULT
Client: Royal Challengers Bangalore, India
Dates : Jul-2010 to Mar-2011
Technologies: Microsoft Business Intelligence Studio, SQL Server 2008, Transact-SQL.
Description:
flikVAULT is a Library Software where the user can get the profiles for players, physios and
trainers. Also the performance of the players can also be evaluated.
The following are the objectives of the software.
Management of Academy including Coach/Trainer/Physio.
Schedule Management of all members including Players.
Player Statistics, Schedule, Fitness and Injury Reporting.
Coach Evaluation Report.
Role: Senior Developer
Activities undertaken:
End-to-end software design and development.
Database design & development. Designed tables, stored procedures and triggers.
Developed reports in SSRS.
Unit testing
v
Project Name: TPM-Trak
Client: Bajaj, Bosch, Maini
Dates : Nov-2008 till Sep-2009
Technologies: Microsoft Business Intelligence Studio, SQL Server 2008, T-SQL.
Description: TPM-Trak is a suite of products to drive productivity in manufacturing companies. It provides the management with actionable manufacturing intelligence, based on accurate live production data from the shop floor. It has won the prestigious CMTI-PMT award for “Best Design of the Year – 2007”.
Role: Software Developer
Activities undertaken:
Instrumental in design, development and testing of Smart Manager and Cockpit modules.
Educate customers and field engineers on how effectively TPM-Trak could be used.
Scaling up the product for meeting the customer requirements.
Personal Details:
Father’s Name : Mallikarjuna Swamy Hiremath
Mother’s Name : Kavitha Hiremath
Spouse’s Name : Nrupesh K M
Date of Birth : 12-07-1986
Gender : Female
Passport No. : L1357474
Languages Known : English, Kannada & Hindis:
Declaration:
I assure to be an efficient candidate and hope details given above will suffice your needs for me to apply for the job.
Date:
Place: (Kusuma Hiremath)
Contact this candidate