SUMMARY

• 11+ years of experience as a Business Analyst (IT) / Scrum Master in Cisco Applications, Confidential (11i, R12), wif a verifiable track record of managing complex IT projects and exceeding expectations. Practiced in clarifying business requirements, gap analysis between goals and existing procedures, design process and system improvements to increase productivity and reduce costs.
• Business Analysis of:
• Cisco Custom Apps / Cisco Partner based applications / Cisco IAM applications - Cisco OneIdentity, Cisco PMC (Performance Metrics Central), Cisco TPV (Total Program View), Cisco Commerce (CCW - Quote to Order, Pricing), 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),
• ERP Other Modules: System Administrator (SYSADMIN), Application Developer (AOL).
• Expertise in ILM (Information Lifecycle Management), Data Governance & SOLIX EDMS (Data Archival, Data Subsetting, and Data Masking Tool; Oracle ERP Methodology: Agile Scrum methodology).
• Expertise in analyzing Business and Development Specifications, Use Cases, and Detail Design to develop requirements gathering, analyzing teh business process, conducting Feasibility studies, Document generation and conducting sessions.
• Comprehensive knowledge of teh testing lifecycle wifin teh web, client server & Mainframe environment.
• Excellent knowledge of Software Development Life Cycle (SDLC), Iterative Software Development Life Cycle Process as per Rational Unified Process (RUP) and Rational Tools used during various phases of RUP.
• Excellent skills in Business Analysis, OO Analysis, Data Analysis, Requirement Analysis, Project Portfolio Analysis, Business Modeling and Use Case Development using UML methodology.
• Proficient in customizing already existing business practices, workflows, activities and deliverables in short faced releases especially in Monthly & Quarterly.
• Skilled in SQL, PL/SQL, SQL*Plus, TOAD, SQL Assistant, Oracle Forms, Oracle Reports, PL/SQL, SQL, OAF, ILM, Discoverer, XMLP.
• Deep analysis of various Cisco IT services applications, including CITS OMSORT, CITS Act Smart Lic, CITS Enterprise Licensing Agreement (ELA), CITS PEP, CITS uCRM (Case Management EMAIL2DB->SFDC).
• Experience in integration of Revenue recognition (Cisco NGCCRM app - for revenue Processing) wif EBS.
• Excellent experience on Oracle Order to Cash (O2C) life cycle; Cisco Master Data Management (Cisco MDM - Maintain SSOT for Cisco Customer Registry.); Order Fulfillment (Standard to Drop Ship Model)
• Develop User interfaces and requirements sessions. Requirements gathering, data modeling, System Architect. Feasibility studies, Scope Documents, Requests for Proposal.
• Preparing graphical depictions of use cases including state diagrams, activity diagrams, sequence diagrams, use case diagrams, component-based diagrams, collateral diagrams, including teh business workflow.
• Conducted JAD sessions for communicating wif teh all Project directors and stakeholders.
• Hands on experience of Data manipulation, performance testing on SQL, Oracle using SQL scripts.
• Conducting sessions wif end users/clients to gather business requirements and translating teh same to teh development teams.
• Familiar wif Hadoop information architecture,data modeling and data mining and experienced wif working in Hadoop and Hive environments.
• Proficient in Data Analysis & BI Dashboard analysis for proper data representation to business.
• Providing traceability across teh project by analysis and review of project elements involved in traceability including requirements, testing artifacts, end-user support documentation and training materials.
• Extensive Documentation Skills for use in Standardization of Testing and Programming Procedures and Guidelines.
• Formulating teh Test Plans, Test Scripts and Test Cases for Functional, System, Integration, UAT, and Regression Testing based on teh Design Document and User Requirement Documents.
• Expertise in source to target mapping in Enterprise and Corporate Data Warehouse environments.
• Extensive database experience and highly skilled in SQL in Oracle.
• Has a limited experience in building website content using WebEx Social / Jive.
• Handle multiple assignments and coordinate deliverables wif key stakeholders in cross-functional groups.
• Excellent Analytical skills to understand teh business process and Functionality, Requirements and to translate them to system requirement specifications. Developing functional specifications for business process refinement and automation, data modeling, System Architecture, conducting feasibility studies, scope.
• Extensive experience in managing teams/On Shore-Off Shore Coordination/Requirement Analysis/Code reviews/Implementing Standards.
• Good understanding of Oracle Demantra. Desire to learn new technology and tools.

AREAS OF EXPERTISE

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

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Business Analyst (IT)/ Scrum Master / Data Analyst

Responsibilities:

• Business Analysis of Cisco OneIdentity App (Identity & Access Management (includes Local/Social self-registration, 2FA, User Login, Password Management) - (Scrum methodology; JIRA/Confluence; Group: Cisco EDS Team)
• Business Analysis of Cisco PMC (Performance Metrics Central - Java / OBIEE / Oracle, ETL, Hadoop environment, Rally using Scrum Methodology; Group: Cisco CS&S).
• Business Analysis of Cisco customized applications including Cisco Commerce applications (CCW P&D; Group: Cisco Commerce);
• Functional Analysis of Cisco OneIdentity (IAM) Services and responsible for creating IAM policies.
• Analysis of PMC business operation needs (BRD) and authored various functional specifications (FSD).
• Worked wif and coached a Product owner and development team.
• Impact analysis of To-Be Business process flows changes for Cisco PMC and TPV.
• Preparing very nice presentations and reports using Power Points and Tableau to halp teh management to take decision on many initiatives.
• Enhancements of different metrics calculations in Cisco PMC, especially metrics include Attach rates, Renewal rate, attach rate, Coverage rate and SR RMA ratios.
• Working wif product management team from Partner Support Service (PSS), Smart Care (SC) and Smart Net Total Care(SNTC) to get teh product collected information into PMC
• Analyzed business partner needs, authored various business documents like BRD, FSD, Use cases & Business process flows for Order Management (R12), Cisco Commerce - Pricing (CCW-PWB) and List Price Catalog.
• Expertise from End to End process in Quoting and Quote to Order Process, Cisco Pricing Process, List Price Catalog (For Products & Services, include SaaS items).
• Working wif Pricing Ops and Disti Ops stakeholders to gather teh 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 teh End-to-End Support for various Cisco partners (for all Cisco applications), to avoid issues wif product licensing / software application related issues.
• Performance Analysis of Cisco applications (Group: Cisco GIS)
• Performance and Business analysis of various Cisco Supply chain applications (wif 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 B2B, MAKE Track (Including Conc. Programs), MAKE B2B.
• Involved in writing requirements and use cases of Cisco case management applications includes uCRM (unified Customer Relationship Mgmt. (EMAIL2DB wif SFDC)), NGCCRM, Demantra (Demand & Planning analysis), PPP & PEP applications.
• Excellent data extraction skills by writing complex SQL & PL/SQL scripts in Oracle DB.
• Identify teh 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 teh existing system, preparing/reviewing teh Business & functional design documents.
• Worked wif many cross-functional teams across Cisco Teams/Stakeholders for resolving business issues.
• Involved in gathering requirements from teh user and performed Gap Analysis.
• Extensive experience using data cleansing techniques, Excel pivot tables, formulas (including VLOOKUP), and charts.
• Worked closely wif teh Team in a SCRUM approach (for monthly release projects & 3 months release projects) by handling quality assurance test cases, taking care of analyzing Cisco 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, CRs).
• Maintain PMO dashboards & Project Charter/Portals wif current documentation & Status reports.
• Conducted user interviews wif various functional groups in teh 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 teh project to senior management.
• Creating PowerPoint presentations and project updates using MS Project for management review.
• Was actively involved in writing business cases for teh client to test teh custom components developed by teh Technical teams to make sure dat all teh business needs are satisfied.
• Supported various Release Activities for multiple projects and involved in GDCP projects.
• Clearly document teh requirements, incorporating flow charts for both technical & non-technical stake holders.
• Involved in creation of performance strategy, deep dive reports and performance readout slides.
• Involved in development of few dashboards in WebEx Social for maintaining project scope and portfolio analysis.
• Responsible for creating and tracking teh defects using HP ALM (HP QC), & Rally
• Responsible for maintaining of all business documents in Cisco EDM.

Confidential, Santa Clara, CA

IT Analyst (Data) & Developer - Oracle

Responsibilities:

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

Confidential

Oracle Developer

Responsibilities:

• Customized various Reader’s Digest reports includes RDA Preliminary Payment & RDA Accrual Recon. Reports.
• Developed and customized teh various oracle interfaces using IBM Constellar V3.6.1 and V4.0.
• Developed teh PL/SQL API’s to validate teh 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.
• Performed unit testing, integrated system testing and user acceptance testing.
• Involved in Bug Fixes & Performance related issues wif various customized RD oracle reports.
• Responsible for writing teh Technical Design Documents, Migration Documents, Preparation of Test Cases.

Confidential

Oracle Developer 

Responsibilities:

• Involved in activities of RMA, Drop shipment and creation of customized Sales Order validation packages.
• Develop SQL Loader scripts to migrate teh data from teh flat files and populated teh 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 teh Return material authorization and Sales Orders in OM.
• Defined request sets as per client’s requirements.