SUMMARY:

• Proficient in all phases of the Software Development Lifecycle(SDLC(Water Fall & Agile methedology)) including Requirements gathering, Analysis, Design, System Implementation, Performance Tuning, Testing and Support.
• Excellent experience with DW Concepts such as Star schema, Snowflake Schema, Fact, Dimensional tables, physical and Logical data modeling.
• Well versed in SAP Business Objects 4x/3x/XI R2 Enterprise Suite (Universe Designer, Information Designer tool (IDT), Web Intelligence, LCM/Promotion Management, Central Management Console (CMC), Central Configuration Manager (CCM), Import Wizard and Promotion Management.
• Experience in building Universes, Free Hand SQL methods and creating Complex and Ad - Hoc Reports using SAP Business Objects.
• Experienced working knowledge on Bigdata tools with AWS-S3 and Redshift.
• Good knowledge on SAP HANA/Lumira.
• Experienced working with Universe Designer (UDT) and Information Designer Tool(IDT).
• Extensive experience in interacting with business users, business owners for requirements gathering, analyzing business process and making necessary changes to schema objects to fulfill reporting needs.
• Experience in using various source systems connections for BO use: OLAP (BICS) for BW and RDBMS like Oracle 11g/9i/8i, SQL Server 2005/2008 and Teradata.
• Involved in designing Databases and data marts on Oracle/Access. Widely used TOAD (Oracle) and SQL Server Management studio to write complex queries to check for data quality, performance of reporting queries and tweaked them to reduce run time.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 8x/9x/10x.
• Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations and making use of actions, local and global filters according to the end user requirement.
• Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Experienced to connect Denodo 5.5/6.0 using Postgre connection and creating BO data model using IDT 4.2 SP3 tool and creating reports for users/stack holders.
• Experienced in development of Data Virtualization Views, Base Views, Derived Views, Projection, Selection, Union Views.
• Experienced to edit VQL script for addition of enhanced attributes in Denodo views and execute denodo views in VQL Shell window to validate data against Source data tables.
• Analyse/ensure Denodo exist views for business logic and validate the views for expected results.
• Provide Dummy attributes for BO use in Denodo Interface views and later sync-up with Denodo actual views from different denodo branches.
• Involved to optimize the Denodo queries and requesting the BO reporting needs.
• Involved with Denodo team to analyse optimization technics like Branch pruning, Aggregation Push down.
• Experienced to edit VQL script for addition of enhanced attributes in Denodo views and execute denodo views in VQL Shell window to validate data against Source data tables.
• Create the associations for denodo views for query optimization/performace purpose.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Experience in giving training to the teams.
• Involving in Estimates and project plans.

TECHNICAL SKILLS:

Business Intelligence: SAP Business Objects 4.x/3.1/XI R2/6.5 (Designer,Info view(Launch Pad), Universe Designer(UDT), Information Designer tool (IDT), WebI, Deski, Rich client,Import Wizard, Life Cycle Manager (LCM),CMC,XcelsiusLiveOffice and Qwaas,Promotion Manager),Analysis for Office,SAP BW.

Reporting Tools: Vermillion Reporting Suite, Actuate reporting Tool, Crystal Reports XI/2013.

ETL Tools: Informatica 8x, Ab Initio

Data Visualisation Tools: Tableau 8.2/9.x/10.x, MS Power BI, SAP Lumira,Qlik View.

Data Virtualization Tools: Denodo 5.5/6.0, BO Data Federator

Data Bases: Oracle 8i/9i/10g/11g, SQL Server 2005/2008,Teradata, AWS-S3, Red Shift,SAP HANA

Tools: SQL * Loader, Toad 7.1, Erwin 3.5.2,SQL Developer.

Languages: SQL, HTML,Actuate Basic.

Operating Systems: Windows 2003 Server, Windows2000/XP and Windows7.

PROFESSIONAL EXPERIENCE:

Confidential, San Rafael,CA

Business Intelligence Analytics Consultant

Environment: SAP Business Objects 4.2 Sp3/3.1 Sp6 suite tools (WebI, Rich Client,Deski,IDT,UDT, BI Launch Pad), SAP Data Federator 3.1, SAP BW Cubes, Denodo 5.5/6.0, Tableau 10.2, Qlik View, Oracle 11G, AWS-S3, Red Shift, Windows 7.

Responsibilities:

• Gather requirements by interacting with Business users for the reports/dashboard requirements.
• Providing walk-through sessions on the new features and functionality on the exist reports to Autodesk Finance team.
• Upload the files in AWS-S3 buckets.
• Copy files from S3 test bucket to Redshift database schema tables using Copy command.
• Use Reshift tables for Analytics purpose.
• Provided centralized Denodo views to Qlik view, SAP BO reporting/Dashboard purpose.
• Upgrade BO 3.1 Webi,Deski, crystal reports and universes into BO 4.2 Webi and universes.
• Created and modified universe (.unv/.unx) objects for canned reports basd on business needs.
• Created Connections for Information Designer tool IDT (.UNX) and published to BOE server.
• Re-developed Data Federator Universe(.UNV) to Multi connection universe (.UNX) using BO 4.2 IDT.
• Created multi connection universe (.unx) using relational connections like Oracle and SAP Netweaver BW (JCO) and OLAP connection (BICS) for SAP BW cubes.
• Developing complex universes by using advanced features like aggregate aware,conditions and created user objects including Dimensions, Measures and attributes.
• Created derived tables for complex calculations in universe.
• Performed and ensured universe functionality after upgraded from 3.1(.unv) to Bo 4.2 IDT(.unx).
• Implemented Data security profile in IDT to provide row level security based on user id’s.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations and making use of actions, local and global filters according to the end user requirement.
• Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Developed the prototype reports for end users in Business objects to get sign off for actual designing and for presentation.
• Experienced in development of Data Virtualization Views, Base Views, Derived Views, Projection, Selection, Union Views.
• Create the join conditions based on primary key basis between the tables and creating the derived view based on requirements.
• Provide Dummy attributes for BO use in Denodo Interface views and later sync-up with Denodo actual views from different denodo branches.
• Schedule the reports as requested by users on daily, Weekly,Monthly, Quarterly,Yearly basises.
• Preparation of Unit test plans, unit test results and data validation for the reports.
• Implementing projects using Agile methodology.

Business/Data Analytics Analyst (BO/Tableau)

Environment: SAP Business Objects 4.1 suite tools (WebI, IDT,UDT, BI Launch Pad), Tableau 8.2/9.1, Teradata,SQL Server 2008,Windows 7.

Responsibilities:

• Providing walk-through sessions on the new features and functionality on the exist reports to community Mortgage,Home Equity and Mortgage teams.
• Managing of all BO universes and standard reports in BO XI 4.1 which is used by Home Loan Origination users.
• Converted the Cognos reports (60+ reports) into BO reports.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations and making use of actions, local and global filters according to the end user requirement.
• Skilled in Tableau Desktop for data visualization through various charts such as bar charts, line charts, combination charts, pivot table, scatter plots, Heat maps, pie charts, and packed bubbles and also used multiple measures for comparison such as Individual Axes, Blended Axes, and Dual Axes.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating Aggregates, sets, Joins, bins, Hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters.
• Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Preparation of Unit test plans & Unit test results for the reports.

BI-BO/Tableau Consultant

Environment: SAP Business Objects 4.1 suite tools (WebI,IDT and Universe Designer tool, BI Launch Pad), Crystal Reports 2013,Tableau 8.2,SQL Server 2008,Teradata,Windows 7.

Responsibilities:

• Create standard reports using Web Intelligence / Crystal Reports using OLTP system for Confidential Home loans users.
• Created universe using BO 4.1 IDT for data modeling purpose.
• Implemented the custom schedule business logic in query level in Crystal Reports.
• Implemented Index awareness to improve the performance at universe level.
• Generation of Tableau extracts and implementation of different calculations, visualizations in the tableau lay out design.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Provide the Mapping documents for ETL team.
• Prepare the technical documents and provide the pseudo code.
• Create global universes(.unx and .unv) for canned and ad hoc reporting purpose.
• Used parameters and input controls to give users control over certain values.
• Preparation of Unit test plans & Unit test results for the reports.
• Prepare the user documents and provide the user trainings/walk-through sessions to users.

Business Intelligence Reporting Lead

Environment: SAP Business Objects XI 3.1/XI 4.0 SP4, Info view(Launch Pad), Universe Designer (UDT), Information Designer tool (IDT), Import Wizard, LCM, Crystal Reports, Dashboard design, Oracle 9i/11g, Ab-Initio, PeopleSoft, SQL server 2005/2008, ServiceNow, Windows XP, Windows 7.

Responsibilities:

• Managing of all BO universes and standard reports in BO XI 4.0 which is used by Regulatory reporting users.
• Involved in installation and configuration of BO Enterprise XI 4.0 components, BI Launch Pad, Dashboard Design, Live Office, Webi, Advanced Analysis for Microsoft office and OLAP.
• Created Connections for Information Designer tool IDT (.UNX) and exported to BOE server.
• Developing complex universes by using advanced features like aggregate aware and Conditions.
• Implemented Index awareness to improve the performance.
• Created Indexes, Partitioning tables and execute the explain plan to improve the performance.
• Implemented object level security and incorporated Unified security for Row level security.
• Preparation of Unit test plans & Unit test results for the reports.
• Drill down reports using Opendoc functionality.
• Promoting the tested content form Development to IT, QA and Production using Life-Cycle Manager (LCM).
• Worked on the Production issues and provided the report fixes,universe fixes.
• Worked with support team for environmental issues.
• User/Groups and user Folder creation and applying access restrictions. Migrations across the environments DEV, UAT and PROD.
• Worked on Production support issues (SNOW tickets)/L3 Support and timeline solutions for the same.
• Worked collaboratively with ETL team and Data Warehouse team.

Analyst Programmer

Environment: Business Objects XIR2 (Info view, Universe Designer, WebI, Crystal Reports, Publication Wizard, Import Wizard), Vermilion Reporting Suite (VRS), JSP, Jboss, Eclipse, Toad 9.1, Oracle9i, Windows 2000/XP.

Responsibilities:

• Developing of reports as per the requirements using Business Objects Web Intelligence.
• Scheduling the BO reports and make it available for VRS reports data source.
• Importing and exporting bulk requirements from one environment (Dev, QA, and UAT) to production environment.
• Create/modify the Styles, Components, Reports, data sources, record sets and Reference Data (Entities).
• Create/modify the commentary or other manual data using commentary module.
• Place the java files in server folder structure and after bouncing the JBoss server and checking the server log files if VRS system files to generate or preview the reports.
• Conducted Trainings on Vermilion Reporting Suite (VRS) Concepts for Boston and Dublin QA team’s and prepared the Training material.
• Involved in upgrading the VRS tool from lower version to latest version (2.7.3).
• Responsible to support the issues with reports on the BO environments (Development, UAT, Test and Production).
• Develop and implement test scripts for evaluating service packs and future releases
• Evaluate and design web services access points for data access in multiple and dynamic user interfaces.
• Designed, developed and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems using Business Objects XI connected to Oracle data source.
• Set up groups and users for Business Objects deployment in CMC.
• Developed WebI Reports as per the business requirements

Analyst Programmer

Environment: Business Objects XIR2 (Web Intelligence, Info view, Xcelsius 2008 &QaaWS), Crystal Reports, Publication Wizard, Import Wizard, Dashboard Manager, SQL, Windows 2000/NT, Oracle 9i.

Responsibilities:

• Created reports using web Intelligence tools whereas Business Objects Universe as the Data Provider.
• Specified the Joins and checked the cardinalities.
• Implemented Contexts, Joins and Aliases for resolving Loops and Checked the Integrity of the Universes and exported the universes to the Repository making resources available to the users using Designer.
• Check Integrity of the universe.
• Exporting the Universes to repository to make it available to the users.
• Created reports using web Intelligence tools whereas Business Objects Universe as the Data Provider.
• Copying the Reports from one folder to another in infoview.
• Scheduling the Reports as per business needs through Infoview.
• Preparation of Unit Test Cases for reports.

Analyst Programmer

Environment: Business Objects 6.5, Web Intelligence, Informatica 5.1/6.x, Oracle 8i & Windows 2000.

Responsibilities:

• Created list and cross tab reports using Business Objects Web I.
• Worked with Business Objects Designer to modify the existing universe as per the Reporting and Sales Dashboard needs.
• Defined Classes & Objects of the universe and organized the data along dimensions and hierarchies to perform multi dimensional analysis (Slice &Dice and Drill).
• Worked on resolving some of the WebI issues which users had faced
• Created and modified Universe by using @functions, Short-cut joins, Hierarchies and wrote custom SQL in derived tables.
• Provide the Mapping documents for ETL team.
• Created ETL process for different ETL modules based on the requirement.
• Prepared UTP documentation and tested the Jobs, Workflows and mappings for each scenario as per the document.
• Documented all the changes made to the Universes and Reports for future references.