Business System Analyst

POOVIZHISELVI R *************.*@*****.***

BUSINESS SYSTEM ANALYST +1-248-***-****

Workday Reference :

Oanh Vu (****.**@*******.***)

Akshata Brahmavar (*******.*********@*******.***)

Annamalai Vairavan (*********.********@*******.***)

Harinder Singh (********.*@*******.***)

10+ years of IT experience in Analysis, Design, Development and Implementation of Enterprise Data warehouse projects using ETL processing tool Informatica 7.x,8.x,9.x with OLAP reporting tool Tableau 9.x, 10.x, Business objects XIR2, BOXIR3.1, BOXI R4.1, Microsoft Power BI, OBIEE in various domains like Software, HealthCare, Manufacturing, insurance, Software & Services, retail and Banking.

As a Business Analyst, working on Stakeholders requests, Quarter End Activity, Reconciliation task, Restatement, Policy implementation at Dashboard level, QBR deliverables, Production Data issues, Performance issue, Access request, Report development on different slice and dice level for Business Units or Cross functional etc.,

Extensively working with Report Development Tools –Tableau, Business Objects, Power BI,OBIEE

Extensive hands on with Salesforce Sales analytics and objects.

Worked on Salesforce CPQ modules Quotes and Pricing for Opportunity to calculate the accurate List price.

Developing, Designing and supporting interactive Tableau reporting and dash boarding using OLAP.

Working directly with stakeholders on requirement gathering and dashboard deliverables.

Translating business requirement to IT team to get the required data for Dashboard development.

Handling the ad-hoc requirements from different stakeholders

Worked with different data sources like SAP HANA, Salesforce, Oracle, SQL server, HAWQ SSE, Flat files for various report and dashboard development

Created solution driven dashboards by developing different chart types including Crosstab’s, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.

Designed Dashboards with Quick filters and Parameters to handle views more efficiently.

Extensive knowledge in creating data visualizations using Tableau Desktops and regularly publishing and presenting dashboards

Extensive experience on building Interactive dashboards using Tableau.

Worked on Salesforce data extraction, done cleansing activity and updating data back to Salesforce using informatica cloud.

Worked on Salesforce tables on Order management, Case Management and CMT data.

Implemented Tableau/Oracle BI security at the Data (Data security) and Object (Roles and Permissions) security

Expertise in Business Objects enterprise Products (Universe Designer, Desktop Intelligence, Web Intelligence, Info View, CMS, CMC & CCM)

Extensively used various features like Joins, Alias and Contexts in Universe designer to overcome various traps (Chasm, Fan) and Loops.

Experience in building and retrieving data using Universes, Personal data files, and creating complex ad-hoc Reports using the Business Objects suite applications.

Extensively worked on universe development inclusive of fan trap, chasm trap, @ functions, aggregate awareness, hierarchies, row and column level security, prompts.

Experience in BO Crystal Reports and resolved performance issues.

Experience in designing and implementing ETL environments using ETL strategies as well as tools like Informatica Power Center 9.x/8.x.

Having Experience in Informatica Powercenter 9x and Informatica cloud

Worked on Informatica cloud on synchronization, replication and task flow tasks.

Good in data warehouse concepts/data warehouse architecture and best practices.

Excellent knowledge of software development life cycle activities including analysis, design, development, unit testing, regression testing, production deployment and Maintenance.

Having Knowledge on Amazon and Hadoop Cloudera database connectivity with Tableau.

Quick learner, excellent communication skills and good performer both in team and independent job environments. Never missed the deadline of any projects.

Maintained positive communications and working relationships at all business levels

CERTIFICATION: ORACLE OCA CERTIFIED PROFESSIONAL

TABLEAU DESKTOP SPECIALIST

EDUCATIONAL DETAILS:

M.Phil in Computer Science from Bharathidasan University (2006-2008)

M.C.A from Bharathidasan University (2002-2005)

BSC in Computer Science from Periyar University (1999-2002)

WORK EXPERIENCE

DATA QUALITY ANALYST - Workday Pleasanton, CA – Aug 2020 – Feb 2021

SENIOR BUSINESS ANALYST - Workday Pleasanton, CA – July 2019 – October 2019

RESPONSIBILITIES:

Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Tableau Reports.

Interacting with different stakeholders to handle day to day issues on the Sales KPI dashboards.

Getting data from Sales force from different objects and loading the data into the AWS redshift by using Alteryx for data validation.

Validated the EDW data with the source data using Excel, data base and Alteryx.

Understanding the business requirement to test the data for Tableau dashboards.

Writing queries to validate the tables and tracking the error details until we get the sign-off.

Creating the Column level mapping for Table design.

Understand the relationship between the objects in Salesforce and EDW to complete the testing according to Business rules.

Developed dashboards using Workday and Adaptive Insights data in Tableau.

Extensively worked on User level testing, Regression testing on Column and object level.

Documented the Issues and tracking the details in Google sheets.

Extracting data from Google BigQuery and Google sheets to develop the Account Certification dashboards.

Used to analyze the bad records by implementing business logic and built the score cards for various Salesforce objects called Contacts, Lead and Agreement etc.,

Used various Data quality metrics like uniqueness, completeness, accuracy, validity etc to show the scorecards.

Worked in various team like Sales, Finance and MDM.

Sharing the Knowledge transition with the new team members and guiding them to understand the project.

SENIOR BI ARCHITECT - Nov 2019 to Aug 2020

SENIOR BUSINESS ANALYST VMware Inc.- Palo Alto, CA – March 2018 – June 2019

Client: VMware Inc.- Palo Alto, CA

RESPONSIBILITIES:

Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Tableau Reports.

Interacting with different stakeholders on requirement gathering, ad hoc requests, Quarter end reports needs, Reconciliation, Product hierarchy changes, QBR dashboard developments, Commission data preparation etc.,

Developed and modified the reports and dashboards as per Business requirement with the quality and coding standards prescribed for the module.

Used Business Intelligence Reporting Tool and Tableau to create QBR to provide the quarter end results to Wall street.

Extensively worked on Google and Microsoft tools to track and share the Project details with the team.

Developed reports and dashboards based on policy change for different functional areas.

Developed the dashboards to view the sales threshold, sales and profit comparison for the different region and years.

Connecting data from Sales Force and developing dashboard for Sales, Commissions and YOY growth etc.,

Integrate the Tableau dashboards back to Salesforce every quarter end to show the company wise growth to stakeholders.

Developed Sales Analytics dashboards for Sales team, QBR for finance team and Discount trend analysis for DVM team. Worked in cycle of Sales, discounts and finance team to get the business knowledge.

Tracking the MRR sales revenue dashboard for Sales and Services along with Contract values.

Working on Subscription (SAAS), Perpetual & Support and maintenance data to make the Discounting and Pricing calculations.

Developing the reports and dashboards to track the year on year growth and KPI on various functional areas.

Involving in reconciliation task which required for quarter end on various areas like billing, discount, allocations etc.,

Extracted data from various sources and performed data blending.

Created different type of charts, worksheets and dashboards by using custom queries and multiple tables.

Created various interactive customized dashboards and stories.

Applied various types filters like Data source filters, Quick filters and Context Filters.

Created table calculations, calculated fields and parameters.

Publishing sheets and dashboards on server.

Worked on SQL queries to validate the reports.

Developed complex reports and visualizations using Tableau Desktop as per requirements.

Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.

Executed and tested required queries and reports before publishing.

Validate the data for each report and review the reports.

Generated high detail oriented views using multiple measures, Individual Axes, Dual Axes .

Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters and date functions. Also updating the weekly status and tracking the query sheet.

Used to implement Oracle functions and procedures to bring the different level of hierarchical data into Tableau reports.

Created Stories using Tableau as part of report presentations to Business.

Connecting to the Salesforce tables to get the Product Issue ticket information and doing the data analysis to provide the Predictive analysis in Tableau Dashboard

Using different data sources like Salesforce tables, SAP Hana, Oracle and Hadoop HAWQ SSE for Dashboard creation.

Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.

Tracked status of Tableau reports and Dashboards

Actively participated in Testing, Code review and Knowledge Transition.

Applied security features of Tableau like row level, report level security in the reports to make the sensitive data secure.

Creating User stories in Jira to document the requirement to design to track the task.

Conducting or participating in Scrum calls to discuss the team/individual status.

Hands on Experience on Salesforce CPQ for pricing reference. Calculate the Accurate List price using Pricing and Quoting.

Worked in DVM team to guides the Products discount for each Product and BU.

Creating mapping document for technical designs and Documenting the BRD, Test cases etc.,

Environment : SAP HANA, Tableau Desktop 2019.1.2, Tableau Server 2019.1.2, SAP Business Objects, Microsoft Power BI, HAWQ, Greenplum, Postgres SQLMS Excel, Oracle, TOAD, SQL Server, Impala, Flat files

TABLEAU LEAD

Blue Shield of California Health Data Reporting – Chennai India - August 2014 to April 2016

RESPONSIBILITIES:

Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Tableau Reports.

Developed and modified the reports as per Business requirement with the quality and coding standards prescribed for the module.

Analyzed financial data to identify relationship between operations and payment trends

Streamlined billing and operations processes to increase payment efficiency

Executed monthly financial modeling, budget improvement, processed expense reports and implemented time series modeling in Tableau

Understanding of Business Model development using different functionalities like Dimensional Hierarchies, Level Based Measures, Aggregation Rules, Time Series Function using Expression Builder

Extracted data from various sources and performed data blending.

Created different type of charts, worksheets and dashboards by using custom queries and multiple tables.

Created various interactive customized dashboards and stories.

Applied various types filters like Data source filters, Quick filters and Context Filters.

Created table calculations, calculated fields and parameters.

Publishing sheets and dashboards on server.

Developed complex reports and visualizations using Tableau Desktop as per requirements.

Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.

Executed and tested required queries and reports before publishing.

Validate the data for each report and review the reports.

Generated high detail oriented views using multiple measures, Individual Axes, Dual Axes .

Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters and date functions. Also updating the weekly status and tracking the query sheet.

Created Stories using Tableau as part of report presentations to Business.

Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.

Applied security features of Tableau like row level, report level security in the reports so as to make the sensitive data secure.

Environment : Informatica PowerCenter 9.5.1, Tableau Desktop, Tableau Server, MS Excel, Oracle, TOAD, Facets, Flat files, Windows

TABLEAU DEVELOPER

Pfizer- PGS- GLASS Data Warehouse – Chennai India- September 2013 to July 2014

RESPONSIBILITIES:

Analysis of the specifications provided by the Client, Understanding the Business.

Experienced in Designing & Formatting Dashboards using Tableau.

Build the advanced chart types and visualizations like Bar in bar charts, Bullet graphs, Box and whisker plots, Pareto charts.

Build the complex calculations to manipulate of data.

Using and implementing the statistical techniques to analyze data.

Using the advances analytics, interactive dashboard design.

Using the date month, logic statements and Using several Calculation Types like Type Conversions and Date Calculations, Quick Table Calculations.

Using advanced date calculations, aggregate calculations, user-calculations, table-calculations, logical-calculations, string-calculations, type-conversion, number calculations.

Worked on SQL queries to validate the reports.

Using advanced Statistics and Forecasting like Trend Lines, Forecasting and R Language scripting in the reports.

Using Calculations in Tableau like Creating and Editing Calculated Fields.

Using the Calculations and Aggregations & Aggregating Dimensions in Calculations.

Using the Record Level Calculations for Date Conversion.

Using Level of Detail measures for calculations to analyze the data in different levels.

Implemented the prompts in the filters and calculations.

Created the Paging to represent the multiple view in single page using the controls.

Advanced Table Calculations like Table Calculation Scope and Direction, Table Calculations for Statistical Analysis.

Handled Team of 5 members by assigning tasks, providing Knowledge transition on Report requirement, Development of universe and reports, tracking the weekly dead line, Error handling, Implementation, on-time delivery, documenting the error handling and producing the user manual documents to end user.

Involved the complete project implementation from gathering data from SAP system to ETL process and from ETL process to report development

Involved in GAP analysis for ETL and report development.

Worked with complex mapping using transformations such as Expression, Router, Lookup, Filter, Joiner, SQ, Stored Procedures and Aggregator.

Migrated the code into different environment and documented the migration activities.

Environment : Informatica PowerCenter 9.1, Tableau Desktop, Tableau server,SAP system, Oracle 9i, Flat Files

TABLEAU DEVELOPER

PFIZER-LSVS Enhancements and Support –Chennai India - January 2013 to August 2013

RESPONSIBILITIES:

Interacted with Business Analysts and Data Modelers and defined Mapping and Design process for various sources and Targets.

Created analytical reports and dashboards using filters, parameters, sets, bins and implemented visualizations with complex calculations to manipulate the data.

Create, customize & share interactive web dashboards in minutes with simple drag & drop.

Created incremental refreshes for data sources on Tableau server.

Coordinated database middleware issues with DBA's, system performance with System Architects.

Generated high detail oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geo-coding.

Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the application.

Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.

Effective story board development conveying the story in transparent manner to the users.

Distributed Tableau reports using Packaged Workbooks, PDF to authorized user community.

Responsible for performance optimization by writing SQL overrides.

Improved performance of tableau dashboards and maintained high level of data integrity.

Involved the complete project implementation from gathering data from SAP system to ETL process and from ETL process to report development

Involved in GAP analysis for ETL and report development.

Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Tableau Reports.

Handled Team of 5 members by assigning tasks, providing Knowledge transition on Report requirement, Development of reports, tracking the weekly dead line, Error handling, Implementation, on-time delivery, documenting the error handling and producing the user manual documents to end user.

Implemented Slowly Changing Dimensions (SCD, Both Type 1 & 2).

Worked with complex mapping using transformations such as Expression, Router, Lookup, Filter, Joiner, SQ, Stored Procedures and Aggregator.

Developing Informatica mapping and tasks in informatica cloud for Sales force.

Environment : Informatica PowerCenter, Tableau 8.0, Tableau Server, MS Excel, Oracle, TOAD

TABLEAU DEVELOPER

PFIZER- PGS-SFMIS Reporting – Portage MI / India - June 2012 to December 2012

RESPONSIBILITIES:

Involved in gathering the requirements and analyzing the requirements and interact with the customer to find the proper information.

Extracted data from various sources and performed data blending.

Created different type of charts, worksheets and dashboards by using custom queries and multiple tables.

Created various interactive customized dashboards and stories.

Applied various types filters like Data source filters, Quick filters and Context Filters.

Created table calculations, calculated fields and parameters.

Publishing sheets and dashboards on server.

Executed and tested required queries and reports before publishing.

Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters and date functions.

Created Stories using Tableau as part of report presentations to Business.

Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.

Environment : Tableau Desktop, Tableau Server, MS Excel, Oracle, TOAD, Windows

BUSINESS OBJECT DEVELOPER

Brocade-Brocade Data warehouse Support –India - April 2010 to May 2012

RESPONSIBILITIES:

Direct Interaction with the client to resolve the DW related issues.

Involved in validation of Report Specifications and ETL Changes.

Report migration and developed reports in OBIEE.

Involved in Informatica cloud task for SFDC.

Created Data synchronization task, Data replication task, task flows in Informatica cloud.

Responsible for Development and Modification of reports.

Worked with senior management for dashboard creation and report bursting.

Worked on Unix scripts to automate the jobs and communicate the different server tasks.

Handled P1 issue tickets and bug fixing tasks on BO reports and Informatica mappings.

Created and extensively worked on enhancement of Informatica mappings, sessions and workflows.

Development of Test Cases, RFE document and migration checklist.

Tracking the status of Operations, Footprints, Marketing, SFDC,BMI and BIG-O modules and update the status to onsite.

Designed and maintained complex Universes, resolved loops by creating aliases and contexts.

Used Aggregate awareness function of Business Objects to route the query objects through the appropriate path while selecting from multiple contexts..

Involved in building and retrieving data using Universes, Personal data files, and creating complex ad-hoc Reports using the Business Objects suite applications.

Extensively worked on universe development inclusive of fan trap, chasm trap, @ functions, aggregate awareness, hierarchies, row and column level security, prompts.

Extensively used various features like Joins, Alias and Contexts in Universe designer to overcome various traps (Chasm, Fan) and Loops.

Migrated reports from BOXIR2 to BOXIR4.1

Created complex variables, breaks, sorts, filter and conditions for various reports.

Used prompts in the reporter as well as in the universe to create more interactive reports for running different kind of campaigns.

Development of Test Cases, Field mapping document, RSV and Combo documents

Extensive testing and migrating the reports or objects from development to Production system.

Developed testing scripts and test cases. Extensively tested Business Objects reports, dashboards and other Business Objects Applications in new environment.

Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.

Environment : Informatica PowerCenter/PowerExchange/cloud 8.1, Business Objects XI R2,SQL Server, Flat Files

BUSINESS OBJECT DEVELOPER

Charles Schwab - Finance Corporation Administrative Technology –India - Feb 2008 to Feb 2010

RESPONSIBILITIES:

Created reports in WEBI for BAR reporting and Finweb applications.

Semantic layer (Universe) design from different databases

Scheduling reports based on ETL task for monthly load in different databases.

Admin(CMC) - For creating users, Folder and checking connections, scheduling reports.

Handling Change request and worked on report enhancement.

Involved in Production Support activities for different application

Extensively worked on Loop resolving, aggregate awareness, custom hierarchy, report navigation tasks for drill down reports.

Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.

Worked in migration of universe and reports between environments.

Designed universes, solved loops by creating aliases, contexts and resolved traps.

Created complex variables, breaks, sorts, filter and conditions for various reports.

Created complex reports involving master/detail and cross-tab and Combined queries and sub-queries

Linked multiple data-providers and Used calculation contexts/extended contexts

Coordinated with DBA and Business objects designer group in solving various technical issues.

Accessed reports through webpage which was created on .net and Editing the .net code.

Implemented VBA macros in MS Excel to change the format of data after exporting the reports from BO reports to Excel as per the business requirement.

Developed testing scripts and test cases. Extensively tested Business Objects reports and other Business Objects Applications in new environment.

Developed Cubes and worked in Voyager reports for POC. Created Simple crosstab reports from Cubes to replicate the existing IBM Essbase reports.

Involved in value add activity by reducing the 76 Finweb reports into 12 by changing the prompts.

Created the Web Intelligence Report and used Events for Daily/Weekly /Monthly Scheduling of the reports.

Created reports in BO Crystal reports to display more than 1000 characters in a fixed format string in a single row of report.

Environment : Informatica PowerCenter 8.1, Business Objects XI R3.1, Teradata, Oracle 9.1,SQL Server, .net for web page design, VB macro for format change in MS Excel.

Contact this candidate