SUMMARY:

• BI Developer/Engineer with a Bachelor of Science Degree in Computer Engineering. Skilled in setting up pipelines to pull data from different resources using Confidential BI tools. Develops reports and data models in Power BI, SSRS, and Excel. Capable of taking data and reports and turning them into business insight to assist with business decision making.
• Strong skill in Confidential BI tools such as SQL, SSIS, SSAS, SSRS, COSMOS, Kusto, Power BI PowerShell.
• Excellent Report Management using SharePoint, Power BI, Excel, word, PowerPoint, Visio.
• Builds data warehousing systems for business intelligence, reporting, and analytics.
• In - depth knowledge and ability to build data pipelines from, on-prem data sources, blob storages to Azure SQL database.
• Strong background in data warehousing design, tabular and multidimensional modeling.
• Detailed Functional understanding of PBI service (including gateways, OneDrive, work spaces, etc.).
• T-SQL Expert with stored procedures, user defined functions, indexes, and other SQL Server tools.
• Proficient in data modeling and visualization using Excel, Power BI, DAX and MDX query.
• Proficient in Excel Pivot table, V-Lookup, logical and nested formulas.
• Hands on experience in performance tuning and optimization using SQL server profiler and tuning advisor.
• Excellent Project Management skill.
• Prioritization skills to manage multiple projects on different schedules.
• Detail oriented, analytical thinker, curious, strives for more quality, persuasive, proactive, persistent, good communicator and good team player.

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

Business Intelligence Engineer/Power BI Engineer (Contract)

• Design, develop, and implement business intelligence solutions for the team to achieve data reporting and analysis goals.
• Working with Confidential Sales management systems.
• Determines business data reporting and analysis requirements, working with clients and business units to answer key business questions; and identifies new data requirements, analysis strategies, and reporting mechanisms.
• Collaborates effectively with and supports development teams.
• Implement new solutions, and deliver successfully against high operational standards of system availability and reliability.
• Assists in business report generation for business decision making.
• Assists in data administration, modeling, and integration activities in data warehouse systems.
• Analyzes key metrics, data findings, error reporting, and performance management control; tests solutions and resolves issues.
• Designs conceptual, logical, and physical data models and provides analytical support.
• Manipulates and mines data from database tables, such as SQL server, Odata, Kusto and Data Warehouse/Cube.
• Automate Email-sending to customer using Confidential Flow and PowerShell.

Confidential, Redmond, WA

BI Data Analyst (Contract)

• Develop professional report, visualization and dashboard in Power BI.
• Setting up pipeline to pull data from Cosmos to SQL database.
• Assemble and convert user requirements into standard reporting solution and customize specific user requests when necessary.
• Create/ Update Store procedures/views per business requirements
• Pulling daily data from COSMOS to local machine, then pushing it into the sql server via SSIS package.
• Ensure quality on deliverables (UAT)
• Develop T-SQL Script, Stored Procedures, Functions, and Views and support ad-hoc requests /reports
• Gather and analyze business requirements and translate business needs into long-term business intelligence solutions.
• Provide technical assistance to the team on various MS BI stack technologies.
• Identify and troubleshoot business process and data quality issues on new or existing reports.
• Performing daily data validation and smoke test on reports and dashboards.

Confidential, Seattle, WA

SQL Database Analyst (Contract)

• Work productively together with BI, customer-support departments, and management teams.
• Design, develop and maintain database.
• Use T-SQL to design, build, and implement stored procedures, views, jobs, functions and ETL processes for data analysis and integration using SSIS.
• Responsible for performance tuning and optimization using SQL Server profiler and tuning advisor.
• Create reports for business units on an ad-hoc basis.
• Performed Data Visualization using Tableau and Power BI.
• Work with Business Intelligent and prepared report using SSRS.
• Manage backup and recovery systems for SQL databases.
• Provide end user support, training, and troubleshooting for software applications.
• Manage and maintain relational databases to ensure usability and reliability.
• Provide technical leadership, assistance, and training to departments.

Confidential, Bellevue, WA

Software/Database Tester

• Performed BVT, Unit, Integration, System, Functional, Regression, load and performance, Alpha, Beta and Release Candidate(RC) testing on dozens of applications using both automated and manual testing methods.
• Performed Authorization and Authentication Testing.
• Performed performance tuning and optimization.
• Developed Test Plan and Test Cases to cover all the functionality.
• Develop documentation and test procedures.
• Perform product release testing, recommended process improvements.
• Participate in document and deliverable reviews, change management, and assessments.
• Works independently, leverages relationships across other departments.
• Executed both manual and automated testing using C#.
• Requirement Study, Preparing Functional Test Scripts for new requirements.
• Assembling Computers, Installing Software’s, Troubleshooting for both Hardware & Software errors.
• Provided various technical support services for the company’s software applications, including problem analysis and resolution.
• Worked closely with the developers of applications to advise concerning changes on system-levels.
• Maintained close collaboration with vendors to ensure timely support whenever necessary.
• Made effective and much appreciated suggestions for changes in the system applications, and gave expert advice as to proper operation.
• Trained end-users by means of verbal personal instruction and specially designed documentation.

Technical Support Analyst

Confidential, Bellevue, WA

• Provide campus employees and students with level-one IT help desk support. Provide resolution to issues including, but not limited to, system logins, network connectivity, application support, learning management systems support, printing, hardware, VPN access, and wireless connectivity.
• Gather information from customers to be able to convey technical concepts in work orders at the proper level to IT staff.
• Assisted level-two technicians, following established processes, with routine technical procedures
• Notify customers regarding outages, system problems, or maintenance schedules; serves as a liaison between the customer and Information Technology Services.
• Handled reservations and return of equipment. Perform basic troubleshooting of equipment brought to the help desk by students and employees.
• Assisted with user education and training.

TECHNICAL SKILLS

Operating System: Windows 10/8/7/Vista/XP

Testing tools: Selenium with C#, NUnit, TestRail and TFS

Languages: Python, C# HTML, CSS, JavaScript

Front-end Tech: HTML, CSS and JavaScript

RDBMS: SQL Server Management 2016/2014/2012/2008, MS Access

Confidential tools: MS-Word, MS-Excel, MS-Access, MS-PowerPoint, Visio

Reporting tools: PowerBI, DAX, Excel and SSRS.

Documentation tools: SharePoint, one drive and google drive.