Data Engineer Resume
Sunnyvale, CA
SUMMARY:
- Sr. Business Analyst / BI Analyst / Data Engineer with over 20 years of Systems analysis, Design and Project Management in varying applications; in fields such as banking/finance,, healthcare, telecommunications, manufacturing, financial, chemical and engineering industries.
- Strong communications skills; able to understand technical and non - technical problems and translate those into solutions.
- Developed and executed a new architecture plan for report delivery.
- Extensive experience in Business Intelligence; backend, data delivery and reporting.
TECHNICAL SKILLS:
Oracle, MS: SQL Server, Tableau, SAP/Businessobjects Enterprise, (CMC, WEBI, Xcelsius), Informatica, Microstrategy, ErWin, SAS, Omniture, C, C++, FORTRAN
HP: UX, Sun/Solaris, Sun OS, Windows, DEC VAX, Confidential OS/VMS,VM/CMS, NeXT.
PROFESSIONAL EXPERIENCE:
Confidential, Sunnyvale, CA
Data Engineer
Responsibilities:
- Responsible for leading the design, development and deployment of data reporting solutions for AppleCare Service .
- Developed a backend environment to update and support the necessary data for a number of dashboards.
- Used Tableau dashboards to visualize the progression of students through curricula. Published extracts and dashboards to Tableau server for consumption.
- The purpose of the dashboards is to monitor progress of students. The dashboards are also used by stakeholders to validate completion of mandatory and s by technicians.
Confidential, El Segundo, CA
Sr. BI Solution Analyst
Responsibilities:
- Working with business stakeholders in all areas of BI, from requirements analysis, data discovery, presentation and identification of new opportunities within their data.
- Collaborated with IT and created documentation for designers and developers
- Worked with IT/Big Data team to review new data requirements and availability of same.
- Helped prepared visualizations for business stakeholders to understand and help clarify issues
Confidential, Honolulu, HI
Sr. Business Analyst
Responsibilities:
- Responsible for eliciting, gathering and documenting requirements for a new Data Infrastructure project for the Confidential and Support Division to include Intake, Storage, Analysis and Reporting.
- Conducted requirement gathering sessions interviewing all constituents; teachers, support personnel, analysts and directors.
- Assisted in the area of project management, by compiling project manager’s data and reporting status, schedules and financial data including budget, actual, forecast and reforecast.
- Developed proof of concept dashboards utilizing Tableau.
Confidential, San Francisco, CA
Business System Analyst
Responsibilities:
- Involved on a Phase 2 implementation of system developed to automate reports that run across the organization (at different time zones).
- Specifically working on the self-service module that assists departments in running their own reports. SAP/BO WEBI
Confidential, Campbell, CA
Sr. Consultant
Responsibilities:
- Technical responsibility for delivery of a new SAP/Xcelsius dashboard for the KPIT/AIM group.
- The dashboard, a replacement of a manual effort delivered in Excel that gathered data from many sources, including systems of record, legacy systems, Excel and manual data.
- The project involved all facets of the BI development cycle, data discovery, ETL, Semantic Layer and dashboard development and delivery. Coordinated development of portions of the project with off shore team. Delivered on time.
- Analysis and support BI Integration of new ODS and system of record. Gap analysis and testing.
- Installed latest SAP/BOE 4.1SP2 as part of the upgrade. Modified a number of universes to include legacy and new data of record.
- SAP/BO Administration; upgrade DEV/TEST and PROD environments to latest version. Implemented SSO.
- Delivered BI Solutions to a number of clients. Comprising the full cycle from analysis to deliverables. Involved in the requirement gathering process, data discovery and gap analysis.
- Utilized SAP Business Objects suite with particular focus on presentation.(Xcelsius ~ Dashboards)
Confidential, San Jose, CA
Business Analyst
Responsibilities:
- Assisted in analyzing business requirements for a new implementation of a Data Warehouse and BI Reporting system.
- Conducted and participated in JAD sessions, developed and was responsible for sign-off of the business requirement documents.
- Working closely with Business Analyst to finalizing design, interaction of Xcelsius Dashboard with respect to end user experience for Analytics Metrics.
- Design, Development/Modifying of existing Universe and creating the new BO canned reports.
- Identified and documented metrics, KPI/dashboards, reports and "what-if" scenarios.
- Analyzed existing reports and prepared samples on new platform.
- Developed ‘proof of concept' for a program within the department of Adult Protective Services.
- “In-Home Supportive Services (IHSS) program is a federal, state, and locally funded program designed to provide assistance to those eligible aged, blind, and disabled individuals who, without this care, would be unable to remain safely in their own homes.”
- The 'proof of concept' helped IHSS program immediately by identifying inaccuracies that penalized the program and it's clients.
Confidential, San Francisco, CA
Business Analyst
Responsibilities:
- Serving three regions world-wide, with over 4000 consumers of weekly custom flash dashboards.
- Member of the dashboards team developed using the Agile methodology, having new releases on a weekly basis. These releases included major and minor changes, for example introduction of new metrics; business logic overhaul; new ETL features and UI changes.
- Responsibilities included liaison between technical team and business stake holders, user acceptance testing, problem identification, recommendations of possible solutions, documenting and tracking issues.
