Muthuraman G Mail ID: acv1ne@r.postjobfree.com Mobile Number: +1-469-***-****

Summary

Overall 10+ years of experience in IT Industry

8+ Years of experience in SQL Server 2000, 2005, 2008, 2008 R2, 2012 and 2014.

6+ Years of experience in Microsoft Business Intelligence (DTS, SSIS and SSRS).

3+ years of experience in managing team.

More than two years of experience in PDW (Parallel Data Warehousing).

Having Strong Knowledge in TIBCO Spotfire.

I have Valid H1B Visa and Currently I am working in Client place at Dallas, TX.

Strong exposure in understanding business process and handled highly complex business logics in SQL Server.

Hands on experience in Performance tuning with measurable performance management

Expertise in debugging and error handling.

Having Domain Knowledge of Supply Chain Management, Aviation and Insurance Domain.

Exposed to version control configuration system like TFS, Microsoft Visual Source Safe (VSS) and Tortoise SVN.

Experienced in working with tools like Ramco Virtual Works (RVW) and JIRA.

Experienced in the areas of programming, Testing, Software Implementation and Customer Support

Analysis of critical issues and providing quick, feasible solutions and co-ordinate implementation of the same with Onsite.

Guiding and mentoring juniors by giving domain knowledge transfer and Technical presentation.

Extensively worked in Agile and SCRUM development practices.

Educational Qualification

MCA from Faculty of Engineering and Technologies (Annamalai University) Year 2003 in First Class (7.15 CGPA)

B.Sc., Mathematics from Govt. Arts College (Madras University) Year 2000 in First Class (70.31%)

HSC from Board of Tamil Nadu Year 1996 in First Class (61%)

SSLC from Board of Tamil Nadu Year 1994 in First Class (67.4 %)

Experience Details

Working as System Analyst in Hexaware Technologies, Chennai. (July 2013 – Till Date).

Worked as Database Architect in Zylog System Ltd. (February 2007 – July 2013).

Worked as Programmer in Ramco System Ltd. (A SEI CMM Level 5 Company), Chennai.

(February 2006 – February 2007).

Worked as Software Engineer in Take Solutions Pvt. Ltd. (A SEI CMM Level 5 Company), Chennai. (April 2004 - February 2006)

Worked as Programmer Trainee in N-3 Cluster solution Pvt. ltd., Chennai. (April 2003 - March 2004)

Technical Skills

Operating Systems : Windows Server 2003 / 2000 / 7 /XP

Language : C#. Net, VB.Net, XML, C

Databases : SQL Server 2012/ 2008 / 2005 / 2000, Oracle10g and MS - Access 2000

Internet Programming : HTML, ASP 3.0, ASP.NET

Version Control System : SVN (Subversion), VSS 6.0 (Visual Source Safe) and TFS

Application Server : IIS

Reports : SSRS, Crystal Report, Active Report and TIBCO Spotfire.

ETL Tool : SSIS

Achievement

Awarded the “STAR Award” (November `2015) by Hexaware Technologies for showing the Strong Programming Skills and Client Interaction.

Awarded the “Significant Contribution in ICMS” (July `2010) by Zylog System Ltd for showing the Strong Programming Skills.

Awarded the “Best Performer” (September `2006) by Ramco System Ltd for displaying Strong Programming Skills and Domain Knowledge.

Awarded the “Employee of the Month” (July`2005) by Take Solutions Limited for displaying Strong Customer Orientation Skills.

Certification

Designing Business Intelligence Solutions with Microsoft SQL Server – 70647(Certification Number: F080-9830 and Date of Achievement: 29/November/2014)

Projects Experience

Enterprise Data Warehousing R2 – Mercury Integration March 2014 – Till Date

EY - USA

The Mercury Integration Project involves in creating a data warehouse with help of PDW to meet customer needs on management reports.

The main scope of the project is move data from EDW to APS and to automate the process of bringing the source data into APS ODS layer.

The Data’s are received from different source systems and same is processed through SSIS Package with help of “DWLoader” tool.

Role: Senior Developer & Team Lead.

Domain: TAX and Advisory

Organization: Hexaware Technologies, Chennai, Tamilnadu, India.

Responsibilities:

Understanding various source systems in discovery phase.

Involved in creating SSIS package for different source system.

Participated in technical discussion with Onshore/Offshore and Knowledge sharing with team members.

Involved in unit testing of SSIS package with Source file.

Involved in SSIS Package deployment process.

Technology Environment

Windows 2000, SQL Server 2012 PDW (APS–AU2 - Dell appliance with 9 Compute Node Rack), SSIS, TFS and Visual Studio 2012 with SSDT.

Audit Resource Management System (ARMS) Nov 2013 – Feb 2014

EY - USA

The ARMS Project involves in creating a data warehouse for the customer to meet their needs for management reporting.

The reports are planned to be designed and deployed in the Share point Portal maintained by the client. The self service capabilities to generate Ad-hoc reports were also planned to be generated using the Reporting services.

The Management information is planned to be delivered to their six divisions.

Role: Team Lead

Domain: TAX and Advisory

Organization: Hexaware Technologies, Chennai, Tamilnadu, India.

Responsibilities:

Involved in business and functional requirement gathering

Creating technical specifications for SSIS development work

Understanding client various source systems in discovery phase.

Involved in creating Conceptual and Logical data model

Involved in creating the design documentation for Data Mart

Participated in technical discussion with onshore/Offshore and Knowledge sharing with team members

Creating SSIS Package and SSRS Reports

Technology Environment

ASP.Net, SQL Server 2012, SSRS and Crystal Report

IB Management Information July 2013 - Oct 2013

IB - UK

The IB Management Information Project involves in creating a data warehouse for the customer to meet their needs for management reporting.

The reports are planned to be designed and deployed in the Share point Portal maintained by the client. The self service capabilities to generate Ad-hoc reports were also planned to be generated using the Reporting services.

The Management information is planned to be delivered to their six divisions.

Role: Team Lead

Domain: Insurance

Organization: Hexaware Technologies, Chennai, Tamilnadu, India.

Responsibilities:

Involved in business and functional requirement gathering

Creating technical specifications for SSIS development work

Understanding client various source systems in discovery phase.

Involved in creating Conceptual and Logical data model

Participated in technical discussion with onshore/Offshore and Knowledge sharing with team members

Creating SSIS Package and SSRS Reports

Technology Environment

SharePoint 2010 and SQL Server 2012, SSIS & SSRS

ICMS (Injury Claims Management System) Jan 10 – July 2013

Carlisle Medical Inc, USA (http://www.carlislemedical.com)

Carlisle Medical Inc (CMI - http://www.carlislemedical.com) is a leading provider of value added services related to workers’ compensation, for both injured Workers and their Insurers, to ensure timely and effective service to the injured worker, at the same time minimizing cost to their Insurers. CMI has been in business for more than 25 years and has grown to serve about 200 Clients presently.

Provide an integrated view of all three applications – DME, RESTAT & MailRx so that CMI can serve Clients effectively

Provide access to Clients, so that they can have real time access to information pertaining to them

Provide other features such as role based access, online approvals, generation of effective reports etc

Role: Team Leader and Sr. Database Programmer

Domain: Insurance

Organization: Zylog Systems Ltd, Chennai, Tamilnadu, India.

Responsibilities:

Involved in Requirements gathering, Software Requirement Specification.

Developed the Unit Test Cases for the modules.

Analyze system specifications and translate system requirements to task specifications for junior programmers

Creating the SSIS Packages and SSRS Reports based on the Client Requirement.

Collaborative development techniques as well as knowledge of Project management discipline within Information Technology field.

Writing Stored Procedures and functions.

Unit test Case development and Execution.

Ability to solve problems quickly and completely.

Provide assistance to testers and support personnel as needed to determine system problems.

Deploying the Project in Client’s Place thru VPN and interacting with the clients.

Resolve database performance issues and other distributed data issues.

Deployment of the product in Testing, Quality, UAT and Production servers

Team management

Executed tasks in most of the stated roles above, depending on project’s needs.

Validated and deployed software solutions at the customer site.

Technology Environment

ASP.Net, JavaScript, AJAX, MOSS 2007, Visual Source Safe, XML Web Services, SQL Server 2005 & 2008, SSIS and SSRS

BMS Jul 2008 - Dec 2009

Coverpoint - UK

The aim of this project is to develop a web-based application, which can be used by BMS Groups for their Errors and Omissions insurance business.

This web-based application will be externally hosted and supported by Cover point. Insurance Agents, Broker (Willis) and Underwriters will use the application. In this Project we have covered the following modules:

Modules: Insurance Quotation and Firm Order, Mid-Term Adjustment, Reports, Renewals and Email Alerts.

Role: Sr. Database Programmer

Domain: Insurance

Organization: Zylog Systems Ltd, Chennai, Tamilnadu, India.

Responsibilities:

Writing Stored Procedures and functions.

Develop, implement and maintain unit tests of database programs

Resolve database performance issues, replication and other distributed data issues.

Manage backup and recovery of databases.

Monitor databases for errors and perform problem determination when necessary.

Deploying the Project in Client’s Place thru VPN and interacting with the clients.

Integrating the components and identifying the issues and person responsible to fix the issue and troubleshooting.

Technology Environment

ASP.Net, C#.Net, JavaScript, AJAX and SQL Server 2005, SSIS & SSRS

CORE Framework Aug 2007 - Jul 2008

Coverpoint - UK

The aim of this project is to provide the Framework named as Core. Core Framework used to develop the web application which provides the entire business rule defined by the Coverpoint.

This application will have various Functions features like creating new quotes, submission, quote selection, binding, document production and correspondence, mid-term adjustments, Bordeaux reporting.

This Project will be used to configure common controls and product specific controls to be displayed in a single page. And also able to set the control to be enabled or disabled. To achieve this functionality, we need to save all the control information in the database level. Whenever the user does changes with this configuration, our system should reflect the changes in the relevant screens.

It will be a time consuming job to implement the logic and testing the functionality.

Role: Sr. Database Programmer

Domain: Insurance

Organization: Zylog Systems Ltd, Chennai, Tamilnadu, India.

Responsibilities:

Involved in Requirements gathering, Software Requirement Specification.

Coding and Bug fixing.

Unit test Case development and Execution.

Writing Stored Procedures and functions.

Ability to solve problems quickly and completely.

Provide assistance to testers and support personnel as needed to determine system problems.

Coding and Bug fixing.

Deployment of the product in Testing, Quality, UAT and Production servers.

Enforce database standards and procedures.

Database designing, database performance, management and tuning experience.

Determine appropriateness of data storage and backup strategies

Technology Environment

ASP.Net, C#.Net, JavaScript, and SQL Server 2000

Bloodstock Feb 2007 - Aug 2007

Willis (www.willis.com)

Cover point is a software application supporting the Insurance business of Willis.

It has online facilities trading platform has been chosen to support Willis aim to attack and grow market share in medium value business (approximately £200-£10,000 brokerage with the aim of processing higher still) and to support a leap in processing efficiencies.

This document is a result of gathering business requirements primarily from Willis Bloodstock line of business. The web-based application will be externally hosted and supported by Cover point.

There will be no integration with existing Willis systems, there will not be integrated billing or claims handling facilities. Agents, Willis and Underwriters will use the application. In this Project we have covered the following modules:

Requesting for the Quote

Requesting firm Order

Mid-Term Adjustment (MTA)

Role: Database Programmer

Domain: Insurance

Organization: Zylog Systems Ltd, Chennai, Tamilnadu, India.

Responsibilities:

Unit test Case development and Execution.

Ability to solve problems quickly and completely.

Provide assistance to testers and support personnel as needed to determine system problems.

Coding and Bug fixing.

Deployment of the product in Testing, Quality, UAT and Production servers.

Technology Environment

ASP.Net, C#.Net, JavaScript, and SQL Server 2000

Personalized Assembled Aviation Solutions Feb 2006 - Feb 2007

Safe Air Limited, New Zealand

For aviation owner/operators, aircraft maintainers, and third-party MRO providers, Ramco has customized Virtual Works into an industry-specific package called Personalized Assembled Aviation Solutions. This product brings together the software applications that these users need, with modules such as Aircraft and Components Records management, Configuration Management, Maintenance Planning, Maintenance Program, and Reliability Analysis

The Aircraft Setup and Component Setup module is centered on a database that records all aircraft subassemblies and components used by the software owner, whether they are in the warehouse or on-aircraft. It can capture data such as component manufacturer, MSN, model, part ownership, and part flight hours/cycles. Aircraft and Component Records can also monitor each part's remaining life cycle, based on user-defined parameters.

Ramco's Aviation Solutions covers all elements of aviation management, including technical records, Configuration Management module, engineering, operations, maintenance, e-signatures, material management, financial, human resources, Sales management, Procurement management and decision support.

Role: Database Programmer

Domain: Aviation

Organization: Ramco System Ltd, Chennai, Tamilnadu, India.

Responsibilities:

Experience in database objects development.

Experience in Crystal reports development.

Experience in migration through Vembu Porting tool.

Determine appropriateness of data storage, archive, purge and backup strategies.

Database designing, database performance, management and tuning experience.

Enforce database standards and procedures.

Provide technical leadership and mentoring to others on the team.

Technology Environment

RVW 1.4.3 with .Net, XML, JavaScript, SQL Server 2005, Crystal Reports 11, SSIS and Vembu Porting tool

TAKE-HUB Jun 2004 - Feb 2006

IAL Shipping Corporation (P) Ltd., Puzhal and Dubai

TAKEHUB sub Product of the take suite, which is the Virtual distribution network to manage multiple remote hub (warehouse) operations.

Quick user-controlled location setup and easy to establish and control Zone, aisle, rack, bulk, and bin locations.

Tight integration of Inventory control and order management to meet guaranteed order commitments. Directed workflow to capitalize on space optimization.

Automated rating of the Product based on the stock movement.

Pick List generated based on FIFO.

Automated Time stamp Resource Management Tool to optimize the utilization of resources.

Monitoring Demand Forecast of the Complementary items based on the movement of the main Product.

It comprises of the following sections.

Masters

Receipts

Storage

Issues

Active and Resource Sheet (ARS)

Location Management

Value Addition

Role: Software Engineer

Domain: Supply Chain Management

Organization: Take Solutions Pvt. Ltd, Chennai, Tamilnadu, India.

Responsibilities:

Involved in Requirements gathering, Software Requirement Specification.

Experience in Active report development

Coding and Bug fixing.

Unit test Case development and Execution.

Ability to solve problems quickly and completely.

Provide assistance to testers and support personnel as needed to determine system problems.

Coding and Bug fixing.

Deployment of the product in Testing, Quality, UAT and Production servers.

Technical Environment

ASP, XML, JavaScript, SQL Server 2000, Active Reports and IIS 5.0

I Point Apr 2004 - Jun 2004

Britannia Industries Limited

IPoint is SCM based software that helps in organizing the flow of products from the supplier to the consumer.

It comprises of the following Modules Sales, Purchase, Accounts, Stock, Admin, Reports, Security and Management.

Role: Programmer

Domain: Supply Chain Management

Organization: Take Solutions Pvt. Ltd, Chennai, Tamilnadu, India.

Responsibilities:

Unit test Case development and Execution.

Experience in Active report development

Coding and Bug fixing.

Ability to solve problems quickly and completely.

Provide assistance to testers and support personnel as needed to determine system problems.

Deployment of the product in Testing, Quality, UAT and Production servers.

Technology Environment

Windows 2000, VB and SQL Server 2000

HELP DESK Apr 2003 - Mar 2004

N-3 Cluster solution Pvt. ltd., Chennai

Helpdesk is an easy to use solution that manages an organization’s support department to improve its productivity & efficiency. It helps in bridging the gap between organizations and their customers, both internal and external.

Supports remote access to end user's desktop to reduce response time. It have features of Registers complaints / requests from anywhere, Priorities, sorts and filters issues, Identifies unusual issues and tracks trends, E-mail alerts and escalations, Query and keyword search capabilities - knowledge base, Supports file attachments, Supports multiple departments / multiple offices spread geographically, Scalable and Supports login based access only.

Role: Programmer Trainee

Domain: Supply Chain Management

Organization: N-3 Cluster solution Pvt. Ltd., Chennai, Tamilnadu, India

Responsibilities:

Unit test Case Execution.

Coding and Bug fixing.

Ability to solve problems quickly and completely.

Provide assistance to testers and support personnel as needed to determine system problems.

Technology Environment

ASP, Java Script, HTML, SQL Server 2000

Personal Details

First Name : Muthuraman G

Last Name : Ganesamoorthy N

Date of Birth : 8th July 1979

Known languages : English & Tamil

Passport No : L6190662

Visa Detail : Valid H1B Visa

Skype ID : live:ngmuthuraman

LinkedIn ID : Muthuraman Ganesamoorthy

Contact this candidate