We provide IT Staff Augmentation Services!

Business System Analyst Resume

San Rafeal, CA

TECHNICAL SKILLS:

Software/Databases: Windows, MS Office 2003 - 2016, Office 356, Excel (PowerPivot),MS Access, Crystal Reports, MS Project, Pro Visio, Tableau, RMA Tool, Remedy, Cognos, SharePoint, BI Tools, Asset Management Tool, PeoplePulse, Teradata SQL Assistant, SQL Server, Hive, Looker, SQL Workbench

Programming: VBA, XML, SQL, Hadoop, SQL Plus, Oracle, SAP, Business Objects Webi, DB2, VWS (Web based reporting system), HTML, CMS, Joomla, SSRS

Communication: Skype, WebEx Meeting, WebEx Connect, GotoMeeting, Slack, Zoom

PROFESSIONAL EXPERIENCE:

Confidential, San Rafeal CA

Business System Analyst

Responsibilities:

  • Working with the ISM-BMs team on automating business processes.
  • Created automated system (Access) for routine process that utilized Excel files which increased productivity and accuracy by 90%
  • Created integrated product evaluation system using Access, Excel, and Hadoop to handle the following procedure
  • Validate product pricing
  • Create upload file to cloud base system of new, changed, and cancel products
  • Validate several language translations based on the country
  • Consulted with other departments on implementing a similar validation system within their department
  • Interacting with other departments on automating reports and procedures using advance VBA and SQL
  • Providing data analyzes through Hive to department members for validation
  • Create data mapping on new system, securing productivity of data flow
  • Developed data flow, process flow, user cases, and ER Diagrams
  • Participated in user acceptance testing

Programming Environment: VBA, SQL, Hadoop, MS Access, Excel, PowerPoint, SharePoint 365, Excel, Professional Visio, Hive, Cloud base server (Pelican), Slack, Looker, SQL Workbench, HUE

Confidential, Oakland CA

Database Consultant

Responsibilities:

  • Working with the Confidential Finance on a mortgage integration and conversion from an old system to a new system.
  • Translating VBA code in MS Access database to new code which was imported into a new SQL system.
  • Working closely with analysts in translating SQL code used in the development of major upper level reports
  • Involved in the testing, pre-production, and deployment of the new system
  • Created VBA code and complex formulas in developing Excel applications and financial data models

Programming Environment: VBA, MS Access, SQL, Excel, PowerPoint, SharePoint, DW, Teradata SQL Assistant, SQL Server Management Studio, SSRS, SSIS

Confidential, Pleasanton CA

Database Consultant

Responsibilities:

  • Work with the Supply Chain department on the decentralization of system databases in three departments (Floral, Meat, and Produce)
  • Develop project plan which identify key issues and problems, along with timeline and network deployment to district centers
  • Assessed project impact on workforce
  • Upgraded all the systems from 2003 to 2013
  • Created data mapping document
  • Coded and upgraded the databases and Excel reports

Programming Environment: VBA, Excel, Access, PowerPoint, DB2, QFM, DW, Teradata SQL Assistant, SSRS

Confidential, San Francisco, CA

Consultant

Responsibilities:

  • Worked in the Consultant Service division as the developer
  • Project was the development of an interim Access database system for processing company wide performance review survey to be used in yearly employee evaluations and promotions. The system also handles a survey by team members regarding the working environment of the team
  • Created code for importing daily data collected from SharePoint
  • Designed and developed data validation and control processes which decrease user error by 90%
  • Worked closely with team members offshore and coastal on making modification and updates to the system, travel coastal 30% and remote 70%
  • Collaborating with the team using Google apps
  • Developed ERD, data mapping, and work flow diagrams for interim system to be turnover to USI team

Programming Environment: Access, Excel, PowerPivot, VBA, SharePoint, Tableau

Confidential, Pleasanton, CA

Project Lead Sr. Developer Client Server

Responsibilities:

  • Worked with the Project Management Office/Business Management Office (PMO/BMO) division as lead Developer, also responsible for two other developers
  • Work on major modification to normalize department Access system and increase system performance by 40% using SQL and VBA
  • Developed data map, ERD, technical requirements for current and new systems
  • Created department databases which consist of translating business requirements to technical requirements, ERD, data mapping, and work flow diagrams, and prototype to a Go Live database
  • Created GUI objects for the MS Access front-end
  • Designed and developed monthly dashboards (KPIs), and report cards for deliver to upper management and other divisions using Access, Crystal Reports, and Excel
  • Developed complex ad-hoc Access reports for different portfolios (Revenue Cycle, ICD-10, and R&Q)
  • Coded Clarity, SAP, and other data storage to create reports for analytical review
  • Worked directly with IT Department in managing the team’s virtual environment and security levels (through coding)
  • Worked closely with IT support to resolve system and network situations
  • Responsible for the migration of department database systems to a Windows file server
  • Set Metadata and security for report migration to SharePoint
  • Lead developer in the development and implementation of a migration to a SQL server
  • Created table structure with indexing for move to SQL server 2008
  • Liaison between department technical team and company IT working on setting up IP addresses and DNS names for team

Programming Environment: Access, Excel, PowerPivot, IB Tools, VBA, SQL, Crystal Reports, SharePoint, AIMS, SAP, SAS, SSRS, Remedy, Clarity PPM, Professional Visio, Tableau

Confidential, San Ramon, CA

Access/Excel Developer

Responsibilities:

  • As the Developer built an Access database system for the Marketing department to be used for the company’s major employee survey to work with Excel.
  • Developed an Excel-automation project generating PowerPoint slides directly from Excel worksheets
  • The Excel automation process greatly reduced the time and expense needed to deliver results.

Programming Environment: Excel, Macro, VBA, PowerPoint, PeoplePulse

Confidential, San Francisco, CA

Access Developer

Responsibilities:

  • Built a new hiring database for temporary workers
  • Translation of business rules in to technical requirements
  • Created an automated reports through Access to be used by upper management
  • Handled data consolidation from Excel to Access
  • Programming Environment: Access, Excel (Pivot tables, Macros), VBA, SQL, SQL Server 2008
Confidential, San Ramon, CA

Reporting Consultant

Responsibilities:

  • Wrote system requirements for reporting system in the Centers Technologies & Tools department.
  • Identified and evaluating key redesign issues needed to be addressed
  • Designed and created the reporting system using Access
  • Created Excel/VBA automation tools for a variety of User Directed Tasks
  • Managed data analysis and reporting needs for upper management
  • Developed technical solutions and timelines for upper level reports
  • Retrieved data from various SharePoint sites to use in metrics
  • Work with IT on various level of security

Programming Environment: Access 2007, Excel, VBA, Crystal Reports, Enterprise Guide 4, SharePoint, PowerPoint Presentation, Oracle, SAS

Confidential, CA

System Analyst

Responsibilities:

  • Worked within the Asset Management team (ITAM), creating and Excel application to streamline electronic data discovery (EDD) printing. Standard EDD procedures generate a PDF document to capture workbook content
  • Created code to suppressed blank pages, while ensuring that all content was accurately captured, converted into PDF format, and archived
  • Reduced in cost related to paying by page count by 40%
  • Provided monthly matrixes on unassigned assets to upper management
  • Maintained and updated server applications through Asset Management tool (AIMS)
  • Researched and analyzed asset using Business Object and other asset tools
  • Automated daily and weekly reporting procedures using Excel, Access, and Crystal Reports
  • Worked on monthly reconciliation of server usage by departments and divisions.
  • Involved in the decommission of servers
  • Designed and coded the monthly dashboard and scorecard for deliver to upper management

Programming Environment: Access, Excel (Pivot tables, macros), VBA, SQL, Crystal Reports, SharePoint, Asset Management Tools, Business Objects, Remedy, Cognos, SAP

Confidential, San Francisco, CA

System Analyst

Responsibilities:

  • As the System Analyst using analysis to create the detailed specifications necessary to develop, upgrade or modify existing small to medium-sized department’s Access database system
  • Automated the daily, weekly, and monthly reporting database systems making it more efficient and accessible for Project Managers
  • Provided high level reports to the electric team using Crystal Reports
  • Developed complex Excel macro for large volume of data pulled from SAP
  • Provided high level reports to the electric team
  • Created Excel based Dashboard which displayed metrics detailing company revenue
  • Developed complex Excel macro for large volume of data pulled from SAP and SAS
  • Led development of Excel based, VBA tool to replace manual forms for field service technicians.

Programming Environment: Excel, VBA, SQL, Access, Crystal Reports, SAP, SAS, SharePoint

Confidential, San Jose, CA

System Analyst

Responsibilities:

  • Worked with Network Level services (NLS) and Smart Care services
  • Responsible for the modification of the Access database used as the main analysis tool for daily processing.
  • Performed retrieval and analysis on data from CNCs (Cisco Network Collector) to research discovered and undiscovered network devices using available data analysis tools in a data warehouse environment
  • Worked closely with IT and Global Theatres (US, Asia Pac, Australia, Emerging Markets, European Market) in resolving network discrepancies effecting new and renewal Smart Care contracts.
  • Data scrubbing of data to providing increase efficiency and decreasing redundancy.
  • Assisted in identifying data discrepancies problems and preparing testing environments
  • Handled the Smart Care MACD daily process to develop reports used to make changes to the IB system through portable solution files.
  • Worked on integrating the Web based tool (VWS)l into the SmartCare (Access) validation system through programming modifications to increase accuracy and streamline the process. ‘

Programming Environment: Access, Excel, VBA, Crystal Reports, SQL, Oracle, Toad, Remedy 7, RMA Tool, Visio, Sonar, and CSCC, Data Modeling, Smart Care Batch Tool, Wiki, WebEx Meeting, Connect, Sametime

Hire Now