Candidates About

 

Prasanna Kumar Bokam

SAP BOBJ and Tableau Developer

 

·10 years of experience in Data warehousing and Business Intelligence technologies along with around 3+ years of data visualization using Tableau

·         Business Intelligence Analyst with vast experience in data analysis, database design, SQL programming, data modelling and reporting.

·         Experience with business reporting and analytics using SAP Business Objects Reporting Services, Tableau, OBIEE 11g, SAP Lumira, SAP Design Studio.

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

·         Experience in creating universes, reports, scheduling using SAP BOBJ.

·         Experience in creating  Rpd, Anaytics dashboards, scheduling using ibot in OBIEE

·         2+ Years of experience working on Tableau creating various Reports and Dashboards using different functionalities.

·         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.

·         Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.

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

·         Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.

·         Good leadership, organizational, oral/written communication, interpersonal, analytical, and problem solving skills.

·         Expertise in project management, billing and staffing resources.

 

H1B - Authorized to work in the US for any employer

 

Technical Skills

BI & Data Visualization Tools:  SAP Business Objects Suite(XI 4.x), Tableau,  OBIEE 11g, SAP BO Design Studio, SAP Lumira, SAP HANA

Scripting Languages: SQL, PL/SQL, Python, Unix

Operating System: Windows NT, Windows XP, Windows Vista, Unix, iOS

RDBMS: Oracle, Teradata, MS SQL Sever

Datamodelling tool: Erwin, SQL modeller

GUI tools: Toad, SQL developer, Teradata SQL assistant

MSOffice Tools MS Excel, MS Access, MSWord, Visio, PowerPoint

 

Awards:

Citi Star Award by IBM for most trusted and dedication towards multiple Business Objects releases

 

Educational Qualifications

➢   Bachelor in Technology from Raghu Engineering College, Visakhapatnam

 

Trainings

➢   Have Undergone BO Training and Pl/Sql training.

 

 

 

Work Experience

 

Lead BOBJ/Tableau Developer

Client : Apple, Cupertino, CA

Technologies: Tableau 10, SAP BOBJ, Teradata, Mac OS.

Oct 2014 to till date

 

Works for Apple Worldwide team and helps to develop the strategy by helping the business analyze their data in different ways and come up with the right questions to fulfill the company's objectives.

·         Create and maintain hundreds of business critical ongoing and ad hoc reports covering customer sales, forecast, master production schedule, OEM production, supply allocation and inventory data using Business Objects and Tableau.

·         Develop supply chain strategies for all Apple product lines to increase customer delivery times, and minimize supply risks. 

·         Responsible for interaction with business stakeholders, gathering requirements and managing the delivery.

·         Implement new reporting solutions from multiple data sources, which included dashboards, Interactive documents, and free form SQL reports.

·         Design, review, update and execute project requirement documents, test plans, help documentation, release notes, customer UAT's, and stakeholder demonstrations.

·         Extract, scrubbed and blended large data sets to produce BI and Analytic solutions for executive management.

·         Worked on various POC's utilizing Visualization tools like BO, Tableau, and OBIEE and provided input in evaluating the tool capabilities.

BOBJ Developer responsibilities:

·         Provided Business Objects troubleshooting, architecture, configuration, system enhancements, audit reporting, business report development and universe design development

·         Created reports by using multiple data providers(using ecxel,universe etc).

·         Used calculations, Sorting, Rank, Drill down, Drill through, Formatting, Breaks, Filters, Prompts, Sections for creating reports.

·         Created the Reports using Merged Dimensions and Combined Queries.

·         Involved in Scheduling the reports to the appropriate users.

·         Tested the developed reports by writing SQL queries for validating data in backend.

·         Try to improve the performance of reports by tuning them

Tableau Developer responsibilities:

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

·         Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.

·         Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.

·         Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

·         Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

 

 

 

Lead OBIEE Developer

Client : Apple, Hyderabad, India

Technologies: OBIEE 11g, Teradata, Mac OS.

Feb 2013 to Sep 2014

 

·            Interacted with Business Users and Business Analysts to gather and document the requirements and translate these to technical specifications.

·            Lead a reporting team to ensure high quality reporting standards.

·            Created Requirements Traceability Matrix and Mapping Document to trace requirements in BI implementation.

·            Created Physical, BMM and  Presentation layer in rpd.

·            Developed interactive Dashboards and Reports in Oracle BI Answers as per the reporting specifications.

·            Shedule reports using ibots.

 

 

Senior Business Intelligence Developer

Client: Citigroup, Kolkata, India

Technologies: SAP BO XIR3.x/XIR2, Oracle 10g, Sql Developer, Windonw 2000.

Sep 2009 to Dec 2012

 

·            Analyzed the business requirements along with Onsite co-ordinator and teams.

·            Developed Universes and reports as per the requirement.

·            Attened the UAT sessions with UAT teams and prepare plans.

·            Tested business objects reports for data validation and compared results with TOAD.

·            Prepared specifications and documentation of reports for end users

 

Business Intelligence Developer

Client: Hewlett Packard, Bangalore, India

Technologies: BO XIR2, Oracle 8i, Toad, Windows 98.

Nov 2007 to Feb 2009

 

·            Analyzed the business requirements along with Onsite co-ordinator and teams.

·            Enhanced the universes by adding tables, classes and objects.

·            Developed reports using Business Objects functionality like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail.

 

Business Intelligence Developer

Bharathi tel

Noida, India

Nov 2006 to Nov 2007

·            Worked as BI Reporter cum Developer and SQL developer.

·            Developed reports and dashboards as per requirement.

·            Enhanced the universes by adding tables, classess and objects.

·            Tested the universe by doing intergity check.

 

Software Engineer

GMIPL

Visakhapatnam, India, Jun 2006 to Oct 2006

·            Worked as SQL developer.