Viji Kandasamy
Naperville, IL 630-***-**** ac7kys@r.postjobfree.com
SUMMARY
Seasoned Information Technology professional with hands on application development, application support, testing and quality control experience. Certifications in ITIL Foundation (V3). Certification in Sales Force Administration. Cross functional leadership with project and program management. Experience in managing global teams. Through knowledge in SQL, PL/SQL and relational databases creation, maintenance and support. Proven customer-focused attitude with customer support experience. Successful completion of multiple, simultaneous projects. Proven track record in successful project management of multiple projects with off shore teams.
CORE KNOWLEDGE & SKILLS
Application Development
Java
UNIX
HP - OVSD
SharePoint
VBA / Excel
Visual Intercept
Visual Source Safe
HP-BAC / SaaS
Database Experience
DB2
Oracle – SQL, PL /SQL
SQL Server
SDLC & Testing
Product Life Cycle
Code testing
Debugging
Load Runner/Vugen
Project Management
Project scheduling
Project team leadership
Offshore team management
Project budget management
Project specification development
Six Sigma Implementation
Production Support – 24X7
Software support
Hardware support
Protocol creation
Testing
End user problem resolution
System maintenance
EDUCATION
Bachelor of Science, Computer Science
North Eastern Illinois University
Chicago, IL
Certification
ITIL V3 FOUNDATION
Salesforce Administration
PROFESSIONAL EXPERIENCE
Cox Automotive 2016 - Current
QA Analyst
Developed reports, dashboards, and processes to continuously monitor data quality and integrity. Created and updated users.
Managed ongoing support request and administrative needs of users.
Designed, setup and maintained Salesforce standard objects, custom objects and junction objects, while also structuring user roles, security profiles and workflow rules.
Good experience with Excel, including Macros, VBA, Formulas, Pivot Tables, and Vlookups.
Testing software to ensure all operation are working as expected.
Reviewing test document for completeness and accuracy modify the document when needed.
Writing test cases using with Agile methodologies.
Creating Change Request as per customer request.
Familiar with Change management and configuration management.
CVS Caremark, Buffalo Grove IL 04/2014 – 2016
Senior Java Production Support Analyst
Responsible for Tier I software and hardware support.
Troubleshoots and restores routine technical service and equipment problems by analyzing, identifying and diagnosing faults and symptoms using established processes and procedures.
Working with HP Quality Center for quality management software
Performing Functional, Integration, and System Integration testing
Responsible for application maintenance
Run reports for user request using SQL in DB2
Working in a team setting, sharing information, training and assisting others with work orders
Collaborating with QA team to cover all aspects of SDLC & STLC process
BLUE CROSS BLUE SHIELD, Chicago IL 07/2012 – 11/2013
Technical Coordinator
Point-of-contact for internal customers needing technical assistance.
Coordinated all technology services between technical and business team.
In Siebel data management team monitored Unix scripts and log files.
Wrote Database Queries in SQL to retrieve data from the database. Updated db2 database as needed.
Created ad hoc reports for customers. Monitored application servers.
HEWLETT PACKARD, Naperville IL 2009 - 06/2012
ITO Service Delivery Consultant
Total accountability for administration, monitoring and business analysis activities of Open View Service Desk (OVSD). Served as a liaison for customer and management team to implement enhancements to OVSD. Responsible for planning, evaluation, directing, designing, tracking, analyzing and coordinating multiple complex projects. Developed and executed intricate technical tasks, applied analytical problem-solving methodologies and technical direction to team of support staff.
Executed many cost saving initiatives by providing proactive support for L2 and L3 level 24/7 support to meet 98 % availability SLA which saved approximately $200,000
Led OVSD team and provided direction to other team members which reduced downtime by 75%
Took additional responsibility as a business analyst when the previous analyst transitioned to different role, which saved about $100,000 in additional salary
Prioritized ticket escalation process and kept both internal and external customers informed of the status of the ticket which improved customer satisfaction scores by 75%
Prepared and implemented Disaster Recovery strategy and improved uptime by 5%
Periodical updating of Oracle database using Toad
Experience in gathering, documenting and analyzing user requirements
ALCATEL- LUCENT, Naperville, IL 1997 - 2009
Application Developer (iMerge Team)
Total accountability for administration, monitoring and business analysis activities of the OVSD. Administrated 50 applications for Application Operation and Monitoring (AOM) and Code Migration (CM). Managed SharePoint sites for customers. Maintained Oracle databases.
Tested client/server based application for company’s new product division
• Performed Functional, Integration, and System Integration testing manually
• Performed Regression testing using automation tool Quick Test Professional
• Worked with HP Quality Center for quality management software
• Collaborated with QA team to cover all aspects of SDLC & STLC process
• Worked closely with development team to discuss and resolve bug issues
• Created & executed manual test cases and test scripts based on the technical requirements document
Experienced in all phases of software development life cycle (SDLC) - Project Analysis, Requirements, Design, Development, Testing, Documentation and Deployment and also in Windows Client/Server Environment
Hands on experience in Developing Rich User Interface on web using Java Script, HTML, DHTML.
Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using PL-SQL in Development and Production environment for Oracle.
Wrote SQL Queries to create tables, stored procedures, and triggers using Oracle.
Created testing methodology and criteria using Load Runner
Created HP BAC (Business Availability Center) script for customers to monitor an application which identified causes of downtime. This reduced downtime by 50%
Collaborated with customer and HP SaaS team and created script to monitor application availability for the external sales web site which reduced downtime to almost 0%
Worked with offshore teams and third-party vendors to provide AOM/CM support for applications that helped increase sales by 50%
Worked in a team monitoring compliance of core guidelines and other internal controls as part of the IT governance process
Led the six person cross functional Disaster Recovery team and created Disaster Recovery document which helped the process to run smoothly
Mentored new team members and helped them to learn IT protocols
Application Developer (EPOCH Team)
Assisted Configurator team with the development and implementation of tools to support new product line 7R/E Packet Solution Product for iMerge. Developed rules based “ordering wizard” for ordering packet solution equipment. Performed project management duties for multiple Configurator and bid quote tools for telecommunication switch equipment. Created functional test cases for EPOCH (Electronic Product Ordering Configuration and Handling). Designed and coordinated Test Plan for various configuration and bid quote tools.
Manually tested Web based application
• Created & executed test cases and test scripts with positive & negative scenarios
• Performed Cross browser, functional, system integration, GUI, Ad-Hoc testing activities manually
• Agile methodology with daily scrums to discuss bug status
• Worked in correlation with client to better understand requirements and make detailed test cases and test scripts
Led a team of three QA personnel and seven end users to create the complaint handling system. Perform reviews, walkthroughs, or inspections. Provide application instructions for users. Design and executive test plans on computer applications. Managed production releases.
Engineered and developed 5ESS Switch units for modeling tool (predecessor to bid tool). Using Lotus 1-2-3 automated process and saved 75% on ordering time
Coordinated efforts of eight testers and 800 system modification requests (MRs) for initial deployment of system for an on-time delivery raising satisfaction by 100%
Automated the modification request tracking tool using Visual Intercept. This saved 50% – 60% time for the customer
Built and uploaded test loads for bid quote tool using Visual Basic and Access which allowed customer to down load the tool faster and easier