M urugesan Chidambaram (MURU)

_______________________________________________________________________

abi6wi@r.postjobfree.com 818-***-**** 10 Carova Beach Place, Sacramento, CA 95835

Summary

• Over Thirteen years of experience working in Information Technology field doing

analysis, design, implementation, testing, maintenance, documenting and production

support for Databases, Business Reports and both Windows & Web based Applications.

• Have excellent communication, analytical, problem solving, debugging,

interpersonal and teamwork skills. Have strong knowledge of Data warehousing and

Business Reporting, Application development and support, Relational databases,

Database Administration.

• Work experience includes in the fields such as Insurance, Telecom, Software, Transport,

Retailing industries developing applications, reports, analytical cubes, data models,

databases, coding standards, database fine tuning and performance improvement.

Duties and Responsibilities

Design and Implement data models and databases.

Design, create, and optimizes tables, queries, views and stored procedures.

Create ETL processes utilizing SQL Server Integration Services (SSIS).

Develop complex reports utilizing SQL Server Reporting Services ( SSRS), Crystal

Enterprise and Business Intelligence.

Create Cubes, Virtual Cubes, Dimensions using star schema using SQL Server Analysis

Services (SSAS).

Design and implement data warehouses.

Establish and enforce database development standards such as naming conventions.

Research, recommend, and implement any tools or technologies that help the team

develop applications that are efficient and easy for maintenance at the same time.

Learn and be informed on new technologies and development best practices.

Work directly with business stakeholders to understand end users’ needs and prepare

detailed requirement document before the actual implementation.

Discuss with team and project managers and get everyones input/approval on

application/database design and functionality.

Technical Skills

Databases: SQL Server 2008, 2005, 2000, Oracle 10, MS-Access, DB2

Languages and Tools: Visual Studio, .NET, VB.NET, C#, ASP.NET, XML, JAVA SCRIPT,

T-SQL, Cognos, MS-Office, Business Intelligence Development

Studio, SQL Server Reporting Services, SQL Server Integration

Services, Crystal Reports, DTS, Analysis Manager, SQL Management

Studio, Query Profiler.

Education

Masters degree in Computer Applications (M.C.A) from Madurai Kamaraj University, India (1994-1997).

Bachelor ofScience in Computer Science from Madurai Kamaraj University, India (1991-1994).

Employment History

Working for CSAA IIB, Walnut Creek, CA from August ’05 to Present as IT

Consultant II

Worked for International Solutions Group, Herndon, VA from March 2003 to July ‘05 as

Programmer Analyst.

Worked for DIRECTV Broadband Inc., San Jose, CA from March 2002 to February 2003

as Sustaining Engineer

Worked for BPL Systems Limited, Norcross, GA and BPL Telecom Limited, Bangalore,

INDIA from January 2000 to February 2002 as Systems Analyst

Worked for Maitri Computers, Bangalore, INDIA May 97 to December 99 as Software

Developer.

Project Experience

CSAA Walnut Creek, CA Aug’05 – Present

Team: Business Performance Management and Support

Developed ETL Processes SSIS and DTS Packages and Jobs and scheduled and monitored for

automatic extract, transformation and loading of data from systems such as

o Memberpoint, (CRM application)

o ResponseTek (customer service survey)

o NICE (call monitoring and evaluation for QA)

o Call Data from Aspect/Avaya (Oracle DB)

o Leads Generation

o Post Call Survey,

o OnmyWay (employee HR data from peoplesoft)

o IEX (attendance data)

o VOC CFAS (web application developed by me to capture member experience)

o into OLAP Schema.

Created cubes, virtual cubes, dimensions, shared dimensions, measures, calculated measures and

OLAP reports using AimCall OLAP Reports Interface and also developed numerous reports.

Developed Customer Feedback Analysis system (CFAS) for Voice of the Customer group. It’s a web-

based application I developed from end to end using ASP.NET, VB.NET, SQL Server, VBScript, Java

Script.

Developed Cross-Tab, Standard, Drill down, Drill thru, Subreports, Graphical Reports, Scorecards,

Dashboards using SSRS, Crystal Reports and Cognos.

Provided on-call support to monitor the ETL jobs by setting up email alerts to cell phones and act on

process errors immediately even during non-business hours.

Team: Voice of the Customer

Created databases and processes in SQL Server to pull Membership dimensions data

such as MRV, Tenure Group, Product Type to name a few for millions of memberships.

Created EXCEL pivot reports for analysis and created several reports that were used by

Marketing Executives, VOC management and to the President Paula Downey.

Team: Enterprise Portfolio Management Group

Developing reports and publishing the reports using Crystal Report 10 and Crystal

Enterprise Server 10.

Converted the Prosight application forms used by ePMO group into reports.

Extracted column information from Prosight using Archive and Freeze utility.

Created Oracle Views from Prosight form fields to use in Reports.

Environment Used: Windows Server 2003, Crystal Reports 10, Crystal Enterprise

10, Oracle 9.2, SQL Plus.

Embarcadero Systems Inc., Alameda, CA Sep’03 – Jul’05

Terminal Operating System Developer for Marine Terminals Corporation

Worked as a developer and played a vital role in the design, development and

maintenance of Terminal operating system application and its various sub systems. Used

Visual basic 6, VB.NET, C#, ORACLE, SQL Server, Windows socket, COM/DCOM and

other tools and technologies to develop the system.

Developed several complex reports relating multiple tables, utilizing formulas and

parameters for gate in/out summary, cargo manifest, booking, demurrage collection,

wheel tickets, and several other modules using Crystal Reports 9.0, Crystal Enterprise

and Crystal Analysis Pro tools.

Developed the applications and supporting DLLs using VB6, VB.Net, C#, ASP.NET,

ADO.NET in Windows 2000/NT, Oracle, SQL, MS-Access environments.

KANA Software Inc., Menlo Park, CA Mar’03 –Aug ‘03

Database Upgrade and Verification Consultant

Installing and configuring KANA Response Server and KANA Web Server application

in Windows 2000/NT, Sun Solaris, and AIX platform.

Migrating customer databases from older version and verifying the correctness of

upgrade.

Upgraded the databases to SQL Server 2000, Oracle 8.1.7.4, DB2 7.2 from their

respective older versions

DIRECTV Broadband, San Jose, CA Mar’02 –Feb ‘03

Sustaining Engineer

Investigated and fixed the problematic code that affects the performance of

the system in production environment. This includes fixing ASP Code, Optimizing

Stored Procedures and Views, creating additional indexes for tables and archiving of

data from huge tables.

Fix customers record in production database by writing backend SQL queries for any

one off issues.

Provide 24/7 on call support to any production issues.

Monitor health of web application and database servers.

Develop and deploy bug fixes and patch programs to the DIRECTV Order

Provisioning systems.

BPL Systems Limited, Norcross, GA Jan’00 –Feb ‘02

Projects

InputAccel & Dialog Server, ActionPoint, San Jose, CA

Easyjet Airlines Reservation system, Bullet Proof Technologies, Los Angeles, CA

Contractor for Sustaining Engineering Group at DirecTV Broadband Inc San Jose, CA

Maitri Computers, Bangalore, INDIA May’97 –Dec ‘99

Projects

Transport Management System - Apr ’99 to Dec ’99

Point of Sale & Financial Accounting System - Oct ’ 98 to Mar ’ 99

Integrated Office Automation System - Dec ’ 97 to Sep ’ 98

Contact this candidate