Resume

Sign in

Lead BI developer.

Location:
Union City, NJ
Salary:
85$ per hour
Posted:
April 20, 2021

Contact this candidate

Resume:

EVVasu Pendyala

256-***-****

adlt7z@r.postjobfree.com

Career Overview

* ***** ** ********** ** software developer providing solutions and prediction analysis to different clientele

Experienced in various Business Intelligence solution tools like SAP Business Objects data suite, Power BI, Qlik and Tableau.

Passionate in Visual story telling using various Business Intelligence tools

Managed multiple teams onshore and offshore to deliver projects within short deadlines

Expertise in SAP Data Services 4.x, SAP Business Objects 4.x(4.0, 4.1,4.2), XI3.1 reporting application along with SAP HANA 1.0 and Data Modeling

Proficient in Business Objects tools – Universe Designer, Web Intelligence, Crystal Reports, Xcelsius, Live Office, Info View, Data Integrator, data federator.

Knowledge on various data visualization and dashboard applications like Power BI, Tableau and QlikSense.

Expertise in QlikSense Development, Architecture, optimization and QlikSense SDLC and governance.

Responsible in building powerful data visualizations for users which also serves as self-service visualizations to look into analytics on the go

Connected different ODBC, OLE DB data sources (SQL Server, Oracle) and flat files to create and schedule different complex reports as per given business requirement by leveraging the basic components of Different kinds of BI Tools.

Have worked against different data bases like Snowflake, Azure, Data lake, Oracle, SQL Server, Sybase, Teradata, SAP HANA

Expertise in Design, Development and Deployment of Reports, Visualizations and interactive story telling using tools like Business Objects, Power BI, Qlik & Tableau

Finding solutions for Corporate reporting requirements and involved in a full life cycle implementation of SAP BI/BO (OLAP/OLTP environments), Power BI & Qlik

Worked in all phases of BW/BI SDLC including analysis, design, development, testing, deployment, post-production support/maintenance, documentation and end-user training.

Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable

Good Communication and Interpersonal skills. Technically depth, Result-Oriented with strong Problem-solving skills. Innovative & efficient. Capable of working as a Team Member or Individually with minimum supervision

Technical Skills

OLAP: SAP Business Objects XI (CMC, Designer, Reporting) 3.1/4.0/4.1/4/2, Web Intelligence XI/3.1/4.0/4.0, Info View, Dashboard Manager, Crystal Reports 2008/2011, Xcelsius, Tableau, SAP Lumira (Discovery/ designer), Power BI (Until December 2020), QlikView (11/12),QlikSense (Nov 2018,Feb 2019, Nov 2019), N printing (Nov 2018,Feb 2019, Nov 2019)

Databases / RDBMS: Oracle 11g/10g/9i, SQL Server 2008/2005, Sybase, Teradata, MS Access, SAP HANA 1.0, Amazon redshift, AWS Cloud, Big data.

Programming Language: SQL, PL/SQL, UNIX Shell scripting, Java Script, NoSQL, Python, DAX, M Query

Data Modeling: SAP HANA Studio, QlikSense, QlikView, Power BI, SAP BODS

ETL Tools: SAP Business Objects Data services 4.0, Informatica Power center 8.1/9.1,

Operating System: Linux, Windows NT/2000/2003/XP/7, Solaris 10, Azure

Educational Background

Bachelors in Electronic and Communication Engineering.

Jawaharlal Nehru Technological University – Hyderabad, India

Maters in Electronic and Computers Engineering.

Southern Illinois University – Carbondale, IL

Work Experience

Sr. Data Visualization Lead

Client: MSA, Pittsburgh March 2019 – Current

Working with Stake holders and collaborating with senior management, subject matter experts, and IT teams to define business requirements

Worked as an Individual and also as a team to create effective stories and content that reach target audience.

Implemented end to end Migration project using Power BI for one of fortune 500 companies.

Handled multiple data analytics projects simultaneously with different environments and databases

Produced Power BI data models and recommended best practices for the creation of reports and graphics/visualizations.

Tune and optimize existing Business Intelligence (Power BI & Tableau) reports and dashboards and re-modelled existing data to suit existing data atmosphere

Created and designed foundation for all Power BI data models flowing through Azure Data bricks and Azure Portal

Maintained data in Azure Portal for cost effective solutions for a long-lasting project.

Data Modeling of new structures per current structures in Data Lake for implementing reporting Structural requirements & New data structure determination

Alignment to Altria Data Lake Coding Standards & conventions

Worked on AD-Hoc reports as well as candid reporting on Live data

Created data analytics in Databricks and Originated the data in different database like Snowflake and ADLS

Created views on Snowflake Database for easy access to large calculations which we would help the performance of the reports / Visuals

Implemented and integrated Power BI with different databases by setting up Gateway connections

Develop and review Preliminary dashboard design with Stakeholders and implement their feedback into scope

Worked on creating new reports and dashboard against databases like Snowflake, SAP HANA using tools like Tableau, SAP Business objects suite (IDT,WEBI)

Environment: Azure Databricks, Azure Data lake storage, Power BI (Until March 2021), Snowflake, SharePoint extracted files, Snowflake, Amazon RedShift, SAP HANA, Oracle, SQL Server, SAP BO 4.2,Tableau.

Sr. Data Visualization Consultant/QlikSense Consultant

Client: Delta Dental of Virginia, VA June’2019-June 2020

Responsibilities

Working Closely with the Business users, Data owners and understand the Business Requirements

Created Data visualization and dashboards in QlikSense while creating data models for different segments of business

Worked for Claims, Underwriting, Billing and different business segments and created reports using Nprinting

Created incremental load process to load the data into QlikSense applications from different source systems

Scheduled the jobs and distributed to end users from QMC.

Experience in database programming, SQL, Tables, Views, Indexes, Joins, and Sub - Queries.

Trained end users to develop and use QlikView and QlikSense applications.

Created QlikView & QlikSense dashboards using different objects like List Boxes, Multi Boxes, Pie charts, Line charts, Funnel charts, Scatter charts, Bar charts, Combo charts, Straight tables, Pivot tables, Buttons, Containers.

Involved in performance tuning of QlikView & QlikSense apps for faster data reloads and efficient response times.

Involved in designing the data models, extract & transform the data from heterogeneous data sources like QVD files, Excel, SQL Server, Oracle, binary QVW, Inline & txt files in creating the QlikSense dashboards.

Handled applications performance tuning, including maintenance & upgrades of applications and systems.

Created an extension to use Nprinting reports accessible directly from QlikSense Apps.

Build ad-hoc reports for business data analysis based on end user requirements & distribute reports to end users

Integrated QlikSense dashboards to different kinds of portals (API’s) to be used by various teams

Developed reports in QlikView and in NPrinting and emailed the reports to end users.

Environment: QlikSense Feb 2018/November 2019, Oracle, Flat files, Excel files, XML files, Microsoft SQL Server, Power BI, Microsoft Azure data lake

Sr. Business Intelligence / Data Visualization Consultant

Client: Penn State Health and College of Medicine, Hershey’s, PA December’2018-June’2019

Responsibilities

Working Closely with the Solution Manager, Business users, Data owners and understand the Business Requirements

Worked on the existing Data warehouse to understand the existing business views and database schemas/ETL Process

Arranged walkthrough sessions with the user group and to confirm that all the requirements have been captured and obtained sign off on the requirements documents.

Prepared detailed Business requirement documentation, including the Technical speciation’s mapping the functional requirements to BOBJ technical fields.

Worked on updating the existing universes, adding additional Views, contexts/alias tables, adding more objects to the business layer

Created several complex Tabular and Graphical AD-HOC reports using WEBI application on top of the existing universes to report Daily/Monthly data

Extensively used combined queries, multiple queries complex query filters to retrieve data from multiple universes and fetch the results to present the user requirement (stories) as valuable effective reports

Designed and implemented the Incremental Loading using QVDs so that instead of reloading the entire data from the database, QlikView would only load the data worth of one day and concatenate it to the Old Data which is already stored in QVDs.

Embedded QlikSense based application to web pages and social interaction websites

QlikSense app performance optimization.

Performance tuning by analyzing and comparing the turnaround times between SQL and QlikView /QlikSense.

Developing the QlikView and QlikSense environment and supporting the business decision process.

Creating NPrinting Reports with Dynamic PowerPoint, Excel with Disclaimers, Pixel Perfect PDF output and generating emails, News-Stand and Report for Hub.

Configuring NPrinting On Demand Extension object using Extension Objects in Qlik Sense.

Created multiple workspaces and dashboards for migration review as first set from organization

Implemented Power BI from scratch for CTO to help estimating new project to plan scope for migration

Handled multiple business units with their various requirements on the go with different data sets.

Migrated major dashboards from Qliksense and SAP to Power BI

Environment: SAP Business Objects 4.2 SP6, Information Design Tool, QlikSense /QlikView 12, SAP Lumira 2.0, Web Intelligence, Oracle 11g and Windows, Power BI

Lead Business Intelligence Consultant

Client: Bayview Asset Management, Miami, FL March’2017 – December’2018

Responsibilities

Implemented WebI Geo Maps feature from BO 4.2 to provide a list of loans with property information all over US

Linked multiple universes using IDT in 4.2 to facilitate MSP, RAMM, Service Live etc. environments to create Adhoc reports.

Extensively involved in developing Webi report publications, scheduling and monitor publications.

Experience with writing, debugging and performance tuning SQL queries using Toad and Oracle SQL Developer.

Defined contexts, aliases and used multi parse SQL in the universes to address loops and traps in order to support Ad-hoc and canned reports.

Work with business users and stake holders to understand the business requirements for an application and recommend best analytical solution based on reporting technologies available

Designed and building Semantic layers in SAP BO Universes under Data warehouse environment, developing complex canned reports and maintaining Security with SAP Business Objects

Perform data analysis on business needs and extract data mappings with respect to data warehouse

Interacted with end users in gathering requirements for various Real estate business areas: RAMM, Marketing, Live service, Full service, Component vs. Non-Component etc.

Create complex, innovative and intuitive visualization dashboards using variety of reporting technologies available and take them through full life cycle development.

Worked on QABDI implementation and created many dashboards and visualization as backend

Developed account specific reporting packages for client's customers to track their spending on employee insurance.

Enhancement of existing reports to improve performance by modifying the SQL code used in extraction of data. Involved in designing of QlikView solutions & full lifecycle implementations

Develop efficient QlikView data models using flat files, SQL 2005, MS access and Oracle

Setting up of tasks, reloading data and refreshing the applications on a scheduled basis using QlikView Management Console

Implemented section access for the applications

Developed User Interactive Sheets & Reports as business needs.

Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks.

Environment: SAP Business Objects 4.2, Universe Design Tool, Information Design Tool, SAP Lumira(designer/discovery), Web Intelligence, Tableau 9.X/10.X, SQL Server, Oracle 11g and Windows.

Sr. Business Intelligence Developer

Client: Lincoln Financial Group, Philadelphia, PA August 2012- Feb’2017

Responsibilities

Sr. SAP Consultant working on multiple projects as Business objects and Crystal report developer

Involving in business requirement gathering from the SMEs and report users

Implemented IBM DB2 database and Oracle 11g as the data source for Crystal Reports and BO Universe

Very good experience in BO development, Universes, Webi reports, infoview and crystal reports.

Experience in migrating the data into HANA DB

Involved with the clients to understand the business needs and coordinated with the team to achieve the needs of the business

Used HANA views (Calculated views) as source data for Lumira Reports and Dashboards

Worked on complicated Crystal reports involving Cross-Tab and Sub-reports using the two data sources

Demonstrated Business Objects BI 4.0 and Crystal Reports Enterprise to Business Users

Involved in designing and building of Universes, Classes & objects

Developed derived tables in designer to enhance the capabilities and performance of the universe

Creating local and central repositories as per client requirements.

Setup, execute, and test the assigned programs utilizing BO XI 4.0 Webi and DeskI tools

Implemented IBM DB2 database and Oracle 11g as the data source for Crystal Reports and BO Universe

Developed simple to complex report from SYBASE, ORACLE database and SAP BW using Hyperlink, Rank, Combined Queries, and Merged Dimension.

Created both single and multi-source universe using IDT Created restricted or custom LOV’s in the universe objects as per the request from the user community

Worked along with QA team to get the SIT and UAT process to be complete align with Unit Testing and perform code review

Working with User for requirements and part of the team developing the software.

Consistently attended meetings with the client subject matter experts to acquire functional business requirements.

Developed case studies to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting.

Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.

Use of Set analysis and aggregation functions for sheet objects.

Environment: Windows XP/7, IBM DB2, Oracle Database, Microsoft SQL Server 2008 R2, Sybase 12.X, SQL Developer, Microsoft SQL Server management studio, SAP Business objects 3.1/4.0/4.1 SP6, WEBI, Crystal reports, SAP HANA 1.0, SAP BODS 4.0, Design Studio, Xcelsius, QlikView /QlikSense, SAP Lumira, Bex-Analyzer

Sr. SAP Business Intelligence / Crystal Reports Developer

Client: Volkswagen Group of America, Auburn Hills, MI June 2011- August 2012

Responsibilities

Designed complex SAP BO Universes both in OLTP Data warehouse and OLAP environments

Involved in migration of Users, Groups, Universes, Personal Folders, Connections, Reports (Deski & Webi) from XIr2 to XI3.1 using Import Wizard

Experienced in installation, configuration and setting up the security from the scratch in the new environment (BO XI3.1)

Created new Universes from scratch to build reports in DESKI, WEBI and crystal and modified the existing Universes for performance in Business Objects XI 3.1

Involved in on site off shore models and managing off site work queue and status monitoring

Created universes against a BEx report using Information Designer (IDT)

Performed GAP Analysis between old and new data models to improvise performance

Created BO Business Intelligence Archive Resource (BIAR) files for backup and moving BI content from Development to Testing and Production environments

Designing and developing enterprise level Crystal reports to support multiple projects and business lines – developed command level, universe sourced and spread sheet sourced crystal reports.

Created crystal reports using pivots tables, groups, sub groups, complex formulas involving logic, running totals, parameters, stored procedures, and charts, cross tabs in both commands based and linked tables.

Experience using Business Objects migration (import) wizard and BIAR files to migrate reports across multiple environments –Dev, Test and Prod.

BO Performance Tuning- Optimized performance at Universe, Report, Database & Server levels

Involved in post-production support of existing crystal reports, WEBI and modifying them to make business logic changes - used Mercury Quality Center and Service Center.

Configured single sign on windows AD authentication for logging in business users

Integrated Crystal Xcelsius dashboards with Business Objects Universe using QAAWS.

Designed complex Scorecard and Dashboard and live Office in Xcelsius

Environment: Oracle Database, SQL Developer, Microsoft SQL Server management studio, WEBI, Crystal reports, Xcelsius, SAP Data Services 4.0 SP1 (Designer, Repository Manager, Management Console, Server Manage) SAP Business Objects 4.0 Suite, SAP R3, SQL Server 2008, Oracle, MS Access 2007, Windows 7, Windows NT.

Business Objects Developer / Crystal report Developer

Client: Verizon, Ashburn, VA August 2009 – May 2011

Responsibilities

Involved in the prototyping, effort estimate, User acceptance testing and user support phases of project development

Worked on Data Marts and extensively on modules CMC, Designer, Web Intelligence, Desktop Intelligence, Crystal, Crystal Xcelsius, Auditor, Infoview, Import Wizard & Report Conversion Tool

Used aggregate awareness, short-cut join, @ functions, Derived Tables at Universe Level for Query performance Enhancement

Resolved loops and traps using aliases and contexts. Created complex joins like outer joins and equi-join & theta joins and checked the integrity of the Universes

Created Complex Reports by using multiple data providers to combine 3 reports as a single Report in Deski, Webi and Crystal.

Experience in creating Dashboards using metrics and Analytics.

Responsible for building Dashboard Universe(s), Metric Reports for check points on Service Level Agreements, Predictive Analysis etc

Used JAVA SDK to customize the Infoview login page with the logo and user description according to the user requirement.

Experience in creating Xcelsius Dashboards from Microsoft Excel as a data source

Developed Reports with Parameters, Sub-Reports, Cross-tabs and Charts based on Stored Procedures and Queries by using Crystal Reports

Sound Knowledge of logical and physical database design including Normalization and Entity Relationships (ER) diagrams

Involved in performance tuning of Business Objects Full Client and WEBI reports

Plan and write test cases based on the requirements or defects corrections, supervise their execution by the testing team, perform complex and sensitive tests

Involved in training the end user from Japan in basic and advanced Adhoc reporting as well as to create queries, format results, and share them with others within the enterprise in Japan

Environment: Microsoft SQL Server management studio, WEBI, Crystal reports, Xcelsius, SAP BODS 3.1, SAP Business Objects BI platform XIR/3, SAP Business Objects Data Services 4.0, SAP R3, SQL Server 2008, Oracle, MS Access 2007, Windows 7



Contact this candidate