We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

SUMMARY:

  • Over 15 years of working experience as Sr. Business Systems/Data Analyst.
  • Analyzed and developed and automated systems and applications for consistency and accuracy of data/reporting.
  • Working knowledge of cGMP concepts, practices, documentation and inventory management
  • Strong computer skills: Word, Excel, Powerpoint, Access, Project, Outlook, C, C++, SQL, VBA, Cognos, SAP R/3 6.2,

SKILL:

  • Business Warehouse, CRM, MM, WM, SD, HR & FI/CO, Visio, gRemedy, HTML, XML, Crystal Report, Oracle 10gBusiness Objects (BOBJ 3.1 and BOBI 4.0), Informatica, QlikView, Sharepoint, UNIX, Salesforce, Google Mail, Lotus Notes

WORK EXPERIENCE:

Confidential

Sr. Business Analyst

Responsibilities:

  • Lead and Manage the Onsite Services Project for Kaiser on the Job and Healthworks.
  • Recommend solutions to existing processes and develop new processes. Committed to continuous business process improvements and issues/concerns.
  • Worked in all phases of SDLC. Lead a project to rebuild existing Onsite Services process in Sharepoint in Access, VB/SQL and Business Objects.
  • Involved in Gathering Requirements, Planning, Requirement Analysis, Design, Data Conversion, Development, Integration & Testing, UAT, Implementation, Operation & Maintenance, User Training, User Experience and Technical Documentation.
  • Developed documentations such as Gap Analysis, Security Matrix, Flowcharts, Workflow, Process Flow diagrams with Swim Lanes, Business Requirement, Functional Requirement, Technical Requirement/Specifications, UAT Test Plan/Test Cases, Training Manuals and Cause/Effect Diagrams. Created Quick Reference Guide for Users.
  • Supported applications/systems Sharepoint, Access, SQL, Business Objects, VB, Access and Excel.
  • Provided support concerning metrics, reports, dashboards and KPI’s to ensure accuracy of data/reporting in VB/SQL/BOBJ.
  • Acted as Project Manager scheduling meetings and coordinating status/progress of the project. Worked with Managers, Business Process Owners and Stakeholders to follow up and give directives to meet the deadline of the project.
  • Handled and supported data modeling, data migration, data quality, data integration, data extracts, data audits, data evaluation, data entry, data builds/synthesis, data mining, data validation, data cleansing and data scrubbing.
  • Performed migration/testing across different environments (DEV/QA/PROD) and platforms.
  • Developed Use Test Cases and Test Scripts for UAT. Developed and executed test cases/scripts in UAT.
  • Trained users/clients within the department for supported applications/systems.

Confidential, San Diego, California

Sr. Systems Analyst

Responsibilities:

  • Involved in Performance Management Reporting project for KPI’s/Reports/Dashboard in Business Objects.
  • Worked in all phases of SDLC and have used methodologies/processes like Waterfall, Agile and Scrum. Involved in data migration/implementation project from Cognos to Business Objects and assigned in Gathering Requirements, User Story, Planning, Requirement Analysis, Design, ETL, Data Conversion, Development, Integration and Testing, UAT, Implementation, Operation and Maintenance, User Training, User Experience and Technical Documentation.
  • Developed tools/programs to support clients/users across all organization as per requirement.
  • Supported applications/systems like Cognos, Business Objects, SQL, SAP, BW, VB, Access, Excel and Data Warehouse.
  • Worked in ETL and build packages/cubes in SQL 2005/2008/2008 R2, SSMS, SSIS and Transformer.
  • Prepared reports, developed BEX queries and managed data warehousing in BW. Have used BW in PMR project in BOBJ.
  • Developed and wrote SQL queries, stored procedures, triggers, events and powershell in SQL Server 2008 R2.
  • Provided support/help concerning metrics, reports, business intelligence tools, dashboards and KPI’s to ensure accuracy of data/reporting.
  • Developed Universes, Queries, Dashboards using Xcelsius, WEBI, Crystal Reports in Business Objects.
  • Acted as Project Manager scheduling meetings and coordinating status/progress of the project. Worked with Sr. Managers, SME’s, Data Owners, Business Process Owners, Consultants/Contractors, Vendor and Offshore Team to follow up and give directives to meet the deadline of the project.
  • Handled and supported with data migration, data quality, data integration, data extracts, data audits, data evaluation, data entry, data builds/synthesis, data mining, data validation and data cleansing. Supported Data Warehousing.
  • Observed Project Lifecycle and performed migration/testing across different environments (DEV/QA/PROD). Have used QlikView platform for BI.
  • Prepared Use Test Cases for UAT. Developed and executed test cases/scripts in UAT.
  • Coordinate with Business Leads and internal customers in continuous business process improvements and issues/concerns. Involved in I.T. projects/initiatives. Attended weekly meeting to identify/rectify issues/concerns.
  • Developed documentations like Security Matrix, Process Flow diagrams with Swim Lanes, Flowcharts, Workflow Training Manuals, Functional Requirement, Technical Requirement/Specifications, UAT Test Plan/Test Cases and Cause/Effect Diagrams. Developed Quick Reference Guide for Users.
  • Involved in SDLC and Project and Portfolio Management using SAP for I.T. Projects.
  • Trained users/clients within the company in I.T. supported applications/systems.
  • Received requests or ticket and solve/troubleshoot problems. Worked with the business to support/help in their requirement.

Confidential, California

Business Systems Analyst

Responsibilities:

  • Imported tables to Access from SAP and EDW/Oracle to design and develop programs/tools/GUI in Access for the Data Operations group. Build master cubes of all production tables every week and send notification of update.
  • Gathered/processed data in Access/Excel and creating macros in Excel and writing SQL queries/VB code in Access.
  • Received requests and produced reports depending on specs from different groups pertaining to Material Master, Bill of Material/Recipe and Business Rules/Processes/Audit Rules/Class A Data.
  • Developed/generated metrics for Class A, Pareto charts and publish report every week in Livelink and BW to all Business Process Management, Business Process Owners, Data Content Owners and Data Stewards.
  • Extracted Material Master tables and Bill of Material/Recipe tables from SAP MM.
  • Supported MDM, data quality, data integration, data governance, data analysis, data extracts, data audits, data evaluation, data entry, data builds/synthesis, data mining, data validation, data cleansing and master data in SAP Material Master, Bill of Material/Recipe, monthly reports and ad - hoc reports.
  • Built Master Cube and generated Daily Audit and Ad hoc Audit requests. Supported Data Ops Group/Supply Chain.
  • Managed and supported the Data operations group and give directives to meet the deadline of the project. Worked and supported Directors, Sr. Managers, Managers and Supervisors in Reporting and Analytics.
  • Managed and supported with SAP/R3 functions in MM, Recipe Modules.
  • Assisted in LSMW to load Materials in SAP/R3. Added, modified and did mass changes to existing materials.
  • Managed complex queries, reports and modules. Handled all requests concerning reporting for Clinical/Commercial, Supply Chain, Finance, Quality, Procurement and Logistics in SAP, BW, Access, VB, Excel, Oracle 10g, EDW and SQL.
  • Involved in projects and published weekly Class A Metrics for Business Process Owners and Data Content Owners.
  • Used Google docs, spreadsheets, maps, search, Gmail. Familiar with Google, Youtube and Android.
  • Supported internal customers concerning business processes/requirements/rules/IMP’s, Material Master, Bill of Material/Recipe and all issues concerning SAP R/3, Access and Excel. Worked and involved in various projects.
  • Analyzed, designed, developed and automated systems/processes in Access/VB/Excel/SQL for SAP Material Master/Recipes. Debugged existing programs in Access/Visual Basic/SQL. Created GUI/Interface and trained for users.
  • Used Trackwise for Enterprise Quality Management for Functional Area Supplier Management and Manufacturing. Supported in Quality processes in Incident, Auditing, Complaint Handling and Change Control in Trackwise.
  • Involved in automation project and prepared use test cases for UAT. Developed and executed test cases/script in UAT.
  • Ensured that data/reports adhered to all business rules/processes and submit for gRemedy ticket for the business owner to make the necessary changes consistent to the business rules. Gathered functional and technical requirements.
  • Committed to continuous improvement of quality, processes, system, analysis, data, reports, design, specs, changes and user support. Documented business processes.

Confidential, San Ramon, California

Sr. Data/Business/Project Analyst

Responsibilities:

  • Worked comprehensively on SAP Order to Cash (OTC), Plan to Report (PTR) and Supply Chain Execution (SCE).
  • Managed and supported with Master Data in SAP/R3 functions in CRM, Customer Master, Material Master, Vendor Master, Recipe, WM, SD, HR and FI/CO Modules. Data conversion of all modules like Customer Master, Material Master, Finance for GL Balances, Accounts Payable, Accounts Receivable and and Vendor Master.
  • Supported MDM, data extracts, data audits, data evaluation, data entry, data builds/synthesis, data mining, data validation, data cleansing and master data in SAP Material Master, Bill of Material/Recipe, monthly reports and ad-hoc reports. Supported Data Warehousing.
  • Generated complex queries/infocube, ODS Objects, ETL, BW Reporting variables, navigational attributes, calculated and restricted key figures in BW for users. Designed, developed, maintained and scheduled/published queries/reports in BW.
  • Managed with data extracts, data audits, data evaluation, data entry, data builds/synthesis, data mining, data validation and master data in SAP Material Master, Bill of Material, Customer Master, Vendor Master, GL Master, Bank Master, Asset Master, Profit Center, Cost Center and Primary Cost Element.
  • Worked comprehensively on BEx Analyzer, Report Writer, Query Designer, Web Application Designer and Administrator Workbench. Designed and implemented BEx, Web Reports and Templates in BW.
  • Worked with Accenture and offshore team in Chevron Philippines to coordinate and to follow up and give directives to meet the deliverables.
  • Involved in CPDEP/SDLC and Project and Portfolio Management using SAP for I.T. Projects.
  • Developed SAP BW cubes/queries for different groups to support accurate reporting.
  • Generated complex queries/infocube, ODS Objects, ETL, BW Reporting variables, navigational attributes, calculated and restricted key figures in BW for users. Designed, developed, maintained and scheduled/published queries/reports in BW.
  • Trained users on how to use BW, queries and report writing. Developed and maintained BW queries and workbooks.
  • Developed ad-hoc queries/reports, static reports, dynamic queries and statistical analysis. Handled large volume of data.
  • Gathered data/information from different sources and convert/transform them into reports/analytical results.
  • Analyzed, designed, developed and maintained GL Balances and Material Master program in Access/SQL.
  • Gathered/processed data in Access/Excel and creating macros in Excel and writing SQL queries/VB code in Access.
  • Validated data integrity/accuracy and used data manipulation, data cleaning and data mining.
  • Managed complex spreadsheets, charts and comparison/analysis reports. Generated queries, modules and reports.
  • Gathered data/information from different sources and convert/transform them into reports/analytical results.
  • Assisted and helped in using Trackwise for Complaint Handling and Change Control.
  • Committed to continuous improvement of quality, processes, system, analysis, data, reports, design, specs, changes and user support / training.

Confidential, Los Angeles, California

I.T./Design Engineer (Project)

Responsibilities:

  • Analyzed, designed, developed and maintained programs in Access/SQL.
  • Gathered/processed data in Access/Excel and creating macros in Excel and writing SQL queries/VB code in Access.
  • Managed complex spreadsheets, charts and analysis reports. Generated/produced queries, modules and reports.
  • Validated data integrity/accuracy and used data manipulation, data cleansing and data mining.

Confidential

Sr. Business/Project Analyst

Responsibilities:

  • Worked comprehensively on SAP Order to Cash (OTC), Plan to Report (PTR) and Supply Chain Execution (SCE).
  • Managed and supported with Master Data in SAP/R3 functions in CRM, Customer Master, Vendor Master, SD and FI/CO Modules. Supported Data Warehousing.
  • Handled and supported with MDM, data extracts, data audits, data mining, data validation, data cleansing data evaluation, data entry, data builds/synthesis and master data in SAP. Generated monthly reports and ad-hoc reports.
  • Generated complex queries/infocube, ODS Objects, ETL, BW Reporting variables, navigational attributes, calculated and restricted key figures in BW for users. Designed, developed, maintained and scheduled/published queries/reports in BW.
  • Worked comprehensively on BEx Analyzer, Report Writer, Query Designer, Web Application Designer and Administrator Workbench. Designed and implemented BEx, Web Reports and Templates in BW.
  • Developed SAP BW cubes/queries for different groups to support accurate reporting.
  • Developed ad-hoc queries/reports, static reports, dynamic queries and statistical analysis. Handled large volume of data.
  • Trained users on how to use BW, queries and report writing. Developed and maintained BW queries and workbooks.
  • Managed data extracts, data audits, data evaluation, data builds/synthesis and master data in SAP Material Master, BOM, SD, Customer Master, Vendor Master, GL Master, Bank Master, Asset Master, Profit Center and Cost Center.
  • Gathered data/information from different sources and convert/transform them into reports/analytical results.
  • Managed complex spreadsheets, charts and analysis reports. Developed numerous queries/reports based on specs.
  • Analyzed, designed, developed and maintained programs in Access/SQL.
  • Processed data in Access/Excel and creating macros in Excel and writing SQL queries/VB code in Access.
  • Involved in all project planning and forecasting using MS Project. Gathered functional and technical requirements.
  • Analyzed and developed and automated systems and applications for consistency and accuracy of data/reporting.
  • Committed to continuous improvement of quality, processes, system, analysis, data, reports, design, specs, changes and user support / training.

Confidential

Business Analyst

Responsibilities:

  • Worked comprehensively on BEx Analyzer, Report Writer, Query Designer, Web App. Designer and Admin. Workbench.
  • Developed ad-hoc queries/reports, static reports, dynamic queries and statistical analysis. Handled large volume of data.
  • Generated complex queries/ infocube, ODS Objects, ETL, BW Reporting variables, navigational attributes, calculated and restricted key figures in BW. Designed and implemented BEx, Web Reports and Templates in BW.
  • Designed, developed, maintained workbooks and scheduled/published queries/reports in BW.
  • Developed SAP BW cubes/queries for different groups to support accurate reporting.
  • Analyzed and developed and automated systems and applications for consistency and accuracy of data/reporting.
  • Gathered data/information from different sources and convert/transform them into reports/analytical results.
  • Analyzed, designed, developed and maintained programs in Access/SQL. Developed numerous queries/reports.
  • Managed complex spreadsheets, charts and analysis reports. Generated/produced queries, modules and reports.
  • Validated data integrity/accuracy and used data manipulation, data cleaning and data mining.
  • Processed data in Access/Excel and creating macros in Excel and writing SQL queries/VB code in Access.

Confidential

Sr. Business/Data Analyst

Responsibilities:

  • Worked comprehensively on SAP Order to Cash (OTC), Plan to Report (PTR) and Supply Chain Execution (SCE).
  • Managed and supported with Master Data in SAP/R3 functions in CRM, Customer Master, SD and MM Modules.
  • Handled and supported MDM, data extracts, data audits, data evaluation, data entry, data builds/synthesis and master data in SAP. Generated monthly reports and ad-hoc reports.
  • Designed, developed, maintained workbooks and scheduled/published queries/reports in BW.
  • Helped users on how to use BW, query and report writing. Developed numerous queries/reports based on specs.
  • Worked comprehensively on BEx Analyzer, Report Writer, Query Designer, Web App. Designer and Admin. Workbench.
  • Generated complex queries/infocube, ODS Objects, ETL, Reporting variables, navigational attributes, calculated and restricted key figures. Designed and implemented BEx, Web Reports and Templates in BW.
  • Developed SAP BW cubes/queries for different groups to support accurate reporting.
  • Developed ad-hoc queries/reports, static reports, dynamic queries and statistical analysis. Handled large volume of data.
  • Gathered data/information from different sources and convert/transform them into reports/analytical results.
  • Involved in all project planning and forecasting using MS Project.
  • Analyzed and developed and automated systems and applications for consistency and accuracy of data/reporting.
  • Managed complex spreadsheets, charts and analysis reports. Generated/produced queries, modules and reports.
  • Analyzed, designed, developed and maintained programs in Access/SQL. Developed numerous queries/reports.
  • Validated data integrity/accuracy and used data manipulation, data cleaning and data mining.
  • Processed data in Access/Excel and creating macros in Excel and writing SQL queries/VB code in Access.

Confidential

Business/Data Analyst - Finance

Responsibilities:

  • Analyzed, designed, developed and maintained programs in Access/SQL. Handled large volume of data.
  • Gathered/processed data in Access/Excel and creating macros in Excel and writing numerous SQL queries.
  • Processed data in Access/Excel and creating macros in Excel and writing SQL queries/VB code in Access.
  • Managed complex spreadsheets, charts and analysis reports. Generated/produced queries, modules and reports.
  • Validated data integrity/accuracy and used data manipulation, data cleaning and data mining.
  • Gathered data/information from different sources and convert/transform them into reports/analytical results.
  • Monitored/managed inventory and determine material for replenishment, obsolete items and handled reimbursements.
  • Committed to continuous improvement of quality, processes, system, analysis, data, reports, design, specs, changes and user support / training.

Confidential

Responsibilities:

  • Scheduled and administered written tests and computer typing tests of clients.
  • Managed collection of data, inputting, printing and dissemination to the appropriate Federal/Provincial/Local or Third Party Providers. Produced weekly, monthly and quarterly statistical reports.
  • Perform any other duties necessary to facilitate the day-to-day operation of the center and its programs in a manner consistent with the center's philosophy and operating guides in an efficient and effective manner.
  • Entered clients information/records. Arranged files and records, maintained bulletin boards and display racks.
  • Entered and produced correspondence, proposals, contracts, work schedules, reports, agendas and minutes of the meetings using MS Word, Excel, Powerpoint and Access.

Confidential

Sr. Business/Data/Project Analyst

Responsibilities:

  • Analyzed, designed, developed and maintained programs in Access/SQL. Handled large volume of data.
  • Gathered data/information from different sources and convert/transform them into reports/analytical results.
  • Validated data integrity/accuracy and used data manipulation, data cleaning and data mining.
  • Managed complex spreadsheets, charts and analysis reports. Generated/produced queries, modules and reports.
  • Analyzed and developed and automated systems and applications for consistency and accuracy of data/reporting.
  • Processed data in Access/Excel and creating macros in Excel and writing SQL queries/VB code in Access.
  • Gathered/processed data in Access/Excel and creating macros in Excel and writing numerous SQL queries.
  • Monitored/managed inventory and determine material for replenishment and obsolete items.
  • Involved in all project planning and forecasting using MS Project.
  • Committed to continuous improvement of quality, processes, system, analysis, data, reports, design, specs, changes and user support / training.

Confidential

Business/Data/Project Analyst

Responsibilities:

  • Analyzed, designed, developed and maintained programs in Access/SQL. Handled large volume of data.
  • Gathered data/information from different sources and convert/transform them into reports/analytical results.
  • Managed complex spreadsheets, charts and analysis reports. Generated/produced queries, modules and reports.
  • Gathered/processed data in Access/Excel and creating macros in Excel and writing numerous SQL queries.
  • Processed data in Access/Excel and creating macros in Excel and writing SQL queries/VB code in Access.
  • Validated data integrity/accuracy and used data manipulation, data cleaning and data mining.
  • Monitored/managed inventory and determine material for replenishment and obsolete items.
  • Analyzed and developed and automated systems and applications for consistency and accuracy of data/reporting.
  • Involved in all project planning and forecasting using MS Project.
  • Committed to continuous improvement of quality, processes, system, analysis, data, reports, design, specs, changes and user support / training.

Confidential

Legislative Executive Assistant

Responsibilities:

  • Produced correspondence using MS Word and handled incoming and outgoing mails.
  • Prepared all schedules of privilege speeches, committee meetings and appointments.
  • Arranged filing system and kept all important/confidential documents.
  • Analyzed, designed, developed and maintained programs in Access and Foxpro.
  • Prepared MS Powerpoint presentations to be used in meetings. Produced reports using MS Excel.

Hire Now