www.HamaraShehar.com Pvt Ltd Hyderabad : Microsoft SQL Server Developer

[Admin]

HamaraShehar.com
HamaraShehar.com Pvt. Ltd.
http://HamaraShehar.com

Designation: SQL Developer (Microsoft SQL Server)
Experience: 2 - 3 Years
Location: Hyderabad / Secunderabad

Job Description
2+ years of exclusive SQL coding experience in Microsoft SQL Server 2005/2008
Good experience in large (125+ tables) logical/physical database design and PowerDesigner is a plus
Experience in SQL code review, performance tuning,data
export and import

Desired Candidate Profile
Extensive experience in writing complex stored procedures, functions,triggers and views using T-SQL for OLTP and reporting applications
Exp. in performance tuning, reverse engineering, version control, production deployment procedures.

Company Profile
HamaraShehar.com, an ISO 9001 company, established in yr 2000 by NRIs is a fast growing #1 Web Solutions
Co. in Hyderabad helping 3,000+ clients globally.
It provides end-to-end web solutions and the 1st Indian
ASP providing on-demand web services.

Address:
HamaraSheharcom Pvt Ltd
402A, Jade Arcade
Paradise Circle, MG Road
Secunderabad,AP,INDIA 500003

Telephone:
91-40-27813106

[Guest-IJT]

Name : BHANWAR SINGH RATHORE
Email : bhanwar_4210 AT rediffmail.com
Designation / Skillset : desktop engineer support

Resume :
CURRICULAM VITAE
BHANWAR SINGH RATHORE

OBJECTIVE
To contribute effectively to the growth of the organization and enhance my technical and inter personal skills coupled with overall personality development ensuring excellent prospects in relevant fields.
COMPUTER SKILLS
Languages : VB.Net, HTML, C++.
RDBMS : MS-Acess, MS-SQL server7.0/2000/2005.
Operating System : Window 98/NT/2000 Pro/Server/XP/MS-Dos.
MS-Office Tools : MS-Office 97/2000/2003/2007
PC Maintenance : Bios Setting, Operating System Installation, Boot Setting, PC Assembling, Basic Networking and Printer repairing.
PROFESSIONAL QUALIFICATION
- 18 Months Higher Diploma in Software Engineering HNIT from NIIT.
EDUCATIONAL QUALIFICATION :
- Pursuing M.Sc (C.S) from Vardhman Mahaveer Open University Kota.
- Completed PGDCA from Vardhman Mahaveer Open University Kota.
- Completed B.Sc (IT) from NIIT Beawar.
- Higher Secondary (12th Commerce) from Rajasthan Board Ajmer.
- Secondary from Rajasthan Board Ajmer.
PRACTICAL EXPERIENCE
- One year work in Paras Milk as an Asst. IT Executive.
COMPANY PROFILE : PARAS MILK V.R.S. FOOD Ltd. Gulaothi Bulandshaher in Uttar Pradesh.
- Now I am working at Shree Cement Transport handling Computers and Printers as Desktop Support Engineer.
COMPANY PROFILE : SHREE CEMENT Ltd, Bangur Nagar Beawar Distt.Ajmer in Rajasthan.
KEY STRENGTH
- I am fast learner, team worker, self motivated & Helpful adaptable to any corporate culture.

Date :…………..
Place :…………
BHANWAR SINGH RATHORE
-------------------------------------------------------
More Information about this submission and submitter :-
___________________________________________________
Submission ID : 4272063
Date & Time : 19th Jun 2011 7:47 AM (UTC)
IP Address : 182.156.229.72
Browser Info : Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; GTB7.0; BTRS7181; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506; InfoPath.2)
Predicted Country : --

[Guest]

ARAVINTH.G
E-Mail : aravinth.it04 AT gmail.com
Profile
1 Involved in projects using SQL SERVER2000/2005 AND MYSQL.
2 Exposure in Crystal reports design
3 The Strong Back-End Knowledge & Experience in SQL SERVER 2000/2005 & MYSQL
Educational profile
1 BTECH-IT (72%) - A.V.C College of Engineering, Anna University (2006 -2010).
2 Xii (80%) - D.B.T.R National Higher Secondary School, Mayiladuthurai (2006)
3 X (94%) - D.B.T.R National Higher Secondary School, Mayiladuthurai (2004)
Professional experience
Working as a SQL developer at Kadamba Technologies pvt.Ltd., Chennai from August-2010 to till Date.
Technical Skills
Database Tools : SQL Server2000, 2005 & MySQL
Applications : MS-Office 2000/2007
Project Level Responsibilities
- Understanding requirements from the user’s specification.
- Developing flowchart and pseudo-code algorithm for the program application.
- Macro level review and unit testing for the same application.
Project summary
Company : Kadamba Tech, Chennai, India.
1 Project#1 : KPI Monitoring System.
Duration : 4 months.
Technology : Dot Net Frame Work 3.0, Asp.Net,Ado.Net, SQL
Server2005 and AdobeFlex3.0.
Client : Daimler India vehicles corporation pvt.ltd Chennai.
Responsibilities : Implemented stored procedures ,Functions and Database Maintenance
Description : In this project, 19 KPI screens are there. They’re as follows
1. Percentage Number of Timeline Milestones Achieved to Missed
2. Average delay in Timeline Milestones & Top Timeline Milestones Delays
3. Time Duration from RfQ to PO Planned Vs Actual
4. Utlization of Allocated Budget
5. Escalation In Price of Commodity (Cement, Steel – Structural & Reinforcement And Asphalt) Plan Vs Actual
6. Cashflow status - Plan Vs Actual status - Graph
7. Budget Status
8. Top 10 Changes
9. Reasons for Change
10. Weekly Progress of Civil
11. Weekly Progress of FM
12. Weekly Progress of ME
13. Total Safety Violations, Accidents & Incidents
14. NPM awarding volume increased significantly, huge savings generated with global leverage potential
15. NPM awarded Volume of Buy ramp-up in MEUR (based on actual awarded value)
16. Progress of Plant Project bid packages PO awarding
17. Risk Status
18. Number of created Q-Process descriptions
19. Functional training man days/employee
Each screen indicates the performance of employees. Here actually Data retrieved from database based on some calculation and integrated with flex component through web services. Each screen is one of the departments of Daimler.

2 Project#2 : Quality Management
Duration : 3 Months.
Technology : Dot Net Frame Work 2.0, C#.net, Asp.Net, Ado.Net, SQL
Server2005,Crystal reports and AdobeFlex3.0.
Responsibilities : Implemented stored procedures, Functions and Database Maintenance
Client : Daimler India vehicles corporation pvt.ltd Chennai.
Description : In this project, 11 KPI screens are there. They’re as follows
1. Scorecard
2. HDT/LDT Concern status
3. MB Actros Concern status
4. C & D-sample vehicles audited
5. Q target (Durability) Conformation
6. MB Actros PDI Pass Rate
7. Implementation of Ds (Safety Relevant) characteristics at supplier end - Plan Vs Actual
8. Service Check points closure status - HDT & LDT
9. Number of created Q-Process descriptions
10. Functional training man days/employee
11. Utilisation of Support SLA Vs Plan
The QM are classified into four Perspective, they are internal process perspective, customer process perspective, employee perspective and financial perspective. Scorecard screen is the overall view of the project and other screens indicates the quality of employees and training employees. Each screen is one of the departments of Daimler.
3 Project#3 : Actros Operations Monitoring System (AOMS)
Duration : 3 Months.
Technology : Dot Net Frame Work 2.0, C#.net, Asp.Net, Ado.Net, SQL
Server2005,Crystal reports and AdobeFlex3.0.
Responsibilities : Implemented stored procedures, Functions and Database Maintenance
Client : Daimler India vehicles corporation pvt.ltd Chennai.
Description : In this project, 11 KPI screens are there. They’re as follows
1. Stockyard
2. Aging status
3. Maintenance scheduke
4. Repair status
5. Sales Status
6. Transaction
7. Status Overview
The objective of the Actros Operations Monitoring System (AOMS) is to create a CAQ tool for an improved paperless dispatch management of the MB Actros trucks.
The scope is to design, develop, test and deploy an IT tool including these key features such as Vehicle Database, Initial Data Entry as SAP input
Screens : Transactions, Tracking, Stockyard view
Transactions & Vehicle History Tracking, Printout functionality, and
Authorization & Authentication.
4 Project#4 : Trend Analysis
Duration : 2 years
Technology : Dot Net Frame Work 2.0, C#.net, Ado.Net, Asp.net, VC++, SQL
Server2005, Crystal reports, Adobe Flash and VB.
Responsibilities: Implemented stored procedures, Functions and Database Maintenance.
Client : Prozone sports (UK).
Description : Football’s leading multi-game analysis database allows you to identify key trends in player and team performance. The benefits are in terms of physical performance, work rate, tactical and game specific skills are unsurpassed. The Prozone system provides a dynamic and unique insight into the team’s performance.
http://www.prozonesports.com/products.html
5 Project#5 : Cricket21
Duration : 9 Months
Technology : Dot Net Frame Work 2.0, C#.net, Asp.Net, Ado.Net, SQL
Server2005,Crystal reports and AdobeFlash.
Responsibilities: Implemented stored procedures, Functions and Database Maintenance

Client : Own product.
Description : Cricket21 presents the pioneering multi-match analysis software for your team’s performance analysis and opposition scouting.
Team Analysis:
The software provides interactive graphics and stats for:
1. KPI monitoring
2. Team individual & Match Stats
3. Tactical & technical preparation of the player.
4. Analyze multiple games in-depth the graphically & statistically
Opposition Analysis:
1. Team, unit &player level analysis.
2. Player graphic analysis’s across multiple games.
3. Study strengths & weakness of individual players across games and formulate plans for each oppositional player.
4. Interactive graphics with multiple filters.
5. Study player in-depth:
- Batsman by runs, strokes, dismissals, dotballs, boundaries
- Batsman performance against bowler, style, delivery type
- Subjective- beaten appeals, uncomfortable edges & dismissals.
- Batting in phase of play (Power play, Middle over, End over)
- Batting in first 10 balls of all his innings.
- Bowlers perform runs, dotballs, wickets, boundary balls, speed
- Bowler performance RHB/LHB
- Bowler variations (swing bothwise, both cutters, googly, doosra, armball)
- Use of slow ball, Yorker & bounce.
- Summary and report of Do’s and Don’ts
- Detail presentation report of strength and weakness.
6. Form Guide
7. Summary and detail report of players strengths & weakness
http://www.cricket-21.com/
6 Project#6 : Matrix Stores screening system
Duration : 3 months.
Technology : Dot Net Frame Work 2.0, C#.net, Asp.Net, Ado.Net,
MySQL.
Responsibilities: Implemented stored procedures, Functions and Database Maintenance

Client : Matrix BS India Chennai.
Description : In this Project Audited data can be uploaded into our Database and can be taken as either excel or pdf file format with final status based in some calculation and also Master can be edited(phase 1),Audit can be created and viewed(phase 2) and report can be taken(phase3).
Project consists of three phases.
i. Data Master
1. client
2. dist
3. branch
4. storetype
5. store
6. hub and assosiate
7. cat and brand
8. parameter
ii. Audit
1. create audit
2. upload auditdata
3. view audit data
iii. Report
1. audit report
2. stores not audited
3. remarks
4. average score
5. consistency