Engineer Software

SHREYAS SASTE

Email: *******.*******@*****.*** Cell: +1-770-***-**** DOB: 6th Dec 1989

PROFESSIONAL SYNOPSIS

An energetic and enthusiastic IT professional armed with 9 years and 6 months of experience in Business Intelligence.

Identify priorities and requirements through establishing relationships with end-users and the IT organization, analysis of business workflows and an understanding of short and long-term business needs.

Expert technical skills as BI consultant, BI Developer understanding and providing solutions based on business requirement.

Develop, maintain and manage advanced reporting, analytics, dashboards and other BI solutions using reporting tools like Business Object, Tableau, Power BI and other BI tools etc.

Perform and document data analysis, data validation, data mapping/design, by accessing multiple sources, specifically data residing in data warehouses

Expert technical skills in Business Objects XI R1/R2/R3 & BI 4.1 Architecture and Content

Management Design and Deployment.

Expert in creating Web Intelligence Reports, Desktop Intelligence, Crystal Reports and Lumira Dashboards, Power BI dashboards.

Helped SAP to document more than 12 SAP Knowledge Base articles for BO XIR3.1 and 4.1 SP2 notes (Kbase articles)

Good written and verbal communication skills along with experience of working with technical stakeholders and Business leaders

A good Team member and can easily gel up with people.

Good knowledge on Agile processes to be followed for Agile methodology.

PROFILE SUMMARY.

Client interaction for requirement gathering, system study & analysis.

Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems.

Synthesize and translate Business data needs into creative visualizations using Analytical tools.

Understanding the technical & functional specifications. Creating Initial mapping to accommodate the business requirements into technical documents.

Responsible for Tableau/BO development, including universe creation, data foundation building, analysing the data models and version upgrades.

Analysing the requirement and creating a relevant universe for the reporting needs.

Analyse product log files, crash dumps, network traces, etc. to provide root cause analysis

Streamline and clarify active issues by associating bugs with existing bugs, finding duplicate issues, helping uphold proper reporting/escalation/closure processes for customer issues, trouble-shooting any user issues.

Create documents and implement standards and/or complex modelling to monitor and enhance the capacity and performance of the SAP BO reports, Tableau and Power BI dashboards.

Mentoring and assisting the team for optimum performance towards individual’s contribution.

TECHNICAL SKILL SET

Databases : ORACLE 9i, 10g, SQL Server, MySQL, MS Access, Teradata

Domain Experience : Business Objects XIR1/XIR2/XIR3 & BI 4.1, Tableau Server 8/9/10,Power BI, Lumira

INDUSTRY EXPOSURE

Organization

Industry

From

To

Role

Fiserv

IT

June 2015

Till Date

Data Architect, Analyst

Saama Technologies

IT

Mar 2013

June 2015

Associate Consultant

KPIT Cummins

IT

Sep 2010

Dec - 2013

Software Engineer

June 2018 – Till Date, FISERV Title: BI Consultant

SAP BO 4.1 SP6, Tableau, OBIEE, Database: Mysql, SQL Server, oracle

Scope

Implementation of a complete package of ETL and Reporting.

200 tables to be migrated from OWBI to Informatica (ETL Conversion)

More than 300 OBIEE reports to be migrated to SAP BO (Web Intelligence) reports and few of them to be converted to Tableau dashboards.

Working with Client to understand the requirement and then pass it on with my technical knowledge to offshore team, review the reports and universe, and migrate the code to production.

BO Maintenance and Administrative Support including weekly backups, publishing dashboards, providing users access, resolving user login and database connectivity issues, creation of schedules, optimizing dashboard performance issue etc.

I am responsible for designing and creating the universe and its security part and then design the complex reports/dashboards.

Develop universe from scratch as per the reporting need for Web Intelligence reports. Also, working on scheduling and publication of these set after the migration and testing to Production Environment.

Create documents like Technical Specification, Initial mapping, Technical mapping to help rest of the report developers use the semantic layer objects.

Setup Data and Row-level Security for internal and external users, depending on their roles.

Coordinating with cross functional teams for analysing requirements and testing the standard reports.

Daily Status update to client on issues and projects along with weekly CPT meeting.

Working as a Scrum Master and so need to make sure we follow the Agile Process while doing the conversions.

Conducted PI Planning session (Quarterly planning for Agile) to make sure all the work is present in story format in Agile.

Coordinate with partners for advanced training program for team members.

June 2015 – June 2018,FISERV Title: BI Consultant

SAP BO 4.1, Power BI, Informatica, Database : Oracle, Sql Server

Scope

Site/Project creation and setting up security for the same.

Capture column/objects/measures mappings and calculated objects based on project requirements

Prepare Universe Mapping Document, Review Documents, Report Mapping Document, Join Mappings document and check the Unit test document

Resolving loops, adding context, creating aliases, using cascaded lov’s in universe.

Created a custom hierarchy and prompt parameter for the same. Created cascaded prompts.

Business Securities set up at universe level for specific user groups.

Created number of documents which helps the team to analyse the report structure, queries of the report and data expected in the reports.

Automation of reports for weekly/monthly schedules.

Design, Build & schedule SAP Web Intelligence Reports to extract data and deliver it in various formats.

Creating Tableau and Power BI dashboards based on the requirement.

Provide Warranty Support and Prod support for deployed solution.

Installing required DB Drivers for connectivity to different database servers from Tableau Server and assisting users with DB Connectivity related issues.

Mar 2013 – June 2015 Saama Technologies Title: Associate Consultant

Tableau 10.2, BI 4.0 SP 2, Database: MS SQL Server, Oracle

Scope

Primarily worked as a BI Developer, and worked on other reporting tools like Tableau and Lumira dashboards.

Created the universe based on the data-mart.

Creating multiple objects in the universe and reports to deliver the report as per the Client Requirement.

Reviewer for the training of the new Hire’s batch for the SAP Business Objects Training.

Creation/addition of users/groups and providing access on required Sites/Projects.

Installing required DB Drivers for connectivity to different database servers from BO server and assisting users with DB Connectivity related issues.

Assist users with issues raised related to login (AD), dashboard refresh, new bugs etc.

Applying Support Packages and Patches along with testing of BI Upgrades.

Testing the BO Environment to ensure that it is ready for Development and Test.

Creating Users & Groups and granting access to Universes & Folders & providing them with effective rights in CMC.

Migrating the Reports & Universes between different environments and versions

Resolving the Service Requests / Issue Tickets on priority basis.

Performing maintenance activity on BI Servers on weekly basis.

Sept 2010 – Jan 2013, KPIT Cummins Title: Software Engineer

BI 4.1, 3.0,2.0, Database: Oracle 10g, Teradata

Scope

Check all the tools installed, check the connectivity, and ensure the proper privilege is provided to the development team in Dev and Test Environments.

Performing maintenance activity on servers on weekly basis.

Providing weekly and monthly status reports/metrics to the higher management.

Performing maintenance activity on servers on weekly basis.

Web Intelligence and Desktop Intelligence Reports: Designed and built WEBI Reports, Universes for clients. It involves day to day Client interaction to understand the specific details of the requirement and meet stringent deadlines

Universe Designer: The project objective also includes creation and optimizing business layer and providing insight in developing high end reports.

Identifying and reporting bugs detected to Product Group for hot fix generation based upon judging the criticality of a feature in the end product such as Universe designer, Web Intelligence, Desktop Intelligence.

In case of product limitations, provided workarounds to achieve the requirement.

Performed Desktop Intelligence Report Conversions to Web Intelligence

Worked on multilingual reports and have created reports based on different regional fonts.

Assisting in migrating and recreating Reports in Web Intelligence XI 3.1.

Excellent problem solving and analytical skills

Author, Review and Release Knowledge Base articles related to Business Objects products.

Won awards like Customer Delight award, Cheers awards.

Integrating Business Objects products with the Third party Authentication Tools (AD, LDAP,SSL)

CORPORATE TRAININGS

Name of the Course : Business Objects XIR2 Training and Development

Organized by : SAP & KPIT Cummins

Name of the Course : Business Objects R3 Development and Security Setup

Organized by : SAP & KPIT Cummins

Name of the Course : Introduction to SAP Lumira and Analysis for MS Office

Organized by : Saama Technologies

Name of the Course : SSIS/SSRS

Organized by : Fiserv

EDUCTATIONAL QUALIFICATION

Bachelors - Computer Science

PVG College of Science Pune

April-2010

(Shreyas Saste)

Contact this candidate