Prakash

PROFESSIONAL SUMMARY

Business Intelligence professional with over 8+years of experience in Software Design, Development, Integration, Implementation of BI and Database Platforms.

Involved in SDLC of Reporting Projects, includes Requirements Gathering/ analysis, Design, Development, Testing and Production rollover.

Extensive Tableau experience in Enterprise Environment in Tableau 9.x/10.x as a Developer, Administrator and Analyst.

Good knowledge on Tableau Desktop, Tableau Server and Tableau Reader.

Expertise in designing and development of various dashboards, reports utilizing Tableau Visualizations like bargraphs, scatter plots, pie-charts, geographic visualization and other making use of actions,local and global filters according to the end user requirement.

Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.

Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.

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

Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.

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

Expert in Unit, System and User Acceptance Testing and Performed Data Validation for all the reports and dashboards generated from various database sources.

Knowledge on ETL tools like Informatica,Alteryx.

Experience in developing DWH & OLAP solutions and extensive use of Databases (Oracle, SQL Server) and SAP BOBJ 4.1/4.0/BOXI R3.1/R2/ 6.5, Universe Design Tool & Information Design tool,Designer, Desktop Intelligence, Web Intelligence Rich Client, BI Launch pad, InfoView,Crystal Reports.

Presentation of the advanced features of Business Objects to end-users to enable them to develop reports easily.

Developed Dashboards with Dashboard Design components using maps, Pie Charts, Staked Bar, List Views etc. creatively using best dash board components effects for better interaction.

Involved in full Life Cycle of a project, which includes Requirement Analysis, Planning, Designing, Development, Test and Roll-Out / Go Live.

Team player with good communication and interpersonal skills. Productive interaction with business partners to identify business information needs for reports

TECHNICAL SKILLS

Business Intelligence Tools

Tableau Desktop 7/8.x/9.x/10.1,Tableau server 8.0/9.0, Business Object BOXIR2/3x/4.0, Crystal reports 8.x/10.x

ETL Tools

Informatica.

Databases

MS-SQL Server 2000/2005/2008, Hive, Oracle11g/10g/9i/8i, DB2, Teradata.

Languages

SQL, T-SQL, PL/SQL, JAVA, HTML, XML, C, C++.

Operating Systems

Windows 7/VISTA/NT/ XP/ ME/ 2000/ 95/ 98, LINUX/UNIX.

PROFESSIONAL EXPERIENCE:

Department of Transportation, Madison, WI Feb 2015 – Till Date

Tableau Developer

Responsibilities:

Designing and deploying multiple Tableau v9.x/10.1 dashboards across 3-tier environment sourcing from varied data sources such as SQL server, Hive/HQL, Flat files.

Involved in every step of the Development including Business requirements gathering, design and UAT.

Blended data from multiple data sources into one report by selecting primary keys from each source.

Preparing Dashboards using calculations, parameters in Tableau and created calculated fields, groups, sets and hierarchies etc.

Creating views in Hive servers to use as data sources in Tableau.

Working in Big data environment using tools like Datameer.

Creating data models in the Big data tool Datameer.

Used Sqoop to import data from a relational database management system (RDBMS) such as MySQL or Oracle into the Hadoop Distributed File System (HDFS), transform the data in Hadoop MapReduce, and then export the data back into an RDBMS.

Implemented Validation Dashboard which can be used to validate metrics (KPIs) against different worksheets & databases.

Designed a Tableau Interface to Enter, Report & Schedule Hive jobs. Execute SQL statements for Validation via single user interface & Monitor the Scheduled Jobs.

Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.

Monitored VizQL server, Application Server and data server activity to track performance and system stability.

Scheduling data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.

Formatting Tableau dashboards to fit PDF files and distribute them via emails to executive management.

Validating the report data with the source systems and reviewing it to find any data anomalies.

Involving in administrative activities, working as a site admin, maintain users, custom views.

Set up Weekly schedules of reports to email users based on data refresh.

Participating in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau desktop 9.x/10.1, Tableau server 9.x/10.1, Datameer v5.11.13, SQL server 2008, Hive, Microsoft office suite 2007.

State farm Insurance, Bloomington, Illinois April 2013 –Jan 2015

Tableau Developer

Responsibilities:

Interacted with business users and performed Gap Analysis of Client requirements.

Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business's needs.

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

Designing various types of visualizations for vulnerability scan data and clarity data.

Administered user, user groups, and scheduled instances for reports in Tableau.

Executed and tested required queries and reports before publishing.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.

Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.

Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.

Provided support for Tableau developed objects and understand tool administration.

Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.

Created Custom Hierarchies to meet the Business requirement in Tableau.

Created various connections, Data foundations and Business layers.

Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.

Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.

Strong verbal and written communication skills, ability to work effectively with user departments.

Environment: Tableau7.0/8.0, Tableau Server,BO 4.0, Universe Designer, Desktop Intelligence, Web Intelligence, Oracle, Microsoft SQL Server, Oracle, Microsoft Office, Microsoft Visio, Windows 7

Genentech, South San Francisco, CA April 2012 – Mar 2013

DW BO Analyst/Developer

Responsibilities:

Participated in gathering Business Requirements and client Meetings.

Created Business Objects Universes against the Star Schema to support Users.

Performed analysis, design, develop, testing and Maintenance of Universes.

Created universe classes, objects (measures, dimensions and details).

Defined Aliases and Contexts to resolve the join issues in the Universe.

Involved enhance performance of queries used to create reports.

Solved the issues during designing such as loops, Cartesian product due to fan trap and chasm traps.

Created reports for various Portfolios using the Universes as the main data Providers.

Implemented various types of joins including equi-joins, outer joins and self-joins on tables in schema.

Developed reports using various functions, operators, Calculation Contexts, report filters and variables.

Used Business Objects report level properties like Breaks, Rank and Customized filters to display relevant data.

Created Different type of Graphs (Bar, line, Pie chart etc) and Cross Tabs with all sorts of formatting for report level analysis.

Created the reports using Business Objects functionalities like Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etcin Web intelligence.

Extensive testing and migrating the reports or objects from development to Production system.

Automated the reports for refreshing the data every month and quarter details.

Trained user community in basic and advanced Business Objects reporting skills.

Regularly synchronized the QA, DEV environments with Production reports and Developed, Customized and Implemented reports using Crystal reports.

Developing Canned Crystal Reports using Business View as the Data source in Crystal.

Created Running Totals, Formulas and different functionalities like Hyperlinks, Graphs, Charts, and sub reports based on report requirements in Crystal reports.

Configured the environment, Developed, Scheduled and Tested reports using Crystal reports and Business Objects (Business View Manager, Infoview).

Environment: SAPBOXIR2/3x/4.0, Designer, CMC, Desktop Intelligence, Web Intelligence, XCelsius, CrystalReports, Business View, Oracle 11i, SQL, Win 2007.

Golden Source Corporation– New York, NY January 2011-March 2012

Business Objects Developer

Responsibilities:

Design universes and objects by retrieving the data from various data sources and defining the necessary connections.

Used various join methods like Equi-join, Theta join, Outer-join while creating Universe.

Created new reports from the scratch for new requirements and modified some of the existing reports in three different Universes.

Created new Attributes, Filters and Complex measure objects in the Universe.

Resolved Loops, Fan traps and Chasm traps with Aliases and Contexts.

Creating Measure objects and hierarchies to enable drill down functionality in the reports.

Created custom LOV’s and Hierarchies for easy user selection drill down purposes.

Exported the Universe/Reports to the Repository.

Worked on the SQL tuning and optimizationof the Business Objects reports.

Deploying Business objects contents in production environment by Importing BIAR file using Import wizard.

Worked with multiple Data providers in a report and added slice and dice capabilities.

Created reports to be published in the repository accessible by User Groups.

Developed Cross-Tab and Drill Down reports.

Formatted the Reports as per the Users requirements using all the facilities in Business Objects, which allows the users to analyze the data.

Involved in Development of reports using Business Objects in monthly transaction (MTD) and year to date transactions (YTD).

Extensively used Calculations, Variables, Breaks, Sections, Ranking and Sorted Inputs Drill down, Slice and Dice, Alerts for creating Business Objects reports.

Created documentation for all test case runs with expected and actual results.

Understanding of Fixed Income and mortgage securities in Investments.

Worked along with the testing team to derive test cases for efficient Data reporting.

Performed the knowledge transfer to other team members, provided application and user on-call support.

Environment:BO XI R2/3x, Designer, CMC, Desktop Intelligence, Web Intelligence, DB2, SQL, Win XP.

InfoTech Pvt. Ltd., India Aug 2008 – Dec 2010

Business Objects Developer

Responsibilities:

Involved in-group meetings to analyze business requirements by close interaction with the Users and Business Analyst team.

Developed Universe as per the Business requirements.

Resolving the loops using Contexts and Alias and checked the cardinalities, Integrity of the Universes.

Used @ functions like @prompt to create user interactive objects.

Developed and created classes with dimension, detailed and measure object and specified hierarchies.

Designing Business Objects Universes and reports based on the Specifications.

Actively worked with the end users in finalizing the Functional Specifications.

Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.

Prepared user documentation for hands on training of end user community.

Created reports using functionalities like Alerts, filters, break etc.

Created variables, formulae and detail objects at report level to create new columns based on the result set of the report.

Designed, developed, maintained and tested universes to supporting ad hoc queries and canned reports.

Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.

Developed complex queries using different data providers in the same report and synchronized the data.

Formatted reports as per the users’ requirements using all the facilities in Business Objects, which allows the users to analyze the data.

Created the reports using Business Objects functionalities like Slice and Dice, Drill down, Cross Tab, Master/Detail and Formulas etc.

Worked extensively with the major functionality of BO like Breaks, Ranks, Variables, Alerts, Formulas, Calculated data items, Filters, Sorts, and Query prompt and Drill filters.

Worked withCMC for creating repository, creating and managing the universes, creating categories, creating and managing the users, giving access permissions for Business Objects Reports.

Environment:BO 6.5/ XI R2, Web Intelligence, Designer, CMC, Info View, Oracle 9i, SQL, PL/SQL, Win XP.

Contact this candidate