KHUSHABU RANI

Sr. BUSINESS ANALYST

Email: adpoum@r.postjobfree.com

Phone: +1-414-***-****

PROFESSIONAL SUMMARY:

●Over 6+ years of Professional Experience as Business Analyst in Media and solid experience working in the field of Retail industry Business Process Management applications along with the experience in change management and Business Process Mapping with also solid understanding of Requirement Management, Data Modelling and Application Design.

●Extensive experience in Retail industry Projects acting as a liaison between IT leads and Project Manager and coming up with the strategic solution to help uplift the organization.

●In-depth knowledge of television Broadcast Management Systems (BMS) and scheduling process.

●In-depth knowledge of advertising workflow in television broadcast media ecosystem.

●Strong knowledge of Agile PLM, scrum processes and experience in redesign of product development process as per the business requirement and designed workflows and allocated permissions within SharePoint.

●After completing stories into JIRA, conducting review sessions with Offshore and onshore tech teams, QA team, BU and project managers and answering their open questions.

●Experience in Managing Wide Orbit Program content across channels and platforms from production and acquisition through rights, scheduling and transmission.

●Expertise in Software Development Life cycle (SDLC), Project Life cycle, Business Process Modeling (BPM), Software Development Methodologies including Waterfall, and Agile with SCRUM process.

●Expertise in both Sql and Oracle to process user’s request with a set of programming lines and application program.

●Extensively used SQL queries using query Analyzer for data analytics, data mapping, verification and validation. Conducted User Acceptance Testing (UAT), managed Test Plans and Test Cases using Rational Quality Manager.

●Possessed effective content creation and broadcast media research capabilities.

●Consolidating the information gathered into Business Process Models using Business Process Mapping tools.

●Expertise in database management through H Look-up, V Look-up, Pivot Tables, Graph charts in MS Excel.

●Experience in B2B, B2C and Ecommerce portals web application developments.

●Highly proficient in working with users to gather requirements, analyze them and subsequently use the Rational project and design tools to model the requirements.

●Experienced in a role demonstrating excellent time management, Mediapulse order management and able to analyze workload and prioritize time based on changing priorities.

●In-depth knowledge of creating use cases, functional design specifications, activity diagrams, logical, component and deployment views to extract business process flow, X12 transactions.

●Extensively used rational tools for UML, tracking and reporting and applied the Rational Unified Process in all areas of a software development life cycle.

●Extensive experience working with vendor e-commerce tools like Microsoft commerce as well as helping construct and integrate in-house ecommerce applications.

●Performed UAT and exposure to User Certification Testing (UCT) and Operational Readiness Testing (ORT)

●Expertise in understanding and supporting the client with Project Planning, Project Definition, Requirements Definition, Analysis, Design, Testing, System documentation and user training.

●Used Rational ClearQuest for tracking and prioritizing defects and for enhancements after baselining the requirements.

●Used Rational ClearCase for Version Control of requirement documents and well versed in writing queries/Scripts for Data Analysis and QA reporting and testing.

●Experience in Change Management Process (Identify, Analyze, Evaluate, Plan, Implement, Review and Close).

●Excellent skills in Project and Performance Management to support Strategic Planning, Goal Setting, Strengthen Accountability, Enhance Decision Making, and Improve Customer Service.

●Highly motivated team player with excellent communication, presentation and interpersonal skills, always willing to work in a challenging and cross-platform environment.

SKILLS:

Languages : VB.Net, JavaScript, VB Script, XML, SQL, PL/SQL, UNIX, ASP.NET.

Database & Server : SQL Server, Access, ADO NET, Microsoft IIS.

Software Modeling : UML, Rational Unified Process, Rational Rose.

Versioning Software : Clear Case, Visual Source Safe (VSS), Perforce, Subversion.

Modeling Tools : HTML, Adobe Analytics, and Google Analytics.

Methodologies : Oracle Hyperion, RUP, SDLC, Waterfall, Scrum, Six Sigma, CMMI, ITIL.

Other Skills : Gathering & Management, Application design, development and testing, Database Design, ETL.

Configuration Tools : Rational ClearCase LT, Visual SourceSafe (VSS), Rational RequisitePro.

E-Commerce Package : DemandWare, Sterling- DOM, WebSphere Commerce, ERP-OMS/VISTA

WORK EXPERIENCE:

Barnes and Nobles, New York, NY Jan 20 – Present

Sr. Business Analyst

Barnes and Nobles is the largest bookstore retail chain with a strong supply chain network in the US. Worked as Business Analyst on their e-commerce Point of Sale (POS) application of Retailing Business accessed through their website. The online bookstore enabled potential customers to execute: simple Searches (using Title, Author, etc.), and Advanced Searches (using Title, Author (Last & First names), ISBN, etc.) helping them decide on the books they would like to buy online. Once the customer's account was created/verified (for an existing customer using ID and Password), the customer entered the Credit Card information, which was then processed securely, followed by confirmation of the placed order. The application facilitated the users to browse for different categories of books like 'Bestsellers', 'Kids', etc. along with providing information for latest events and happenings in the publishing world.

Responsibilities:

●Conducted user interviews, gathered requirements, analyzed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.

●Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.

●Performed data mapping, logical data modeling, created class diagrams, and used SQL queries to filter data.

●Worked on ERwin Data modeling tool to create the Claim center and Policy subject areas and reverse engineered the existing products to perform the Data mapping process.

●Worked with end users to design business requirements of a Business CRM System and manage B2B processes of distribution across the region.

●Analyzed the system for the effectiveness of the E- commerce operations

●Designed and influenced future state concept of operations through the development of business process models and data flow diagrams

●Utilized Data tables, Created logical Source to target mappings, Document Process and Data flow diagrams

●Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational Requisite Pro.

●Performed in depth Gap Analysis to analyze/compare the as-Is and To-Be compatibility of existing system infrastructure with the new business requirements.

●Used Business Process Models context, data flow, Entity Relationship Diagrams ER-Diagrams as precursors to re-engineering, functionality enhancements, migration to new technology and value-addition of existing business solutions.

●Communicated the bugs, testing status and testing issues with project manager, QA team, developers during the status and defect review meetings.

●Created Functional Specification Documents and Data Mapping Analysis for System Integrations.

●Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.

●Created Use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project. Carried out defect tracking using ClearQuest

●Understand the as-Is system and develop the To-Be system concept and also prepare the System Process Maps.

●Technical specifications development using traceability matrix, data dictionaries and user stories

●Performed GAP analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.

●Worked with developers and designers of BPM System to make sure development understands business processes and detailed technical requirements.

●Designed and developed workflow templates and life cycles for processes involving creating content to publishing product information on the web.

●Utilized diverse data platforms for Master Data, CRM or Reporting like Business Objects, Tableau, Qlik, Oracle, SQL

●Coordinated JAD session with system analysts, development team, project manager for application development and Pre-validation specifications.

●Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application and managed them using Rational Requisite Pro.

●Used Test Director which is a Mercury tool to help manage defects and issues log during the testing phase.

●Created and maintained data dictionaries, Entity Relationship Diagram (ERD) models, and guidelines for database usage and availability.

●Worked on data mapping, data modeling and used SQL queries to filter data from the database.

●Planning and creating test scenarios to ensure that the system modification will meet the specified business requirements.

●Created the SQL scripts for demonstrating the prototypes and for verifying the result sets.

●Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized.

Walt Disney World, Orlando, FL Sept 17 – Dec 19

Business Analyst

The Walt Disney Company, commonly known as Walt Disney or simply Disney is an American diversified multinational mass media and entertainment conglomerate headquartered at the Walt Disney Studios in Burbank, California. The scope of this project is to provide a fully personalized customer interaction environment that integrates information and applications from multiple sources into a superior user experience. End users can personalize the portal by adding content and features, adjusting preferences, setting a theme and rearranging the layout.

Responsibilities:

●Involved in Inception Phase and prepared vision statements and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.

●Executed the Mediapulse order management, returns/dispute management and reporting activities for Walt Disney.

●Acted as a resource in understanding how IS systems carry out business functions and assists in ensuring the timely and effective implementation.

●Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.

●Helped develop and execute strategic merchandise financial plans and strategies that support the merchandising, marketing and financial objectives of the department and division.

●Worked in Wide Orbit Media Sales which empowers TV sales teams to build proposals with a full suite of tools leveraging real-time account information, inventory availability, and audience research and delivery metrics. Integration with WO Traffic extends data consistency across linear and digital.

●Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.

●Skilled in secondary Market Research, Media Tracking, Analysis, Media Measurements encompassing traditional, social and broadcast media.

●Maintained Monthly Metrics to generate reports on requests completed by individuals using online metrics tool

●Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them.

●Worked with Architects, Programmers, Development testers, Quality Assurance testers, and other System and Business Analysts that represented all other interfacing Applications and Middleware components for the various Application Projects assigned.

●Performed Unit and Integration testing with the development team as well as User Acceptance Testing and Regression Testing of the application using QTP, Quality Center and Jira.

●Integrated Wide Orbit Program with Wide Orbit and other 3rd party solutions to simplify workflow and share rich data across the organization.

●Participated in Data Analysis and Design and data mining with the Data analyst in defining data sources and required data content for the data warehouse component.

●Adept at writing data mapping documents, data transformation rules, maintaining data dictionaries, data migration documents and interface requirements documents.

●Interacted with clients to create solutions, document workflows, business processes and process mapping.

●Performed the requirement analysis and documented the requirements using Rational Requisite Pro

●Helped with tasks among the development team, monitored and tracked progress of the project following agile methodology.

●Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.

Keptbug Technology, Noida, India Jun 14 – Jul 16

Business Analyst

My project was to test the Point of Sales System (POS) for their inventory management, retail management system.

Responsibilities:

●Helped improve the Point Of Sale system (POS) for the Exchange retail stores to increase the process efficiency and reduce the overall operation time.

●Created User Stories, Test Cases utilizing Target Process Agile methodology tool.

●Helped create Inventory process for retail stores, consisted of data integration and inventory processes with third party vendor

●Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.

●Documented the Traceability Matrix for tracing the Test Cases and requirements related to them.

●Coordinated various kinds of User Acceptance Testing (UAT) including regression testing, system testing, integration testing, functional testing, alpha & beta testing.

●Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements.

●Supported QA by helping outline test scenarios and defining success criteria.

●Maintained and monitored trade floor data room, which has limited access to approved TFS/BTS technical personnel.

●Conducted JAD sessions with the IT and QA team for a seamless design, development and production of the application.

●Performed different testing like unit testing, system testing functional regression testing.

●Involved in preparing a simple and detailed User manual for the application for intended users.

●Extracted and transformed data (as per the Business Rules/logic) from source systems to provide a consistent structure for the data warehouse environment.

●Involved in data mapping and data normalization of the data throughout the cycle.

●Created the user requirement specifications and helped convert them to functional requirements and managed them in Rational Requisite Pro with proper traceability to the system requirement specifications (SRS) and also created the business vision document and glossary.

Contact this candidate