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.