We provide IT Staff Augmentation Services!

Sr. Business Objects Developer/ Tableau Consultant Resume

4.00/5 (Submit Your Rating)

Fairfield, OH

PROFESSIONAL SUMMARY

  • Six plus years of IT experience in Analysis, Design, Development and Testing of data warehousing applications.
  • Experience in all phases of project development life cycle in Data Warehousing - Analysis, Design, Development, Testing and Production Support.
  • Strong experience in Business Objects 4.1, 4.0, XI R3, and R2 (Designer, BI LaunchPad, and Desktop Intelligence)
  • Experienced in creating various kinds of dashboards, including wat-if scenarios and map-based dashboards using Crystal Xcelsius.
  • Experience in gathering business requirements and creating Universes and Reports to meet those requirements.
  • Experience in performing QA, testing and performance analysis on universes and reports.
  • Broad knowledge in resolving issues such as loops, chasm traps, fan traps, etc during BO Universe design and creation.
  • Extensive knowledge of Business Objects report functionality - Drill downs, Open Document, Merged Queries etc.
  • Created and maintained reports using Web Intelligence, Desktop Intelligence and Crystal Reports. Also Created ad-hoc reports as per requirement.
  • Experience in Oracle BI reporting tool.
  • Clear understanding in Business Intelligence and Data Warehousing concepts, wif hands on experience in both fields.
  • Experienced in ETL tool Informatica.
  • Strong experience and expertise in designing/ developing complex mappings from various transformation logic like Lookups, Router, Filter, Expression and more.
  • Extensive experience wif Data Extraction, Transformation and Loading from disparate sources like Oracle, SQL Server, MS Access, flat files, CSV files, etc into a common Data Model using Informatica.
  • Experienced in TOAD, PL/SQL, Teradata SQL Assistant stored procedures, functions.
  • Strong experience in databases such as Oracle 10g/ 9i, Teradata, SQL Server on UNIX, Windows 2000/NT/98 platform.
  • Excellent analytical and logical programming skills, good understanding at conceptual level.
  • Experience in developing interactive dashboards in using Tableau.
  • Ability to work well in groups as well as independently wif minimum supervision.
  • Ability to work well wif diverse groups and business users.
  • Ability to learn new technologies and tools quickly.
  • Excellent communication, presentation, verbal and writing skills.

TECHNICAL SKILLS

Technology: ETL, Data Integration, Business Intelligence

BI Tools: Business Objects 4.2,4.1,XIR3/R2, Crystal Reports, Tableau, Qlikview

ETL Tools: Informatica PowerCenter 7.x/6.x, SSIS 2012

Databases: Teradata, Oracle 10g/9i/ 8i, MS SQL Server

Programming Languages: PL/SQL, C++, C, UNIX Shell Scripting

Other Packages: MS Office - MS Word, Access, Excel, Powerpoint.

Operating Systems: Windows 2012, XP/NT, Unix

PROFESSIONAL EXPERIENCE

Confidential, Fairfield, OH

Sr. Business Objects Developer/ Tableau Consultant

Roles and Responsibilities:

  • Interacted wif Business Analysts and end users to develop standard, as well as ad-hoc reports according to functional specifications.
  • Interacted regularly wif end-users to generate reports using Business Objects functionality such as Queries, Slice and Dice, Cross Tab, Drill Down, Arithmetic functions and formulae, etc.
  • Participated in the complete development lifecycle: analysis, design, build and test reports.
  • Created several complex Web Intelligence reports to halp management to track and monitor inventory, commodity and price compliance.
  • Created reports linking several universes for different subject areas like Purchase Orders, Accounts Payable, Pharmacy and Inventory for seamless reporting.
  • Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report. Extensively used Calculations, Variables, User Objects in the creation of reports.
  • Extensive testing and migrating the reports or objects from development to Production system
  • Involvedin performance testingof all the reports, which halped in analyzing its performance before moving into production.
  • Created complex variables, breaks, sorts, filter and conditions for various reports.
  • Created complex reports involving master/detail and cross-tab and Combined queries and sub-queries
  • Coordinated wif DBA and Business objects designer group in solving various technical issues.
  • Generated various report templates for standardizing the reports throughout the organization.
  • Created new Projects and imported User Access groups wif the security model.
  • PublishedTableaudashboard onTableauServer and embedded them into portal.
  • Configured new features in the server platform using Tabadmin Commands and the workbooks provided byTableauSupport.
  • Tested reports and uploadedtableaudashboards on to server and provided production support fortableauusers.
  • Worked on editing data connections and changing data sources inTableau
  • Created interactive visualizations by adding quick filters.
  • Analyzed data using Filter Shelf, Conditional filters (by using formula), and Dynamic measure filters.
  • Created worksheets using parameters and used features like sorting, grouping, sets.

Environment:Oracle 12G, SQL Server, Business Objects 4.2, Web Intelligence, CMC, Tableau 9/10,Universe Designer

Confidential, Colmar, PA

Sr. Business Intelligence Analyst

Roles and Responsibilities:

  • Involved in the design and creation of BO Universes, classes, objects and measures to TEMPeffectively represent the LOB data.
  • Checked cardinalities, contexts, joins, etc for resolving loops discovered during integrity checks of the Universes.
  • Involved in developing KPI reports for power users.
  • Used Drill down, filters, conditions, formulae, and other BO functionality to generate reports for end users.
  • Designed mappings in Informatica for ETL process.
  • Wrote PL/SQL stored procedures & triggers for implementing business rules and transformations.
  • Worked on Informatica tool - Source Analyzer, Data Warehousing designer, Mapping Designer, Workflow Monitor, Workflow Manager and Repository Manager.
  • Worked extensively on different types of transformations like Source qualifier, Expression, Filter, Aggregator, Rank, Lookup, Stored procedure, Sequence generator.
  • Created and scheduled Worklets, configured email notifications. Set up Workflow to schedule the loads at required frequency using Power Center Workflow Manager, Generated completion messages and status reports using Workflow Manager.
  • Administrated Workflow Manager to run tasks & worklets.
  • Analyzed session log files incase the session fails in order to resolve errors in mapping or session configurations.
  • Wrote stored procedures, functions and triggers also tuned complex SQL queries for better performance.
  • Performed testing, knowledge transfer and mentored other team members.
  • Developed Tableau dashboards wif combination charts for clear understanding. Created Dashboards wif Quick filters, Parameters and sets to handle views more efficiently.
  • Leveraged expertise to deliver reporting solutions across process areas using Tableau.
  • Uploaded dashboards from Tableau Desktop to Tableau server for easier maintenance.
  • Worked wif Tableau command line tools tabcmd and tabadmin for managing scheduled tasks, administering users and groups, troubleshooting, performance tuning, and general systems maintenance.
  • Capability in designing exquisite visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms.
  • Administered user, user groups, and scheduled instances of data refresh activity to be consumed by Tableau reports.

Environment: Business Objects 4.2,4.1, MS Sql server, Tableau

Confidential, CO

Sr. Business Objects Developer

Roles and Responsibilities:

  • Collaborated wif Business Analysts and the developers to gather business and functional requirements.
  • Documented the requirements and designed the Business Objects Universes according to requirements.
  • Designed and Built Universes, wif desired classes, objects and measures to ensure proper report generation.
  • Employed Integrity Check to verify proper construction of Universes, resolving any loops, traps, etc.
  • Created customized reports, both tabular and pictorial, for end users.
  • Extensively used calculations, variables, breaks, sorting, drill down for generating TEMPeffective reports.
  • Also used Alerts in generated reports.
  • Involved in training end users in basic and advanced ad-hoc reporting, creating queries, formatting results, etc using Web Intelligence.
  • Provided technical assistance to users wif queries regarding errors or programs.

Environment: Business Objects 4.0, Oracle BI, Teradata database, Teradata SQL Assistant, Oracle 10g, Toad

We'd love your feedback!