More Related Content
What's hot (20)
Similar to GANESH -Certified Consultant (20)
GANESH -Certified Consultant
- 1. Page 1 GANESH V Mobile +65 94575451 vepganesh@yahoo.com VISA Status: PR-Permanent Residence Availability: Immediate Salary: Negotiable OBJECTIVE: Looking for a challenging position where my skills and experience will greatly enhance the company's success and provide personal growth. Career Summary:  Certified Professional with over 12+ years of professional IT experience in Architecture (Project design and Infrastructure sizing), Leadership, Analysis and Design and programming roles for various domains (Government Projects, Data Center, Pay Roll Processing and Billing System, Healthcare and Online E-Learning).  Currently working in HP (Hewlett Packard) as Technology Consultant for MSBI (SSIS/DTS, SSRS, SSAS- MDX), MDM,DQS,Oracleand SSRS integrated with Sharepoint Portal(via C#.net) Project using agile Scrum Methodology with middle wearTechnology, Singapore  Having thorough knowledge in SDLC (Software Life Cycle Development)  Well versed in Data Warehousing(Business intelligence, DTS/SSIS,SSRS and SSAS) Oracle 10 G and Informatica –ETL (IDQ) and DBA  Expertise in SSRS, Business Object XI, Qlikview, CRYSTAL REPORTS 9 & 10, Brio Reports and haveing Experience in Microsoft Visual Studio .net and SharePoint(Admin), VBScript and Power shell  Project management skills with capability to develop and manageproject plans  Good leadership skills and excellent abilities to understand user’s requirement and converting into specification based on technical feasibility and limitation  Adopt the adherence to global systems, standards, policies and procedures.  Positively influence others/team members to achieve results that are in the best interest of the organization  Ability to managelarge, complex ES (Enterprise) Projects/product developments, customization, implementation, data migration, data Integration and BAU, effort, costing, quality, time, budget and risk.  Sound Knowledge on ITIL Processing (Incident, Problem, and Change Management systems)  Extensively worked with structured approach and delivered projects using offshore-on-site delivery model.  Experience in interacting with different project/Domain‘s stake holders and project planning  Quick learner, passionate performer and Goal-oriented  Highly motivated, self-sufficient, and able to work well independently. SOFTWARE SKILLS SET Skill Name Skill Level Last Used Experience Data Warehousing Tools Expert Currently 10 Years SQLServer-2012,2008R2,2008,2005,2000 SSIS/DTS (Integration Services), SSRS (Reporting Service) and SSAS (Analysis Service) Expert Currently 8 Years MDX ,DMX, Reporting with Power Pivot and Excel, MDM,DQS Expert Currently 4 Years SQL Server DBA (Database Administrator) Advanced 2 Years Oracle 10G and 11G Expert Currently 6 Years DB2 and MY SQL Expert 3 Years
- 2. Page 2 Informatica 9+,IDQ and Unix scripting Expert Currently 3 Years Data Stage Advanced 1 Years Integrating SSRS with SharePoint/MOSS 2007&20010 via C#.Net and VB.net Advanced Currently 5 Years QlikView, Business Object XI, CRYSTAL REPORTS 9 & 10, Brio Reports Expert Currently 6 Years Operating System Windows 7, 8.1,Windows Server 2008,2012, Citrix Server and UNIX (Cent OS) CERTIFICATION: Querying Microsoft SQL Server 2012 Implementing a Data Warehouse with Microsoft SQL Server 2012 Oracle 8 HP-Exam HP004C435320 -Nonstop Structured Query Language ITIL - REG NO-4525845 Developing and Implementing Web Application(Internet and Intranet) with Microsoft Visual C#.NET Core Solutions of Microsoft SharePoint Server 2013 Education: MasterDegree –MCA (Master of Computer Application) EMPLOYMENT HISTORY: Working for HP as Technology consultant -Data Warehousing Tools forSOE Project, Singapore Project Title SOE Project Dec’09 - to Till date Technology consultant-Data Warehousing Tools (SSIS, SSRS, SSAS, Oracle) Cum 3rd Level Production Support (24/7) Team Size 21 Presentation Layer SQL Server 2008R2 (SSRS), QlikView and SharePoint 2007 Business Layer C#.net, Visual Basic.NET, ADO.net Provider and Excel Provider Data Layer SQL Server 2005, 2008, Oracle 10G, BMC Remedy, SUMMS (SCOM, eHealth , BPM , Opsware , Netcool, NetQos and TMART) , SCCM, Excel, MS-Access, MySQL, XML and ,GIAS –Web Reporter, Nvision and Contact Centre, SAP Development Tools SQL Server 2008 R2 (SSIS, SSRS,SSAS- MDX), Oracle, QlikView and C#.net DM Design Tools Erwin (Data Model) and Visio (ER diagram) Methodology Scrum Agile Operating System Windows 2008 & UNIX Period Dec-2009 to Till date Summary: Designing/Developing ETL (Using SQL script), ad hoc reports and Reports (Dashboard, Trend, Chart, Matrix, Dynamic report and sub report/Drill down) from various source such as SQL Server 2005, 2008 R2, Oracle 10G, BMC Remedy, SUMMS (SCOM, eHealth , BPM , Opsware , Netcool, NetQos and TMART) SCCM, Excel, MySQL, XML, Contact Centre, Nvision and GIAS –Web Reporter by using the full advantage of the Business Intelligence technologies in SQL Server 2005&2008R2 (SSIS, SSRS,SSAS) and Oracle 1) So far, I have designed and Developed 267 reports and 107 SSIS Packages for the above project 2) Data had been extracted from heterogeneous system/Tools and Products Duties and Responsibility:  Serve as the Primary contact for the project’s development matters with customers  Preparing POC for client meetings & Involved in Vendor SOW verification, Impact analysis, Infrastructure sizing
- 3. Page 3  Involved in Projects ACR (Architect) Review in Analysis, Technical Design, Construction and Implementation Phase of the project  Worked with Cross platform team(functional team, Global Architecture, Global Shared service team) in various projects  Submitted Application Landscape, Infrastructure Landscape diagrams, Application Design Diagrams and Data Model related to the projects and worked on Impact analysis of the System requirement changes related to projects.  Plan the application roadmap by researching and evaluating alternative best practices and technologies, and make recommendations for implementation  Involved and provided solution to Application Development team  Architecting/Designing and Developing ETL and Reports and DB Design  Preparing the necessary Data Model (SQL script to createa Database conforming to standards) using Erwin Tools  Involved in Back-End setup Replication, Performance, Tuning, Stored Procedure, SQL Functions, Views and creating Indexes, Cursor, Trigger, statistics, Ad hoc query to construct the database based on the user specifications as well as improve the Database’s performance.  Writing Web interface to back end (SQL (DDL,DML,DCL),StoredProcedure, UDF,UDDT, PLSQL and ORCACLE) and  Plan the application roadmap by researching and evaluating alternative best practices and technologies, and make recommendations for implementation  Execute the project according to the project plan  Set up files to ensure that all project information is appropriately documented and secured  Establish a communication schedule to update stakeholders including appropriate staff in the organization on the progress of the project  Review the quality of the work completed with the project team on a regular basis to ensure that it meets the project standards  Assess problem situations to identify causes, gather and process relevant information, generate possible solutions, and make recommendations and/or resolve the problem  Coordinating with other teams and management  Asset Management- Data Center (Warranty and End of Life) Key Achievements in my current Project in HP:  Organized and implemented the efficient work flow system that resulted in significant cost savings  Created and presented an excellent image of the company and its services to customers, and coordinated and communicated well with clientele and management at all levels  Provided new quality standards for better performance and reliability  Improved the accuracy of budget forecasts  Managed big budget projects and achieved project scheduled goals  Established good working relationships with customers/clients Project Title EDS – Integration with HP and HP Product (Ink, Printer) Price Forecast Oct’08 to Nov’09 Senior System Analyst – HP Singapore Brief Description: Merging all countries EDS Employees’ information (HP Stock/Share allocation, Pay roll and Time Tracking Application) into HP System and HP Product (Ink, Printer) Price Forecast Team Size 16 Presentation Layer ASP.Net, SQL Server 2008(SSRS) and Business Object XI and Crystal Reports Business Layer C#.net, Visual Basic.NET, ADO.net Provider and Excel Provider Data Layer SQL Server 2005, 2008, Oracle 10G, Excel, MS-Access, MySQL, CSV and Flat File Tools Oracle Designer, SSIS, SQL Server Reporting 2008, SSIS Oracle 10G Operating System Windows 2008 & UNIX Period Dec-2009 to Till date
- 4. Page 4 Duties and Responsibility:  Reporting to the Application Manager of Solutions  Responsible for leading Software Development teams (Oracle Application, Pay roll and Time Tracking Application) on customer projects as well as internally driven maintenance projects for all HP core project.  Develop project plans and pass it to the application manager to get approval for the implementation and track project execution, manage changes, develop and execute implementation plans.  Researching solutions to programming problems  Coordinating with other teams and management Project Title Payroll Application Data Center Consolidation Dec’06 to Oct’08 Warehousing Tools Analyst– HP Singapore Brief Description: The purpose of the DCC Migration is to reduce the application maintenance cost and keep all the application hosting in one place as well as keep all the application in the same standards. Migrated SQL server 2000 Databases to SQL server 2005 database (including DTS - SSIS) and Reports , Oracle Application from 9 to 10 I had designed and Developed 50 reports and Migrated 140 ETLs (SQL Server 2000) to SSIS Packages (SQL Server 2005) for the above project Team Size 12 Presentation Layer ASP.NET , SQL Server 2005(SSRS), Crystal Reports and Business Object XI Business Layer C#.net, Visual Basic.NET, ADO.net Provider and Excel Provider Data Layer SQL Server 2005, Oracle 10G, Excel, MS-Access, MySQL, CSV and Flat File Tools SQL server 2005 (SSIS, SSRS-SQL Server Reporting Service) and Oracle 10G and Informatica -ETL and C#.net Operating System Windows 2003 & UNIX Duties and Responsibility:  Serve as the Primary contact to deal the project’s development matters with main customer and HP Asia pacific reason and EMEA region user.  Preparing POC for client meeting and Involved  Architect/Designing and Developing ETL and Reports  Develop project plans and pass it to the application manager to get approval for the implementation then track project execution, manage changes, develop and execute implementation plans. Key Achievement in my previous project in HP: 1) Played key role in EDS and HP integration project and Data center consolidation (DB Servers) 2) Migrated UK|IRL payroll to a newer version 3) Developed and supported Time Tracking application for EMEA and Asia pacific region Worked for Singapore General Hospital, Singapore Project Title Internal Online Clerical Forms & Crystal Reports - Migrated ERP (SAP' database) System to MS SQL and Created .Net Application Nov’05 to Nov’06 DBA cum Senior Software ETL Developer Singapore General Hospital, Singapore Project Title EDS – Integration with HP Nov’05 to Nov’06 DBA cum Senior Software ETL Developer Team Size 4 Presentation Layer ASP.Net and SQL Server 2005(SSRS) Business Layer C#.net, Visual Basic.NET,ADO.net and SAP Provider Data Layer SQL Server 2005, 2008, Oracle 10G, Excel, MS-Access, MySQL, CSV and Flat File Tools SQL server 2005 (SSIS) and C#.net Operating System Windows 2003 & UNIX
- 5. Page 5 Brief Description: An Application developed for Singapore General Hospital-Singapore, Which automates the whole process of entering patient particulars, Billing forms, Medical information form, Official forms, treatment history and the crystal reports which give high level report for top management officer and day to report for clerical staff. Duties and Responsibility:  Maintaining the DB Servers and Focus on regular day to day DB activities  Developing the .net Application, ETL and Reports Worked for Ministry of Health Singapore Project Title MOH (Ministry of Health)–IRIS Mar’05 to Aug’05 Software Engineer - NEC, Singapore Project Title EDS – Integration with HP Mar’05 to Aug’05 Software Engineer Team Size 7 Presentation Layer Crystal Report 9 Business Layer C#.net , ADO.net and Oracle 8 Data Layer Oracle 8 Tools Crystal Report 9 Operating System Windows 2003 & UNIX Brief Description: An Application being developed for the Ministry of Health - Singapore, Which automates the whole process of entering patient particulars, Medical information’s, treatment history to identify the communicable diseases, Worked for PortNet, India Jan 02 to Jan 2005 Project Title I: Import and Export Operations of the Container Project Title Import and Export Operations of the Container Jan’02 to Jan ’05 Module Lead Team Size 7 Presentation Layer ASP.Net,C#.net ,Crystal Report 9 Business Layer C#.net , ADO.net and Data Layer Oracle 8 and SQL Server 2000 Tools Crystal Report 9,Visual Studio .Net, SQL Server 2000 and Oracle Operating System Windows 2003 & UNIX Brief Description: The Import and Export Operations of the Container was undertaken to streamline the export and imports formalities at the Container Terminal. It has infrastructure facilities for computerized container handling. Project Title II: PortNet Brief Description: This front end System is linking with SQL Server for the Data manipulation and Database maintenance Project Title IV: PortNet •Brief Description: Intranet System (Thin Client) is developed by using ASP.Net, Visual Basic.Net, and C #. The system compromises of 3 projects - Vessel Scheduling, Container Allocation and Container Booking. Worked for Accel Private Limited as Software Engineer, India Project Title: Online Examination (ACCEL s/w ltd at Chennai.) and Computerizing center Brief Description: Online Information System is developed by using java servlets. It is user friendly and provides the necessary help and guidelines wherever required.