Candidates About

 

John D. Dubravetz

Multifunctional Business Analyst that performs a variety of activities related to project management, design, development, and analysis encompassing one or more of the following areas of technical expertise: programming, computer application analysis, software development, systems integration, reporting and related disciplines.

SUMMARY OF QUALIFICATIONS 

·         Expert in business process engineering and software development life cycle, including analysis, design, development, testing and implementation of software applications.

·         Familiar with current FDA industry standards.

·         Excellent communication, analytical, interpersonal, and presentation skills; expert at managing multiple projects simultaneously.

 

TECHNICAL SKILLS AND CERTIFICATIONS

Modeling Tools:                                                MS Visio, Rational Rose

Requirement Management Tools:           RequisitePro    

Methodologies:                                     RUP, SDLC, Agile

Databases:                                           Oracle, MS Access, SQL, MicroStrategy, Tableau

GUI/Tools:                                            MS Project, Visio, SharePoint, SSRS, Word, Excel, Crystal Reports, Toad, Brio, MicroStrategy, Tableau, BIOVIA Electronic Laboratory Notebook (ELN), HP Quality Center, Application Lifecycle Management (ALM)

Industry Standards:                               FDA Regulations including cGMP and 21 CFR Part 11

Platforms:                                             Windows NT/2000/XP/7, Unix, Solaris, Sun Microsystems

Defect Tracking Tools:                         ClearCase, ClearQuest

Certifications:                                        USC Multimedia, RUP, MCSE, SQL*LIMS, CCNA

 

Education

Associate of Science, 2014

College of the Canyons, Valencia, CA

 

Amgen / TCS                                                    Thousand Oaks, CA                             July 2016 – October 2017           

Project Manager / Business Analyst

§  Managed the Instrument Data Acquisition Integration for all new instruments

§  Provided technical direction and support for the systems development and delivery of an Integrated Data Solution for a Laboratory system.

§  Liaised with business and Lab Champions during engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards for the Holistic Lab Release.

§  Worked with the business, developers, SME and Champions to implement the new BIOVIA Electronic Lab Notebook for Digital Paperless Data Management.

§  Deployed new ELN software to laptop/Tablet systems to replace paper notebooks.

 

USTS / Health Net / Pacific Management          Chatsworth, CA                                 February 2015 – April 2016                                                                                    January 2013 – December 2013                                                 

Project Manager / Business Systems Analysis

§  Managed the installation and relocation for five new projects

§  Prioritize and arranged the project plans using MS Project for the new onsite projects

§  Assisted with other project managers to prioritize existing projects through the agile methodology.

§  Worked with the operations managers to gather requirements for five new onsite projects.

§  Audit the data models and provided recommendations for the software engineering team.

§  Managed the testing strategy for the data model changes and worked with other members to facilitate the testing.

§  Worked with the DBA to make recommendations regarding performance or structural issues.

 

 

Time Warner Cable / Keshav Consulting          El Segundo, CA                                July 2014 – February 2015                                                                                    January 2013 – December 2013                                                 

Business Intelligence Analyst

§  Assisted in building detailed project schedules. Interacted with business representatives for gathering MicroStrategy and SSRS Reports / Dashboards requirements and to define business and functional specifications

§  Liaison between business users and technical team to obtain a clear insight of the underlying business process and developing functional requirement documents.

§  Identifying key matrices, parameters and formulate a strategy for building reporting solution to gauge the efficiency of the new or enhanced report through the agile methodology.

§  Analyzed and used various data sources - Oracle, SQL, Excel, and Web Services.

§  Mapped different data sources to create Business Models.

§  Configured SSRS Agents/Alerts to deliver daily/weekly/hourly reports.

§  Organized UAT testing with the Business users.

 

Sempra Energy / InSync                                  Los Angeles, CA                         January 2013 – December 2013           

Business Analyst

§  Provided technical direction and support for systems development, requirements analysis, component specifications, business and technical procedures, component and system testing, system implementation, documentation and training.        

§  Develop small applications in the SharePoint 2010 environment using SharePoint Designer and Microsoft InfoPath.

§  Tested the SSRS reporting system for the deployment of advanced reporting to management.

§  Developed small databases in SharePoint 2010 to track internal costs and equipment inventory.

§  Conducts audits on computer systems and enhancements for quality assurance.

§  Performed GAP analysis of business rules, business and system process flows, user administration, and requirements.

§  Performed planning and system life-cycle activities and recommends short-term and long-term resolutions and requirements for existing and/or new computer applications; and participate in the development and documentation of procedures related to these systems

 

Amgen / Hudson                                              Thousand Oaks, CA                           February 2012 – June 2012           

Business Analyst

§  Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards for Integrated Services Management (ISM) project                   

§  Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR). Created test cases and test scripts which were stored and managed in SharePoint and HP Quality Center

§  Performed GAP analysis of business rules, business and system process flows, user administration, and requirements.

 

Technicolor                                                      Burbank, CA                                 October 2011 – February 2012

Business Analyst                                            

§  Gathered, analyzed, and modified SSRS reports stored in TFS for the Glendale and Burbank trending system.

§  Gathered requirements for upgrades, modifications and enhancement in File Maker OASIS System and SharePoint Glendale Production System.

§  Managed and prepared business process models/case diagrams for integration of orders from various customers.

 

 

AT&T / Cognizant                                             Santa Clarita, CA                                    July 2007 – March 2011

Business Analyst / Assistant Manager                                                                                                             

§  Lead the Radio Access Network (RAN) Business Transformation Phase II Optimization/E911 functional domain by developing and documenting AT&T mobility workflow analysis, metrics and process flows.

§  Composed and presented to VP’s the RAN Organizations process flow diagrams and trends in the data to improve the Quality of Service.

§  Prepared business process models/case diagrams; using Visio which were stored in SharePoint.

§  Gathered, analyzed, and trended process metrics using process control charts for Optimization/E911 and mapped metrics to a national scorecard.

§  Worked with the IT and business clients to trend the fallout process and determine the root cause and a strategy for implementing a more efficient architecture/model.

§  Re-engineered U-Verse order fallout handling processes and Investigated fallout orders in regards to system defects, modify defects, assign to other departments, vendors, engineers and assist in the corrections of system defects.

§  Performed complaint trending, risk assessment and researched orders that flow through the system as a reject/defect. This may include review of XML, requirements, use of SQL and other tools.

§   

Amgen / Cognizant                                          Thousand Oaks, CA                           October 2005 – June 2007           

Business Analyst / Assistant Manager                                                                                                                         

§  Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards for ARISg project.

§  Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR). Created test cases and test scripts.

§  Ensured all artifacts complied with corporate SDLC Policies and guidelines, including creating procedures.

§  Performed GAP analysis of business rules, business and system process flows, user administration, and requirements.

§  Acted as a Quality representative to improve awareness, visibility, and communication on quality initiatives to ensured cGMP and compliance requirements (Title 21 CFR Part 11) were met.

§  Updated System Change Request (SCR) forms for Product Data Management (PDM).

§  Created Requirement Traceability Matrix (RTM) for test cases and functional specifications to SSRs and BPRs in excel.

§  Provide technical and procedural expertise/support for User Acceptance Testing (UAT)

 

ComputerNet Systems                                      Santa Clarita, CA                                  January 2005 – July 2005

Business System Specialist                                                                                                                            

§  Work with engineering personnel, end users/customers, vendors and contractors to develop the User Requirement Specifications, Functional Specifications, Design Specifications, System Design Concept and Operation Manuals for the new and existing control systems.

§  Compile and maintain Project documentation and Hardware Software System files including managing timelines within Microsoft Project.  Wrote SOPs for Manufacturing and Maintenance personnel and provided training on the new system operation.

 

Amgen                                                             Thousand Oaks, CA                  July 2002 – December 2004      

Business Analyst / Assistant Manager                                                                                                                         

§  Write and modify validation protocols and final reports used for the validation of various templates within the Sample Manager Thermo LabSystems database.

§  Wrote several test cases to test the template functionality and the linking of the templates currently within the Production instance during the design and development phase.  After successfully passing development testing the templates were transferred into production for validation testing and qualification.

§  Ensure that the templates correspond with the local procedures, Design, Development, and Implementation of SampleManager based on site specific Standard Operating Procedures, Specifications, and Manufacturing Procedures. 

§  Represented Corporate through the support of several remote locations, Puerto Rico, Colorado, Rhode Island, and Thousand Oaks, by providing technical expertise and training in the system rollout of SampleManager. This includes traveling, teleconferencing, and working a wide range of hours to ensure a smooth rollout.

 

 

Baxter Bioscience                                            Los Angeles, CA                       July 2001 – December 2001

Senior Analyst

§  Performed risk analysis on various projects to ensure adequate validation testing is being performed and/or to ensure the equipment is in alignment with project objectives.

§  Performed technical implementation for the SQL*LIMS 4.0 systems, consisting of 4 Windows 2000 servers, 3 Sun Solaris servers.  The system contained SQL* LIMS 4.0, Citrix and Oracle databases.

§  Managed the daily system backup, monitoring and maintenance of servers and databases, Citrix/Terminal server connectivity and database backup.

§  Managed the purchasing, staging, troubleshooting, test documenting and qualifying of 30 Citrix client Scientific Systems.

§  Wrote several Standard Operating Procedures for the installation of servers, client systems, ghosted images, server monitoring, daily backups, and UPS server shutdown and startup.

§  Researched technical solutions, designing, developing, validating, and providing system support infrastructure for laboratory instrumentation and supporting information management systems.

§  Supported several remote locations at Los Angeles, Thousand Oaks, Van Nuys, Duarte and Round Lake Illinois.

 

ComputerNet Systems                                      Santa Clarita, CA                                      June 2000 – July 2001

Business System Specialist                                                                                                                            

§  Setup and Configured network servers and personal computers with Exchange, Sun Microsystems, Cobalt Qube, Unix, Citrix, Firewalls, Routers, DSL, Cable Modems, Security Features, and Virtual Private Networks (VPN).

 

Universal Studios, Inc.                                      Studio City, CA                                  January 1998 – July 2001

IT Communications Analyst/Systems Administrator

§  Led the design, development and implementation of Aironet/Cisco wireless backbone communications, which follow the 802.11 RF 2.4 Ghz standards, three Windows NT and SQL database servers.  Migrated Merchandise C-SPEC 2MB wireless network to Aironet/Cisco 11MB wireless network. 

§  Managed the four Windows 2000 Servers running Citrix, which connected to the Maximo park production SQL database.  The Maximo application was used to track inventory of parks equipment.

§  Led the design and implementation of C-SPEC wireless backbone communications for Universal Studios Theme Park.  Researched wireless Merchandise POS, including cart locations and store inventory processes.

§  Conducted the technical planning and led the installation of Merchandise POS system, including telecommunications requirements, Digi-Rack modem set-up, and polling via OS/2 RemoteWare. The platform was comprised of four Novell 3.12 File Servers, 25 Personal NetWare Servers, and 150 IBM 4694 (486/33) Cash Registers.

§  Maintained the clients IBM AS400 terminal systems emulator connectivity for the daily updates of Merchandise products.

§  Conducted the technical planning and led the conversion of seven NetWare/Novell Servers to Windows NT 4.0 Servers.  The NetWare/Novell systems were connected on a Token Ring segment, which were also converted to an Ethernet segment.

§  Performed technical analysis for the VGS Ticketing System project, consisting of an Ethernet segment installation, 60 DOS Compaq 2000 POS terminals, and a Compaq 2500 Novell NetWare 3.12 Server.

§  Led the Installation and design of a T1 leased line (X.25 Protocol) to support VGS ticketing with an ICVERIFY credit card gateway.

Prudential Insurance                                        Woodland Hills, CA                   November 1988 – February 1997

§  One year - Claims & Member Service Coordinator: Examined and evaluate contractual payments, eligibility, and release claims in accordance with governmental regulations.  Reviewed member and provider inquiries relating to claims, eligibility and enrollment.

§  Four years - Computer Coordinator: Provided technical support to over 150 users connected to the Novell network.  Purchased and coordinated the installation of software and hardware for servers and workstation.

§  Four years - Printing Operator: Reproduced company material for the distribution to internal and external customers.  Dealt with propriety material and quality review.