SUMMARY

• BOBJ developer with 7 years ofexperience in implementing Full Life Cycle Business Intelligence solutions, including requirements gathering, designing, developing the Universes and Reports/Dashboards.
• Experience in using SAP Business objects, Crystal Reports, Tableau and Infographic Tools.
• Experience in development, implementation testing and support for various Data warehousing applications using SAP business objects with CMC, BI Launch Pad, Universe Design tool (UDT), Information design Tool (IDT).
• Developed WEBI Reports/Dashboards/Universes in BI4 Environment.
• Experience in developing Web Intelligence reports using different data sources.
• Experience in using Tableau desktop, Tableau server and Tableau reader.
• Experience in using Tableau desktop power tools.
• Experience in developing dashboards, data visualizations and analytics using tableau desktop and tableau server.
• Experienced in web Publishing and Scheduling, Report Bursting using Broadcast Agent or Publishing wizard.
• Developed WEBI reports using advanced features including Hyperlinks, Input Controls and Merged Dimension.
• Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
• Experience in designing and developing reports, using different features like Drill Analysis, Sections, Breaks, Ranking.
• Created Universes using complex and advanced features from various Database sources including Oracle, Teradata.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Experience in resolving the join issues like Loops, Traps in the Universe, used Alias and Context methods to resolve the loops and traps
• Experience in dimensional data modeling, Star Schema Modeling, fact and dimensional table design, physical and logical data modeling.
• Efficiently mapped business requirements and processes to technical solutions.
• Experience in developing front end pages using HTML.
• Extensive experience in in extraction, transformation and Loading(ETL) of data from different data source systems such as flat files, excel, oracle.
• Experience in using infographic tools like Piktochart, Canvas, Vengage to develop graphical visualizations.
• Commitment towards work and can adapt to new environments.
• Ability to understand and revise group requirements efficiently.

TECHNICAL SKILLS

Reporting Tools: Business Objects 4.0,4.1, Crystal Reports XI/10/9, Central Management Console (CMC), Web Intelligence

Dashboard Tools: Tableau 9,10

Programming Languages: C, C++, Java, HTML

Database: Oracle, Teradata

J2EE technologies: JDBC, JSP, Servlets

Application and Web Server: Apache, Tomcat

IDE & tools: Eclipse, putty, rational rose, text pad, edit plus, SQL plus

Scripting Languages: Java Script, Unix shell script

Operating Systems: Unix, Windows XP/vista

Office tools: Word, Excel, Power point

Infographics: Piktochart, Canva, Vengage

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

BOBJ Developer

Responsibilities:

• Involved in interacting with users in understanding the requirements and interpreting the requirements into report specifications.
• Developed WEBI report to track the special asset delinquent loans sourcing from ACBS and ALS loan systems.
• Developed WEBI report to capture the approved and declined transactions of commercial cards and scheduled the report to send an email instance to users every month.
• Created complex reports using multiple data providers, custom SQL, cross tab, drill down, combined queries, merged dimension, complex functions, filters etc.
• Created complex objects like dimensions, measures and detail objects based on the business requirement.
• Validated and mapped data in the report against the ACBS front end loan system.
• Involved in updating the impacted reports, testing the reports after the front end loan system upgrade.
• Involved in adding new tables, removing tables, replacing old tables in the universe as per the front end system upgrade.
• Implemented changes to the report using the user defined functions like @prompt, @variables, condition objects and aggregate awareness functions for SQL enhancements.
• Involved in working with different database environments and moving of the universes and reports between PROD, DEV, and TEST
• Scheduled the report using the events and parameters for optimal performance of the report.
• Worked on Teradata SQL Assistant for testing and validating the required functionalities of reports.
• Involved in developing the documentation for the commercial reports.
• Developed webpages and portals for commercial banking reporting team.
• Involved in maintenance of the pulseweb pages and portals.
• Worked on upgrade testing of BOBJ 4.1.
• Worked on providing access to the users for accessing corresponding reports and dashboards.
• Worked on Ad - hoc requirements and issues.
• Developed tableau visualizations using scatter plots, pie chart, geographic map, bar charts.
• Created tableau workbooks using formulas, action filters and parameters.
• Involved in analyzing the performance of the tableau dashboards using the power tools and making changes to the dashboard as per the results.
• Involved in maintenance of universes in universe designer.
• Involved in testing GE to HFS conversion by developing and testing BOBJ reports in test environment.
• Developed visualizations using Infographics to represent overall statistics about BOBJ usage, overall statistics about Tableau usage in commercial banking.
• Developed Infographic visualization for Tableaudevelopment life cycle to clearly understand the steps in developing and publishing tableau dashboards.
• Created graphical data visualization using Infographics to represent data more clearly and visually more appealing in understanding the data.

Confidential, Los Angeles, CA

Business Objects Developer

Responsibilities:

• Interacted with clients and assisted in business requirements gathering, including working with end users to interpret functional requirements into report specifications.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business report requirements and provided Several Report Mock-ups to finalize the requirements.
• Converted business requirements (BTRD) to (TDD) technical requirement documents.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Used designer Information Design Tool (IDT) to create Universes and resolve Join Path Problems utilizing contexts and Alias tables.
• Created linked universes and developed Complex reports that involved multiple data providers, Master/Detail charts, cross tab charts and complex variables and calculation contexts.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Migrated universes and reports from SIT/UAT to production using Upgrade Management Tool.
• Maintaining Universes and Reports to multiple Environments (Dev, Test, and Prod) and Promoted the tested content form Development to IT, QA and Production using Life-Cycle Manager.
• Extensively worked with BOXIR4 and BOXI 3.1 for creating complicated reports using LaunchPad and Web Inteligence including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis data reports along with LOV.
• Created and Formatted the Reports as per the Users Requirements using the features in BOBJ like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, @functions and Formulae to analyze the data.
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Used the Drill Down/up function to analyze data and created multiple charts in Reports.
• Created, managed and formatted standard reports, master/detail reports and cross tab reports using Report Manager
• Used ETL tool Informatica when needed for loading data into another Database DB2
• Developed Crystal Reports with Web Elements. Where they use a Custom Function library for Crystal Reports which allows you to easily embed web controls on to the report.
• Worked on Implementing the LOVs, Hierarchy's, Pre-Defined Conditions, Resolving Data Base Connections, Adding new objects to the Universes.
• Worked closely with the end users and user decision makers to develop the transformation logic to be used in Reports.
• Designed Universes using different data sources. And created Derived Tables in the Universe using views and sqls to meet the Reporting Requirements. Scheduled jobs in CMC by Daily, weekly, bi-weekly and monthly basis and export the results in Excel and send the report to the user thru Email.
• Resolved the issues while converting Deski report to WebI by direct workout
• Created different Dynamic Dashboards using Xcelsuis and QlikView for based on states and LOB.
• Worked with Crystal Xcelsius and QlikView for creating simple dashboards and simple crystal reports and convert those in to user interfaces like excel files, PowerPoint representations for better understanding.
• Created Universes and complex reports against huge Oracle and Teradata database.
• Involved in Training the Users in using this robust system.
• Implemented mappings in Informaticapowercenter involving source as flat files, relational tables to load the data to relational target tables using real time extract methods.
• Involved in universe performance tuning and Data Quality

Confidential, Atlanta, GA

Business Objects Developer

Responsibilities:

• Loaded data into Dimensions (manual) and Applications from BW and external sources.
• Performed an initial study of the current reporting application, to finalize the data elements required for reporting.
• Interaction with users & management, performance of analysis, designing, coding, testing & implementation.
• Created Repository for BO development, created Universes and Complex Reports.
• Involved in working with different database environments and moving of the universes and reports between PROD, DEV, and TEST.
• Extensively using Informatica Designer, Server Manager to complete ETL job design and unit testing.
• Extracted data and Developed mappings by using Informatica Power Center Designer.
• Created staging tables using informatica to serve the purpose for the tables in the data mart.
• Created the OLAP Universes on top of BEX queries and generated the WebI reports.
• Created Complex Crystal Xcelsius Reports from the output of Business Objects report data.
• Created Xcelsius dashboards for the (Sales management) application.
• Used QaaWS to provide dynamic functionality.
• Working on creating Universes, Business Intelligence Layer for end users to develop the Adhoc/Canned reports.
• Created user objects including Dimensions, Details, Measures, Filters and Prompts, LOV
• Defined Report Level Ranking, Database Ranking and Alerts in Reports based on the specifications.
• Designed Universes by defining joins, cardinality between tables, linked the existing Universes using Business Objects XI R3.1.
• Configured the Data services to connect to the SAP R/3 BW.
• Created the complex WebI reports such as Cross Tab and Master Detail Reports using the Java Report Panel.
• Worked closely with the end users and user decision makers to develop the transformation logic to be used in Reports.
• Created very complex reports that include multiple data providers, cross-tab, drill up-down, master detail reports, charts/ bar charts / pie charts and VB macro.
• Generated various report templates for standardizing the reports throughout the organization.
• Involved in Training the Users in using this robust system.

Confidential, VA

Business Objects Developer

Responsibilities:

• Involved in gathering end user Functional and Technical requirements, User/System Documentation, User training and testing developed reports for final deployment.
• Used Business Objects XIR3 extensively and Involved in Full SDLC (software development life cycle) rules are followed for designing new components.
• Designed, created and maintained Universes for Business Objects and Web Intelligence users using Business Objects Designer Module.
• Created Web Based reports using Web Intelligence and Dashboards for various reports such as Cross Tab and Master Detail Reports using the Java Report Panel.
• Generated various reports on a daily, weekly and monthly basis using Business Objects Report module.
• Involved in writing free hand SQL, as data provider for retrieving data when universe doesn’t provide required data.
• Created complex Stored Procedures and Views to be used for the reports.
• Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.
• Involved with the group which provided support and ideas for migration from BO XI 2 to BO XI 3
• Created Xcelsius dashboards using Query As A Web Service (QAAWS) and Live Office
• Tested reports for data consistency, tested Universe table joins, contexts, defects in reports/fixed the defects in reports
• Gave my thoughts and ideas to the data-modeling team in designing a new data mart for future reporting applications in a EDW warehouse.
• Coordinated with BO Admin in managing the Central Management Server to add/delete, enable/disable BO Servers.
• Coordinated with DBA and ETL in solving various technical issues and also to stream-line universe design and optimize query performance