Sr. IT Data Engineer Resume San Mateo - Hire IT People

SUMMARY

Experienced Data Analyst in Fortune 500 companies ( Confidential, Confidential ).
Tackled complex integration problems with major impact on our operations and bottom line.
Passionate about performing data analysis and visualization in order to better understand the problems, in a rich and objective way, and to communicate improvements to upper management.
Experience in Project Management, Business Analysis, Business Modeling, and Data Modeling
Strong skills in Microsoft Excel (vlookup, Essbase, What - If Analysis, Pivot Table and Macros)
Completed project 4 months ahead of schedule and on budget
Award winning employee

TECHNICAL SKILLS

Applications: Tableau, SAP, Quickbooks, Peachtree, Crystal Reports, Excel, Word, OneNote, SharePoint Workspace, MS Project, MAS

Database: Oracle, Access, Sybase, PL/SQL, Stored Procedure, PowerDesigner, Erwin, ER Diagram

Language: SQL, Python, R, C++, html

PROFESSIONAL EXPERIENCE

Sr. IT Data Engineer

Confidential, San Mateo

Responsibilities:

Analyzed tickets, outage and financials data to gain insight in order to improve company process and automate across multiple projects
Created automated standardized reports using SQL and Excel from multiple database that provided live data and ease of accessibility
Modified database using SQL select, update, insert and delete
Optimized database performance by troubleshooting and uncovering the root cause of issues
Migrated 300,000 tickets and 1.3 million rows of data successfully into a new ticketing system and launched it in 2 days to enhance workflow
Created data visualization dashboard with Python to facilitate communication across multiple departments, generate conclusions and recommendations
Reviewed incidents with Incident Team to identify issues and to gather data for improvement

Data Analyst

Confidential, Mountain View

Responsibilities:

Analyzed data, using logic and reason, to identify systems improvements, and drive projects to increase productivity in operational functions
Compiled and converted sales data and into to ensure readability and quality data structures for the analysis of data
Developed and prepared project documentation, improve processes, maintain track reports to communicate details of project

Financial Analyst

Confidential, Alameda

Responsibilities:

Extracted data, prepared key presentations and recommendations for sales using Crystal Reports to Excel from over 130,00 tables
Analyzed account purchasing data using Excel and compared variance for over 600,000 invoices and 1,500 products to identify growth opportunities.
Built out novel reports and migrated rebuilt legacy reports into new centralized reporting portal to meet reporting needs company-wide.

Business Reporting Analyst

Confidential, San Jose

Responsibilities:

Maintained, handled and updated purchase orders and invoicing ensuring that orders are filled correctly and on time
Supported daily shipment logistics and follow-up with customers to meet the fulfillment of order
Resolved daily customer relationship issues to enhance partnership development
Provided prompt reporting of accounts and remittance information to clients to provide up-to-date information on order status

Financial Analyst

Confidential

Responsibilities:

Managed project of scanning backup documents electronically for additional security measures of various accounts
Conducted month-end financial reviews for cost variance analysis of approximately 20 cost centers within Risk Management department in 5 different countries in Asia for transparency
Compiled monthly headcount reports for approximately 200 staff to assist with workforce planning
Assessed monthly cost development against prior run-rates and cost targets, and investigated cost issues to keep within budget using Crystal Reports
Participated in bottom-up budget processes and identified potentials for cost savings