SUMMARY

• Around 8 years of IT experience in the area of Business Intelligence as a Developer and Analyst. Extensive experience related to business analysis, requirement gathering and documentation of functional and non-functional requirements, Universe development, validation of data for consistency and Report Development for Public sector, retail and banking domains.
• SDLC: In depth strong working knowledge of the Software Development Life Cycle SDLC phases such as Planning, Analysis/Design, Development, and Testing for the software/system development process
• Worked the following versions and modules of Business Objects 4.0/ XI R3.1/XI R2/6.5/6.0 Business Objects SDK, Desktop/Web-Intelligence 4.0/ XI R3.1/ XI R2/XI R1/6.5, CMC, CCM, CMS, Live office, Discussions, Import Wizard, Web I SDK, Broadcast Agent BCA , Publisher, Supervisor, Designer, Launch pad, Lumira
• Adept at extracting data from different databases such as Oracle 11g/10g/9i, SQL server, MS Access with strong competency in data mart, star schema, snowflake schema, data requirement analysis and implementation of business applications.
• Experience migrating BO platform from BOXI 3.1 to 4.0 ,4.1 and converting DESKI reports to WEBI.
• Extensively used Calculation Contexts, Variables, hyperlinks and Drill Down analysis to increase readability for user.
• Created complex reports by linking data from multiple data providers, using free hand SQL, element linking, hyperlinking and functionalities like combined queries.
• Created WSDLs using Query as a Web Service QaaWS from different data sources.
• Experience working with CMC in scheduling documents and creating events.
• Proficient in creating views and stored procedures. Strong in working with relational databases.
• Experience facilitating project meetings, reviews, walkthroughs, and customer interviews. Actively involved in Gap Analysis and business process re-engineering.
• Supported end users to troubleshoot applications and also conducted post-production user training.
• Strong expertise in building templates, Pivot Table, graphical analysis charts and statistical reports using MS Excel.
• Performed performance tuning at report, universe and database level.
• Extensive experience creating dashboard reports using Live office Connections and Query Browser.
• Experience creating dashboards with navigating interface using Dynamic Visibility.
• Experience working as Production support analyst on a daily basis creating new tickets based on the severity of report fixes.
• Indepth knowledge on Tableau Desktop, Tableau reader and server.
• Experience scheduling and monitoring BO jobs using third party schedulers like Control-M.
• Experience working with Business Intelligence data visualizations in Dashboards, Lumira and Tableau.
• Good Knowledge of Cognos Modeling Tools Framework Manager, Metric Designer and report studio.
• Coordination and work along with the ETL team to ensure the timely execution of feeds to the reporting tables as well as testing the quality of data and providing inputs to them.
• Experience in preparing Business Requirements Document BRD , Use Case Specifications and Functional Specifications.
• Excellent communication and interpersonal skills, capable of communicating with highly technical engineering teams. Exceptional mediator between external and internal customers, capable of interpreting their needs and positions to ensure the success of the projects.

TECHNICAL EXPERTISE

WORK EXPERIENCE

Confidential

Business Objects developer

Responsibilities:

• Interacted with the management and business decision makers to identify business requirements. Document reporting needs of business service and support organization and disseminate those requirements into Data warehouse strategy resulting in both operational and analytical reporting.
• Created and maintained traceability matrix for Business attributes as part of the data conversion effort.
• Worked on analyzing the data, extracting SAS report attributes and mapping them to the current system and BO.
• Review and analyze the existing SAS code, create Data Flow Diagrams and worked with ETL team in incorporating the logic into tables.
• Read and interpret conceptual, logical and physical data models to include context, data flow, process flow, logical diagrams and data dictionaries.
• Work with ETL in data modeling using dimensional, star and snowflake schema modeling.
• Designed, developer and maintained universes by defining joins, cardinalities between tables applying contexts and aliases to remove cyclic dependencies.
• Created Heirarchies and User Security profiles in universe based on Business Rules.
• Customized universe level prompts, filters and aggregate awareness as per functional requirements.
• Coordinated with the data team on design approaches for report requests to decide on what objects to use from the universe, creating predefined filters and hierarchies in the universe as needed.
• Performed integration testing of universes structure checking, object parsing, joins parsing, conditions parsing, cardinality checking, loops checking and context checking after any modifications to them in terms of structure, folders and objects.
• Extensively worked with derived tables, aggregate tables, setting up aggregate navigation, shortcut joins in designing the data foundation layer for universe.
• Created custom List of Values and parameters in universe as per functional requirements. Designed universe to address users adhoc reporting needs.
• Created report mockups from existing SAS reports and business inputs.
• Created complex reports by linking data from multiple data providers, using free hand SQL, custom sorts, calculation contexts, element linking, hyperlinking and functionalities like combined queries.
• Extensively worked with formatting the reports according to user requirements and Incorporated complex business logic into reports using variables and filters.
• Coordination and work along with ETL team to ensure timely execution of feeds to the reporting tables as well as testing the quality of data and providing inputs.
• Extensively worked with third party scheduler Control-M workload automation to schedule BO reports incorporating ETL dependencies, defining parameters and setting up variables.
• Developed highly complex reports with hyperlinking, custom sorts, calculation contexts and complex variables.
• Developed universe user documentation guide for end user reference and also for Production support.
• Provided end user training and assistance for self service reports.
• Performed unit testing, system testing and user acceptance test UAT for universe and reports.

Environment: SAP Business Objects 4.1 SP 4 Launch pad, BO Explorer, Web I, Lumira, Rich Client, Widgets, Crystal Reports, Dashboards , Netezza, Hadoop, Aginity, Squirrel, Unix, SAS 9.0, Agile

Confidential

Business Objects/ dashboards Developer

Responsibilities:

• Review and understand functional requirement documents prepared by business analysts and prepare detail technical requirement documents to share with the team both onsite and offshore.
• Read and interpret conceptual, logical and physical data models to include context, data flow, process flow, logical diagrams and data dictionaries.
• Designed, developer and maintained universes by defining joins, cardinalities between tables applying contexts and aliases to remove cyclic dependencies.
• Created Heirarchies and User Security profiles in universe based on Business Rules.
• Managed row level security at Universe level to customize data access for user groups.
• Customized universe level prompts, filters and aggregate awareness as per functional requirements.
• Coordinated with the data team on design approaches for report requests to decide on what objects to use from the universe, creating predefined filters and hierarchies in the universe as needed.
• Created BO dashboard for executive view covering selected KPI for the business function.
• Participated in full life cycle development of dashboards. Analyzing client requirements, preparing Dashboard Specification Documents, conceptual design of dashboard, unit testing and performance tuning of dashboards.
• Developed complex dashboards using Dynamic Visibility and using multiple data connections.
• Created dashboards using Query browser, BI Web services and live office as data sources.
• Extensively worked with Ranks, Alerts, filters, prompts, variables and calculation contexts in designing reports.
• Created complex reports by linking data from multiple data providers, using free hand SQL, element linking, hyperlinking and functionalities like combined queries.
• Created custom reports like dealer statements, return mails and recoveries in response to user needs. Some of these are extremely complicated and retrieve data from multiple data sources.
• Created and modified views on oracle database.
• Built complex crystal reports based on stored procedures, used formulas, created static and dynamic filters and alerts.
• Presented Business Objects tools to potential new users in order to demo certain functionalities of each. Also developed tableau and cognos reports for the same.
• Prepared dashboards using calculations, parameters in Tableau.
• Proficient performance tuning using Aggregates, rollup, collapse, partition and compression.
• Involved in migration of BO 4.0 to BO 4.1
• Recreated Hyperion Brio reports in Web intelligence .
• Lead offshore team of 5 developers.
• Periodically worked on auditor/monitor in CMC to check the performance of reports in various BO environments.
• Created data sets and story board visualizations by performing data enrichment using Lumira.
• Created desktop widgets with drill to detail links to access detailed webi reports.
• Created publications and alerts using BI Launch Pad.
• Design and developed info cubes and exploration views for users in BOBJ Explorer and scheduled info spaces for indexing.
• Developed and published mobile dashboards using mobile compatible components and query browser.
• Created Lumira storyboard visualizations and exploration datasets for mobile.
• Developed Information spaces and exploration views for explorer mobile.
• Participated with the team in QA, unit testing, peer reviewing of reports and UAT

Environment: SAP Business Objects 4.1 SP 4 Launch pad, BO Explorer, Web I, Lumira, Rich Client, Widgets, Crystal Reports, Dashboards , Oracle EBS, Hyperion Brio, Oracle 11g, SQL Developer, linux, Metacenter

Confidential

Business Objects Developer / Reporting Analyst

Responsibilities:

• Interacted with Project Manager business users to understand the business needs, gather report specifications.
• Performed thorough data profiling and data analysis to ensure that reports meet the business objectives and are sanitized up-front.
• Created mockup reports in the process of designing technical specifications.
• Assisted in migrating BOBJ 3.1 to BO 4.0
• Converted existing Deski Reports to Webi using Report Conversion Tool.
• Performed enhancements to existing reports and universe.
• Created hierarchies in universes for reporting needs to drill down on hierarchies.
• Updated Universes reports continuously to rolling user requirements data sources in an agile environment.
• Analyzed the relationship between fact and dimension tables in data warehouse while designing universe.
• Worked towards optimal design or universes and removed loops through the use of aliases and contexts.
• Coordinated with DBA and Business objects designer group in solving various technical issues.
• Scheduling and monitoring reports using Broadcast Agent server.
• Built different visualizations using Xcelcius 2008
• Created complex reports using functionalities like Union, Intersection, Minus Queries, Drill Down, Custom Sorts etc.
• Developed Geomap, drill down webi documents mobile version 5 for ipad. Also used trend status, bullet charts and sparkline charts in webi mobile.
• Involved in unit testing of reports by writing queries against Oracle data sources.
• Extensive testing and migrating the reports or objects from development to Production system.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
• Involved in end user training and documenting the procedures.

Environment: Business Objects XI R3.1, Designer, Supervisor, RCT, Web Intelligence 6.0, Broadcast Agent, Oracle 8i, , PL/SQL,Windows 2000, UNIX

Confidential

Business Objects Developer/Analyst

Responsibilities:

• Interacted with end users to gather and document the requirements and translated them in to Technical specifications to Design Universe.
• Formatted reports as per the user requirements in Business Objects which allowed user to analyze the data.
• Used Slice and Dice, Drill Down, Filters, Cross Tab, Master Detail and variables .
• Created Alias tables and Contexts in Universe to resolve loops and tested them to ensure correct results.
• Created Hierarchies in the universes to meet Drill Analysis of the reporting needs.
• Worked with BI Lead in performance tuning and optimization of Business objects Universes by building Aggregate tables.
• Made new classes, objects and structural changes to Universes in Designer, including adding new objects, updating tables and joins.
• Involved in designing universes on SAP BW Info cubes.
• Experience in working with Business Explorer Bex and publishing the reports on web using Web Reporting tools.
• Used Predefined query filters, prompts in populating appropriate results.
• Created reports using SAP data source using the SAP best practices.
• Created various User defined objects including Dimensional, Detail, and Measure objects and tested them ensuring correct mapping of data.
• Created reports using universe as main data provider and writing complex queries including sub queries.
• Created Alias tables and Contexts in Universe to resolve loops and tested them to ensure correct results.
• Created Hierarchies in the universes to meet Drill Analysis of the reporting needs.
• Worked with BI Lead in performance tuning and optimization of Business objects Universes by building Aggregate tables.
• Tested and validated data in reports using SQL queries.
• Updated and maintained Universes based on changing user requirements and based on changes in data source.
• Worked in a production support role where in typical issues have been resolved.
• Handled the change request to modify existing Webi reports and universes.
• Trained end users to use various functionalities of Business Objects and provided technical support.
• Experienced in Importing/Exporting the Universes to repository.

Environment: SAP Business Objects XI R2, Crystal Reports, Xcelsius 4.5, MS SQL Server 2005, Oracle 10g, SAP BW, Windows Server 2003/2000, Windows XP.

Confidential

Business Objects Developer/Analyst

Responsibilities:

• Interacted with the client and gathered requirements, then designed and created universes as per the requirements using BO Designer module
• Did data modeling using the fact tables and lookup tables.
• Worked on the establishment of joins and cardinalities between tables in the universe and then checked for the integrity of the whole universe.
• Designed BO Report templates as per the end user requirements.
• Implemented Best Practices for Using Business Objects Suite of Products.
• Generated LOV's for different objects in the universe.
• Created complicated reports including sub reports, graphical reports and well formatted reports.
• Created reports using Info view using functionalities like Combined Queries, sub queries, Drill down analysis, Cross tab, Master detail and Formulas.
• Created complex Web intelligence reports using graphs, pie-charts and multiple data providers on daily, weekly, monthly and quarterly basis.
• Created complex graphical reports using Xcelcius.
• Migrated repositories from Development and did System Test, Performance Test, UAT, and then involved in deployment.
• Involved in the administration part of Central Management Console CMC for Folder Level security set-up, Report Scheduling, Users, User Groups, Servers and Server Group administration.

Environment: Business Objects XI R2, Designer, Web Intelligence, CMC, Oracle 10g, Crystal Reports, Xcelsius 2008,SAP BW 7.0, Window XP, Windows 2003 Server and linux.

Confidential

BOBJ Developer/Analyst

Responsibilities:

• Performed requirement gathering analysis by actively soliciting, analyzing and negotiating customer requirements and prepared the requirements specification document for the application using MS Word.
• Developed business intelligence reports using Business Objects SAP BO tool for the updated results to the stake holder.
• Used Slice and Dice, Drill Down, Filters, Conditions, Cross Tab, Master Detail and formulas and developed Hierarchies to support drill down reports.
• Developed dashboard reports and tested using spreadsheet table selectors.
• Created report level variables by using Variable editor.
• Prepare presentation slides in MS Project, which was extensively used in different JAD sessions and to track progress.
• Gathered Functional and Data Requirements, analyzed workflows and created Use Cases, Requirement Specifications, Report Specifications, Data Requirements, Data Mappings and Data Flow Diagrams.
• Worked on Requirement Change Management System in Rational Requisite Pro.
• Created Tables, Indexes, Views, Snapshots, Database links to see the information extracted from SQL Files.
• Prepared Test Cases based on base-lined Requirements Document, prepared Requirements Traceability Matrix and provided Performance Testing Requirements. Worked very closely with the Test team and documented all the defects.
• Facilitated UAT User Acceptance Testing with Business Users.

Environment: Business Objects 6.5, Designer, Supervisor, Web Intelligence 6.0, Broadcast Agent, Oracle 8i, PL/SQL, Windows 2000, UNIX

Confidential

Business Objects Developer / Business Analyst

• Gathered user requirements for BO reports and directed developers for practical deliverables.
• Created mockup reports while creating report specifications document.
• Worked with the full SDLC, elicit, analyze and define requirements.
• Conducted JAD sessions with the clients to identify the requirements.
• Worked with the software architects / developers to ensure that the applications conform to customer requirements.
• Followed the UML based methods using Rational Rose to create: Use Cases, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Participated Testing and Evaluation of projects at established integration points to assess progress and identify key functionality issues.
• Assist the QA personnel in the creation of Test Cases using Rational Test Manager.
• Performed job of contact point for all stakeholders business, legal, compliance, development .
• Documented monthly status reports for enhancement and modification requests for the development team to assist them in efficient tracking and monitoring of open issues of the project.
• Generated reports using webi and full client.
• Created webi reports using BO functionalities like drill down, prompts, dimensional and measure variables.
• Unit testing of reports.
• Consolidated, validated and documented issues encountered by business users with existing webi reports.
• Prepared documentation on how the reports will work and how to use functionalities in BO reports.

Confidential

Reporting Analyst

• Responsible for analyzing and documenting business requirements.
• Involved in requirement gathering and testing for web intelligence reports.
• Assist senior business analysts in planning, programming, implementing and testing client projects.
• Provide support to supervisors by documenting organizational structures, internal processes and clients business requirements.
• Used Rational Unified Process RUP for streamlining the team's development activities.
• Migrated repositories from Development and did System Test, Performance Test, UAT, and then involved in deployment.
• Tracked UAT issues/bugs and prepared reports.
• Generated weekly, monthly, and quarterly reports necessary in maintaining a good and balanced financial statement.
• Graphical representation of the reports using MS Power Point Presentation and MS Excel Charts.

Education: Bachelors in Business Administration, Acharya Nagarjuna University