Post Job Free

Resume

Sign in

Sql Server Project

Location:
Bengaluru, KA, India
Posted:
August 14, 2017

Contact this candidate

Resume:

Ajosh K John

C*, SV Innovation, B Narayanapura +91-988*******(Mobile), Bangalore.-560016, India. ac1s8n@r.postjobfree.com

Objective: To serve in a reputed organization at a responsible and challenging position which will allow me to utilize my skills, knowledge and capabilities to their full strength.

Strength: Result oriented, self-confident, energetic and committed, excellent inter personal relations and communication skills, skill of taking decisive actions and ability to accept challenges, belief in values and teamwork along with quality and efficiency.

Educational Qualifications:

MS IT & M from Bharathidasan University,Trichy,Tamil Nadu

Aggregate: 77%, Year of completion: 2003

BSc mathematics from MG University, Kottayam, Kerala

Aggregate: 70%, Year of completion: 2001

PDC from MG University, Kottayam, Kerala

Aggregate: 56%, Year of Completion: 1998

SSLC form Kerala Board of Education

Aggregate: 65%, Year of Completion: 1996

Professional Skill Set:

Programming Languages: VB.NET, C#.NET, ASP.NET.

Web Technologies: SharePoint 2010, 2013,Office Online 365, XSLT, XML, HTML,.

Operating Systems: Windows XP, Windows Server 2000,2003

Back end: MS SQL Server 2005, MS Access, Oracle 10g, My SQL.

Tools: Visual Studio,SharePoint Designer 2007 & 2010

Opetartional Intelligence tool Siemen’s XHQ

Work Experience: Total 12 years of experience in software application development.

Associate Architect with Ernst & Young (EY) from Feb 2015 to Till date

Assistant Consultant with TCS, Bangalore from Jun 2014 to Jan 2015.

IT Consultant with CGI, Bangalore from Nov 2011 to May 2014.

IT Lead with ING Vysya Life Insurance Pvt Ltd, Bangalore from Sept 2008 to Oct 2011

Sr. Software Engineer with MindScape computing Pvt Ltd, Bangalore from JAN 2007 to AUG 2008.

Software Engineer with Blossom IT Solutions Pvt Ltd, Bangalore from JUN 2005 to December 2006

Software Projects:

Project: EY - Working on multiple projects on SharePoint 2013, SharePoint Apps, SP2010 and WCF

Providing SharePoint development, SharePoint system Audit & .NET consultation to EY clients.

Handling a team of 5 resources on various projects.

Project: Easy Advice (Mar 2015 – Jun 2015)

Client EY- Advisory Practice

Details Engagement Management System – This project involved migrating an existing system developed in Java to SharePoint 2010. This application was designed to be custom developed completely in SharePoint 2010. As a developer I have worked on Page Layouts, Cascading Style sheets, JQuery, Reusable Web Parts, Event Handlers, Timer Jobs, List Definitions and Site Definitions. This system allows the quality team to manage multiple engagements, resources mapped to the engagement and no of hours committed by each resource to the engagements. There is a total of 7 key reports and other reports which are generated and exported into excel. Role played as a Technical lead for this application, and developed the most complex functionalities and generic excel data upload/append feature in the application .

Project: PM Portal (Nov 2014 – Feb 2015)

Client HP

Details Developing custom workflows, PowerShell script, designing new site templates with custom validation

Project: SharePoint App Support (Jun 2014 – Nov 2014)

Client PwC

Details:

Direct interaction with business for getting clarification on requirements.

Many applications assigned to us were supported by multiple vendors (Infosys. Microsoft). Have worked with different vendors to get the information and worked together on various issues.

Co ordination between onshore and offshore team to keep the work aligned.

Scheduling meeting,training for the team. Hosted bridge calls involving different teams and towers.

Supported four sharepoint (2010,2013)applications which involved taking transition of applications from project services team, resolving incidents within SLA defined,co-ordinating with different teams and reverse KT to business and project services team .

Responsible for creating, following up with approvers and executing Request for change(RFC) and tasks as and when changes are required .Tool used SM9.

To create various documents related to applications and keeping them updated with new changes. Getting them reviewed and approved by business and uploading in Team room repository.

Project: Smart Solution Platform (Dec 2011 – May 2014)

Client Shell

Details: Smart Solutions Platform is one of the latest and greatest idea developed by Oil and Gas industry leader shell. The idea is to create a platform which would enable the Business Users to generate different smart apps required to make effective business decisions in their day to day work. This platform is built using various industry leading technologies like SharePoint 2010, Siemens’ XHQ, Matrikon Alarm manager, SQL Server 20008 R2 etc., This benefits that would be realized from the platform would be:

Reduction in the costs associated with the independent frameworks/system requirements for different departments.

Avoiding the creation of redundant Smart Apps.

Reduced maintenance costs.

Reduced time in creating Smart Apps.

Reduced infrastructure

Roles/Responsibilities:

Provide developer tours about the Presentation layer, DSL layer and architecture to the potential Smart App developers.

Regularly update team wiki and knowledge base for DSL related content.

Report/identify the issues/incident raised.

Design and maintain the data structure of the interfaces / Data model to reflect the content as per standards and business rules.

Identify Reference and Master Data from the Source system together with Data Definition Owner.

ING Life Insurance

Other Achievements’ (Sept 2008 to Oct 2011)

Involved in various activity like migration of SharePoint 3.0 to MOSS, developed custom sharePoint filed control like cascading dropdown, Instant Email send button, custom dataview filter in theme level etc. Attended hands on training done by Microsoft on VS2008, MOSS, SharePoint 2010

Project: SAMS (June 2010 – Oct 2011)

Details: This application is for the ING life Branch managers, Area managers and RVPS. Using this application BM can do their daily activities, interview schedules which need to be approved by the Area managers based on certain conditions .Activities like approving the recruitment and business reviews, setting business targets etc. Sending reminders to respective managers also an feature.

Tools: SharePoint 2007,ASP.NET 3.5,SSRS and SQL Server 2005.

Role: Leading the team,Designing development and coding,Implementation and support.

Project: OCMS (OCT 2009-APRIL 2010)

Details: The key over-ridding objective is to design a software system to amalgamate and integrate the separated “silos” of master/s and transaction/s data out of Tele-calling activities and thus allow the monitoring and management of the outbound activities in an efficient and systematic manner. The system will allow the seamless outbound-tele-calling activities by the agents and provide various MIS reporting to the managers.

Tools: ASP.NET 3.5 and SQL Server 2005.

Role: Designing development and coding,Implementation and support.

Project: Branch Consolidation (JAN 2009-JUL 2009)

Details: To Identify, Optimize and standardize the infrastructure, resources and cost in the branch offices. And to generate an online MIS of branches with a common MIS view for corporate and branch personnel. Using this application users can raise their requirements regarding the IT infrastructure and the system will take care of managing the workflow for approval. Fully automated system with minimal user interaction.

Tools: ASP.NET 3.5, SharePoint 2007 and SQL Server.

Role: Designing development and coding,Implementation and support.

Project: FTPEngine for Arvind Mills (JAN 2008-FEB 2008)

Details: The scope of this software is to help the POS to send and receive files from the HO. This FTPEngine is like a pooling engine that will continuously checking in the pre defined folder in the FTP site, if any file exists it will download and is there any file in the local, will upload the file.

Tools: Version 1 in VB6.0 and Version 2.0 in VB.NET.

Role: Designing development and coding,Implementation and support.

Project: Loyalty (May 07 to Sept 08)

Details: Loyalty Management System is a comprehensive and powerful web-based customer loyalty application designed to allow retailer and e-tailers merchants to build customer loyalty through rewards programs. It acts as a loyalty engine for a Loyalty Program.

Tools: VS 2005,ASP.NET, Oracle 10g

Role: Designing development and coding,developing helper classes, XML data generation, custom server controls and user control. Data base design and stored procedures.

Project: CMS (Jan 07 to Dec 07 )

Details: It is an AJAX enabled Communication Management System that uses to communicate with the customer. Customers get that freedom as well as the ability to take control of all communications-e-mail and SMS from a convenient, unified mailbox.

Short Code Service: Built in Java Servlet.

Email/Sms Service: Built in VB6.0

Tools: ASP.NET, SQL Server 2005, Java Servlet,VB6.0.

Role: Designing development and coding,developing helper classes, XML data generation, custom server controls and user control. Data base design and stored procedures..

Project: Inventory Management System. (April 06 to Aug 06)

Details: It is Web based Inventory Management System that keeps track of the inventory of an organization. The main objective of the project is to keep the inventory cost minimal and controlling the stock levels. It helps to manage the inventory accurately and efficiently .This system will capture the various inventory operations and various reports in addition to tracking the reorder levels, surplus status and alert with proper messages.

Tools: ASP.NET, SQL Server 2005.

Role: Designing development and coding,developing helper classes, XML data generation, custom server controls and user control. Data base design and stored procedures.

Project: Assert Tracking System. (Jan 06 to Mar 06)

Details: It is a web based Professional Asset Management System that helps to manage the assets of an organization. The assets in various departments of the organization can be managed up to date by adding new assets to the list and updating the existing assets tracked periodically with the most current information. This system will capture the various asset operations, depreciation calculation, maintenance details and various reports that help to analyze the status of assets, to identify the assets location, to keep track of maintenance history etc.

Tools: ASP.NET, SQL Server 2005.

Role: Designing development and coding,developing helper classes, XML data generation, custom server controls and user control. Data base design and stored procedures.

Project: Police IT 2000. (Jun 05 to Dec 05)

Details: The main objective of the project is to develop software entering all the details related with crime and traffic. The police can post Crime and traffic violations real-time and retro actively. Stored procedures and XML are used to retrieve and insert data into the database. This system will capture the various Traffic operations including Accident Report, Police Notice, Spot Fine and various.

Tools: ASP.NET, SQL Server.

Role: Designing development and coding,developing helper classes, XML data generation, custom server controls and user control. Data base design and stored procedures.

Personal Information:

Father’s Name: John K

Date of Birth: 03 July, 1980

Sex: Male

Marital Status: Married

Nationality: Indian

Languages: English, Hindi, Malayalam and Tamil.

Passport Number: L3518178

Declaration: I hereby declare that the information furnished above is true to the best of my knowledge.



Contact this candidate