Data Analyst Resume

SUMMARY:

A professional data analyst with an engineering degree and 15 years of experience in design, development, and documentation of data driven business problems. Skill set covers the complete data analysis lifecycle - from data preparation, data modeling and linking of multiple data sources using Power Query, ad hoc analysis using Power Pivot, and storytelling using dashboards and Power Point. Excellent communicator and documenter accustomed to working as part of global teams.

SKILL:

Analytics: Power BI, Power Query, Power Pivot, DAX, M, SQL

Microsoft Office: Excel, Access, PowerPoint, VBA programming, Visio

Documentation: Functional, Technical and End User documentation

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst

Responsibilities:

Expanded functionality of Scaled Agile Framework (SAFe) Program Performance and Program Predictability Reports for the Guided Personal Service (GPS) system.
Reverse engineer SQL scripts into Power Query to streamline legacy operations.
Further utilized Power Query to automate ETL processes for data capture, aggregation and reporting of Program Increments, Teams and Trains residing in multiple Excel spreadsheets.
Imported models into Power BI and created user friendly dashboards utilized by the Portfolio Delivery Managers.
The reports manage 15 Scrum Teams and 300 team members.

Confidential

Big Data Analytics (Reporting & Analytics Group)

Responsibilities:

Implemented a new process for the BEAT (Base Erosion Anti Abuse Tax) initiative to accommodate new IRS controls of inter-company losses exceeding 2% of overseas assets.
The process requires reporting of positions and trade levels of derivatives and non-derivatives data (approx. 50MM transactions per fiscal year) from RBC’s Data Lake.
Developed basic SQL views to pull Transit, Account, Business Date, P&L and Counterparty data from various sources.
Created tabular model cubes using Visual Studio 2019 with SSAS and partitions for optimization.
Utilized Excel Power Query and Power Pivot with DAX functions to build presentation grade dashboards.
Documented the daily, monthly, and yearly activities from a functional standard to handle smooth transition between project phases.

Confidential

Data Analyst

Responsibilities:

Automated the process of Statement of Work (SOW) contract generation for the company’s Legal Department.
Original process required manual cut and paste from disparate Excel, text, SharePoint and Salesforce sources to complete each SOW.
Replaced with an Excel Power BI solution which extracted and transformed the data and linked it into a relational model.
Using VBA, added a customized user-friendly Word Userform pop up screens to capture the staging data and generate the respective SOW.
Also captured Excel based course and instructor relationship lists to create hierarchy charts in Visio to be used for marketing and purposes. Wrote BRD, technical and end user docs.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship