Tableau, SQL,SAS,SAP Business Objects

SHRAVANI BACHU

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

Cell : 469-***-****

Professional Summary:

* ***** ** ********** ** Information Technology using SAS, SAP Business Objects and Tableau in Finance & Retail domain.

In-depth knowledge on Tableau Desktop, Tableau Reader, Tableau Server and Tableau Mobile.

Developed dashboards with Dual Axis concept, Implemented Quick/Context filters, Parameters, Aggregations, Binning, and dynamic sorting by creating parameters.

Experienced in data blending by sourcing data from various data sources.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu options using Tableau.

Developed Dashboards with Quick filters, Calculated fields, Groups, Parameters and Sets to handle views more efficiently in Tableau.

Sourced and analyzed data from a variety of data sources like Oracle, DB2, SQL Server, MS Access and flat files etc.

Experience including technical support, troubleshooting, report design and monitoring of system usage in SAP Business Objects.

Experience in Base SAS, SAS/SQL, SAS/Stat, SAS/Connect, SAS/Access, SAS/ODS.

Possess excellent communication, decision-making, Problem Solving, Analytical, and Interpersonal skills with result oriented dedication towards goals. Capable of working as a Team Member or Individually with minimum supervision.

Technical Skills:

Database Warehouse Tools: SAP Business Objects Enterprise XI 3.1, SAP Business Intelligence BI4.0, BI 4.1, Tableau 7, Base SAS and SAS Enterprise Guide.

Operating Systems: Windows, Unix.

Databases: Oracle, SQL-Server, MS Access and MS Excel.

Languages: SQL.

Experience Summary:

Fannie Mae, Dallas, Texas 11/2015 – Till date

Role: Business Analyst/Tableau Developer

Mortgage Fraud Reporting & Analytics team supports Fannie Mae Compliance & Ethics for its reporting and modeling needs. My role as a Tableau Developer is to develop monthly/quarterly Federal Regulatory Reports for submissions to Federal Housing Finance Agency (FHFA) and provide Infrastructure Support for the Fraud Case Management System (FCMS) project. I was SME in developing SARs (Suspicious Activity Reports) filed to FinCEN (Financial Crimes Enforcement Network) as per FHFA regulations.

Responsibilities:

Involved in meetings and projects with business users, project managers & developers to automate and upgrade applications that accomplish business operations and goals.

Responsible for generating, maintaining and automating daily, weekly, monthly and quarterly reports for the Fannie Mae Compliance & Ethics team and FHFA and other Stake holders as required.

Developed complex dashboards for Higher Management using Tableau and sourced data from Oracle.

Built Tableau dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.

Developed Tableau data visualization using Cross tabs, Heat maps, Donut Charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts.

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau desktop.

Created Complex Tableau reports utilizing the features like Hierarchy, New Calculated Columns, Actions - Drill Down functionality, Graphs. Also Created Parameters to achieve desired functionality.

Used Informatica to populate the data mart from large flat files and relational databases.

Involved in the development of Informatica mappings between Source system and Warehouse.

Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboards using KPI's.

Utilized Tableau server to publish and share the reports with the business users.

Expertise in writing SQL Queries, Dynamic-queries, sub-queries and knowledge of Stored Procedures, Triggers.

Worked with various teams across different domains to support their data & analytics needs.

Extensive Experience in Base SAS, SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/ACCESS and SAS/ODS etc in Windows & Unix environment.

Environment: Tableau 8.x /7.x (Desktop/ Server), Base SAS, SAS Enterprise Guide, MS SQL Server, Oracle, Windows, Linux.

Project Details in KPIT Technologies Ltd., Pune, India:

Client Name 1 : ICICI Bank 08/2013- 08/ 2015

Role : Tableau Developer/ Engineer

ICICI is a leading financial institution involved in personal and institutional lending, mortgages and banking. The project scope is to design and build reports for decision support for personal and institutional loan data. The reports are built from data received from various branches and offers summarized view for optimized decision making.

Responsibilities:

As a Tableau Developer, using Tableau for Data Analysis, Digging the data for source, systems analysis and deeply diving the data for Predictive findings and for various data Analysis.

Analyzed and gained understanding of the underlying data and generated tableau dashboards with forecast and reference lines.

Worked with clients to better understand their reporting and dash boarding needs and present solutions using structured Waterfall and Agile project methodology approach.

Designing and developing, proto typing the various dashboards using tableau desktop. Also involved extensively for building the dashboards such as creating Tableau Extracts, Refreshing extracts, Tableau Layout designing, Tableau Work Sheet Actions, Tableau Functions, Tableau Connectors (Live and Extract), Dashboard color coding, formatting and report operations (sorting, filtering (Quick Filters, Cascading filters, Context Filters), Ranking, Top-N Analysis, hierarchies).

Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

Build interactive Tableau dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, Sets to handle views more efficiently.

Worked on querying data and creating on-demand reports using Tableau Desktop and publish the same to Server.

Designed and developed Business Intelligence end to end solutions using Tableau desktop.

Created reports for users using Tableau Desktop by connecting to multiple data sources (Flat files, MS Excel, .CSV, SQL Server, Oracle).

Developed an ad-hoc Tableau reports based on agile business requirements.

Developed Dashboards using quick filters, context filters, global filters, parameters and calculated fields on Tableau reports.

Worked on groups, sets, parameters, different calculation functions including Table calculations.

Worked on various reports using best practices and different visualizations like Bars, Trends, Pie charts, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.

Involved in data analysis, reviewing business requirements and publishing the same to business.

Reviewed basic SQL queries and altered for better performance in Tableau Desktop.

Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment: Tableau 8.x /7.x (Desktop/ Server), MS SQL Server 2008, Oracle 11g, Teradata, Windows 2008.

Client Name 2: SAP 10/2012- 08/ 2013

Role : Junior Engineer

I worked on SAP Business Objects support project directly with SAP Client. SAP is a global software company, one of the largest vendors of ERP and other enterprise applications. The company is headquartered in Walldorf, Germany.

Worked on Tableau for internal reporting by connecting to oracle database to identify the productivity, customer service quality of each team and employee.

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

Generated context filters and data source filters while handling huge volume of data.

Built dashboards for measures with forecast, trend line and reference lines.

Published Workbooks by creating user filters so that only appropriate teams can view it.

Created Users, Groups and Set Permissions on Server.

Worked on reporting as well as admin part.

Connectivity issues of Business Objects reports with various Relational Databases.

Creating universe level filters and prompts for various reporting needs.

Designing reports and variables in report and scheduling concepts.

Creating BO users in CMC (central management console) and assigning rights to them.

Using Import wizard (3.x) and Upgrade Management Tool (4.x) to migrate the content between different versions.

Creating jobs in Promotion Management Tool to migrate the content between different environments.

Modifying and creating the reports based on the user requirement.

Remote accessing SAP customer’s environments and troubleshooting on issues.

Experience in Business Objects trace logs and digging to the root cause of issues.

Creating Users, User groups and setting up the user profiles.

Interacting with customers, understanding their requirements, designing, testing and troubleshooting Business Objects Universes and Reports for various clients of Business Objects.

Establish connectivity from reporting databases to Business Objects by installing correct middleware drivers and performing various configuration steps.

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

Modifying the Sever properties like (sizing, timeout, cache size, time session ...etc.) from CMC.

Creating a new Server’s - Web Intelligence Processing Server, Creating and Sizing on Adaptive Processing Server, Creating Adaptive Job server for scheduling, creating a connection Server for testing issue’s on Customer Environment’s.

Published the Reports in to different formats like (Excel, PDF etc.) using the Publication from the CMC and BI Launchpad.

Create jobs and scheduling the jobs according to the requirement.

Scheduled the multiple Webi & Deski reports using the publication in different formats and sent to the enterprise recipients as well as Dynamic recipients.

Creating Multiple Server Groups to maintain BO System easily.

Used Translation management tool, Report conversion tools.

Created the New Custom Access levels in to BOE 3.1, BI 4.0, and BI 4.1.

Using the Custom Access levels granted the Rights to the Groups, folders and Applications.

Migrated all the Scheduled jobs and publication jobs in to BO 3.1, BI 4.0, BI 4.1.

Assigned the jobs to the one particular Job Server Group to reduce the load on BO servers.

Deploying the Reports, Universe, and Rights etc. from one environment to another environment using Import wizard.

Expert in Scheduling and Publication jobs in BOE 3.1 and BI 4.0, 4.1.

Environment: Tableau 8.x /7.x (Desktop/ Server), BOE 3.1, BI 4.0, BI 4.1, MS SQL Server 2008, Oracle 11g, Teradata,Windows 2008.

Project Details in Goldstone Technologies Ltd., Hyderabad, India:

Client Name : SAP 06/2011- 10/2012

Role : Technical Trainee Associate

I worked on SAP Business Objects support project directly with SAP Client. SAP is a global software company, one of the largest vendors of ERP and other enterprise applications. The company is headquartered in Walldorf, Germany.

Responsibilities:

Worked on Web Intelligence reports refresh issues in SAP business Objects.

Designing reports and variables in report and scheduling concepts.

Maintaining users and access levels.

Maintaining the client and server applications.

Migrating universes and reports using Import Wizard and LCM.

Working on Adaptive Processing Server splitting and assigning memory for required services based on the requirements.

Managing the Web Intelligence Processing Servers based on the hardware requirements of server box and setting the parameters of Webi processing servers.

Environment: SAP Business Objects 3.x/4.x, Oracle, MS ACCESS, MS EXCEL, MS SQL Server, Windows.

Education:

Bachelors of Technology from JNTU-Hyderabad, India. - 2011

Contact this candidate