SUMMARY:

• Quality focused professional with 11+ years of experience in the IT industry as a Business Systems Analyst, Scrum Master and Application developer.
• Development of Business Requirements (BRD), User interfaces and requirements sessions, requirements gathering, Feasibility matrix and functional Documents (FSD).
• Business Analysis of
• Confidential Applications including Confidential OneIdentity, Confidential PMC (Performance Metrics Central), Confidential TPV (Total Program View), Confidential Commerce (CCW - Quote to Order, Pricing & Discounting), List Price Catalog GUI, Pricing Workbench GUI, eGenie (Item/Master details information SSOT).
• Oracle Supply Chain Management (SCM) modules: Purchasing (PO), Inventory (INV); Order Management (OM), Oracle Shipping (WSH) module, Advanced Pricing (QP)
• Oracle Financial: Accounts Receivables (AR), TCA ; Accounts Payables (AP) ; General Ledger (GL)
• Oracle CRM Modules: Service Contracts (OKS), Install Base (CSI);
• Oracle other Modules: SYSADMIN, Application Developer (AOL).
• ILM (Information Lifecycle Management), Data Governance & Confidential EDMS (Data Archival, Data Sub setting, and Data Masking Tool)
• Data Analysis of:
• Partner performance (PMC), Ariba catalog discount analysis (Discount id / Certification & Price List)
• Performance Analysis of:
• OMSORT, Act Smart Lic, Enterprise Licensing Agreement (ELA), PEP, uCRM (EMAIL2DB with SFDC)
• Experience in integration of Revenue recognition ( Confidential NGCCRM) with EBS.
• Excellent knowledge on Oracle Order to Cash (O2C) life cycle; Confidential Master Data Management ( Confidential MDM).
• Proficient in Data Analysis, generation of reports (OBIEE /Tableau), documentation skills.
• Extensive experience in working with Joint Application Development(JAD) sessions to understand the requirement, analyze the requirement, design the ETL Mappings/Workflows as per the requirement
• Formulating the Test Plans, creation of test scripts, functional test cases and UAT cases based on the Design Documents and User Requirement Documents.

COMPETENCIES:

• Out of the box thinking: Innovative beyond existing practices and mindsets.
• A leader and Scrum Master: Actively seeks leadership roles.
• Project/generate enthusiasm: Can easily identify topics which are currently critical.
• Ability to communicate effectively to clarify complex and sensitive information.
• Multi-tasking, organizational talent; time-management and can work independently without supervision.
• Experience in managing teams/On Site-Off Shore Coordination and implementing standards.

TECHNICAL SKILLS:

Expert knowledge of All MS Office applications (Word, Excel, Outlook, Project, Access, PowerPoint, Visio Professional), UNIX, ILM, Confidential EDMS, Oracle ERP, Oracle, SQL, PL/SQL, SSH, TOAD, SQL Assistant, Oracle Forms, Oracle Reports, SOAP UI, Advanced REST, OAF, Discoverer, XMLP, Hadoop, Hive, OBIEE, EDW, ETL/Informatica, Teradata, Tableau

AREAS OF EXPERTISE:

• Business Liaison to IT SDLC Software Development Cross Functional Project Delivery Business Workflow
• Business & Functional requirement documentation IT Strategy Process workflow analysis
• Use Cases analysis Performance Analysis Data Analysis User Experience (UX) Jive
• Scrum Master SDLC & Agile / Scrum Methodologies User Acceptance Testing (UAT)
• IAM Oracle Applications (ERP) Business Analysis JIRA/Rally

PROFESSIONAL EXPERIENCE:

Business Analyst (IT) / Scrum Master

Confidential, Milpitas, CA

Responsibilities:

• Business Analysis of Confidential OneIdentity (IAM Services)
• Business Analysis of Confidential PMC (Sales & Service Performance Metrics Central - Java / OBIEE / Oracle, ETL, Hadoop environment, Rally using Scrum Methodology
• Business Analysis of Confidential customized applications including Confidential Commerce applications
• Functional Analysis of Confidential OneIdentity (IAM) Services and responsible for creating IAM policies.
• Analysis of PMC business operation needs (BRD) and authored various functional specifications (FSD).
• Worked with and coached a Product owner and development team.
• Impact analysis of To-Be Business process flows changes for Confidential PMC and TPV.
• Preparing very nice presentations and reports using Power Points and Tableau to help the management to take decision on many initiatives.
• Responsible for the ETL workflows impact Analysis due to new business enhancements or change requests.
• Coordinate and implement enhancements to Confidential PMC Sales and Service metrics calculations.
• Working with product management team from Partner Support Service (PSS), Smart Care (SC) and Smart Net Total Care(SNTC) to get the product collected information into PMC
• Analyzed business partner needs, authored various business documents like BRD, FSD, Use cases & Business process flows for OM (R12), Confidential Commerce - Pricing (CCW-PWB) and List Price Catalog.
• Data analysis in Ariba catalog discount issues, EDMS channel program discounts, Disti discount issues and 1Tier partner base discounts.
• Expertise from End to End process in Quoting and Quote to Order Process, Confidential Pricing Process, List Price Catalog (For Products & Services, include SaaS items).
• Working with Pricing Ops and Disti Ops stakeholders to gather the business requirements and responsible for creating detailed solution design (FSD).
• Involved in technical architecture design and strategy in various oracle financial & SCM modules.
• Involved in key roles during implementation of project roll-out, all phases of project SDLC and also supported post go live activities.
• Performed various item factor setups in eGenie include Base price factor, Item Factor & Uplift Factor etc.
• Provided the End-to-End Support for various Confidential partners (for all Confidential applications), to avoid issues with product licensing / software application related issues.

Business Analyst / Performance Analyst

Confidential, Milpitas, CA

Responsibilities:

• Business systems analysis of various Confidential Supply chain applications (with partners like Fox Conn, Celestica etc.)
• Oracle ERP (CG1 SC LSS End to End) - Supply Chain includes Order Management (OM), Oracle Transportation Management (OTM) (Include COB Domain, RIQ Domain, 3B2, 3B3 Messages), Deliver Track; Deliver Confidential, MAKE Track (Including Conc. Programs), MAKE Confidential .
• Involved in writing requirements and use cases of Confidential case management applications includes uCRM (unified Customer Relationship Mgmt. (EMAIL2DB with SFDC)), NGCCRM, Demantra (Demand & Planning analysis), PPP & PEP applications.
• Excellent data extraction skills by writing complex SQL & PL/SQL scripts in Oracle DB.
• Identify the business impact applications due to application DB Migration (SJ->RCDN), Init. Parameter Changes, Plan Changes due to DB Upgrade (10g to 11g) and also involved in root cause analysis.
• Business analysis of various GBP applications, including CITS OMSORT, CITS Act Smart Lic, CITS Enterprise Licensing Agreement (ELA), CITS PEP (Partner Registration), CITS uCRM etc .
• Understanding the existing system, preparing/reviewing the Business & functional design documents.
• Worked with many cross-functional teams across Confidential Teams/Stakeholders for resolving business issues.
• Involved in gathering requirements from the user and performed Gap Analysis.
• Excellent experience in testing (including performance testing of CCW Web Services) of web services using SOAP UI and REST web services using advanced REST client.
• Extensive experience using data cleansing techniques, Excel pivot tables, formulas, and charts.
• Worked closely with the Team in a SCRUM approach (for monthly release projects & 3 months release projects) by handling quality assurance test cases, taking care of analyzing Confidential Applications and documentation etc.
• Expertise in Change Management, Issue/Risk Management and Quality Management. Resolved issues reported by customers on various aspects of products (Enhancements, Defects, Change Requests).
• Maintain PMO dashboards & Project Charter/Portals with current documentation & Status reports.
• Conducted user interviews with various functional groups in the Organization.
• Use Case Modeling using Rational Unified Process (RUP) for preparing Business & Functional Requirements.
• Involved in System integration testing (SIT) and user acceptance testing (UAT).
• Giving project sizing’s for various releases of the project to senior management.
• Creating PowerPoint presentations and project updates using MS Project for management review.
• Was actively involved in writing business cases for the client to test the custom components developed by the Technical teams to make sure that all the business needs are satisfied.
• Supported various Release Activities for multiple projects and involved in GDCP projects.
• Clearly document the requirements, incorporating flow charts for both technical & non-technical stake holders.
• Involved in creation of performance strategy, deep dive reports and performance read out slides.
• Involved in development of few dashboards in Confidential WebEx Social for maintaining project scope and status.
• Responsible for creating and tracking the defects using HP ALM (HP QC), & Rally
• Responsible for maintaining of all business documents in Confidential EDM.

Business Analyst / Data Analyst

Confidential, Santa Clara, CA

Responsibilities:

• Involved in system study, analyze the requirements by meeting the client and designing the complete system.
• Interacting with all the stakeholders to understand and the existing business process and gather business requirements.
• Responsible for implementation of Confidential EDMS tool on the Oracle Applications package.
• Involved in various Oracle Application modules data archiving by using Confidential EDMS tool.
• Analyzing Software Requirement Specification, Design documents as per Rational Unified Process.
• Performance tuning of customized complex queries, in Confidential MERGE schema, by tracing the related JOBS.
• Oracle Applications 11i System Administrator activities - creation of Responsibilities and Data Groups for New Archival & MERGE schemas.
• Creating & defining the relationships ( Confidential MINIME) among the tables to purge the data in a proper manner.
• Responsible for creation of various reports to publish the data after archival process and also fine-tuned various OBIEE Performance issues with SQL’s.
• Performing Critical path analysis and analyzing ER diagrams.
• Developed the various PL/SQL packages/procedures as part of Customized modules data archiving.
• Responsible for validating the archived data using Confidential ARCHIVE responsibility after ERP data archival and also responsible for writing Technical design/requirement Documents.
• Fine tuning of various Oracle & customized reports with the help of explain plan, TKPROF, hints & indexes.
• Created and customised necessary PL/SQL triggers to validate data before starting the archival process
• Responsible for writing the Technical Design Documents, Preparation of data reports.
• Development of various customized flows and data validations of Oracle CRM modules include Service Contracts, Install Base before archival process
• Performed unit testing, integrated system testing and user acceptance testing.

Developer - Oracle ERP

Confidential

Responsibilities:

• Customized various Reader’s Digest reports includes RDA Preliminary Payment & RDA Accrual Recon. Reports.
• Developed and customized the various oracle interfaces using IBM Constellar V3.6.1 and V4.0.
• Developed the PL/SQL API’s to validate the required data before doing extraction and interfacing to ERP.
• Developed Shell scripts for submit various Oracle Standard Requests like Journal Import through DM Constellar.
• Involved in IBM Constellar Up gradation project and developed various PL/SQL Triggers, Dynamic Procedures.
• Developed Cash Management Conversion PL/SQL script, to insert data into Transaction Codes Table.
• Involved in Creation & cloning of Value Sets, Registration of Concurrent Program Names and Executables into one instance to another using FNDLOAD functionality.
• Modified standard reports RAXINV, POXPRPOP for mapping with proper tags also modified Outbound and Inbound process for Ship orders and Purchase orders.
• Tuned the cursor scripts to increase the overall performance of the API.
• Involved in Bug Fixes & Performance related issues with various customized RD oracle reports.
• Responsible for writing the Technical Design Documents, Migration Documents, Preparation of Test Cases.

Developer - Oracle

Confidential

Responsibilities:

• Involved in activities of RMA, Drop shipment and creation of customized Sales Order validation packages using PL/SQL.
• Develop SQL Loader scripts to migrate the data from the flat files and populated the staging tables.
• Develop PL/SQL packages to validate mapping and loading of legacy data from staging Tables into interface tables. Design, coding and testing various reports for the Return material authorization and Sales Orders in OM.
• Defined request sets as per client’s requirements.
• Customization of various reports (6i/10g). Development of PL/SQL objects (includes VIEWS, PROCEDURES, PACKAGES, and FUNCTIONS). This is a full maintenance of oracle applications 11i financials and Manufacturing modules like General Ledger, Purchasing, Order Management, and Inventory which involved understanding of business processes and solve problems according to client requirements.
• Created various customized forms (6i/10g) & necessary tables and required PL/SQL functions, to validate data.
• Generated custom reports using Reports6i and deployed various gif files into the menu like Oracle Apps Menu.
• Creation of PL/SQL stored procedures and triggers to support front-end applications such as forms6i and reports.
• Implementing the Form 10g WEBUTIL functionality to export the Forms data to Excel sheet in the .CSV format.