Management Data
Resume:
Vijay Arra
**************@*****.***
Highly qualified Business Intelligence Developer having over 7 years of
software development experience within several business areas.
Results-focused with proven ability to plan, design and develop quality
software solutions to support reporting and Business Intelligence
initiatives. A trainer and leader with strong communication skills and the
ability to solve complex problems, lead development teams, improve data
management and integrate systems.
. Extensively worked as a Business Intelligence Developer on Data
Warehousing projects. Worked on installing and configuring BI Tools,
developing reports, universes from various databases Oracle, DB2, SQL
Server and Teradata.
. Expert in creating database semantic layers (Universes) and developing
Decision support Reports using Business Objects, Desktop Intelligence,
Web Intelligence and Crystal Reports.
. Experience in designing and developing the Universe (business view of the
database), developing canned/ad-hoc reports, scheduling the processes and
administering the BO activities.
. Efficient in Optimizing, Debugging and testing SQL queries and stored
procedures written in Oracle, DB2, Teradata and SQL Server.
. Good communication skills, strong decision making skills, organizational
skills, and customer service oriented. Excellent analytical and problem
solving skills, Good Technical writing skills.
. Expert in designing Disaster Recovery and Performance optimization
techniques.
. Experienced in applying patches/fixes & performing Upgrades, environment
sizing, Performance tuning & troubleshooting.
. Very strong in Client/Server Architecture, Relational Databases (RDBMS),
Data Modeling and Design and build the Data Warehouse, Data marts using
Star Schema and Snow Flake Schema for faster and effective Querying for
the Metadata Management solutions.
. Good experience in Performance and Memory utilization analysis.
Core Competencies
Complex Multi-source Reporting Team development and public speaking
Analysis SQL Server, Oracle, Teradata, Ingres
Business Intelligence / Enterprise and DB2 SQL and DB Management skills
Reporting Embedded systems design
Service Oriented Architectures and Data warehousing and business process
Web Services integration
Multiple level repository Semantic layer (Universes and metadata
migration and maintenance. layer) creation
TECHNICAL SKILLS:
BI Tools: SAP Business Objects (XI R2/XI 3.1/4.0/4.1), SAP Information
Design Tool, SAP Universe Design Tool, SAP BW, BEx Query
designer, BEx Analyzer, Central Management Console,
Lifecycle/Promotion Management, Upgrade Management Tool,
Desktop Intelligence, InfoView, Web Intelligence, Crystal
Reports (10/XI/2008/2011/2013), Crystal Reports Enterprise
4.0/4.1, Xcelsius (2008), SAP Dashboards, SAP Design
Studio, SAP Information Steward, SAP Lumira, Oracle BIEE,
SSIS, SSRS, Qlikview 10.x/11
Operating Systems: UNIX (HP, Solaris, AIX), Windows 9X/2KX/NT/2008/2008
R2/ 2012, Linux (Red Hat)
Databases: Oracle10g/11i, Teradata, DB2, SQLServer and MS Access
Database Tools: TOAD, Rapid SQL, SQL Developer,
Other Tools: HP Application Lifecycle Management 11, SQL*Plus, MS
Office XP, MS Visio, MS Project,PowerTerm, Visual Terminal,
Putty
Programming Languages: C, C++, SQL, HTML and PL/SQL
Web Servers: Tomcat, BEA Web Logic, IBM WebSphere, Microsoft IIS
ETL Tools: SAP Business Objects Data Services XI 3.1/4.0/4.2, Data
Integrator XI
EMPLOYMENT HISTORY:
Indian Health Service, Albuquerque, NM
Feb 2014 to till date
Role: Business Objects Developer
Technical Environment: SAP Business Objects Enterprise XI 3.1/4.1, Crystal
Reports 2008/2011, Crystal Reports Enterprise 4.1, SAP Dashboards/ Design
Studio, SAP Lumira, SAP BO Explorer, SAP Information Steward, DB2 8.x/9.x,
Web Intelligence, BO SDK, DB2 Connect, TOAD, RazorSQL, Performance
Management, QAAWS, Windows server 2008 R2/2012.
Responsibilities:
. Leveraged Business Objects tools to make best use of resources and
ensured optimum performance of the tool.
. Defined architecture standards and best practices for BO implementation
and conceived reusable frameworks for BO and get them developed.
. Performed technical and advisory functions in the development of business
objects architecture and the creation of frameworks for reporting,
dashboards, delivery, scheduling and object retention policies for
complex information systems.
. Created and supported the infrastructure for a business Objects
Enterprise systems spanning several clustered environments.
. Documenting user requirements, translating requirements into system
solutions and develop project plan.
. Performed tuning on the Business Objects Enterprise performance and
implemented the load balance on the servers.
. Used Crystal Reports to create reports that connect to Business Objects
Universes with minimal effort.
. Work closely with Data Architect, ETL, infrastructure and DBA resources.
. Designing and building simple, complex, ad-hoc and compound reports in
all possible formats using Business Objects tools.
. Created multiple Universes for ad-hoc and canned reports based on the
relational data model that will replace the existing Stored Procedures as
the data sources.
. Converted Crystal reports to Web Intelligence reports. Created multiple
Universes with aggregate tables and increased the performance of the Webi
reports.
. Converted around 30 crystal reports to use crystal reports enterprise.
. Designed Universe semantic layer, data model and OLAP cubes for
Performance Management and Reporting needs.
. Responsible for universe and Web intelligence Reports, development and
deployment.
. Solved schema-designing problems by creating aliases, defining contexts
and using features available in Designer to separate queries on measures
or contexts
. Implemented the Index Awareness and Aggregate Awareness for faster query
responses and thereby improving the report performance.
. Implemented Object and row level security in Universe to incorporate
security at Business level.
. Demonstrated Web intelligence tool's strength by enhancing the report
performance.
. Oracle 10g/11g, Db2 9.X, sql server databases and Solaris/Unix
environments.
. Created Master/Detail Reports, Cross-tabs, Charts and Applied slice-and-
dice, implemented different level of hierarchies for drill techniques.
. Developed and tested the reports based upon data generated by IHS
transaction and customer information systems using Crystal Reports.
. Providing quick reporting solutions across the team and writing UT test
cases for testing team.
. Performed QA on the reports, data to make sure they are on par with the
reporting specifications.
. Involved in conversion of Crystal Reports using stored procedures and
views to the reports using the new universes created.
. Converted the desktop Intelligence reports to web Intelligence and
increased their performance to max by creating Aggregate tables and
creating multiple Universes.
. Worked with Business Users on regression testing the Enterprise Reports.
. Implemented Data Quality Monitoring and Metadata Analysis using SAP
Business Objects Information Steward.
. Created Data Visualizations and Dashboards using Qlikview, SAP Lumira,
SAP Design Studio and SAP BO Explorer and demonstrated the differences
and the power of each tool to the users.
. Rendered visualizations in Lumira using data from HANA data source for
the POC project.
. Created interactive dashboards and reports to users in SAP Design Studio
by connecting various data sources.
. Handled all administration activities like Server Installation, managing
sites, users, groups, projects, schedules, security, extracts,
subscriptions and installations.
. Created multiple Dashboard Projects, worksheets and Custom Views as part
of Design Studio content.
. Developed complex high visibility dashboards using SAP Design Studio to
monitor standard KPI metrics. Developed single and multiple dashboards
and scorecards.
. Built static Dashboards with the data in Excel files.
. Optimize and improve the performance of existing data warehouse and BI
applications.
. Conducted user end training to the users to make them understand the data
models, building queries using Universe and use the Business Objects
tool.
PepsiCo, Winston Salem, NC
Oct 2013 to Feb 2014
Role: Business Intelligence Developer
Technical Environment: SAP Business Objects Enterprise XI R2/4.1,
Lifecycle/Promotion Management, Upgrade Management Tool, InfoView, BI
launchpad, Business Objects Central Management Console, Crystal Enterprise
XI/2008/2011, Xcelsius (2008), SAP Dashboards,DB2 9.x, Oracle 10g/11, Web
Intelligence, DB2 Connect, RapidSQL, HP Application Lifecycle Management
11, Windows 7.
Responsibilities:
. Designed and implemented the security model for the Business Objects BI
4.1 and Crystal enterprise environments.
. Designed new Access Levels in SAP BI 4.1 environment to implement user,
application and folder level security on Central Management Console
(CMC).
. Migrated Business Objects Enterprise XI R2 environments to new SAP
Business Objects 4.1 environments using Upgrade Management Tool.
. Upgraded 400+ existing Crystal Reports to Crystal Reports 2011 in Crystal
Enterprise XI release 4.
. Re-written the Oracle/DB2 stored procedures that were used in the ETL
processes for daily data load.
. Interacted with Business Users and Business Analysts to gather and
document the requirements and translate these to Technical specifications
for designing Universes.
. Implemented Object and row level security in Universe to incorporate
security at Business level.
. Developed, Tested, Promoted and Maintained the Web Intelligence Reports,
also had modified the existing reports based on user requirements.
. Re-created the reports from scratch in Crystal Reports 2011 which have
performance issues.
. Worked on Performance improvements for the existing Crystal and Webi
reports.
. Worked on SAP Information Steward 4.0, Data Quality Management, Metadata
Management, Data Profiling and, Data Quality.
. Configured Metadata Manager to read and analyze large volume of BOE
metadata.
. Developed Xcelsius/SAP Dashboards presentations, visualizations for
profitability Analysis, Distributor Sales Analysis, Monthly Sales
Analysis, Forecasted Sales What if Analysis.
. Interactive visualizations were made for executives to visually evaluate
different scenarios by adjusting key variables.
. Built multi variable what-if analysis bar charts for all information at
one glance about all product lines of the company.
. Followed best principles and made some major workflow changes and
successfully reduced Dashboard load times.
. Scheduled the reports to the users, gathered the feedback from them and
made changes as per the requirements.
. Monitored, provided production support and application maintenance for
Crystal Reports 2011 deployment.
. Performed regression testing for all the reports and documented the
changes.
Intercontinental Hotels Group, Atlanta GA
Jan 2010 to Oct 2013
Role: SAP Business Objects Developer
Environment: SAP Business Objects BI 4.1, Information Steward,
Lifecycle/Promotion Management, Upgrade Management Tool, Business Objects
Enterprise XI R2/ XI 3.1, SAP Dashboards (Xcelsius 2008), Qlikview 10.x/11,
Live Office, QAAWS, Business Objects Data Services XI 3.1, Oracle 10g/11i,
SQL Sever 2005, Tomcat, PL/SQL, SABA LMS 7.0, Crystal Reports 2008, Web
Intelligence, SQL Developer, TOAD, Windows NT/2000.
Responsibilities:
. Implemented Full life cycle: Design, development, deployment and support
in developing rich professional dashboards to present operational HR data
using SAP Xcelsius.
. Designed and implemented the security model for the Business Objects BI
4.1, BOE XI 3.1 and Crystal enterprise environments.
. Migrated Business Objects Enterprise XI 3.1 environments to new SAP
Business Objects 4.1 environments.
. Designed Logical Model and database objects. Developed Semantic Layers
with UDT/IDT, Dashboards and Reports.
. Created SAP Business Objects Web Intelligence, Crystal Reports based
reports and customizations.
. Created Rich web based reports in online and offline mode with highly
flexible query capabilities like Queries and sub queries, Report filters,
freestyle input, Query enhancements and Alerting.
. Monitored, provided production support and application maintenance for
SAP Xcelsius deployment.
. Developed rich professional dashboards to present operational HR data.
. Implemented What if scenarios and simulations for comparisons and
transformed Complex business data into simple actionable visual
presentation.
. Created compelling dashboards with usage of country maps, charts, graphs,
knobs, animation of data sequences and rich imagery.
. Implemented Xcelsius dashboards distribution, publication, SAP BO
Xcelsius security and report authorizations.
. Involved in conversion of existing Xcelsius dashboard to Qlikview
dashboard.
. Identified data sources and prepared data for Qlikview dashboards.
. Designed, created and maintained Qlikview applications.
. Developed Qlikview Scripts to build model across multiple data sources.
. Designed SAP Business Objects Data Services workflow package and built
static Dashboards using Crystal Xcelsius 2008 with the data in Excel
files.
. Created reports for SABA LMS 7.0 cloud using the Crystal Reports, SABA
Adhoc Reporting, SABA Analytics and the Data Exports.
. Used Business Objects Data Services XI 3.1 in creating various processes,
data flows, and Data Marts.
. Developed SQL and PL/SQL scripts to implement business logics of database
through Stored Procedures.
. Worked on enhancements to existing reports, creation of new reports in a
productive SAP Business Objects instance as part of post-implementation
support.
. Worked with Business Users on regression testing the Enterprise Reports.
. Effectively prepared and customized the training documents, White papers,
Best Practices, Template documents.
Hillsborough County Public Schools, Tampa, FL
Mar 2009 to Jan 2010
Role: Business Intelligence Lead
Environment: Business Objects Enterprise XI 3.1, Business Objects Data
Services XI 3.1, SAP BW, SAP FI/MM/SD, BEx Query designer, BEx Analyzer,
Crystal Enterprise 10, DB2 8.x/9.1, SQL Sever 2005, Tomcat, Weblogic, CA
Datacom, PL/SQL, Crystal Reports 10/2008, Web Intelligence, BO SDK,
WebiSDK, DB2 Connect, TOAD, Performance Management, Xcelsius 2008,
QAAWS(Query As a Web Service), Lawson ESIS, Windows NT/2000,UNIX(HP), MS
Project 2007.
Responsibilities:
. Supported the infrastructure for a Business Objects Enterprise system
spanning several clustered environments and supporting ~6000 users. This
includes support for Business Objects XI 3.1, and covers many SAP
Business Objects products including: Crystal Reports (with Business
Views), Web Intelligence, Performance Management, and Crystal.
. Involved in a huge migration effort from Crystal Enterprise 10
environments to new Business Objects XI 3.1 environments that included
conversion reports. Created and maintained Enhancement, Bug tracking and
Bug fix documents.
. Designed and implemented the security model for the BOE XI 3.1 and
Crystal enterprise environments.
. Used Business Objects Data Services XI 3.1 in creating various processes,
data flows, and Data Marts.
. Developed SQL and PL/SQL scripts to implement business logics of database
through Stored Procedures.
. Involved in the design/development of ETL and batch load data processes.
This included design and development of efficient Star-Schema designs to
support Enterprise and Customer Specific Data Marts.
. Assisted the team with training, design and architecture of day to day
and project tasks.
. Worked on performance tuning the various jobs and workflows.
. Created Business Views and Universes for canned reports based on the
relational data model and exported to repository. Implemented row level
and object level security within the universe.
. Developed complex high visibility Xcelsius dashboards to monitor standard
KPI metrics. Developed single and multiple dashboards and scorecards.
. Built static Dashboards using Crystal Xcelsius 2008 with the data in
Excel files.
. Extensive experience with SAP BW such as Info cubes, BEx Query designer,
BEx Analyzer, Data Modeling.
. Responsible for detailed knowledge of data coming from SAP modules: FI,
SD, MM.
. Used BEx Analyzer and Query Designer to Query and analyze SAP BW OLAP
Cubes.
. Designed the BEx Queries in the BW Environment.
. Extensively used BEx analyzer to create queries, variables, filters,
calculated key figures, restricted key figures, charts and workbooks.
. Built Xcelsius Dashboards with SAP BICS Connector using SAP BW Queries to
get data from SAP BW.
. Developed Crystal Reports from SAP BW (Business Warehouse) using BEx
Query as the extraction tool.
. Created Dash boards for the top level Management using SAP BW (Bex
queries).
. Developed flexible queries using filters, navigational attributes in BEx
Analyzer to facilitate data analysis in a drill down or summarized way to
give detailed levels of information.
. Worked on Bex Analyzer to test the above mentioned Xcelsius Dashboards,
Webi Reports & Universe, to verify & test the Consistency of data all
throughout the SAP BW & SAP BOBJ Platform.
. Updated the static models with live data connecting via the Web Service
connectors like QAAWS.
. Created complex reports using the multiple data providers and reports
including sub-reports, graphical reports, formula base and well-formatted
reports according user requirements.
. Developed Live Office functionality, presentation layer and worked on
navigation.
. Trained Power users/End users to use the tool and create Ad-hoc business
objects reports.
Turner Broadcasting Systems, Atlanta, GA
Feb 2008 to Mar 2009
Role: Business Intelligence Developer
Environment: Business Objects (XI/XI R2/XI 3.1), Oracle 10g/11i, Teradata,
PL/SQL, Crystal Reports XI, Web Intelligence, Embarcadero Rapid SQL,DB
Artisan, TOAD, BTEQ, Data Integrator XI, Performance Management
(Dashboards), Windows NT,UNIX.
Responsibilities:
. Directly coordinating with user to gather the new requirements and
working with existing issues.
. Plan, Coordinate and execute Business Objects XI/XI R2/XI 3.1 deployment
for End users.
. Created Universe for ad-hoc and canned reports based on the relational
data model and exported to repository.
. Implemented Object and row level security in Universe to incorporate
security at Business level.
. Managed User, Group and Object-Level Rights, Scheduling, Security
Settings, Universes, Data Connections, User and Group creation using the
Central Management Console.
. Created Cardinalities, Contexts, Joins and Aliases for resolving Loops
and checked the Integrity of the Universes.
. Created Dashboards to monitor business performance, insightful analytics
and role-based dashboards using Business Objects Xcelsius. Created Query
as a Web Service on top of relational databases, created excel functions
and linked dashboards
. Created various reports with multiple data sources, dynamic crosstabs and
drilldowns using Crystal Reports XI, DeskI and WebI.
. Migrated all the reports, universes and security setting from Business
Objects XI R2 to XI 3.1.
. Created dashboards using different analytics like Interactive Metric
Trends (IMT), Speedometers, Metric Trees, Maps, Pareto Charts and Traffic
Lights across the sliced metrics.
. Created Aggregated Tables at various levels in the universe to improve
the performance of the reports and the dashboards and wrote the stored
procedures and packages at the back end for these aggregated tables.
. Created/enhanced catalogs and set user profiles to grant user permissions
for querying.
. Used Web Intelligence for web based query and reporting.
. Created complex reports such as Monthly/Weekly KPI reports, User
Conversion and Retention reports, High Usage reports using DeskI and
Crystal Reports XI.
. Created Hierarchies to provide drill down options for the end-user.
. Customized Business Objects Infoview using Business Objects SDK.
. Created and developed Stored Procedures and packages in Oracle and
Teradata.
. Conducted user end training to the users to make them understand the data
models and use the Business Objects tool.
EDUCATION:
Bachelor of Technology in Aeronautical Engineering (Jawaharlal Nehru
Technological University, Hyderabad, India)
Contact this candidate