Sql Server Data Analyst

Ruowei (winnie) Huang

Jericho NY *****

Tel: 718-***-****

Email: ******@*****.***

EDUCATION New York University, NY

B.S., Computer Science

SKILLS Software: Microsoft Office, My SQL, SQL Server, Domo, Dashboard, Macromedia Flash MX, Dreamweaver MX

Operating systems: Unix, Windows

Programming languages: SQL, FrontPage, HTML, Java

CERTIFICATION CompTIA A+ Certification professional – operating system

Cognos 8 BI Report Authoring Part 1& 2

Cognos 8 BI Metadata Modeling Part 1 & 2

EXPERIENCE

6/2013-Present Modivcare Corp, NY

Data Analyst

Working with various teams within the organization to maximize productivity and optimize operations. Present data from all groups to executives to gauge business operation health and productivity. Gather data, track system performance, and provide analysis to recommend necessary changes

Technical tasks including:

Write queries in SSMS / My SQL and performing ad-hoc analysis

Created Packages using Execute SQL Task, Data Flow Task and automate the import and export of data in SSIS ETL tool

Developed SSIS packages to transfer data across heterogeneous data sources (Excel, Flat File), Import data from SQL into excel to generate reports

Established a connection between Excel and SQL Server to automate data population throughout Excel

Developed and automated data bridge between HHAeXchange and ADP

Created MS Access database with ODBC connection to data warehouse

Implemented and optimized stored procedures in SQL server, performed SQL query tuning, and developed test scripts for store procedure validation

Implemented stored procedures using SQL server, involved in writing SQL-stored procedures for database transactions and performed SQL query tune up, developed test scripts to test stored procedures

Led Domo implication and development initiatives

Environments: Windows, HHAeXchange, HHAeXchange AWS, SQL Server, Microsoft Suite

5/2004-5/2013 Time Warner Cable, NY

Technical Analyst

Worked with teams across the organization to understand their analytics need and produce dashboards and analytics solutions that allow them to execute more efficiently. Work with business executives to define key metrics and build reporting to monitor performance along those metrics. Reconciled discrepancies in reports by validating data, support and analytics, resolving end-to-end data quality issues that impact business

Technical tasks including:

Created and generated regionalized ad-hoc reports, PivotTables, macro, excel functions, charts, models and queries for all regions using Cognos ReportNet, excel, Access, Visio, Word and Power Point

PeopleSoft reporting-General ledger, query reporting and creation, Account Payable reporting, OPEX reporting, P&L reporting, analysis of financial data

Enter PRs, track and review POs for different accounts from PeopleSoft

Support Business Operations and Capital Management teams to ensure the overall efficiency of reporting across business units.

Aggregated data from all Network Operations and Engineering group and generate finance and engineering reports for senior management

Communicated and presented departmental financial results and findings to company upper management and various departments

Created and analyzed daily, weekly and monthly reports on productivity, service calls, repeat calls, and equipment using Cognos ReportNet and Score Card PMT applications

Utilized the Manpower Access database and synchronized the data with WorkAssure(Arris) and PeopleSoft

Monitored, analyzed and performed quality controls on operational data and assigned projects

Prepared Business Requirements documents (BRDs), defined project plans and wrote system requirements specifications

Optimized and maintained existing reports, database and queries using Cogons and Access

Utilized the CSG billing system to analyze data as a quality control

DSAM server administrator, DSAM meter quality control

Coordinated with field managers running diagnostic test on customer equipment

Performed diagnostics using various measurement tools (CMIT, NSM, OMSE, Stargus, Set top Diagnostics )

Troubleshooting of problems with customer equipment

Provided knowledge of all analog and digital information, policies, and procedures

Environments: Windows, SQL, Cognos, Microsoft Suite, CMIT, NSM, CSG, ARRIS, INR, OMSE, Stargus, Set top Diagnostics, Score Card PMT, Big Brother, PeopleSoft

8/2001-4/2004 Hotelsroom.com, NY

Web Desinger

Translated user’s need into technical specification

Developed website using Macromedia Flash MX, Dreamweaver MX, Photoshop and HTML

Created user’s manual for applications being implemented onto the live site

Installed and updated software; upgraded existing computers

Created documents and presentations using Microsoft Office

Environments: Windows, Microsoft Suite, Macromedia Flash MX, Dreamweaver MX, HTML

Contact this candidate