We provide IT Staff Augmentation Services!

Business Intelligence Consultant Resume

Madison, WI

SUMMARY:

  • Seek challenging assignments opportunity to use my unique set of skills to resolve complex problems and assist a supporting visionary Business Unit to exceed its goals.9+ years of IT experience in the Business Intelligence, Dashboard Development, Business Analysis, Data Analysis, Report analysis, Reports Development & Data warehousing.
  • Business Intelligence Consultant with a skill set of Tableau 9/ 10/ 2018.3, Business Objects XIR2, XIR3, XIR3.1, 4.0, Xcelsius 2008 and Crystal Reports X/XI/2008.
  • Strong experience using Tableau Server, Tableau Desktop, Tableau Public, & SAP Business Objects.
  • Experience in product installation and implementation development of insightful dashboards in Tableau and Business Objects.
  • 3 years of experience working in Tableau.
  • 2+ experience in MS Power BI.
  • 2 years of experience working in SAP HANA.
  • 1+ year of experience working in SSRS.
  • Experience in designing BI solutions and leading projects to meet the information needs of the business users.
  • Experience in managing & leading projects for development, reporting and data visualization using Tableau, SAP Business Objects, Power BI and HANA.
  • Experience developing dashboards in Tableau, SAP Lumira, Design Studio, BO Explorer and Power BI.
  • Experience in Configuring Interactive Dashboards with Drill - Down capabilities using Filters, sets, groups, calculated fields, parameters, bins, sorting etc. and Dashboard prompts.
  • Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables and logical and physical modeling.
  • Experience in creating Procedures, calculated views, analytical views and attribute views in SAP HANA.
  • Experience building reports using SAP HANA as source.
  • Expertise in conducting corporate trainings for the end users.
  • Excellent presentation skills and strong written and verbal interpersonal skills.
  • Quick learner and stronger desire to master in new technologies.

TECHNICAL SKILLS:

Reporting Tools: Tableau 2018.3/10/9, Power BI, Business Objects 4.2/4.1/4.0/ XIR3/XIR2, Web Intelligence, BI Launchpad, Info view, Desktop Intelligence, IDT, UDT, CMC/CMS, Broadcast Agent, Performance Manager, Import wizard, Crystal reports XI/10/2008, SAP Lumira and Xcelsius 4.5/2008, Microsoft Visual Studio 2008.

ETL: Informatica, Data Services (BODS) and SAP BW

Databases: Oracle 12c/10g/9i/8i, MS SQL Server 2000/2005/2008 , MS Access and DB2

Languages: XML, HTML, JAVA Scripts, LANGUAGES, SQL, PL/SQL and C

Operating Systems: Windows 95/98/NT/2000/XP/7/8

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

Business Intelligence Consultant

Responsibilities:

  • As a BI consultant, primary activities included designing technology roadmap for dashboards & reports using Tableau and Business Objects; serving as SME point of contact for Tableau and delivery of solutions adhering to BI industry best practices.
  • Interacting with users, managers, bureau directors for business requirements.
  • Implement technical solutions for ongoing challenges.
  • Install upgrade Tableau server and server performance tuning for optimization.
  • Designing data model from scratch to aid team in data collection to be used for Tableau visuals.
  • Developed Tableau Dashboards with interactive views, trends and drill downs along with user level security.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Worked with team of analysts, bureau directors and project managers to develop and implement BI solution and Customer KPIs for Department of Children & Family.
  • Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields.
  • Translating business process into technical requirements, developing dashboards and BI reports.
  • Working with management teams, database team and BI team in designing BI solutions.
  • Develop BI reports for Internal and external users.

Environment: Tableau 2018. 3, SAP BO 4.2 & Oracle 12c.

Confidential, Brooklyn Park, MN

SAP Data Modeler

Responsibilities:

  • Main responsibilities include BI analysis, collecting user requirements, data modeling, dashboard build and report building.
  • Provided technical solutions to team members in achieving targets for BI reporting.
  • Worked with BI Architect in designing the BI environment based on client requirements.
  • Worked with various business users to analyze reporting needs and developing appropriate applications.
  • Analyzed supply chain data to identify relationship between purchase orders, line items and inventory.
  • Analyzed data for orders, freight, tax and materials and transformed into BI reports.
  • Worked with ABAP programmers in translating ABAP codes to BI reports.
  • Designed BI universes and reports using SAP Business Objects 4.0.
  • Created attribute, analytical and calculated views based on client requirements Using SAP HANA.
  • Replicated data using SAP ECC to SAP HANA using SLT.
  • Build prototypes dashboards using Power BI, SAP Lumira & Tableau.
  • Build BI reports using tools like BI Launchpad, Webi Rich Client & Microsoft Visual Studio.
  • Build dashboards using Microsoft Power BI.
  • Build dashboards using multiple sources in Power BI.
  • Scheduled Automatic refresh and scheduling refresh in Power BI service.
  • Created Reports using Charts, Gauges, Tables, and Matrix.
  • Improved the performance of dashboard using calculated columns and measures.
  • Designed and developed queries and views necessary to support SSRS reports.
  • Created reports using Microsoft Visual Studio.
  • Used excel macros to get live data into reports.
  • Very good understanding of purchasing, order to cash, sales & inventory data.

Environment: SQL Server 2008, BO 4.0 & Raven (Custom application).

Confidential, Minneapolis, MN

SR Business Intelligence Consultant

Responsibilities:

  • Responsible for creating BRD (business requirement document), project plans and timelines.
  • Responsible for mapping business requirements to technical specifications and creating technical design documents.
  • Developed audit universe to monitor business objects activity’s and jobs by implementing best practices.
  • Developed solution for tracking and monitoring report ticketing system using Business Objects tools.
  • Developed Webi reports using updated features like Cascading input controls and grouping input controls, providing better satisfaction to end users.
  • Optimized Business Objects reports and universes using features like query stripping and index-aware prompts.
  • Created Business Objects universes using IDT and UDT.
  • Developed dashboards and published story’s and data sets to SAP Lumira.
  • Created data visualization application for business users using Lumira.
  • Experience working on designing/creating InfoObjects, InfoSources, Transfer structures, Communication structures, Standard and Custom InfoCubes, Data Store Object (DSO).
  • Experience in installing and configuring Business Objects on Windows.
  • Worked on mapping data, from different source systems to consolidate into one universe.
  • Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
  • Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
  • Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
  • Utilized Tableau server to publish and share the reports with the business users.
  • Generated data extracts in Tableau by connecting to the view using Tableau MySQL connector
  • Responsible for requirement gathering, report design, preparing work flows and report gathering templates.
  • Worked on production support, monitoring, trouble shooting, deploying and opening communication lines between ETL team, QA team, Business Analysts and BO team.
  • Worked on production releases, monitoring job loads, scheduling and triggering BO reports on load completion and sending communication to users.
  • Working with ETL, QA and Production Support teams in deploying analytical tools and solutions.
  • Used tools like JIRA for task management and project tracking.

Environment: Oracle 10G/11G, SQL Server 2008, Teradata, BO 4.1 & Tableau 9.

Confidential, Minneapolis, MN

SR Business Intelligence Lead Consultant

Responsibilities:

  • Clustered SAP Business Objects environment with multiple servers in processing and application tier.
  • Configured multiple application servers with load balancer and IIS to enable Single Sign-on (SSO) and Windows AD.
  • Designed and created SAP Business Objects security gate access for external customer by integrating Voya Online services security application.
  • Implemented complex Row Level Security logic in the universes for internal, external and regional office users.
  • Developed Universes in XI R3 and set up row level security for different groups in Designer.
  • Rebranded around 40 Business objects reports and successfully deployed it to prod.
  • Debugging and resolving ticketing issues.
  • Working with ETL team in designing and implementing of data model for Business Objects universe and reports.
  • Analyzing the data for business requirements
  • Providing layouts and timelines to meet project development needs
  • Analyzed business process and recommending process improvement techniques, resulting in better performance.
  • Working in agile environment with changing requirements, applying fixes and deploying reports and universes to QA and Prod environment.
  • Participating in scrum meetings and defining task using version1.

Environment: Business Objects XIR 3.1, BW 7.4, Apache Tomcat, DB2.

Confidential, Maple Grove, MN

BI Analyst/ Business Objects Consultant

Responsibilities:

  • Actively interacting with business users to understand their business requirements in developing and designing Web Intelligence reports.
  • Trained End Users on Web Intelligence platform and helping them resolve report issues.
  • Developed and published story’s to SAP Lumira server using SAP Lumira.
  • Developed Web Intelligence reports using BI Launch pad 4.0
  • Created Information spaces and Exploration view sets using BO explorer 4.0.
  • Created report design prototypes to monitor product sales for sales department.
  • Provided reporting solutions to business users.

Environment: Business Objects XIR 4.1, Apache Tomcat, SQL Server 2008.

Confidential, Minneapolis, MN

Business Intelligence Lead Consultant/ BI Analyst

Responsibilities:

  • Interacted with business users, business owners to know understand their business requirements in developing and modifying universes and reports.
  • Conducted meetings with end users, presented mock reports and designed reporting solutions for supply chain data.
  • Led a project team responsible for the data validation & BI Reporting.
  • Delivered over 350 reports & provided maintenance, supporting key processes in Sales, Finance & Operations.
  • Maintained communication with end clients and provided project status.
  • Supported UAT team in testing Webi reports by conducting user training and by facilitating them with different user friendly options in Webi.
  • Optimized reports by using index awareness in Business Objects Universe.
  • Provided support for users on application usage by conducting training sessions and walk through on different user friendly features in Business Objects reporting.
  • Created custom hierarchy using oracle functions for drill through analysis in universe and navigated from summary data to detail data in Webi master to detail report.
  • Designed QAAWS queries for HR dashboard using QAAWS.
  • Worked with ETL team in designing and implementing of data model for Business Objects universe and reports.

Environment: Apache Tomcat, Teradata, Oracle, DB2, SQL Server, Informatica, Business Objects 3.1/4.0, Crystal Reports X, Xcelsius 2008.

Confidential, Rochester, MN

Business Intelligence Lead

Responsibilities:

  • Worked as system engineer for Clinical Decision Support and Medical Provider Profile. Responsible for technical design, universe development and report development.
  • Actively interacted with users for requirement gathering and presented mocks, directing towards new technologies, resulting in better performance.
  • Provided BI Solution to internal business customers.
  • Guided and mentored the Business Objects teams, involving training and monitoring staff performance to effectively adhere to company’s “best practice” initiatives.
  • Provided technical support, guidance and documentation to end users; provided immediate fixes remotely on critical issues.
  • Evaluated new analytics tools and methodologies for possible deployment.
  • Responsible for creation, improvement, and documentation of GL and Clinical reports and related universe, including standardization and applying best practices.
  • Used Clear Quest to track and build new request based on the requirement.
  • Developed functional and technical document and leaded the team in gathering and analyzing data flow.
  • Designed and developed standard reports and summary reports using Web Intelligence rich client and Web Intelligence Infoview.
  • Strong understanding of Clinical, in- patient & out-patient data.

Environment: Apache Tomcat, DB2, SQL Server, Data Integrator, Data Stage, Business Objects 3.1/4.0, Crystal Reports 2008, Xcelsius 2008.

Confidential, Eagan, MN

Business Objects Lead Consultant

Responsibilities:

  • Interacted with users, gathered and analyzed requirements to create a logical and physical design of the reporting system.
  • Developed detailed documentation for training and testing. Trained end users in job specific tasks and prepared traceability matrix from the requirements for testing purposes.
  • Prepared a project plan for conversion.
  • Designed and developed queries to generate reports inBEx Analyzer.
  • Designed task for report development along with modifying existing reports to support new and additional business requirements.
  • Converted Desktop Intelligence reports to Web Intelligence using report conversion tool.
  • Partnered with database and architectural teams to plan and build out new reporting systems, understanding the scalability and constraints of data loads and developed a series of complex Business Intelligence solutions using Business Objects Designer, Desktop Intelligence, Web Intelligence and Crystal Reports.
  • Communicated with users and participated in meetings for requirements, gathered and provided production and technical support to the users and business analysts such as remodeling reports, building reports and universes.
  • Supported onshore / offshore developers with ongoing daily issues.
  • Improved the server performance by analyzing the server metrics.
  • Assigned privileges to users and user groups to access and work with universes and reports.
  • Implemented security set up for users and Groups.
  • 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.
  • Set the Row level Restrictions to the different user groups based on their profiles.

Environment: Business Objects XIR3.1, Apache Tomcat, Oracle 10g, DB2.

Confidential, NJ

Business Objects Consultant

Responsibilities:

  • Conducted weekly meetings with client teams providing status and guidance on projects.
  • Conducted Business Objects user training and ongoing mentorship.
  • Responsible for gathering the requirements from the Users and designed the detailed design specifications for the Business Objects reports.
  • Responsible for assigning task to Developers and off shore team, defining project needs and deadlines.
  • Published Webi and Deski reports.
  • Developed complex reports using Crystal Reports, Business Objects and other tools accessing multiple data sources.
  • Gathered requirements to build a universe for Finance department. The process includes interaction with users, training modules to end users.
  • Scheduled reports through CMC and Info view.

Environment: Business Objects XI R3.1, Apache Tomcat, Oracle 10g

Confidential, South San Francisco, CA

Business Objects Consultant

Responsibilities:

  • Migrated Web Intelligence reports, Crystal reports and dashboards from XIR2 to XIR3.1.
  • Responsible in upgrading SAP Business Objects XIR2 to XI3.1 SP3.
  • Tested reports and universes, debugged and resolved the defects identified after migration.
  • Involved in daily scrum meetings to discuss what tasks have been achieved, what needs to be done and what are the loopholes.
  • Created Test cases and tested the reports and data according to the functional and non-functional requirements.
  • Validated Test Plans and Documented the Defects.
  • Fixed the defects identified in SQA testing after migration from DEV to IT.
  • Involved in full life cycle design and development of Business Objects reporting applications. Installation of business Objects and repository creation.
  • Responsible for requirement gathering, interacting with business users and finalize on any enhancement needed for reporting.
  • Fixed the bugs caused after migration in Webi reports, crystal reports and dashboards.
  • Involved in installing and configuring of Business Objects XI servers.
  • Used life cycle manager to promote the jobs from DEV to IT and QA.
  • Prepared user documentation for hands on training for end users.
  • Set the Row level Restrictions to the different user groups based on their profiles.

Environment: Business Objects XI R3.1, XIR2, Win 2008 Server, Apache Tomcat, Oracle 10g & DB2.

Confidential, Boston, MA

Business Objects Consultant

Responsibilities:

  • Created dashboards for Finance and Utilization departments, using LiveOffice and QAAWS as the data sources.
  • Created complex dashboard supporting large amount of data, performing 7 levels of drilling.
  • Used live Office to get data from Web-Intelligence documents and Crystal Reports to feed data to Dashboards.
  • Created templates for standardizing the structure of our corporate documents.
  • Responsible for development of detail business requirement documentation, involving user requirements, planning, design documentation and user acceptance.
  • Created custom reports for financial department, including Accounts receivable, aging, bad debts, balance sheets, cash collection in response to user needs.
  • Involved in all the phases of designing universe and dashboard to suit the management needs.
  • Created Deski reports using stored procedures.

Environment: Business Objects XI R3.1, Apache Tomcat, Oracle 10g.

Hire Now