We provide IT Staff Augmentation Services!

Senior Business Intelligence Analytics Lead Resume

San Antonio, 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 Tableau 10, Tibco Spotfire 7.11, Power BI Stack, OBIEE, 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.
  • Converted existing Business Objects reports into Tableau interactive dashboards.

PROFESSIONAL EXPERIENCE:

Senior Business Intelligence Analytics Lead

Confidential, San Antonio, TX

  • Lead a team of offshore report analysts in designing and developing work frames for new reports and maintenance of end to end big analytics several bank services LOB projects based on users’ requirements.
  • Administration of Tableau for the creation of users, setting permissions, scheduling of jobs, and monitoring of users and tasks status on servers
  • Created several complex predictive analytics models and Cluster Analysis using advanced data manipulation techniques such as ‘R’ and Iron Python.
  • Designed and deployed rich graphic visualizations to show metadata health and data governance controls using Tableau.
  • Prepared different proof of concept views for data governance, controls and bank services metadata Health reports.
  • Created user experience templates and feedback forms for effective collaboration.
  • Converted existing OBIEE reports into Tableau dashboards.
  • Developed Tableau data visualization using Pareto, combo charts, heat maps, box charts, scatter plots, geographic map, cross tabs, using property control and custom expressions.
  • Responsible for building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Implemented several actions, filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau.
  • Effectively used data blending, filters, actions, hierarchies feature in Tableau.
  • 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.
  • Gathered business requirements and designed technical requirements documentation.
  • Developed various dashboards, utilizing context filters for filter consistency and sets while dealing with huge volume of data.

Senior Business Intelligence Analytics Lead

Confidential, Houston, TX

  • 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.
  • 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 Tableau solutions and helped educate business users to facilitate early adoption of the tool.
  • Worked closely with business users, assisting them with questions and issues using Tableau.
  • Used Excel sheet, flat files, and CSV files to generate Tableau adhoc reports.
  • Interacted with ETL developers, Project Managers, and members of the QA teams.
  • Worked with various infrastructure teams and Tableau 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 Tableau 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 Tableau 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, Austin, Texas

  • Converted various Excel, Tableau 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.
  • 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

  • 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

Freescale Semi Conductor, Austin, TX

  • 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

  • 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

  • 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

  • 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