SUMMARY

• Over 14 years of experience in Business Intelligence & Data Analytics technologies Using Query Reporting Analysis and Data Visualization tools.
• Extensive Experience in Tableau Suit Desktop/Server/online 2021.x/2020.x/ 2019.x/2018.x/10.x/9.x/8.x/7.x/6.x and SAP Business Objects 3.x/4. x.
• Expertise in developing complex dashboards using Tableau/Xcelsius, reports using Web Intelligence/Desktop Intelligence/Crystal Reports, Universe development using Universe Designer/Information Design Tool and Report Conversions from DeskI to WebI/Crystal Reports to WebI.
• Performed trouble shooting of performance issues associated with Tableau reports.
• Flexible BI Analyst who has had to adapt to the field’s demands
• Seasoned Veteran who has had to wear different hats on occasion, and picked up tools as per client needs
• Well versed with Tableau, SAP Business Objects, Data Analysis, Reports Development & Data warehousing.
• Expertise in Business Objects Administration involving environment management, content migration and version upgrades.
• Worked on Data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files using Informatica Power Center.
• Supported in major SDLC phases and Agile Methodology for end - to-end BI Application development involving Requirements Gathering, Design, Development, User Acceptance Testing, Production Deployment, Sprint based development and JIRA tracking.
• Good analytical skills on data and impact analysis, data cleansing and data transformations.
• Experience in working with Oracle 12g/11g/9i/8i, MS SQL Server 2000/2010/2012/2014/2018 running on Windows 2000/XP.
• Possess very good understanding of Normalized ER Models (Master/Detail) as well as Dimensional models (Facts/Dimensions, Star schemas and snow flake dimensions).
• Used various Data models as source for reporting including Dimensional Data Model, Star Schema model, Fact, Measures and Dimensions tables, and Transactional and Logical data models.
• Extensive exposure to multiple Business domains including Financial, Banking, Pharmaceutical, Health Care, Retail and Manufacturing.
• Extensive experience in developing data models in HANA 1.0 SP2.
• Created of Business Requirements Documents, Functional and Technical specifications for BI Applications.
• Developed HTML prototypes and UI deliverables, such as wireframes, flowcharts, screen mock-ups, and interface design specifications.
• Proficiency in upgrade, development & maintenance of PeopleSoft Applications.
• Design, develop, test and maintain software to support the PeopleSoft Finance (AP, GL, AR, CM and PO) / PeopleSoft HRMS (Core HR, Payroll, Benefits Administration and Base Benefit).
• A good Team player with the ability to communicate effectively at all levels, possessing excellent presentation, communication and interpersonal skills.
• Experience leading onshore and offshore teams.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows and Linux.

Databases: Workday, Oracle 9i/10g/11g/12g, SQL Server 2005/2008/2012/2018 , Teradata 13.0, DB2, MS ACCESS, HANA 1.0, IBM Netezza.

BI Applications: Tableau Desktop/Server/On-Line 2018.x/10.x/9.x/8.x, SAP Business Objects XI/XIR 2/3.1/4.0/4.1/4.2 , Webi, Deski, SAP BW 7.4, BEX Query, Crystal Report, Dashboard Designer, Xcelsius, Business Explorer.

ETL Tool: Alteryx, SSIS, SSRS, SSAS, Informatica Power Center 9.5.

Data warehousing: Normal forms (OLTP), Star Schemas (OLAP), Snow Flake Schemas, and slowly changing dimensions, Fact & Dimensions tables, SCD Type 1/2/3

Others: PL SQL, T - SQL, ANSI 89, ANSI 92, Report Tuning, Data mining, Free-hand SQL, Data Analyzation, ALM, Microsoft Word, Power Point, Excel, Access and Outlook.

Industries: Financial, Banking, Investments, Pharmaceutical, Health Care, Retail and Manufacturing.

PROFESSIONAL EXPERIENCE

Confidential, Somerset, NJ

Senior Tableau Developer/Tableau Admin/BI Developer

Responsibilities:

• Gathered Business requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Created views/reports in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Worked in the application UI to present to the end users with Tableau dashboards and visualizations in multiple platforms.
• Created Heat Map showing current service subscribers by color that was broken into regions allowing business user to understand where we have most users vs. least users.
• Created customized Tableau Dashboards, integrating Custom SQL from Teradata and Oracle, Hadoop and performing data blending in reports.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic
• Performed Python and R integration in Tableau for statistical analysis.
• Used Google and Adobe analytics data to build the dashboards in Tableau for enterprise website analysis.
• Performed data analysis and data profiling using SQL on various sources systems including Oracle and Teradata.
• Used Data Blending and combined Adobe Marketing Cloud data with other aggregated data, to compare and analyze data in different perspective using Alteryx.
• Developed Alteryx modules for big data analysis of geospatial information and SQL queries
• Wrote SQL code with multiple joins to pull the data from multiple Oracle Database. Optimized and automated the query in Alteryx.
• Developed Tableau Data Extracts for dashboards by creating ETL workflows in Alteryx from multiple data sources and customized data.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Actively involved in the creation of users, groups, projects, workbooks and the appropriate
• Maintained and Installed Tableau Server in all the environments.
• Involved in Performance Tuning of the database, which included creating indexes, optimizing SQL statements and monitoring the server.

Environment: Tableau 2019.x/2021.x (Desktop/Server), Power BI, AWS, Teradata, Oracle 12g, JIRA, Alteryx, Python (Tabpy), SharePoint, MS Office Suite (Word, Excel, PowerPoint).

Confidential, New York, NY

Data Visualization Expert/Tableau Admin/BI Developer

Responsibilities:

• Performed data/systems analysis to determine best BI solution (reports, dashboards, scorecards etc.) using Tableau.
• Used Tabpy and called Python Functions in Tableau using Script Bool, Script INT, Script Real, and Script Str.
• Used web data connector in Tableau and built dashboards using data for various websites.
• Created Ad hoc reports in Tableau 10 to visualize top 10 products based on User count.
• Developed various Dashboards using objects such as Chart Box List, crosstab etc. using Tableau.
• Developed donut charts for analyzing Debit Card Usage, Credit Card Usage, Cash and Other.
• Created different KPI's using Table calculations and calculated key figures (Manipulating strings, arithmetic calculations and aggregation options).
• Created complex formulas and calculations within Tableauto meet the needs of complex business logic.
• Worked extensively with Advance analytics like Reference Lines and Bands, Trend Lines.
• Developed various data connections from data source toTableauDesktop for report and dashboard development.
• Created Technical Documentation for reports and maintenance/enhancements of existing Reports.
• Involved in project planning, scheduling for database module with project managers.
• Created new Data source and replaced with existed Data source. Created Schedules and Extracted the data into Tableau Data Engine.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau, worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images and Maps.
• Effectively used data blending feature in tableau. Defined best practices for Tableau report development.

Environment: Tableau Desktop/Tableau Sever, MS SQL Server 2008, JIRA, Oracle, Apache Hive, Python, Windows 7, Management Studio 2012, Alteryx.

Confidential, Cambridge, Massachusetts

Senior Tableau Developer /Senior Business Intelligence Developer

Responsibilities:

• Gathered business requirements and implemented logical and physical data modeling using star and snow flake schemas in a data warehousing environment of Oracle and SQL Server.
• Built complex formulas in Tableau for various business calculations.
• Acted Flexibly by switching to Workday Cloud as a database for further visualization towards end of the project
• Created HR visualizations on Workday
• Mined data via SSIS and performed backhand SQL query optimization
• Created data marts via SSAS to create more efficient data analysis
• Customized Workday Cloud Visualizations to fit Tablet device layouts as per client’s demand.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps,
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using Tableau Desktop.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics.
• Created and assisted users in Tableau dashboard development.
• Administered and provided production support for Enterprise-wide Tableau application consisting of multiple key functional business domains.
• Worked with business analysts, interpreted business requirements that users looked to dashboards to answer, and created server-based Tableau dashboards with automatic updates.
• Leveraged advanced features of tableau such as calculated fields, parameters, and sets to support data analysis and data mining.
• Worked as a Techno-Functional Consultant for PS Finance 9.1 Reimplementation.
• Worked with Accounts Payable, General Ledger Cash Management on various customizations, which involves Positive Pay, Vendor Interface, Automation of journal entries, Service Fee Automation, Cash Reserve Priority.
• Used Business Objects IDT 4.1 to build multi source universes, resolved loops and Chasm trap in the database schema, involved in performance tuning and optimization on Business objects Universes by creating Aggregate aware objects.
• Performed Data Warehousing and ETL using Informatica Power Center 9.5.
• Developed dashboards using query as a web service and live office to merge data from multiple data providers.
• Managed offshore team, provided them with onsite assistance of gathering requirements from the end users onsite.
• Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report.
• Extensive experience in SQL understanding and used TOAD and MS SQL Management Studio.
• Created new classes, objects and made structural changes to Universes in Designer which includes adding new objects, updating tables and joins.
• Used Crystal Dashboard design and Crystal Presentation Design(both in-built templates and customized templates) to transform complex data in a more consolidated and powerful interactive dashboards.
• Created new Universes and fine-tuned existing ones by resolving join problems, setting up aggregate awareness, defining hierarchies, cascading LOV, @Functions and more.
• Performed troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
• Extensively Designed & Deployed System Reports, Custom Reports, User Report, Ad Hoc Queries by incorporating the functionalities of Sort and Drill Down.

Environment: Workday, Tableau Desktop/Online 9.x/10.x, Windows 7, Business Objects 4.1 SP2, PeopleSoft 9.1,People Tools 8.5, Xcelsius, IBM Netezza, IDT, UDT, CMC, Launchpad, Crystal report

Confidential, Richmond, VA

Senior Tableau Developer/Lead SAP Business Objects Developer

Responsibilities:

• Developed new Compliance reports and Dashboards which were to identify and report security breaches and change in Suspicion status of suspected breaches.
• Customized the Tableau landing page with site listing as icons and descriptions.
• Connected to DB2 by IBM as a database engine
• Constructed the reports page for internal strategy group with standardized custom right and left side sections within Tableau.
• Used Tableau API to customize the views, selects, filters, date and time.
• Generated tableau dashboards with combination charts for clear understanding.
• Interacted with users to gather and analyze requirements for the new Compliance Reports.
• Acquired the understanding of the complex logical and physical design of the reporting system.
• Data blending implemented on CITAM databases and generated interactive dashboards for Conduct Risk and Conduct Rules Reporting
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Integrated Tableau Dashboards/Story Points views with SharePoint
• Created complex universes using IDT on Compliance Data Repository for multiple projects
• Optimized SAP BO universes designed and developed a series of complex Business Intelligence solutions using Business Objects Designer, Desktop Intelligence, Web Intelligence and Crystal Reports.
• Secured sensitive data by applying a security feature of object level security in the Universe and the report level security in the CMC. Scheduled recurring daily, weekly and monthly reports.
• Set Row level Restrictions to different user groups based on their profiles.
• Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report. Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Conducted thorough unit and System Integration Testing of the reports and dashboards prior to handover for the User Acceptance Test
• Effectively used JIRA for Defect Management during System Integration Testing and User Acceptance Testing
• Created User Manuals and conducted training to the User Group prior to Go live

Environment: Tableau/Server 9.3, Windows XP, Linux, Windows 7, Oracle 11g, Business Objects XIR4.1 SP1, Business Objects 4.2 SP2, Xcelsius, DB2, SQL Server 2012

Confidential, New York NY

Senior Business Intelligence Developer/Tableau Developer

Responsibilities:

• Responsible for gathering the requirements from the Users and designed the Detailed design specifications for Business Objects Reports and Tableau Dashboards
• Developed new reports/visualization along with modifying existing reports/dashboards to support new and additional Business requirements for CCAR and DFAST Federal Reporting
• Developed complex reports and dashboards using Crystal Reports, Business Objects and Tableau accessing multiple data sources.
• Created Tableau Dashboards to produce different views of data visualization and presenting dashboards on web and desktop platforms for End-User to help in the Capital Planning process.
• Designed and deployed rich Grap hic visualizations using various reporting objects like Facts, Attributes, Hierarchies, Transformations, Local and Global filters, prompts, Calculated fields, Sets, Groups, Parameters and Drill/Drop Downs in Tableau
• Developed Vetting Deck Dashboards, score cards, Metrics, what if analysis, prompts, Drills, Search (using Add-ons), to depict Provisions, Net Charge Offs, Ending Reserves and Losses across multiple Asset groups.
• Published Webi and Deski reports.
• Used Shared and Global variables to pass data from Main report to Sub report & vice versa.
• Design ad hoc reports as per user requirements.
• Created reports using DESKI and WEBI. Handled Embedded Functions like @functions in the Designer to handle User requests for report generators.
• Addressed chasm trap and Fan Trap using Multi Parse SQL.
• Scheduled reports through CMC and Info view.

Environment: Tableau 7.x and 8.x, Business Objects XI R3.1, Tableau 8.0, Apache Tomcat, Oracle 10g, Xcelsius

Confidential, Portsmouth, OH

Senior SAP Business Objects Consultant/Tableau Developer

Responsibilities:

• Migrated Web Intelligence reports, Crystal reports and dashboards from XIR2 to XIR3.1.
• Tested reports and universes, debugged and resolved the defects identified after migration.
• Assisted in creating Tableau dashboards for presenting key metrics related to Pharmacy shipment and Order received status.
• Involved in daily scrum meetings to discuss what tasks have been achieved, what needs to be done and what are the loopholes.
• Installed and configured Business Objects XIR3.1 in DEV, IT, QA and PROD environment.
• Set up clusters in various environments.
• Responsible for installing Business Objects, Xcelsius, Toad and Crystal Report client tools for different users.
• Implemented security set up for users and Groups.
• Unit tested and fixed issues identified in BOXI 3.1 universes and reports migrated from BOXI R2.
• Fixed the bugs caused after migration in dashboards.
• Used life cycle manager to promote the jobs from DEV to QA.
• Checked Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
• Optimized Crystal Reports performance for large reports (reduced page generation time).
• Used Toad to verify data pulled by the report is correct compared to the database data and also to verify the joins used in designing the universe are correct.
• Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report. Prepared user documentation for hands on training for end user community.
• Created Classes, Dimension objects, Measure objects and Detail objects in the universe.
• Resolved issues related to RDBMS flaws such as Fan Traps, Chasm Traps using BO multi parse SQL functionality.
• Analyzed data using Slice/Dice and Drill Mode. Created various highly interactive dashboards and data visualizations reports for Ad Sales and Program Finance departments.
• Created several Tableau data extracts with prebuilt calculations, parameters and sets to enable end users to easily utilize the extracts as semantic layer to create their own workbooks.
• Developed Metadata Models in Tableau and dashboards.

Environment: Tableau 6.4, Business Objects XI R3.1, XIR2, Tableau 6.x, windows 2008 Server, Apache Tomcat, Oracle 10g, Xcelsius.

Confidential, Melville N. Y

SAP Business Objects Consultant/Tableau Developer

Responsibilities:

• Interacted with the management and business Decision-makers to identify business requirements.
• Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer.
• Used Tableau type conversion functions when connecting to relational data sources.
• Created incremental refreshes for data sources on Tableau server.
• Created report schedules, data connections, projects, groups in Tableau server.
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for creation of the universe with Classes, Objects and Condition Objects.
• Created Aliases and Contexts to resolve the Loops and Traps (fan traps and chasm traps)
• Leveraged BW queries in to generate WEBI reports using BI Launch Pad in BO to meet user requirements.
• Created monthly and summary reports in WEBI for the different domains like Finance, Marketing and HR domains.
• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
• Created WEBI reports & Crystal reports and deployed them through Info view with BEX as source
• Created Marketing and Finance Dashboards for FP&A, Inventory Management and Cost Center Accounting data.
• Exclusively used QA AWS and Live Office to import data to spreadsheet and develop visually rich dashboards.
• Worked on optimizing the performance of the dashboards.
• Reduced the dashboard loading time by scheduling the backed source webi reports and by selecting the filter option changing with refresh on trigger option to pick from the latest instance.
• Created Dynamic Dashboards using SAP BI data/ Bex Queries.
• Extensively worked on Xcelsius Dashboard using Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.

Environment: Tableau 6.4, Business Objects XI R3.x, windows 2003 Server, Windows XP, IBM WebSphere Portal Server, Oracle 10g.

Confidential, New York NY

SAP Business Objects Developer

Responsibilities:

• Created WEBI/DESKI reports involving complex queries, sub queries, Unions and Intersection.
• Designed Universes, creating prompts and queries. Applied Contexts and Aliases to remove loops.
• Imported data from Excel to compare Actual Vs Budget.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
• Customized the reports with custom functions and loops to leverage the user reporting needs.
• Interacted with users, gathering and analyzing requirements, logical and physical design of the reporting system.
• Develop detailed documentation for training and testing. Train end users in job specific tasks and prepared traceability matrix from the requirements for testing purposes.
• Designed a Hi Performance universe by joining several dimensions to the fact table like Accounts and Returns.
• Demoed Celsius (2008) dashboards to summarize the bestselling product and dashboards displaying sales by store and region.

Environment: Business Objects XI R2, Crystal Reports X and Oracle 10g.

Confidential, Parsippany NJ

SAP Business Objects Migration Consultant

Responsibilities:

• Gathered Requirements gathering from the Business and designed the detailed design for the Business Objects Universes and Reports.
• Responsible for creating Universes, Desktop Intelligence, Full client, Web Intelligence and OLAP repots in Business Objects XIR2/6.5.
• Migrated Reports, universe, connections, users and groups from 6.5 to XIR2.
• Created and modified group accounts and user accounts.
• Applied user and group rights to objects such as top-level folder security and object level security.
• Created linked reports in web Intelligence using OPENDOC functions.
• Created Applications, Dashboards, Metrics, Menus, Rules, Alerts and Analytics using application Foundation 6.5.
• Deployed QAAWS from import wizard.
• Used query as web option to build visualizations based on the reports built in Business Objects.
• Set the Row level Restrictions to the different user groups based on their profiles.
• Modified report content, distributed reports in multiple formats such as Excel & PDF and monitored the reports daily in Business Objects environment.
• Created large and complex reports using Universes, Personal Data files, Free Hand SQL, Stored Procedures and migrated the already existing excel reports to Business Objects.
• Scheduled the reports using Broadcast Agent and distributed the reports as per the requirement as mail attachments in various formats like XLS, PDF and monitored daily reports using Broadcast agent console.
• Configured the web and application servers for the new Business Objects server as a part of migration from Business Objects 6.1 to 6.5.
• Provided technical support to the users and business analysts like installing Business Objects desktops products on user machines etc.

Environment: Apache Tomcat, Oracle 9i, Business Objects 6.5 - XI, Xcelsius

Confidential, New York, New York

SAP Business Objects Developer /BO Admin

Responsibilities:

• Performed Star Schema customization / Design session.
• Wrote functional specification document for the security implemented in Business Objects.
• Developed new reports along with modifying existing reports to support new and additional Business requirements.
• Extensively wrote PL/SQL procedures to get data from Oracle database.
• Troubleshoot problems and customize the application according to the specifications of the analysts.
• Developed and scheduled reports in Web Intelligence on recurring basis.
• Created complex Universes and report for GL, AP and AR.
• Created Custom Hierarchies for several groups.
• Designed and developed drilldown and summary reports for Sales Forecast.
• Created detail and summary reports, used to fold/unfold sections corresponding to breaks in current blocks for Desktop Intelligence Reports.
• Extensively used relevant graphical representation such as bar charts, pie chart etc., in Webi reports
• Implemented extensive use of derived tables in the process of building reports.
• Created interactive Excel Dashboard in Crystal Xcelsius 4.5.

Environment: AIX, SQL, Oracle 10g, Business Objects 6.5.

Confidential, Manhattan, NY

SQL Database Developer/SAP BO Developer

Responsibilities:

• Gained understanding of the Requirements, System architecture and diagrams.
• Responsible for functional setups of newly established units and configured the data migration for various categories such as vouchers, books, store’s location, financial year, category creation.
• Wrote SQL scripts to create Staging tables and developed packages to load files /legacy data into the ERP Application
• Used DTS Wizard to move data to different databases.
• Worked on developing excel reports using with SQL Server data as a source.

Environment: MS Excel, MS Words, MS Visio, SQL Server 2005