Business Intelligence Objects

Kiran

Ph: 315-***-****

ad5ts9@r.postjobfree.com

Professional Summary

Over 14 years of experience in IT with solid experience designing and creating data visualizations using Tableau.

Worked on (Tableau 10.5/10.4/10.3/10.2/10.1/10.0/9.3/9.2/9.1/8.0/7.0), Tableau server, Tableau online, Tableau public, Tableau reader.

Experienced in Analysis, Development, Design and Maintenance of Business Intelligence applications, creating dashboards, designing Universes, Full Client/Web reports etc.

Used Tableau Cmd for various Dashboard migrations from one environment to another.

Used efficient load balancing techniques to manage the load on the server for concurrent user logins.

Created automated scripts for tableau workbook refresh when not using live connections

Experience with Tableau maintenance tools and Tableau server monitor to start/stop services and maintain statuses.

Worked as a Tableau Developer. Created visualizations and dashboards as per the user requirements.

Worked in data preparation, data transformation and reports.

Good understanding of Business Intelligence concepts. Worked with Dimensions and Fact tables.

Extensive experience and expertise in creating and analyzing data using MS Excel pivot tables and charts.

Strong Understanding on the phases of Software Development Life Cycle (SDLC) and models including Waterfall and Agile.

Expertise in designing Test plans, defining Test cases, performing Verification and Validation, maintaining test scripts and analyzing bugs.

Proven expertise with Quality Center (QC) /ALM(Application Life Cycle Management.

Strong Knowledge of Functional Testing, GUI Testing, System Testing, Regression Testing, and User Acceptance Testing.

Expertise in HPALM to manage complete testing effort, defect Tracking and Bug Reporting.

Strong insight to determine priorities, schedule work, and meet critical deadlines within budget guidelines, along with excellent communication and documentation skills

Expertise in Linux, UNIX and Windows environment. Good basic knowledge of UNIX Shell Scripting

Working experience with Business Objects Solutions manager, configuring it and monitoring the Business Objects resources.

Experience with planning, designing the architecture, troubleshooting, tuning, and maintaining Business Intelligence /data warehouse systems

Experience with installation / creating, deployment / migration / upgrading of Business Objects new releases and patches in distributed, clustered and failover environment

Have good knowledge of Teradata architecture and expert skills in using Teradata utilities BTEQ, Fastexport, Fastload, Multiload and good exposure to T pump, TPT/TPT Stream on UNIX/Windows environments and running the batch process for Teradata.

Experience in Teradata SQL Performance tuning for optimal performance, collect statistics, join strategies, join

types and Explain/Optimizer plan

Migrated Universes, Reports and Users from XI R3 to BI 4.0 using Upgrade Management Tool in BI 4.0, Coordinated and executed Business Objects migration from XIR2 to XI 3.1 SP3 Using Import Wizard and BIAR files applying Business Objects Best Practices

Extensive experience in RDBMS like Oracle 11g/10g/9i/8.x/7.x, SQL Server 2000/8.0/7.0

Worked on Windows 7/XP/2000/98/NT/95 and UNIX/Linux, windows-based GUI tools for databases like TOAD, SQL Navigator, Rapid SQL and Enterprise Manager

Worked across various projects like Children welfare, Pharmaceutical, Financial, Mortgage and Retail Industries and utilized best practices based on their BI environments.

Excellent technical, time management, communication, interpersonal and presentation skills

Technical Skills

Decision Support

Solution tools

Tableau, Business Objects XIR3/XIR2/XIR1/,BI 4.2/4.0, Xcelcius 2008, Dashboard Manager, Designer, Supervisor, Desktop Intelligence, Web-Intelligence, Info View, Broadcast Agent, CMC Performance Management, Report Conversion tool and Import Wizard, Life Cycle Management.

ETL Tools

Data Integrator 11.7, Informatica Power Center 9.0

(Designer, Workflow Manager, Workflow Monitor)

RDBMS / Database

Oracle 11G/10G/9i/8i/7.x,DB2 v8.1, MS SQL Server 8.0, MS Access

Data Modeling Tools

Erwin 4.1, Microsoft Visio

Development Tools

Toad, SQL Navigator, Rapid SQL, Enterprise Manager,

MS Excel, MS Visual Studio, Microsoft Project Professional

Languages/ Scripting

SQL, PL/SQL, C++

Operating Systems

Windows XP/2000/98/95/NT, MS-DOS, Linux, UNIX Sun Solaris

Others

Credit Loss Management (CLM), Concurrent Versioning System (CVS), MVS (Multiple Virtual Storage), JCL (Job Control Language)

Work Experience

Amtrak Mar’18 – Till Date

Washington, DC

Sr. Tableau developer

Responsibilities:

Worked as a dashboard developer for the Pharmaceutical Company. Project involved creating multiple dashboards, conversion from IBM Cognos reports to Tableau dashboards and enhancements.

Worked on the dashboards to track the Number of Calls made to prescriber, financial dashboards, resource allocation on various products.

Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary reports and Dashboards using KPI's.

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

Design and development of various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Working in the MapR development environment where all the reports and views are created and published.

Worked on analyzing the requirements and the sources data. Worked on a mapping document to map the required columns from the data sources.

Worked with excel and csv files. Created extract files and live data. Worked on data preparation. Published the data source to the server for the power user.

Created Maps to provide the count of providers in different geographic locations. Created drill down capability using the Action filters.

Deployed dashboards on the server.

Created multiple dashboards, such as financial dashboard, Travel intensity and so on. The dashboards tracked the Actuals and Budgeted amounts for the enterprise. It also tracked the frequent travelers by month and region. Created multiple worksheets and dashboards.

Extracted data from xls, CSV and database tables. Used data as live and extract. Created data source level filters. Performed data transformation in the data layer. Created hierarchy, groups and calculations.

Created different visualizations like trend chart, Maps, bar chart etc. Created data stories for ease of navigation.

Created user filters and action filters. Created parameters and used them in the calculations.

Worked with excel and database queries to test the dashboard.

Also involved in helping users in creating and executing test cases. Supported the UAT effort. Provided guidance, reviews, updates and defect status.

Worked in data analysis. Used excel and database tables.

Deployed Dashboards and sheets on the Tableau server. Provided security to different dashboards.

Environment: Tableau desktop 9/10.1, Tableau server, Tableau Reader, TDE, MS excel

State of Michigan

Department of Human Services July 2012 to February 2018

Tableau developer / Business Intelligence consultant

Lansing, MI

Responsibilities:

As part of the Business Intelligence (BI) team involved in requirement gathering discussions with the business community. Analyzed data to be presented in the dashboards. Helped users in data preparation.

Worked on report and dashboard mock-ups. Provided demo to the users on the various functionalities of Tableau.

Coordinated with the Business Analyst, and Project Manager to get the requirements and deliverables.

Creating Relationships, actions, data blending, filters, parameters, hierarchies, Level-of-Detail (LOD), calculated fields, sorting, groupings, live and extract connections, and in-memory in both tableau and excel.

Building, publishing customized interactive reports and dashboards.

Handling the new developments as well as enhancements for the existing dashboards in Tableau.

Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary reports and Dashboards using KPI's.

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

Design and development of various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Performed day to day admin tasks like monitoring DB Services, creation of user groups and access requests, monitoring of user activities/ sessions, universe connection and availability checks.

Conducted Study to Build Universe's Classes and Objects involving everyday terms that supports Users. Object properties defining Measure, Dimension and Details were created.

Implemented Universes by detecting Cardinalities, resolving loops, Chasm Traps and Fan Traps using Contexts and Aliases etc, and also Developed Hierarchies to support users with the option to drill down on reports. Also implemented User Security.

Designed complex reports based on discussions with user groups and created various objects using built-in functions (like prompt, select, where, and aggregate), complex SQL queries and joins

Highly Interactive Dashboard completely based on dynamic user input and varying amount of information to analyze without limitations being provided to the user.

Involved in creation of Reports, formatting reports, generation of charts, bars etc as per user requirements using Webi, Xcelsius 2008.

Various other forms of dashboard development also performed including Data from SAP BW through Bex

Queries, Data from Universe using QAAWS, Data from Webi reports, Crystal Reports using Live Office etc.

Dashboards Using Advanced Multiple Drills Down, Dynamic Visibility, and Alert Features were designed to support Complex Requirement Scenario.

Designed dashboard using best practices and advanced filtering techniques to dynamically filter and serve as the source for the dashboard.

Worked on certain issues and dealt with Info View and CMC.

Environment: SAP Business Objects XI 3.1/3.2, Crystal Reports 2008, Data Integrator & Services, Web Intelligence, T-SQL, Oracle PL/SQL, Info View, CMC., Tableau desktop 9.x, Tableau server, Tableau Reader, TDE, SQL Server 2005 management studio, MS excel

Accident Fund Insurance Company of America Jan’11 – June 2012

Lansing, MI

Sr. SAP Business Objects Consultant/Lead

Accident Fund Insurance Company of America is a workers' compensation insurance company. The company is an operating unit of Accident Fund Holdings, the 10th largest writer of workers compensation insurance in the United States according to A.M. This project involved migrating existing BI applications from BOXI R2 to BOXI R3.1 and administering and development of BO.

Responsibilities:

Designed and implemented Business Objects architecture, including hardware and software requirements, CMS information, security, and migration from XIR2 to XIR3.1

Setup and initial configuration of XI R3 on Windows platform using Oracle11g as the repository database.

Used the import wizard to import existing user accounts, groups, categories, Webi documents, universes, connections and universe restrictions to BOXI R3 environment.

Involved in Conversion of Deski reports to Webi reports using Report Conversion Tool.

Performed Administrative tasks like Setting up user profiles, assigning rights and privileges for groups, setting up categories using CMC, and maintain Bo servers

Built of a new security model with the BOE environment to support the Accident Fund real time and historical dashboards.

Modified existing client analyst universes and created new universes as per the business requirements using @Aggregate Awareness, @prompt and @BOUSER functions

Developed real time and historical dashboards within Xcelsius 2008 utilizing Query As A Web Service and Live Office.

Scheduling of the report on successful event and save on specific servers using FTP/File System Configuration in Business Objects XI 3.1.

Promotion of Universes, Reports, Users, Groups, User Rights and Privileges from different environments Dev, QA, UAT and Production.

Created Standard WebI reports with client customizations and formatting to serve as templates for the canned and ad hoc reporting.

Documented all the changes made to the Universes and Reports for future references.

Environment: Business Objects XI 3.1/R2,SQL, Oracle 11g, Sybase, Web Intelligence, Crystal Reports, Import Wizard, Xcelcius 2008, QAaWS, Live Office, Web services, Apache Tomcat, SQL Developer, Windows 2008, Weblogic 5.1/6.1, Shell scripting,

Fannie Mae, Nov’08 – Dec’10

Herndon, VA

Sr. SAP Business Objects Administrator/Developer

Fannie Mae (Federal National Mortgage Association), works to ensure that mortgage money, is available for people in communities all across America. This project involved administering and developing reports for different business groups in Fannie Mae’s Multifamily/HCD portfolio Data Warehouse.

Responsibilities:

Responsible for Administration, development and troubleshooting of different agency reports through Business Objects XI R2/3.1 and development of dashboards through Crystal Xcelcius.

Migrated Business Objects XI R2 content in to Business Objects XI R3 environment using the Import Wizard.

Managed all the BO Servers and Clusters through CCM and CMC.

Installed & Configured BO Enterprise XI R2 SP2 on Windows 2003 server.

Resolved slow down issues and improved the performance of production servers.

Responsible for the administration of transactional and analytical data constructs/structures.

Integrated Business Objects reports into corporate portal using java SDK.

Configured .war files on BOXI server to receive authentication.

Responsible for the design and development of Business Objects Crystal Reports & Business views, Universes and analytical data constructs/structures.

Created access Restrictions to secure data based on users’ access levels.

Prepared Business/Technical Requirements, Design Templates, Development Standards document and Detailed Design documents.

Used SAP BEX Query Designer to make modify queries: Restricted Key Figures, Calculated Key Figures

Created various Reports by pulling the OLAP data from Data Warehouse of SAP BI 7.0

Modified the BEX Query using Query Designer to suite the reporting requirements.

Designed and developed Universes and reports according to the user requirements.

Created hyperlink reports using open doc functionality.

Migration of Canned Reports/Universe/Personal Documents/Inbox.

Created Analytics and Dashboards using Performance Management tools to enable executives get a bird’s eye view of the business performance.

Accessing data from the database using SQL Developer (running on Oracle 10g) to cross check the data accuracy and creating reports on the same if needed by the business.

Implemented and conducted training session to train Power Users/Managers in BO functionality and to use the reports in Web Intelligence.

Documented all the changes made to the Universes and Reports for future references.

Environment: Business Objects XI 3.1/R2/6.5, Crystal Reports XI, SQL, Oracle 9i/10G, Sybase, Windows 2003 Server, Web Intelligence, Xcelcius, SAP BI 7.0, SAP BEX Query Designer, SAP BEX Report Designer, CVS, Apache Tomcat, SQL Developer, Sun Solaris (UNIX), Weblogic 5.1/6.1, Shell scripting, Clear Quest.

CGI, State of Florida

Tallahassee, FL Jan’07 - Nov’08

Sr. Business Objects Administrator/Developer

Working on Statewide Automated Child Welfare Information System (SACWIS) for the Florida Department of Children and Families (DCF) developing the Florida Safe Families Network (FSFN) BOE.

Responsibilities:

Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Created Publications based on Agency and District and distributed to the Users.

Created Events and Calendars for scheduling purpose using CMC.

Managed all the BO Servers and Clusters through CCM and CMC.

Migrated the CMS database from DB2 to oracle

Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.

Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.

Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.

Applied rights and privileges to users/groups, folders and categories, using CMC.

Created Cascading LOVs, Hierarchies and Filters.

Developed universe user documentation guide for the end users reference.

Deployed and scheduled reports through CMC.

Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.

Created Auditor reports and tracked user access of reports and Universes.

Worked with Crystal Report XIR2 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.

Experience in handling development team onside or offshore.

Provided training for end users for generating their own report including complicated WebI reports.

Environment: Business Objects XI r2, Crystal Report XIR2, CMC, Import Wizard, Conversion Tool, Web-Intelligence, Desktop-Intelligence, Designer, Info View, Data Integrator, Tomcat, DB2v8.1, Oracle 10g, SQL, Windows 2000/XP.

Fannie Mae, Mar’06 – Dec’06

Dallas, TX

Sr. Business Objects Developer

Fannie Mae (Federal National Mortgage Association) is a shareholder-owned company and a part of the US Housing Industry that works to ensure that mortgage money is available for people in communities all across America. The public mission and the defining goal of the company are to help more families achieve the American Dream of homeownership. This project was about developing various reports for different business groups for the NPDC (National Property Disposition Center) in Fannie Mae.

Responsibilities:

Involved in the Migration of the UAT and Production Environments from Business Objects 6.5 to Business Objects XI R2 for the Federal National Mortgage Association Fannie Mae.

Design of an architecture to support full-lifecycle development of universes and reports,

Setup and initial configuration of XI R2 on Windows 2003 using Oracle10g as the repository database.

Migration of content from the 6.5 system to XI R2 using the Import Wizard.

Conversion of desktop Intelligence documents to Web Intelligence documents using the Report Conversion Tool.

Integration of XI R2 with Windows Active Directory for authentication.

Mapping of the 6.5 security requirements to the XI R2 security model.

Provided assistance to users regarding reporting issues and help them to better understand the requirements.

Designed the report template and applied new templates to existing reports in various formats like cross tabs, master-detail, charts and breaks.

Built and modified different canned reports like workflow, exception and performance reports.

Generated various reports with complex queries, formulae, variables and different in-built functions and calculation with contexts.

Define detail variables and linked different objects from different data providers and to resolve incompatibility to display without dropping cases in a block.

Improved readability in report by adjusting format such as, sorts, ranking and alerters.

Generated reports with Drill options to facilitate drilling and filtering on different hierarchies present in the universe.

Tested new and modified reports with different test cases and verified data against GUI application CLM for DARTS and TRAX) before sending report for user acceptance.

Gathered requirements with business analyst and direct interactions with business-users to understand their need and documented it to be sent for sign off by business users.

Rectified errors and faults in existing reports by cross checking the result objects used and also optimized them for faster execution. Submitted Problem Requests (PR) for enhancement changes required for universe and tested the PR modification in production environments.

Checking versions of different requirements and reports with the versioning tool CVS.

Environment: Business Objects XI R2/6.5, Desktop Intelligence, Web Intelligence, COBOL,

Credit Loss Management (CLM for DARTS, TRAX), Concurrent Versioning System (CVS)

Oracle10G, Sybase, Win XP

Innova Tech Inc. Sep’05 – Feb’06

Arlington, VA

Business Objects Developer/ETL Developer

Project: US Patient & Trademark Office (USPTO)

Responsibilities:

Gathered information from business users.

As a Business Objects developer responsible for designing, developing and maintaining Repository in Oracle 9i database.

Migrated BO 6.5 to BOXIR2.

Created Business Objects groups, users and assigned privileges to their accounts

Created one or more document and universe domains in Repository and maintained throughout the assignment successfully.

Comprehensively Used Business objects Designer for Universe development- Involved creating Classes, different kind of objects, Cardinalities, Strategies.

Created derived tables to meet the reporting requirement.

Created user defined @prompts and complex conditions at Universe level for better performance.

Solved database loops, chasm, fan traps by using alias and context.

Used all types of methods in reporting technology to represent data on report like (filters, alerter, breaks, sorts, ranking, master/detail and Drill).

Recommended and implemented design changes to warehouse fact tables and indexes to improve query performance.

Generating Reports from different data providers using Business Objects.

Created Classes, Objects in universe for Oracle and using Business Objects 6.5 and exported to the repository.

Published Documents on the World Wide Web for access to authenticated users via Info View.

Categorized Documents based on the Departments & Users.

Creating Dashboard and Scorecards with Dashboard Manager.

Tuned the SQL using Explain Plan to increase performances of Reports.

Tested the Universes and Reports in different environments for the data representation and the performance issues.

Involved in training end users, business users and customers in creating, modifying and interpreting Bo reports and WebI reports.

Created indexes and analyzed tables for better performance.

Environment: Business Objects XIR2, 6.5, DB2, PL SQL, Web intelligence 6.5, BCA, Data Integrator, Teradata, UNIX Scripting, SQL Server, MVS, JCL,Windows NT, and Windows XP

Indus Networks Limited, Aug’04 – Aug’05

Hyderabad, India

Business Objects Developer/Analyst

Environment: Business Objects 5.1.6, Designer, Reporter, Web Intelligence 2.6, Broadcast

Agent, Crystal Reports 8.0, Informatica Power Center, Oracle 8.x, Erwin and Windows NT

Education

Bachelor of Engineering, India

Contact this candidate