We provide IT Staff Augmentation Services!

Bi Consultant Resume

Irvine, CA

SUMMARY:

  • 11 years of experience in developing and administrating reporting solutions in different versions of SAP Business Objects, Crystal Reports, Tableau and SAP BW (Webi, Deski, Business View Manager (BVM), Universes, BO 3.1, 4.X, Crystal Reports 2008 - 2016, Tableau 10.2, SAP BW 7.X).
  • Experience with Installing and Administration of entire hardware, and software products like Tomcat, and Apache (Clustered and Standalone environments).
  • Experience in Installing and testing the Business Objects applications suite on servers.
  • Substantial experience in Business Objects Upgrades (XIR 2/3.0/3.1/4.1/4.2 ).
  • Effectively administered and supervised the Business Objects (SAP BI) environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports.
  • Knowledge about Business Objects Security Model and experience with Business Objects Security Implementation (Row level, Object level, Command level in both BO 3.X and 4.X).
  • Experienced in Import Wizard, upgrade management tool and Promotion Management.
  • Professional understanding of Software Development Life Cycle (SDLC).
  • Developed Complex Reports from varied data sources like Store Procedure, Excel files, Oracle and SQL Server.
  • Worked on creating BO Reports based on Custom Hierarchy, dynamic cascading prompts, Custom LOVs, dynamic data connections in BVM, merged dimensions, derived tables, designer and IDT, multitab and multisource reports.
  • Worked on building complex Crystal Reports using Arrays, Custom Functions, Variables, Running totals, and Subreports.
  • Expertise in Developing Universe from scratch along with resolving traps and loops.
  • Experience in performance tuning in Business Objects and Crystal Reports.
  • Strong data base experience in Oracle9i/10g/11g, Microsoft SQL Server 2005/2008.
  • Experience in Data Warehousing and Data Processing concepts and implementations.
  • Knowledge of different Schemas (Star and Snow Flake Schemas) for query and business analysis requirements.
  • Experienced in identifying Bottlenecks in Reporting Processes and resolving in limited time frame.
  • Experience in PL/SQL procedures, packages, functions, cursors, triggers, views, materialized views.
  • Excellent technical and professional client interaction skills. Interacted with both Technical, functional across different phases of the project life cycle.
  • Currently working as an onsite Lead for Confidential for a BW/BO Production Support Lead role.
  • Expert in scheduling the reports and ETL jobs via Autosys by writing JILs.
  • Good hands on experience on UNIX commands and scripts.
  • Can trouble shoot technical issues during the ETL process, isolate the root cause and take appropriate action to amend the problem.
  • Basic knowledge of Informatica. Developed simple to medium level workflows. worked on managing ETL process by pulling large volume of data from OLTP to a staging Database using SSIS for data transformation.
  • In depth use of Data warehouse concepts, OLTP, OLAP, ETL, Star Schema, Snowflake, data modelling and SQL.
  • Good Hands on knowledge on SAP BW, BEx Analyzer, Query Designer, Analysis for Office and EPM.

TECHNICAL SKILLS:

Reporting tool: Crystal Reports 2008-2016, Business ObjectsXIR2, 3.X/4.X, BEx Analyzer, A4O, EPM

ETL tool: Informatica 9.1, SAP BW 7.X

Data Modeling: Star Schema Modelling, Snow Flake Modelling, FACT & Dimensions.

Databases: Oracle 11g/10g/9i, Microsoft SQL Server 2005/2008

Languages: PL/SQL, SQL Server, UNIX Shell Script

Database Utilities: Toad, Rapid SQL, PL/SQL Developer

Operating Systems: Windows 7/10 Professional, UNIX

Scheduling Tool: Autosys

Domain Knowledge: Banking and Finance

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

BI Consultant

Responsibilities:

  • Understanding the data flow from SAP and Non SAP Data Sources to SAP BW.
  • Providing production support for BW Process Chains, troubleshooting data issues, work with business to for data correction from source.
  • Design and support Webi, Crystal, Analysis for Excel, and BEx Analyzer for business users.
  • Design and support Interactive Dashboards with Tableau 10.2.
  • Validating the installation by checking the public folders, Reports in Personal folders, Groups, Row level security, Scheduling and by running some sample reports.
  • Developed ETL to extract files for the external vendors and coordinated that effort.
  • Working on security issues and user maintenance in BO 4.2 SP4.
  • Defined best practices for Tableau report development.
  • Created repository and security domain with user groups and security implementation.
  • Resolve remedy Incidents and Change requests.
  • Having Tableau Expertise in Administration, designing, development and deployment.
  • Created ETL for transforming and loading dimensions and facts, using SSIS and Azure data factory.
  • Promoting the code from Dev, QA to Prod.
  • Provided support for Tableau developed objects and understand tool administration.
  • Used existing ETL standards to develop these mappings.
  • Proficient in data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
  • Performed ETL testing based on ETL mapping document for data movement from source to target.
  • Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, BI
  • Developed dashboard prototypes using Cloud Dashboard Tools Looker and AWS Quicksight managing all aspects of the technical development.
  • Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
  • Configuration Management of reports in Perforce.
  • Wiring JIL jobs for Autosys scheduling.
  • Experience with Big Data, Cloud Analytics, Data Mining, and Data Visualizations using various tools and applications
  • Leading a mix of onshore-offshore team.

Environment: BOE 4.2, Crystal Reports 2016, Tableau 10.2, SAP BW 7.4, ETL, Oracle 11g

Confidential, Irvine, CA

BO Lead Consultant

Responsibilities:

  • Participated in project planning sessions with Client managers, business analysts and team members to understand current BO environment and finalizing effort and approach for Migration.
  • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
  • Proposed and executed the project in an Agile and phased manner.
  • Used Upgrade Management Tool and Promotion Management for the Migration process. Migrated users, universes and reports.
  • Extensive experience with IBM Mainframe for analyzing the data in designing the ETL Process.
  • Conducted sessions with to make them understand about the new featured in BO 4.1 compared to BO 3.1.
  • Migrated users, categories, groups, reports, folders, Universes, security models from Business Objects 3.1 version to Business Objects 4.2 SP2.
  • Worked closely with business power users to create reports/dashboards using tableau desktop.
  • Tested integration and validation of data from various sources to targets using SQL queries and ETL process.
  • Creation of Folders in CMC and implementing security on various objects of CMC (folders, Applications, Universe and Connections).
  • Experiences with push down optimization in Informatica.
  • Extensive knowledge of Tableau Server Concepts like tab cmd, tab admin, creating/ adding users, sites and projects, managing licenses and data connections, scheduling tasks.
  • Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
  • Used XML Parsers and Generators to handle inbound and outbound XMLs in Informatica.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Experience in Publishing Tableau Workbooks to Tableau Server and assigning User Access.
  • Worked on remediating the Upgrade issues reported by testing team.
  • Documented all issues faced during the BO Migration and presented to all application teams.
  • Provided post migration support to different application team.

Environment: BOE 3.1/4.1, ETL, Crystal Reports 2013/2016.

Confidential, Irvine, CA

Technology Lead

Responsibilities:

  • Understanding of financial data flow in Eagle and Eagle core reporting.
  • Design and develop Informatica workflow to get data out from Eagle modules to database.
  • Understanding of client custom reporting needs and suggesting BO capabilities to achieve the same.
  • Design and develop reports in Webi and Crystal Reports.
  • Maintained the user accounts (IAM). Migrated applications to the AWS cloud.
  • Doing POC for complex requirements.
  • Publishing and scheduling the reports on BOE 4.1
  • Promoting the code from Dev, QA to Prod.
  • Configuration Management of reports in Perforce.
  • Wiring JIL jobs for Autosys scheduling.
  • Leading a mix of onshore-offshore team.

Environment: BOE 4.1, Perforce, Oracle 11g, Autosys, Informatica 9.1, Crystal Reports 2011

Confidential, Irvine, CA

Technology Lead

Responsibilities:

  • Understanding Actuate Reports and Document them as requirement document for Webi Reports.
  • Acting as a Single Point of contact for Infosys and CG stakeholders.
  • Acting as a BO consultant to client and providing them in depth details of BOE capabilities and providing alternate solutions in case of complex requirements.
  • Building Webi reports over oracle, DB2 and SQL server.
  • Doing POC for complex requirements.
  • Worked on SAP Data Services for Data extraction and Manipulation from source systems needed for reporting.
  • Publishing and scheduling the reports on BOE 4.1
  • Promotion and Configuration management of code.
  • Handling a development team of 10 resources as Onsite Lead.
  • Helping junior team members in any technical challenges faced during development.

Environment: BOE 4.1, Perforce, Oracle 10g, Autosys, Crystal Reports 2011

Confidential

Technology Analyst

Responsibilities:

  • Understanding requirement by Disaster Recovery group and developing crystal reports.
  • Uploading the latest reports over LDRPS Application.
  • Design and development of Crystal Reports.
  • Scheduling and modifying existing reports.

Environment: SAP Crystal Reports 2008, Oracle, SQL Server

Confidential

Technology Analyst

Responsibilities:

  • Developed proof of concepts (POC) for creating custom hierarchy and using in the Report.
  • Build Webi reports over a reporting data warehouse.
  • Involved in designing the data model. Good understanding of Data warehousing concepts, Star schema and Snow-flake schema.
  • Worked on SAP Data Services to load data from flat files with source systems to reporting data warehouse.
  • Performance tuning both at the Universe and Report level.
  • Performed the Unit testing, Integration testing and System testing. Extended support to the users in UAT.

Environment: Business Objects 3.1, Oracle 9i

Confidential

Senior Software Engineer

Responsibilities:

  • Development of Webi reports and universes over BOXI R2.
  • Migration of BO reports from BOXI R2 to R3.
  • Took a backup of CMS DB and FRS input and output of BO XI R2 version.
  • Note the security model at XI R2 level, Server settings as well.
  • Install a brand-new BO XI 3.1 version with SP’s, with new schema information.
  • Used Import Wizard Import folders and users with instances options.
  • Implemented new security model in XI R3 based on XI R2 model as we had more options in XI R3.
  • Troubleshooting all migration related issues.
  • Raising tickets with SAP support for any unresolved technical challenges.

Environment: BOXI R2 and R3, Oracle 9i

Hire Now