We provide IT Staff Augmentation Services!

Bi Developer/data Analyst Resume

0/5 (Submit Your Rating)

Jacksonville, FL

SUMMARY

  • 7+ Years’ experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms and Worked on various domains including Insurance, Finance, Banking, Healthcare and Retail.
  • Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher - level data analysis and data management services.
  • Involved in Full Life Cycle Development of Reporting Projects, includes Requirements gathering/analysis, Design, Development, Testing and Production rollover.
  • In-depth hands on experience on Tableau Desktop and Tableau Server.
  • Created Dashboard's using multiple BI Tools with Drill-Down capabilities using Dashboard prompts, Local and Global Filters.
  • Extensive TableauExperience in Enterprise Environment and TableauAdministrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
  • Created different visualizations to convey the story inside the data Involved in Requirements gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects
  • 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 KPI’s
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Pie charts using show me functionality.
  • IntroducedTableau to Client's to produce different views of data visualizations and presenting dashboards on web and desktop platforms to End-user and help them make effective business decisions.
  • Extensive experience in preparation of reports, tables, listings and graphs
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
  • Used SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.
  • Proven ability to work efficiently in both independent and team work environments
  • Expertise in Data warehousing concepts like OLTP/OLAP System Study, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling and XSD.
  • Preparing test cases and test plans. Maintaining deliverables, contributing significantly in taking Tools training to the team.
  • Created incremental refreshes for data sources on Tableau server.
  • Experience in Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment.
  • Expert in using Tableau and Power BI Desktop to Analyze and obtain insights into large data sets, create visually compelling and actionable interactive reports and dashboards.
  • Extensive experience on Big data sources like Hadoop Hive, Amazon Redshift with Tableau as the front end and created several reports.
  • Experience in using various MS office tools for analyzing, arranging and presenting data.
  • Understanding value proposition of the project and translate the requirements and business specifications into application functionality.
  • Interacting with Team in fixing errors, executing test plans, providing Test Data and Test Cases and Test Procedures.

TECHNICAL SKILLS

Office Tools: MS Outlook, MS Excel, MS Word, MS Access, MS Power Point

Reporting Tools: Tableau 10.3/10.2/10.1/9. x/8.x, Tableau Admin 10.x/9.x/8.x, Power BI Desktop, IBM Congo’s 10.x/8.x

Operating Systems: Windows XP/NT/2000/98/95, UNIX, Linux, MAC OSX

Databases & Tools: Teradata, Oracle 11g/10g, MS Access DB 2013/16, Hadoop Hive, Amazon Redshift, MS SQL Server 2008, Alteryx

Programming Languages: PL/SQL, SQL, XML

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

BI Developer/Data Analyst

Responsibilities:

  • Interacted with business users for requirement analysis and to define business and functional specifications.
  • Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
  • Created Business requirement documents and plans for creating dashboards.
  • DevelopedTableau dashboards with combination charts for clear understanding.
  • Responsible for implementing effective Business dashboards & visualizations for senior management employing Tableau Software.
  • Created visually compelling and actionable interactive reports and dashboards. Utilized table calculations, parameters, filters, charts, mark cards, sets, nested sorting, trend lines etc.
  • Creating New Schedule's and checking the task's daily on the server
  • Maintaining server activities, user activity, and customized views on Server Analysis.
  • Involved in installing tabcmd to schedule the report's and setup email reports using command lines.
  • Identified information and analytical needs of business users with regard to data analytics, Business Intelligence.
  • Extracted data from DB2, Flat files, XML Files, Flat Files and populated into EDW(SQL Server) and consumed by Tableau Desktop
  • Prepared software requirement specifications, business rules interacting with business units and designed Star schema, logical and physical database design for Domains.
  • Creating users, groups, projects, Data connections, settings as a tableau administrator.
  • Creating New Schedule's and checking the task's daily on the Tableau server
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
  • Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
  • Published Reports, workbooks & data source to server and exporting the reports in different Formats.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Have used Custom SQL, Aggregate and Analytical functions to extract the required data for campaigns, reports and dashboard development.
  • Scheduled Meetings with Business users to understand current reconciliation process; Gathered requirements from end users and mcustomers experts to define the scope and requirements of Reports.

Environment: Tableau Desktop 10.3,10.x,9.x, Tableau Admin 10.x,9.x Power BI Desktop, Teradata, SQL Server, SQL, MS Office

Confidential, Atlanta, GA

BI/SQL Developer

Responsibilities:

  • Documented business reporting requirements (functional/non-functional) and translated them into solutions.
  • Worked on multiple Complex tables through custom SQL.
  • Coded complex SQL queries to retrieve data from the database depending on the need
  • Made use of Sub query-Factoring (WITH clause) to make complex SQL statements simple and make them more efficient
  • Using set operators in PL/SQL like Union, Union all, Intersect and Minus
  • Developed and presented reporting models and mock-reports to get feedback and approval from business users. Installed and administeredTableauServer.
  • Building, publishing interactive reports and dashboards, report scheduling using Tableau Server
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other SQL code and SQL joins for applications.
  • Mentored business power users to create reports/dashboards using tableau desktop.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Utilized advance features of Tableau software like to link data from different data sources together on one dashboard to filter data in multiple views.
  • Data collection and leveraging on data manipulation teams for required data.
  • Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created Filled maps, actions, parameters, Filter and calculated sets for preparing dashboards and worksheets using Tableau.
  • Strong team member with good communication and analytical skills.
  • Experienced in tuning long running SQL queries for better performance.
  • Responsible for scheduling the subscription reports with the subscription report wizard.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Experience in the Date Modeling using Power BI Desktop to extract, transform and load the data from the Oracle Database.
  • Analyzed the data using statistical features in tableau to develop Trend Analysis reports.
  • Experience in assisting users in creating and modifying worksheets and data visualization dashboards.

Environment: Tableau Desktop 9.0, 8.3, 8.2, Tableau Server, SQL, Power BI, SQL Server, MS Access, Oracle.

Confidential

Tableau Developer

Responsibilities:

  • Created several dashboards that captured Operational Performance, Financial Performance, Information Security, Talent Management and Project Performance metrics
  • Migrated content from Production, QA to Development Environment
  • Used Actions extensively to link and filter sheets for easier navigation in Dashboards
  • Interacted with business users to gather requirements and provided guidance for the Data Warehouse team in how to structure data for optimal use in Tableau
  • Implemented ETL process to load the Data Warehouse and developed repositories (Microsoft SQL Server)
  • Performed dimensional modeling to help prioritize different business processes
  • Developed several scripts and SQL queries to create various reports for administration
  • Developed MicroStrategy reporting tutorial for employees to help them create their own customized report
  • Published Dashboards onto Tableau Server and from there consumers would choose viewing medium
  • Worked in Tableau environment to Create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server
  • Manage Production, Test and Development environments including installation of patches, security administration and access controls.
  • Involved in writing complex business rules for populating dimension tables, fact tables, and Aggregate tables.
  • Created complex reports like Detail Level Transaction report's, monthly Aging, YTD cash goal reports,
  • Created extensive joins for data blending from several different data sources
  • Helped customize Tableau Server with Company Logo and Company Pop-Ups
  • Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics
  • Attended meetings with Data Warehouse team, ETL team and Project Managers to track deliverable status
  • Performing complex data management, mapping and query development
  • Identification and integration of data from a variety of sources
  • Data fetching by going against different source systems like DB2 and Oracle
  • Assist with the design and development of analytic datasets
  • Liaise between business users and Tableau support team.
  • Work with various infrastructure teams and Tableau support team to help improve dashboard response time.

Environment: Tableau 8.0, 8.1, 8.2, Tableau Server, Oracle, SQL Server, MS Office

Confidential

Report Analyst

Responsibilities:

  • Interacted with business users and performed Gap Analysis of Client requirements.
  • Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
  • Worked with the report development Manager and other team members on report requirements based on existing reports/dashboards in Business Objects, timelines, testing, and technical delivery.
  • Worked closely with business power users to create reports/dashboards using tableau desktop.
  • Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
  • Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
  • Created Table of Contents (TOC), a common navigation page which had all the links to various reports.
  • Make use of filters and making them local and global accordingly.
  • Publish the developed dashboard, reports on theTableauServer so that the end users having access to the server can view the data.
  • Design and development of various reports and dashboards that can be easily accessible through Tableau App in pads, iPhones, and other smart mobile phones.
  • Actively participated in clarification meeting with the Clients.
  • Created Test Cases and documented the Test Results.
  • Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
  • Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007, MS Access, Windows 2007 server, Teradata, Microsoft office 2007.

We'd love your feedback!