SUMMARY:

• 10 Years of IT Experience in information technology with progressive development and implementation of various Data Warehousing projects
• 2+ Years of Lead experience across various development projects by maintaining healthy group dynamics.
• 2 Years of experience in Data Warehouse implementation using Informatica tool as ETL Developer
• Experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Metadata Manger)
• Most of the transformations were used like the Source qualifier, Update strategy, joiner, lookup, Filter and Sequence generator.
• 2 years of Tableau Experience in Enterprise Environment
• Ability to connect to different data sources from Tableau, presenting the good Visualization of data, Different way of using the filters and parameters.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x) reports.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security
• Provide status reporting of team activities against the program plan or schedule
• Keep the project manager and product committee informed of task accomplishment, issues and status.
• Initiate sub - groups or sub-teams as appropriate to resolve issues and perform tasks in parallel
• Extensive experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Business Intelligence application
• Extensive Knowledge in development, maintenance and troubleshooting of Business Objects Enterprise Products using Business Objects 4.0, BO 4.1, Business Objects XI Enterprise R2, XI3.0 and XI3.1 Mira (Desktop intelligence, Web Intelligence), Business Object Universe Designer, BI Launch Pad, Rich Client, Auditor, Migration
• Strong working experience with Business Objects Enterprise Architecture, including deploying reports, Universes to server, scheduling reports, migration wizard, and central management console (CMC), Creation of user groups, implementing access restrictions Migration using Life Cycle management, Central Management server (CMS), Disaster recovery etc.
• Had experience in security restrictions in Designer and Access Restrictions in Business Objects Enterprise.
• Extensive knowledge in Enterprise deployment and maintenance of Business Objects Full-client, Designer, XI 3.0 and XI 3.1/BI 4.0/4.1/4.2 versions.
• Good in migrating Business Objects environments from earlier versions to the latest version of BI 4.0, BI 4.1, BO XI3.1 and XI3.0.
• Extensive experience in Business Objects Installation on multiple platforms.
• Done Production support of Crystal Reports, Web intelligence i.e., modifying users and security, fixing errors in reports, Performance tuning of reports and Migrations.
• Involved in applying upgrade patches to Business Objects Server
• Extensive knowledge on using Report conversion tool and Import Wizard and Setting row level restrictions while designing universes.
• Taking Backup of Input, Output files Repository Servers and restoring CMC Repository and Input, Output file Repository Servers.
• Setting up Auditor for XI3.0 and XI3.1 and 4.x.
• Extensive experience in supporting/maintaining/troubleshooting large amount of reports/ universes/End user’s issues.
• Distinctive knowledge in Optimization techniques both at universe and report level.
• Extensive experience in improving the testing productivity of the BO product when working with SAP.
• Worked on many new features of BO 4.0 in the developing environments of the products ramp up edition.
• Possess excellent debugging and an analytical skill for problem determination of issues comes at different phases of implementation and support platforms.
• Worked on BEx query designer and analyzer in building Queries, Columns, Rows, local structures restricted key figures, Variables, Exceptions, and conditions
• Hands on experience in dimensional data modeling, Star Schema Modeling, Snow Flake Modeling,Physical and Logical data modeling.
• Involved inscheduling the Webi as object packages, creating the schedule events on test server usingCMC
• Proactively involved with the Testing team in efficiently improving the quality of the product.
• Extensive experience in developing data models in HANA 1.0 SP2
• Established the best modeling and recommended strategies for BOBJ environment and architecture forSAP HANA
• Performed datamodeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Good Exposure in developing data models in HANA 1.0 SP2
• Involved in datamodeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Created Universes on top ofHANA viewsand developed the Webi reports
• Works well individually or in a team environment and possesses excellent communication skills, both written and verbal.
• Conducted End User Trainings on SAP BO 4.1 Interface
• Business Objects Enterprise Certified Professional (BOECP) from SAP Business Objects
• Received several accolades for solving critical issues at the earliest time from important customers like Confidential, Confidential .
• Received PROMISING TALENT award for consistent performance throughout the development phase of the project
• Received SPOT award from Deloitte Management for consistent performance and Excellency
• Best Trainer award for training the junior resources on BO reporting tools in Goldstone Technologies Ltd.

TECHNICAL SKILLS:

DBW Tools: Business Objects XIR2 and XI 3.0, XI 3.1, XI 4.0, XI 4.1

Other Reporting Tools: SAP Business Explorer, (BEx)Analyzer, BEx Query Designer, SAP LUMIRA, QAAWS, LIVE OFFICE, Analysis for Office

Dashboard Tools: Tableau 8.x / 9.x

Modeling Tools: HANA STUDIO 1.0

ETL Tools: Informatica 9.1, Autosys

Environment: Linux, Windows 2008, windows 2003, XP.

Database: Oracle 9i/11g, SQL Server 2008, Ms Access 2000

Other Tools: HADOOP (HDFS, SQOOP, PIG, HIVE, HBASE), HPQC, WINSCP, Guide ware, Peoplesoft CRM

PROFESSIONAL EXPERIENCE:

Confidential, NY

SAP BO Consultant

Responsibilities:

• Developed WEBI reports based on IDT, UDT, BEX Queries and HANA Views.
• Involved in updating the HANA Views for the existing model. Updated the columns and join conditions in the attribute and analytical views as part of enhancement
• Created Webi reports that includes BEx and Universes as data sources
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Involved in creation of Views on SQL Server OLTP system
• Involved in data modeling, creating star schema and snow flake schemas.
• Created webi reports and fine tuned to the views for performance optimization.
• Created Universe as per the data model Star Schema and validated accordingly
• Worked on Bex query designer and Analyzer in building the queries, Columns, Rows, Restricted key figures, Variables and Conditions.
• Created Analysis for Office reports on top of HANA Views and done the preliminary testing for data validation
• Prepared the System Test cases and Unit Test Cases with different scenarios
• Tested the report output for various input providers and provided the best performance of it
• Involved in integration testing of the product as the data is from various sources.
• Involved in Regression testing of the WEBI reports based on BEx and HANA Views so as to have data consistency across the systems.
• Coordinate the review, presentation and release of design layouts, analysis, test cases and other documentation
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Ability to connect to different data sources from Tableau, presenting the good Visualization of data, Different way of using the filters and parameters.
• Developed the standard reports within Tableau by connecting different databases Oracle 10g, MS SQL server.
• Used the extracted Data Marts from warehouse in designing of tableau views
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Experience in preparing the Dashboard Specification Documents.
• Conducted Unit Testing of the dashboard.
• Experience in Designing of the Dashboard according to color guide given by client.
• End to end client interaction to get the business answers.
• Focal point and Lead for all BO Design issues and responsible for presenting the prototypes of critical requirements to the client.
• As a consultant, responsible for doing comparative analysis between different reporting tools of SAP, to decide the feasible tool according to the business requirements of the client.
• Developing advanced analysis reports using SAP LUMIRA, Analysis for Office
• Responsible for updatation of the test results and its status in HPQC
• Monitor the HPQC system and send the respective status to the team and management on a daily basis.
• Provided training to the internal Associates on BO Tool.

Environment: Business Intelligence 4.1 SP6, SAP HANA Studio 1.0, IDT, Analysis for Office, SAP LUMIRA, Bex Query Designer, Bex Analyzer, HPQC, Tableau, Oracle 10g, MS SQL server.

Confidential, NY

Team Lead / Senior Support Engineer

Responsibilities:

• Production support (L2& L3) and development of enhancement requests for WEBI reports
• Prepared the application document i.e., functional and technical requirement documents
• SME for the BO production support in the project and responsible for working with the clients on new enhancements
• Setting object and row level security restrictions in universe designer based on management hierarchy and groups at CMC level
• Set Table Mapping in universe designer to hide the personal data from end users.
• Prepared the RCA (Root Cause Analysis) documents which ever required for the support issues.
• Worked on Auto-sys tool to monitor the automated jobs and prepared the status
• Interact with the dev team for the fix migration from dev to UAT env. Prepared the necessary migration document as specific to the project standard document.
• Worked on complex enhancements in WEBI reports like merge dimensions, creation of detail objects, using breaks, page break options, sections
• Interact with various teams in the project to check the health of the environment and send the information to the senior management on monthly basis.
• Check the daily status of the tickets and update to the management.
• Checking with the users and regular follow-ups for the tickets raised
• Prepared the monthly tickets status document, which needs to discuss in the business call bi-weekly.
• Prepared two POC’s on SAP Lumira on interactive analysis and showcase to the client.
• Created storyboards and documents using various functions like charts, tables, drilling, filters in a single document and prepared storyboards.

Environment: Business Objects XI R3.1SP7, Oracle SQL developer 3.2, Service Now

Confidential, Santa Clarita, CA

Business Objects Developer and Administrator

Responsibilities:

• Interacting with users in collecting requirements and on design discussions of Business Objects universe and reports.
• Created WEBI reports for various portfolios using universes as the main data provider.
• Involved in Creating the Universes, Groups and Folders in Business Objects.
• Created Objects, Predefined Conditions, joins in the Universe and Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Applied aggregate awareness to speed up query time.
• Did multi-dimensional analysis using slice & dice, drill (up, down, through and across) by setting up different hierarchies and defining the scope of analysis.
• Published/Scheduled reports using Business Objects Enterprise.
• Modifying the existing reports and universes based on the user requirement or as per the database changes.
• Involved in testing reports before publishing them to the repository
• User/Groups and user Folder creation and applying access restrictions. Migrations across the environments DEV and UAT.
• Promoting the tested content form Development to UAT using Promotion Management.
• Scheduled BO reports. Troubleshooting various problems in Reporting (Web I) part and Admin (CMC) part.
• Accountable to deliver the files at on time.
• Involved in Data connectivity to the data bases.
• Also used multiple data providers and created the reports by synchronizing the common objects.
• Created Tableau views on top of Data Marts(Extracts) connecting to Sql Server and created various formats of dashboards

Environment: Tableau 7.x, Business Objects XIR3.1, Oracle 10g, SQL SERVER 2008

Confidential

Team Lead / Senior Report Developer

Responsibilities:

• Requirement gathering, analysis and preparing estimations for the development.
• Preparing the Technical Specifications
• Responsible for Estimations and effort tracker and daily updates to the management.
• Responsible for the delivery of reports from Off-shore end.
• Preparing the UDD and development exit report criteria for ST & SIT
• Release manager for the defect status call.
• Used the HPQC for the defect analysis and respond to it with the status required.
• Designed two universes using SQL Server/DB2 as databases for reporting requirement.
• Involved in Building universes on Sql Server Database that included Stored Procedures (PL/SQL).
• Created and Involved in designing of the data models like Star Schema and developed universe (unv) using it
• Developed webi reports as per the client’s requirement.
• Created multi-tab reports, used logos, various other functions like sections, filters, drill filters, complex variables, merge dimensions, hyperlinks, input controls, multi-data provider, sub-query, results from another query, custom sql
• Used stacked bar charts and line graphs in report design.
• Given weekly backup of the reports as BIAR files.
• Using Guideware application prepared the test data. Created test scenarios for webi reports
• Preparation of ETL mapping documents according to the Business Requirements.
• Analyzed the Sources, targets, transformed the data, and mapped the data and loading the data into Targets using Informatica.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica.
• Extracted the Data Marts for validation with the backend datasource.
• Transformations like Expression, Router, Joiner, Lookup, Update Strategy, and Sequence Generator are mainly used.
• Used Joiner transformation for extracting data from multiple sources.
• Creating Informatica mappings, Mapplets and reusable transformations.
• Created tasks and workflows in the workflow manager and monitors the sessions in the workflow monitor.
• Performed unit testing and validated the data.

Environment: Business Objects XI R3.1SP3, BI 4.1, Informatica 9.1, SQL Server 2008, DB2 9.0, Guideware application, HPQC.

Confidential

Technical Associate

Responsibilities:

• Responsible for interacting with the customers, understand their requirements, designing, testing and troubleshooting Business Objects Universes and Reports for various clients of Business Objects.
• Involved in improving the productivity of the BO product by reducing the defects rate.
• Used Import Wizard, Report conversion tools in the migrating environments.
• Responsible for maintaining and creating the universes, Deski and Webi reports.
• Modifying and creating the reports basing on the user requirement.
• Provided service to customers in troubleshooting of complex and critical reports by providing the absolute and feasible solutions
• Designing of complex report layouts using Business Objects reporting tools for various customers of SAP Business Objects all over the world.
• Interacting with users (all around the world) in collecting requirements and on design discussions of Business Objects universe and reports.
• Solved many Troubleshooting errors like #Multivalve, # Overflow, #Context, # Data sync, # Incompatible at report level.
• Added/created complex objects to the universe to enhance the report functionality.
• Tested the universe structure to ensure the tables are properly updated along with the database
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Replicating the Bugs in different BO versions in different operating systems and forwarding the same to Product group for the Fix.
• Helping the customers to upgrade or move their repositories to different patch levels.
• Mentoring junior level support engineers in Business Objects Architecture and Functionality.
• Meeting with UK and US counter parts to discuss status on the projects.

Environment: Business Objects XI Enterprise R2, XI3.0, XI3.1, Oracle 9.2, Toad, Apache Tomcat.

Confidential

Technical Associate

Responsibilities:

• Involved in Installing the Business Objects XIR2, creating Repository, creating Users and User Groups using Central Management Console (CMC) and setting appropriate rights.
• Involved in designing, developing & testing the universe and reports for the customers across the APAC Regions.
• Installation and configuration of Business Objects XIR2 Enterprise Server Products on Windows.
• Installing the supported versions of web apps as per the PAR (Product Availability Report)
• Involved in creating objects with open document links in universe and thereby using these objects at the report level (full client and webi) for report navigation.
• Setting up the default and customer hierarchies at universe level for Multi-Dimensional analysis. (Drilling).
• Created universe with the model provided Star Schema and validated with the ad-hoc queries to meet the client’s requirement.
• Helped in designing the star schema model to meet the reporting requirements.
• Created Derived tables and @Aggregate awareness functions to improve performance of the Universe.
• Setting object and row level security restrictions in universe designer
• Using of Filters, Complex Conditions according to the customer’s requirement
• Solving the performance issues related Universes and Reports

Environment: Business Objects XI Enterprise R2, XI3.0, Webi, Deski Oracle 9.2, Apache Tomcat.

Confidential

Report Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Extensively used Web Intelligence through Infoview interface to generate reports.
• Involved in designing phase of Universe.
• Created Universes by defining connections and retrieving data from database.
• Resolved join path problems using contexts and aliases.
• Created Drill-down, Drill-up, Drill-by Reports to provide users with more detailed information and query linking.
• Development and Deployment of Complex Reports.
• Used multiple data providers, Union, Sub Queries, Intersection, minus and Master/Detail, cross tab, Charts.
• Extensively used Opendoc function to link parent and child reports.
• Designed exceptional documents with Alerters and involved in designing the report with rank feature in WEBI.
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, slice and dice, Master/Detail, Cross Tab, and Charts for creating Business Objects reports.
• Unit Testing of the Reports and documented the results.
• Designed, developed and managed Universes in Business Objects Designer for generating the pay roll reports for sales, marketing reports for marketing group users.
• Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.
• Creation of reports like Residential and Business Customers reports, Service charge validation Reports, Monthly paper bill Reports
• Created custom reports like Gross Margin, Account Query, Aging, Balance Sheet, Income Statement, Bad Debt and Payment Reports in response to user needs. Some of these reports are extremely complicated and retrieve data from multiple data sources
• Created Charts to display summary data using universe as main data provider.
• Created User Conditions and Filters to improve report generation & readability of report and displayed the summary of data by creating Charts.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
• Involved in production support and resolved production issues.

Environment: Business Objects XIR2, Web intelligence XI, Desktop Intelligence XI Oracle 9i andWindows 2000.