We provide IT Staff Augmentation Services!

Business Objects/tableau Developer Resume

Livonia, MI

SUMMARY:

  • 9+ years of experience in IT Industry, with expertise in developing Business Intelligence and Data Warehouse applications.
  • Involved Develop, maintain, and enhance Informatica Cloud(ICS) Mappings, Task Flows, and processes (Data Integration)
  • Business Intelligence Consultant with a skill set of Informatica Cloud, Business Objects 4.2/4.1/4.0/3.1/3.0/ XIR2 and Crystal Reports 2011/2008, Crystal Dashboard Design (Xcelsius)4.0/2008.
  • Expertise working with Infomatica Cloud, SAP BI 4.x (IDT, Universe Designer, LCM, UMT, BI Launch Pad, WEBI, BI Workspaces).
  • Expertise using BOBJ 3.1 (Designer, DeskI, WebI, Rich Client, InfoView, CMC, Import Wizard, QaaWS, Publishing Wizard, Report Conversion Tool, Live Office, BI Services).
  • Good knowledge in overall Informatica cloud, BI/BO 4.0/XIR3 application architecture and able to Design, Deploy, Support the application.
  • Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.
  • Created simple and complex reports involving Filters, Contexts, Hierarchies, Variables, list of values (LOVS), local variables, Alerter, Ranking and multiple data providers.
  • Involved in Universe designing, developing and generating complex, Ad - Hoc, dashboard Reports, Business views along with User Acceptance Test and data accuracy test.
  • Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, and functionalities like Combined Queries.
  • Create and maintain SQL queries required to support BO reporting needs.
  • Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
  • Proficient knowledge on BO XI Architecture and new features.
  • In-depth knowledge in creation ofDashboards using Crystal Xcelsius/Dashboard Design.
  • Expertise in retrieving data using Business Objects Universes, personal data files, and free hand SQL methods.
  • Proficient in using SQL, PL/SQL, T-SQL to study data in different systems and to validate reports.
  • Experience working with BW 7.3 backend db system.
  • Created Olap universes and Webi reports using BICS connection for BW.
  • Created dashboard using BW as a data source querying BW using BEx.
  • Experience using Query designer in BW 7.3.
  • Good understanding of BW Info Cube.
  • Worked with SAP HANA, created attribute view, analytic view, calculation view, store procedure, push calculation towards HANA to get maximum performance.
  • Migrated Universe, reports, dashboard, user, groups etc from dev to qa, qa to prod using import wizard using best practices.
  • Good knowledge and experience in using Oracle 9i/10g/11g, MS SQL Server 2005/2008.
  • Process oriented thinking and problem solving approach.
  • Ability to work under pressure and complete work on schedule. Having problem solving skills, quick and independent learning skills.
  • Sound knowledge of waterfall, Agile methodologies.
  • Being a key project player, observed a full Life Cycle of a project, which included Requirement Analysis, Planning, Designing, Development, Test and Roll-Out / Go Live.
  • Experienced in Tableau Desktop, creating highly interactive Data visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.
  • Hands on experience using Tableau features to design, develop and support Tableau visualizations, analytical dashboards and highly interactive dashboards

TECHNICAL SKILLS:

Operating System: XP, 2003, Win7,win10

RDBMS: Oracle 11g/10g/9i, MS SQL Server 2016/2008/2005, Teradata,DB2

Web Technologies: SQL, PL/SQL

BI Tools: Informatica CloudSAP BI/BOXIR2/XIR3.0/XIR 3.1/4.0/4.1/4.2 Crystal Reports 2011/2008Dashboard Design/Xcelsius4.0/2008, SAP HANA

PROFESSIONAL EXPERIENCE:

Confidential, Livonia, MI

Business Objects/Tableau Developer

Responsibilities:

  • Defined, designed, and implemented Business Intelligence (BI) technologies and services to enable the analysis of data to support strategic initiatives and ongoing business requirements.
  • Develops business intelligence solutions using Business Objects and Tableau technologies.
  • Assists in the development of an enterprise analytical and self-service/ ad-hoc reporting environment.
  • Assists the BI Specialist in leading the business intelligence solution development life-cycle, development of BI standards and templates
  • Possess a deep understanding of customers and how they are using data to drive their business and achieve their goals.
  • Served as a mentor to entry BI developers in assisting to create a sustainable analytics ecosystem.
  • Working with business users to develop data visualizations, dashboards and reports using Tableau
  • Hands on experience using Tableau features to design, develop and support Tableau visualizations, analytical dashboards and highly interactive dashboards.
  • Design and implement proof of concept solutions and create advanced BI visualization.
  • Experienced in Tableau Desktop, creating highly interactive Data visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.

Environment: Win10, Oracle 11g, Teradata, SQL Server 2016, BI 4.2, Tableau 2018.2, 2018.3

Confidential, Dearborn Heights, MI

Business Objects Developer/Tableau Developer

Responsibilities:

  • Developed requirements, perform data collection, cleansing, transformation, and loading to populate facts and dimensions for data warehouse
  • Involved Develop, maintain, and enhance Informatica Cloud Mappings, Task Flows, and processes (Data Integration)
  • Perform data mappings and design out multiple integrations, transformation like Hierarchy Parser, Expression, Router, Sorter, aggregator, lookup, Filter, SQl and Joiner
  • Run Mapping Configuration Task (MCT) to validate the changes in the mapping.
  • Use XML file as a Source and use it in Informatica Cloud by uploading through WINSCP tool.
  • Performed the unit testing /Data Validation from Source file(XML) to the target database (SQL Server)
  • Analyze and Design Business Objects components based on the data sources, data definitions, data relationships and business rules.
  • Write Business Objects Code and Test Business Objects Components against data warehouses and operational data stores.
  • Created Universe using Universe Designer (.unv), Working with star, snow flake, relation model.
  • Created Several Reports in SAP Web Intelligence Rich Client version 4.0.
  • Provided technical expertise on Design, Performance Tuning, Data modeling, Data Warehousing, and Data integration for applications.
  • Partner with Business Intelligence and Business operational teams to implement new requirements. Ability to lead and guide a team.
  • Troubleshoot and resolve application / system issues, Conduct peer reviews to ensure standards.
  • Developed and maintained Audit report, Demographic reports and other analytical reports.
  • Tested several reports in QA.
  • Create Documentation such as Report functional Specs, Report Design Specs, Universe Design Specs, Universe functional Specs
  • Migrated reports, Universe to Accurev in the form of LCM biar file by using Promotion Management and applied the code in the QA.
  • Writing Complex SQL to Validate Data.
  • Working within the business and other team members to build requirements and design functional specifications for the data warehouse and front-end dashboards and reports. Maintain a clear understanding of the potential impacts of proposed solutions on other areas of the system and/or project.
  • Developed and execute unit testing for all developed objects including testing documentation and validation.
  • Provide ongoing support of the existing BO Reporting, Resolves coding, configuration, and data issues in a timely fashion.
  • Develops and maintains accurate documentation and meta-data for the data warehouse.
  • Create Meta Data Universe for Business users to track all the metadata elements (Universe Objects, Reports Objects, Reports to Objects mapping, Folders, Universe to Objects mapping etc).
  • Working in Agile Methodologies to track and manage the User Stories and tasks and make it deliverable within assigned Time period.
  • Created Reports Functional Test Cases and performed reports functional testing from Application Lifecycle Management (ALM) tool.
  • Assigned, updates and track Defects status on Application Lifecycle Management (ALM) tool.
  • Validate and perform automation testing from Unified Functional Testing (UFT) tool.
  • Implemented object/data level security within Business Objects.
  • Used the Translation Management Tool to translate report metadata (.wid files) created with Interactive Analysis or Web Intelligence and universe metadata
  • Performed User Acceptance Testing responsible tracking documentation & understand requirements, creating test cases based on requirements, requesting test data to establish baseline, participating on conference calls with Project Team to read through test cases and get approved and follow through to production
  • Collaborates with QA team members in the execution of Quality Assurance (QA) and User Acceptance Testing (UAT) for reports functionality involving business rules decision services
  • Develop meaningful, efficient dashboards and visualizations using leading platforms, primarily Tableau
  • Translate complex Tableau visualization needs into technical specifications, including calculations, custom groups, parameters, filtering criteria, aggregations, etc.
  • Working with business users to develop data visualizations, dashboards and reports using Tableau
  • Hands on experience using Tableau features to design, develop and support Tableau visualizations, analytical dashboards and highly interactive dashboards

Environment: Win10, Win7, Oracle 11g, Teradata, SQL Server 2016, BO XIR 3.1, 4.0, 4.1,4.2, Informatica cloud

Confidential, Kansas City, MO

Business Objects Developer & Administrator

Responsibilities:

  • Completed Installation of Business Objects version 4.1 (SP4).
  • Migrated all Contents (users, groups, folders, security rights, access levels, universes, universe connections, ODBC connections, categories, instances, application etc) from 3.1 to 4.1 by using upgrade Management Tool (UMT) through BIAR file.
  • Secured sensitive data by applying a security feature of object level security in the Universe and the report level security in the CMC.
  • Scheduled recurring daily, weekly and monthly reports (WebI) in Info View and used Calendar based scheduling for the reports custom dates.
  • Created Universe using IDT (.unx) and Universe Designer(.unv), Working with star, snow flake, relation model.
  • Provided SAP Business Objects system administration solutions as Scheduling of reports, Publication of reports, Assign folder level securities, Assign user group level securities, Assign access levels
  • Web Intelligence report writing support for several application systems including Cerner, GE, McKesson, and several homegrown databases, with a commitment to hospital employees/system analyst satisfaction.
  • Provided technical support to IS analysts and/or associates and leads projects and/or technology initiatives through all phases of systems development including: planning, development, implementation and operation for complex computer projects.

Environment: Win7, Oracle 10g/11g, Sql Server 2005/2008,BI 4.1,BO XIR 3.1, Crystal Dashboard Design(Xcelsius)4.1/2008.

Confidential, Hartford, CT

Business Objects Developer

Responsibilities:

  • Gathered requirement in short term project, convert into technical requirement and start developing webi reports for end users.
  • Created Web Intelligence reports in 3.1 for end users using combined query, merge dimension, function variable, drill throw reports, alerter, ranking etc.
  • Providing daily, weekly, monthly, quarterly, yearly reports for end client.
  • Validated data from Toad to Webisql and make sure data is carrect.
  • Created documentation and hand over project to sustaining team.
  • Hyper care project for postproduction support.
  • Modified webi reports to add more objects and formatted according to requirement on page mode.

Environment: Win7, Oracle 11g,BO XIR 3.1

Confidential

Business Objects & Dashboard Developer

Responsibilities:

  • Created Universe using IDT (.unx) and Universe Designer(.unv), Working with star, snow flake, relation model.
  • Expertise in upgrading from 3.1 to 4.0 using UMT and applying new security on Admin level.
  • Created Dashboards and Scorecards using Dashboard desing 4.0 with QaaWS, Live Office, BI Services, XML as a data sources.
  • Created WEBI reports involving complex queries, sub queries, Unions and Intersection using BI 4.0 and BO 3.1.
  • Worked with SAP HANA, created attribute view, analytic view, calculation view, store procedure, push calculation towards HANA to get maximum performance.
  • Created Universes on OLAP SAP HANA model using star schema approach.
  • Created Deski reports using free hand sql, flat files, store procedures, universe as a data source.
  • Created several Universes (joining the tables, creating prompts and queries and applied Contexts and Aliases to resolve loops) for finance, sales, promotions, manufacturing, SCM, HR, LMS Users.
  • Involved in ETL Process using BODS/Informatica.
  • Addressed chasm trap and Fan Trap using Multi Parse SQL.
  • Imported data from Excel to compare Actual Vs Budget.
  • Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
  • Used Toad to verify data pulled by the report is correct compared to the database data and also to verify the joins used in designing the universe are correct.
  • Secured sensitive data by applying a security feature of object level security in the Universe and the report level security in the CMC.
  • Heavily interacted with the Client users to gather the requirements of the KPI WebI report.
  • Created various drillable WebI reports.
  • Created ad-hoc reports with multi prompts to retrieve required data for the user and to minimize unnecessary load on the server.
  • Created Reports with heavy conditional formatting and functions to meet user requirement.
  • Customized the reports with custom functions and loops to leverage the user reporting needs.
  • Scheduled recurring daily, weekly and monthly reports (WebI, DeskI) in Info View and used Calendar based scheduling for the reports custom dates.
  • Created various group based publications and distributed reports to the users.
  • Designed a HighPerformance universe by joining several dimensions to the fact table like Accounts and Returns.
  • Migrated Universe, reports, dashboard, user, groups etc from dev to qa, qa to prod using import wizard using best practices.
  • Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report.
  • Interacted with the users to analyze the changes for improvement they need in existing reports and develop the reports to satisfy their needs and requirements.
  • Created several dashboards using Crystal Xcelsius, opendoc command to locate report from dashboards as drill down detail.
  • Used Live Office, BI Services and QAAWS (Query ads a web service) to get the data from the database into the dashboards.
  • Designed and Developed Xcelsius dashboards / analytics and exported to several formats
  • In Xcelsius used single value, selector, mapped, chart, background, collaboration and text components, dynamic visibilities.
  • Created Olap connection using BICS in IDT.
  • Created Webi reports using BEx queries as a data source from BW db.
  • Acquired an excellent understanding and work experience of EXCEL functions in Xcelsius.
  • Created Olap universes and Webi reports using BICS connection for BW.
  • Created dashboard using BW as a data source querying BW using BEx.
  • Experience using Query designer in BW 7.3.
  • Good understanding of BW Info Cube.
  • Prepared user documentation for hands on training for end user community.

Environment: Win7, Oracle 10g/11g, BI 4.0,BO XIR 3.1, Crystal Dashboard Design (Xcelsius) 4.0/ 2008.

Confidential, New York, NY

Business Objects & Dashboard Developer

Responsibilities:

  • Created several universes using Designer using star, snow flake, relational model.
  • Provided cascading prompts Custom Hierarchies in the reports as well as the Universe to create more interactive reports for the users.
  • Created Webi/Deski/Crystal Report reports for sales, HR, Finance, SCM Users.
  • Wrote a full functional specification document for the security implemented in Business Objects.
  • Resolved Loops using Aliases and Context, Addressed chasm trap and Fan Trap using Multi Parse SQL.
  • Created Custom Hierarchies to provide drill down capabilities in Webi for the ad-hoc power/general users.
  • Developed several Complex Reports, various features used include Multiple Groupings, Drilldown, Parameter fields, Formulas and Conditional formatting using Crystal Reports.
  • Used prompts, alerts, drill down analysis as per the end user requirements.
  • Created detail and summary reports, used to fold/unfold sections corresponding to breaks in current blocks.
  • Created graphical representation of WebI reports such as bar charts, pie charts etc.
  • Migrated reports, universes, dashboards, connection, users, groups from DEV to QA and QA to Prod using import Wizards.
  • Scheduled reports for bursting/publication on daily, weekly, monthly, yearly basis.
  • Improved query performance by implementing aggregate awareness.
  • Created interactive Scorecards and Dashboards using summary level data and provided users drill down reports and used QaaWS as a datasource.
  • Created several Dashboards using alerts, highlight important metrics/KPI for VPs level.
  • Involved in user training to the end users on working with Web Intelligence tool through infoView and WebI Rich Client.
  • Involved in SDLC from the beginning to finish all the way from devto prod, handed over complete project after documentation to sustaining team for support.
  • Involved in production supports, troubleshoot, CR, SR with the users in production.

Environment: XP/Win7, Oracle 9i/10g, Business Objects 3.1, Xcelsius 2008, Crystal Reports 2008

Hire Now