Curriculum Vitae
Objective
- To build a career with a leading corporate, work as a key player in challenging environment with dedicated people where I can learn, explore and realize my potential. To contribute to things which contain a flavor of my skill and use my skills and creativity to help the organization to achieve and sustain growth in the competitive world.
Professional Experience
- Ganesha has around 7.9 years of experience (6 years as Full time + 6 months as Project Trainee + 1.3 years as practice) in Datawarehousing and Microsoft Business Intelligence (MSBI) Technology along with SQL Server 2005/2008/2008 R2/2012. His expertise lies in SSRS & Report Builder (Reporting), DTS/SSIS (ETL), SSAS (OLAP), Cube Development, Datamart designing, MDX, TSql & Sql Server 2005 / 2008 / 2008 R2 / 2012. He has also good knowledge on Power Pivot, Power View and Performance point Server. He has 6 years of experience in working with Team Foundation Server (TFS) for source code management, reporting, requirements management, project management, testing and release management capabilities. He has also good knowledge on MDM and ODS. He has worked for world reputed companies like Accenture, Cognizant, ProcessMAP. He has strong experience in domains like BFS, Life Science, Healthcare, EHS and Real Estate. He has worked on projects for clients such as SCAN Health Plan, Think Finance, Genzyme (A Sanofi company), JTC Corporation Singapore, SKF, Cardinal Health Inc. , SHAW Industries Group Inc. , Goodyear, Dresser, ITT Corporation & Ingersoll Rand (IR).
Professional Summary
- Currently Ganesha is working with “Cognizant technology solutions” as a MSBI Tech Lead/Analyst. Ganesha’s main area of expertise has been in Application & Development with skills of SSRS, DTS/SSIS, SSAS, SQL Server 2005/2008/2008 R2/2012, Report Builder and Report Model.
- 7.9 years of experience in Microsoft Business Intelligence Domain and SQL Server 2005/2008/2008 R2/2012
- He has also good knowledge on Power Pivot, Power View and Performance point Server.
- 6 years of experience in Team Foundation Server (TFS) for source code management, reporting, requirements management, project management, testing and release management capabilities
- Good experience with SQL Server 2005/2008/2008 R2/2012, SSRS (SQL Server Reporting Services), DTS/SSIS (SQL Server Integration Services) and SSAS (SQL Server Analysis Services) and writing MDX queries.
- Expert level skills on T-SQL and query optimization, developing Reports using SSRS, developing Extraction, Transformation and Loading (ETL) strategies using SSIS, Database designing using SQL Server 2005/2008/2008 R2/2012 and Datamart Development.
- Good experience and understanding of database design, relational integrity constraints, OLAP, OLTP, Datamart Development, Cubes
- Expertise in writing and debugging Stored Procedures and Functions.
- Strong experience in building and designing Reports in SQL Server database.
- Supported team in resolving SQL Reporting services and ETL related issues.
- Excellent communication skills bridging Client Interaction and Team Management.
- Strong analytical, problem troubleshooting/solving skills, self-starter.
- Expert in providing Training in Microsoft BI tools.
- Exposure to Proposal/Estimation Discussions and data model.
- Has good knowledge on MDM and ODS.
- Good level of understanding in Unix (commands and shell scripting)
- As part of his assignments, he has been involved in most SDLC phases of project Requirement gathering, design, code development /enhancement, User acceptance testing, Post-implementation Support.
- He has also been a Tech Lead/Team lead for around 3 yrs.
- He has worked in countries like Singapore, Netherlands, United States for client interaction, business growth and Application Development
Project Experience
Company : Cognizant Technology Solutions
Client : SCAN Health Plan
Project : IKA Data Warehouse and Interface
Role : BI Tech Lead/Analyst
|
Long Beach, CA, USA
|
Business Intelligence – SSIS, SSRS Reports, SSAS (Jan 2014 – Till date)
|
Team Size : 30
Client : 25 (Developers, Manager, BAs, Architect, DBA)
Cognizant : 5
|
Project Overview
|
SCAN Health Plan (SCAN) is a not-for-profit health plan organization that serves more than 110,000 people with a health plan for Medicare and Medicaid-eligible individuals as part of the state’s long term care program in California and Arizona.
SCAN Health Plan is undergoing a system replacement project where IkaSystems’ Core Administration solutions will be used in place of SCAN’s core system, MC400. As part of this plan, there is a requirement to create a Master Data Service layer to provide merged data from both MC400 and ika Systems. The primary objective of the project is to create an Enterprise Data warehouse (EDW) and operational data store (ODS) architecture, Organization architecture and automation framework that will help Business people to strategize based on analysis of Data.
The project involves designing and implementing the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R2/2012.
The project provides maintenance support for ETL systems.
The project provides reporting capabilities, subject-oriented subsets of data designed to meet the business requirements of specific reporting and analysis functions using SSRS and SSAS.
The project includes creation of SSAS cubes, Creation of reports from cubes and also the development of reports using SSRS 2008 R2/2012 and Report builder.
The project provides a reporting infrastructure, which includes a user-friendly interface.
The project provides an environment to identify, define and develop the common set of core reports required by customers and the management.
The project required timeliness of data for reporting and analysis purposes
The project entails the potential need for historical data within the data warehouse, date parameters for such data, and identification of the data source(s).
|
Responsibilities
|
- His role basically involves as a Tech lead along with Application development & Testing.
- He defines, plans, schedules, monitors, set milestones and coordinates the activities of the team, and reviews their deliverables.
- He works directly with functional analysts and business users in understanding the information needs of the business and developing new data warehouse/BI functionalities or tools to meet these requirements.
- Works closely with Business Analysts and performs all the needed Requirement Gathering / Design / Develop / Enhance / Test / Implement / Production Support Activities for the Project.
- He prepares performance Dashboard, Jobs Failure stats, Data Volume check using SSRS, SSAS, SSIS, SQL and Excel and gives PPT presentation near client for this on a daily basis.
- He presents the Enterprise Information Management team on the daily leadership stand up meeting.
- He develops Scorecard report, Drill down Report, Drill through Report, Sub Report, Linked Reports and Parameterized Reports using SSRS, SSAS and Report Builder.
- He creates and manages Reports subscriptions and schedules SSRS reports.
- He schedules reports for Replication check notification to business users using SSRS and subscription
- He manages Report Manager, uploads and deploys SSRS Reports rdls, Data sets, Data Sources, Report Model into Report Manager. He also manages roles & Permissions to be assigned to the users and works on Security for the SSRS Reports.
- He works with SSRS Report Migration from MC400 to IKA System.
- He works with ETL and Jobs Migration from MC400 to IKA Environment
- He develops ETL Packages using SSIS, SSRS / T-SQL Code and schedules jobs along with Jobs Monitoring Automation.
- He develops and deploys SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.
- He works with SSAS cube based reports, SSIS packages and job to process OLAP cube and uses his analysis services capabilities to maintain and support SSAS cube.
- Troubleshooting reports issues, ETL job failures, optimizing query performances.
- He performs code reviews, analyses the Requirements and Suggest suitable improvements
- He involves in Testing & Performance Tuning of written code
- He prepares Technical Documentation
- He coordinates with onsite / offshore team members.
|
Technologies:
|
- Business Intelligence: SSRS, Report Builder, SSIS, SSAS, Performance Point Server, Power Pivot, Power View
- DBMS: SQL Server 2008 R2 / 2012
- Report Builder
- Version Control System : Team Foundation Server (TFS)
|
|
|
|
Company : Cognizant Technology Solutions
Client : Think Finance
Project : Think Finance EIM
Role : BI Tech Lead / Analyst
|
Fort Worth, TX, USA
|
Business Intelligence – SSAS, SSIS, SSRS Reports (Dec 2012 – Dec 2013)
|
Team Size : 40
Client : 10 (Manager, BAs, Architect, DBA)
Cognizant : 30
|
Project Overview
|
Think Finance is a lending company offering short-term installment and revolving loans to United States residents.
The primary objective of the project is to create an Enterprise Data warehouse and operational data store architecture, Organization architecture and ODS process automation framework that will help Business people to strategize based on analysis of Data.
The project provides reporting capabilities, subject-oriented subsets of data designed to meet the business requirements of specific reporting and analysis functions.
The project involves designing and implementing the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R2/2012.
The project provides maintenance support for ETL systems.
The project includes creation of SSAS cubes, Creation of reports from cubes and also the maintenance of web reports using SSRS 2008 R2/2012 and Report builder.
The project provides a reporting infrastructure, which includes a user-friendly interface.
The project provides an environment to identify, define and develop the common set of core reports required by customers and the management.
The project required timeliness of data for reporting and analysis purposes
The project entails the potential need for historical data within the data warehouse, date parameters for such data, and identification of the data source(s).
|
Responsibilities
|
- His role basically involves as a Tech lead along with Application development & Testing.
- He defines, plans, schedules, monitors, set milestones and coordinates the activities of the team, and reviews their deliverables.
- He works directly with functional analysts and business users in understanding the information needs of the business and developing new data warehouse/BI functionalities or tools to meet these requirements.
- Works closely with Business Analysts and performs all the needed Requirement Gathering / Design / Develop / Enhance / Test / Implement / Production Support Activities for the Project.
- He presents Think Finance EIM team on the daily leadership stand up meeting.
- He prepares performance Dashboard, Jobs Failure stats, Data Volume check using SSRS, SQL and Excel and gives PPT presentation near client for this on a daily basis.
- He develops Scorecard report, Drill down Report, Drill through Report, Sub Report, Linked Reports and Parameterized Reports using SSRS and Report Builder for Finance, Loans, Risk, Compliance and Marketing Department.
- He creates and manages Reports subscriptions and schedules SSRS reports.
- He schedules reports for Replication check notification to business users using SSRS and subscription
- He manages Report Manager, uploads and deploys SSRS Reports rdls, Data sets, Data Sources, Report Model into Report Manager. He also manages roles & Permissions to be assigned to the users and works on Security for the SSRS Reports.
- He works with SSRS Report Migration from Pay Day One to RISE Product for Think Finance.
- He works with ETL and Jobs Migration from Legacy environment to ODS Environment
- He develops SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.
- He develops and deploys SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files for compliance department.
- He works with SSAS cube based reports, SSIS packages and job to process OLAP cube and uses his analysis services capabilities to maintain and support SSAS cube.
- Troubleshooting reports issues, ETL job failures, optimizing query performances.
- He performs code reviews, analyses the Requirements and Suggest suitable improvements
- He involves in Testing & Performance Tuning of written code
- He prepares Technical Documentation
- He coordinates with onsite / offshore team members.
|
Technologies:
|
- Business Intelligence: SSRS, Report Builder, SSIS, SSAS, Performance Point Server, Power Pivot, Power View
- DBMS: SQL Server 2008 R2 / 2012
- Report Builder
- Version Control System : Team Foundation Server (TFS)
|
|
|
|
Company : Cognizant Technology Solutions
Client : Genzyme Corporation (Sanofi Genzyme)
Project : PlanIT & Ticket Management System
Role : BI Tech Lead
|
Almere, Netherlands
|
Business Intelligence – SSAS, SSIS, SSRS Reports (May 2011 – Nov 2012)
|
Team Size : 40
Client : 9 (Manager, BAs, Architect, DBA)
Cognizant : 31
|
Project Overview
|
Genzyme is a top 5 pharmaceutical company in world.
The primary objective of the project is to build a robust and intelligent system that will help Business people to strategize based on analysis of conformed Facts and Dimensions. Designing and implementing the ETL processes which involve collection of data from sources like SQL Server 2005/2008/2008 R2 and XML. Provide maintenance support for ETL systems. They wanted a solution which assists in generation of reports related to problems, issues and risks in Applications and which provides reports and dashboards displaying status of current ongoing projects and programs.
The project required a data warehousing environment (OLAP cubes and ETL packages) and reporting infrastructure over two of the applications – PlanIT (Project Management) and Clarify (Ticket Management).
|
Responsibilities
|
- His role basically involves team lead and application development.
- He works closely with Functional Analysts for requirement gathering, designing the database and creating workflow.
- He is involved in Proposal/Estimation Discussions and data model.
- He plays a major role in client interaction and team management.
- He writes scripts for pulling data from SQL Server db and XML.
- SQL Server 2005 to develop the datamart.
- He designs and implements the ETL processes
- He creates Cube-Based Reports through SSRS and Report Builder 3.0.
- He uses Analysis Services Capabilities to build Cubes.
- He troubleshoots reports issues, ETL job failures, optimizing query performances.
- He coordinates with onsite team members.
- He ensures deliverables meet Quality standards.
|
Technologies:
|
- Business Intelligence: SSRS, Report Builder, SSIS, SSAS, Performance Point Server
- DBMS: SQL Server 2008 R2
- Report Builder
- Version Control System : Team Foundation Server (TFS)
|
|
|
|
Company : Accenture
Client : JTC Corporation
Project : Real Estate Management
Role : BI Module Lead
|
Jurong, Singapore
|
Business Intelligence – SSRS Reports (Nov 2010 – May 2011)
|
Team Size : 50
Client : 9 (Manager, BAs, Architect, DBA)
Accenture : 41
|
Project Overview
|
JTC Corporation (JTC) is Singapore’s leading industrial infrastructure specialist spearheading the planning, promotion and development of a dynamic industrial landscape. For more than 40 years, JTC has played a key role in the growth of the economy by providing cutting-edge industrial real estate solutions.The primary objective of this project is to develop a solution that would manage the “Real Estate Management” (REM) for the Singapore Government. Provides advanced reporting capabilities,subject-oriented subsets of data designed to meet the business requirements of specific reporting and analysis functions, To provide a reporting infrastructure, which includes a user-friendly interface.
Develops ETL applications using SSIS , and data cleansing functions
To identify, define and develop the common set of core reports required by customers and the management
Developing 10 REM Reports that deals mainly with 4 categories such as Rental revision, Service Performance, User Admin and Plan Submission.
|
Responsibilities
|
- Design the technical documentation for the Rental Revision Reports
- Research, define and deploy BI improvement opportunities and streamline the business intelligence processes
- Create detail design, work on development and perform code reviews.
- Writing scripts for pulling data from SQL Server db.
- Using SQL Server 2008 to develop the Reports in SSRS.
- Using Analysis Services Capabilities to build Cubes.
- Troubleshooting reports issues, optimizing query performances.
- Coordinating with team members.
- Ensures deliverables meet Quality standards
- Troubleshoot and help resolve user issues.
|
Technologies:
|
- Server : Reporting Services, Integration Services, Analysis Services.
- Operating System – Windows Server 2003
- DBMS: SQL Server 2008 R2
- Report Builder
- Version Control System : Team Foundation Server (TFS)
|
|
|
|
Client : Cardinal Health Inc.
Project : Accident Incident Management System
Role : Module Lead
|
Bhubaneswar, India
|
Business Intelligence – Reports and OLAP Lead (Jan 2010 – Oct 2010)
|
Team Size : 22
Client : 7 (Manager, BAs, Architect, DBA)
ProcessMAP : 15
|
Project Overview
|
The Cardinal Health Inc. is a health care services company, currently ranked 17th on the Fortune 500, specializes in health care supply chain services, providing pharmaceuticals and medical products to more than 40,000 locations each day. The company is also a manufacturer of medical and surgical products, including gloves, surgical apparel and fluid management products..The primary objective of this project is to develop a system wide data mart which Provides advanced reporting capabilities, subject-oriented subsets of data designed to meet the business requirements of specific reporting and analysis functions
To provide a reporting infrastructure, which includes a user-friendly interface
To identify, define and develop the common set of core reports required by customers and the management
To develop a security framework as part of the data mart architecture
Need to develop policy pertaining to information stewardship. Requires determination of responsibility for accuracy, access authority, definitions, and data integrity relationships.
Required timeliness of data for reporting and analysis purposes
The potential need for historical data within the data mart, date parameters for such data, and identification of the data source(s)
Developing 36 AIMS Reports that deals with mainly 6 categories such as Nature of IllnessInjury, cause of IllnessInjury, Root cause Analysis,Contributing factors,Body Parts and Incident Type.
|
Responsibilities
|
- Defines, plans, schedules, monitors, and coordinates the activities of the team, and reviews their deliverables.
- Develops various functional components of the data mart applications including extract programs on source systems, ETL applications, and data cleansing functions
- Work directly with functional analysts and business users in understanding the information needs of the business and developing new data warehouse/BI functionalities or tools to meet these requirements.
- Research, define and deploy BI improvement opportunities and streamline the business intelligence processes
- Create detail design, work on development and perform code reviews.
- Writing scripts for pulling data from SQL Server db.
- Using SQL Server 2008 to develop the datamart.
- Designing and Implementing the ETL processes
- Creation of AIMS Reports, Cube-Based Reports, Report Models, Reports using Report builder.
- Using Analysis Services Capabilities to build Cubes.
- Troubleshooting reports issues, ETL job failures, optimizing query performances.
- Coordinating with onsite team members.
- Ensures deliverables meet Quality standards and create subscriptions.
- Troubleshoot and help resolve user issues.
|
Technologies:
|
- Server : Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS).
- Operating System – Windows Server 2003
- DBMS: SQL Server 2008 R2
- Report Builder – Report Builder 3.0
- Version Control System : Team Foundation Server (TFS)
|
|
|
|
Client : SHAW Industries Group Inc.
Project : AIMS Datamart, Cubes & ASA Reports
Role : Module Lead
|
Bhubaneswar, India
|
Business Intelligence – Datamart & Report Developer (Sept 2009 – Jan 2010)
|
Team Size : 16
Client : 6 (Manager, BAs, Architect, DBA)
ProcessMAP : 10
|
Project Overview
|
The SHAW Group is a fortune 500 corporation whose core comptencies are Engineering, Procurement, and Construction, piping, energy, chemical, and fossil and nuclear power.The primary objective of this project is to build a robust and intelligent system that will help Business people to strategize based on analysis of conformed Facts and Dimensions.Creation of Accident/Incident Management System(AIMS) Datamart, Report Model,Cubes and AIMS reports like Cause of Illness Injury Chart, Incident Statistics Matrix Report, Metrics Count For SHAW Report, Nature Of Illness Injury Chart, Part Of Body Chart and ASA Reports. (Activity Status Report, Perormance Week wise chart, ASA Summary report, ASA Details Report and Percentage of ASA created weekwise Chart). Data will have consistent business rules, hierarchies and standardized metrics and calculations.
|
Responsibilities
|
- Work directly with functional analysts and business users in understanding the information needs of the business and developing new data warehouse/BI functionalities or tools to meet these requirements.
- Research, define and deploy BI improvement opportunities and streamline the business intelligence processes
- Create detail design, work on development and perform code reviews.
- Writing scripts for pulling data from SQL Server db.
- Using SQL Server 2005 to develop the datamart.
- Designing and Implementing the ETL processes
- Creation of ASA Reports, Standard Reports, Cube-Based Reports, Report Models, Reports using Report builder.
- Using Analysis Services Capabilities to build Cubes.
- Troubleshooting reports issues, ETL job failures, optimizing query performances.
- Coordinating with onsite team members.
- Ensures deliverables meet Quality standards and create subscriptions.
- Troubleshoot and help resolve user issues.
|
Technologies:
|
- Server : Reporting Services, Integration Services, Analysis Services.
- Operating System – Windows Server 2003
- DBMS: SQL Server 2008, Excel.
- Report Builder – Report Builder 3.0
- Version Control System : Team Foundation Server (TFS)
|
|
|
|
Client : Goodyear
Project : Datamart Optimization & Safety Scorecard Reports
Role : Senior Developer
|
Bhubaneswar, India
|
Business Intelligence – Datamart and Report Developer (Jun 09 – Sep 09)
|
Team Size : 15
Client : 5 (Manager, BAs)
ProcessMAP : 10
|
Project Overview
|
Goodyear is one of the world's largest tire companies, with operations in most regions of the world. Together with its subsidiaries and joint ventures, Goodyear develops, markets and sells tires for most applications. The primary objective of this project is to build a robust and intelligent system that will help Business people to strategize based on analysis of conformed Facts and Dimensions. Creation of an AIMS (Accident/Incident Management System) Datamart and to develop Safety scorecard Reports and Standard Reports. Metrics will be centralized into an Accident/Incident Management Portal in a supported BI environment. Data will have consistent business rules, hierarchies and standardized metrics and calculations.
|
Responsibilities
|
- Work closely with onsite Business Analysts for requirement gathering, designing the database and creating workflow.
- Develop technical architecture based on detailed requirements
- Writing scripts for pulling data from SQL Server db.
- Using SQL Server 2005 to develop the datamart.
- Creation of Safety Scorecard Report,Goodyear Standard reports, Report Models.
- Troubleshooting reports issues, optimizing query performances.
- Coordinating with onsite team members.
- Ensures deliverables meet Quality standards.
- Validate the technical feasibility of business requirements
- Infrastructure, architecture and environment evaluation
- Interfaces with Business users and Technical managers to clarify requirements, review design, test cases, and deployment
- Devising the Report delivery mechanisms and creating subscriptions
- Ensures deliverables meet Quality standards
|
Technologies:
|
- Server : Reporting Services, Integration Services, Analysis Services.
- Operating System – Windows Server 2003
- DBMS: SQL Server 2008, Excel.
- Report Builder
- Version Control System : Team Foundation Server (TFS)
|
|
|
|
Client : Dresser
Project : SSAS Cubes & Standard AIMS Reports
Role : Senior Developer
|
Bhubaneswar, India
|
Business Intelligence – Datamart and Report Developer (Feb 09 – May 09)
|
Team Size : 15
Client : 5 (Manager, BAs)
ProcessMAP : 10
|
Project Overview
|
Dresser is one of the world's leading providers of innovative, reliable and affordable equipment and services for mission-critical applications in global energy infrastructure.The primary objective of this project is to build a robust and intelligent system that will help Business people to strategize based on analysis of conformed Facts and Dimensions. Creation of an AIMS (Accident/Incident Management System) Datamart and to develop Dresser Standard Reports and generate Report Model. Metrics will be centralized into an Accident/Incident Management Portal in a supported BI environment. Data will have consistent business rules, hierarchies and standardized metrics and calculations.
|
Responsibilities
|
- Work closely with onsite Business Analysts for requirement gathering, designing the database and creating workflow.
- Work on enforcing proper integrity constraints and maintaing relationships among the different objects.
- Writing scripts for pulling data from SQL Server db.
- Using SQL Server 2005 to develop the datamart.
- Designing and Implementing the ETL processes
- Creation of Dresser Standard Reports, Cube-Based Reports, Report Models.
- Using Analysis Services Capabilities to build Cubes.
- Troubleshooting reports issues, ETL job failures, optimizing query performances.
- Coordinating with onsite team members.
- Ensures deliverables meet Quality standards.
- Troubleshoot and help resolve user issues.
|
Technologies:
|
- Server : Reporting Services, Integration Services, Analysis Services.
- Operating System – Windows Server 2003
- DBMS: SQL Server 2008, Excel.
- Report Builder
- Version Control System : Team Foundation Server (TFS)
|
|
|
|
Client : ITT Corporation
Project : Locations, Levels Cubes (SSAS) & Dataload using SSIS
Role : Senior Developer
|
Hyderabad, India
|
Business Intelligence – Datamart, Cube and Report Developer (Nov 08 - Feb 09)
|
Team Size : 15
Client : 5 (Manager, BAs, Architect, DBA)
ProcessMAP : 10
|
Project Overview
|
ITT Corporation is a global diversified manufacturing company and participates in global markets including water and fluids management, defense and security, and motion and flow control.
The primary objective of this project is to build a robust and intelligent system that will help Business people to strategize based on analysis of conformed Facts and Dimensions. Designing and implementing the ETL processes which involves collection of data from sources like SQL Server 2005/2008. Provide maintenance support for ETL systems. Creation of ITT Datamart.Cubes, Report Models, Creation of reports from cubes and also the maintenance of web reports using Sql Server Reporting services 2005.
|
Responsibilities
|
- Work closely with Business Analysts for requirement gathering, designing the database and creating workflow.
- Writing scripts for pulling data from SQL Server db.
- Using SQL Server 2005 to develop the datamart.
- Designing and Implementing the ETL processes
- Creation of ITT Reports, Cube-Based Reports using SSRS and Report Models.
- Using Analysis Services Capabilities to build Cubes.
- Troubleshooting reports issues, ETL job failures, optimizing query performances.
- Coordinating with onsite team members.
- Ensures deliverables meet Quality standards.
|
Technologies:
|
- Server : Reporting Services, Integration Services, Analysis Services.
- Operating System – Windows Server 2003
- DBMS: SQL Server 2005, Excel.
- Report Builder
- Version Control System : Team Foundation Server (TFS)
|
|
|
|
Client : Ingersoll Rand (IR)
Project : Environment, Health and Safety Management System
Role : Application Developer
|
Hyderabad, India
|
Business Intelligence – Datamart, Cube and Report Developer (Jul 08 – Oct 08)
|
Team Size : 17
Client : 7 (Manager, BAs, Architect, DBA)
ProcessMAP : 10
|
Project Overview
|
Ingersoll-Rand is a leading innovation and solutions provider that focuses on the major global markets of Climate Control, Industrial Technology, Infrastructure Development and Security and Safety.
The primary objective of this project is to build a robust and intelligent system that will help Business people to strategize based on analysis of conformed Facts and Dimensions. Designing and implementing the ETL processes which involves collection of data from heterogeneous sources like SQL Server 2005/2008. Provide maintenance support for ETL systems. Creation of Environment, Health and Safety (EHS) Datamart.Cubes, Incremental processes, Report Modeling, Creation of reports from cubes, Scorecard reports, Excel Back Up Report, Raw Data Report, No Data Report and also the maintenance of web reports using Sql Server Reporting services 2005.
|
Responsibilities
|
- Work closely with Business Analysts for requirement gathering, designing the database and creating workflow.
- Writing scripts for pulling data from SQL Server db.
- Using SQL Server 2005 to develop the datamart.
- Designing and Implementing the ETL processes
- Creation of Scorecard Data Hierarchy report, Excel Back up Drill Down Report, Cube-Based Reports, Report Models.
- Using Analysis Services Capabilities to build Cubes.
- Troubleshooting reports issues, ETL job failures, optimizing query performances.
- Coordinating with onsite team members.
- Ensures deliverables meet Quality standards.
- Troubleshoot and help resolve user issues.
|
Technologies:
|
- Server : Reporting Services, Integration Services, Analysis Services.
- Operating System – Windows Server 2003
- DBMS: SQL Server 2005, Excel.
- Report Builder
- Version Control System : Team Foundation Server (TFS)
|
|
|
|
Client : Svenska Kullagerfabriken (SKF)
Project : Datamart Reporting & SKF Cubes & ProcessMAP Forum
Role : Project Trainee
|
Hyderabad, India
|
Business Intelligence – Datamart, Cube and Report Developer (Dec 07 - May 08)
|
Team Size : 15
Client : 5 (Manager, BAs, Architect, DBA)
ProcessMAP : 10
|
Project Overview
|
SKF, is a Swedish bearing company founded in 1907, supplying bearings, seals, lubrication and lubrication systems, maintenance products, mechatronics products, power transmission products and related services globally.
The primary objective of this project is to build a robust and intelligent system that will help Business people to strategize based on analysis of conformed Facts and Dimensions. Designing and implementing the ETL processes which involves collection of data from sources like SQL Server 2005/2008. Provide maintenance support for ETL systems. Creation of SKF Datamart.Cubes, Report Modeling, Creation of reports from cubes and also the maintenance of web reports using Sql Server Reporting services 2005.
|
Responsibilities
|
- Work closely with Functional Analysts for requirement gathering, designing the database and creating workflow.
- Writing scripts for pulling data from SQL Server db.
- Using SQL Server 2005 to develop the datamart.
- Designing and Implementing the ETL processes
- Creation of SKF Standard Reports, Cube-Based Reports, Report Models.
- Using Analysis Services Capabilities to build Cubes.
- Troubleshooting reports issues, ETL job failures, optimizing query performances.
- Coordinating with onsite team members.
- Ensures deliverables meet Quality standards.
|
Technologies:
|
- Server : Reporting Services, Integration Services, Analysis Services.
- Operating System – Windows Server 2003
- DBMS: SQL Server 2005, Excel.
- Report Builder
- Version Control System : Visual Source Safe (VSS)
-
|
|
|
|
Technical Skills
Business Intelligence : MSBI, SSIS, SSAS, SSRS, Report Builder, BIDS, Reports, OLAP Cubes, MDX, ETL, Datamart
Operating Systems : Windows XP
DBMS : SQL Server 2005/2008/2008 R2/2012
Applications & IDE : Business Intelligence Development Studio, MS Office,Visual Studio.NET
Web Server : IIS
Version Control System : Team Foundation Server (TFS) , MS Visual Source Safe (VSS)
Framework Experience : Microsoft .NET (Basic)
Web Technology : HTML, XML, JScript, VBScript, ASP.NET (Basic)
Web Application : SharePoint (Basic)
Trainings & Certifications
- IBM Web Security certification in Accenture
- Six Sigma Yellow Belt training in Cognizant
- First Time Team Lead certification in Cognizant
- Operation Clarity training in Cognizant
- Effective Business Communication training in Cognizant Technology Solutions
- Sql Server 2012 training by Microsoft in Cognizant
- ITIL : Level 0 training
- 7 Habits of highly effective people training in Cognizant
- Microsoft Business Intelligence (SSRS, SSIS, SSAS) training by Influx, Hyderabad.
- Microsoft Business Intelligence (SSRS, SSIS, SSAS) training by Influx
- Microsoft SQL Server 2005/2008 at ProcessMAP.
- Data Security and Client data Privacy Training at Accenture
- Respect in Action training at Accenture
Educational Qualification
National Institute of Technology, Rourkela (NIT Rourkela)
www.nitrkl.ac.in
Master Of Computer Application
2005 – 2008
Cumulative GPA: 8.3/10.0
|
Rourkela, India
|
- Mastrer degree in Computer Application with High Distinction; 2nd topper in the batch.
- Active participant in Paper presentation during technical festivals, participated in Carom, cricket and indoor games.
- Coordinating Prof. D.P.Mohapatra, NIT Rourkela in writing a book with C.L.Liu on Discrete mathematics for Tata Mc. Graw Hill titled “Elements of Discrete Mathematics” which is recently published.
|
Professional Activities/Achievements
- A Book on Discrete Mathematics , Tata Mc Graw Hill– Coordinator to Prof. D.P. Mohapatra, N.I.T. Rourkela
- SQL Server Training- Trainer in Cognizant & ProcessMAP Infotech Pvt. Ltd.
- MSBI Training- Trainer in Cognizant & ProcessMAP Infotech Pvt. Ltd.
- Worked as a Key player in all of the projects.
- Promoted to the post of Senior Analyst within one year in ProcessMAP Infotech Pvt Ltd.
- 2nd Topper in Mastrer degree in Computer Application At NIT Rourkela.
- Topper's Top in the OJEE Master of Computer Application Entrance in the year 2005
- Champion of Carom tournament - 2012 in Cognizant, Mumbai
Personal Details
First Name
|
Ganesha
|
Last Name
|
Ratha
|
Date of Birth
|
12th July, 1984
|
Nationality
|
Indian
|
Gender
|
Male
|
Marital Status
|
Single
|
Visa Availability
|
H1B
|
Visa Type
Holding H1B Visa valid till 7th February, 2016