SUMMARY:

Experienced Analyst with a demonstrated history of working in the Information Technology industry. Skilled in Microsoft Power BI, Databases, Advanced Excel, Project Management, Data Manipulation/ Data Cleansing / Analysis, and SQL. Strong business development professional with a Bachelor’s Degree focused in Information Technology, Software Engineering.

SKILLS:

Databases: SQL Server Management Studio, Relational Databases

BI Tools: Excel, Tableau, Power BI, DAX, Power Pivot, and Power Query

Programming: Python (Pandas)

Other Tools/Skills: Project Management, SAP Data Services, Data Analysis, ArcGIS, AWS - Redshift, Azure Machine Learning Studio, Crystal Reports

WORK EXPERIENCE:

Confidential

Sr. Consultant

Responsibilities:

• Work with key stakeholders for business requirement gathering
• Tailor and Create DAX measures in Power BI
• Build and Develop core data model with Power BI for accurate reporting
• Develop Power BI reports and dashboards that include Executive Dashboards, KPI Scorecards, and additional reports
• Conduct Webinars and Lunch & Learns on various topic pertaining to Power BI and Python
• Create Azure Everyday Videos
• Consult with various BI related Projects - Power BI, SQL, Azure, Tabular Models, Adobe Analytics

Data Analyst, BI Consulting

Confidential, Kirkland, WA

Responsibilities:

• Built custom Azure Startup reports/dashboards in Power BI
• Ad-hoc data analysis via SQL
• Consulted with various BI related Projects - Power BI, SQL, Azure, Tabular Models, Adobe Analytics

SQL Analyst, Data & Web Development

Confidential, Tacoma, WA

Responsibilities:

• Wrote SQL code to wrangle data from Lawson/Infor HR & Finance/Budget datasets for reporting in Excel and Power BI
• Wrote DAX to create new measures/custom column within Power BI
• Developed Power BI reports and dashboards that include Executive Dashboards, KPI Scorecards, and additional reports
• Met with various members within school district to understand their unique situation, ask questions to get to the root of their problems, and explore solutions that help transform their business need
• Worked with Business System Analysts and HR Leadership team members to translate business requirements into data models for visualization deployment

Business Intelligence (BI) Data Analyst

Confidential, Bellevue, WA

Responsibilities:

• Built custom Sales Pipeline reports/dashboards in Power BI
• Ad-hoc data analysis
• Deep dive root cause analysis
• Handled unstructured data from a variety of Microsoft-internal tools
• Maintained and created SQL code and stored procedures

Business Intelligence (BI) Engineer

Confidential, Seattle, WA

Responsibilities:

• Provided BI support of ETL jobs, incoming tickets, including extensive troubleshooting tasks, with responsibilities covering multiple product lines
• Provided analytical support and collecting data from different data sources
• Owned the design, development, and maintenance of ongoing metrics, reports, analysis, dashboards, etc. to drive key business decisions (Power BI and Excel)
• Deep dives and Ad hoc requests into Prime Student data via established data warehouse (Datanet)
• Identified and recommended potential data sources; compiles/mines data from a variety sources and maintains data quality and cleanliness

Campaign Data Manager

Confidential, Seattle, WA

Responsibilities:

• Independently executed the entire campaign process, from instruction receipt to file production
• Interfaced directly with client teams, addressed and managed client requests and communicate status - in person, via phone and email
• Customized and optimized the entire campaign management process, to include new campaign requirements, development test, production execution and quality control
• Processed ad hoc data import and data export requests
• Identified and resolved issues in client instructions prior to execution
• Created complete queries or scripts to verify completeness and accuracy of file output

Data Analyst

Confidential, Seattle, WA

Responsibilities:

• Designed and created simple to complex SQL queries
• Debugged and reviewed stored procedures and recommend changes
• Import and export of data, bulk insert of data, Excel file data, and Flat file sources and load into various tables for analysis and processing
• Generated reports, chart and graphs using Excel and SQL Server reporting services (SSRS)
• Supported multiple marketing programs by gathering and analyzing data, generating reports, and communicating findings

Data Analyst

Confidential, Seattle, WA

Responsibilities:

• Monitored data transmission and proper operation of sensors on meteorological (met) towers used for preliminary wind energy studies around the world
• Validated met tower data for, and prepare periodic summary reports for use by clients and other groups in the company
• Created, implemented, and maintained current SharePoint website for my team
• Troubleshot any erroneous data found in large datasets
• Fulfilled client data requests as needed
• Used MS Access to link SQL servers and create, maintain, and develop queries
• Provided timely communications to clients and team members regarding problems with equipment and for routine reporting
• Interacted professionally with clients through email, phone and in person
• Shared and continuously develop knowledge and best practices
• Created and updated technical manuals for new and existing company procedures for in-house Data Quality Filtering and Processing

Data Analyst

Confidential, Chicago, IL

Responsibilities:

• Analyzed incoming data from meteorological towers and report on findings per relevant standards and company practices
• Utilized ArcGIS to obtain basic knowledge of the mapping tool
• Created Excel charts of weekly wind speed data for wind farm projects
• Participated in User Acceptance Testing
• Researched and troubleshot data issues using spreadsheets and databases
• Provisioned of telemetry modems for meteorological towers
• Acted as an active SharePoint Administrator for the Wind Assessment Group