We provide IT Staff Augmentation Services!

Business Intelligence Big Data Analytics Consultant Resume

Houston, TX

SUMMARY

  • Over 12 years of experience in Business Intelligence Architecture and Development.
  • I have extensive knowledge in the deployment of enterprise level Business Intelligence solutions to improve business performance through increased revenue, reduced costs, and improved productivity.
  • Highly extensive experience with BI Management, Architecture, Administration, Development, Analysis and Reporting with expertise in Tibco Spotfire 7.11, Tableau 10, Power BI Stack, and Business Objects for developing data visualization dashboards and reports.
  • Extensively worked with data from Big Data Hadoop/HDFS, Hive, RDBMS like Oracle 11g/10g, Teradata.
  • Experienced with SSAS, SSRS & SSIS 2012 along with Transact - SQL, PL/SQL
  • Performed functions with Tableau adapters to cross relate with databases for data mining and data reporting
  • Developed complex SQL scripts for Teradata database for creating BI layer on Data Warehousing for Tableau reporting at Confidential
  • Converted existing Business Objects reports into Tableau interactive dashboards.

TECHNICAL SKILLS

  • Spotfire Development / Support
  • Business Intelligence
  • Spotfire Interactive Dashboards Creation
  • RDBMS Database
  • Big data Hadoop
  • Hive
  • Tibco Spotfire 7.11
  • Tableau 10
  • Power BI Stack
  • Business Objects
  • OLTP/OLAP Systems
  • ETL Informatica / SSIS
  • SSAS / SSRS / SSIS 2012
  • SQL / PL/SQL
  • Oracle 10g/11g
  • SQL Queries / DB2
  • SAP HANA
  • HANA Cloud
  • Teradata
  • DB2/ Database Access Tool
  • TOAD
  • MS Excel Services
  • MS Access
  • SharePoint 2013

PROFESSIONAL EXPERIENCE

Business Intelligence Big Data analytics Consultant

Confidential, Houston, TX

Responsibilities:

  • Lead a team of report analysts and data Modelers Designed, developed, tested, and maintain an end to end big data analytics project based on users’ requirements.
  • Designed and deployed rich graphic visualizations using spotfire solution tools.
  • Created user experience templates and feedback forms for effective collaboration.
  • Converted existing Business Objects reports in spotfire dashboards.
  • Developed spotfire data visualization using Pareto, combo charts, heat maps, box charts, scatter plots, geographic map, cross tabs, using property control and custom expressions.
  • Developed complex SQL scripts from big data Hadoop, Teradata database (RDBMS) for creating BI layer for spotfire reporting.
  • Responsible for building, publishing customized interactive reports and dashboards, report scheduling using Spotfire server.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets using Spotfire.
  • Effectively used data blending, filters, actions, hierarchies feature in Spotfire.
  • Administered users, user groups, and scheduled instances for reports in spotfire.
  • Executed and tested required queries and reports before publishing.
  • Converted metric insight reports to spotfire reports.
  • Gathered business requirements and designed technical requirements documentation.
  • Developed various dashboards, used context filters, sets while dealing with huge volume of data.
  • Designed dash boards for actionable, non-actionable proof of concept reports for big data analytics from the Hadoop eco system using Hortonworks Hive data source.
  • Generated dashboards to compare the expected weekly sales vs projected sales used dual axis for comparison.
  • Generated dashboards by joining multiple complex tables.
  • Prepared different views for Small Business Health Options Program.
  • Generated dashboard for finance team, provided security by using user filters.
  • Created various complex visualization reports and charts using cross tables, bar charts, line charts and different layers of map charts.
  • Supported the use of spotfire solutions files and helped educate business users to facilitate early adoption of the tool.
  • Worked closely with business users, assisting them with questions and issues using spotfire.
  • Used Excel sheet, flat files, and CSV files to generate spotfire adhoc reports.
  • Interacted with ETL developers, Project Managers, and members of the QA teams.
  • Worked with various infrastructure teams and spotfire support team to help improve dashboard response time.
  • Developed donut charts for analyzing sales planning data.
  • Created different KPI's using table calculations and calculated key figures - manipulating strings, arithmetic calculations, aggregation options and Logical functions.
  • Worked extensively with advanced analytics like reference lines, bands, and trend lines.
  • Utilized different formatting techniques using annotations and mark labels.
  • Published and shared views on Spotfire server.
  • Scheduled extract refresh and subscriptions.
  • Performed administration tasks such as creating and managing sites, setting permissions, managing ownerships and providing access to the users using user filters and adding them to the specific group.
  • Wrote and maintained technical documentation to describe reports development, logic, coding, testing, changes, and corrections.
  • Trained CSRs on Spotfire software.
  • Gathered clients, suppliers and internal resource data from all the Vendor Management Systems.
  • Generated new KPI for Scorecards.
  • Performed data collection and leveraging on data manipulation teams for required data.

Lead Business Intelligence Consultant

Confidential

Responsibilities:

  • Converted various Excel, and BO reports to Tibco Spotfire.
  • Performed as main point of contact for business users to gather business requirements for the creation of actionable proof of concepts KPI’s through mock up visualizations which are based on the business needs
  • Led cross functional group of BI developers and data/ETL modelers.
  • Provided troubleshooting and diagnostic support for BI analytics tool configuration and release management
  • Experienced in Tibco Spotfire implementation, configuration and administration.
  • Responsible for maintenance of library administration, user security access and performance tuning and optimization
  • Identified and raise system capacity related issues (storage, licenses, performance threshold)
  • Created visualizations for preventive and predictive analytics using R scripting and custom expressions.
  • Created Data sources for regular and customized row level security information links creations
  • Created various complex visualization reports using 3D scatter plots Cross tables, Bar Charts, Line Charts and different layers for an interactive map charts from geo-data gathered via Arch Gis and WM services
  • Customized data by adding property controls, filters, calculations, summaries and functions.
  • Created information links by using Information Designer to pull the data from Teradata Database (RDBMS) and SAS data sets.
  • Used Automation Job Service Builder to Export DXP file during migration process.
  • Developed reports using Spotfire Professional and published the same to Spotfire Server for business users to use.
  • Created various prototypes for the production engineering and production forecasting teams to show various Spotfire analytics and their efficiency in helping users make informed business decisions.
  • Created Action Controls using Python scripting.
  • Handled multiple data tables in analysis.
  • Enhanced reports created in Spotfire 7.6
  • Conducted Unit testing of the reports developed in Spotfire Professional.
  • Responsible for the migrating the reports from development to acceptance / production server.
  • Worked on developing training program, user guide for Spotfire Professional and Spotfire web player in terms of best developing and design practices.

Business Intelligence Developer

Confidential, Taylor, TX

Responsibilities:

  • Created a high-stake project dashboard for company executives (CEO and CTO), directors, stakeholders and decision makers
  • Used Microsoft Power View as the presentation and reporting layer with a Power Pivot model as the backend engine via a SQL Server database (RDBMS).
  • Utilized Power Query and SSIS 2012 to resolve data import from a SQL Server database(RDBMS) engine.
  • Performed several DEMOS on Microsoft Power View and Power Pivot capabilities via PowerPoint 2010
  • Utilized SharePoint 2013 Access forms for data entry and Excel services for report rendering.
  • Architected and created several reports utilizing calculated fields and columns, dimensions and measure with over 100 metrics and Key Performance Indicators (KPIs) embedded in the reports
  • Converted several existing Business Object reports and Universes into SSRS 2012 reports.
  • Created SSAS 2012 multidimensional conventional and tabular cubes for different BI initiatives.
  • Created Star and Snowflakes database schemas for several BI solutions
  • Created Performance Point server reports, drill through, drill down, main/detail reports, scorecards with an OLAP Multidimensional conventional database as the back end

Business Intelligence Consultant

Confidential, Austin, TX

Responsibilities:

  • Responsible for implementing enterprise-wide Microsoft Business Intelligence solutions using cutting-edge technologies such as Performance Point Server 2007 (PPS), Reporting Services (SSRS) and Microsoft Office SharePoint Server (MOSS). Reports run on both SQL Server 2008 and 2005 platforms.
  • Utilized OBIEE to create and analyze queries using proactive intelligence delivery and alerts.
  • Created enterprise and financial reports, online analytical processing (OLAP) analysis and presentation.
  • Performed functions with Tableau adapters to cross relate with databases for data mining and data reporting
  • Developed core and standard reports by designing complex report templates.
  • Maintained report library to enable re-use of templates, which streamlined the creation of new reports.
  • Developed and delivered dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS).
  • Developed reporting techniques included time series, trend analysis, de-normalization of data and Linear Regression.
  • Developed custom T-SQL stored procedures, views, functions (table value functions) used by reporting services.
  • Served as the conduit between the customer community (internal and external) and the software development team through which requirements flow.
  • Configured reporting manager for subscription, email notification, drill down reports, data sources and users’ security.
  • Utilized Analysis Services (SSAS) to design multi-dimensional models, including the construction of data source views, dimensions, and cubes while adhering to enforced development methodologies for Reporting Services and performance point.
  • Developed report models for users to create reports on demand.
  • Developed scorecard, KPI’s, indicators, reports, grids, filters (inbound and outbound) using
  • Deployed data via MOSS 2007 to document libraries.
  • Created dimensions, attributes, measures group used by dashboards in Performance Point.
  • Designed dashboards, including scorecards and reporting with the Dashboard Designer delivered via MOSS for One Touch projects. Prototype SQL Server 2005 Analysis Services (SSAS) cubes using Unified Dimensional Model (UDM) for custom reporting on SSRS 2005/2008.
  • Deployed SSRS RDL’s to test, staging and production from bids.
  • Assisted QA team in writing test plans and scripts to test functional, operational reporting and dashboard.

Business Intelligence Developer

Confidential, Houston, TX

Responsibilities:

  • Developed complex SQL queries (ex: using various joins and sub-queries) and stored procedures.
  • Developed complex expressions to calculate, group, filter, parameterize, and format the contents of a report.
  • Configured layout and graphical presentation of data within reporting services.
  • Developed high quality SSRS solutions designs (SharePoint integrated mode).
  • Created custom parameters used by business-specific reports.
  • Developed complex stored procedures called by reporting services.
  • Developed charts, matrix, report types used as company-wide benchmarks for Performance Management.
  • Designed parameter-driven reporting environment or super users to directly access the data warehouse to create ad-hoc reports.
  • Created user-friendly, flexible, personalized dashboards. Reports used by diverse group of users. Set up email alerts using IBOTS.
  • Performed in-depth performance tuning of reports, queries and stored procedures to keep databases and reporting processes optimized.
  • Worked with DBAs and ETL developers to create optimized reporting structures.
  • Analyzed data models and worked with data architects to further define and create new models to support on-going reporting business needs.
  • Created ad-hoc queries and reports as requested. Provided on-going analytical support for ad-hoc requests.
  • Converted existing reporting tools to standardized reporting infrastructure using SQL and SSRS.
  • Led and participated in efforts to create test plans used to validate implementation against original requirements (Reporting Services and Performance Point).

Quality Assurance Analyst

Confidential, Houston, TX

Responsibilities:

  • Developed TSL scripts for Ensemble 3.2, 3.4 Amdocs billing system software project.
  • Built and configured application pool in IIS to use the right application and directory settings.
  • Deployed BCD List for info path forms, SharePoint web parts in SharePoint 2003.
  • Maintained application logs for deployment processes and checkpoints.
  • Migrated to SharePoint 2003 in implementation phases and tested branding, navigation, links, web contents, web parts and security entitlements.
  • Performed extensive regression testing utilizing Test Director (test case planning and defects reporting) on Amdocs billing system front-end applications.
  • Managed vendor development team to set expectations of defect priority. Coordinated fixes for each build and hot fix/patch for server migration between test, production and staging.
  • Played major key role in data migration during “Go-Live” phase from QA, Staging, UAT, ITG and PRO.
  • Mapped right web-config for Web Services to point to the right database to populate the correct data in test and production environment.
  • Solely responsible for the planning, testing and defect tracking of the automated collection software.

Quality Assurance Analyst

Confidential, New Orleans, Louisiana

Responsibilities:

  • Worked with QA Manager and Project Managers to prioritize and schedule QA testing and to resolve scheduling conflicts in a Web- Based Environment
  • Trained, administered, installed and managed Mercury-Interactive automated testing tools: Test Director and WinRunner.
  • Analyzed functional specifications to ensure Automated Test Lifecycle Methodology (ATLM) was followed.
  • Responsible for the planning and execution of all test plans, test cases and test scripts which specify Testing overviews and responsibilities.
  • Implemented matrix-form test scenarios.
  • Performed regression, functional, system and load/scalability testing.
  • Created robust WinRunner test scripts using WinRunner 6.0 and 7.0.
  • Automated several manual regression test cases using Win Runner.
  • Managed team to meet project deadlines while ensuring standard operating procedures were followed.
  • Conducted stress, load and performance testing to verify the stability and performance of the components created by the development team.
  • Used test director and quality center to maintain requirements, test cases, pass/fail status and for bug tracking

Hire Now