Data Sales

Ramesh P

Sr. BO Lead

Mobile: 614-***-****

Email Id: *********@*****.***

Professional Summary:

Reporting Specialist with 13 years of Data warehousing experience in technical architecture, design, development, and deployment of business intelligence and web-based applications dealing.

Project experience in various business verticals including Energy, Banking, Healthcare and retail industries. Strong background in software quality processes, metrics and practices, with experience in CMMI Level 5 projects.

Primary strengths include SAP BO BI 4.1 SP2, UDT, IDT, BO XI R3 /R2/6.x, CMC, Designer, Import Wizard, Crystal Reports, Web Intelligence, Performance Management and Tableau 10.2/9.3

Experience in Full life cycle Implementations & Production Support projects experiences in SAP BO.

Experience on implementation including blueprinting, gap analysis, mapping, design and configuration, testing, go-live, user training and post production support.

Hands on experience on Tableau, SAP BO Explorer, Sap Lumira, BO Analysis for OLAP/Office.

Involved in SAS Data Integration using Connectivity and metadata. A shared metadata environment provides consistent data definition across all data sources.

Creating users, groups, projects, Data connections, settings as a Tableau administrator.

Extensively worked on Tableau Administrator and Tableau Server.

Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modelling.

Preparing Dashboards using calculations, parameters in Tableau.

Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

Creating users, groups, projects, Data connections, settings as a Tableau administrator.

Extensively worked on Tableau Administrator and Tableau Server.

Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.

Preparing Dashboards using calculations, parameters in Tableau.

Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

Excellent track record of implementing ETL solutions for large scale data warehouses/data marts/reporting data stores on time using BODS (4.1, 3.2 & 6.5)

Extensive experience in Tableau Desktop, Tableau Server in various versions of Tableau. Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.

Sound working experience in ORACLE 11g/10g/9i, SQL SERVER, VB SCRIPT, HTML.

Strong knowledge in Star/Snowflake schema, Data Purging, Data Mining, Data Audits and other Data Warehousing concepts.

Acquainted with Configuration Management using version control systems and working under Operational change control Management system.

Excellent team player working within and across BUILD, PLAN, TEST, Infrastructure, and Operate teams.

Hands on experience in SAP-BW 7.3.

Knowledge on SAP HANA

Academic Qualification’s

MBA Technology Management – Osmania University

Professional Certifications: -

Business Objects Certified Professional

BODS Certified

Microsoft Certification in MS -Sql server

Technical Skills

OLAP and Reporting Tools

Business Objects 6.5/ XIR2, XIR 3.1 and BO 4.1, Tableau 10.2,9.3, Crystal Reports, SAP Lumira.

ETL Tools

BODS 4.2/BODI 3.1, Informatica 9.x

Programming Languages

SQL, PL/SQL. Data warehousing concepts

Databases

SQL Server, Oracle 10g, DB2, SAP HANA

Operating Systems

Windows 2003/NT/2000/ XP/98, UNIX/Linux

PROFESSIONAL EXPERIENCE:

Department of Environmental Protection, Charleston, WV. Aug 2016- Present

Technical Lead

Responsibilities:

Involved in collecting the requirements gathering from various departments users.

Create sustainable and efficient visualizations, emphasizing usability and good design practices

Work with end users to gather requirements, overlaying an analytics perspective

Involved in developing the Datamart’s using bods as an ETL tool.

Well versed with the applications i.e, Oil & Gas, Mining and Reclamation, Electronic Submission Systems.

Involved in design and development of Universes using UDT/IDT for various departments in the DEP.

Involved in designing multi-dimensional schemas.

Automated the BODS jobs for SPILL datawarehouse and RBDMS datawarehouse

Developed the webi reports based on Spill datawarehouse and RBDMS Applications.

Involved in development of Webi reports and used various techniques for tuning the reports.

Created reports and filtered them by various measures and dimensions.

Developed Dashboard for Mining dept., OOG using SAP Lumira for better visualization of the figures.

Involved in working with CMC and giving rights to the new users.

Involved in extraction of the from various legacy systems and loading into data warehouse.

Creating users, groups, projects, Data connections, settings as a tableau administrator.

Involved in creating dashboards and reports in Tableau 102.

Involved in creating dashboards and reports in Tableau 10.2.

Maintaining server activities, user activity, and customized views on Server Analysis.

Created Business requirement documents and plans for creating dashboards.

Created report schedules on Tableau server.

Creating New Schedule's and checking the task's daily on the server.

Provided trainings on various BI tools i.e, SAP BO.BODS and Tableau 10.2

Environment: -

SAP BO 4.2, BODS 4.2 with SP8, Tableau 10.2, Oracle 11.2

Nestle Globe, Irvine, CA. Jan’13– July '2016

Technical Lead

Nestlé’s existence and future development is completely dependent on successfully serving consumers’ needs. To accomplish this, we create companies in each country that can be close to the consumer and develop bonds of trust over many decades. Fundamental to this way of doing business is investing in the skills of people in each country, creating long-term relationships of trust with employees, suppliers, business partners, governments, and society as a whole.

BO Responsibilities:

Interacted with the management and business Decision-makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.

Architecting reporting requirements into technical design and development. Created Info providers & BEx queries to simulate/validate results achieved from Design Studio reports. Architected the Re-org of BW objects to maintain standards

Creation and implemented adhoc reporting system using Business Object Universe.

Implemented custom hierarchies for flexible reporting to drilldown the data to lowest granularity.

Developed complex reports with multiple data providers (Merged Dimensions), unions, sub-queries, complex date objects, breaks, sections, alerts and database functions.

Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer.

Modified BW queries in to generate WEBI reports using BI Launch Pad in BO to meet user requirements.

Developed WEBI reports on SAP Bex Queries using BICS in Webi Rich client.

Created monthly and summary reports in WEBI 4.0 for the different domains like Finance, Marketing and HR domains.

Scheduled all BO Reports in CMC by creating the events for these reports.

Created Marketing and Finance Dashboards for FP&A, Inventory Management and Cost Center Accounting data.

Created complex dashboards on Bex Queries using Query Browser in Dash board designer 4.0

Built Test Scripts and Training modules for end users.

Involved in SAS software enables you to connect to, acquire, store, and write data back to a variety of data stores, streams, applications, and systems on a variety of platforms and in various environments and relational databases.

Tableau Responsibilities

Blended data from multiple databases into one report by selecting primary key's from each database for data validation.

Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.

Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Designed dashboards on the concept of Dynamic Availability where in a variety of worksheets / views were connected by Actions, and provided an interactive reporting environment of the Revenue Impact Analysis, Inventory Control, Pricing Opportunity Analysis, Markets Overview, Shopping Activity, etc., in the developed dashboards.

Created histograms, pie charts, box plots, scatter plots for inventory management, background maps illustrating the potential revenue change, destinations flown across different geographic markets, time-series statistics for price variance across different vendors, heat maps for shopping activities across business units. Implemented Tableau Online to enable cloud implementation of analytics developed on Tableau desktop, and to make dashboards available on the cloud platform being implemented by the client.

Environments:

SAP BO 4.0, SAP BW 7.3, HANA, BEX, WEBI, IDT, Tableau 9.3.

Bosch Automotive Service Solutions, Montpelier, OH. May 11– Dec 12

Sr. BO Developer

Bosch MFG Unit deals with data warehousing and data migration projects, Service Readiness Solutions (SRS) i.e, providing an online computer database for the purposes of inventory management, business information management in the nature of business analytical reporting, monitoring and tracking of package shipments

BO Responsibilities:

Created reports and filtered them by various measures and dimensions.

Blended data from multiple databases into one report.

Used Java Script API to customize the views, selects, filters, date and time.

Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.

Worked on BO upgrade project in converting the 3.1 universes and reports to 4.0 environment.

Created aggregate objects on different level of aggregation using @aggregate functions to improve report performance

Implemented custom hierarchies for flexible reporting to drilldown the data to lowest granularity.

Developed complex reports with multiple data providers (Merged Dimensions), unions, sub-queries, complex date objects, breaks, sections, alerts and database functions.

Conducted Business Objects Web Intelligence end user training for Power and Compliance groups.

Worked on Promotion Management tool for creating the jobs for moving the universes and reports from one environment to other.

Worked on Version Management tool for retrieving the previous versions of the reports and universes which are migrated.

Scheduled Web Intelligence, Desktop Intelligence & Crystal Reports to Email, FTP, File System and Business Objects Inbox for Customers.

Created Information Spaces in SAP BO Explorer on top of Oracle UNX universe and then viewing the Explorer views on IPAD and I phone using BO Explorer app.

Worked with different dashboards connectivity options like QAAWS, BIWS, Universe Connectivity (4.0) and Live office.

Tableau Responsibilities:

Interacted with business users for gathering requirements and look and feel of the applications to be developer.

Developed various dashboards, used context filters, sets while dealing with huge volume of data.

Designed dash boards for actionable, non-actionable complaints from Multidimensional database.

Generated dashboards to compare the expected weekly sales vs projected sales used dual axis for comparison.

Generated Tableau dashboards for e-bills and paper bills comparison.

Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.

Data blending implemented on EMPI databases and generated interactive dashboards.

Created adhoc reports to users in Tableau by connecting various data sources.

Handled Tableau admin activities granting access, managing extracts and Installations.

Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.

Environment:

SAP BO 4.0 Sp05/4.1(SP 04), Dashboards (4.0), SAP BI Mobile, BO Explorer, Analysis for Microsoft Excel, Analysis for OLAP Edition, Live Office, BICS, QAAWS, Tableau, Oracle 10i.

AETNA, CORP., CT Oct 2010 – Apr 2011

Sr.BO Developer

Aetna is one of the nation’s leading providers of healthcare providers. It mainly focuses on meeting customer’s needs. Aetna is dedicated to help people achieve health and financial security by providing easy access to cost-effective, high-quality health care. Aetna has several products like delivering strong customer service and providing easy-to-understand information. Aetna implemented an integrated Oracle system to support its business activities

Mapping of 6.5.1 security requirements to the XI R3 security model according to AETNA standards.

Provided impact analysis to Project management based on user requirements.

Creation and implemented adhoc reporting system using Business Object Universe.

Ensure deliverables has been completed in time with superior quality.

Played a key role in mapping out timelines, milestones, and communication process.

Created web intelligence reports through Business Objects Universe and published in repository.

Have performed migration of reports and universes via a staging area to create a BI Archive (BIAR) file in CMS that will then imported into BO XI 3.1 Dev using the Import Wizard.

Verified and validated test cases designed by testing team. Executed Informatica, SAP BI Test cases and updated the Test case document.

Provided application support and defect fixing in test region.

Provided end user training to understand business objects environment.

Environment: - Business Objects XI-R3.1 Desktop Intelligence, Web Intelligence, Universe

Designer, SQL, PL/SQL and Windows,0racle

Cambridge University Press, Liberty Plaza, NY. Jul 09- Sept 10

Sr. BO Developer

Cambridge University Press (CUP) is the publishing business of the University of Cambridge, one of the world’s leading education & research institution. It is the oldest publisher and printer in the world, having been in operation since 1534. CUP being an international publishing house has branches & offices spread across the globe through which it markets & distributes material books in both forms of media, print & electronic. Having a staff of over 1,900 in 53 offices services an inventory of 45000 in print titles, growing at a rate of 4,200 new ISBNs per year.

Responsibilities:

Created users and groups in the CMC and managed their roles, responsibilities and privileges based on their usage levels. Published the reports using CMC and scheduling the reports to the specific users on daily, weekly, monthly basis.

Involved in solving the discrepancies occurred in the ETL environment.

Developed WebI reports providing an easy-to-use interface with powerful query features. This reduced the report backlog and ensured business decisions were made in a timely manner.

Researched the existing reports, formulated and came-up with recommendations to create new semantic layers(s)/reports.

Used Import Wizard to migrate the universes, reports and rights from Development to QA and then to Production and Vice versa.

Migrated 3.0 Webi reports to BO 3.1 environments.

Exclusively Used QAAWS, Live Office, XML mappings as per the Dash board requirements.

Developed web services using Query as a Web Service Wizard (QAAWS) and deployed it to the server for developing Xcelsius dashboards.

Performed QAAWS Sizing on the servers to perform the Queries run fast and display the dash boards.

Created multiple Flash variables in Xcelsius and used them to pass data from one dashboard to other.

Involved in Setting up the XML mapping files to pick up data from ODS on a daily basis and produce KPI results in the dashboard.

Developed Demand WebI Reports which reads parameters from Crystal Xcelsius.

Developed multiple dashboards so that the user can navigate from one dashboard to the other.

Environment: SAP Business Objects Enterprise XI3.1, Web Intelligence XI 3.1,

Xcelsius2008, SQL Server 2008, Windows Server 2003.

Adobe Systems, SFO, CA. Apr 07 – Jul 09

Sr. BO Developer

Deliver data & reporting solutions for WW Sales Field Operations. First deliverable will be targeted to 800 Sales Reps, replacing the existing worldwide sales rep dashboard solution with air application. Second phase will be delivering data & reporting solutions, replacing the current Micro strategy reporting. The addition of Channel 2.0 data will provide comprehensive view of channel data in addition to Opportunity, Quota, and Commissionable Revenue. This visibility will lead to better decision making which indirectly impact the revenue generating activities. Provide ability to increase measurement of Field Marketing activities performed to enhance Enterprise Sales Pipeline.

Responsibilities:

Developed Dashboards using Xcelsius 2008 components using maps, Pie Charts, Staked Bar, List Views etc. creatively using best Xcelsius components effects for better interaction.

Installed Crystal Xcelsius designer and created dashboards. Created WSDLs using query as web services and implemented WSDLs into Xcelsius dashboards

Created customized Web Intelligence reports as a source data for Live Office to Integrate Xcelsius on Corporate dashboards.

Developed, Tested, Promoted and Maintained the WEBI Reports, also had modified the existing reports based on user requirements

Designed logic for Xcelsius 2008, Dashboard in Microsoft Excel for Data Visualization.

Used Xcelsius to Visualize and to enhance the data presentation along with developing dynamic charts and graphics.

Worked on building Xcelsius Dashboards on top of universes build using SAP Integration Kit.

Used the XML Enabled Model to feed data dynamically into Crystal Xcelsius-built model or dashboard

Created Xcelsius dashboards for visual understanding of information and publish to BO Enterprise.

Provided training and knowledge transfer to allow responsible parties to provide on-going support post go-live.

Created critical visualization using Business Objects Crystal Xcelsius for the Business Dashboard Used Crystal Report’s to feed data to Crystal Xcelsius Visualization an XML file as a data source.

Environment: SAP Business Objects Enterprise XI3.1, Web Intelligence, Crystal Xcelsius, SQL Server 2008, Windows Server 2003, Toad 9.0, Oracle 10g, SQL, PL/SQL and Windows XP.

Saudi Electricals, Utopiainc May 06-Mar 07

ETL/SAP BODI

The first process in materials management is related to spare parts. A detailed business process is required to determine the order point for the spare parts, identify the ideal quantity to order, process receipt of the parts, and then make sure they are in the correct place. Spare parts are integral to the continuing operation of production lines and related equipment. Poor management of this process can cause downtime and loss of production. Quality control is a large part of materials management. The creation of material standards, inspections, and returns process is a primary responsibility of the materials management group.

Responsibilities:

Familiarized the business, its strategy and implementation’s.

Experience in interacting with client at onsite to gather business requirements, analyzing and developing ETL designs

Gathered Customer, User and Owner requirements; analyzed and documented them.

Used Business Objects Data Integrator 6.5 for ETL extraction, transformation and loading data from heterogeneous source systems.

Designed and customizing data models for Data warehouse supporting data from multiple sources on real time.

Tuned Data Integrator Mappings and Transformations for the better performance of jobs.

Customized configuration of Business Objects Web Intelligence by fine-tuning and optimization for better performance.

Designed and developed Data Integrator (DI) scripts for data transformation.

Experience in cleansing data in DI using proper data types and mappings and to create Workflows using object library and tool palette to execute data flows.

Created multiple universes and resolved Loops by creating table aliases and contexts.

Worked with database connections, SQL joins, loops, aliases, materialized views, views, aggregate conditions, parsing of objects, LOVs, and hierarchies.

Created complex reports using user-defined functions like @variables, @prompt, condition Objects and aggregate Awareness Functions for SQL enhancement.

Enabled/Disabled different servers in Central Configuration Manager and Central Management Console.

Environment: Business Objects 6.5, BODI 6.5, Webi DESKI, SQL, PL/SQL, Erwin, SQL Loader, Windows NT, ORACLE, PL/SQL, SQL Enterprise Manager

Cameron, Bangalore Aug 05-Apr 06

BOBJ Developer

Cameron is a leading provider of flow equipment products, systems and services to worldwide oil, gas and process industries. Leveraging its global manufacturing, engineering and sales and service network, Cameron works with drilling contractors, oil & gas producers, pipeline operators, refiners and other process owners to control, direct, adjust, process, measure and compress pressures and flows

Responsibilities:

Involved in creating a DataMart.

Involved in developing the universes and implementing the universe features to

improve the performance.

Exported the universes to repository for making resources available to users

Involved in creating web intelligence reports.

Used Sections, conditions, Alerts and Breaks.

Involved in formatting reports.

Interacted with Business Users for business requirements and report enhancements

Customized configuration of Business Objects Web Intelligence by fine-tuning and

optimization for better performance.

Environment: Business Objects 6.5, BODI 6.5, WebI 6.1, DESKI, SQL, PL/SQL, Erwin, SQL Loader, Windows 2000/NT, ORACLE.

Contact this candidate