Resume

Sign in

Sr BI Consultant

Location:
Ashburn, Virginia, United States
Posted:
February 22, 2018

Contact this candidate

Resume:

Praveen Reddy Nukala

Email: ac4knw@r.postjobfree.com

Cell: 703-***-****

SUMMARY

Over 12 years years of experience in Implementation and Maintenance of Business Intelligence, Data Visualization, Analytics, Data Management, Data Integration in multiple environments.

Strong Skills in Business Objects including the Installation, Configuration and Maintenance of Business Objects 4.2/4.1/XI 3.1/R2/6.x/5i, Web intelligence 4.2/4.1/XI 3.1/R2/6.x/5i, Performance Manager and Dashboard Analytics.

Strong experience in carrying Functional, Integration, Latency, Performance, reliability testing for various Business Objects Enterprise suit products

Strong hands on experience implementing dash boarding, data visualizations and analytics using Tableau

Extensive experience in Tableau and SAP BO Suite.

Extensive experience in working with Tableau Desktop, Tableau Server and Tableau Online in various versions

Expertise in using Universe Designer over BEx queries and InfoCubes to migrate & model data from BW to BO for reporting. Excellent skills to develop reports using WEBI

Have software development life cycle experience using VB, Oracle, SQL Server, and MS-Access.

Understand and evaluate dimensional data models and corresponding corporate standards and procedures. Excellent analytical and problem solving skills.

Involved in BO Administration and Performance Tuning Knowledge of Publisher, Auditor and Business objects software development kit (SDK).

Good understanding of Data Warehousing concepts.

Well versed with system development life cycle methodologies.

SKILL SUMMARY

OS: UNIX, SOLARIS10, Linux RedHat, Windows NT/2000/98/95/3.1

Databases: Oracle7.x/8.1/8i/9i, DB2, HANA, SAP BW,SQL Server 2005, MS Access.

ETL: Informatica PowerMart 5.1/ 4.7, Power center 5.1, Data Integrator.

BI Reporting Tools: BOE3.1, BOE4.0, Webi 6.x/XIR2, Performance Management and Dashboard Analytics, Crystal Reports JASPER 0.3.2, Design Studio, Lumira, Tableau, IDT, UDT

Business Objects XI R2 Enterprise Suite, Crystal Reports, (Central Management Console (CMC), Import Wizard, Universe Designer)

Database Skills: Stored Procedures, Database Triggers, and Packages.

Languages: C, SQL, PL / SQL, VBA, UNIX Shell Scripting,

Design Tools: Erwin, Oracle Designer / 2000

GUI: Developer/2000, Visual Basic, Tomcat, JBoss, Websphere

Internet Tools: HTML, DHTML, JavaScript, VBScript, XML

PROFESSIONAL EXPERIENCE

Title: Sr. BI BO Consultant June 2010 – Dec 2017

Client: IRS (Internal Revenue Services), Lanham, Maryland .

Goal is to promote Business Intelligence strategies within IRS, and achieve mutual benefits between project offices and business intelligence core competent center.

Played a lead role in managing migration projects as well as multiple level repository migration and maintenance.

Installed and configured BOE 4.2/4.1 on Solaris platform and Linux RedHat and migrated the existing content from BOE 3.1 to BOE 4.2/4.1

Configured overall BOE 4.0 system environment including capacity analysis and planning, performance tuning, auditing, and optimization.

Installed cluster environment on 4 nodes and mounted FRS storage on Veritas Cluster. Managed and configured clusters between the Servers for the failover on Tomcat web tier and application tier

Using BO SDK analyzed BO repository before and after migration.

BOE3.1 >> BOE 4.0 migration of multi-cluster/multi node infrastructure.

Resolved various issues with databases connections, IDT, UDT and promotion manager

Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server

Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.

Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization.

Designed and developed the most suitable User Interface such as Dashboards, multiple charts types,Trends, custom requests for Excel Export and objects for Management Dashboard reporting using Power Pivot.

Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports

Designed and developed dashboards for KISAM system performing statistical analysis to identify trends

Analyze operational performance and make configuration adjustments as necessary.

Designed, developed and maintained Tableau functional reports based on user requirements.

Developed Tableau data visualization using cross tabs, Heat maps and other charts to support the user requirements.

Trained the Business Users in report creation and also new features of Business Objects 4.2/4.1

Supported PPM Resource management team to design and develop universe and reports

Resolved issues with IDT and database connections to support the project requirements.

Environment: Business Objects 4.2/4.1, Web Intelligence 4.2/4.1, Tableau 9.2, CMC, Oracle 9i,10g, Linux, Teradata 14 and Windows NT.

Title: Sr. Business Objects Consultant Oct 2008 – June 2010

Client: Tetra Tech Inc, (FAA – Contract), Arlington, Virginia .

As a Business Objects Administrator, Installation upgrade and migration are the main responsibilities at FAA.

Installed Business Objects XI R2, Crystal Reports, CMC and Web intelligence XI R2.

Upgraded all the three environments from BOXIR2 to BOE3.1 and configured and deploying application on Oracle application server as primary web Server. Evaluate the effectiveness of disaster recovery exercises affecting Business Objects.

Played a lead role in managing migration projects as well as multiple level repository migration and maintenance.

Analyze operational performance and make configuration adjustments as necessary.

Configured LDAP to sync with the SSO Authentication.

Managed and Configured clusters between the Servers for the failover

Used the Import wizard to migrate reports, universe and categories from staging to production servers.

Created complex canned and Ad-Hoc reports with different data sets to meet the requirements using Web Intelligence.

Customized reporting home page using java application for users to run Web Intelligence reports.

Trained the Business Users in report creation and also new features of Business Objects XI

Prepared test cases for the created WEBI and Dashboard reports that incorporate application business rules for QA team to perform testing before rolling to production.

Worked with Business Objects CMC module in the process of controlling universe and restricting reports.

Environment: Business Objects XI 3.1, Web Intelligence 3.1,Crystal Reports, Performance Management, CMC, Oracle 9i,10g,TOAD,Solaris and Windows NT.

Title: Sr. Business Objects Consultant Jan 2005 - Sept 2008

Client: Bank of America, St. Charles, Missouri

The main responsibilities are to gather requirements from end users to create new Universe and maintain the existing universe to create Deski, Webi and Dashboard Reports for loan line Call Center.

Interfaced with Management, end users and senior executives regarding business analysis.

Installed Business Objects XI R2, Crystal Reports, CMC, and Web intelligence XI R2.

Installed and configured Business Objects XI R2 using Tomcat and Apache as Java application server and Web Servers.

Managed and Configured Servers (File Repository Server, Report Application Server, Web Intelligence Server, Destination Job Server, Program Job Server, Event Server.

Used the Import wizard to import existing user accounts, groups, categories, WebI documents, universes, connections and universe restrictions to BO XI R2 environment.

Created complex canned and Ad-Hoc dashboard reports with different data sets to meet the requirements using Dashboard Manager and Web Intelligence XI.

Trained the Business Users in report creation and also new features of Business Objects XI

Worked with Mappings, Repositories, Source tables, Target tables, Workflows, Tasks, Workflow Monitor, implementing Business rules/logic and developing strategies for ETL processes using Infomatica power mart.

Scheduled reports to run using SDK VBA Macros to store BO Reports in PDF and Excel Format.

Worked with Business Objects CMC module in the process of controlling universe and restricting reports.

Migrated commonly requested reports and analysis exercise to the Web Intelligence platform.

Environment: Business Objects 6.1x/6.5.1,XI R2 VBA, Web Intelligence 6.x/XI R2, Crystal Reports, Performance Management, BCA, CMC, Informatica power mart, ORACLE 9i,10g, MS Access,,TOAD and Windows NT.

Title: Sr. Business Objects Consultant June 2004 -Jan 2005

Client: Sanofi ~ Synthelabo Research, Malvern, Pennsylvania .

Sanofi is a Number one pharmaceutical company in France, later merged with Aventis and a.k.a Sanofi -Aventis. The Objective of this Project is to gather requirements from the users and convert existing JASPER Reports to Thin Client (WEB I) Reports.

Installed Business Objects 6.1b/6.1.3 and Webintelligence6.x

Analyzed the Data Model, Jasper reports and Requirement Analysis to create a new Universe for the GEDIT Regulatory Users.

Analyze migration strategies for Business Objects Universes and reports across multiple Business Objects Repositories (Development, staging and Production).

Involved in gathering business requirements, logical modeling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.

Designed Universes in two phases, the first phase involved in creating the structure like tables and columns of a database joined by joins and also resolving the loops with Alias. The second phase involved in enhancements of universe like aggregate awareness, context, complex classes, joins and complex nested prompts.

Gathered Requirement Analysis to implement additional changes to the Universe and created complex nested prompts to meet the additional user requirements.

Created templates and 25 new WEBI reports for GEDIT Regulatory Users.

Involved in writing Test Cases and Test Plans for the reports.

Trained End users to create reports in Business Objects.

Participated in Computer Related Systems Validation Process and Change Control Procedure for GV Production Computing Environment - SIS Related Changes.

Environment: Business Objects 6.1b/6.1.3, Web Intelligence 6.x, JASPER0.3.2, Unix, Lotus Notes, MS Access, Oracle, SQL Server 2005, TOAD and Windows NT.

Title: Business Objects Developer Feb 2004- June 2004

Client: Quest Diagnostics, Lyndhurst, New Jersey .

Project: Decision Support System for Human Resource Management Systems

Installed Business Objects5.i/6.1a and Webintelligence2.7/6.0.

Involved in migration of Business Objects 5.1.7 to Business Objects Enterprise 6.1a

Upgrading Universes & Reports from Business Objects 5.1.7 to Business Objects 6.1a.

Involved in adding Translate tables and Views to the existing universe, resolved the loops using Aliases and created user objects to support the end user needs using Designer.

Exported the universes and the reports to the Repository to make resources available to the existing users.

Implemented row level security at the user level, and also made changes in the Addins for effective data row.

Exported Universe across different environments domains from development to Production.

Involved in making changes to the addins using VBA to get the effective data rows.

Environment: Business Objects 5.1.7/6.1a, ORACLE 8i/9i, VBA, SDK and Unix AIX 4.x.

EDUCATION

Bachelors of Commerce (B.Com), 1996, Osmania University, Hyderabad India



Contact this candidate