We provide IT Staff Augmentation Services!

Business Intelligence Analyst Resume

SUMMARY

  • Have experience developing 50+ SQL queries using Amazon Redshift and SQL Server to answer key business performance, strategy questions and support ad - hoc reporting requests by understanding data at a very granular level.
  • Experienced developed dashboards in Tableau, PowerBI and Excel using Parameters, LOD expressions, Pivot Tables, Power Pivot, bar, line charts, and automated mundane tasks and created excel reports using macros which has increased productivity by 20%.
  • Gained leadership experience by juggling between multiple roles, wore multiple hats, worked many extended hours to deliver results successfully and showed great camaraderie by mentoring the new folks who joined the team.
  • Took more responsibility than expected to and showed a no-limits mindset towards the company’s long-term growth.

TECHNICAL SKILLS

Languages and Databases: SQL, AWS Redshift, PostgreSQL, SQL Server, My SQL, Data Modeling, Python (Novice)

Data Processing Toolkits: Microsoft Excel (Pivot Tables, Index & Match, VLOOKUP, VBA Macros)PowerBI (Certification), Tableau Desktop Specialist, Salesforce

Project Management Kit: Git Version Control, JIRA, Asana, Monday.com

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Analyst

Responsibilities:

  • Gained experience in gathering requirements from stakeholders, building business metrics and KPIs using SQL and preparing documents to bridge the gap while simultaneously working with business operations, settlements, sales & marketing and finance teams to timely deliver the project
  • Analyzed client terminations with vintage analysis driving up retention by6%
  • Createdanoriginationleveltableaudashboardforchieffinancialofficerwithsummarycardsshowing%of clientsanddebtenrolled, and weighted average fee % by FICO scores, state, client age, monthly payment and termlength
  • Leveraged customer financial data to analyze settlement trends and reduced active clients without a settlement >= 3 month from 45% to26%
  • Developed 50+ SQL queries using Amazon Redshift to answer key business performance and strategy questions and support ad-hoc reporting requests by understanding data at a very granularlevel
  • Design and build the automated test frameworks and test suites for use in development and testing cycles
  • You improve your team’s automation of development, testing and deployment
  • Perform manual testing, the scope of which will encompass all functionality of services to as a prequel to automation
  • Knowledge of test methodology and tools, software testing standards, methods and conventions, build systems, and the product development cycle
  • WorkeddirectlywithVPof Salesand Settlementstoanalyzeconversionratesbymarketingaffiliates,firstdraftpaymentsandoffers approved for determining agent incentives
  • Built20+interactivetableaudashboardsusingcalculatedfields,parameters,LODexpressions andquick/context/actionfilters with user level security to track enrollment and settlement activity and enhance executive decision-makingprocess
  • Collaborated with settlements department to understand their data needs and provided client information for 15+ creditors to scrub and match accounts against that led to a 12% increase in accountssettled
  • Develop dashboards in Excel using Pivot Tables, Power Pivot and bar and line charts. Automated mundane tasks and excel reports using macros which increased productivity by20%
  • Improved delivery time on complex projects by creating 10+ Excel macros using VBA
  • Used Excel functions like Index Match to look up values based off of rows and columns, SUMIFS, COUNTIFS for aggregation, modified/formatted pivot tables, sorted items and grouped data for data analysis
  • Used Python to automate reading from a SQL script and then save the results to a file.
  • Programmatically generate Excel charts/Formulas and tables using Python scripts.

Confidential

Business Intelligence Analyst

Responsibilities:

  • Performed data cleaning, merging and exporting the dataset in Tableau Prep.
  • Wrote complex SQL queries to extract data from the Sales data marts as per the requirements.
  • Performed daily data manipulation using SQL and prepared reports on weekly, monthly, and quarterly basis.
  • Since the data came from multiple sources and unstructured, made use of SQL functionalities like CTE’s, window functions, different types of joins, subqueries.
  • Developed Tableau data visualization using Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
  • Deployed graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Used python automation scripts to automatically export data to Excel after completion of SQL queries.
  • Explored Python’s Pandas library to further clean and transform the data as per requirements
  • SDET inDesign and build the automated test frameworks and test suites for use in development and testing cycles
  • You improve your team’s automation of development, testing and deployment
  • Perform manual testing, the scope of which will encompass all functionality of services to as a prequel to automation
  • Knowledge of test

Hire Now