Management Sql Server
Resume:
Muthuraman G Mail ID: ************@*****.*** 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