HiteshBhatia.com  
Links
    MUBE.co.nr
    My FaceBook


Liked my websites? my work?
Want your own WEBSITE?
CLICK HERE for details


Updated:

11/06/2011

Heres a list of projects that I have worked / currently working on.

Project Details

-------------------------------------------------------------------------
 Since September 2010                                  Tata Consultancy Services
-------------------------------------------------------------------------
 Title: IMP AB Maintenance & Enhancement Project
 Client Name: International Masters Publishers (IMP)
 Position: SQL Server DBA, T-SQL Developer, Module Leader
 Languages: SQL Server 2008, T-SQL, PowerBuilder 6.5.1
 Special Software: Team Foundation Server (TFS)
 Team Size: 2
 Location: Malmö, Sweden / Mumbai, India
 Description: A direct marketing campaign management and decision support system. It provides information about Campaigns, Lists and Segments. It provides projections of future performance for formula, payments, and returns, Campaign simulation, List selection, Campaign performance tracking and analysis.
 Responsibilities:
Support and stabilization of newly migrated SQL Server environment.
Error handling and sending notifications on failure of SSIS jobs.
Deploying and administrating SSRS reports.
Complex T-SQL development and debugging.
Analysis, Design, Coding, Testing, implementation and documentation of the entire database related changes.
Client Interaction on a day to day basis.
User problem resolution like solving issues and enhancement requests.
Designing and maintaining SQL server database systems.
Storage and space management.
Performance tuning of stored procedures and tables.
Index creation and defragmentation thus ensuring high index usage.
Handled MIS update process involving complex SQL queries and debugging.
Developed complex stored procedures, Functions, Views, Triggers, Cursors for mission critical applications.
Direct engagement with the Client for requirement gathering and onsite support at Malmö, Sweden.


-------------------------------------------------------------------------

 November 2009 – August 2010                    Tata Consultancy Services
-------------------------------------------------------------------------
 Title: MIS Database Migration
 Client Name: International Masters Publishers (IMP)
 Position: SQL Server DBA, ETL Developer, Onsite Coordinator
 Languages: SQL Server 2008, SSIS, T-SQL, PowerBuilder 6.5.1
 Special Software: Team Foundation Server (TFS)
 Team Size: 5

 
Location: Malmö, Sweden / Mumbai, India
 Description:The project involves database migration from Sybase ASE to SQL Server 2008. It also involved consolidation of three servers to one which reduced costs and improved performance of the system. SSMA and SSIS are used for schema and data migration.
 Responsibilities:
Successfully migrated the databases from Sybase to SQL server 2008.
Database schema migration using SSMA (SQL server migration assistant for Sybase)
Successfully migrated about 2300 tables containing 180 GB data from 15 databases situated in Sweden, New York and Sydney using SSIS.
Used SSIS extensively in the project for data migration and interfaces.
Created different transformations in SSIS for loading the data into SQL database which includes (fuzzy lookup, conditional split, SCD, Pivot, multi cast, merge join, Data conversion, Script task and many more).
Modified complex stored procedures, triggers and functions.
Creating Backup and disaster recovery strategies.
Modified PowerBuilder scripts to connect to SQL Server instead of Sybase.
Business Reports developed in excel and PowerBuilder were migrated to SSRS reports.
Interaction with the Client on a day to day basis and understanding the requirements.
Onsite coordinator for the Migration project handling UAT and Deployment.
Documentation of the complete migration project with Best practices and Lessons learnt.

-------------------------------------------------------------------------
 December 2008 – October 2009                  Tata Consultancy Services
-------------------------------------------------------------------------
 Title: IMP AB Maintenance & Enhancement Project
 Client Name: International Masters Publishers (IMP)
 Position: Sybase DBA, T-SQL Developer
 Languages: Sybase ASE 12.5, T-SQL, PowerBuilder 6.5.1
 Special Software: Embarcadero DBArtisan
 
Team Size: 3
 Location: Mumbai, India
 Description: A direct marketing campaign management and decision support system. It provides information about Campaigns, Lists and Segments. It provides projections of future performance for formula, payments, and returns, Campaign simulation, List selection, Campaign performance tracking and analysis.
 Responsibilities:
Sybase ASE activities like device creation, backups, server maintenance, performance tuning, etc.
Complex T-SQL development and debugging.
Analysis, Design, Coding, Testing, implementation and documentation of the entire database related changes.
User problem resolution like solving issues and enhancement requests.
Using Embarcadero DBArtisan to connect to Sybase database and perform administrative tasks.
Designing and maintaining Sybase server database systems.
Performance tuning of stored procedures and tables.
Index creation and defragmentation thus ensuring high index usage.
Handled MIS update process involving complex SQL queries and debugging.
Developed complex stored procedures, Functions, Views, Triggers, Cursors for mission critical applications.


Final Year BE Project
Project completed sucessfully !!!
Our project was judged 2nd in Computer Department.

    We - I, Aatish, Arjun, Swayam - have selected our final year project.
    It is part of Ekalavya-IIT Bombay.

Title of the project: Search Engine Tool based on
                                Case Based Reasoning (CBR)

Domain Area of the Project: Artificial Intelligence

Details: The search engine tool is based on the Artificial Intelligence     technique of Case Based Reasoning (CBR). The tool provides a framework     for implementing a CBR application. Knowledge can be refined and     updated anytime from anywhere and information can be delivered across     multiple channels, over the web, via email, phone and desktop.

Weblink of the Project Scenario given by Ekalavya, IIT Bombay:
    http://ekalavya.it.iitb.ac.in/proposaltakenupgroups.do?proposalid=65
 
Websites Designed : Want your own WEBSITE? CLICK HERE for details.
 
http://mube.co.nr

Details: Website dedicated for Mumbai University Engineering Students. Launched first in August 2006. Relaunched with a new design in June 2007.
-------------------------------------------------------------------------
http://pawanandpreeti.com

Details: Wedding website launched in December 2007. Probably my best effort at designing till date.
-------------------------------------------------------------------------
http://hiteshbhatia.com

Details: This website ! Launched in August 2007.
-------------------------------------------------------------------------
http://nareshwedspriyanka.co.nr

Details: Wedding website launched for my cousin sisters wedding in January 2006.
-------------------------------------------------------------------------
Websites Comming Soon !!!
-------------------------------------------------------------------------
http://raajstudio.com

Details: Website for a Photo Studio.
-------------------------------------------------------------------------
http://goodhealthclinic.in

Details: Website for a Doctors Clinic.
-------------------------------------------------------------------------
   
 
© HiteshBhatia.com
All Rights Reserved