Customer Service Data

SWARNARAJ (RAJ) SIVASUBRAMANIAM

#** ******* *****, ***********, **, M1X 1T9, Canada

Tel: 416-***-**** (Mob), 647-***-**** (Res), Email: **************@*****.**

Objective:

Obtain a position where I can apply my strong analytic and project management skills in the financial or manufacturing industry and achieve career growth.

Profile:

A self-managed and result oriented Business/Systems Analyst with 12 years experience in IT and over 9 years experience in Manufacturing Quality Assurance

-Strategic individual with strong interpersonal, communication, problem solving and decision making skills

-Ability to establish and maintain strong alliances; lead and motivate teams

-Drive projects to successful completion; convey complex technical requirements/data;

-Exceed customer expectations and achieve fiscal bottom-line results

HIGHLIGHT OF SKILLS:

12+ years’ experience in data queries, database administrations, data warehousing, data collection, consistency checks, data modeling & mining, predictive analysis, control data quality, data merging, using SAS, SQL 2012, MS Excel and MS Access

10+ years of Expertise in creating reports, pivot Table/graph, v-lookup table, macros, if conditional functions, conditional formatting, complex queries, tables match, VBA macros, frequencies, cross tables, data profiling, cleansing, data matching,

Knowledge on Relational database, joining tables, forms, controlling data entry, flexible queries, customize reports, sharing data across applications, data security, SQL queries using advanced Excel and Access

Proficiency in Microsoft Applications 2003/2007/2010, VB, MS Project, MS Visio, SAS 9.2, FoxPro, Clipper, SQL server 2012, Oracle PL/SQL, IBM DB2 Windows

Expert in data conversion, data integrity and data extraction among flat file, MDB, txt, DBF, DAT, CSV, SQL Server, MS Excel, Microsoft Access, MS Project, & SAS

Create master database to analyze customer and company data to create and implement quick-campaign and marketing campaign

Expert in managing projects, analyzing survey-based marketing research data, business analysis, Business Intelligence (BI), Data warehousing, generating and presenting statistical reports

Experienced in root-cause analysis, problem solving, reporting systems and identify research indicators

Strong analytical knowledge of business objects and business requirement

A depth in knowledge on Project Management and Lean Project for Lean Enterprise

Followed Certified Business Analysis Professional course

Trained on Sig-Sigma Green Belt

Trained in Software Testing & QA

PROFESSIONAL EXPERIENCE:

ESTABLISHMENT: ROYAL KITCHEN LTD.,

From: Oct 2015 – To Date; Installation & Customer Service Co-ordinator

Scheduling Installation & Services

Managing the installation & Post installation services

Customer Service

Contract Management

ESTABLISHMENT: LUCVAA KITCHEN LTD

From: Oct 2014 – Oct 2015; Installation & Customer Service Co-ordinator

Scheduling Installation & Services

Managing the installation & Post installation services

Customer Service

ESTABLISHMENT: WOODNOTE KITCHEN & BATH LTD

From: June 2008 – June 2013; Business Systems Analyst & IT

Determines operational objectives by studying business functions; gathering information; evaluating output requirements and formats.

Designs new computer programs by analyzing requirements; constructing workflow charts and diagrams; studying system capabilities; writing specifications.

Improves systems by studying current practices; designing modifications.

Monitors project progress by tracking activity; resolving problems; publishing progress reports; recommending actions.

Maintains system protocols by writing and updating procedures.

Provides references for users by writing and maintaining user documentation; providing help desk support; training users.

Maintains user confidence and protects operations by keeping information confidential.

Prepares technical reports by collecting, analyzing, and summarizing information and trends.

Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.

Contributes to team effort by accomplishing related results as needed.

MAGICKWOODS LTD, A KITCHEN & BATH VANITY COMPANY

From: June 2003 – June 2008; Quality Assurance Analyst; Installation & Service Manager

Responsible Reporting on Quality Assurance of company’s production to CEO

Development of Quality reports such as First Article Report, PPAP, CAPA, NCRs for Management

Management of Inventory Database and Inspection Scheduling

Managing In-Process Inspection & Managing the Quality Inspectors

Meet the Quality Standards along with Production team on Finish Products

Vendor/Customer Quality Management, visiting overseas vendor for factory audits

Establish policies and procedures for departmental improvements

Report to CEO on Quality in terms of Cost, Improvements, Disputes & recoveries

Managing Installation and customer inquiries

HEMTOURS (PTE) LTD., HEMAS GROUP

Dec 1994 - May 2003; Senior Systems Analyst/Programmer

COMPUTER HOUSE (PVT) LTD.,

Sep 1992 - Dec 1994; Computer Application Programmer

EDUCATION, TECHNICAL TRAINING & KNOWLEDGE AREA;

-Diploma in Computer Programming

-Australian Computer Society (ACS)

-British Computer Society (BCS I) & BCS Professional Project

-Diploma in Networking and Followed A+ Certification course

-Systems Administration on Windows NT & Lotus Domino 4.6

-Unix – SCO Open Server

-Oracle 8.0, Developer 2000

-Java 2 Programming including Advance swing components, JDBC, Serve lets and Java Beans

-IBM DB2 - Work Group & Enterprise Edition for Windows NT & 2K Servers

-SUN Solaris rel 9.0

-Active Directory Design & Implementation on MS Windows 2003 Server, MS Exchange Server/Client

-Followed Certification in Quality Assurance course at Seneca College (Basic Quality Concepts, SPC, Advance SPC, Quality Audit, Quality Management, Reliability, Design of Experiments (DOE)

-Statistical Analyst Software 9.2 (SAS)

-Project Management (PMP)

-Trained in Six-Sigma – Green Belt

-MS-Office Application 2003, 2007, 2010, 2013

COMPETENCY BASED EXECUTIVE TRAINING:

-Time and Relationship & Customer Service Management

-Leadership & Leadership Qualities

-Total Quality Management in order to obtain ISO certification

-Trained in WHMIS and Fall Arrest Safety Courses

REFERENCES available upon request

Contact this candidate