Business Data Analyst Resume

SUMMARY

Data Analyst with 7 years of experience capable of using Oracle SQL, MS SQL, PL/SQL, Tableau, Microstategy, Narrowcast, Jenkins, Excel, VBA, API Calls. Ability to mine hidden gems located within large sets of structured, semi - structured and unstructured data. Devoted to improving the effectiveness of business decisions through transforming data into valuable insights. Involved in NASDAQ capital market process implementation project in Confidential . Seasoned in Agile/SCRUM processes with a focus on perfecting quality and improving product availability.

TECHNICAL SKILLS

MS SQL Server
Oracle SQL
VBA
Excel (Pivot Tables, Macros, Formulations)
Tableau
Microstartegy
PowerView
QlikSense
Experienced Agile/SCRUM
Data Scraping
Data Modeling
Quantitative Analysis
Forecasting,
SQL Queries and Reports
PL/SQL
Datawarehouse
XML
XPath
JSON
API
Business Process Modeling
Business Process Development
Project Management
Delivering Trainings
JIRA
Confluence
Jenkins

PROFESSIONAL EXPERIENCE

Business Data Analyst

Confidential

Responsibilities:

Designed ETL process dealing with different data sources and loaded data into target data sources by performing different kinds of transformations using package and procedures with PL/SQL.
Developed business processes using ORACLE PL/SQL packages, procedures, programs, jobs and schedules.
Developed file transfer processes using shell scripts and JENKINS.
Developed complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
Monitored performance and optimized SQL queries for maximum efficiency.
Created complex Triggers, Tables, Views and SQL Joins and other statements to maintain referential integrity and implement complex business logic.
Experienced in ETL processes involving migrations and in sync processes between two data sources.
Designed and developed Tableau and Microstartegy graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
Building compelling data visualizations to demonstrate data-driven insights by using Tableau and Microstartegy.
Hands on experience in business understanding, data understanding, and preparation of large databases by using Excel Pivot Tables, Macros and Formulations.
Hands-on experience in deploying/testing Web Services for API Calls (SOAP, REST) using SOAPUI.
Followed Agile methodology, participated in daily SCRUM meetings and Retrospectives, achieved each SPRINT deliverables.

Business Intelligence Specialist

Confidential

Responsibilities:

Developed categorical financial budget plans to achieve sales and profit goals using Excel (Pivot Tables, Macros and complex Formulations), BI & OLAP cube reports and reported to the C-Level.
Demand forecasting based on historical performance and recommend actions comparing with historical real performance data from OLAP Cubes.
In pre-season and in-season OTB and financial planning, replenishment, assortment, inventory forecasting and merchandise allocation for 800+ SKU's.
Formulated 10%+ Sales growth and 5%+ Inventory turnover through sales reports, markdown strategies.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship