Engineer Sql Server
Resume:
Abin Jacob Mathew
*** ****** *** *** *******, IL 60018 +1-847-***-**** ******.****@*****.*** LinkedIn
TECHNOLOGY PROFESSIONAL
Software Engineer Analyst
Over 20 months experience in driving implementation, strategic growth, capability improvement, process standardi zation,
and product visibility within the Global Technology Support Center supporting multiple organizations with more than
800,000 end users over U.S., Europe, Australia and Asia -Pacific regions. Experienced in providing technology s upport for
clients systems including Learning Management Systems (LMS), Procurement Systems and Accenture Operation
Management Systems. Certified with ITIL v3 Foundational and uses the process knowledge to serve clients better.
Demonstrated success in:
Handling more than 1000 technical incidents over last year for multiple clients’ applications.
Monitoring and ensuring 200 + SSIS daily job on multiple Window servers run successfully.
Migrating .Net Application from Window Server 2003 to Window Server 2008 within a short deadline.
Developing and configuring the Google Search Appliance (GSA) which is used as single point for search.
Vendor Management.
System Automation and
Service Process Improvement.
TECHNOLOGY & CORE COMPETENCIES=
Microsoft SQL Server (2005, 2008R2) SQL Server Integration Services (SSIS) Structured Query Language (SQL)
Microsoft Window Server (2003, 2008) Incident & Change Management Google Search Appliance
Supplier Information System (Aravo) Sumtotal and Docent LMS Internet Information Services
CRM –Siebel & BMC Remedy ITSM HTML & XML ASP.NET & C#
PROFESSIONAL EXPERIENCE
Accenture Private Service Limited - Bangalore, India 06/2012 - 04/2014
Accelerated through the organization via various global and cross-capability roles based on proven strengths of technical
and non-technical capability include incident management, c hange management, monitoring capability and development
capability. The Different roles and projects within Organization included:
Learning Application Technical Support Engineer Analyst 06/2012 - 04/2014
Support and ensure availability of production-environment product and applications for external customer s on Learning
Management System on Sumtotal and Docent LMS. Responsibilities include but are not limited to, incident management
and change management for the client . Customers include Multinational Consumer Goods Company, a US Bank and
Manufacturers of Agricultural Machinery and a British Retail Bank. Total learners supported add to 450,000+.
Role and Responsibility include:
Ensure availability of the system running on MS SQL Server 2005, 2008 and Window Server 2003 as per Service
Level Agreement (SLA).
Representative in the weekly operation calls.
Coordinated with CAB (Change Advisory Board) and Development teams for deployment and RFC s (Request for
Change) as per Client requirements.
Ensure Data Integrity of LMS and executed bulk data change as per requirement using SQL Server Scripts
Event Management and clarify the customer queries within the LMS system by checking the DB records, IIS,
application and email (SMTP) logs.
1
Abin Jacob Mathew
Software Engineer Analyst
Service Request include Generic requests like course uploads, batch processing of r ecords and special requests like
generating adhoc Audit Reports and daily and monthly reports.
During the Application migration, was responsible for transferring the client course file via secure FTP to the new
vendor and support the Application Maintenanc e teams for a smooth transition to new LMS application.
Configuration and Technical Engineer Specialist for Google Search Appliance 09/2013 - 04/2014
Develop, Configure and Support the Google Search Appliance (GSA) which is used as Single Search Portal across the Project
and Helpdesk. Task included configuring the GSA tool to search from learning courses, Project SharePoint’s and Database
records from Siebel and BMC Remedy. This project was internal and support 1400 end users in Accenture Operations.
Role and Responsibility include:
Develop and Maintain the User Interfaces (UI) of the Search Portal using HTML and Extensible Stylesheet
Language (XSLT).
Maintain the website and Database access by the GSA and ensure crawling error s are handled.
Used Dynamic Navigation functionality in GSA to solve the content growth issue.
Monitor the Portal usage using Google Analysis.
Migration of Accenture Ops Management Tool 08/2013
Migrated a .Net Application which is used as a Management Tool for Accenture Operation. Our responsibility include s
migrating the Application components which consists of SSIS packages, SSRS report, Database and Web pages of the
website tool from Window Server 2003 to 2008 R2.
Role and Responsibility include:
Setup the Web Application on Internet Information Service (IIS), migrate the Databases, Configure the SSRS server
and added the reports and Update the SSIS package for the Product Testing and Production environments.
Coordinated and worked with different teams for t he migration including the Techops for Setup of the Window
Servers and DBA team for SQL Server Issue.
Worked with the Software Quality Engineering (SQE) for testing for the application and its components.
Tasks during the GO LIVE Maintenance window include restore the latest Database into new Production
environment and conducted basic smoke testing.
Integration Application Technical Support Engineer Analyst 06/2013 – 04/2014
Daily Monitoring and ensuring more than 200+ SQL SSIS Server Job running on MS SQL Server 2005 completes successfully
without any data validation error. We supported jobs for eight clients and ensure the feeds are sent successfully to
downstream application including LMS, Taleo, Information Management System, Portal etc.
Role and Responsibility include:
Ensure that the confidentiality and Integrity of Customer data is maintained always. All Data validation errors are
informed to the concern customer helpdesk to correct the discrepancy.
Handled all Job failures by informing the respective teams if input feed has not arrived, investigating Issue and
ensure the feed has been processed within SLA so that the required data has been sent to downstream
applications.
Application Technical Engineer Analyst for Accenture Ops Management Tool 09/2013 - 04/2014
Provide Tier 3 Support Coverage for multiple Management tools for Accenture Operations running on Window Server 2003
& 2008 and MS SQL Server 2005, 2008.
Role and Responsibility include:
Access Management of the Tool
Ensure that the availability, confidentiality and Integrity of the tools are maintained always.
Page 2 of 3
Abin Jacob Mathew
Software Engineer Analyst
Procurement Application Technical Engineer Analyst for Accenture SIM 03/2013 - 10/2013
Daily Support and Maintenance of the Accenture Procurement Supplier Information System (SIM) which uses a Aravo
Vendor SaaS (Software as a Service) tool. Responsibilities include incident management and change management for the
tool. The number of user for the Accenture SIM was about 40,000+.
Role and Responsibility include:
Maintain availability of System and Data Integrity with the SaaS tool Aravo
Work with different Procurement team like Account Payable, Commodity leads, Sup plier Vendor Maintenance and
made sure that the data is consistent as this data is later used for legal and Fina nce teams of Procurement
Conduct and lead the weekly call with the Accenture Procurement Leadership and Aravo Vendor team to resolve
technical and functional issue raised for the tool.
Additional Non-Technical Responsibility includes
Service Improvement Initiatives (SIP) Team (Value for Client) 11/2012-04/2014
Part of the project team responsible for tracking and maintaining the Service Improvement tools and ideas with the
project. Task included maintaining the Saving Calculation Sheet, the SharePoint Site, planning and organizing weekly
connects with Project Leadership and Team Leads for demonstration and recording the minutes of meeting (MOM).
CERTIFICATION & EDUCATION
Certification
ITIL v3 Foundational Certificate Sept 2013
Certification No: 108**-******
Education
Bachelor in Technology in Computer Science and Technology 2012
Ranking third in the University (out of 1720) and first in the college (out of 120)
University: Mahatma Gandhi University, Kottayam, Kerala, India
Major Courses include : Problem Solving & Computer Programming, Engineering Mathematics, Computer Organization,
Object Oriented Programming, Data Structures & Programming Methodologies, Operating Systems, Data Base
Management Systems, File Structures & Algori thms, Language Processors, Software Engineering, Computer Networks &
Network Computing, Algorithm Analysis & Design, Computer Graphics, Theory of Computati on, Web Technologies,
Security in Computing, Neural Networks
High School (90%) 2008
Board: Central Board of Secondary Education (CBSE), New Delhi, India
School: Our Own High School, Dubai
Major Subjects include Computer Science, Mathematics, Physics and Chemistry
Page 3 of 3
Contact this candidate