HARI PINTO

Sr. BI /Tableau/Data Analyst/Big Data Consultant

410-***-****/ adc7a3@r.postjobfree.com

Professional Summary

•Over all 23 years in IT with 6 years of experience in Tableau, experience in tableau visualization, with Join & data blending, wrote custom SQL to create rich datasets that enable better visualizations & decision-making by the business.

•Over 10 years of experience in Business Objects Enterprise Suite, LCM, Version management, import wizard and Info view, with SQL-Server, Sybase IQ, Netezza, Teradata and Oracle databases.

•Good knowledge of Hadoop ecosystem, HDFS, Big Data, RDBMS,

•Experienced on working with Big Data and Hadoop File System (HDFS), Pyspark, Spark-Scala.

•Hands on Experience in working with ecosystems like Hive, Pig, Sqoop.

•Create/manage Projects, Database Views, Data Sources and Data Connections using Netezza, SQL server.

•Consulted on Tableau server performance enhancements; and server reconfiguration based on workbook complexity and data extraction

•Worked on the development of Dashboard reports for the Key Performance Indicators for the top management

•End-to-end experience in designing and deploying data visualizations using Tableau.

•Expertise in designing Universes, WebI Reports, DeskI reports, and Full Client Reports.

•Experience in installation and configuration of Business Objects and Web Intelligence, creation of repositories with user groups and security implementation.

•Expertise in Business Objects XI R2/3 CMS, Universe design, Scheduling, import wizard, Publish wizard, Lifecycles manager, Desktop Intelligence, and Web Intelligence.

•Extensively worked on Business Objects 3.1, Business Objects XI R2, Crystal reports XI R2, Xcelsius 2010, Tableau.

•Involved in full life cycle BW implementations along with other Post-Implementation and Post Maintenance projects in SD MM and FI/CO functional areas.

•Extensive experience in SAP BW/BI components like Info Cubes, Multi-Cubes, Info Source, Info Package, Data source, Info Objects, ODS (DSO), Update rules, Update routines, Transfer rules, Transformations, DTP.

•Expert in Performance tuning using Aggregates, Rollup, collapse, Partition, Repartition and Compression.

•Strong hands-on experience in BW/BI front-end and back-end development with a deep understanding of the SAP BW/BI tools and techniques.

Educational

Bachelors in Accountancy from Bombay University, India 1985.

Professional Experience

Client:

Apple (San Jose, CA) Jan-19 – Mar 20

Environment: Tableau 2019.3, Teradata, PostgreSQL, Hadoop, Hive, Spark, Scala, python

Role: Tableau Developer & Data Analyst

•Was personally involved in meetings with Business Team Managers and colleagues to define and scope list of reports, content desired in these reports, formatting and presentation standards for these reports, time Line of development and helped in assessment of Level of effort with other team members.

•Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

•Manage & develop innovative, scalable machine learning and data mining solutions that mine complex user behavioral data and transform it into actionable insights.

•Constructed and presented research ideas, prototypes and proofs of concepts, precise measurement skills in both Metric and standard scale, involved in identifying, ingesting, and enriching a wide range of structured and unstructured relational data into datasets for analysis.

•Created Hive databases, dimension & fact table, built queries in Hive on top Hive tables, import in tableau for data analyzing.

•Export and Import data into Hadoop HDFS & Hive using Sqoop.

•Involve in creating Hive tables, indexes, Partition the table load the data and writing Hive queries which will run internally

•Load data into Hive partitioned tables, created ORC tables, Text-file,

•Software development in a collaborative team environment using Scrum Agile methodologies, to build data pipelines using technologies like Hive.

•Strong Knowledge of Hadoop and Hive and Hive's analytical functions.

•Capturing data from existing databases that provide SQL interfaces using Sqoop.

•Excellent Data Analysis skills. Comfortable with querying and analyzing large amount of data on Hadoop HDFS using Hive, Sqoop and Spark

•Experienced Hadoop Developer has a strong background with file distribution systems in a big-data arena. Understands the complex processing needs of big data and has experience developing codes and modules to address those needs. Developed using Cloudera Hadoop streaming and Hive solid understanding of Hadoop file distributing system.

•Designed and developed HR Big Data Analytics platform that supports next gen analytics of structured and unstructured data.

•Use pySpark Scala to Reduce the Data Preparation, Data Management effort and helped derive insights that increased HR overall digital foot print.

•Worked on machine learning on large size data using Spark

•Developed Spark/Scala, Python for regular expression (regex) project in the Hadoop/Hive environment with Linux for big data resources.

•Data sources are extracted, transformed and loaded to generate CSV data files with Python programming and SQL queries.

•Extensively used SQL, RDD, Data-Frame, Dataset, Spark, Hive, Spark-SQL for Data Analysis and Model building.

•Developed jobs to Sqoop data from MySQL to HDFS implemented recursive execution\looping and conditional execution of actions in spark Scala Hive Development jobs to load partitioned tables (static and dynamic), External and internal tables developed data aggregates, roll-ups and support dashboard, reporting and Adhocs analytics using Hive.

•Query data and Blend information from diverse data sources to create rich datasets that enable better visualizations & decision-making by the business, organized dashboards in Tableau to analyze the revenue, expense over various attributes of customers, project, time and location dimension.

•Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data.

•Connected Tableau server to publish dashboard to a central location for portal integration.

•Develop Order to revenue forecasting model and process for total Digital and initiate process and systemic improvements to enable segments predict Revenue conversion.

•Initiate daily lean practices in Orders to Revenue tracking and create institutional best practices to avoid delay in revenue conversion.

•Develop cash model to review actual cashflow and predict cashflow in direct and indirect spend by reviewing R&D metrics, Product costing, and Services/Support costing.

•Develop and sustain cash forecasting model to deliver predictable and reliable cash forecast that will match with actual outcome.

•Define and improve processes around developing and improving cash and working capital metrics to deliver metrics driven cash forecasting and cash management.

•Create Teradata system table dashboard with disk size, table size, table skew growth over a period, Create Module count of iPhone and MAC computer dashboard, compare with each module with warehouse database table count, and sorting max difference at left of the chart, Created sales & financial dashboard, having sales over a period with Activation, FSI & FCS period, Create workbook with different product launch in different period and calculate the FSI count over a period, integrated each chart workbook with other workbook, between the TAB and link across other dashboards, import & integrate dashboard created by others.

•Design and development of Tableau software applications to support reporting and Business Intelligence initiatives, using data analytics, visualization, data mining, SQL; Perform Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump & generate weekly log files.

•Worked extensively with Calculated field, hierarchies, parameter, Bins, groups, and Set.

•Build & Created Cascading Filter for complex dashboard & Graph Charts.

•Worked extensively with advance analysis Actions, Calculation, parameters and table calculations.

•Ability to simplify, translate and explain complex processes, wrote SQL statement.

•Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

•Perform quality assurance and testing of SQL server environment.

Client:

Consumer Energy (Jackson, MI) Oct-18 –Dec-19

USAA (San Antonio, TX) Jan-18 - Jul 18,

Role: Tableau Developer.

Environment: Tableau 9.1/10.4/10.5/2018.2/2019.2, BO 4.2, WebI, IDT, SQL server, Big Query, Hadoop Hive, Netezza, Oracle, SAP HANA, Agile environment.

Description: USAA means United Services Automobile Association and its insurance, banking, investment and other companies. Banks Member FDIC. Investments provided by USAA Investment Management Company and USAA Financial Advisors Inc., both registered broker dealers. I was part of ESF & EST manage day to day activity of marketing area, where customer used to contact USAA by different means like Telephone, mobile & internet for automobile insurance until sales funnel record was created thru session, quote, app & product.

•Was personally involved in meetings with Business Team Managers and colleagues to define and scope list of reports, content desired in these reports, formatting and presentation standards for these reports, time Line of development and helped in assessment of Level of effort with other team members.

•Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

•Manage & develop innovative, scalable machine learning and data mining solutions that mine complex user behavioral data and transform it into actionable insights.

•Constructed and presented research ideas, prototypes and proofs of concepts, precise measurement skills in both Metric and standard scale, involved in identifying, ingesting, and enriching a wide range of structured and unstructured relational data into datasets for analysis.

•Query data and Blend information from diverse data sources to create rich datasets that enable better visualizations & decision-making by the business, organized dashboards in Tableau to analyze the revenue, expense over various attributes of customers, project, time and location dimension.

•Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data.

•Connected Tableau server to publish dashboard to a central location for portal integration.

•Track profit, loss with an intuitive ESF dashboard, the top two views provide an overall picture of quarterly and yearly performance over the past three years. The views include key financial measures such as net sales, net profit, and net profit margin.

•Build Financial dashboard YoY, YTD, FYF for Cash flow, Income statement & Balance Sheet, showed profitability and growth YoY.

•Sales funnel Enterprise (SFE) performance dashboard will provide different KPI like Session, Quote start, Quote Complete, App Start, App Complete & Product would provide MTD & YTD Line & Graph Chart and compare the data with plan data to indicate performance.

•Create Dashboard of Audit database for SAP BO, SAP Hana, Mem-SQL.

•Created Rich HR management dashboard using HR information like Headcount Tracking & Forecast, Recruiting Metrics, Compensation & Benefits.

•Build line charts to track Headcount with current year with prior year, with business unit and department.

•With Recruiting metrics created bar chart month wise details and budget required to trained the new recruit candidates.

•Create views and dashboards on end client's sales data giving Sales Performance vs Target values of their product and customer with forecast values in charts and measure values, show Sales dashboard KPI like Number of New Customers and Leads, Churn Rate (i.e. how many people stop using the product or service), Revenue Growth Rate, Comparison to Previous Periods, Most Recent Transactions, QTD (quarter to date) Sales, Profit Rate, State Wise Performance, Average Revenue for Each Customer

•Developed Tableau data visualization using cross tabs, Box and Whisker Charts, Scatter Plots. Pie Charts and Bar Charts.

•Developed donut charts and implemented complex features in charts which will show the measure breakups.

•Involved & managed creating dual-axis bar & line charts with multiple measure.

•Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

•Created Hive databases, dimension & fact table, built queries in Hive on top Hive tables, import in tableau for data analyzing.

•Export and Import data into Hadoop HDFS & Hive using Sqoop.

•Involve in creating Hive tables, indexes, Partition the table load the data and writing Hive queries which will run internally

•Load data into Hive partitioned tables, created ORC tables, Text-file,

•Software development in a collaborative team environment using Scrum Agile methodologies, to build data pipelines using technologies like Hive.

•Strong Knowledge of Hadoop and Hive and Hive's analytical functions.

•Capturing data from existing databases that provide SQL interfaces using Sqoop.

•Excellent Data Analysis skills. Comfortable with querying and analyzing large amount of data on Hadoop HDFS using Hive, Sqoop and Spark

•Experienced Hadoop Developer has a strong background with file distribution systems in a big-data arena. Understands the complex processing needs of big data and has experience developing codes and modules to address those needs. Developed using Cloudera Hadoop streaming and Hive solid understanding of Hadoop file distributing system.

•Designed and developed HR Big Data Analytics platform that supports next gen analytics of structured and unstructured data.

•Use Spark Scala to Reduce the Data Preparation, Data Management effort and helped derive insights that increased HR overall digital foot print.

•Developed jobs to Sqoop data from MySQL to HDFS implemented recursive execution\looping and conditional execution of actions in spark Scala Hive Development jobs to load partitioned tables (static and dynamic), External and internal tables developed data aggregates, roll-ups and support dashboard, reporting and Adhocs analytics using Hive.

•Design and development of Tableau software applications to support reporting and Business Intelligence initiatives, using data analytics, visualization, data mining, SQL; Perform Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump & generate weekly log files.

•Worked extensively with Calculated field, hierarchies, parameter, Bins, groups, and Set.

•Build & Created Cascading Filter for complex dashboard & Graph Charts.

•Worked extensively with advance analysis Actions, Calculation, parameters and table calculations.

•Ability to simplify, translate and explain complex processes, wrote SQL statement.

•Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

•Perform quality assurance and testing of SQL server environment.

Client: PayPal Inc (Deloitte), (Lake Mary, FL), Aug-16 –Dec 2017

Role: Tableau Developer.

Environment: Tableau 10.4, BO 4.2, WebI, IDT, SQL server.

Description: PayPal Holdings, Inc. is an American company operating a worldwide online payments system that supports online money transfers and serves as an electronic alternative to traditional paper methods like checks and money orders. A billing connected to a specific form of payment, which is typically a credit or debit card. Companies use the billing information to verify the authorized use of such a card. It is also where companies send paper bills and bank statements

•Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.

•Worked with several users and interacted with them to gather requirements.

•Organized dashboards in Tableau to analyze the revenue, expense over various attributes of customers, project, time and location dimension.

•Built Tableau dashboards with floating objects and capitalizing the various dashboard actions features like URL, images, web integrations.

•Implemented hierarchies in Tableau with Region as the highest level followed by Country and City with other details.

•Build Financial dashboard YoY, YTD, FYF for Cash flow, Income statement & Balance Sheet.

•Created Rich HR management dashboard using HR information like Headcount Tracking & Forecast, Recruiting Metrics, Compensation & Benefits.

•Build line charts to track Headcount with current year with prior year, with business unit and department.

•With Recruiting metrics created bar chart month wise details and budget required to trained the new recruit candidates.

•Developed WebI reports, extensively used Calculation contexts, Variables, Drill down, Slice and Dice, Breaks, Sections, Ranks, Alerts, input controls.

•Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, and Ranking.

•Extensively used slice and dice features, filtering and ranking to create cross tab and master/detail reports.

•Involved in formatting sections, tables, inserting and organizing multiple breaks.

•Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors.

•Build Cascading Prompt, Cascading List of Values in BO – Universe Designer

•Build Row Level Security in Business Objects by Creating a Data Security Profile and Row Level Security In Business Objects Using a Security Table.

•Build and design new and change existing Universes, Classes and objects, resolved loops and Traps using Contexts and Aliases while designing Universes, setup Universe level conditions to restrict data based on report requirements. Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports.

•Build & Created Cascading Filter for complex dashboard & Graph Charts.

•Used CMC for User creation and given folder permission to the user.

•Created user right & permission using security editor based on the profile for report access.

•Worked on Publication and scheduling in sap BO.

•Experience using CMC in an administrative capacity, including creating User & Roles, troubleshooting security issues, and folders rights.

•Monitoring all the related CMS, Audit and Reporting Database services

•Verifying Web applications (CMC, Info-view, Custom Applications) availability

•Monitoring day to day scheduled report jobs from Instance Manager

•Provide technical support for existing reports, dashboards, or other tools.

•Plan, design, and implement application database code objects, such as stored procedures and views.

•Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

•Perform quality assurance and testing of SQL server environment.

•Develop new processes to facilitate import and normalization, including data file for counterparties.

•Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

•Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.

•Work with users requesting data pulls or reports, to clarify data availability, data access issues, user requirements, and set priorities.

•Write requirements documents for the customer requesting data formal approval.

•Write specifications for the team programmers and/or report developers. Perform quality assurance on data and reports to ensure they meet the specified user requirements.

• Write technical and user documentation for data marts and applications.

•Analyze data from multiple data sources to establish true definitions of the data and what types of additional data are needed, in what format, to what level of specificity.

Client: JPM Chase. (New York, NY), Oct-15 – July-16

Role: BO Analyst Developer.

Environment: BO 4.1, WebI, IDT, Sybase IQ.

Description: JPM Chase. (New York, NY) JPMorgan Chase & Co. is a leading global financial services firm and one of the largest banking institutions in the United States, with operations worldwide. Working in Risk Management system as a Webi Analyst Developer, with SOX Control and Variance Analysis with layer of information.

•Lead & manage project technical team BI Analytics deliverables to ensure business objectives are met, Work with business managers to identify where business intelligence can be applied in supporting global business objectives.

•Proficient in converting User requirement into Functional specs and technical specs.

•Prepare appropriate documentation and ensure that new functionality is properly transitioned to reporting users.

•Done Implement Business Intelligence (BI), data warehouse (build model) with a focus on usability and ease of use for standard reports, dashboards, drill down reports, scorecards.

•Involved and design with the team and outside the team, in Business Process Analysis, Develop & Implement Data mart.

•Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.

•Implemented Data warehousing schemas like Star-Schema, Snow-Flake Schema.

•Involved in the designing and Building of Universes, Classes and objects, Resolved loops and Traps using Contexts and Aliases while designing Universes, Set up Universe level conditions to restrict data based on report requirements. Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports.

•Extraction data from different source systems and building universe design in BO and delivering dashboards & Webi reports. Created Derived tables in the Designer to enhance the capabilities and performance of the universe, Customized Universe level Prompts as per Functional Requirements.

•Check the integrity of the Universes, and export the universes to Repository for making available to users

•Created reports using Business Objects functionality's like Drill Down, Cross Tab, and Formula's. Created Standard Reports utilizing all the features on Web Intelligence in BOE XI 4.1 like Optional Prompts, Functions, and Alerts.

•Created Breaks, input control, Filters at Different Levels of the reports and applied ranking in the Webi reports. Extensively worked with formatting the reports according to the user requirements.

•Resolved data issue and bugs in the data design, and also fixed report as per customer requirement. Coordination and work along with the ETL team to ensure the timely execution of feeds to the reporting tables as well as testing the quality of data and providing inputs to them.

•Developed Dashboards using Xcelsius 2010 according to user specifications. Wrote complex views, functions and stored procedures using SQL, PL/SQL, to be used in Reports development. Extensively worked on Data Stage (ETL) to populate data in to the Data warehouse.

•Created transport in sap BO using promotion Manager, and maintain reports, IDT, Universe, and Connection in Version Management.

•Used CMC for User creation and given folder permission to the user.

•Created user right & permission using security editor based on the profile for report access.

•Worked on Publication and scheduling in sap BO.

•Experience using CMC in an administrative capacity, including creating publications, troubleshooting security issues, and folders.

•Followed sap best practices in report development and maintenance of universes. .

Client: Johns Hopkins Medical Inst. (Baltimore, MD) Jun-13 – Sept-15

Role: SAP Tableau/ BO/BW Analyst Developer.

Environment: Tableau 9.1, BO 4.1, Webi, IDT, sap BW 7.3, SAP Hana, XCelcius 2010, ECC 6.0, SAP SRM, SAP SCM.

Description: Johns Hopkins Hospital (Baltimore, MD) ranked 1st in the country. In innovations of cancer treatment, neurosurgery, transplants, patient safety and give hope to patients around the world, hospital has a very high rate of patient satisfaction for acute care. With Analyst developer role in initial development phase, I have create Model and store procedure bring down the data from difference source and platform, have built universe on top of those model basis on report requirement.

•Lead & manage project technical team BI Analytics deliverables to ensure business objectives are met, Work with business managers to identify where business intelligence can be applied in supporting global business objectives.

•Proficient in converting User requirement into Functional specs and technical specs.

•Prepare appropriate documentation and ensure that new functionality is properly transitioned to reporting users.

•Worked on Extractor from SAP (FI, CO,HR, SRM), Enhanced extractor, CMOD & Functional Module to bring additional information using ABAP.

•Expertise in BI-content, Designed and developed various Data targets and Infoprovider like DSO (ODS), Infocube, Infoobject, Multiprovider and Infoset, build transformations to cleanse the data and enhance the infoprovider getting the information master-data and ODS with the help of ABAP4 to suit the business requirements.

•Created ODS, Infocube, Multi-providers and infoset and extract PO/SRM data using (Data sources Like 0BBP_SC, 0BBP_SCA, 0SRPO_D1, 0SRCF_D2, 0SRIV_D3, 0SRCA_D4, 0SRCT_DS1) into SAP BW. Customize SRM Extractor to get additional information.

•Create Bex query report on top of this SRM Cubes, bring Bex query to sap BO Webi and dashboard.

•Expertise in ABAP (Start, End, Expert, Transformation Routines & Customer Exits).

•Work extensively in Bex report create Bex Query on top of InfoCube, ODS, Mutiprovider and infoset.

•Involved in creating HANA modeling, and bring data from non-sap, loading data into table definitions. Creating objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based).

•Created Universe sitting on top sap Hana and SAP BW on Hana and created Web Intelligence, Dashboards, Analysis for OLAP.

•worked on Semantic-Partitioned-object (SPO), Data-Flow, manage to create model with different source, and have SPO based on Period and region and data-Source and manage to bring data from different country and region.

•Involved in Performance Issues like Creation of aggregates, Rollup and Compressed the InfoCube to improve the query response.

•Optimized web intelligence report performance on OLAP databases with Query Stripping enabled at query properties or document properties level.

•Configured/fine tuned the performance parameters of all BO processes.

•Performance tuning of Webi reports on OLAP Universes using optimization techniques like query stripping.

•Done Implement Business Intelligence (BI), data warehouse (build model) with a focus on usability and ease of use for standard reports, dashboards, drill down reports, scorecards.

•Involved and design with the team and outside the team, in Business Process Analysis, Develop & Implement Data mart.

•Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.

•Implemented Data warehousing schemas like Star-Schema, Snow-Flake Schema.

•Involved in the designing and Building of Universes, Classes and objects, Resolved loops and Traps using Contexts and Aliases while designing Universes, Set up Universe level conditions to restrict data based on report requirements. Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports.

•Extraction data from different source systems and building universe design in BO and delivering dashboards & Webi reports. Created Derived tables in the Designer to enhance the capabilities and performance of the universe, Customized Universe level Prompts as per Functional Requirements.

•Check the integrity of the Universes, and export the universes to Repository for making available to users

•Created reports using Business Objects functionality's like Drill Down, Cross Tab, and Formula's. Created Standard Reports utilizing all the features on Web Intelligence in BOE XI 4.1 like Optional Prompts, Functions, and Alerts.

•Created Breaks, input control, Filters at Different Levels of the reports and applied ranking in the Webi reports. Extensively worked with formatting the reports according to the user requirements.

•Resolved data issue and bugs in the data design, and also fixed report as per customer requirement. Coordination and work along with the ETL team to ensure the timely execution of feeds to the reporting tables as well as testing the quality of data and providing inputs to them.

•Developed Dashboards using XCelcius 2010 according to user specifications. Wrote complex views, functions and stored procedures using SQL, PL/SQL, to be used in Reports development. Extensively worked on Data Stage (ETL) to populate data in to the Data warehouse.

•Created transport in sap BO using promotion Manager, and maintain reports, IDT, Universe, and Connection in Version Management.

•Used CMC for User creation and given folder permission to the user.

•Created user right & permission using security editor based on the profile for report access.

•Worked on Publication and scheduling in sap BO.

•Experience using CMC in an administrative

Contact this candidate