Business Intelligence Analyst Resume Houston, Texas - Hire IT People

SUMMARY

Master’s degree in Information systems with 6+ years of experience working as a Business Intelligence Analyst.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, Tableau Desktop Specialist, Salesforce:
Project Management Kit: Git Version Control, JIRA, Asana, Monday.com

PROFESSIONAL EXPERIENCE

Business Intelligence Analyst

Confidential, Houston, Texas

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 by 6%
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

Technology: SQL, AWS Redshift, Tableau, Excel, PythonBusiness Intelligence Analyst

Confidential, Palm Springs, FL

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

Technology: Tableau, SQL Server,MicrosoftExcel

Business Intelligence Intern,

Confidential, Gainesville, Florida

Responsibilities:

Generated campaign reports using Bar and Column charts, Combo charts, Multi Row Cards, Doughnut and Pie Charts in Power BI.
Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
Leveraged DAX functions like table, aggregation and iteration functions to answer KPIs like donations per quarter, donations sliced by attributes like donor type and campaign purpose

Technology: Tableau, SQL Server,MicrosoftExcel