Manasa B

adx7pv@r.postjobfree.com,

Contact: 309-***-****, Bloomington, IL.

EXPERINCE SUMMARY

** ***** ** ********** ** Business Intelligence tools – Power BI, SAP Business Objects and Cognos.

Experience in various business domains, including Insurance, Manufacturing, Energy & Utilities, and Transportation.

Worked on complete Software Development Life Cycle which includes Design, Development, Migration, Test, Implementation phases and Agile Methodology.

Proficient in working with multiple databases, which include SQL Server, Oracle, DB2 and Excel.

Experience connecting with various data sources using Import and Direct modes for data collection, analysis, transformations, building the models, visualization, and reporting using the Power BI stack.

Expertise in writing DAX (Data Analysis Expressions) measures, aggregations, date/time intelligence functions, calculated columns, and table expressions.

Experience in creating paginated reports using Power BI Report builder and publishing paginated reports to Power BI Service.

Skilled in using Power Query Editor to add tables, columns, perform transformations like Renaming Columns, Changing Datatypes, Split Columns, Merge and Append Queries, Adding Calculated Columns.

Expertise in the design and development of data visuals, and reports, which includes Table, Matrix, Stacked Bar Chart, Stacked Column Chart, Line Chart,Scatter Plot, Tree map, Slicers, Maps, KPI, Decomposition Tree, Smart

Narrative and Key Influencers.

Expertise in implementation of Row Level Security (RLS) in Power BI.

Designed data models using schemas such as Star schema, Snowflake schema in Power BI

Proficient in migration of SAP BO and Cognos reports to Power BI reports and Paginated reports.

Experience in reports building using SSRS.

Experience in migration of SAP BO reports from 3.1 to 4.2 versions.

Expert in SAP BO CMC activities like Promotion management, handle Users & groups.

Expertise in creating packages using Cognos Framework Manager.

Strong knowledge of Data Warehousing, OLTP, OLAP, and Relational Database concepts.

Best team player and work independently with self-service BI tools.

Experience working with scrum master, product owner, and global delivery teams to drive and be a key contributor to project releases and sprint execution.

Enthusiastic and passionate about learning and quickly adapt to new technologies and tools with the latest skills.

TECHNICAL SKILLS

Business Intelligence/

Reporting Tools

Power BI Desktop, Power BI Report Builder, Power BI Service

SAP BO - Information Design Tool (IDT), Interactive Desktop Analysis (IDA) –Web Intelligence, Advanced Analysis – Office and Web versions, Central Management Console (CMC), BI Launch pad

Cognos 10.0 - Report Studio, Framework Manager, Configuration Management

Databases

MS SQL Server, DB2, MS Access, Oracle

Management Tool

Service Now, Remedy, Jira, and Kanban

Languages

SQL

Operating Systems

Windows 7/8/10/, SQL Server 2012 to 2019

PROFESSIONAL EXPERIENCE

Prudential Financial – USA Power BI Developer, Nov 2019 – Present

Project Description

Prudential Inc is one of the largest Financial Organization across the world. It has been providing support in insurance, retirement planning, investment management and others. As part of BI rationalization project, migrating the Cognos and SAP BO reports to Power BI across Business Units.

Responsibilities

Identify the packages and Cognos reports across multiple business units such as GI, GBTS Security Reporting, ISG.

Analyse and archive the inactive Cognos and SAP BO reports.

Create functional specification documents and complexity tracker for Cognos packages, reports, SAP BO reports and universes with identify tables, joins, connections and filters.

Create Power BI reports by reusing existing SQL Queries using Direct Query Connection mode.

Created Power BI reports using Stacked Bar chart, Stacked Column chart, Line Chart, Pie Chart, Tree Map, KPI, Map, Matrix, Table, Cards and other visualizations.

Created Power BI reports using functionalities DAX functions, Slicers, Filters, Bookmarks and Drill through.

Worked on DAX (Data Analysis Expressions) measures, aggregations, calculated columns, date/time intelligence functions, and table expressions.

Published reports on workspaces in Power BI Service.

Developed various dashboards for HR, GI, and ES BU’s.

Created apps for individual business units and provided reports access to respective business users.

Developed Paginated reports using Table, Matrix, List box, Parameters, filters features in Power BI Report Builder.

Environment

Power BI, SAP BO, Cognos, SQL Server, DB2, Oracle

Shell UAH Project – Bangalore (India) BI Developer, Dec 2017 – Oct 2019

Project Description

Shell has planned to develop new reports in Power BI also enhance its BO Webi reports and SAP Design Studio dashboards along with BW queries repointed with new flattened hierarchies with existing classical hierarchies in UAH assignment. This will be followed by in-depth testing to ensure their seamless usage as before.

Responsibilities

Imported data from SAP HANA and Flat files to Power BI to generate reports.

Worked on all type of transformations Renaming Columns, Changing Datatypes, Split Columns, Merge and Append Queries that are available in Power BI query editor.

Build the relationship between tables and established Star Schema in Model view.

Developed reports in Power BI using Calculated Columns, Measures, DAX functions, Slicers, Filters and Bookmarks.

Developed analysis reports and visualizations like table function, aggregated functions, iteration functions, and time intelligence functions.

Designed Power BI data visualization utilizing Matrix, Line and area chart, Bar chart, Column Chart, Pie chart, and Maps.

Implemented RLS in Power BI Desktop and added roles in Power BI Service.

Published Power BI reports to Power BI service workspaces.

Creating connections between BW system and Business Objects using IDT developed the reports using the BEX query.

Developed Web Intelligence Reports using advanced BO features like Document Links, Element Links, Input Controls, Report filters using BI Launch Pad (Info view).

Published Reports and Dashboards to Business Objects Repository [BI Launchpad].

Involved in testing, performance tuning and troubleshooting the errors while developing the reports and reduced the complications of report delivery.

Migrated the reports from development to Quality, Quality to production using Promotion Management in CMC.

Environment

Power BI, SAP BO 4.2, SAP BW, SAP HANA, Excel.

Toshiba BI Upgrade Project – Bangalore (India) BI Developer, Mar2017 – Nov 2017

Project Description

Toshiba has planned to upgrade its BO 4.0 to BO 4.2 version along with BODS data filtration. As part of BO migration engagement, the impact on the current BO Universes and BO reports. This will be followed by in-depth testing to ensure seamless usage as before.

Responsibilities

Closely worked with Onsite coordinators/PM to produce migration activities and test cases.

Responsible for WebI reports and universe migration from 4.0 to 4.2, using promotion management.

Responsible for integrity check of universes after migration, testing of reports after data filtration and migration.

Providing KT to team how to proceed report testing after migration.

Involved in creating test cases and test results.

Environment

SAP BO 4.0, SAP BO 4.2, Oracle

VeriFone BI Retro fitment Project – Bangalore (India) BI Developer, Jun 2016 – Feb 2017

Project Description

VeriFone has planned to upgrade its Oracle EBS 11.x to R12 version. As part of BO Retro-fitment engagement the impact on the current BO Universes and BO reports must be analysed. This will enable the redesign of the BO entities followed by in depth testing to ensure their seamless usage as before.

Responsibilities

Analyse the tables and attributes which are going to impact in the new R12 database after the up gradation from R11 Database.

Created the Impact Analysis document for the list of tables and attributes for Universes.

Valuable contribution on Technical Specification document for the complete list of tables for retrofitting the universes and corresponding reports.

Prepared Impact Analysis document for Deski Reports using Xpress Tool along with the list of table names to be retrofitted.

Modified universes as per the design document database tables, columns and join changes. Added Derived tables in universes based on R12 database changes.

Retrofitting the Universes with all other necessary changes. Performed Integrity Check for all universes after modifications to validate loops, traps, and cardinalities.

Retrofitting the Deski reports and testing with the related connections.

Created BIAR files for the universes and Deski reports.

Environment

SAP BO 3.1, Universe Designer, Toad 11.6

Atlas Copco ACT Project – Bangalore (India) BI Developer, Aug 2015 – May 2016

Project Description

Atlas Copco is a world-leading provider of sustainable productivity solutions. The Group serves customers with innovative compressors, vacuum solutions and air treatment systems, construction and mining equipment, power tools and assembly systems. Atlas Copco develops products and service focused on productivity, energy efficiency and safety.

Responsibilities

Involved in creating reports Design Documents.

Creating connections between BW system and Business Objects using IDT.

Developed the reports using the BEX query.

Developed Web Intelligence Reports using advanced BO features like Document Links, Element Links, Input Controls, Report filters using BI Launch Pad (Info view).

Published Reports to Business Objects Repository [BI Launchpad].

Involved in testing, performance tuning and troubleshooting the errors while developing the reports and reduced the complications of report delivery.

Migrated the reports from development to Quality, Quality to production environments using Promotion Management in CMC.

Scheduled Webi reports to different users as per requirements.

Successfully handled minor enhancements in Dashboards using Dashboard Designer tool.

Linked Dashboards and Webi reports by passing parameters through Open Doc.

Published Dashboards to SAP Portal and Business Objects Repository

Environment

SAP BO 4.0, Dashboard Designer, SAP OLAP Workspace Analysis Tool, BEX Query (SAP BW)

Boeing ESATS Rewriting Project – Bangalore (India) BI Developer, Jan 2014 – Aug 2015

Project Description

Boeing is the world's leading aerospace company and the largest manufacturer of commercial jetliners and military aircraft. Additionally, Boeing designs and manufactures electronic and defence systems, missiles, satellites and advanced information and communication systems.

The objective of the Enterprise Systems Architecture Tool Suite (ESATS) project is to remodel the entire ESATS Standard, and application BI Package based on Cognos best practices to provide the business users and stake holders the flexibility to create Ad-Hoc reports on products, Product versions, Standard Category and Software Module.

Responsibilities

Analyse the ESTAS reports with old data model and rewrite the reports by using new data model.

Involved in peer review of Initial Design Document prepared by other team members.

Created packages to extract data by using framework manager.

Developed the reports by using Functions, Prompts and Calculations.

Written SQL queries for Data validation across Cognos reports data.

Implement the reports in production environment.

Environment

Cognos 10.0, Framework Manager, SQL Server 2008

Syngenta Business Intelligence Reporting – Bangalore (India) BI Developer, Apr 2012 – Dec 2013

Project Description

Syngenta provide products and solutions to help farmers achieve global food security for a growing population, sustainably. Syngenta work by looking at agriculture through the eyes of growers, and by applying world-class science to develop crop protection products and seeds.

Syngenta innovations help farmers to overcome multiple challenges – from weeds, insects, and disease to the effects of heat and cold on crops. Whether they grow corn or rice, vegetables or coffee, farmers around the world trust Syngenta to help them produce healthy, premium crops and minimize the use of precious natural resources.

Responsibilities

Involved in creating reports Design Documents.

Creating connections between BW system and Business Objects using IDT.

Developed the reports using the BEX query.

Developed Web Intelligence Reports using advanced BO features like Document Links, Element Links, Input Controls.

Published Reports to Business Objects Repository [BI Launchpad].

Involved in testing, performance tuning and troubleshooting the errors while developing the reports and reduced the complications of report delivery.

Migrated the reports from development to Quality, Quality to production environments using Promotion Management in CMC.

Published Dashboards to SAP Portal and Business Objects Repository

Created the reports in SAP OLAP workspace analysis tool.

Environment

SAP BO 4.0, Dashboard Designer, SAP OLAP Workspace Analysis Tool, BEX Query (SAP BW)

Canadian Pacific Railways Project – Bangalore (India) BI Developer, May 2011 – Mar 2012

Project Description

Canadian Pacific Railway was founded in 1881 to physically unite Canada and Canadians from coast to coast.

This is the Canada's second largest company. CPR's network extends from the Canada's West to the Canada's East, and to the U.S. industrial centers of Chicago, Washington, and New York cities.

Responsibilities

Monitored critical reports in Instance Manager in CMC, found out the route cause whenever jobs fail and rerun the jobs.

Monitored Servers in Server Management in CMC.

Monitored Servers in CCM and Restart servers whenever required.

Created Users, Groups and provides the access securely.

Successfully handled jobs monitoring, servers monitoring and maintenance.

Involved in Universe enhancements.

Involved in reports enhancements.

Environment

SAP BO 3.1, Universe Designer

EDUCATION

Bachelor of Technology in Electronics and Communication Engineering

Contact this candidate