We provide IT Staff Augmentation Services!

Sr. Power Bi/ Sap Bo Developer Resume

SUMMARY:

  • Highly motivated Power BI/ SAP BO developer with around 9+ years of IT Experience having multiple skill set and extensive working experience in Data warehousing and Business Intelligence Technologies with expertise in SQL Server Development, MSBI Stack (TSQL, SSIS, SSAS, SSRS), Azure, Power BI for building, deploying and managing applications and services through a global network of Microsoft - managed data centers.
  • Expertise in Development support solutions for Business Objects 4.0/XI 3.1/XI R2/R1/6.x, Central Configuration Manager (CCM), Central Management Console (CMC), Crystal Xcelsius, Query as a Web Service(QaaWS), Crystal Reports 2008/XI R2/XI/9.0 and Live Office.
  • Strong ability to analyze user requirements, Business Requirement Specifications.
  • Expert in Data Preparation, Data Modeling and Data Blending.
  • Hands on Experience in optimizing the SAP BO queries by creating various clustered, non-clustered indexes and indexed views.
  • Extensive experience with MySQL, DB2, SQL Server, Oracle Database Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER Functions.
  • Expertise in Power BI, Power BI Pro, Power BI Mobile
  • Experience in ETL processes involving migrations and in sync processes between two databases.
  • Experience in gathering, analyzing and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
  • Excellent knowledge of all the phases of Software Development Life Cycle (SDLC
  • Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation
  • Experience in hard coding the crystal commands of Date parameters,(ISNULL(), lastfullmonth, monthtodate etc.), CSTR, Date and String conversions
  • Extensive experience in design and developing of jobs, workflows, Data flows and creation of transformations between source and target database using SAP Business Objects Data Services (BODS / BODI) Designer.
  • Expert in creating and developing Power BI Dashboards in to rich look and tested Power BI reports of Database and verified it with the source data.
  • Worked on Data warehouse such as dimensional modeling, Star/Snowflake schemas, Data marts, fact and dimension tables identification and OLAP.
  • Experience in Database Development and Release Management Concepts, Practices and Procedures along with Performance Tuning Database Code in OLTP and OLAP environmfents.
  • Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) and Complex Queries on Microsoft SQL Server
  • Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
  • Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER functions.
  • Involved in Coordinating meetings with the product committee, project manager and functional management to discuss project impediments, needed resources or issues/delays in completing the task.
  • Excellent Written and Verbal communication skills and ability to translate Technical Concepts into Business Language and Business Language into Technical Requirements.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Power BI/ SAP BO Developer

Responsibilities:

  • Developed Dashboards and Reports with Excel, SQL Server, SharePoint List and Report Server data sources using Power BI Service Desktop tool.
  • Involved in database development using stored procedures, triggers, views and cursors.
  • Created Cluster/Non-Cluster Index, Unique/Check Constraints, Views, functions.
  • Involved in creating MDX, DAX, Cubes and Tabular models using SQL Analysis Services (SSAS).
  • Wrote efficient Stored Procedures for the Optimal Performance of the system.
  • Embedded Power BI reports on SharePoint portal page and managed access of reports and data for individual users using Roles.
  • Generated dashboards in POWER BI Desktop and POWER BI Service using super-fast slice and dice and modern data visualization features.
  • Designed and developed new ETL/SSIS package that load data from OLTP into our existing Data Warehouse based on technical specifications and business requirements.
  • Designed dimensional data model of the OLAP database using Erwin.
  • Automated Power Query refresh using power shell script and windows task scheduler.
  • Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.
  • Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
  • Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports.
  • Responsible for creating and changing the data visualizations in Power BI reports and Dashboards on client requests.
  • Designed and implemented SSAS Tabular Cube as the reporting layer. And Used DAX scripting to accessdata from Tabular Model.
  • Deployed Dashboards, Reports and Data sources in the Power BI Service. Environment: MS SQL Server, SQL Server reporting services SQL Server Integration Services 2014 (SSIS), MS SQL Server 2016T-SQL, DAX, SQL Server, PowerBI Desktop,DAX,MDX, JIRA, Tableau, Microsoft Visual Studio 2014, Excel, Azure

Confidential, Dallas TX

Sr. Power BI Developer

Responsibilities:

  • Coordinated JAD session with the development team to understand functional requirements.
  • Used Power BI Custom visuals like Power KPI, Chiclet Slicer, Info Graphic Designer, Spline Chart to make the visuals look and understand better.
  • Created indexes and indexed views for enhanced query performance.
  • Designed and implemented SSAS Tabular Cube as the reporting layer. And Used DAX scripting to accessdata from Tabular Model.
  • Designed Data Model in Power BI Designer according to the Structure and Hierarchy of Data.
  • Created indexed views, and appropriate indexes to reduce the running time for complex queries.
  • Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
  • Monitored performance and optimized SQL queries for maximum efficiency.
  • Created reports using multiple data providers such as Universes and personal data files in generating reports.
  • Formatted the reports as per the business requirements.
  • Implemented Power BI Power Query to extract data from external sources and modify the data to generate the reports.
  • Extracted data from Oracle, SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
  • Designed dashboards utilizing Power BI with rich visuals such as charts, slicers, gauges, funnel, word cloud.
  • Performed data messaging operations using DAX expressions and M code in Power BI.
  • Developed Power BI Apps to deliver key metrics to multiple groups within the organization.
  • Shared Power BI reports and dashboards to various user's groups using app workspace.
  • Set-up data alerts on Power BI dashboards to update stakeholders.
  • Responsible for creating datasets using T-SQL Stored Procedures and involved in Data visualization.
  • Configured Power BI enterprise data gateway for scheduled data refresh of Power BI datasets.
  • Secured the reports using role based security in Power BI. .
  • Designed the POC for migrating the On-premises OLAP database to Cloud for reporting.
  • Utilized TFS (team foundation server) for coded check-in/check-out and the management of differing code versions.

Environment:, SSDT,, T-SQL,DAX SQL Server Analysis Services 2014 (SSAS), SQL Profiler, SSMS, MS-Excel, Power BIDesktop, Azur

Confidential

Sr.SAP BO Developer

Responsibilitie

  • Installation, configuration, maintenance, technical support and troubleshooting of Business Objects.
  • Interacted with Business Users and Business Analysts to gather the Requirements and Businesslogics.
  • Worked closely with Business Analysts to capture and document Business Requirements.
  • Established the SAP Business Objects connectivity with SAP BW system and Relational databases t implement the SAP Business Objects reporting requirement.
  • Involved in designing Universe and migrating existing Desktop intelligence (DESKI) reports to Web intelligence (WEBI) reports.
  • Actively involved in migration of Business Object resources from BOXI 3.1 to BOXI 4.0 environment.
  • Performed regression testing after migration to BOXI 4.0 platform.
  • Fixed formatting, dimension and variable issue in Webi report after migration.
  • Convert BOXI 3.1 universes to BOXI 4.0 version of universe.
  • Involved in designing Technical specification document, identified various data mappings and the design of Data warehouse.
  • Incorporated complex business logics by writing complex SQL procedures and functions.
  • Use life cycle manger to promote Business Object resources from Development to Test server.
  • Performed an initial study of the current reporting application, to finalize the data elements required for reporting.
  • Managed existing Universes, created Classes, Objects and applied Hierarchies based on Businesslogic.
  • Created Universes and Complex Reports.
  • 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.
  • Exported the Universes to the Repository to make resources available to the users for ad-hoc report needs.
  • Created complex reports using reporter module in Desktop/Web Intelligence functionalities like Slice and Dice, Drill Down, @Functions, Cross Tabs, Master/Detail, and Formula.
  • Created dashboards for Operations and Sales, Actual Sales and Projected Sales, National and International territories Sales using Xcelsius, Web services, QaaWS and Excel data.
  • Linked reports using Open Document syntax to link master report to a detail report by creating hyperlink objects in the Universes and Reports.
  • Troubleshooted and resolved the issues with existing ETL process.
  • Generated pictorial views in the form of 2D, 3D & Pie Charts from existing Reports & Chart Wizard.
  • Updated and maintained Universes based on changing user requirements and data source changes.
  • Extensively used designer to design various universes for different business groups.
  • Worked extensively with the major functionalities of BO like Breaks, Sections, Alerter, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
  • Used features such as functions, running totals, parameters and conditional formats to develop highly formatted Crystal Reports.
  • Created Crystal Reports using Universes and Business Views as the data sources based on the business requirements.
  • Ensured the quality and timely delivery of all the important complex canned reports, and Involved in migration and testing of Objects to PROD environment from DEV through QA environmentusing Import Wizard .

Environment: Business Objects XI 3.1/3.0, Designer XI, Crystal Reports, Web Intelligence XI, Desktop Intelligence, Info View, Designer, CMC, Xcelsius Dashboards 2008, OLAP, BO Live office, Windows 2003/XP, TOAD, RDBMS, SQL Server, SAP BW, SAP Business Objects suite

Confidential, LA

SAP BO Developer

  • Complied a complex technical documentation based the business requirements.
  • Created multifarious sales reports in SAP Business Objects including complex cross tab, summary reports.
  • Generated various reports on Daily, Weekly, Monthly and Yearly basis.
  • Extensively used formulas, variables, prompts, alerts based on Universes.
  • Created universes using derived tables and materialized views.
  • Created universes and resolved loops and Traps by table aliases and contexts.
  • Involved in upgrading of reports from SAP Business Objects XI to Business Objects 4.0.
  • Involved in supporting the UAT team during Upgrade of reports from SAP Business Objects XI to Business Objects 4.0.
  • Create reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
  • Used data modeling tool Erwin for creating Logical, Physical data models and DDL's.
  • Responsible for ETL operations using SQL Server Integration Services (SSIS) and Worked with users in training and support and also has experience in incremental data loading.
  • Created Standard reports, Ad-hoc reports, Complex charts and Drill-Down Reports using BusinessObjects 4.0.
  • Created Ad-hoc reports using SAP Business Objects functionalities like Cross Tab, Master Detail and Formulas, Alerts, Slice and Dice, Drill Down @Functions.
  • Extensive hand-on experience in working with Xcelsius Dashboards.
  • Experience working with Xcelsius to display summary-level business data in a rich and intuitive format.
  • Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Crystal Xcelsius.
  • Test/Debug Business Objects Universe enhancements/modifications in Designer to include new objects, updated tables and joins.
  • Worked extensively with the ETL team in creating summary tables to improve report performance.

Environment: SAP Business Objects 4.0 (CMC, Import Wizard, Universe Design Tool, Web Intelligence, Info view), Crystal Reports 2011, Xcelsius 2011, Visual Basic 6.0, DB2, Oracle 11g, SQL Server 2005/2008.

Confidential, Mason OH

SAP BO Developer

Responsibilities:

  • Design and development of complex Business Objects reports
  • Use of Lumira for agile visualization
  • Design and development of universe and data modelling using Information Design Tool
  • Implemented security features of Business Objects like row level, object level and report level to make the data secure
  • Involved in performance tuning and Data Quality, Business Objects Full Client and WEBI reports.
  • Use of Dashboard Design(Xcelcius) for creating dashboards and crystal reports
  • Wrote complex views, functions and stored procedures using SQL & PL/SQL to be used in Reports development.
  • Use of Central Management Console to set up groups and users for Business Objects deployment. Manage user profiles using Supervisor and set object-level security and row level security restrictions, to restrict sensitive client
  • Create standard and ad-hoc reports using Business Objects functionalities like Slice and Dice, Templates, Drill Down, Functions, Cross Tab, Master Detail and Formulae, Breaks and Custom Sorts in reporting
  • Responsible for defining the scope of the project, gathering business requirements, doing gap analysis and document the same
  • Worked on Data Modeling using Dimensional Data modeling, Star Schema/Snow flake schema, Fact & Dimensions tables, physical & logical data modeling
  • Responsible for developing thick/thin client canned reports using Business Objects and Web Intelligence
  • Documenting issues and resolutions, troubleshooting tips and knowledge-sharing with team
  • Performed Admin tasks like monitoring DB Services, monitoring BO server running with optimal performance, monitored licenses, monitoring of user activities/ sessions etc.
  • Various forms of dashboard development 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
  • Perform unit testing to ensure dashboard is working as expected in complex scenarios
  • Handled project management tasks such as resource allocation, project planning, updating management on project and progress reviews etc.
  • Developed and designed training material for end-users
  • Created reports with Charts and Drill down functionality for a better Visualization.
  • Used Performance Management tools to make the Look and feel of the report in a better way for taking the decisions
  • Created Custom LOV's (List of Values) and Custom Hierarchies for drilling down to lower levels in the reports.
  • Designed and developed Test Scenarios, Test procedures, Test Cases, and Test Data according to requirements.

Confidential, Richmond, VA

SAP BO Developer

Responsibilities:

  • Customizing the AdhocWebi reports as per the user requirements by using the Formulas, Drill Downs, Master/Detail and Cross Tabs.
  • Developed dashboards, KPI and scorecards for detailed analysis. Also, creating Dashboard (xcelsius) Manager using Application Foundation and Web Intelligence.
  • Optimize Universes using @functions (@prompt and @select) and Aggregate Awareness Functionality.
  • Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.
  • Created dashboards using SAP Business Objects Dashboards 4.0 (Xcelsius)
  • Created WSDLs using Query as a Web Service (QaaWS) from different Data sources.
  • CMC: Scheduled the reports (PDF, Excel) in Info View to Business users
  • Implemented dynamic cascading prompts and defined business views
  • Organized complex data in the report by Inserting Filters, Sorting, Ranking and highlighting data.
  • Created complex reports by utilizing the features on Web Intelligence like Optional Prompts, Functions, Alerters, Rank, and Merged Dimension etc.
  • Assisted with admin to work with LCM, upgrade management tool and Promotion management tool
  • Assisted in training the powerful features of Business Objects to Moderate BO users.
  • Solid knowledge of PLSQL procedures, functions, triggers, packages and advanced SQL queries
  • Created complex crystal annual mock up tabs (N*N matrix), Summary Reports, Master/Detail Reports, list-detail reports of conditional suppress/unsuppressed sections from scratch.
  • Implemented static/dynamic date parameters to multiple sub-reports in crystal
  • Tweaked various cosmetic changes (summary info, section expert, guideline, rulers, grid and align) to make all the sub reports were consistently crystal pixel perfect reports
  • Experience on shared variables (numerical/dynamic arrays) to communicate through the main-report and to display statistical values (mean, median and aggregate averages).

Environment: SAP Business Objects 4.0 (CMC, Import Wizard, Universe Design Tool, Web Intelligence, Info view), Crystal Reports 2011, Xcelsius 2011, Visual Basic 6.0, DB2, Oracle 11g, SQL Server 2005/2008.

Confidential

Team Lead

Responsibilities:

  • Gathered business requirements and performed detailed analysis.
  • Created universes with Classes and Objects for investment management system.
  • Defined contexts, aliases and used multi parse SQL in the universes to address loops, chasm traps and fan traps, which support Ad-hoc and canned reports.
  • Used Index awareness, @aggregate aware and Aggregate tables for optimized query performance. Created universe on top of views build in composite coming from multiple data sources.
  • Worked extensively with @functions (@select, @prompt, @where) in designer, created optional prompts, also created objects using complex case functions.
  • Exported Xcelcius to repository to make it available for users through info view, Created and modified the Crystal Reports for various financial groups using the Universe as a main data provider.
  • Created Multiple Custom Hierarchies for several groups to provide drill across functionality
  • Extensively involved in developing Web Intelligence reports' publications, scheduling and monitor publications..
  • Implemented Row level restriction for managers profiles using designer. Resolved tickets to support production environment, modified and tweaked report content and distributed reports in multiple formats such as Excel and PDF.
  • Used @aggregate aware function and Aggregate tables for optimized query performance. Used @prompts to create predefined conditions and prompts to filter the data and dynamic user selection.
  • Developed Graphic Reports, Pie charts for the statistical representation of the data. Tested the Web Intelligence reports in System Integration and Testing (SIT) environment and Performance Testing (Staging) environment to validate performance of all the reports, which helped in analyzing its performance before moving into production environment.
  • Installing, Deploying and Clustering BOXI 3.1 Enterprise server on Windows 2003 server and Windows Server 2008 having Web / Application server as Apache Tomcat, Websphere
  • Installation of client tools.
  • Performed migration of contents ( including users, reports, universes) from R2 to 3.1
  • Testing performance of CR, WEBI, DESKI and accordingly configuring the server parameters.
  • Post-implementation, enhancement and maintenance support.
  • Created users, groups, server groups and setup security architecture.

Environment: SAP BO 4.0, UDT, IDT, SAP BO3.1, Acute, Windows

Confidential

Sr. BOBJ Developer

Responsibilities:

  • Created prototypes of the dashboards, involved in interacting with the end users and finalizing the conceptual design, Created Xcelcius visualization for Wealth management business unit to provide Financial Analysis by product, region, state, portfolios and Advisors.
  • Created personalized dashboards to reflect user-specific alerts and metrics to track critical Key Performance Indicators (KPI). Used XML, QAAWS data sources to import data into the dashboard.
  • Used dynamic visibility to give users multiple views with in one single screen for detailed insight and interactive analysis, Used multiple components (Gauges, dials, sliders, list boxes radio buttons, Pie charts, combination charts, accordion menus, combo boxes etc) to build state of art dashboards
  • Created drill down reports in crystal reports and in web intelligence
  • Created universes with Classes and Objects for investment management system. Defined contexts, aliases and used multi parse SQL in the universes to address loops, chasm traps and fan traps, which support Ad-hoc and canned reports.
  • Extensively involved in developing Web Intelligence reports' publications, scheduling and monitor publications.
  • Used @aggregate aware function and Aggregate tables for optimized query performance. Used @prompts to create predefined conditions and prompts to filter the data and dynamic user selection
  • Developed Graphic Reports, Pie charts for the statistical representation of the data. Tested the Web Intelligence reports in System Integration and Testing (SIT) environment and Performance Testing (Staging) environment to validate performance of all the reports, which helped in analyzing its performance before moving into production environment.

Environment: BO3.1, UDT,Infoview, XML, QAAWS, dashboards, Xcelsius, SQL,Crystal Reports 2008, Windows.

Confidential

Business Objects Technical Support Specialist

Responsibilities:

  • Involved in Administration activities, worked with Import Wizard to promote Reports/Universe to Production. Installed, Maintained the Business Objects Enterprise. Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department.
  • Created dashboard for IT department and published them to the Enterprise, which showed daily activity being performed by the system users such as user’s login time, number of reports being used by each user, number of sessions running etc.
  • Defined contexts, aliases and used multi parse SQL in the universes to address loops, chasm traps and fan traps, which support Ad-hoc and canned reports.
  • Worked extensively with @functions (@select, @prompt, @where) in designer, created optional prompts, also created objects using complex case functions.
  • Extensively involved in developing Web Intelligence reports' publications, scheduling and monitor publications.
  • Created Xcelsius Dashboard using Query as a Web services. Involved in POC and user training on Xcelsius and live office. Involved in user training, trained users on Infoview and Xcelsius Applications, and provided technical guidance to users.
  • Implemented security matrix in CMC, created access levels for users and applied restrictions on contents. Implemented Row level restriction for managers profiles using designer.
  • Resolved tickets to support production environment, modified and tweaked report content and distributed reports in multiple formats such as Excel and PDF.
  • Worked with Crystal Report XIR2 for creating complex reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports and analysis reports.
  • Used conditional formatting as per user requirements in crystal reports.
  • Developed Graphic Reports, Pie charts for the statistical representation of the data

Environment: BoXI, BOXIR2,BO3.1, UDT,Infoview, CMC, Universe, Import Wizard, Oracle 10g, SQL, Windows.

Hire Now