PROFESSIONAL SUMMARY:

• A dynamic professional with 11 years of experience in Data warehousing and Business Intelligence technologies along with around 4 years of data visualization using Tableau.
• Expertise in Business Objects 4.1, 4.0, XI R3/R2, Tableau 2018.2 and Business Objects Administration etc.
• Worked in all phases of BW/BI full life cycles including analysis, design, development, testing, deployment, post - production support/maintenance, documentation and end-user .
• Produced attractive Tableau visuals/dashboards to convey the story inside the data using techniques for guided analytics, interactive dashboard design and visual best practices.
• Designed Business Objects Universes and efficient information frameworks, implementing business rule as per business requirement. Created complex Business Objects reports /scorecards.
• Involved in trouble shooting of performance issues which were associated with Business Objects reports and Tableau Dashboards.
• Extensive knowledge in SQL, PL/SQL& T-SQL programming and trouble shooting.
• Good Knowledge of Data Warehouse Concepts including Schemas and Data Modeling.
• Good knowledge in ETL methodology for Data Extraction, transformations, loading.
• Good understanding of business environment, strong analytical, problem solving abilities, excellent communication skill and ability to work proactively in a fast paced environment.
• Comfortable at coordinating and managing the teams of small size.
• Has strong ability to learn new Technologies in a short span. A project planner with expertise in planning, executing and spearheading various SDLC/Agile projects in compliance to quality standards.
• Got Kudos, Bravo and Pet on Back (PoB) for defect less delivery.

TECHNICAL SKILLS:

BI Reporting Tools: SAP Business Objects 4.1(UDT, IDT, WebI Rich client, CMC, BI Launch pad etc.), BOXI R3.1, BO Administration, Crystal Reports

Data Visualization Tool: Tableau Desktop 2018.2, Power BI

Databases: Oracle 11g, MS SQL Server 2014/2012/2008, Maria DB

Agile Project Management: JIRA

DB Tools: Quest Toad, PL/SQL Developer

Languages: PL/SQL, .NET, HTML

Domain Knowledge: Consumer & Community Banking(Vendor Management, Clarity/Budget Reporting), Investment Banking, Energy, Retail

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington

Tableau/Business Objects Developer

Environment:

Languages: SQL

Database: MS SQL Server 2014/2012/2008, Maria DB

Tools: Tableau 2018.2, SAP Business Objects 4.1(IDT, WebI Rich client, CMC, BI Launch pad etc.), JIRA

O/s: Windows 10

Responsibilities:

• Understanding requirements of the Business users and propose the solution which would be best suitable for their requirements.
• Interaction with the client on various forums for project status discussion, clarification of raised queries around the new functionalities and the area of improvement for the existing functions of the application etc. Developing and maintaining strong client relations with senior level executives—developing new insights into the client’s business model, pain points and delivering actionable high-impact results.
• Designed, developed, tested, and maintained Tableau functional dashboards based on user requirements. Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
• Converted existing BO reports to tableau dashboards.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Donut Chart.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Design and develop BO reports, scorecards and dashboards. Design Report-Layouts, Unit test reports and validate against test cases. Identify the performance bottle-necks in the report and resolve the same.
• Design BO Universes and efficient information frameworks, implementing business rule as per business requirement.
• Involved in creation of high level detail design documents for reports using the Business requirement document and facilitating design sign off from the users.
• Involvement in the review of all on-going development activities of reports/dashboards and making sure that required changes occur within the prescribed timelines.
• Need to define the best application of the Agile processes and continuously increasing productivity and efficiency. Involvement in the continuous & improving the motivation factor of the offshore team to procure the best end result.
• Involved in making necessary enhancements in the Business Objects universe.
• As a part of the development team I have developed crucial reports which met all the Business requirements. Responsible for assisting customers in resolving simple to intermediate issues by troubleshooting critical problems on mission critical deployments.
• Responsible for testing the reports to see if they meet the client’s requirements.
• Involved in Design of Test Strategy, Creation of Unit Test Plan, Testing and logging Test Results. Tracking Defects found during testing.
• Migrating of reports/universes from DEV, SIT, QA and UAT environment.
• Knowledge of Onshore - Offshore model of working and coordinating with offshore team.

Confidential

Business Objects/Tableau Developer

Environment:

Languages: SQL

Database:Oracle 10g

Tools: SAP Business Objects 4.1(UDT, IDT, WebI Rich client, CMC, BI Launch pad etc.), BOXI R3.1, BO Administration, Tableau Desktop 8.3

O/s: Windows 7

Responsibilities:

• Responsible for understanding business requirements, analysis and development of reports and ensuring a smooth bug free delivery.
• Involved in migration of reports from BO 3.1 to BO 4.1.
• Involved in creation of high level detail design documents for reports using the Business requirement document and facilitating design sign off from the users.
• Involved in making necessary enhancements in the Business Objects universe.
• As a part of the development team I have developed crucial reports which met all the Business requirements. Responsible for assisting customers in resolving simple to intermediate issues by troubleshooting critical problems on mission critical deployments.
• Responsible for testing the reports to see if they meet the client’s requirements.
• Involved in Design of Test Strategy, Creation of Unit Test Plan, Testing and logging Test Results.
• Tracking Defects found during testing.
• Preparing the SQL query to fit into the existing data model of the universe.
• Analyzing the SQL query for developing the BO report, which can be achieved in universe level and report level?
• Migrating of reports/universes from DEV, SIT, QA and UAT environment.
• Created complex User Prompts by using @prompt function at the universe level.
• Creating Publications basing on different requirements and scheduling them.
• Developed a new universe according to the new data model which is faster compared to the old DM.
• Set up aggregate awareness for the universe.

Confidential

Business Objects Developer

Environment:

Languages:SQL

Database: Oracle 10g

Tools: Business Objects XI R3.1(Universe Designer, WebI Rich Client, DeskI, Import wizard, Infoview, Publishing wizard, CMC)

O/s: Windows XP

Responsibilities:

• Understanding the Service requests/Incidents in TSG Service Now Tool( Confidential Product) raised by users for various issues.
• Solving issues related to Break-fix in reports, Enhancements of reports (universe level or report level), Scheduling of reports, Data mismatch in report, Formatting, BO Server related, Universe Access to users, User Authentication, BOXI Installation etc.
• Working harmonically with users and other related application teams (ETL, Source Team, DBA, UNIX etc).
• Arranging and attending calls with users and other related teams whenever required.
• Monitoring and sending status mail of scheduled reports for daily/weekly/monthly.
• Maintaining the application, changing/modifying existing reports etc.
• Migration of reports and universes from one environment to another.
• Handling outages and preparing MOM of weekly status calls.
• Raising tickets in SAP and working with SAP team for critical issues.
• Migrating of reports/universes from DEV, SIT, QA and UAT environment to Production
• Checking/monitoring health of the BO Production server.
• Assigning proper rights to users.

Confidential

Business Objects Developer

Environment:

Languages:SQL

Database: Oracle 10g

Tools: Business Objects XI R2(WebI, Designer)

O/s: Windows XP

Responsibilities:

• Understanding the functionality of the application.
• Understanding the customer supplied documents.
• Understanding the business requests clearly and addressing business concerns.
• Working harmonically with onsite counterpart and other related application teams.
• Implemented Business Objects functionalities like Derived table, Report level variables, Functions and Formulas etc.
• Responsible for the correctness of the reports in accordance with the requirement.
• Created User Prompts by using @prompt function at the universe level.
• Tuned the SQL query to reduce the execution time of the report.
• Developed the BO reports which will open a child report in PDF format by clicking the hyperlink in the parent report, by passing the required prompt values to the child report from the parent report.
• Arranging and attending calls with onsite members and other related teams whenever required.
• Maintaining the application, changing/modifying existing reports etc.
• Function design, coding, review and testing. Preparing status calls documents and release documents.

Confidential

Business Objects Developer

Environment:

Languages: PL/SQL

Database: Oracle 10g

Tools: Business Objects XI R2

O/s: Windows XP

Responsibilities:

• Gathering User Requirements. Analysis of the specifications provided by the clients
• Extensively involved in solving issues related to Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Done Unit Testing, Data validation Testing and Integration Testing for the BO reports. Involved in writing test cases as well.

Confidential

Business Objects/Crystal Report Developer

Environment:

Languages: PL/SQL

Database: Teradata

Tools: Business Objects XI R2, Crystal Report 2008

O/s: Windows XP

Responsibilities:

• Extensively involved in solving issues related to Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Created User Prompts, Conditions and Filters.
• Implemented Business Objects functionalities like Slice and Dice, Drill down, Functions and Formulas etc.
• Designed and modified the Crystal reports as per client's requirements.
• Done Unit Testing, System Testing, Data validation Testing and Integration Testing for the crystal reports.
• Executed the tasks under tight delivery schedules and delivered on time.

Confidential

Business Objects Developer

Environment:

Languages: PL/SQL

Database: Oracle 10g

Tools: Business Objects XI R2

O/s: Windows XP

Responsibilities:

• Extensively involved in the designing and building of Universes, Classes and Objects.
• Created Universes by retrieving the data from various data sources, defining the connections necessary. Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes. Created the reports using Business Objects functionalities like Slice and Dice, Drill down, Functions and Formulas etc.