bfe50954-0593-43bc-94b5-b0022ba5e4bc

Andrew Smith


287 Custer Street, Hopewell, PA 00000

(000) 000-0000

Professional Summary

Perceptive and logical data analyst with proven ability to communicate with both professionals and end users to identify and translate business requirements. Offering 10+ years of experience driving data accuracy and integrity. Proven ability to build and lead teams of talented professionals to develop valuable process solutions to meet business objectives

Employment history

BI Consultant (Team Lead), Gutkowski-Doyle. North Josphine, Michigan
Dec. 2016 – Present
 
Team handling and performing the L2/L3 activities 
Cube designing and bug fix using transformer 
Providing RCA for critical environmental issues 
Responsibilities includes cognos administrator/report building/cube related issues along with package enhancement 
Managing team with both offshore/onshore resource handling capabilities 
Standup meeting handling with efficient handovers of tasks 
Active participation in Cognos 10.2 –> SAP HANA migration activities as part of 2019 roadmap. Undertaking installation of cognos patches and end-end cognos admin activities 
Working on the Cognos-SAP HANA integration methodology and implementation 
Built HANA calculated views as part of POC 

Senior Software Engineer, Mraz-Collier. Wiltonchester, Nebraska
May. 2015 – Feb. 2016
 Working on SR/Incidents on Cognos Analytics(version 11) platform 
Daily interaction with Clients on environment and ticket handling 
Monitoring the cognos services, cube build-refresh activity and perform sanity checks 
Report development using Cognos Analytics(version 11) for internal project audits 

Application Developer, Kertzmann-Kshlerin. Friesenbury, Hawaii
Feb. 2014 – Aug. 2014
 
Developing of dashboards and score cards using Cognos 10x series
Owning the cognos administration task which includes the patch installation and load balancing 
Developing test cases and creating functional specifications and technical design document    
Involved in migration of ReportNet 7.3 to Cognos 10.1 and delivered the migrated reports
Capable of data modelling and applying SQL skills to understand the data flow

Education

Southern Lueilwitz College, Saraside, Ohio
Bachelor of Science, Engineering, Mar. 2008

West Satterfield, New Elbert, Hawaii
Associate of Science, Oct. 2003

Accomplishments

Tools

Declaration

Skills

SAP HANA

Datawarehousing

SQL

c3e2eaea-a82c-4155-ba19-9fd4f73a4bdc

Andrew Smith

287 Custer Street, Hopewell, PA 00000
[email protected]
(000) 000-0000

Professional Summary

IT Professional with over 2 years of successful experience in analytics. Recognized consistently for performance excellence and contributions to success. Strengths in Data warehousing and data analysis backed by training and experience. Looking forward to working in a company with competitive environment and grow along side the company.

Skills

Python
Beginner

ABAP
Experienced

RPA
Experienced

BW4HANA
Experienced

Tableau
Skillful

SQL
Skillful

R
Skillful

Employment history

BI Consultant, Lakin-Huel. Vicenteview, Missouri
Jan. 2020 – Present
  1. Development of complete models i.e. from Datasource to extract data from different systems till the Data Store Objects which will hold the data ready for reporting in BW4HANA system.
  2. Analysis of report scheduling in production to reduce the report failure count from approximately 40 to 0-5.
  3. Analysis of BO KPI reports with real time data for the business users.
  4. Monitoring of daily data loads from multiple systems including SAP and Non-SAP systems to BW system which is then being used in around 250 BI reports everyday. 
  5. Data warehousing of Spare Parts Management and other different areas data which is used by Business users across Globe like China, Germany etc.
  6. Leading the DaTis system monitoring which is the system with status of critical background jobs.

RPA Developer, Bernier-Fadel. East Heath, Wisconsin
May. 2019 – Jun. 2019
  1. Automating a process of queue clearing which reduced the time for the process from 2 days to 4 hours.
  2. Automation of other workarounds which reduced the total count of ticket by 40 which was a huge cost savings. 
  3. Taking responsibility of gathering the requirements from leads of 5 different process areas for automating the repeated tasks in respective process areas. 
  4. Prepare the process documents for effective support and understanding of the process.
  5. Ensuring the quality of the developed product and then deploying them in production.

ABAP Technical consultant, Cole-Borer. North Christoper, Minnesota
Aug. 2018 – Sep. 2018
  1. Reduction in the manual effort by automating the weekly report for runtimes of critical reports which is sent via email to stake holders using ABAP.
  2. Enhancements in the current ABAP reports in production when and where required.

Education

The Feeney, South Madeleine, Missouri
MBA, Data Science and Business Analytics, Present

The Maine College, Marcelomouth, Utah
Bachelor of Engineering, Computer Science, Jul. 2018

Academic Projects

Trainings and workshops

bi consultant

  • Schedule data refresh on Tableau server for weekly and monthly increments based on business changes.

bi consultant

  • Involved in Data Preparation and Cleaning process 
  • Creating Data Model.
  • Writing Mysql stored procedures and complex queries for reporting.
  • Involved in preparing & designing Data Models using R
  • Developing Insights Using Lumira

bi consultant

  • Demonstrate database technical functionality, such as performance,  and reliability.
  •  Assisted in fixing WebFOCUS reports cosmetic issues, browser related issues.
  • Converted complex MicroStrategy SQL into WebFOCUS using SQL Pass-through, with perfect data match.
  • Extracted SQL to generate reports in WebFOCUS and gathered default selections to replicate the same in WebFOCUS. 

bi consultant

  • Solve technical design issues in BI architecture.
  • Short assignments of performance tuning across several clients on the consumer goods domain. 
  • Develop Stored Procedures, SQL jobs, SSIS packages, Tableau dashbaords. 
  • Performed Regression and SIT Testing.

senior bi consultant

  • Attività di prevendita per prospect e clienti su vari prodotti di Business Analytics (Oracle BI, Essbase, Tableau) e Data Integration (Talend)
  • Attività di delivery su progetti di analisi dati, per aziende del settore TLC, Pharma e Manufacturing.
  • Developed reports in InfoAssist, which has given the capability to develop their own ad-hoc reports.
  • Created A2A validation document, which was used as a common template for all the folders.

bi consultant

  • Prepare evaluations of software or hardware, and recommend improvements or upgrades, For Dundas BI Application.
  • Build, configure, and test RPA Processes using UiPath studio.
  • Build, develop and give consultations dashboards based on business needs.
  • Build a dashboard for Hajj season, to management and IT operations.
  • ETL to build dashboards from multiple sources.
  • Meeting Planner and follow up.

junior bi consultant

  • Responsible for Tableau Server Administrative functions, upgrades, installations and configurations.
  • Assigned permissions to different Lines of Businesses and users.
  • Schedule data refresh on Tableau server for weekly and monthly    increments based on business changes.
  • Tableau site admin – Published, revoked and granted permissions to the published dashboards.
  • Involved in development of the Reports and Graphs.
  • Maintained the module specifications documents for the reports.
  • Created compound reports in output formats of Excel and PDF. The compound reports included reports and graphs together which should be available in both Excel and PDF formats.

bi consultant

  • Data warehouse development for Vodafone Hungary
  • Programming language: Oracle SQL
  • Knowledge following technologies: ETL, Oracle Data Integrator,Business Objects, PL-SQL
  • Knowledge in cloud data warehousing via Google Cloud Products

bi consultant

  •  Expert in providing Enterprise Reporting solutions using SSRS 2008/2012/2014/2016. 
  • Extensive ETL experience using DTS/SSIS/Alteryx for Data Extractions, Transformations and Load. 
  • Designed, developed, implemented, and supported Power BI dashboards. Integrated data sources and databases with Power BI, and designed and developed data models and back end queries for presenting data.
  • Designed testing plans and scripts in HP Quality Center based on requirements

bi consultant

  • Represented Google Express Merchant Direct customers and enhanced customer satisfaction by driving omni-channel customer support capabilities
  • Partnered with project management to develop comprehensive dashboards summarizing Google Express merchant performance
  • Defined business process flows using Microsoft Visio, data requirements using Excel, and report layouts for the Ops users
  • Developed ETL via SQL and App Scripts engine queries for over 200 merchants across 3 performance metrics (Days Outstanding, Refund SLA, Email Response Rate)
  • Decreased purchase lookup processing time by 30% and increased value recovery rate by 40% by automating scan operations for a critical piece in the value recovery value chain
  • Automated 6 hours of daily customer support email inquiries and implemented script that auto-generates email based on merchant, escalation type, and returns details
  • Spearheaded migration of Scan Ops department from Pittsburg to San Jose, thereby increasing efficiency and reducing head count