www.ihs.com solutions India Pvt Ltd Bangalore : Database Administrator/SQL Server

[Admin]

IHS solutions India

Company profile:
IHS solutions serve customers in the aerospace and aviation, architecture / engineering / construction, automotive, electronics & electrical, government & military, petrochemical, energy, telecommunications and utilities industries. IHS is the Engineering division of IHS Inc.

IHS India is an Indian arm of IHS Inc's engineering division and we are based at Bangalore.
For more details view www.ihs.com

Designation Sr. Database Administrator/SQL Server

Job Description
Ability to manage MS SQL 2000/2005 servers installations
- Experience with development of DTS and SSIS packages for loading data to applications
- Experience with replication and full text indexing
- Ability to support complex SQL query and stored procedure development
- Ability to do performance analysis and tuning of MS SQL installations

Desired Profile
Ability to manage MS SQL 2000/2005 servers installations
- Experience with development of DTS and SSIS packages for loading data to applications
- Experience with replication and full text indexing
- Ability to support complex SQL query and stored procedure development
- Ability to do performance analysis and tuning of MS SQL installations

Education: BE/BTech in Computers
Experience : 4-6 years

Contact IHS India

Website http://www.ihs.com

Contact Us
IHS India Pvt. Ltd.
132, DivyaSree Technopolis
Yamalur Post, Off Airport Road
Bangalore, INDIA 560037
E-mail : hrindia@ihs.com
Tel. (80) 30288973

[Guest-IJT]

Name : Tejas Shah
Email : tejasshah712 AT gmail.com
Designation / Skillset : Java, Android, Oracle, C#, SQL

Resume :

Academics Bachelor of Science – Information Technology from Mumbai University
Work Experience System Administrator at HM Coaching Classes
- Windows Server 2003 Installation
- Microsoft Outlook email server installation and administration
- Anti-virus installation and maintenance
- VB 6.0 / MS-Access based winforms application development
Profile :
Career Objective - To take on new challenges and responsibilities where I can efficiently and effectively utilize my technical skills to achieve the set goals.
Profile - Competent in object oriented languages programming
- Constant and active focus on evolving mobile apps development and web technology especially related to user-interface design.
- Experience on java server-side programming
- Problem solving and workflow systems analysis attitude
- Professional in manner and appearance with strong interpersonal skills.
- Well organized, detail oriented, responsible, good work ethic, and ability to learn quickly.
- Clear communication skill and positive attitude in face-to-face situation.
Academics Appeared For B.Sc.IT (May, 2011) From Mumbai University (Awaiting result of last semester)
60.83% ( Aggregate - I,II,III,IV,V Semesters)
Technologies :
Operating
Systems / Platforms - Windows XP, Windows 7, Windows Server 2003/2008
- Linux
Programming Languages - Java 1.5 / 1.6
- C# .net 2.0, 3.5, 4.0
- Java Script
- VB Script / VB.net
Presentation and Web Technologies - Java Server Pages
- ASP.Net 4.0 Web
- Winforms Development
- WPF Development
- HTML 5.0
- CSS
Mobile Technology - J2ME (MIDP 1.0 & 2.0, CLDC 1.0 & 1.1, CDC, Blackberry)
- Android application development
Database - Oracle 9i
- Microsoft Access Database
Server Side - Java – J2EE Development
- Web-services development
IDE - Eclipse for Java and android application development
- Microsoft Visual Studio 2010
- NetBeans
Web Server - Apache Tomcat
System Design Skills & Tools - Use-case diagram
- Class-Diagram
- UML designing
Office Tools - Microsoft Word 2007
- Microsoft Excel 2007
- Microsoft PowerPoint 2007
Project Description :
Project Description
This project enables students to take exams based on multiple choice questions from his/her smart mobile phone based on Android operating system. The application has following functionalities :
- User Registration
- Take multiple choice exams on various subjects on mobile
- Save exam results on web-server and retrieve the results laters
The project also included development of an administration website using which administrator set exams on various subjects by entering questions and multiple choices. Website included following functionalities.
- User registration authentication
- Set exams for various subjects – add questions and multiple choice questions
- View reports of exam results of various students
Front End - Java Server Pages – Administration Website
- Android App for Mobile
Back End - Microsoft Access Database,
Technology/
Platform - Mobile Application Development – Android
- JSP for web application development
IDE Used - Eclipse for android application development
Web Server - Tomcat
Role The project was executed as a POC for a software company – Vaaaga Consultancy www.vaagha.com . Team had one another colleague from the college class. It was also presented to the college faculties as last semester project.
- Project conception
- System Design and Architecture
- Implementation
- Integration Testing
- Deployment
Additional Courses :
- Advance Java Course : - Successfully completed Advance Java Course from Neebal Technologies ltd., Andheri (West), Mumbai.
- English Speaking Course : - Successfully completed English Speaking Course from Indo- American Society, Mumbai.
- Personality Development Course : - Successfully completed Personality Development Course from Indo- American Society, Mumbai.
- Hardware and Networking Course : - Successfully completed Hardware and Networking Course from H.M. Classes., Malad (West), Mumbai.
Languages spoken and Extra Activities :
Language English, Gujarati, Hindi, Marathi.
Extra Activity Reading Books, Planting Tree, Playing Games, Collecting Different countries Coins, Internet Browsing.
-------------------------------------------------------
More Information about this submission and submitter :-
___________________________________________________
Submission ID : 4364818
Date & Time : 13th Jul 2011 2:18 AM (UTC)
IP Address : 120.60.138.102
Browser Info : Mozilla/5.0 (Windows NT 6.1) AppleWebKit/534.30 (KHTML, like Gecko) Chrome/12.0.742.112 Safari/534.30
Predicted Country ;: India

[Guest]

BK Sudhindra

Email : sudhindra.bk AT gmail.com
Professional Summary
- More than 10 years of experience in IT industry
- More than 4 years of experience as Project Lead / Lead Analyst
- Have good working knowledge of SQL Server 2005 and SQL Server 2008
- Good knowledge of SQL Server Profiling and Performance Tuning
- Good knowledge of Scripting Languages
- Designed, built and tested web based applications using C Sharp, ASP, PHP and SQL Server 2005 / SQL Server 2008 as backend
- Good knowledge of Microsoft VSS and Perforce
- Good knowledge of database concepts and SQL
- Good knowledge of complete SDLC Process
- Good knowledge of SQL Server Reporting (SSRS), SQL Server Integration Services (SSIS) and Report Builder
- Expert in SQL Server 2000/2005/2008/2008 R2
- Basic knowledge of Data Warehousing concepts
Technical Skills :
Programming Languages VB.NET, C Sharp, ASP.NET and ASP
Scripting Languages VBScript, JavaScript and PHP
Databases SQL Server 2005 / 2008 / 2008 R2
Other Tools MS Project, Perforce, Report Builder
Others Secure FTP, XML, SSRS, SSIS
Professional Summary :
Sep 2008 - till date Bally Technologies
Mar 2005 - Sep 2008 Hewlett-Packard ISO Pvt Ltd.
Jun 2003 - March 2005 DSL Software Ltd and Deutsche Bank, Singapore
Sep 2000 - Jun 2003 Canarys Automations Pvt Ltd.
Mar 2000 - Sep 2000 NIIT Limited
Educational Qualification :
Year Degree completed College / University CGPA / % Marks
2006 M.S. (Software Systems) B.I.T.S, Pilani 7.35
1999 B.E. P.E.S.I.T 68%
Professional Experience :
1. Bally Technologies (Sept 2008 – Till Date)
Organization : Bally Technologies
Environment : ASP.NET, VB.NET and SQL Server 2005 on Windows 2003 Server
Role : Lead Analyst
Team Size : 6
Summary : MAPSX, a synonym for Multi Area Progressive System involves enhancements to backend (SQL Server 2005 / SQL Server 2008) and Performance Tuning. The major chunk of work with the MAPSX system is fine tuning queries and Stored Procedures to improve performance. The MAPS system also involves a front-end developed in ASP.NET and VB.NET
Roles & Responsibility :
- Working as Lead Analyst
- Responsible for Change Request Analysis and Design of the application :
- Interacting with the US Partners for understanding the business requirements
- Contribution to Requirement Analysis and System Design
- Responsible for estimation of tasks :
- Using WBS method for each task or FPA as appropriate
- Responsible for assigning tasks to developers
- Responsible for coding, documenting and implementation of the application :
- Writing Unit Test Cases
- Writing Design Documents
- Creating Tables, Views, Indexes and Stored Procedures
- Tuning performance using SQL Profiler
- Creating Installer for Deployment
- Writing Batch file to carry out un-attended SQL Server Installation
- Unit/Integration/Load Testing
- Writing User Guide for the Application
- Writing SSIS Package to Transform and migrate the data
- Creating Reports using SQL Server Reporting Services
- Creating Custom Reports using Report Builder
- Responsible for configuration management of the project :
- Configuration Management using Perforce
2. Hewlett Packard (Mar 2005 – Sept 2008)
Organization : Hewlett Packard
Environment : ASP.NET, C Sharp, PHP, ASP and SQL Server 2005 on Windows 2003
Server
Role : Project Lead
Team Size : 6
Summary : PRTool, a web-based tool is an automation of HP Peer Review Process. PRTool has interfaces for Review Initiation, Item Log, Rework and Review Closure. The Review Dashboard gives us all the information on Review metrics like Review Efficiency, Review Effectiveness, Major and Minor Defects across all stages of SDLC etc …
Roles & Responsibility :
- Working as Associate Software Analyst
- Responsible for Requirement Analysis and Design of the application :
- Interacting with the US Partners for understanding the business requirements
- Contribution to Requirement Analysis and Module Design
- Responsible for estimation of tasks :
- Using Function Point Analysis
- Responsible for assigning tasks to developers
- Mentoring the junior developers
- Responsible for coding, documenting and implementation of the application :
- Involved in fixing Critical/Serious Defects and all Enhancements
- Writing Unit Test Cases and RTM
- Writing Design Documents
- Writing Database Design Document
- Writing Stored Procedures and DB functions.
- Unit/Integration Testing
- Responsible for configuration management of the project :
- Configuration Management using Microsoft VSS
Organization: Hewlett Packard
Environment: Scripting Languages on HP-UX
Role: Senior Software Engineer
Team Size: 2
Summary: EKSLi Components involves 2 sub-projects. WCHART, a bug tracking tool and a reporting interface in PDF format and Coex-DCT, which tests Co-existence of ISUs (Independent Software Units) during installation and configuration. It involves installing the Operating Environment, installing the required patches and then test the actual ISUs for co-existence with other ISUs with the package.
Roles & Responsibility:
- Working as Associate Software Analyst
- Responsible for Requirement Analysis and Design of the application:
- Interacting with the US Partners for understanding the business requirements
- Contribution to Requirement Analysis and Test Plan
- Responsible for estimation of tasks:
- Using WBS
- Responsible for coding, documenting and implementation of the application:
- Writing Test Plan
- Understanding the ISU Structuring
- Enhancements to WCHART Tool
3. DSL Software Ltd (Jun 2003 – Mar 2005)
Organization: DSL Software Ltd
Environment: VB, ASP, SQL Server 2000 on Windows 2000
Role: Senior Software Engineer
Team Size: 4
Summary: Genie, a complete Risk Management Tool. This consists of a SQL Server data-source and Visual Basic Front-end. The feed to the data-source is scheduled daily. The data from different other data-sources comes into Genie data-source and then transformations are applied.
Roles & Responsibility:
- Working as Senior Software Engineer
- Responsible for Requirement Analysis and Design of the application:
- Interacting with the UK Partners for understanding the business requirements
- Contribution to Requirement Analysis and System Design
- Responsible for estimation of tasks:
- Using WBS
- Responsible for coding, documenting and implementation of the application:
- Developed Stored Procedures, Triggers, Jobs and Views in SQL Server 2000
- Involved in Minor enhancements to front-end
- As a senior developer involved in Analysis, Development and Implementation
- Tuning Indexes
- Tuning SQL Queries for Performance

Organization: Deutsche Bank, Singapore
Environment: VShell 2.3 (sFTP Server), Secure CRT 4.1.6 (sFTP Client)
Role: Senior Software Engineer
Team Size: 2
Summary: A secure file transfer setup from our System (Genie) to other up-streams and down-streams. This setup would replace the present FTP, which is exposed to security vulnerabilities.
Roles & Responsibility:
- Working as Senior Software Engineer
- Responsible for Requirement Analysis and Design of the application:
- Interacting with the UK Partners for understanding the business requirements
- Contribution to Requirement Analysis and System Design
- Responsible for estimation of tasks:
- Using WBS
- Responsible for coding, documenting and implementation of the application:
- Evaluated the VShell Server and Secure CRT products
- Involved in complete setup of sFTP system
- As a senior team member involved in Evaluation, Analysis, Setup, Implementation & Maintenance.

Organization: DSL Software Ltd, Bangalore
Environment: ASP, SQL Server 2000 and Windows 2000 / NT
Role: Software Engineer
Team Size: 6
Summary: A complete Project Management & Tracking tool. This tool automates all the processes from Project initiation, management, tracking to closure. The Incident Management System is used by Customer Base of Deutsche Bank to Log Incidents.
Roles & Responsibility:
- Working as Software Engineer
- Responsible for coding, documenting and implementation of the application:
- Developed Stored Procedures in SQL Server 2000
- Involved in Production Management, Technical Support Calls
- Involved in Minor enhancements
- As a team member involved in Design, Development and Implementation
4. Canarys Automations Pvt Ltd (Sept 2000 – Jun 2003)
Organization: Canarys Automations Pvt Ltd.
Environment: ASP, SQL Server 7.0, Apache and Windows 2000
Role: Software Engineer
Team Size: 2
Summary: As Review Process is one of the vital software processes in the Project Management System, automating this process is interesting and effective. The Review Process involves inspecting various project profile documents developed in the life cycle of a project.
Roles & Responsibility:
- Working as Software Engineer
- Responsible for coding, documenting and implementation of the application:
- Understand the Requirements
- Performed Detailed Analysis and SRS Document
- Database Design, System Design and Development
Organization: Canarys Automations Pvt Ltd.
Environment: ASP, SQL Server 7.0 and Windows 2000
Role: Software Engineer
Team Size: 2
Summary: Development of this application was to automate the Software Audit Process compiling to the HP Standards. Audit Tool incorporates planning, tracking & managing of the software audit process in an Organization. This forms a centralized repository for all the Org wide Audit data.
Roles & Responsibility:
- Working as Software Engineer
- Responsible for coding, documenting and implementation of the application:
- Analysis and Design
- Development

[Guest]

Sweta Kamal
Email : sweta.kamal1 AT gmail.com
________________________________________________________________________
CAREER OBJECTIVE :
To excel in my field with competitive environment with my intellectual abilities, creative thinking, technical bent and interactive learning to become a quality expert to generate positive result for both me and my organization and be a part of team that dynamically works towards the profitable growth of the organization.
SKILL :
- Strong communication and problem solving skills.
- Possessing positive attitudes like truthfulness, commitment and punctuality.
- Good team player with very good inter-personal skills and decision making.
- Takes complete ownership of given responsibilities and always has been an initiator when it comes to taking more responsibilities.
- Fast learner and hard worker.
EDUCATIONAL QUALIFICATIONS :
- Academic :
- HSC (10th) from BSE, ORISSA with 60% in 2006.
- CHSE (12th) from CHSE, ORISSA with 57% in 2008.
- Bachelor Degree in COMPUTER APPLICATION from Berhampur University with 80% in aggregate and Distinction.
WORK EXPERIENCE :
Fresher
SKILL :
Programming Languages : DOS, C, C++, Java,
Web Development : HTML, JavaScript
Operating Systems : Windows (XP), UNIX, LINUX
Databases : Oracle 8i
Networking : Data Communication and Computer networks
OTHER DETAILS :
Expected CTC : 2.5 Lakhs p.a.
LINGUIST PROFICIENCY :
English, Hindi, & Oriya
CERTIFICATIONS :
* Got several certificates in activities like Essay, Drawing, Painting, Song, Instrumental Music, Alpana and Mehendi.
HOBBIES AND INTEREST :
Cooking, traveling & interacting with different people, road map reading, listening music & playing keyboard also, participating in discussions.