Resume Details
G. R.

Location Long beach, CA  
Contact Click to View Contact
Source Vendor Candidate
Salary N.A.
Rate N.A.

Resume


Ganesha Ratha

 

 

                                

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

 


A. B.
Skill: IT-Database Design Location: West Chester , OH   
Description:
S U M M A R Y Has over twenty years of experie.... more
S. P.
Skill: IT-Database Design Location: Cincinnati , OH   
Description:
Professional Summary: Thirteen years of extensi.... more
R. N.
Skill: IT-Database Design Location: Mount Orab , OH   
Description:
OBJECTIVE Database Design / Administrator To .... more
B. C.
Skill: IT-Database Design Location: Rowland Heights, CA   
Description:
v\:* {behavior:url(#default#VML);}o\:* {behavior:u.... more
V. K.
Skill: IT-Database Design Location: Indianapolis, IN   
Description:
  Vijay Kommanaboina    .... more