Bi Developer/data Analyst Resume
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.