bd35a409-0fba-4b19-a762-1423901e4332

Andrew Smith

Professional Summary

 Business Analyst with 2.5 + years of total work experience interpreting and analyzing data in order to drive successful Business Solutions. Proficient knowledge in Statistics, Mathematics, Economics, Machine Learning & Analytics. Excellent understanding of Business Operations and Analytics tools for effective analysis of Data. 

Employment history

Business Intelligence Analyst, Tillman-Hermann. Johnsville, New Jersey
Mar. 2020 – Present
*Perform daily,weekly,monthly reviews and analysis of current processes using operational metrices.
*Create informative,actionable reports that highlights relevant business trends and opportunities for improvement.
*Define project requirements by identifying project milestones,phases and elements forming project teams establishing project budget.
*Working on specific product metrics to improve overall engagement and conversion.
 

Business Analyst, Wolff and Sons. Lake Lacy, Missouri
Feb. 2019 – Mar. 2019
 1.Partner Attrition: 
 
Tools Used: R, Hive, Excel 
 
Ø Analyze and build metrics to identify the root cause of partner attrition. 
Ø Analyze and take measures to control employee attrition. 
Ø Created Dashboard to visualize and analyze city wise cancellation done and RCA for cancellation. 
 
2. OLA Postpaid: White-listing 
 
Tools Used: Python, Hive, Excel 
 
Ø White-listing customers for OLA Postpaid (ride now pay later) by looking at their past history of response and default. 
Ø Approached the problem using decision approach to find out a group of customer with higher probability of response and lesser default rate. 
 
3. Customer Segmentation: 
 
Tools Used: Python, Tableau         
 
Ø Classified customer based on relevant attributes like quality, affordability and frequency of transactions. 
Ø Classification helps business to identify the products that are affordable without compromising with the quality. 
Ø Successfully implemented K means clustering to cluster million customers. 
Ø RFM (Recency, Frequency, Monetary) analysis for behavior-based customer segmentation. 

Application Developer 1, Hilpert-Olson. South Hildegardefurt, Nevada
Nov. 2016 – Dec. 2016
·Involved in Architecture Design, Requirement Gathering, Coding & Migration Process. 
·Installed & configured Master & Work Repositories. 
· Responsible for setting up ODI in all 3 environment (DEV, TEST,PROD). 
·Configured data servers for oracle database and setup physical & logical models in Topology Navigator. 
·Responsible for designing, developing and testing ETL strategy to populate data and Change Data Capture (CDC). 
·Working on ODI Designer for designing the Interfaces, defining the data stores, Interface and Packages, created mappings. 
· Export/Import Interfaces,Scenarios,Packages across different environments. 
· Configured ODI Agents on server and tested them to execute & schedule ODI jobs. 
·created load plans to run the scenarios in a hierarchy of sequential and parallel steps and created unit-testing codes for end to end testing of ETL packages. 

Education

East Idaho Academy, Abshireville, South Dakota
12th, Science, Sep. 2011

North Bednar University, West Christenfort, Alabama
10th, Science, Oct. 2009

Personal info


Phone:

(000) 000-0000

Address:

287 Custer Street, Hopewell, PA 00000

Skills

Python








SQL








Excel








e43fab83-8c1c-4297-9d83-37e99a3e82e0

Andrew Smith


287 Custer Street, Hopewell, PA 00000

(000) 000-0000

Professional Summary

Analytical, accomplished, professional Business Intelligence (BI) Analyst and Developer with over 5 years of experience in multifaceted roles requiring project management, business development, and solutions architecture.  Skilled in the areas of agile development, enterprise data warehousing, and data analytics. Motivated and eager to advance my career with a growth-oriented, technically-advanced organization as a Chief Information Officer.

Employment history

Business Intelligence Analyst, Nolan-Hilpert. Goldnerburgh, Montana
Mar. 2020 – Present
Responsible for building BI solutions pertaining to product pricing. The role involves requirement gathering from business, designing data flow and Data visualization to depict business operations. 

IT Analyst, Balistreri Group. West Iraview, Montana
Jan. 2015 – Aug. 2015
  • Data Migration from legacy system to Oracle Database. 
  • Query and performance tuning in PL/SQL. 
  • Building EDW solution for finance analytics project. 
  • Building  data visualization in Tableau 2018.1 (Sales/Volume/Variance report) and drawing meaning out of it. 
  • Integrating R with Tableau in order to enable write back to DB through Tableau. 

Education

South Haag, Baileymouth, Minnesota
B.Tech, Electronics & Communication, Nov. 2014

Hyatt Academy, South Jeff, Illinois
Diploma, Electronics & Telecommunication, Nov. 2011

East Mueller, Port Tylerland, Minnesota
Higher Secondary, Science, Mar. 2008

North Wyoming College, New Shanelbury, New Mexico
Secondary Exam, General, Aug. 2006

Skills

Data Migration

R

Power BI

Tableau

PL/SQL

SQL

49cf11f7-8df0-4710-9aa1-8c90894879d8

Andrew Smith

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

Professional Summary

Analytical, accomplished, Business Intelligence (BI) Analyst and Developer with over 1 years of experience in multifaceted roles requiring project management, business development, and solutions architecture.  Skilled in the areas of agile development, DevOps delivery, enterprise data warehousing, and data analytics. Motivated and eager to advance my career with a growth-oriented.

Employment history

Business Intelligence Analyst, Miller, Thompson and Boehm. New Letha, Illinois
Jan. 2020 – Present
 
  • Develop and manage BI solutions.
  • Provide reports, processes and Power BI.
  • Collaborate with business users.
  • Analyze business processes and requirements.
  • Create and maintain documentation including requirements, design and user manuals.
  • Identify opportunities to improve processes and strategies with technology solutions.
  • Identify development needs in order to improve and streamline operations.
  • Design, evaluate, recommend, and approve changes of forms and reports.

Java Developer, Yost, Vandervort and Pacocha. North Maggiebury, Kentucky
  • Analyze information to determine, recommend, and plan installation of a new system or modification of an existing system.
  • Modify existing software to correct errors, to adapt it to new hardware, or to upgrade interfaces and improve performance.

Projects

Technical Proficiency

Skills

Java Developer
Beginner

Business Analyst
Skillful

Python Developer
Skillful

Power BI Developer
Skillful

Data Analyst
Skillful

Business Intelligence Analyst
Skillful

Workshop & Trainings Attended

Education

Nicolas University, North Shea, North Dakota
B.Tech, CSE with Specialization in Big Data Analysis, Present

Eastern Denesik, Faheyport, Kansas
High School Diploma, Science, Jul. 2016

South Delaware College, South Evangelina, Hawaii
School Secondary Certificate, General, Apr. 2014

Languages

English
Fluent

Hindi
Native speaker

Gujarati
Conversational

Declarations

2489e080-ec52-4844-a228-574c2267ac3f

Andrew Smith

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

Professional Summary

Analytical, accomplished, Business Intelligence (BI) Analyst and Developer with over 1 years of experience in multifaceted roles requiring project management, business development, and solutions architecture.  Skilled in the areas of agile development, DevOps delivery, enterprise data warehousing, and data analytics. Motivated and eager to advance my career with a growth-oriented.

Employment history

Business Intelligence Analyst, Schmeler, Kunze and Mosciski. Runolfssonborough, Washington
Jan. 2020 – Present
 
  • Develop and manage BI solutions.
  • Provide reports, processes and Power BI.
  • Collaborate with business users.
  • Analyze business processes and requirements.
  • Create and maintain documentation including requirements, design and user manuals.
  • Identify opportunities to improve processes and strategies with technology solutions.
  • Identify development needs in order to improve and streamline operations.
  • Design, evaluate, recommend, and approve changes of forms and reports.

Java Developer, Franecki, Mosciski and Bailey. Alenatown, Iowa
  • Analyze information to determine, recommend, and plan installation of a new system or modification of an existing system.
  • Modify existing software to correct errors, to adapt it to new hardware, or to upgrade interfaces and improve performance.

Projects

Technical Proficiency

Skills

Java Developer
Beginner

Business Analyst
Skillful

Python Developer
Skillful

Power BI Developer
Skillful

Data Analyst
Skillful

Business Intelligence Analyst
Skillful

Workshop & Trainings Attended

Education

Eastern Connecticut University, Port Damienland, Georgia
B.Tech, CSE with Specialization in Big Data Analysis, Present

Murazik Academy, West Tobiasburgh, Maryland
High School Diploma, Science, Jun. 2016

South Feest, Vandervortville, New Hampshire
School Secondary Certificate, General, Jul. 2014

Languages

English
Fluent

Hindi
Native speaker

Gujarati
Conversational

Declarations

business intelligence analyst

  • Work with Business Intelligence tools such as QlikView and Tableau to develop reports and provide data to stakeholders
  • Single-handedly implemented report system on QlikView for a Retail client
  • Analyzing and implementing project-specific ETL processes Data management and visualization in a variety of formats; 
  • Business reports development by means of Tableau, Qlikview and Crystal Reports.

business intelligence analyst

  •  Generate standard or custom reports summarizing business, nancial, or economic data for review by executives, managers, clients, and other stakeholders. 
  • Document specications for business intelligence or information technology (IT) reports, dashboards, or other outputs. 
  • Maintain or update business intelligence tools, databases, dashboards, systems, or methods. 
  • Create or review technical design documentation to ensure the accurate development of reporting solutions. 
  • Worked on migration of legacy reports and dashboards from older Amdocs version to newer version 

business intelligence analyst

  • Data wrangling – daily data cleaning of assignment files loaded to the database.
  • Data analysis – inspection and modeling of data in preparation of reporting.
  • Data visualization and reporting – weekly data reports and presentations.
  • Proficiency with company’s CRM system AROTRON.

business intelligence analyst

  • Collects data to identify root cause of problem.
  • Analyzes data, thinks critically, quantitatively and qualitatively to arrive at meaningful solutions.
  • Creates metrics that provide data for process measurement and possible identification for improvement.
  • Develops project plan, portal site and handles issues related to the same.
  • Creates and monitors Kanban board.
  • Resourced and Set up projects projects in Peoplesoft and PPM.

business intelligence analyst

  • Worked closely with the CFO to gather and organize information on problems or procedures.
  • Designed and implemented a data warehouse for automation of various reports and audits.
  • Use proficiency with various coding languages to develop forms and systems to track, analyze, streamline, and automate procedures as necessary
  • Handy with tools like Domain Awareness Platform, Snaptrends, International SOS, Pro-Watch Server Alert, MS-Excel.

business intelligence analyst

  •  Included detection of Business Risks; mitigating and solving it. 
  • Preparing research content and reports for the stakeholders.
  • Environmental risk monitoring and alert services (incidents that directly impacted CITI business).
  • Emergency and Crisis Management Support Service. 
  • Market, Cyber threats impacting CITI. 
  • Emergency Response Procedure for COMMAND CENTER OPERATIONS. 
  • Did project on SHAREPOINT MANAGEMENT. 

business intelligence analyst

  • Design databases to support business applications, ensuring system availability, security, performance and reliability.
  • Worked on providing the additional matrix on Benchmarking and Accounting dashboards and integrated report pages in the web portal.
  • Built Budget v/s Actual Dashboards (Expense Reports) as part of internal reporting initiative. 
  • Performed ETL using Ascential to feed BI source table from PeopleSoft HR tables.

business intelligence analyst

  • Develop and manage BI solutions.
  • Provide reports, processes and Power BI.
  • Collaborate with business users.
  • Analyze business processes and requirements.
  • Create and maintain documentation including requirements, design and user manuals.
  • Identify opportunities to improve processes and strategies with technology solutions.
  • Identify development needs in order to improve and streamline operations.

business intelligence analyst

  •  Analyze data gathered and develop dashboards and report to the administration.
  • Analyze data and extract insights to the business
  • Respond directly to the leadership of the company, bringings status, and insights about the operation
  • Daily use of Power BI and SQL Server 

business intelligence analyst

  • Working within BI reporting team, participating in Prepaid, Products and Services & Mobile Broad Band segments reporting as well as developing and maintaining in-house software
  • Analyzing the impact of proposed products on the market
  • Collecting business requirements, then translating these into effective reports
  • Design and implement commercial dashboard to track daily KPIs
  • Work closely with business users to identify gaps in data trends to take appropriate actions

business intelligence analyst

  • Create BI Solutions to transform data to information 
  • Create projects and monitor systems to support clinical and actuarial analysts in their work.
  • Extracting Data from relational source and loading in DB.
  • Provide Analysis on the data and distinguish relevant trends and outcomes
  • Enhance processes to make reporting easier and simpler.
  • Ensure the effective planning, implementation and monitoring of relevant Business projects or data requirements.
  • Drawing up Business requirements documents (BRD’s) for sign off

business intelligence analyst

  • Worked as a Business Intelligence Analyst with the PBB Banking BI team; supported reporting and analysis requirements from various stakeholders within the organization. 
  • Gathered and analyzed requirements in order to determine reporting needs. 
  • Performed data visualization and interpretation using Qliksense, Qlikview, batch scripting, and SQL server.
  • Completed weekly root cause analysis and reports by extracting information from data sets. 
  • Effectively communicate the results and meaning of dashboards, the business process’, and any other related documentation.
  • Work alone and in collaboration with teams to build exact bi dashboards leading to statistically significant increases in work order response and completion percentages, cost savings, budget planning, and additional business functions.
  • Develop custom SQL queries and alternative methods in order to establish effective data models leading to insightful business intelligence visualizations.

business intelligence analyst

  • SCM – Experienced SAP Professional – Quotation; PO; GR; Logistics.
  • SAP HANA – RDMS – Analyze real time data to achieve KPIs and manage OLTP and OLAP data.
  • Achiever of the Month Award.
  • Collaborated on a project to set up an outsourced Revenue Cycle Management system for a leading hospital in Beirut.

business intelligence analyst

  • Global SCM Process – Experienced SAP Professional – Quotation; PO; GR; Logistics – Data Analysis.
  • SAP HANA – RDMS – Analyze real time data to monitor KPIs and manage OLTP and OLAP data.
  • Manage E-commerce activity – online bidding platform for vendor.
  • Developed VBA Macros – Integrate data – MS Access, Excel and Outlook.
  • Active engagement with stakeholders – KPI Reporting.