SSIS, SSRS, SQL server database, ETL, BI
Resume:
Angela Cui
Houston, Texas *****
******.*******@*****.***
HIGHLIGHTS:
Proficient in SQL Server Business Intelligence Development Studio, SQL Server Management Studio, SAP, MS Office, Zytax5, SharePoint etc.
Intensive working experience in SQL Server Integration Services and Report Services (SSIS, SSRS), SQL query, Store Procedures, and knowledge in SQL Server Analysis Services (SSAS)
Database management expertise; ETL process developer; SAP BW super user
Proven success in data processing accuracy and before or on deadlines and prompt problem resolving; willingness to accept challenges
Independent thinker, quick learner, accountable and reliable
EXPERIENCE:
British Petroleum North America, BP Tax Technology, Houston, TX 2007 – 2017
Systems Analyst
Collected and processed over 10,000,000 transactional data with over $100 million indirect tax liabilities to hundreds of local, county, state and federal governments in US and Canada monthly and delivered the data with accuracy and before the deadline every month for ten years
Designed and developed data processing processes with SSIS packages and store procedures that extract, transform and load (ETL) transactional fuel sale/distribution data and fuel movement data from 7 major BP ERP systems and businesses in Acess, Excel or text format to Avalara tax system (Zytax 5) and Access database applications for tax reporting.
Design and developed data display SSRS reports for tax compliance and audit teams
Constant modified or changed processing processes per new business requirements or government tax law changes and consistently strived to improve data accuracy and reduce processing time
Managed data flow control to meet SOX requirements
Supported indirect tax compliance team and audit team with system or data issues or special data needs; resolved various problems and maintained data archive.
Major software utilized for data processing development are SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Microsoft Visio, Access, Excel, SAP SD and MM modules etc.
Major projects completed are:
oAutomation of processing data flow controls. The process collects total record counts and tax amounts from each step of processing processes that are used to reconcile the totals from first step to the last to be sure no data are lost at the end. This is also required by SOX. There were close to 100 packages or steps to run, to collect the totals manually from each step to spreadsheet was very tedious and time consuming. Using SSIS package to collect the totals and store the data to SQL table automatically greatly improved the control accuracy and efficiency that also made the control easy to review and sign-off by the manager. The project involved brainstorming, team meeting, documentation, flow chart, design, approval, SSIS package coding, testing, sign-off, move to production processes. This project saved 90% of the time.
oProcess simplification project. The process streamlined seven source data processes and reduced SSIS packages from close to 100 to 60 that reduced 1/3 of the processing time and made the whole data processing process a lot easier to understand and maintenance
oBuilt an new access database for Tax and GL reconciliation that saved time for compliance in their tax reporting
oCreated federal motor fuel tax SSRS reports for compliance to accelerate tax reporting
Heath Consultants, Inc., Houston, TX 2006 - 2007
Assistant Controller
Conducted cost analysis, budgeting, forecasting, general ledger adjustment, and financial analysis.
Managed Fixed Assets and Depreciation with FAS systems
Reconciled inventory and employee 401k contributions monthly
TSC Manufacturing and Supply, HOUSTON, TX 2001 - 2006
Accounting Manager / Staff Accountant
I started with the company with only my boss and me. I was responsible for all jobs in the back end office and my boss was handling all front end sales and delivery. By the end of five years, the company had 20 employees and was IPOed on Hong Kong stock market. My financial booking system and documentation systems passed IPO review
Major job done:
Generated annual budget, forecast, and actual analysis reports
Setup QuickBooks accounting system and kept the financials such as AR, AP, PR and full charge accounting, setup documentation system and filed all the documents,
Performed office management
Developed Inventory control system and coordinated international auditing
Central Michigan University, Mt. Pleasant, MI 2000 - 2001
Graduate Student Technician Online database application development
Worked with another graduate student technician, we built a new student registration system to collect student data from the school website to backend office database using ASP, Access and Dreamweaver. This system filled the blank for the university in this area.
EDUCATION AND CERTIFICATIONS:
Master of Management of Information Systems (MIS),
Central Michigan University, Mount Pleasant, MI
Bachelor of Science, Chemistry, Liao-Ning University Shenyang, Liaoning, China
SQL server training on SSIS, SSAS, SSRS programming
Project management essentials training and certification, BP
SAP BW super user training and technical writing, BP
Contact this candidate