IT consultant with 14 plus years experience in the following areas: program/project management, business process improvement using Business Process Modeling (BPM), application support, and all aspects of the Software Development Life Cycle Strong experience in all aspects of the System Development Life Cycle with traditional Business Analysis Functions: Preparing, Presenting, and Documentation: Requirements Analysis, Business Requirements, Functional Specification, Test Plan/Scripts (UAT), Gap Analysis and Report Generation. Advance software skills include MS Office, MS Visio, MS Project, SQL, Documentum Content Management, and MOSS 2007 (Microsoft Office SharePoint Server), Salesforce.com (Veeva), SAPCRM, Informatica (Siperian)

EXPERIENCE:

Confidential
Global BMO (Business Management Office) Lead
3/12 Present

This role is responsible for managing J& J’s Global Services (GS) Delivery organization’s Commercial portfolio from a PMO perspective. The portfolio consists of roughly 600 engagements that span across all of J& J globally. The portfolio’s value is slightly over 73mm. The key deliverable of this position is to direct, train and provides support to the GS Delivery Team through the end to end Statement of Work (SOW) lifecycle process.

• Manage PMO partnership with GS Delivery teams to ensure delivery of application development and support engagements to GS business partners.
• Mentor, guide and provide understanding of the different SDLC Delivery methodologies used to deliver projects within J& J.
• Create and distribute weekly, bi-weekly, monthly and ad hoc operational review metric reports. Review these reports with GS Delivery Senior Management and Directors to ensure their visibility to the overall status of their project portfolio.
• Monitor, maintain, analyze and validate all Global Services project records as it relates to Audit (Compliance), Policies and Procedures established by the PMO office to ensure their accuracy.
• Partner with Finance team to perform financial analysis of the Commercial Portfolios. In depth analysis provided for all engagements that are over or under 5% in budget variance (according to planned vs. actual).
• Partner with Internal Audit group (Compliance) to ensure current processes are being following as per SOPS as well as conducting sessions regarding process improvement.
• Coordinate P& L reviews conduct monthly and quarterly sessions with Delivery Management staff to ensure accuracy of project billing and reporting.
• Publish dashboard reports to promote the communication of current status of Commercial portfolios to senior management.
• Developed an internal knowledge base consisting of SOPs, work instructions, work flows, and internal audit guidelines.
• Manage and enhance technology solutions being utilized by audit including data analytics software (Microsoft Excel and Access).

Confidential
Sales & Marketing Senior Data Steward/Account Manager
10/11 3/12

Strategically manage assigned data entries across the enterprise (Master Data Management Informatica- Siperian), while ensuring high levels of data quality, integrity, availability and privacy. Responsible for standardizing data naming, establishing consistent data definitions, and monitoring/auditing the data quality.

• Understand the impact of new or modified data in customer master on functional business (Sales & Marketing) areas and analyze the impact of proposed changes.
• Identify data issues and implement solutions to remedy those issues, propose and implement changes to processes and systems to meet the needs of the business.
• Coordinate and promote customer master changes with customer master Data Custodians, Customer Master Support Team and the Business Champions.
• Evaluate new data sources (WK, DDD, DEA, HIN, MHA) and provide requirements to integrate these new data sources, modify existing data sources (IMS, AMS as well as internal systems Veeva Salesforce.com and SAPCRM), and participate in data profiling and correction.
• Develop customer master implementation business requirements, business cases, impact analysis and KPIs.
• Create and maintain system and governance documentation, as well as Data Custodian work instructions and SOPs.
• Perform extensive data analysis on large volumes of data -- including creation of SQL queries.
• Assisted with the design, development and implementation of complex databases as it relates to the integration of other systems.
• Act as a liaison between business users, Business Information Account Managers (BIMs) and architects to translate business data requirements into technical requirements.
• Provided training to business personnel, technical staff and compliance on data analysis tools and best practices.
• Participate in design sessions with architects and BIMs; reviewing design documentation to ensure that the design meets business requirements.
• Developed an internal knowledge base consisting of SOPs, work instructions, work flows, and internal audit guidelines.

Confidential
Senior Business Analyst Consultant
4/11 10/11
Senior BA in the Interactive Marketing and Design division of this healthcare/technology consultancy focused on providing design and interactive solutions for the healthcare industry. Responsible for user interface requirements, data requirements, and application requirements.

• Reviews, analyzes, and evaluates business systems and user needs.
• Writes detailed specification documents, such as business requirements and data/mapping requirements.
• Develop business process flows.
• Provides oversight for system testing, support, and quality assurance.
• Facilitates business process and requirement gathering sessions.
• Contributes and adheres to standardized documentation and SOPs.
• Extensive data analysis/mapping consisting of Employee Data as well as Detailed Benefit information (medical, dental, vision, including ancillary packages) for all In-Network and Out of Network benefits.

Confidential
Business Analyst/Data Analyst Consultant
4/10 4/11

Successfully managed all planning, performing, reporting efforts, including the maintenance of a Financial Project Costing Application (using Cognos as the reporting software integrating with SQL Server Transactional Database) for all Delivery Managers/Project Managers within Global Service J& J. The application is an overall initiative to systematically monitor planned projects costs vs. actuals to ultimately determine P& L (profits & losses).

• Responsible for processing/loading monthly vendor estimates/actual, Clarity data, Billing data and GS Project SOW Pricing Models into Financial application via SharePoint.
• Effectively communicate with users as to data issues, system and data status, and financial milestone dates; as well as to the Finance group, technical support and the BMO team (Business Management Office).
• Extensive data analysis ultimately leading to creating/managing a business process for identifying errors, omissions, and inconsistencies of financial data.
• Primary liaison between Business and Systems community to define application specifications, information needs and operational requirements; as well as reporting requirements.
• Developed and conducted training sessions for financial tool.
• Created and currently managing an issue resolution process for potential errors/issues/questions/comments from the user community.
• Manage and enhance technology solutions being utilized by audit including data analytics software (Microsoft Excel and Access).
• Grant or modify user access rights to financial reports and the ability to extract data for individual analysis.

Confidential
Business Systems Analyst Consultant
11/09 3/10

• Reviews, analyzes, and evaluates business systems and user needs.
• Writes detailed specification documents, such as business requirements, functional specifications, and technical design documents.
• Documents detailed steps required to develop or modify systems.
• Provides oversight for system testing, support, and quality assurance.
• Facilitates business process and requirement gathering sessions.
• Contributes and adheres to standardized documentation and SOPs.
• Applies in depth knowledge of system capabilities and user requirements to identify opportunities for system functionality innovation.

Confidential
Senior Business Analyst Consultant
11/06 4/09

Successfully managed all migration mapping efforts for a data migration project for MMD (Merck Manufacturing Division). The MMD Document Management Shared Service (DMSS) Program is a business transformation initiative that will enable Knowledge Management, reengineer business processes such as SOP and Content Management, as well as transition MMD from its current document management environment ( Panagon) to Merck\'s DMSS (FirstDoc with a Documentum platform) a FDA GxP validated enterprise system.

• Technical Business Analyst involved in the complete lifecycle of Migrations for several applications, from gathering requirements, gap analysis, preparing the Information architecture document, mapping the source and the target data types and writing the migration plan and presenting it to the management and end users.
• Developed migration mapping (design) specifications in partnership with business subject matter experts (SME\'s).
• Facilitated cleansing activities including modifying source system metadata items to comply with mapping rules, provide "missing" metadata information to comply with mapping rules, participate in issue identification and resolution business process.
• Acted as a liaison between the Merck technical team and the Business to resolve any issues related to migrations.
• Developed and executed SQL queries against source repositories to develop a Source Data Dictionary defining attributes and values against target repository models.
• Modified source system metadata items to comply with mapping rules.
• Business Analyst involved in UAT related activities from writing the requirement specifications, test scripts and the Requirements Traceability Matrix (RTM) and managing successful completion of all UAT activities for the implementation of MOSS 2007 (Microsoft Office SharePoint Server) ‘Teamsite’ environment.
• Prepared project proposals which included project estimates and cost benefit analysis as per customer’s requirements.
• Supported business (SME) with overall document maintenance and operations of the targeted document management system.
• Extensive data analysis which included data mining to determine whether or not requirements are to be in scope or not.
• Generated various reports requested by management using raw data extracted from data warehouse; then analyzed and represented using bar graphs, pie charts, etc.

Confidential
Information Security Consultant
9/05 10/06

Security Analyst

• Manage the project security review process regarding time estimates and priority assignment for new and existing applications
• Coordinate security impact assessments for new and existing applications
• Provide security guidance during the SDLC
• Use Excel/PowerPoint to create applicable monthly metric compliance numbers for productivity of the Project Security Review process and Security Project Estimates
• Develop Security Awareness documentation
• Assist in the development of appropriate information security policies, standards, procedures, checklists, and guidelines

District Security Liaison (Hopewell site)

• Approve/deny SAP user requests for the Hopewell facility based on employee/consultant job roles and functionality
• Generate SAP tri-annual audit reports

BizRights Administrator (Application to facilitate Segregation of Duties issues for SAP Systems)

• Update/Maintains Controls
• Monitor SOD violations and conflicts across the entire SAP
• Schedule and runs data extracts from data warehouse and analysis
• Grant or modify user access rights to information and data
• Implement data exclusions and mitigating controls
• Implement Change Requests
• Develop Standard Operating Procedures for application
• Develop process flows
• Support the end user population in creating and running report outputs
• Participated in User Acceptance Testing
• Manage and enhance technology solutions being utilized by audit including data analytics software (Microsoft Excel and Access).

Confidential
Information Security Security/Business Analyst Consultant
8/04 8/05

Successfully managed all planning, performing, reporting efforts, including the maintenance of SOX related IT general Access Controls and SOPs for a Management Review Application for all consultant data Nationwide within BMS. It is overall initiative to improve security and digital identity accuracy. It enables Managers to easily review, update and confirm consultant status. Completing the review and maintaining accurate consultant information is critical to the security of BMS.

• Accomplished a 96% compliance rate from 85% of accurate consultant data. (Goal: 90% by Q4/2004)
• Identified any non-compliance issues and aid them to resolution.
• Managed the process of identifying errors, omissions, inconsistencies and potential abuses of consultant data access.
• Reengineered a complete set of User Access Management processes which aligned the recently board approved Authentication and Access Control Information Security Policy with SOX guidelines.
• Performed extensive data analysis and security reviews of Management Review Application.
• Implemented suitable vulnerability and threat management in order to safeguard the information assets.
• Developed techniques, procedures and utilities for conducting security risk assessments.
• Managed planning efforts with Directory Engineering to ensure security plans and procedures are executed correctly and on time.
• Translated and documented/mapped business requirements to system requirements for next release, containing enhancements.
• Used Excel/PowerPoint to create applicable monthly metric compliance numbers for productivity and quality of system application.

Confidential
Business/Systems Analyst Consultant
8/00 3/03,7/99 11/99,10/98 2/99

• Verified traceability of SDLC from Business Requirements through the Implementation Phase.
• Primary liaison between Business and Systems community to define application specifications, information needs and operational requirements; as well as reporting requirements.
• Translated and documented/mapped business requirements to system requirements.
• Managed project plan (development/implementation of COPD) and made sure project was delivered on time.
• Researched and evaluated alternative solutions and recommended the most effective solution for the systems design considering existing systems, available technology, the capacity and limitations of the equipment, operating time, and form of desired results.
• Managed issue resolution process for QA/QC for all Health Management Programs.
• Developed, designed, implemented and automated client reports for Account Management/Program Management.
• Ensured all Health Management Program requirements are addressed.
• Developed and maintained customized data model in BI Query to utilize for data extraction.
• Developed and managed all ad-hoc and production reporting requests using Lotus Notes.
• Developed and maintained project plan for Reporting Standardization.
• Developed and conducted training sessions for reporting tool.
• Assisted in the development/implementation of HMART (Health Management Analysis and Reporting Tool).
• Verify data warehouse source systems (Sybase) are in sync with target systems (Teradata & DB2 - mainframe).
• Created the design and implementation of a detailed systems test plan to ensure an accurate and effective product.
• Quality Assure and Quality Check raw output data generated by SQL scripts.
• Coordinated and managed issue resolution process for all system testing activities.
• Created and maintained record layout for scripts used to support the project.
• Generated and reviewed change requests initiated by the Business group with the Systems group to ensure accurate implementation of changes.
• Managed any issues and risks that exist beyond the project life cycle for possible process improvement opportunities.
• Manipulated/formatted data (data mining) generated by SQL scripts into a format that will enable the Systems Analyst to load into a Microsoft Access database for client presentation.
• Manipulated and transferred files between the PC and the CDSS UNIX System via FTP.

EDUCATION:

MS in Management Systems Analysis
BS in Marketing