Sql Server Project
Resume:
Thomas Koshy
Mississauga – L5L 2G2.
E-mail:************@*******.***
Cell: 647-***-****
PROFILE8 Years of experience in Microsoft Technologies using C#, ASP.NET 1.1/2.0/3.5, WinForms, WPF,WCF, LINQ, VB.NET, Web services, SQL Server 2000/2005/2008, Oracle 10g, Crystal Report 11.5, ASP 3.0, Visual Basic 6.0, SQL/T-SQL, Oracle 10g, PL/SQL, Microsoft Content Management Server 2002, Ektron CMS400, HTML, VBScript, CSS, JQuery, JavaScript, XML, XSL, XSLT, XSDSolutions-oriented IT consultant with notable success in building and implementing a broad range of IT systems Proven analytical, design and problem solving skillsExcellent team player and able to work on self-initiative Involved in analysis, design, development and implementation of various applications in internet/intranet and Client/Server environmentInvolved in interacting with customers/clients, gathering the requirements, presentations through net meetings, implementation of projects, trainings.Good exposure in development of front end Web Interface / GUI.
TECHNICAL SUMMARY
Languages
Technologies
OS and Software Packages
ASP.NET 1.1/ 2.0/3.5 C#, VB.NETASP 3.0, Visual Basic 6.0PL/SQLSQL/T-SQLMicrosoft Content Management Server 2002Ektron CMS400XML/XAML/XSL/XSLT/XSD, XPathHTML/VBScript/CSS/
Object Oriented Programming and DesignMicrosoft Enterprise Library 5.0..NET Framework 1.1, 2.0, 3.5COM / DCOM/ COM+DAO / ODBC
MS SQL Server 2000/2005/2008MS Access, Visio, Project, Office MS IIS 6.0, 7.0Oracle 8i, 10gMicrosoft Visual Studio .NET 2003/2005/2008Visio 2000 SDLC
Professional Experience
Currently working in GlaxoSmithKline as Sr. Software Developer from 10 July 2012 to Present.Worked in yFactor, Toronto as software developer from 28 Nov 2011 to 23 Mar 2012.Worked in The Multisoft Group, Aurora as software Developer from 07 Mar 2011 to 20 November 2011Worked in Jovian capital, Toronto as software programmer from 15 Sep 2010 to 29 Oct 2010. (1.5 months contract)Worked in Guestlogix, Toronto as Software developer from 02 Sep 2008 to April 06 2009.Worked in Mercer, Toronto as Sr. Software Application Developer (9.5 months contract -1 Oct 2007 to 18 July 2008)BMO (Bank Of Montreal),Toronto as Sr. Software Application Developer (6 weeks contract - Jul 2007 to 31 Aug 2007)HP (Hewlett Packard), Bangalore as Business Planning Analyst (permanent) (April 2006 to July 2007)Accenture Services India Ltd, Bangalore as Software Engineer (contract) ( June 2005 to April 2006)ITC InfoTech Ltd., Bangalore as Sr. Software Engineer (contract) ( July 2004 to Oct 2004)FCI Technology Services Ltd., Bangalore ITPL as a Software Engineer (permanent) ( April 2002 to May 2004)
GlaxoSmithKline - Mississauga, Canada 10 July 2012 to Present
Sr. Software Developer
Project name: CAMREG
Role: Design, Development, Stored Procedures, Functions and Triggers. documentation (system overview,
design specification)
The Canadian Medical Registry (CAMREG) is a web-based application designed to track medical registries and
medical enquiries through the Medical Registry This system includes the following features:Ability to enter medical registry information into a web-based form.Ability to retrieve enter medical registry information from the web-based applicationAbility to Export detailed Registry data into an excel file.Ability to Upload the Track HO Output Excel file into the Database.The application follows Commercial IT’s best practices in programming and Oracle coding standardsThe application data is stored in a well-defined format to facilitate the generation of business Reports and Metrics
Languages and tools used: ASP.NET 3.5, C#, WinForms, WPF, Oracle 10g, PL/SQL, HTML, CSS, JavaScript, ADO.NET, jQuery, Visio.
yFactor - Toronto, Canada 28 Nov 2011 to 23 mar 2012
Software Developer
Project name: iCMS Enterprise Applications
Role: Design, Development, Implementation / stored procedures, functions, views.
CMS can be configured as a series of public or private, password protected portal(s), with a business directory or
an itinerary planner. It can also be configured for as many component websites as required.
Unlike other content management systems iCMS is designed to support and manage multiple websites.
Each iCMS implementation includes content consultation, project management, design, content migration,
training and support.
iCMS Enterprise features:Automatically generate site mapAutomatically generate Breadcrumbs etc
Languages and tools used: .NET, WinForms, WPF, VB.NET, MS SQL Server 2005, SQL and T-SQL,
ADO.NET, LINQ, JQuery, Ajax, CSS.
The Multisoft Group - Markham, Canada 07 Mar 2011 to 25 Nov 2011
Software Developer
Project name: Events and Exhibition
Role: Design, Development, Implementation / stored procedures, functions, views.
TMG's registration solution is built on the :
Tailored solutions to suit the unique requirements of your event
Real-Time capturing of all your event data
Unlimited reports that can be easily shared and stored online
Unlimited email broadcasting
Real-Time tracking of an unlimited number of sessions, workshops, courses and tours
Automatic counters designed to limit the number of seats for courses, sessions or tours
Easy integration with any type of Payment Gateway
Real-Time processing and tracking of accounting transactions, with direct linkage to your payment gateway
The module makes it simple for exhibitors to reserve, register and pay for booth space Online and
Real-Time. Visitors and delegates alike will have the ability to examine vendors on the Internet, reviewing
vendor products and services and making contact with them through the integrated system.
Languages and tools used: .NET, C#, MS SQL Server 2005, SQL and T-SQL, ADO.NET, LINQ, JQuery.
Jovian Capital - Toronto, Canada 15 Sep 2010 to 29-oct-2010
Application Software Developer
Project name: IT Goldmine Service Request Reports
Role: Design, Development, Implementation / stored procedures, functions.
Generate various reports for the service request Application.
Reports: Open Ticket report, Closed Ticket Report, SLO Report - Technical Issues,
SLO Report - ACD Service Request, SLO Report Summary.
Major functionalities and features:It calculates the SLO. Calculate the elapsed days, time for the technical issue to be resolved.Calculates the average SLO, Average time, Number of tickets that met SLO and number of tickets that do not met SLOCreated Pie charts to review the summary of the reports.To find the status of all the helpdesk tickets created.
Languages and tools used: .NET 3.5, C#, Crystal Reports 11.5, MS SQL Server 2005, SQL and T-SQL, LINQ, ADO.NET
Jovian Capital - Toronto, Canada 15 Sep 2010 to 29-oct-2010
Application Software Developer
Project name Inventory control – Jovian portal intranet website
Role: Design, Development, Implementation.
Generate various reports for the service request Application.
Inventory control systems have been developed to add inventory items, attributes, inventory
Details and keep track of the Inventory. Finds the duplicate records for the inventory attributes. Adding inventory
Details for each user.
Major functionalities and features:Search for the forms details based on date, name and hardware or software details.
Languages and tools used: .NET 3.5, C#, MS SQL Server 2005, SQL and T-SQL, LINQ, ADO.NET, javascript, AJAX
Guestlogix - Toronto, Canada 02 Sep 2008 to 06 April 2009
Application Software Developer
Project name: OBSC / POS Applications (Point of Sales)
Role: Design, Development, Implementation.
The OBSC (onboard Sales Controller) application is responsible for presenting the graphical user interface to the application user. The interface is comprised of winforms, reports presented in pdf formats.
POS (Point of Sale) application is a GUI that is used by the flight attendants to process onboard sales and then transmit those sales to the POS manager server.
Eventually these applications are implemented to the hand held device.
OBSC Application Tier
Flight Information
Crew operating the flight
On board inventory
Price of Items for sale
Currency conversion rates
POS Application Tier
The Retrieval of flight, crew and inventory for a flight or series of flights
Updating sales information for a given flight or series of flights
Interfacing of credit card sales with the customer’s credit card processing service.
Printing the sales and reports summary in the hand held device.
Credit Card Processing
The credit card processing service.
Airline financial systems
Encrypt the credit card Information
Hand-held units will initiate two downloads:
i). To send the credit card transactions to the processor for authorization.
ii). To send sales transactions to the OBSC/ POS applications.
Languages and tools used: .NET, WinForms, C# 2.0, MS SQL Server 2005, XML, SQL 2005 and T-SQL, ADO.NET, FRONT END/ WEB GUI.
Mercer - Toronto, Canada 1 Oct 2007 to 18 July 2008
Sr. Application Software Developer
Project name: Multiple DataLoader (Console Application).
Role: Design, Development, Implementation.
Data Loader is developed to implement data gathering, transformation and centralization from numerous internal or external sources to multiple dedicated data storages, such as MUKA database for Authentication or Online Total Rewards database. Data Loader also potentially supports Data Weaver System – a light-weighted Online Total Reward database.
Major functionalities and features:Create the encrypted file to decryption (GPG Decryption).Compare the data with the current file to data in the database (Different result creation).Xml Conversion (Plain text to XML – Serialization and De - serialization). XSD Validation (using XPath to navigate data through elements and attributes in an XML document)Data Import to relational databases through API or SQL manipulation. Custom Calculation in data. (Calculations and data manipulations are incorporated in xsl and xml files).Reporting (Notification through Email) File Archiving (moving files to the Archive folder)Import/export databases from one server to different servers.
Design / Testing / Implementation: Designing and coding of new stages.Unit testing of the application.Configuration and Implementation of the application to the servers.
Languages and tools used: .NET, C# 2.0, WinForms, MS SQL Server 2005, XML,XPATH, XAML, XSL, XSD, SQL and SQL,T-SQL, ADO.NET
Mercer - Toronto, Canada
Sr. Application Software Developer
Project name: CBS HR Portal
Role: Design, Development, Stored Procedures, Functions and Triggers.
This is an HR Portal Implementation Project. It has been developed with difference verticals. Cash Balance
Component of the CBS Combined Pension Plan, Health plan, Savings plan etc. The CBS Combined Pension
Plan (CCPP) is designed to help provide, along with Social Security and your own personal savings, future
financial security for you and your family. The Plan will pay you a benefit after you retire or otherwise leave
employment.
The main features of this application:Data Management and Production SupportDesign and coding of the user interface / templates web formsDatabase development creating stored procedures triggers, functions, PL/SQL statements.Unit testing and Implementation of the application.
Self-registration for First-time Users
First-time users will be required to enter a unique identifier and 2 additional data elements for verifying the ID institutions.
Languages and tools used: ASP.NET, C#, WinForms, MS SQL Server 2000, Ektron CMS400,XML, SQL and T-SQL, HTML, CSS, JavaScript, ADO.NET, jQuery
BMO - Toronto, Canada Jul 2007 to 31 Aug 2007
Sr. Application Software Developer
Project name: IRIS
Role: Design, Development, Stored Procedures, Functions and Triggers.
Integrated Retail Investments Sites is a Term Investment Comparison Analysis Application defines the BMO term Investment products and competitive products.
The main features of this application:Related to a single BMO product, and to a single Competitor institution.
This application describes the BMO product Category, BMO Product, BMO Institution, Compare with the competitive products, View All rates, rates tab, difference with competitive positioning and feeds with other competitive institutions.
Languages and tools used: MS SQL Server 2000, .NET 2.0, C#, ASP.NET, Microsoft Content Management
Server,XML, XSLT, PL/SQL and T-SQL, HTML, CSS, JavaScript. ADO.NET, FRONT END / WEB GUI.
Hewlett Packard, Bangalore Apr 2006 - Jul 2007
Business Planning Analyst
Project name: Storage Utility
Role: Design, Development, Implementation, Database design, Stored Procedures, Functions and Triggers.
Storage utility project is the billing model of customer specific for storage. There will be tiers for each customer. Each tier will comprise of some systems that follows same pricing that is, price $/GB/month. Each tier has a committed and buffer usage. Systems can be in different locations under each tier. One bill will be generated for each customer but will have location wise tier wise billing. There may be a different rate for each location for the same customer. In this case systems at different locations can not have same tier. The utilization percentage will be calculated based on the aggregate usage of each system under each tier monthly.
Each customer may or may not have a price erosion table for variable committed portion and price curve for the fixed committed usage. Billing will depend on the pricing curve and price erosion tables if the customer has any of them.
Major featuresThere may be changes in the rates, tier, systems etc for the customer at the time of renewal of contract.Application will receive usage file once in a day in XML format thru FTPMetering team will FTP the XML file with daily usage data. On 2 day of missing usage data for a systemAfter 14 days of missing usage data for a systemAction item: Identify PMO contacts and email idAction item: check with the metering team on the missing/measured indicatorCustomer will be charged at the last measured storage unit in case of missing data.Customer may have Bill Max after N days process in the contract. Maximum bill will be the sum of the committed and Buffer billing.Daily and monthly invoice, revenue split, variance etc reports will send to the respective users.
Languages and tools used: ASP, VB6.0, XML, JavaScript & SQL Server 2000, UML
Hewlett Packard, Bangalore
Project name: TSGAPAC (Finance Reporting Solutions)
Role: Design, Development, Implementation, Database design, DTS, Stored Procedures, Functions and Triggers.
This project initiated with end-to-end process for the pricing of the sales bids. The Major activities are:
Reading DART outputs excel files, to view reports, Communication between the sales and the finance team. Pricing Application to generate pricing based on the DART output and Pricing details from Finance team. One bid will have multiple BU and Business Divisions. The report should appear business division wise, business unit wise.
There are three options for calculations: Net price, GM, Discount percentage, Burden rate and IC discount may change for a particular Product Line and affect the pricing. Dollar rate should give all the pricing in the Dollar amount only if it is INR bid. A place for one time entry for all customers, Resellers, Models, Bid Divisions, Region and Account Manager to enter Bid information along with the attachment.
Needs to calculate the total bid amount in Dollars (for Dollar bid) or Rupees (for INR bid)
Generates reports for all bids against each product, segment, and region for a specific period. Generates reports on order won against each dealer, customer and account manager.
Languages and tools used: VB.NET, ASP.NET, ADO.NET, ASP, VB6.0, JavaScript & SQL Server 2000, DTS
Accenture Services India (PVT) Ltd., Bangalore Jun 2005 - Apr 2006
Software Developer
Project name: OneView (Operational Excellence)
Role: Design, Development, Implementation, Database design, Stored Procedures, Functions and Triggers.
OneView is a project initiated with a vision to develop a portal to integrate all verticals of Accenture India BPO and provide information at every possible level. This project is developed for the automation of BPO and Call Center Operations.
OneView will track the journey of an employee from the time the organization plans the employment to the time the employee leaves the organization.
It provides capabilities onPlanning & Recruitment EffectivenessTraining: Plan, Schedule and Performance monitoringOperations: Performance reportsConvert asp to VB.NET and ASP.NET
Languages and tools used: VB.NET, ASP.NET, ADO.NET, ASP, JavaScript & SQL Server 2000, Visio 2000
ITC InfoTech Ltd., Bangalore Jul 2004 - Oct 2004
Sr. Software Engineer
Project name: Extrusions
Role: Design, Development, Implementation, Stored Procedures, Functions and Triggers.
This project is developed for Bunzl Group. Extrusions are an integrated web solution, which provides content authoring and web based workflow features, which allow Bunzl extrusions. The Business users to manage or change without relying any software tools/packages or any IT team. The Administrator is able to provide access for users from the site.
Languages and tools used: ASP, MSCMS, JavaScript & SQL Server 2000.
FCI TS, Bangalore Mar 2003 - Apr 2004
Software Engineer
FCI TS is a division of FCI (Framatome Connectors International), is world’s second largest manufacturer of electrical and electronic connectors. FCI is headquartered in France.
Project name: Data Warehouse User Table Application
Role: Design, Development, Coding, Stored Procedures, Functions and Triggers.
This application will help the user in querying the data warehouse. This application facilitates the user to create list of data useful for his/her query (set of Item numbers, Group of customer etc). This list will be used by the Business Object developers in querying the data.
Languages and tools used: ASP, COM+, VB, IIS, JavaScript, PL/SQL, Oracle 8i.
Project name: Mold Concept Engine Research
Role: Design, Development, Implementation, Coding, Database design.
A certain amount of mold concepts have been identified. These concepts have characteristics compatible or not compatible with one's product to be molded. In order to help engineers to choose between those concepts a research engine is necessary. This will lead to reduce TTD (time to design).
As the research engine propose best compatible concept, the engineer can download PDF illustration of the concept (photos, 3d perspective view). He's also informed of the guardian's concept to which he can send a mail to begin collaboration.
Languages and tools used: ASP, IIS, JavaScript, PL/SQL, Oracle 8i.
Project name: SRM (Service Request Management Tool)
Role: Design, Development, Implementation, Database design, Stored Procedure.
Service Requests (SR) comes in from all the regions to Bangalore. These requests could be in ERP, Infrastructure or Application Development/Maintenance. The requests from different regions are handled and managed differently, today. SR management tool would be a good way to bring consistency in handling the requests and simplify the process of recording, tracking and delivering them. This tool is to be the central point for all the service requests that are addressed in Bangalore.
The main objectives of developing this tool are:A centralized simplified process for logging, tracking and managing SRs in Bangalore independent of the region or division they come fromConsistency in handling and managing Service RequestsUniform reporting of the process indicators relevant to SRs.
The tangible results expected from this tool/application include:All participants in an SR would be able to access the application and update informationMandatory information like Due Date etc. would have to be entered/maintained by concerned usersStatus of SRs would be available in the form of a report. There would be interfaces to access/update data in Service Center and Time Sheet (Journeyx) Tools. Capability to send mails or notify users by some means
Reports for month end reporting and reports to support billing should be available
Languages and tools used: ASP, IIS, VBScript, and JavaScript & SQL Server 2000.
Project name: Automation of HelpDesk Reports
Role: Design, Development, and Implementation
This project is developed for FCI TS to generate helpdesk calls. This report provides all the calls which logged for all the assignees. Each assignee will receive the reports, which are logged for them. All the calls are based on priority. This report is developed in ASP Pages.
The helpdesk report is automated and scheduled in the server and it will run by the schedule time.
Languages and tools used: ASP, IIS, VB, JavaScript & SQL Server 2000.
FCI Apr 2002 to Mar 2003
Software Engineer
Project name: Lynx (A common language for FCI)
Role: Design, Development, and Implementation
The system is built using Microsoft 3 tier architecture.User Services /Presentation LayerBusiness Services/ Business Logic LayerData Services /Data Access Layer
Having identified its new user friendly Customer Complaints database as a best practice with in CDC. It is a single unified global image of complaints, a vision and transparency.
This helps to improve the quality of products and services and thereby reduce customer complaints.
It prevents a problem from spreading to other clients or sites and of course to give customers a satisfying and timely response.
To identify best practices and synergies in terms of quality applications throughout FCI. It was the perfect response to our strategic aim to improve customer satisfaction, tracks complaints and their solution promptly and provides extensive information so that the same compliant can be avoided in the future.
It is essential to have visibility on all quality issues, past and present with FCI's customers at both divisional and corporate levels.
It provides the users to access to all complaints and actions that they are responsible for dealing with.
Languages and tools used: ASP, IIS, VBScript, JavaScript, PL/SQL, Oracle 8i.
Project name: Image navigation Group Item Template
Role: Design, Development, Implementation and Coding.
This project is developed for FCI's intranet site. It is basically to create a template for the Content Management.
This template is used the users to upload group of images and for each group image the user can upload any number of images.
The users are should be able to download images.
Languages and tools used: MSCMS, ASP, IIS, VBScript, JavaScript & SQL Server 2000.
Project name: Customer Survey Application
Role: Design, Development, Implementation, Coding, Functions, Triggers, Stored Procedures.
This application will help the automotive users to manage the customer survey. This includes entering the customer survey feedback on behalf of customer. Define customers and request feedback from them. Manage administrator profile. Generating reports on the data collected.
Languages and tools used: ASP, IIS, VBScript, JavaScript & SQL Server 2000.
Project name: Download Group Navigation template
 
Contact this candidate