SUMMARY:

• Having 13 years of extensive working experience in Business Intelligence, Data Visualization and Data Analytics.
• Exposure to BI Architect, Project Management, Team leadership, Technical leadership and Project leadership skills.
• Expert in Data Warehousing projects using SAP Business Objects 4.1/3.1/XI R2, Xcelsius, SAP Business Objects Dashboards, SAP Lumira, Tableau, Qlikview, SSRS, SSIS, SSAS, OLTP, Cognos, OBIEE, ETL and OLAP.
• Created interactive Tableau Dashboards.
• Used various features like calculated fields, filters, highlighting, hiearchy, blending, data joins, dual axis charting, storyline, prompt, pivot, exporting, quick filter, bins and shapes of Tableau to create piechart, bar chart, scatter plot, map reports and Interactive Dashboards.
• Involved in business analysis and feasibility study of the client requirements.
• Developing Ad - hoc Reports, scheduling the processes and administering the BO activities using Business Objects XI 4.1/3.1/XI R2 (CMC, CMS, Designer, Information Design Tool, Info view, Reporter, Live Office, Xcelcius), Web Intelligence Rich client (Webi), Desktop Intelligence (Deski)
• Well qualified in creating Ad-Hoc reports using Business Objects Web Intelligence Rich client.
• Knowledge in in Oracle7.x/8/9i/10g/11g/12c development using SQL, PL/SQL, Stored Procedures, Triggers, Functions, Indexes, Materialized views etc.
• Experience in developing logical and physical data models using Erwin designer.
• Experience in Designing and developing analytics using Dashboard Performance Manager.
• Involved in projects for IMF, Confidential, Confidential, Confidential, HP, Confidential, Confidential, Confidential, Confidential and BV.
• Exposure to finance, telecom, HR, risk management and sales projects.
• In depth knowledge of PMBOK methodologies to manage and control projects.
• Exposure to Agile and Scrum methodologies.
• Extensively used Break, Section, Calculations, Sorting, Rank, Drill Up down, Drill through and Formatting, Changing Displays and Prompts while creating Business Objects reports.
• Created dashboards by using Business Objects Xcelsius/Business Objects Dashboard.
• Extensively used Information Design Tool to create Business Objects Universes.
• Extensively used Web Intelligence Rich Client to create Web Intelligence reports.
• Knowledge in Big Data technologies, SAP HANA.
• Knowledge in Cognos, OBIEE, Microstrategy, Teradata

TECHNICAL SKILLS:

BI Tools: SAP BusinessObjects 4.1/3.1/XIR2/6.x/5.x (Designer, Information Design Tool, Launchpad, Infoview), Web Intelligence (Webi), Desktop Intelligence (Deski), Webi Rich Client, SSRS, Cognos, IDT, UDT, OBIEE, Microstrategy

Data Visualization Tool: Tableau Desktop, Tableau Server, Tableau Public, SAP Lumira, Qlik, QlikView

ETL Tool: Oracle Warehouse Builder 10g, Informatica 6.1/7.1/8.6, SSIS

Operating Systems: Windows, UNIX

DBMS: SQL, PL/SQL, Oracle8/9i/10g/11g/12c, MS SQL Server 2008, Teradata, MySQL, DB2, Sybase

Applications Servers: Tomcat, Web logic, Websphere

Version Control: VSS, Share point, SVN, DM5, TFS

Other Tools: Erwin, SQL Loader, SQL Developer, TOAD, SQL navigator, Tidal, Reflexion, Putty, Visio, Microsoft Project, SSAS

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

Responsibilities:

• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications about the financial system for Business Objects Universes and Reports.
• Converted the reports from Business Objects Desktop Intelligence to Web Intelligence.
• Migrated the reports from Business Objects 3.1 to Business Intelligence 4.1.
• Created various interactive Tableau Dashboards.
• Used various features like calculated fields, filters, highlighting, hiearchy, blending, data joins, dual axis charting, storyline, prompt, pivot, exporting, quick filter, bins and shapes of Tableau to create piechart, bar chart, scatter plot, map reports and interactive dashboards.
• Involved in leading the project.
• Designed and developed numerous Universe, Classes and objects based on the client requirements.
• Involved in having daily meetings with project stakeholders and Business Analysts.
• Directly coordinating with user to gather the new requirements and working with existing issues.
• Created the reports using Business Objects functionalities like Queries, Drill up/down, functions, Cross Tab, Filter and Formulas etc.
• Involved in using TFS for version control of SQL code/universe/BO reports.
• Involved in testing of the reports before it’s being deployed to production.
• Invovled in production support for the business objects reports.
• Got training in Reuters Paisley reporting tool, QC and ALM.

Confidential

Responsibilities:

• Designing and developing business objects reports in Web Intelligence and Desktop Intelligence.
• Created reports by using Business Objects Rich Client and using ACL/ACA to validate the data.
• Created reports for Risk Management Group and Credit Risk Reporting.
• Created various interactive Tableau Dashboards.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Created MS-Access Queries, Macro, tables and Excel-pivoting to create management reports.
• Designing and developing business objects universes.
• Involved in having daily meetings with project stakeholders and Business Analysts.
• Created simple and complex BO reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, Ranking and multiple data.
• Project Management and Project Leading.
• Involved in using SVN for version control of SQL code/universe/BO reports.
• Involved in testing of the reports before it’s being deployed to production.
• Designed and developed numerous Universe, Classes and objects based on the client requirements.
• Developed universe and reports by using Designer and InfoView respectively.
• Worked on regulatory reporting for MAS (Monetary Authority of Singapore)

Confidential

Responsibilities:

• Designing and developing Business Objects universes by using Information Design Tool. (IDT).
• Designing and developing Business Objects reports in Web Intelligence Rich Client and Desktop Intelligence.
• Creating oracle tables, views, packages and stored procedures.
• Project Management and Project Leading.
• Preparing Dashboards using calculations, parameters in Tableau.
• Deep experience with the design and development of Tableau visualization solutions.
• Created Tableau dashboards using live connections and extracts based on excel data and database.
• Extensively used parameters, quick filters, actions, sets, hierarchies, user/group restrictions, Initial SQL, custom shapes, table calculations and other features in Tableau dashboard.

Confidential, NY

Responsibilities:

• Project Management and Project leading.
• Designing and developing business objects universes.
• Designing and developing business objects reports.

Confidential, Stamford, CT

Responsibilities:

• Created the reports using Business Objects functionalities like Queries, Drill up/down, and functions, Cross Tab, Filter and Formulas etc.
• Designed Universe by defining joins, cardinality between tables using BUSINESS OBJECTS.
• Working on Oracle SQL programming involving complex join conditions.
• Involved in reporting production support for Confidential users.
• Involved in using SVN for Version Control for universe and reports.

Confidential, Houston TX

Responsibilities:

• Developed universe and reports by using Designer and InfoView respectively.
• Involved in moving the universe/reports from Development to Staging, Staging to Test and Test to Production environment.
• Designed and developed numerous Universe, Classes and objects for the client requirements.

Confidential, Buffalo, NY

Responsibilities:

• Project management and project leading.
• Installed Business Objects XI R2 in Development Servers.
• Configured Central Management Server and set the access rights and granted Privileges on Central Management Console.
• Developed universe and reports by using Designer and InfoView respectively.

Confidential

Responsibilities:

• Project Management and Project Leading.
• Installed Business Objects XI in Development, Test and Production Servers. Configured Central Management Server and set the access rights and granted Privileges on Central Management Console.
• Configuration and administration of Business Objects XI R2.
• Designing and deploying reporting dashboards based on defined KPI(s).
• Involved in developing Proof of Concept (POC) for use of Business Objects XI.

Confidential

Responsibilities:

• Project Management and Project Leading.
• Installation, configuration and administration of Business Objects XI R2
• Migration of Business Objects 5.1.6 repository to Business Objects XI R2
• Maintaining migrated universe and reports by using Designer and Info view respectively
• Created Various Cross Tab and Tabular Reports to view the data in an analyzed way.

Confidential

Responsibilities:

• Worked on installation and configuration of Business Objects XI R2 Enterprise Suite (Desktop Intelligence, Central Management Server, Central Management Console, and Auditor).
• Design and Develop Web Intelligence Reports using Business Objects XI and Dashboard Performance Manager
• Involved in developing Proof of Concept (POC) for use of Business Objects XI.
• Created Various Cross Tab and Tabular Reports to view the data in an analyzed way.

Confidential

Responsibilities:

• Installed BOXI R1/R2 in Development Servers and helped the onsite team to maintain BOXI R1/R2 Test/Production servers.
• Designed & Developed ETL Script using PL/SQL
• Designed and Developed Data Marts Designed and developed Universe and generate Reports using Business Objects XI from Materialized views created from the oracle tables.
• Designing and deploying reporting dashboards based on defined KPI(s).

Confidential

Responsibilities:

• Involved in developing Reports using Business Objects 6.5.
• Generated the Business Objects Reports using the universe as the main Data providers and writing the complex queries including Sub queries, Unions, Intersect and Aliases.
• Created and managed Universe in the Designer.