Shankar Tuljaram Sangoli
Tata Consultancy Services
Experience Summary
I am an associate with Tata Consultancy Services as Assistant Systems Engineer with total of more than 4 years of work experience in IT Industry. My area of experience and expertise is of software development in web with programming languages C# and PL/SQL with windows platforms, and database Sybase and SQL Server. I work in the domain of Financial and Banking Services.
Technology
Below is a list of important hardware, software products and tools that I have worked with.
Hardware Software Products Tools Methods
Pentium 4 ASP.NET 3.5, ASP.NET 2.0, ASP.NET 1.1, C#, VB.NET, ASP.NET AJAX, SQL sever 2000, XML Web Services, HTML, Javascript, DHTML, ChartFX VSS, Microsoft Project Plan,
SQL Reporting Services,
TFS NA
Qualifications
Degree and Date Institute Major and Specialization
Bachelor of Engineering
Jun – 2005 Vivekanand Education Society’s Institute Of Technology - Chembur Information Technology
H.S.C. Mar - 2001 C.H.M – UNR -3 Science
S.S.C. Apr – 1999 Fatima High School English
Assignments
The details of the various assignments that I have handled are listed here, in chronological order.
Project Online Program
Customer Merrill Lynch, New Jersey, US
Period Sep 2007 till date
Description Online Program is the group’s key initiatives & centred on the multi-year effort to re-design the online platform and improve the overall reliability and business capability of client-facing web sites.
The program primarily aims to:
- Deepen client relationships to both the Financial Advisors and the firm and deepen the Financial Advisor relationships to the firm
- Deliver a robust technology platform to extend capabilities, accelerate time to market and improve efficiencies
- Build online capabilities to deliver services at a low cost to the mass affluent market
- Better support institutional clients and improve their abilities to support their end clients. Create linkages to maximize retail conversion from Retirement relationships
- Develop online channel capabilities that meet the needs of overseas markets and assist in aggressively growing non-US Wealth Management business.
Role Module Lead
Solution Environment ASP.Net 3.5, C#, ASP.Net AJAX, JavaScript, DHTML, ChartFx, Component Art
Tools [login to view URL] 2008, TFS
Responsibilities • Coordinating with onsite team, collecting the requirements and analyzing it
• Discussing with onsite about the development status on daily basis
• Leading and managing the offshore team
• Understand the business requirements of the client
• Reviewing the code done by team members
• Delivering the tasks on time with good quality following the Software factory process
Technical Contribution • Development of one of the critical module “Total Financial Picture” in Online Program
• Created reusable custom controls using ASP.Net AJAX library which are used across the application
• Extensively worked on ChartFx and customized it as per the projects requirement
• Research and Development on Yahoo User Interface (YUI) Library, Component Art and other third party controls
• Research and Development on performance optimization
• Understanding RIA architecture and implementing the same in the project.
• Testing and bug fixing in the application
• Provided alternate solutions at number of instances across the application
• Contributed in creating the best practices which were followed during the entire course of development of the application
Project MIS-Retention
Customer ICICI Lombard
Period Feb 2007 to Aug 2007
Description MIS-Retention is a management information system for all the verticals in ICICI Lombard. These verticals need to prepare many reports daily as well as monthly based on the data that they get from all the agents through out India, which is very time consuming and error prone. MIS-Retention has automated this entire process. The user has to just upload the data into the system in the form of excel file. Based on this uploaded data various reports are generated. The reports generated can be exported into different forms like excel sheet, pdf file or graphs (Bar charts, Pie charts etc).
Role Project Head, Team Leader
Solution Environment ASP.Net 2.0, C#, SQL Server 2000
Tools [login to view URL] 2005, VSS, SQL Reporting Service, Microsoft Project Plan, DotNet Charting Tool
Responsibilities • Meeting client for requirement gathering
• Analyzing the requirements and creating Work Breakdown Structure using MPP
• Code review
• QMS and Project Documentation
Technical Contribution • Development of the application
• Unit testing and bug fixing
• Written complex stored procedures to generate different kinds of reports as required by the client
• Used dotnet charting tool to generate various reports in the form of Bar and Pie charts
Project M1-MIS
Customer ICICI Lombard
Period Dec 2006 to Feb 2007
Description M1-MIS is a management information system for one of the vertical called M1 in ICICI Lombard. This vertical need to prepare many reports daily as well as monthly based on the data which they get from all the agents through out India which is very time consuming and error prone. M1-MIS has automated this entire process. The user has to just upload the data into the system in the form of excel file. There are eight different types of data upload in the system. Based on this uploaded data various reports are generated. The reports generated can be exported into different forms like excel sheet, pdf file or graphs.
Role Project Head, Team Leader
Solution Environment ASP.Net 2.0, C#, SQL Server 2000
Tools [login to view URL] 2005, VSS, SQL Reporting Service, Microsoft Project Plan, DotNet Charting Tool
Responsibilities • Meeting client for requirement gathering
• Analyzing the requirements and creating Work Breakdown Structure using MPP
• Code review
• QMS and Project Documentation
Technical Contribution • Development of the application
• Unit testing and bug fixing
• Written complex stored procedures to generate dynamic reports
• Used dotnet charting tool to generate various reports in the form of Bar and Pie charts
Project Asset Management System
Customer ICICI Lombard
Period Sep 2006 to Nov 2006
Description This system is developed to manage the standard as well as non - standard assets of ICICI Lombard at different locations across India. The system is basically used by administrators and IT admin peoples. It handles right from buying of assets till transportation and accounts at various locations. It also facilitates to generate various reports based on the input criteria.
Role Module Leader
Solution Environment ASP.Net 1.1, C#, SQL Server 2000
Tools [login to view URL] 2003, VSS, Microsoft Project Plan
Responsibilities • Meeting client for requirement gathering
• Analyzing the requirements and providing the estimation to the client
• Code review
• QMS and Project Documentation
Technical Contribution • Development of the application
• Unit testing and bug fixing
• Generated dynamic UI using DHML and javascript which made the page very user friendly
• Used AJAX for partial page rendering using XMLHttpRequest
Project Project Management System
Customer ICICI Lombard
Period July 2006 to August 2006
Description This system is developed to manage the projects going on in ICICI Lombard. It allows for project creation and allocate/unallocate resource to a project. It also provides time sheet management on weekly basis for a single as well as multiple projects. Various reports are provided to admin users of the system.
Role Module Leader
Solution Environment ASP.Net 1.1, C#, SQL Server 2000
Tools [login to view URL] 2003, VSS, Microsoft Project Plan
Responsibilities • Meeting client for requirement gathering
• Analyzing the requirements and providing the estimation to the client
• Code review
• QMS and Project Documentation
Technical Contribution • Development of the application
• Unit testing and bug fixing
Project Critical Illness and Home Insurance policy of ICICI Bank
Customer ICICI Bank
Period May 2006 to June 2006
Description This is as intranet application which is developed to process the application for insurance policy of the customers. The policy information can be filled with the help of online web form or by uploading the excel file containing multiple policy information. Before inserting or uploading the data into the database it is being validated against the policy rules after which various exception reports are generated if there are any. The user can search policies and generate the reports. After successful uploading of data, policy certificates are generated.
Role Software Engineer
Solution Environment ASP.Net 1.1, C#, SQL Server 2000
Tools [login to view URL] 2003, VSS
Responsibilities • Requirement gathering
• Analyzing the requirements
• Code review
• QMS and Project Documentation
Technical Contribution • Development of the application
• Unit testing and bug fixing
• Created reusable component for uploading files to server
Project Pachealth E-Commerce System ([login to view URL])
Customer Pachealth Corporation WA
Period Jan 2006 to April 2006
Description Pachealth is a medicine company in Boston. This application is developed to sell there products online. The system allows the user to browse through the product catalogue at the same time view the shopping cart on the same page itself and checkout with the final order which is possible because of the single screen checkout page designed using AJAX and DHTML.
Role Software Engineer
Solution Environment ASP.Net 1.1, C#, SQL Server 2000
Tools [login to view URL] 2003, VSS
Responsibilities • Requirements gathering and analysis
Technical Contribution • Development of the application
• Unit testing and bug fixing
• Created single screen checkout page using AJAX and DHML
• Created webservice for placing online order of the various products by Pachealth Corporation.
Project Clearpoint Metrics Security Solutions
Customer Clearpoint Metrics
Period Nov 2005 to Dec 2005
Description Clearpoint metrics provides security solutions to software companies. This website has public as well as private content. The normal user can only view the public content, after signing in he has the access to private content. The whole content on the website is dynamic and is managed by Dreamingcode’s Content Management System and generates related reports.
Role Software Engineer
Solution Environment ASP.Net 1.1, C#, SQL Server 2000
Tools [login to view URL] 2003, VSS
Responsibilities • Requirements gathering and analysis
Technical Contribution • Development of the application
• Unit testing and bug fixing
Project Life is Good E-Commerce System ([login to view URL])
Customer Life is Good Boston
Period Jul 2005 to Oct 2005
Description It is an E-Commerce website developed to sell shirts, t-shirts, garments and other products of Life Is Good which is based in Boston. The website is very huge as there are large varieties of products available to be sold online. The payment is done through credit card. My role basically was to develop backend management information system and other backend modules like return order, exchange order for new order etc.
Role Software Engineer
Solution Environment ASP, SQL Server 2000, DTS
Tools VSS
Responsibilities • Requirements gathering and analysis
Technical Contribution • Development of the application
• Unit testing and bug fixing
Key Competencies & Skills
My Competency Profile includes the following
Skill Proficiency (E0 to E4)
ASP.net 3.5/2.0/1.1 E3
C# E3
SQL Server 2000 E3
ASP E3
HTML, DHTML, JavaScript, ASP.Net AJAX E4
Career Profile
Dates Organization Role
May 2006 to Sep 2007 Techprocess Solutions Ltd a network company of ICICI venture Senior Software Engineer, Team Leader
June 2005 – May 2006 Dreaming Code India Software Engineer
Training / Continuing Education Summary
Program or Course Coverage Dates
Personal Details
Date of Birth 03-Aug-1983
Nationality INDIAN