Robert Navarro

  • March 22, 2021

Robert Navarro

Cell :(405) 778-3508

email :robertmavarro12@gmail.com

PROFESSIONAL SUMMARY:

  • 6+ years of strong experience in all phases of the life cycle of Requirement gathering, Analysis, Design, Development, Testing, debugging of various Data Warehousing Applications using BI Analytics tool Tableau in conjuction with Informatica.
  • 5 years of experience in designing and development of visualization reports using Tableau using various relational database including ORACLE, SQL Server etc.
  • Experience in working with customers to determine their needs, gather, analyze and document requirements, communicate with customers throughout the development cycle, manage customer expectations, resolve issues and provide project status
  • Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets and Data marts and Data warehouse.
  • Extensive Experience in integration of various data sources like ORACLE 11g/10g,SQL server 2012/2014 and PostgreSQL 9.3
  • Superior SQL skills and ability to write and interpret complex SQL statements and also mentor developers on SQL optimization and performance tuning
  • Excellent experience in Data Analysis, Data Cleansing, Data Verification using complex SQL query
  • Hands on experience in utilizing tableau functions which includes Aggregation, Counting, Logical, information, Text and date functions.
  • Published tableau Reports in the required originations and Made Dashboards available in Web clients.
  • Strong experience in creating advanced chart types, visualizations and complex calculations to manipulate the data as per business need through Tableau
  • Hands-on designing and deploying rich Graphic visualizations with Drill Down and Dropdown menu option and Parameterized dashboards using Tableau.
  • Expert in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Treemaps, etc. using Tableau.
  • Generated context filters and data source filters while handling a large volume of data using Tableau.
  • Involved in creating Filters, quick filters, table calculations, calculated measures.
  • Coordinate with ETL on Informatica to extract, transform and load data into the target database.
  • Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
  • Exposure of end to end SDLC and Agile methodology
  • Have good problem solving, time management skills, communication skills, self-motivated, ability to work independently or cooperatively in a team and eager to learn.

 

EDUCATION:

  • Degree-Bachelor of Science in Electronics & Communications Engineering (5-year degree)
  • Don Bosco Technical College (Passed-Licensure Exam-Electronics & Communications Engineering)

 

 TECHNICAL SKILLS:

 

BI Tools Tableau Desktop 2020.3/ 2019.1/10.2/9.x Tableau Server Data Modeling ERwin 9.5.2. Databases Teradata 15, Oracle/11g/10g, SQL Server 2014/2016,PostgreSQL 9.3 Others MS Word, MS Access,informatica, TOAD, SQL Developer, Microsoft Office, Teradata SQL AInformaticatant, Rally, JIRA

 

PROFESSIONAL EXPERIENCE:

                                                     

Client: Verizon Communications, Inc., Irving, TX                                 Duration: Sept 2019 to Till Date

Project: Campaign Data Mart

Role:  BI Report Developer

Verizon Communications, Inc. is a holding company, which engages in the provision wireless communications products and services. It operates through Wireless, and Wireline segments. The Wireless segment provides wireless voice and data services and equipment sales, which are provided to consumer, business, and government customers. The Wireline segment offers broadband video and data; corporate networking solutions; data center and cloud services; security and managed network services; and local and long-distance voice services.

Responsibilities:

  • Coordinated with business users at various levels and call meetings during the different phases of projects to deliver successfully.
  • understand the architecture, data Model, business logic and rules to be applied to meet the business needs.
  • Discussed with the team to capture high level transformation rules, produce features, define metrics and User Interface Design Document acceptance.
  • Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
  • Participated in building and visualizing dashboards using Tableau Desktop
  • Used Tableau to generate Tableau combination dashboards and wrote SQL Queries for testing the tableau report/dashboard.
  • Implemented Extract filters, Calculation Filters, Context filters, Data source filters to exclude certain values or a range of values as well as batter performance.
  • Created story using sequence of worksheets to convey information using Tableau.
  • Tableau dashboards used different bars and charts like stack bars, bar graphs, scattered plots, Gantt charts etc.
  • Blended data from multiple sources like SQL Server 2014, PostgreSQL, Oracle 10g, and Teradata into one report by selecting primary keys from each database for data validation.
  • Have done advance analysis, through field calculation, table calculation as well as also involved in forecast analysis.
  • Used different functions like number, string, date, Type conversions, and aggregate functions.
  • Created performance recording to improve Tableau’s performance.
  • Effectively used data blending feature in tableau desktop
  • Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
  • Written complex SQL queries to read data from source databases like Teradata and SQL Server
  • Modified existing UNIX shell script to automate the process.Conducted user testing and prepared documents for future use.

Environment: Tableau Desktop 2020.3, MS excel, Power Point, Oracle 12c, SQL Server 2017,SQL, SQL developer, Teradata , Teradata SQL AInformatica tant, JIRA

                                         

Client: AT&T, Irving, TX                                                                       Duration: Jun 2018 to Sept 2019

Project: Sales Data Mart

Role:  BI Report Developer

AT&T Inc. provides wireless and wireline telecom, video, and broadband and Internet services; video entertainment services using satellite, IP-based, and streaming options etc. to residential and business customers.

Use powerful analytics to better serve and engage with customers, build loyalty, and drive revenue. Tableau report and dashboard helping banks effectively utilize customer relationship management (CRM) solutions to acquire new customers, retain existing ones, and maximize customer lifetime value. Customer are accessing powerful analytics to comb through large amounts of data and extract actionable insights about how to increase the profitability of their customers; also enables users to maintain a holistic view of individual customers’ profiles and activities.

Responsibilities:

  • Actively involved in the Analysis phase of the business requirement and reports/dashboards design.
  • Coordinated with business users at various levels and call meetings during the different phases of projects to deliver successfully.
  • Interacted with Business Analyst, Data Modeler and team Members within the organization to understand business processes, implement the logic.
  • Involved in ETL processes and develop source-to-target data mappings
  • Coordinated with ETL team on data transformations using Informatica  to develop jobs for extracting, cleaning, transforming and loading data into data warehouse and developed SSAS tabular model to use for Power BI..
  • Worked with Business users to analyze the data specifications and developed relationships between source data and worked with data modeler to build tables from different source data.
  • Developed custom SQL queries to minimize the data to improve the performance in Tableau.
  • Experience in designing and development of Tableau visualization solutions and Created Business Requirement documents and plans for creating dashboards.
  • Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
  • Defined best practices for Tableau report development and effectively used the data blending feature in tableau.
  • Worked with different types of visualizations like Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards, Z-order, Visual hierarchies and drill-down in the tableau reports.
  • Used Power Pivot to create powerful data models and created power views for dynamic reports.
  • Utilized advanced features of Tableau software like link data from different data sources together on one dashboard to filter data in multiple views.
  • Developed storytelling 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.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
  • Tested reports and uploaded tableau dashboards onto the server and provided production support for tableau users.
  • Done performance tuning for the developed dashboard/report.
  • Have refreshed/republish reports and data set manually.
  • Improved performance by identifying the bottlenecks in Source table, recommended for creating index.
  • Performed data validation, data profiling, data auditing and data cleansing activities to ensure high quality report deliveries·
  • In Power BI developed reports by different time intelligence like year to data (YTD), Month to date (MTD), same period last year.
  • Analyzing reporting requirements and develop various Dashboards, using trend lines and reference lines.
  • Performed Data profiling and analysis using complex SQL, data sitting into target tables.
  • Performed detailed data investigation and analysis of known data quality issues in related databases through SQL
  • Created effective Test Cases and performed Unit and Integration Testing to ensure the successful UAT.
  • Prepared user training documented for smooth transaction to support team.

Environment:Tableau 9.2, Informatica  ,SQL Server 2016, Power BI Service, Power BI Gateway, Power BI Report Server, SQL Server 2014, MySQL, AZURE SQL DB, Advance Excel, SQL, T-SQL, Informatica

 

Client: Health Care Service Corporation (BCBS/HCSC), Richardson, TX                       Apr 2016 to Jun 2018

Project: CMS Data Mart

Role: Informatica Developer

Description:Health Care Service Corporation (HCSC) is the largest customer-owned health insurer in the nation and the fourth largest overall. Operating through our Blue Cross and Blue Shield Plans in Illinois, Montana, New Mexico, Oklahoma and Texas.

The project (CMS Medicare) is aimed at developing an integrated data mart for Medicare and Medicaid members for long-term decision-making, strategic plans, support and solutions giving mainstream users the ability to access and analyze and help stakeholder to automate extract process for downline application.

 

The object of integrated data mart is to enable improved SALES AND MARKETING ANALYSISreport and dashboard to speed up delivery time for quotes and orders by monitoring actual lead times, enforcing business rules, adding triggers to facilitate accuracy, and pursuing up-sell/cross-sell opportunities.

Responsibilities:

  • Participated in the Design Team and user requirement gathering meetings.
  • Worked with the business users to understand the architecture, data Model, business logic and rules to be applied to meet the business needs.
  • Discussed with team to capture high level transformation rules, produce features, define metrics and User Interface Design Document acceptance.
  • Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
  • Participated in building and visualizing dashboards using Tableau Desktop 9.0
  • Co-ordinated with ETL Informatica team to create and manipulate source and target data mappings, ETL mapping transformations.
  • Used Tableau to generate Tableau combination dashboards and wrote SQL Queries for testing the tableau report/dashboard.
  • Implemented Extract filters, Calculation Filters, Context filters, Data source filters to exclude certain values or a range of values as well as batter performance.
  • Created story using sequence of worksheets to convey information using Tableau.
  • In Tableau dashboards used different bars and charts like stack bars, bar graphs, scattered plots, Gantt charts.
  • Blended data from multiple sources like SQL Server 2014, PostgreSQL, oracle 10g, Teradata into one report by selecting primary keys from each database for data validation.
  • Have done advance analysis, through field calculation, table calculation as well as also involved in forecast analysis.
  • Used different functions like number, string, date, Type conversions, aggregate functions.
  • Created performance recording to improve Tableau’s performance.
  • Effectively used data blending feature in tableau desktop 9.0.
  • Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
  • Worked closely with the business analyst’s and Production Support to resolve any JIRA issue related to production reports.

EnvironmentTableau 9.1(Tableau Desktop, Tableau Server, Tableau online), MS Office Suite,Informatica PowerCenter 9.0.1, SQL, Oracle11g,PostgreSQL 9.3, TOAD,Control M, Shell Scripting

 

Client: General Motors, Fort Worth, TX                                                             Sept 2014 to Apr 2016

Role: Informatica PowerCenter Developer

Project: Vendor Payment Inbound File Processing

Description: General Motors Financial Company, Inc. is the financial services arm of General Motors. The company is a global provider of auto finance, with operations in the United States, Canada, Europe and Latin America.The company provides retail loan and lease programs through auto dealers for customers across the credit spectrum.

Responsibilities:

  • Worked with Business users to analyze the data specifications and developed relationship between source data and worked with data modeler to build tables from different source data.
  • Developed custom SQL queries to minimize the data to improve the performance in Tableau.
  • Experience in designing and development of Tableau visualization solutions and Created Business Requirement documents and plans for creating dashboards.
  • Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
  • Defined best practices for Tableau report development and effectively used data blending feature in tableau.
  • Worked with different types visualizations like Combination charts, Map visualizations, Matrixes and tables, Scatter charts Waterfall and funnel charts, Gauges and single-number cards, Z-order, Visual hierarchies and drill-down in the tableau reports.
  • Used Power Pivot to create powerful data model and created power view for dynamic reports.
  • Utilized advanced features of Tableau software like link data from different data sources together on one dashboard to filter data in multiple views.
  • 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.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
  • Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.

Environment:Tableau Desktop 8.2, Tableau Server, MS Office Suite, Oracle 10g, T-SQL, Unix, TSQL,

Informatica PowerCenter 9.1, ORACLE 11g, UNIX Shell Programming

 

Past experience :  worked as an RF Engineer with all aspects of wireless experience including RF Engineering, Atoll /  Planet EV / Asset , Geoplan, Actix, Windcatcher, Autoform, Visio tool support, RF research and analysis, network engineering, involved in site acquisition and system optim

E-mail
robertmavarro12@gmail.com
Phone Number
4057783508
Country
United States of America
Degree
Education level
Category
Finance

Contact Candidate

Contact