Sr Business Analyst Resume Bellevue, WA - Hire IT People

SUMMARY:

SQL certified BI Developer with over 15 years of professional experience in E - commerce, Customer Operations, Heavy industry, Pharmaceuticals data domains with e xtensive exposure to data analysis and database/ETL development, with a strong desire to apply the capabilities of BI tools to simplify, automate and optimize business processes to drive value for the organization.
Advanced SQL skills used in SQL Server, Teradata, MySQL, Hadoop, DB2, MS Access
Daily hands-on experience of implementing ETL using SSIS
Experience in building actionable reports and dashboards using Tableau, Power BI, SSRS, SAP Business Objects that saved millions of dollars
Hands-on experience with Big data (Hadoop and Hive).
Hands-on experience with AWS Cloud data, including ETL
Knowledge of Expedia data domain
Expertise in Developing SSAS Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
Good understanding of Software Development Life Cycle (SDLC) and good understanding of Agile & Waterfall development practices.
Customer centric professional with an ability to develop a culture of improvement with continuous learning.
Keen to learn more, dedicated, self-motivated achiever who is committed to success and adept at juggling multiple tasks in a high-pressured environment.
Exceptional Communication and Interpersonal skills.

TECHNICAL SKILLS:

Languages: SQL, C#, Python

Databases: MS SQL Server, Teradata, Hadoop, DB2, MySQL

Developer Tools: SQL Server Management Studio, Visual Studio

ETL Tools: SSIS

Analytical Tools: SSAS

BI Reporting Tools: Tableau, SSRS, Power BI, Business Objects

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Sr Business Analyst

Responsibilities:

Participated in all stages of database development/BI projects beginning from requirements gathering (including research of availability of needed data in different Expedia data domains, it’s fulness and cleanliness), logical and physical design, implementation, testing and to deployment in different systems
Built SSIS packages and scheduled jobs to migrate data from disparate sources into SQL server/Teradata/MySQL in Cloud/Hadoop and vice versa
Performed root cause analysis on failures. Resolve performance tuning related issues and queries
Implemented solutions that communicated performance metrics, illustrated key trends, and enabled complex business analytics using Tableau, Business Objects, Power BI
Created databases and schema objects including tables, indexes, stored procedures and functions as a part of the data migration initiative
Migrated existing ETL/reporting from DB2 to Teradata

Confidential

Data Analyst/ Project Manager Assistant

Responsibilities:

Data analysis (for validity, consistency, trends, compliance with different criteria). data modeling for upgrades of existing database and applications built on it (using MS Visio to draw ERDs).
Data cleansing and matching that involved duplicate values elimination, data transformation (different data types and formats).
Ad hoc reporting requests from different end users (accountants, customs brokers, project managers).
Summary reports for analysis findings using SSRS (report Builder, Report Designer, ad hoc reports, reports deploying).
Data migration (from production database to accountancy and finances, with concurrent data analysis of the XML file);
Business processes assessment for technical design specifications for programmers, technical documentation for those upgrades.
Clerical and technical assistance for project managers of the company with MS Project 2007 (distributed people and resources between tasks (scheduling), monitored and controlled the task execution and completion on daily/weekly basis using Gantt charts
Maintained data-backup and recovery for existing projects, prepared documentation for various data processes and standardization procedures, researched data and prepared reports).

Confidential

Data Analyst

Responsibilities:

Data analysis for trends in sales.
Data cleansing and matching, data backup and recovery.
Ad hoc and scheduled reports using MS Excel (pivot tables, lookup function, data matching)
Maintained MS Access databases (backup, recovery, data cleansing and matching)
Implemented an ETL processes to load forecast data from flat files (csv), Perform data validation as per business requirements and generate reports on Data Quality checks.
Actual vs Forecast Report: Created a solution using stored procedures & functions to aggregate actual transaction data and generate a combined report of comparing Actuals vs Forecast.