Sql Server Project
Resume:
Sharat Chandra Kanduri Mobile: 099********
E-Mail: qy8nc5@r.postjobfree.com
qy8nc5@r.postjobfree.com
JOB OBJECTIVE: Looking for opportunities to work in the field of database
design, development and administration (sqlserver, mysql) as a technology
expert and to become a significant contributor in a reputed company that
provides a highly challenging environment and opportunities to expose my
skills.
CAREER SYNOPSIS
. Good hands on experience on TSQL Programming.
. Have good exposure and hands on experience in SQL SERVER Business
Intelligence(SSIS, SSAS)
. SUN Trained - Mysql developer.
. Have hands on experience creating dashboards using Performance Point
Server (PPS )
. Can Install and work with Power pivot tools (Self Service BI) for excel
2010 and share point 2010
. IT experience of 4.5 years.
. Joined Wipro Technologies as a campus joinee from JNTU and worked for 2.6
years as project engineer.
. Currently Working for NTT DATA EAS INDIA PVT LTD, Hyderabad as Software
engineer for the past 2 years.
. Worked on ERWIN data modeller (Forward and Reverse Engineering).
. Cleared Business Unit Language Assessment Test (BULATS) while working in
Wipro Technologies.
Technical Experience Summary Table
[pic]
|Technology |Tools |Project |
| | |IDs |
|Self Service BI |Power Pivot for Excel and |1 |
| |Share Point | |
|Data Warehousing |SQL Server 2008 R2 |1 |
| |Integration | |
| |Services(SSIS),SSRS,PPS | |
|Databases |SQL Server 2000, SQL Server |1,2,3,4,5 |
| |2005,Mysql | |
|Modelling Tools |ERWIN Data modeller |1 |
|Development/Productivity Tools |PL/SQL, Visual Studio.NET |2,3,4 |
|E-Com Frameworks/Web Technologies|ASP.NET |4,5 |
|Functional Areas |Technical Documentation |1 |
|Programming Languages |C#, C/C++ |3,4,5 |
|Software Engineering |.NET Framework |4,5 |
|Methodologies/Tools/Technologies | | |
KEY PROJECTS HANDLED
1. KRUNCH BOX
|Description |It is a web based easy to use business intelligence |
| |tool which is used to give insight of the sales across |
| |various retailers and product .It is a wholesaler |
| |specific multiple retailer application providing data |
| |to analyse week, month, quarter,, seasonal half yearly |
| |and annual sales |
|Role |Designing and Developing SSIS packages and dumping |
| |weekly data into sql server databases |
| |Creating jobs with multiple steps to invoke packages |
| |and scheduling them accordingly to auto trigger the |
| |jobs |
| |Writing MDX queries on top of SSAS Cube and determine |
| |sales cube |
| |Creating cubes in SSAS |
| |Writing stored procedures and functions |
|Operating |Windows-server |
|System(s) | |
|Skills |SQL Server 2008 R2 database engine, Sql server |
| |Integration Services(SSIS),SSAS C/C NET Framework |
|Environment |Business Intelligence Development studio sql server |
| |2008 R2 |
|Contribution |Writing SSIS packages and dumping weekly data into sql |
| |server databases |
| |Creating jobs with multiple steps to invoke packages |
| |and scheduling them accordingly to auto trigger the |
| |jobs |
| |Writing MDX queries on top of SSAS Cube and determine |
| |sales cube |
| |Creating cubes in SSAS |
| |Writing stored procedures and functions |
|Start Date |17/12/2010 |
|End Date |Still working |
|Period |5 years |
|Team Size |15 |
|Other Information | Got Outstanding performance rating which is the top |
| |most rating in the organization for my contribution |
| |towards developing ETL packages and writing MDX |
| |queries |
2. ESIC
|Description |Employee state insurance corporation is a central |
| |government initiative which is basically meant to |
| |automate insurance benefits for central government |
| |employees. The entire project is divided into 4 |
| |different tracks and I work for HIS track (Hospital |
| |information system) which deals with complete corporate|
| |hospital features starting from patient registration to|
| |phlebotomy. HIS track consist of about 32 modules .Also|
| |worked on Insurance track administrating database and |
| |data migration activities |
|Role |Created stored routines in mysql with error handling |
| |mechanisms incorporated |
| |Administered database, optimized server parameter |
| |(configuration)settings |
| |Created users and granted roles respectively |
| |Implemented xml in mysql programming constructs |
| |Implemented nested procedures with inout kind of |
| |parameters |
| |Created cursors,views,triggers as part of stored |
| |routines and implemented business logic in database |
| |layer |
| |Implemented transactions and handled effectively |
| |transactional scope for nested routines |
| |Used different storage engines (Innodb,Myisam) for |
| |designing database in mysql |
| |Migrated table structures,views,stored routines from |
| |sql server to mysql as part of project requirements |
| |Used ERWIN data modeller for reverse engineering the |
| |existing application and created reports using the same|
| | |
| | |
|Operating |Windows-server(development), Sun Solaris(production) |
|System(s) | |
|Skills |MYSQL,ERWIN, SQL Server 2005 Integration |
| |Services(SSIS),SSAS C/C NET Framework |
|Environment |Mysql on windows server and Sun Solaris |
|Contribution |Created stored routines in mysql with error handling |
| |mechanisms incorporated |
| |Administered database, optimized server parameter |
| |(configuration)settings |
| |Created users and granted roles respectively |
| |Implemented xml in mysql programming constructs |
| |Implemented nested procedures with inout kind of |
| |parameters |
| |Created cursors,views,triggers as part of stored |
| |routines and implemented business logic in database |
| |layer |
| |Implemented transactions and handled effectively |
| |transactional scope for nested routines |
| |Used different storage engines (Innodb,Myisam) for |
| |designing database in mysql |
| |Migrated table structures,views,stored routines from |
| |sql server to mysql as part of project requirements |
| |Used ERWIN data modeller for reverse engineering the |
| |existing application and created reports using the same|
| | |
|Start Date |17/05/2009 |
|End Date |4/10/2010 |
|Period |5 years |
|Team Size |150 |
|Other Information | Awarded WIPRO-ESIC spot award for my contribution in |
| |reverse engineering existing models and generating |
| |module specific database models |
| |Cleared Business unit language assessment test (BULATS)|
| |with distinction while working in this project |
3. Reward Tracker
|Description |A point based reward tracking mechanism is being |
| |implemented for all employees in BTS FS TMT business |
| |unit. If an employee contributes in any non-project |
| |activity, he would be given few reward points. These |
| |points are accumulated at the end of each quarter. The |
| |employee who gets the maximum no. of points would be |
| |given the reward for that quarter. A simple tool called|
| |'Reward Tracker' a web application, developed to |
| |capture these reward points |
|Role |Database developer |
|Operating |Windows-XP |
|System(s) | |
|Skills |SQL Server 2005,PL/SQL,ASP.NET,C#,.NET Framework |
|Environment |Sqlsever 2008 Business Intelligence Development studio |
| |2008 |
|Contribution |Database design, Stored procedures, Reports (SSRS),Data|
| |migration(SSIS),SSAS |
|Start Date |29/12/2008 |
|End Date |23/4/2008 |
|Period |4 months |
|Team Size |5 |
|Other Information | cleared unified competency framework (UCF) Wipro |
| |internal competency assessment on sql server |
4. Operations Tracker
|Description |Ops tracker is a website completely dedicated for |
| |staffing purposes. It tracks the availability of |
| |resources, and helps project management teams to easily|
| |identify resources available and process further |
|Role |Database developer |
|Operating |Windows-XP |
|System(s) | |
|Skills |SQL Server 2005,Visual Studio.NET,ASP.NET,C#,.NET |
| |Framework |
|Environment |SQL SERVER 2005 Business Intelligence Development |
| |Studio |
|Contribution |Database Design, Stored procedures Importing Demand |
| |data from a predefined excel sheet into specified |
| |database tables using INTEGRATION SERVICES(SSIS) |
| |Created basic Reports using REPORTING SERVICES(SSRS) |
|Start Date |22/08/2008 |
|End Date |20/12/2008 |
|Period |4 months |
|Team Size |10 |
|Other Information | |
5. e-HR
|Description |E-HR deals with maintaining employee information and |
| |collaboration. e-HR is a HR management automation |
| |website. Functionality include leave management, event |
| |management, payroll, staffing, employee services etc |
|Role |Project Engineer |
|Operating |Windows-XP |
|System(s) | |
|Skills |SQL Server 2005,Visual Studio.NET,C#,.NET Framework |
|Environment |Sql Server 2005 |
|Contribution |Designed database structure and stored procedures |
|Start Date |20/05/2008 |
|End Date |19/08/2008 |
|Period |3 months |
|Team Size |15 |
|Other Information | Learned how to use SQL SERVER SSMS and the other |
| |advanced features that are newly added in sql 2005 |
6. Indian Social Security Number generation
|Description |The system generates a unique social security number on|
| |the basis of the information provided by the user after|
| |authenticating |
|Role |Programmer |
|Operating |Windows-XP |
|System(s) | |
|Skills |SQL Server 2000,ASP.NET,C#,.NET Framework |
|Environment |visual studio 2003 |
|Contribution |database design,stored procedures, database |
| |connectivity, Implementing business logic through c# |
| |programming language |
|Start Date |19/04/2008 |
|End Date |19/05/2008 |
|Period |1 month |
|Team Size |2 |
|Other Information | This project is part of my training in Wipro with this|
| |I have successfully Completed my training on .Net for |
| |3 months |
ORGANISATIONAL DETAILS
Career Summary:
Currently working for NTT DATA EAS INDIA PVT LTD, Hyderabad as Programmer
Analyst
PART-TIME ASSIGNMENT: june'07-dec'07 worked with Vijay Institute of
technology and science ., Nizamabad ad Associate professor. Handled
Programming languages like c and database concepts like RDBMS for first and
final year students.
TRAININGS/ WORKSHOP ATTENDED
V Attended Mysql training for developers and administrators course in
bang lore sun learning centre for 3 weeks
V Attended SQl BI and PPS (performance point server )training in Jan 2009
for 1 week
ACADEMIA
V B-Tech Mechanical Engineering, from JNTU Hyderabad with 77% in 2007
(First Class with Distinction).
V Intermediate from Gnanadeep jr college kamareddy with 92% in 2003
V SSC from Jeevadan convent high school kamareddy with 85% in 2001
KEY SKILLS, QUALITIES & STRENGTHS
. Professional Qualities: Persuasiveness, Analytical skills, good oral
and written communication
. Entrepreneurial Qualities: creativity and innovation, action
orientation and strategic thinking
. Personal Qualities: interpersonal sensitivity, flexibility, resilience
and self-motivated.
. Technical skills: Good working knowledge of MYSQL,SQLSERVER, Windows,
C language and SQL BI
EXTRA CURRICULAR ACTIVITIES & ACHIEVEMENTS
. Topper in school (2000 -2001 passed out)
. Stood 3rd in Mechanical Engineering branch in my graduation (2007
passed out)
. Organised trainings in SQL BI and PPS in Wipro which held in the month
of Jan 2009
. Awarded ESIC spot award while working in ESIC Project
. Presented Model at mechanical engineering students conference (MESCON
2006 ) on LDR automated railway gates and won first prize while in
graduation
PERSONAL DETAILS
Date of Birth : march 03, 1986
Languages Known : English, Telugu and Hindi
Address : Hno: 5-8-814 ashoknagarcolony kamareddy
Dist: Nizamabad
State: Andhra Pradesh pin: 503111
Home phone: 084**-******, mobile:
Other details:
Business Skills : Owner of valid two/four wheeler licence and
Indian passport
Father's Name : Dr.Lakshmi Narasimha charyulu Kanduri
Occupation : Teacher
Contact this candidate