We provide IT Staff Augmentation Services!

Business Intelligence Resume

Richmond, VA

PROFESSIONAL SUMMARY:

  • Over 7+Years of experience in Complete Software development life cycle (SDLC) of Database, Data warehouse and Business Intelligence Applications.
  • Extensive experience in working with Tableau 8.0 Workbooks, and Intelligent Dashboards.
  • Good knowledge of Relational database concepts and poses strong knowledge in writing SQL queries in Teradata, oracle and DB2.
  • Strong experience in creating Logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data.
  • Extensive experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive Dashboards with page and dashboard Prompts.
  • Used Tableau Desktop for creating different interactive views and Dashboards.
  • Created extract files for improving the performance. Have used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
  • Expert in Unit, System and Integration Testing and Performed Data Validation for all the ETL’s and reports generated from various ETL sources.
  • Experienced in Business Intelligence (Teradata - SQL, SSIS, SSAS and SSRS), Data Warehousing and Dashboards. Develop & deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS).
  • Unique combination of personal, analytical, technical and communication skills.
  • Expertise in different stages of handling data viz. requirement gathering, identifying data sources/targets, data modeling, data cleansing, data loading, and building Star schema.
  • Experience in creating SQL, PL/SQL, Stored Procedures/Packages/Triggers/Cursors and UNIX Shell scripts.
  • Business Intelligence Consultant who analyzes data and provides visual communications that deliver insights to support key business decisions. Understands value that users require from their data and processes.
  • Hands-on with creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop versions 8.0, 8.1 and 8.2.
  • Utilized all Tableau tools including Tableau Desktop, Tableau Server, Tableau Reader, and Tableau Public.
  • Build better dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data.
  • Built and expanded reports available for both internal support and external customer reports, which included increasing the scope of data extracted and better utilization of reporting.
  • Experienced in troubleshooting and performance tuning of reports and resolving issues within Tableau Server.
  • Experienced in Tableau Server administration including setting up Active Directory users and groups, giving appropriate permissions for viewing published dashboards and scheduling data
  • refresh instances.
TECHNICAL SKILLS:

BI Tools: Tableau, MicroStrategy, Microsoft SQL Server Reporting Services

Data Integration Tools: Informatica, SQL Server Integration Services ( SSIS)

SQL Tools: Teradata SQL Assistant, Toad, PL/SQL Developer, Rapid SQL,

RDBMS: Teradata, Oracle, SQL Server,DB2, MySQL, Access

Documenting and Data Modeling Tools: Power Designer, Erwin, ER Studio, MS Visio, MS Project, MS Office(Word/ Excel/ Access/ Power Point), MS SharePoint, Documentum.

Scheduling Tools: Autosys, Control M

Defect Management/ Testing Tools: Mercury Test Director, HP Quality Center

Change/ Service Management Tool: HP Service Manager, CA Service Desk Manager, Lotus Notes

Scripting/Lang.: C, C++, HTML, JavaScript, Python, PERL, SQL, PL/SQL, and XML

Operating Systems: Windows XP/ Net/2000/ Vista/7, Unix, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Tableau Developer

Roles & Responsibilities:

  • Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
  • Analyzed various reports, dashboards, scorecards in MicroStrategy and created the same using Tableau desktop server.
  • 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 connections together on one dashboard and to filter data in multiple views at once.
  • Involved in new KPI generation for Scorecards.
  • 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.
  • Identify new metrics and enhance the existing KPI's.
  • Dashboard Visualization through Tableau BI application.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
  • Effectively used data blending, filters, actions, Hierarchies feature in tableau.
  • Defined best practices for Tableau report development.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Executed and tested required queries and reports before publishing.
  • Converted metric insight reports to tableau reports.
  • Working extensively with Tableau Business Intelligence tool to develop various dashboards.
  • Working extensively using Excel to validate the data and use as the source data files.
  • Analyzing the data using Statistical features in Tableau to develop trend analysis.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
  • Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
  • Design and development of various reports and dashboards that can be easily accessible through Tableau App in Ipads, iPhones, and other smart mobile phones.

Environment: Tableau (Desktop, Server), Teradata, Teradata SQL Assistant, Teradata Administrator, SQL, PL/SQL, MS Project, MS Office Suite (Word, Excel, PowerPoint)

Confidential Phoenix, AZ

Business Intelligence/Tableau Developer

Roles & Responsibilities:

  • Worked for the IT Service Management, DSM and Enterprise Capacity Planning groups
  • Managed the reporting, dash boarding and regularly published to the Tableau Server.
  • Re-created all excel reports to tableau also imported excel data to create reports in tableau.
  • Used Advanced Excel analytical functions, e.g., Pivot tables, VLookUp, HLookUp, MATCH, INDEX; tabulating information using multiple criteria such as, COUNTIFs, SUMIF, AVERAGEIF functions.
  • Developed complex queries with the team, to extract, manipulate and transform data from several databases (SQL, Oracle & Teradata).
  • Thoroughly analyzed existing dashboards and worked to improve the system performance of large databases and thereby reducing query time.
  • Gave Tableau clinics for training other team members in effectively utilizing advanced tools and features in Tableau for generating valuable Views, Dashboards and reports.
  • Created powerful dashboards/views utilizing pie, bubble, bar & line charts, stacked bar graphs, small multiples, Gantt & Pareto charts, drill downs, advanced filter actions, complex data blending, moving averages, bins, forecasting, linear regression modeling, geo coding and mapping.
  • Worked in conjunction with Quality Assurance(QA) & business testing team for User acceptance test
  • Performed SWOT and brought on process changes to improve user experience

Environment: Tableau Desktop 8.1 and 8.2, Tableau Server 8.1 and 8.2, MS Excel, MS SQL Server 2012 R2, Active Directory, Tableau Data Extract (TDE), Google Analytics, and API Data

Confidential, Fairfield, CT

Tableau Developer

Roles & Responsibilities:

  • Interacted with the Customer Support Group for domain requirements gathering.
  • Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
  • Involved in defining the whole project life cycle, following agile methodology. Analyze business requirements and segregated them into high level and low level
  • Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
  • Assisted Project Manager in developing in project timeline and resource estimations.
  • Developing and maintaining high level overview of the data flows using MS Visio
  • Thoroughly analyzed the current Architecture, databases and designed schemas.
  • Creating and modifying Business Intelligence analytical reports/ dashboards using Tableau Desktop.
  • Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
  • Created very complex Dashboards using Tableau 8.0 using the drill down, drill across, actions for business steering committee.
  • Created Complex dashboards in tableau using the various sources of data from Excel sheets, Teradata, SQL Server, Oracle databases.
  • Designed, Developed and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
  • Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
  • Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
  • Worked on SQL Tuning and Optimization of the reports.
  • Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
  • Created Unit Test Cases and documented the Unit Test Results.
  • Actively participated in clarification meeting with the Clients.
  • Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
  • Involved in testing the database using complex SQL scripts and handled the performance issues effectively.
  • Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau, Teradata, Teradata SQL Assistant, Fast Load, Oracle, SQL, PL/SQL, SQL Developer, Informatica Power Center,, DB2, Oracle, SQL Server, Control-M, MS Project,.

Confidential, Virginia Beach, VA

Tableau Report Developer

Roles & Responsibilities:

  • Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects
  • Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
  • Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
  • Scheduled the published dashboards from Tableau Server on weekly basis.
  • Sending the dashboards to users by emails with the help of admin team with subscriptions.
  • Performance tuning of Reports by creating Linked Universes, Joins, Contexts, Aliases for resolving loops and checked the integrity of the universes using Business Objects Designer module during development.
  • Given training/demos to users on Tableau Desktop for development.
  • Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
  • Created Data Connections, published on Tableau Server for usage with Operational/Monitoring xe Dashboards.
  • Administered user groups and scheduled instances for reports in tableau.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Built complex formulas in Tableau for various business calculations.
  • Resolved various performance issues and analyzed the best process distribution for different projects.

Environment: Teradata, Oracle, Teradata SQL Assistant, Teradata Administrator, TOAD, SQL, Share Point, TFS, Agile-Scrum, Informatica, Tableau, Autosys, UNIX, SQL Server, ERwin, MS VISIO, Microsoft Office.

Confidential, Hyderabad, India

BI Developer

Roles & Responsibilities:

  • Worked on Database design and reporting. Experience working with Tableau, Spotfire development of dashboards and publishing the reports. Working on Data warehousing and reporting.
  • Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
  • Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS).
  • Experience in using SQL Server 2005 Integration Services (SSIS) to extract, Transform and Load data from any OLEDB Provider like DB2, MS Access, Flat File, Excel, Oracle, Lotus notes and Sybase and DTS (i.e. Import and Export) and Automate the ETL operations.
  • Developing Ad hoc reports within SQL Server Reporting Service (SSRS).
  • Working with Tableau, Spotfire, Qlikview, Logi XML tools for reporting.
  • Creating dataflow diagram and documenting the whole data movement process.
  • Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic. Writing high level and detail design documents.
  • Creating report models and deploying on report server.
  • Creating standard report Subscriptions and Data Driven report Subscriptions
  • Creating report snapshots and cache for better performance.

Environment: Oracle 8i, SQL, Windows NT, SQL Server 2005, T-SQL, and Windows XP/2000.

Hire Now