Resume

Sign in

Reports Manager

Location:
San Francisco, California, United States
Salary:
110k
Posted:
August 29, 2017

Contact this candidate

Chandra Marri

ac12g7@r.postjobfree.com

Bay Area, San Francisco, CA, 94158

Mobile: 415 *** ****

SUMMARY & CAREER ACCOMPLISHMENTS

Over 10 years of experience in IT Industry and 8 years as Data Analyst on Tableau, Tableau Desktop, Tableau Server and SAP Business Objects 4.1,XI R3.1/XIR2/6.5, BO 4.1 UDT(Universe Design Tool),BI Launch Pad, IDT(Information Design Tool) worked on Universe Designer, Web Intelligence (Webi), Desktop Intelligence (Deski), Info View, CMC (Central Management Console ), CCM (Central Configuration Manager),Supervisor,Publication,Broadcast Agent, Import Wizard, Dashboards and Crystal Reports, Xcelsius 2008, Tableau, Live Office, SQL, Oracle 7.3, 8, 9i, 10g, 11g, PL/SQL Scripts Server 6.5,7.0,2000,2005,2008, Transact-SQL (T-SQL), MS Access, Excel,VBA,Macros

Over 5 years of experience in Data Visualization with Tableau Desktop, Tableau Server and Tableau Online in various versions of Tableau 10,9,8,7 versions. Created histograms, pie charts, box plots, scatter plots for inventory management, background maps illustrating the potential revenue change, destinations flown cross 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

Creating dashboards in line with the analytical uniformity using the Advanced Analysis of Tableau Desktop, and organizing Dashboard views and objects.

Experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive dashboards with Page and dashboard Prompts.

Experience in creating different visualizations using Bar, Line and Pie chart, Background Maps, Box plots, Scatter plots, Gantt charts, Bubble charts, Histograms, Trend lines & statistics, Bullets, Heat maps and Highlight tables.

Efficient management of Tableau Server by managing & setting permissions, publishing various data sources and workbooks to Tableau Server.

Extensive experience in preparing dashboards using calculated fields, parameters, actions, groups, sets and hierarchies in Tableau Desktop and defined best practices for Tableau report development.

Hands-on experience with SQL scripts like stored procedures and data validation.

Experienced in creating Universe Designer in development process created classes, objects, measures, join conditions, Filters, checking cardinalities, defined hierarchies, checking the integrity of the universes. Used contexts, aliases, shortcut for resolving loops of the Universes and exported the universe to repository

Experience in Installation, Configuration, Administration and Security of SAP Business Objects, Crystal Reports, Web Intelligence, Xcelsius

Reported KPI's to internal and external account managers, directors, and senior management on a daily, weekly and monthly basis.

Extensively worked on Web Intelligence used advanced reporting functionalities such as Master Detail, Cross-Tab, Drill, Filters, Ranking, Graphs, Breaks, Alerts, filters, Prompts, Variables, Formulas, calculation Contexts in building reports, multi-tab report and Scheduling of the reports etc.

Developing complex universes by using advanced features in SAP Business Objects like Lov’s, prompts and resolving the loops using aliases and contexts.

Extensive experience in Migrating Business Objects 6.5.2 to BO XI R2, BOXI 3.1

Excellent Knowledge with Star Schema and Snow Flake Schema Data Models

Installing Business Objects BI4 & BOXI 3.X server as Administrator, configuration of BO tools, set up and maintenance of Business Objects Enterprise environment, creating and managing groups and user profiles.

Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)

Worked on Cognos 10.2 suite, Report Studio, Analysis Studio, Cognos Connection, Event Studio, Query Studio and Framework manager

Experience in VBA for MS Access, Excel (Macros), pivot tables, vlookup and macros

Data Warehouse and Data Mart Design and (Ralph Kimball) Data Warehouse architecture

Worked on OLAP (online analytical processing) and OLTP (online transaction processing)

Experienced on Remedy Incident Management, Change Management, Problem Management, Asset Management, SLA and Advanced Health & Care for Business Objects reporting

Creating dashboards in line with analytical uniformity using the Advanced Analysis of Tableau Desktop, organizing Dashboard views, objects

Worked on ITSM Universe to build reports using Web Intelligence and Desktop intelligence

I have given Interview on BBC World Service Radio, London, UK i.e. 7th February 2003 at 10:45, live discussing on German BMW site Google 'death penalty', how to get companies onto top of the listings(organic) on Search Engines like (Google, Yahoo, MSN), how to get popularly ranked and improve their presence on search engines.

Brainbench certified in Active Server Pages (ASP), VBScript 5.5, HTML 4.0, Microsoft Visual InterDev 6.0, Visual Basic 5.0,6.0 (VB)and Microsoft Internet Information Server (IIS) 4.0 etc.

Excellent documentation and writing skills

Certified in Aviva Business Protection Certificate and in Aviva Anti-Bribery and Corruption

Worked on Oracle Applications R12/11i as a Technical Consultant. Worked full life cycle implementation experience of ERP (Oracle Application R12/ 11i) Technical (GL, AP, AR, INV, PO, OM) and exposure to functional as well

Worked on Oracle PL/SQL and SQL Server T-SQL programming Stored Procedures, functions, Triggers, Packages, SQL Scripts etc.

Preparing the MD070 and MD0120 Documents after completion of the component and CV60, MD70 using AIM 3.0.

Worked in Novasoft (Europe) Ltd in London, UK for more than 3years on various designations as Software Consultant

Worked as Business Development Manager managed over 15 members of the SEM team. Primarily working on SEO and Internet marketing taking care of clients Sponsored Ads, Search Marketing, Link Building, and optimization

Created dashboards in Google Analytics for ecommerce sites and Provided both internal performance reporting and web analytics

Worked on SEO, Content, Link Strategies, Keyword Analysis and Pay per click (PPC).

Involved in Software Testing, QA, Debugging, Manual and Black box and White box testing.

SKILLSET

SAP Business Objects (BI) 4.1, XIR3.1, R2,6.5, Designer, Desktop Intelligence (Deski), Web Intelligence (Webi), CMC (Central Management Console), CCM (Central Configuration Manager), UDT (Universe Design Tool), BI Launch Pad, IDT (Information Design Tool) Crystal Reports, Xcelsius 2008, Query Builder, Tableau, Live Office, Qlikview, QAAWS, Dashboards, Oracle, SQL Server, SQL, PL/SQL and Informatica

ERP Oracle apps (Oracle Applications R12/11i Financials) and R12 Technical Consultant (GL, AP, AR, INV, PO)

Oracle 7.3, 8, 9i, 10g, 11g, PL/SQL, SQL Server 6.5,7.0,2000,2005,2008, SQL, Transact-SQL (T-SQL), SSIS, SSRS, SSAS, Unix, MS Access, Developer/2000, Oracle Forms 4.5,6i, 10g(web), Visual Basic 5.0,6.0, ASP.NET, Oracle Reports 2.5,6i, Crystal Reports, Oracle Discoverer, TOAD, Excel, VBA Access, SQL*Loader, XML

MS Active Server Pages (ASP), Cold Fusion 4.5, HTML, XHTML, VBScript, JavaScript and CSS, Microsoft Visual InterDev, Dream weaver MX, Microsoft Visual Studio, Microsoft Internet Information Server (IIS), FTP, Magic (frontend), FrontPage 2000, FoxPro, Cute FTP, MS Office Word, Excel, PowerPoint

CAREER HISTORY:

Dec 28th 2016 to May 28th 2017

Company: Webcor, Alameda, California

Designation: Business Intelligence Report Developer /Tableau Developer

Created dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver actionable insights and clear visualizations of various KPIs

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps

Developed OPC Dashboard and G&A Dashboard for decision makers

Developed complex reports in Webi Cross tab, Charts, Drill through and ad-hoc reports using BO Web Intelligence.

June 13th 2016 to Nov 1st 2016

Company: Kaiser Permanente, Oakland, California

Designation: Tableau Developer/ Report Developer

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

Delivering reporting for revenue cycle clients reports, Summary reports, dashboards, monthly reports such as Bar charts, 3D charts.

Partner with business analysts to understand requirements, source systems, and perform data analysis

Worked with the Business users to understand report requirements based on existing reports/dashboards in source systems and other teams on dependencies, timelines, testing, and technical delivery.

Prepared Business Requirement Document and converted business requirements into Technical Specification documents.

Worked closely with business power users to create reports/dashboards using Tableau Desktop.

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

Creating dashboards in line with the analytical uniformity using the Advanced Analysis of Tableau Desktop, and organizing Dashboard views and objects

Responsible for Developing Dashboard and preparing ad-Hoc Reporting in Tableau, Business Objects

Created and developed Parameterized, Drill Down and AD Hoc Reports in Tableau

Worked on designing, developing on new report in Tableau based on legacy reports

Developed reports in Tableau, Business Objects reports Revenue cycle decision support

Responsible for creating reports using Webi (Web Intelligence) and Dashboards

Developed complex reports in Webi standard reports, ad hoc reports. Setting up report schedules daily, weekly and monthly

November 18th, 2013 to Dec 2015

Company: Advanced365, Central London, UK

Designation: Tableau Developer/ Business Objects

Participated in admin activities including improving the scalability of the Tableau Server environment by distributing server components across several machines.

Configured distributed Tableau Server environment for real-time replication and failover support.

Provisioned a new Tableau Server site by exporting an existing site and imported it into the new one.

Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.

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

Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Involved in designing, developing, maintaining new and existing universes by required tables, creating joins and checking cardinalities responsible for creation of the universe with classes, objects and condition objects.

Responsible for creating reports using Webi (Web Intelligence), Desktop Intelligence and Dashboards

Delivering reporting for company clients Monthly reports, Summary reports, Detail reports, created graph reports such as Bar charts, 3D charts and Pie charts.

Developed complex reports in Webi standard reports, ad hoc reports. Setting up report schedules daily, weekly and monthly

Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization.

Worked on building queries to retrieve data into Tableau from SQL Server 2008

Designed and developed the most suitable User Interface such as Dashboards, multiple charts types, Trends, custom requests for Excel Export

As Business Objects Administrator managing users and groups, including access rights and security, instance manager on BO Central Management Console (CMC) and monitoring BO services

Developed report using Desktop Intelligence (Deski) Free-hand SQL report and Ad Hoc report developed in Webi

Installed Business Objects XI 3.1 Enterprise Suite on Windows 2003 server on SQL Server, complete backend server administration from installation to deployment

Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Generated Tableau Dashboard with quick, context, global filters, parameters and calculated fields on Tableau reports.

BO Administered users and groups using LDAP authentication and monitor server activities using Auditor

Prepare Dashboards using calculations, parameters in Tableau.

Deployed all the reports and deployed on production environment.

Trained end users to use Infoview with various functionalities of Business Objects and provided support.

Interfaced with business users to prepare and update Business Requirement Documents (BRD). Ensured all requests complied with corporate SDLC Policies and guidelines.

Build reports based on Remedy environment as well

August 5th, 2013- November 7th 2013

Company: iGO4 Insurance Company, Peterborough, UK

Designation: Senior MI Analyst/MI Manager (Contract)

Created Universe and Developing Canned/Ad-hoc Reports, Scheduling and processing of reports.

Experience with universe designer, desktop intelligence, web intelligence, analytics, Xcelsius and dashboard development tools

Responsible for SAP BO administration and security activates related to the project.

Extensively used Business Objects reporting functionalities such Slice and Dice, Drilled, Filters, Ranking, Sections, Graphs and Breaks and creating Xcelsius Dashboards

Developed complex reports in Webi Cross tab, Charts, Drill through, Master-Detail and Cascading and ad-hoc reports using Report studio.

Worked on Congo’s report studio scheduling reports, filters, static prompt conditions and building Cognos reports using CDL Strata environment

June 2013- August 2013

Company: BMW, Oxford, UK

Designation: Data Analyst (Contract)

Responsible for understanding end user requirement and convert into functional requirement and develop reports

Created complex Master/Detail, cross tab reports with different data providers using universe and free-hand SQL and implemented various functionalities like Breaks, Alerters, variables.

Created the reports using Business Objects Crystal Reports inserting filters, sorting, ranking etc.

March 12th, 2012- April 2013

Company: QuoteMeHappy, Aviva, the UK’s largest insurance provider, London, UK

Designation: Business Objects Developer/ MI Analyst

Created Universe user objects including Dimensions, Details and Measures. Resolved the loops using aliases and contexts. Check the integrity of the Universes.

Installed and configured SAP Business Objects XI 3.1 Enterprise Suite on Windows 2003 servers on SQL Server 2008, complete backend server administration

Extensively worked on Web Intelligence used advanced reporting functionalities such as Master Detail, Cross-Tab, Drill, Filters, Ranking, Graphs, Breaks, Alerts, filters, Prompts, Variables, Formulas, calculation Contexts in building reports, multi-tab report and Scheduling of the reports etc.

Developed reports in Webi from designing, development to production and scheduling reports through CMC or Info view on Daily, Weekly, Monthly scheduled reports.

Experience in Installation, Migration and Administration of Business Objects

Build Web intelligent report with daily scheduling in .csv format and place the .csv file on external remote server using .bat (batch file)

Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

Developed complex Reports using Webi like Cross Tab, Slice and Dice, Drilled, Functions, Master Detail and Breaks

Responsible for creating universe and reports for policies, quotes and claims

Created Multi tab reports in Webi for multiple requirements and applied different Webi functionality summary, filtering and specific prompt

Developed report using Desktop Intelligence (Deski) Free-hand SQL report and Ad Hoc report developed in Webi using Excel data

July 7th 2011- March 09th 2012

Company: Intelligent Positioning, London, UK

Designation: Business Objects Developer (Contract)

Involved in gathering the user requirement, analysing business requirements, gathering reporting requirements and prepare specifications document. This involved interviewing the business users and understanding the current reporting system.

Created the SAP BO Universe and Reports using Deski, Webi

Extensively used Business Objects reporting functionalities such as Master Detail, Slice and Dice, Drilled, Filters, Ranking, Sections, Graphs and Breaks

Responsible for creating Dashboards using Webi (Web Intelligence)

Involved in formatting reports, generation of charts as per user requirements.

Generated various reports on Daily, Weekly, Monthly and Yearly basis.

Created publications in Business Objects 3.1 to distribute mass user’s users Inbox (Microsoft Outlook) with data in the body.

Successfully deployed all the reports and deployed on production environment.

Developed and managed MS Access database and used generate reports using macros

Developed reports in reports SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports

Developed dashboard reports using Reporting Services(SSRS), Report Model and ad-hoc reporting using Report Builder

June 4th, 2007- June 2011

Company: Sysven Technologies, Hyderabad

Designation: Business Objects Developer

Responsible for Creating Universes and Reports in SAP Business Objects

Involved in gathering user requirement, report requirements, requirement specification document. This process involved interviewing business users and understanding the current business reporting system.

As a part of Universe development process created classes, user objects, checking cardinalities, defined hierarchies. Checking the integrity of the universes and export the universe to repository.

Business Objects Administration, Managed users, groups and rights, set up access, built reports and delivered

Used contexts, aliases for resolving loops of the Universes

Created ad hoc reports, master-detail, drill down, cross tab reports using web intelligence and desktop intelligence

Involved in various Oracle App project bids and managed bid response consistency by coordinating inputs from multiple departments and resources like project manager,leads,developers,analysing and negotiating man hours for project.Led bid response team meetings and timelines, ensuring completed on schedule

Responsible for Central Management Console (CMC) to schedule reports, configure user and group security, and folders

Implemented java SDK’s to improve the performance.

Implemented security features like row level, object level and report level to make the data security is secure

Developed complex universes by using features like aggregate aware, conditions and hierarchies to perform linking of universes by kernel method to optimize the universe development and performance improvement.

Defined hierarchies in Universe to provide the users with drill down reports in Web Intelligence

Created the reports using Universes as a main data provider and using the Powerful business objects functionality’s like @ functions, user response and formulas.

Proficient in drafting proposals and preparing detailed bids for multiple projects

Use the slice and dice feature, set variables, and set alerts and group values in a report.

Created Charts and formatted them for data analysis in Drill Down/up mode.

Resolved loops by removing unnecessary joins, creating aliases and contexts and check integrity of universe

Created derived tables in the universe to meet user requirements.

Developed reports based on Charts and Cross-Tab using Web Intelligence

Completed migration and Fixed issues during migration and post migration of Business Objects 6.5 to BO XIR2

Developed Xcelsius dashboard in both Xcelsius 4.5 and 2008.

Involved in installation and configuration process of all products of Business Objects software apart from server configuration

Involved in testing reports, analysing its performance, moving into production and training to the end-users.

Updated the static models with live data connecting via the Web Service connectors like QAAWS.

Responsible for scheduling reports through Broad Cast Agent

Used Business Objects VBA/Macros to generate multiple pdfs from Business Objects Document

Apr 14th, 2005- May 2007

Company: Netix Informatics, Hyderabad

Designation: Oracle Apps Technical Consultant (ERP)

Environment: Oracle E-Business Suite R12 /11i, Oracle Applications 11i (Oracle Apps), TOAD, UNIX, FTP, Oracle Forms 10g, Reports 10g, Oracle

Lead the upgrade process of Oracle Forms and Reports 6i to Forms 10g and designed and developed Web-Enabled Oracle Forms 10g & Reports 10g

Customized Oracle Purchasing forms to meet the client requirement by using the CUSTOM.pll.

Created value sets for report parameters and registered in applications.

Developed inventory policies and established accountability for tactical and strategic results through effective reporting, monitoring and cross-functional engagement

Handling the Issues (Tickets) & Analysing the root cause of the problem and giving fixes

Development of Technical Design Document (MD 70) and Migration Document (MD 120)

Developed Pending Purchase Orders Report and Vendor Wise Invoice with payments Report.

Developed Suppliers Report whose Payments exceeds ‘X’ Currency during the financial year

Developed Oracle Forms, Oracle Reports, SQL*Plus and PL/SQL

Developed Custom Trial Balance with Currency Balance Report in PL/SQL.

Worked on GL Daily Rates Interface and AP Invoice Open Interface to upload data from legacy systems.

Developed Invoice Interface in Account Receivables.

Developed Profile Interface in General Ledger.

Developed Outbound Interface for Invoice Receipts Status in Account Receivables.

Developed Outbound interface for Audit query in GL & AP in SQL*Plus.

Responsible for Bid Proposals on ERP Oracle based projects and quoting project estimation and man-day’s and involved in project bidding on project pricing, resources and delivery

Being part of the offshore development team, responsible for the technical components.

Extracted data from Oracle base tables and sending a flat file using UTL_FILE package.

Worked on macros for bid proposals projects like estimation, man-day’s and involved in project bidding on project pricing, resources using Excel/VBA.

Personalized Oracle Standard Forms according to client requirement using Personalization Form.

Created New DFF and attached to the Custom Form which is already developed using Custom Tables.

Oct 10th, 2000 - January 11 Th 2005

Company: Novasoft Information Technology (Europe) Ltd, London, UK

Designation: Software Consultant

I have given Interview on BBC World Service Radio, London, UK i.e. 7th February 2003 at 10:45, live discussing on how to get companies onto top of the search listings(organic) on Search Engines like (Google, Yahoo, MSN), how to get popularly ranked and improve their presence on search engines and German BMW site Google 'death penalty'.

I have worked as project leader to develop one of leading ICT online magazine with almost 8 regions worldwide with more than 100,000 articles are made SEO friendly and till day it stands on top leading search engines

Build ECDL E-commerce shopping cart of huge collection of about 1400 courses which I was responsible for planning, designing database, programming, PPC online campaigns, interactive discussion forums, weekly newsletter for registered users using third party tools

Involved in developing in-house payroll system using ASP, SQL Server 7.0 database

Generated reports for internal users using Excel, Access, VBA on day to day basis

Created, developed and designed complete Job web site using ASP, SQL Server 6.5 which includes database designing, coding and including online Job Posting, Resume Posting, Job search, advanced search etc.

Worked on various internal and web applications projects on a wide range of technologies MS Visual Basic, ASP Magic, HTML, XHTML, VBScript, JavaScript and CSS, Visual InterDev, Dream weaver MX, MS Visual Studio, Microsoft IIS, Cold fusion, Oracle, SQL Server etc. Worked on more than 16 websites from large/medium scale websites

Remote access of databases and uploading data from .CSV file format to SQL Server database on Canadian hosting server database

Worked in SEO Optimisation with W3C standards compliant and search engine optimisation (SEO) strategy consistently produces successful generic results on search engines like Google, Yahoo, MSN

Worked as a SEO for Dixon’s, Curries, The Link, eOffice websites and other websites. Worked closely with marketing department, developed an Internet promotion strategy for the Internet marketing and performed search engine optimisation to ensure the site on top of the listings on major search engines

Worked closely with the marketing department, developed an Internet promotion strategy and performed search engine optimisation (SEO) to ensure the website performing high on major search engines.

Developed various reports on Crystal Reports using SQL Server 7.0 database.

QUALIFICATIONS:

April 1994/April 1995 Mumtaz College, Hyderabad, INDIA, Graduation (B.com)

April 1997/ April 1998 Computer Diploma (PGDCA) in Frobel's Computer Center, Hyderabad, INDIA

INTERESTS:

Reading, Travelling, Music, Meditation, Tennis, Fitness, Swimming

REFERENCES:

References are available upon request.



Contact this candidate