SUMMARY:

• Capable Business Systems Analyst experienced installing and updating hardware and software systems for HRiT and drug safety users. Review and optimize systems to meet changing demands, enhance collaboration and improve security.
• Career history keeping IAM - PeopleSoft and Oracle Argus systems operational and efficient with careful attention to infrastructure and operational procedures. Excellent diagnostic abilities with advanced technical expertise. Proficient in requirement gathering and data analysis.
• Results-driven IT trainer able to handle highly stressful situations with poise. Educated in traditional and progressive techniques. Pursuing role performing and needs assessment services for customers.
• Talented Business Systems Analyst offering proven skills in analyzing and enhancing business systems at the department or enterprise-wide level. Adept at collaborating with diverse personnel involved in testing, implementing, refining and improving systems to address problems, meet current needs and propel companies forward. Top-notch researcher, presenter and diplomatic communicator with 4+ years in the field.

SKILL:

Databases: MS SQL Server, Oracle 8i/9i, Argus, ARISg Drug Safety Database

Environment: Windows 10/NT/2000/XP, UNIX, Mainframe, Oracle E-Business Suit, PeopleSoft 8.55

Automation Tools: MS Visio, Rational Rose, Rational Clear Quest, JIRA, RALLY, Rational Requisite Pro, Pivot Diagrams, Service Now.

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop, Microsoft SQL SnagIt, Snipping Tool, Beyond Compare

Reporting Tools: COGNOS, TOAD, Tableau, SQL server reports, People soft Financial, Documentum, SharePoint, Spotfire

Data warehousing tools: Informatica, Business Object

Testing /Defect Tracking Tools: Test Director, JIRA, RALLY, Quality Center, Win Runner, Load Runner

EXPERIENCE:

Business Systems Analyst

Confidential, Sunnyvale, CA

Responsibilities:

• Supported the design and implementation of applications to sustain Drug Safety objectives, including Argus Safety, MedDRA, reporting tools like COGNOS, TOAD, and Tableau, etc.
• Developed, verified custom reports and support ad hoc reporting process for drug safety business users including the case management team, safety science, vendor management teams, clinical operations, etc.
• Worked as Drug Safety SME during various onsite audits and help Operations in generating quality reports for inspection-related queries.
• Helped business partners in SAE/AE Reconciliation Process and in query resolution. Helped the case management team for appropriate query generation for clinical reports.
• Good understanding of Clinical Database data entry conventions, MedDRA coding, letter templates, narrative write-ups. Configuration expertise in the Argus Safety database.
• Responsible for the study, product, user group, and user configuration requests performed testing and managed the change control process.
• Executed test scripts for new database implementation validation projects.
• Interacted with cross-functional teams and different vendors on day to day basis to resolve the database access, configuration and other system-related issues.
• Assisted with the updating/development and review documentation for Drug Safety SOPs related to PV Safety Systems per GxP regulations and audit requirements.
• Took ownership of Biannual MedDRA version management and upgrades as required by Drug Safety Operations.
• Worked as a data manager who triages the data requests and assists the fulfillment of the data request in time and within SOP standards.
• Lead sessions for business users for new technologies and new database functionalities.

Business Systems Consultant

Confidential, SFO, CA

Responsibilities:

• Partnered with cross-functional stakeholders in HRiT to elicit, analyze, and translate information to create Business Requirement, User Requirements, and/or Technical Requirements.
• Participated and Conducted Sprint Planning, Sprint Reviews, Daily Scrum meetings, and Sprint Retrospective meetings.
• Created User stories in JIRA and walk them through during scrum calls.
• Developed new roles as per business requirements in the PeopleSoft Security model.
• Act as System Administrator who can grant Display Only, Display All, Update/Display all, Correction, Add access to a defined role for different LOB users across HRiT.
• Acted as the primary resource for Privileged Account Management, grant access to new hires in different test environments in PeopleSoft HCM, Sandbox, and CRM. Responsible for user account management for terminated or modified the access for transferred users or moved candidates.
• Monitored the access of the Pilot Group of users after the PROD implementation of newly created roles.
• A key resource to troubleshoot PS PROD Security issues, related to loss of access to PS interface, update access to tab or data tables, etc. for benefits, compensation, staff management, Talent management, Workforce Analytics, and international business users. Creates or modifies procedures to solve problems considering technology capacity and limitations, operation times, and form of desired results.
• Responsible to keep and track project documentation as per IAM SDLC audit and compliance standards. Manage the Change Request process, documents, and approval.
• Maintained and updated project documentation on the project SharePoint site. Updated and informed the project development and changes to all team members.
• Lead and facilitated security workflow sessions.
• Prepared custom reports using SQL queries, data analysis for business reporting and troubleshooting.
• Interacted with the “Users” by interviewing them, by preparing a questionnaire and getting feedback. Audited and reviewed the current security model and determined the least access provisioning to users of Confidential line of businesses.
• Educating users in HCM and CRM about the implementation of new functionality in the current security model.
• Support the intake, organization and logging/tracking of business security requests.
• Provide project support or back-fill responsibilities assigned as needed to support the broader HRiT Risk responsibilities including supporting the enterprise Identity and Access Management (IAM) initiative.
• Writing and presenting documentation about the existing application security model. Maintained and updated Dashboard to inform business users about project activities.
• Constructed test plans and cases for unit testing, Integrated Functional Testing and User Acceptance Testing. Create and review test plans, test cases, test metrics and other QA documents using the Quality Center, SharePoint, MS Excel, etc. to ensure sufficient test coverage. Execute and interpret the results of unit testing and User Acceptance Testing.
• Proactively worked with all stakeholders to support a smooth transition from testing to cutover and Go-Live.
• Work with the IT Project Manager and other stakeholders to ensure that functional and technical gaps are all address and the system is ready for deployment.

Oracle Functional Analyst

Confidential, San Jose, CA

Responsibilities:

• Involved in projects to setup Multi-Org Architecture and Multi-Org Access Control(MOAC).
• Responsible for Security Maintenance Setting User, Menus, Page permissions, Security Attributes, Defining Request groups, etc.
• Participated in troubleshooting of end user’s issues with Order to Cash or Procure to Pay Process flows including Multiple currencies in various ERP modules (GL, AP, AR, Purchasing, OM)
• Involved in the project of setting up a new model company.
• Responsible for helping end-users with setting up various accounts, inventory orgs, accounting and invoicing rules, auto invoice processes.
• Conducted end-user sessions about different Org Structures and Security setups.
• Planned and defined Use Cases, created Use Case diagrams and Activity diagrams in Enterprise Architect.
• Assisted in design review meetings making sure all the requirements are covered in the development project scope.
• Analyzed and reviewed Test Plan and Test Cases to cover overall application functionality.
• Involved in User Acceptance Testing (UAT) and verification of performance.