Sr Business Analyst

ARUNKUMAR C

Email: *******@*****.***

Ph: +91-967******* / +91-814*******

Objective

To join a dynamic and progressive organization offering ample opportunities for diversified experience, enhancement of professional skills and growth of career.

Skills Summary

Proficient in technical analysis, gathering functional and technical

requirements, architecture designing and documentation.

4.3 years of extensive experience in Analysis, Design and

Development.

Comprehensive understanding of SDLC and Methodologies.

Career Highlights

Systems Analyst – Avatar IT Solutions PVT LTD, India (May 2010 – Till Date)

Working for client Sprint Nextel, USA.

Client introduction:

Sprint is the leading telecommunication company in U.S. Sprint is the first company to introduce 4G wireless network in the national carrier in 2010. Sprint is No. 6 company on Newsweek list of 500 Greenest Companies in U.S.

Project: Sprint Customer Care Infrastructure

Customer Care Infrastructure gets data from different ‘Switches’ include - - Avaya, Rockwell, Aspect, Symposium and IPCC. Call data from these switches pulled directly from various sources like databases tables, text files and CSV files created by the site for processing. Loading of this data has been done through various methods (Jobs) due to the assortment of switches used or database access permission granted by the sites. These jobs primarily use SQL loader to load the data into the call tables of Customer care database. Regardless of method, this data is loaded into our local database to be used in call reporting.

Reporting:

Billing Adjustment data is mainly used by Program Operation and Executive Reporting Team in the Customer Care Organization. Billing adjustment is mainly an error correction in the customer billing statement. An error is when a customer has been billed incorrectly due to a system or setup issue caused by Sprint. If it cannot be determined that specific charges were caused by a Sprint error but the customer believes this has occurred and insists on a credit, it is appropriate to trust the customer and provide an adjustment after appropriate research has been completed. It is appropriate to subtract the Monthly Recurring Charge (MRC) from the adjustment for the period the customer should have had the service that would have prevented the average or casual charges. A retailer's adjustment request is handled by National Sales Support

Project Period: On-Going

Technology Used: Oracle 10g DB SQL & PL/SQL

Roles and Responsibility:

Database design and system analysis as per the system requirement.

Coded PL/SQL Procedure, Functions, Triggers, Cursors etc.

Generate Reports using SQL Queries.

Performance Tuning in SQL & PL/SQL.

Modifying existing Stored Procedures, functions, Triggers for enhancement purpose.

Existing Bug Fixing.

Software Engineer – Sidhi Infotech, Bangalore (June 2007 – May 2010)

Project: Payroll Management System

The payroll management system deals with processing payroll of various groups. Group is employer which request third party to process its payroll. Third party will make the payroll service available to the specified users of that group. Group would enroll the employees to our system through portal or they will send the .csv file for bulk loading using SQL Loader. Once all required info like rates, earnings, deductions, State/Local, Leave, Federal Filing, Deposits etc., are available payroll is processed based on the pay cycle and payroll schedule. Dynamic reports can be generated based on the user requirement.

Project Period: June 2007 – December 2008

Technology Used: Oracle 9i SQL, PL/SQL

Roles and Responsibility:

Database design and system analysis as per the system requirement.

Coded PL/SQL Procedure, Functions, Triggers, Cursors etc.

Generate Reports using SQL Queries.

Modifying existing Stored Procedures, functions, Triggers for enhancement purpose.

Existing Bug Fixing.

Project II: Portal Benefits

Portal benefits provide services to the various Employers and Employees who are having medical insurance with third party and Other Insurance Companies. Groups provide various plans and network to employees and they are eligible for the benefits only after waiting period. Termination of an employee involves termination of his plan, network and coverage.

Project Period: February 2009 – May 2010

Technology Used: Oracle 9i SQL, PL/SQL

Roles and Responsibility:

Database design and system analysis as per the system requirement.

Coded PL/SQL Procedure, Functions, Triggers, Cursors etc.

Generate Reports using SQL Queries.

Modifying existing Stored Procedures, functions, Triggers for enhancement purpose.

Existing Bug Fixing.

Educational Summary

Master Of Computer Application (JAN 2012) [Pursuing Final Group]

Directorate of distance education,

Icfai University,

Tripura.

Diploma in Information Technology (2004 - 2007)

Nettur Technical Training Foundation (NTTF an ISO 9000:2001 Institute)

(Considered as BSc-IT in ICFAI University).

Grade: First Class (65%)

Higher Secondary Certificate [12th] (2002 - 2004)

Tagore Matriculation Higher Secondary School

Deviyakurichi, Salem (DT).

Grade: First Class (72%)

Secondary School Leaving Certificate [10th] (2002)

Mary Immaculate Heart Matriculation Higher Secondary School,

Thiruvannamalai.

Grade: First Class (75%)

Skill Set

Database : Oracle9i & 10G

OS : Windows 2000, XP, 7

Languages : SQL, PL/SQL

Tools : SQL Developer, TOAD, HP Service Manager, HP Service Desk.

Certification Course

Oracle Certified Associate (OCA)

Personal Details:

Date of Birth : 28.08.1985

Father Name : Chakravarthi A

Sex : Male

Marital Status : Single

Language Known : English, Tamil.

Permanent Address : North Street, Eduthanour Post, Sankarapuram Taluk,

Villupuram(DT).

Phone : 096******** / 081********.

Declaration

I do hereby declare that the particulars of information and facts stated here in above are true, correct and complete to the best of my knowledge and belief.

(ARUNKUMAR.C)

Contact this candidate