SUMMARY:

• 11+ Years of IT Experience in information technology with progressive development and implementation of various Data Warehousing projects
• 2+ Years of Lead experience in development/support projects by maintaining healthy group dynamics.
• Worked in all phases of SDLC including Requirement Gathering, Designing Data Models, Development, Testing, go live and Post Go Live Support.
• Fully conversant with SDLC, and Water Fall/Agile/SCRUM development processes.
• Extensive experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Business Intelligence application
• Hands on experience in dimensional data modeling, Star Schema Modeling, Snow Flake Modeling,Physical and Logical data modeling.
• 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), Universe Designer, IDT, BI Launch Pad, Rich Client, Xcelsius, Auditor, Migration, LCM (Life Cycle Manager).
• Sound noledge in Preparing Technical Specifications, Functional Specifications, Test data preparation, Test Case scenarios, Universe design documents by interacting with Business Users.
• Experience in Data Warehouse implementation using Informatica power center as a 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)
• Worked on IDQ analyst tool for data analysis, created data quality checks and rules for data profiling, data cleansing and quality.
• Extensive Tableau Experience in Enterprise Environment. Good at Developing Tableau visualizations and dashboards using Tableau Desktop
• Ability to connect to different data sources from Tableau, presenting the good Visualization of data, different ways of using the filters and parameters.
• 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. Involved in applying upgrade patches to Business Objects Server
• Done Production support of Crystal Reports, Web intelligence me.e., modifying users and security, fixing errors in reports, Performance tuning of reports and Migrations.
• Worked on BEx query designer and analyzer in building Queries, Columns, Rows, local structures restricted key figures, Variables, Exceptions, and conditions
• Experience in building Universes from SAP BW and Non - SAP Data Sources.
• Conversation of .unv files to .unx while upgrading to new version of BOBJ
• Distinctive noledge in Optimization techniques both at universe and report level.
• Extensive experience in improving the testing productivity of the BO product when working with SAP.
• Possess excellent debugging and an analytical skill for problem determination of issues comes at distinct phases of implementation and support platforms.
• Extensive experience in developing data models in HANA 1.0 SP2
• 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.
• Works well individually or in a team environment and possesses excellent communication skills, both written and verbal.
• Keep the project manager and product committee informed of task, issues and status.
• Initiate sub-groups or sub-teams as appropriate to resolve issues and perform tasks in parallel
• Conducted End User/Client s on SAP BO to be familiar with the tool usage and functionality.

TECHNICAL SKILLS:

B Tools: Business Objects XIR2, XI 3.0, XI 3.1, BI 4.0,4.1 WEBI Rich Client, BI Launchpad, UDT, IDT, Import Wizard, LCM, Promotional Management

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

Dashboard Tools: SAP LUMIRA, Xcelsius, Tableau 7.x/8.x / 9.x, Design Studio

Modeling Tools: HANA STUDIO 1.0, Erwin

ETL Tools: Informatica 9.1, Informatica Data Quality 9.0.1

Scheduling Tools: Autosys, Ctrl+M

Ticketing Tools: Service Now, PeopleSoft CRM, SAP

Defect Tracking Tools: HPQC, IBM Relational Clear Quest, JIRA, Bugzilla

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

Database: Oracle 9i/11g, SQL Server 2008, DB2, My-Sql, MS Access 2000

Other Tools: HADOOP (HDFS, SQOOP, PIG, HIVE, HBASE), WINSCP, Guide ware, SAS Enterprise Guide 7.1

PROFESSIONAL EXPERIENCE:

Confidential, VA

Sr. System Integration Analyst/ Report Developer

Responsibilities:

• Interacting with business process owners and users to understand the functional requirements and translate them into technical documents
• Design of new dimension tables in DWH to pull data from different source system and its integration
• Understanding the different source systems & designing the model on business requirements
• Creating source to target mappings with all the transformations logics with documentation and update in the data dictionary
• Validating the ETL developments and target tables
• Did enhancements on existing tables in DWH as per new business requirements on fact and dimension tables
• Developed and maintained an on-line documentation web site that included object models, data models, and metadata
• Generated Report for the different line of Business Like Medicaid, Chip, Medicare, Commercial, Exchange.
• Extensive work on to create Complex SQL queries with the halp of SQL Server Management Studio
• Developed Web Intelligence reports making use of combined queries (Union, Intersection, Minus).
• Worked closely with Data services team to validate and check if all required fields and elements were loaded into EDW from the old source systems and monitor daily loads to ensure proper report delivery.
• Worked along with the development team to integrate the Crystal Reports with the Prompt Screens.
• Created and documented a list of tables, fields, joins, derived tables, hierarchies and filter prompts needed for the complete reporting.
• Extensive noledge in writing formulas using crystal /Basic syntax and shared variables
• Involved in designing Universes by creating the Business Objects Data Model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects like Dimensions, Details and Measures which are grouped into Classes and checked the integrity of the universe.
• Used Prompts in the reports as well as the Universe to create more interactive reports for the users.
• Developed reporting standard template for the BI team and implemented their standards when building new universes.
• Built reports using multiple data providers, external data providers and used merge dimension functionality to achieve the join pattern in existing report (if wasn't possible from the universe). Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions.
• Created Report Level Variables, Objects and Formula to create new columns based on the result set.
• Developing advanced analysis reports using SAP LUMIRA, SAP PREDICTIVE ANALYSIS
• Created reports by connecting to IMCE from SAP Lumira, SAP Business Objects Explorer BEx and MS Excel through ODBO/MDX for multi-dimensional reporting.
• Scheduled reports to be pushed onto a team's SharePoint site as well as to user's inbox. Served a support person a weekly rotational basis.

Environment: Business Objects 4.1, Webi, IDT, Informatica 9.1, MS Visio, Netezza, Sql Server 2008, IBM - me series

Confidential, VA

Sap BO Consultant / Data Analyst

Responsibilities:

• Developed WEBI reports that sources from IDT, UDT, BEX Queries and HANA Views.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Involved in creation of Views on SQL Server OLTP system
• Involved in dimensional data modeling, creating star schema and snow flake schemas.
• Created webi reports and fine tuned to the views for performance optimization.
• Created complex webi reports like finance reports and Ad-hoc reports using Ranks, drill down function charts, Report Linking, Multi data provider, Merge dimensions, Detail objects, results from another query, custom sql, Combined Queries etc
• Created many reports like loans, commitments and outstanding to no the exact amount of change in each loan
• 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 regression testing against the BW source data
• 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.
• 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 that suits the business requirements.
• Provided to the internal Associates on BO Tool.

Environment: Business Intelligence 4.1 SP6, SAP HANA Studio 1.0, IDT, Analysis for Office, Bex Query Designer, Bex Analyzer, HPQC, Tableau9.x, Sql server 2008, Teradata.

Confidential, NY

Sr. BO Consultant

Responsibilities:

• Designed Universes for Integrated Reporting System.
• Involved in discussion with data modular, business user and client in designing and defining the logical & physical models. Used ERWIN tool for designing the model.
• Created various User defined objects including Dimensional, Detail, and Measure objects and tested them to ensure correct mapping of data.
• Improved the performance and reduced the coding with the use of @functions (@aggregate aware, @select, @prompt, @where)
• Created new and modified existing Hierarchies in the universes to meet Drill Analysis of the user's reporting needs.
• Defined Alias and Contexts to resolve loops and tested them to ensure that correct results are retrieved
• Performed integrity testing of the Universes (Universe Structure checking, Object parsing, Joins parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after any modifications to them in terms of structure, classes, and 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.
• Customized the parameters in universe to improve the performance like max no of rows limit, connection timeout, ANSI parameter settings, row level, column level restrictions and table mapping for masking the NPI data.
• Created derived tables in universe to meet the adhoc business reporting requirements.
• Created universe using IDT tool and created webi reports on top of that.
• Design and develop standard reports and summary reports.
• Worked extensively with the major functionality ofBOlike Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Created reports like Residential and Business Customers reports, Reports by Period, Demographic reports and Comparative Reports.
• Created advanced reports with "if tan else syntax," calculation context, character strings functions, combined queries and sub queries.
• Created various tableau dashboards which shows the KPI’s
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Developing advanced analysis reports using SAP Lumira
• Conversion of existing dashboards from Xcelsius to Lumira, for comparison purposes
• Created storyboards and documents using various functions like charts, tables, drilling, filters in a single document and prepared storyboards.
• Created test plans, test cases and tracked defects/ artifacts in HPQC.

Environment: Business Intelligence 4.1, Tableau 9.1, Teradata 15, SAP Lumira 1.6, HPQC

Confidential, NY

Team Lead / Senior Support Engineer

Responsibilities:

• Production support (L2& L3) and development of enhancement requests for WEBI reports
• Prepared the application document me.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 for health check of various applications and servers 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 on the fixes and regular follow-ups for the tickets raised
• Responsible for updating the test results and its status in HPQC
• Monitor the service now system and send the respective status to the team and to the management daily.
• Prepared the monthly tickets status document, which needs to discuss in the business call bi-weekly.

Environment: Business Objects XI R4.1SP2, Oracle SQL developer 3.2, Service Now, HPQC

Confidential

Team Lead / Senior Report Developer

Responsibilities:

• Requirement gathering, analysis and preparing estimations for the development.
• Preparing the Technical Specifications
• 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
• 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, Custom Hierarchies, Custom LOV’s, Cascading Prompts, Pre-defined filters, query level filters and report level filters, userresponse functions.
• Used @functions in universe design like @prompt, @select, @where, @Variable, @AggregateAwareness
• Converted universes from .unv to .unx. Used IDT tool to convert .unv to .unx upon upgradation to 4.1
• 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 from 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 Power Center.
• Extracted the Data Marts for validation with the backend data source.
• 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.
• 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 BugZilla for the defect analysis and respond to it with the status required.

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

Confidential

Business Objects Administrator

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outlines proposed solutions.
• Planning, Installation and configuration of BO XIR2/3.1 in Windows and Linux.
• Expertise in Resolving the Daily issues in the Daily Production Environment.
• Responsible for maintaining and creating the universes, Deski and Webi reports.
• Responsible for Creating and maintaining various user groups and their security using Business Objects CMC
• Involved in applying upgrade patches to Business Objects Server
• Done Migration of universe, groups, and reports from one environment to other environments.
• Implemented java SDK’s to improve the performance.
• User/Groups and user Folder creation and applying access restrictions. Migrations across the environments DEV and UAT.
• Used migration wizard to migrate reports, universes, business views, security, user groups etc from Development to Testing and to Production.
• Published/Scheduled reports using Business Objects Enterprise. Troubleshooting various problems in Reporting (Web me) part and Admin (CMC) part.

Environment: Business Objects XIR3.1/4.1, Oracle 10g, SQL SERVER 2008, CMC, ImportWizard

Confidential

Technical Associate

Responsibilities:

• Installation of 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.
• Installing the supported versions of web apps as per the PAR (Product Availability Report)
• Used Import Wizard, Report conversion tools in the migrating environments.
• Solved many Troubleshooting errors like #Multivalve, # Syntax, #Context, # Data sync, # Incompatible, #ToRefresh at report level.
• 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
• Solving the performance issues related Universes and Reports
• Extensively used Web Intelligence through Infoview interface to generate reports.
• 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.
• Used multiple data providers, Union, Sub Queries, Intersection, minus and Master/Detail, cross tab, Charts.
• 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.
• Created Charts to display summary data using universe as main data provider.

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