Sr.business Analyst Resume
Ei Segundo, CA
SUMMARY:
- Over 8 Years Professional Experience as Business Analyst in Retail Ecommerce Environment.
- Qualified professional with 8 years ofexperienceas aBusinessAnalystin Retail, Supply Chain, Ecommerce andDigitalMedia with solidexperienceworking with the technical staff to implement management and staff'sbusinessrequirements into the software application in retail and e - commerce anddigitalmarketing environments.
- Expertise in understanding the business needs, defining a creative and useful software solution to the management, implementing and training the application to the user community.
- Experience as a Business Analyst/ Systems Analyst with solid understanding of Business Requirement gathering, Business Process flow, Business Process Modeling, Data Analysis, Data Mapping and Business Analysis.
- Experienced in traditional Agile BA and storyboard approach for front end dev projects such as fixed income index construction as well as manipulation.
- Strong experience working in Software Development process using Waterfall, Agile-SCRUM and RUP methodologies.
- Possess strong knowledge ofdigitalmarketing and analysis of individual campaigns.
- Planned and defined system requirements to Wireframe with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
- Experience working directly with clients in consumer packaged goods and retail industry
- Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
- Identified the options for potential solutions; assessed them for both technical and business suitability; applied technical as well as organizational changes according to the new system.
- Experience in IBM WebSphere Commerce Server with expertise in Requirement Analysis, Design, Development, Testing, Maintenance and Troubleshooting of high transactioneCommerceapplications.
- Good experience in Master Data Management (MDM) and Retail related Customer, Product and Identity data. Experienced in designing Master Data Management CRUD & Business Processes required to run, improve, and transform the business.
- Expertise in Requirement Analysis, requirement modeling using Unified Modeling Language (UML) and Object Oriented Analysis.
- Experienced requirement elicitation techniques like interviews, brain-storming, document & interface analysis and organizing sessions with Subject Matter Experts (focus groups).
- Hands on experience in Project Management while assisting Senior Project Manager.
- Participate in developer integration, system integration and acceptance testing of all e-commerce applications and Hands on experience with Ecommerce web sites.
- Experience in developing applications usingHybrisecommerceframework.
- Experience in writing test plans, reviewing test cases and mentoring QA teams.
- In-depth knowledge of conducting User Acceptance Test (UAT), data quality checks using SQL, gap analysis and Requirement Traceability.
- Expertise in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
- Designed and managedcontentmanagementtemplates and work flows using sharepoint
- Expertise with supply chain strategies/vendor manufacturing process methods to determine level of procurement and strategic sourcing strategies/plans and worked with vendors/peers to determine lead times, schedules and cycle counts, established requirements needs.
- Experience in writing Use Cases and producing Use Case Model, Analysis model, Behavior diagrams (sequence diagrams, collaboration diagrams), and Class diagrams.
- Organized Joint Application developments (JAD), Joint Application Requirements sessions (JAR), Interviews and Requirement Elicitation sessions.
- Experience in Functionality Testing, User Acceptance Testing, Database Testing,Regression testing and Risk Based Testing
- Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
- Extensive experience in verification, validation (cross-functional testing) and SDLC Process
- Excellent working experience with SQL Server and SQL CE
- Effectively use technology to increase profit, productivity, and competitive edge while simultaneously delivering significant reductions in cost of doing business.
TECHNICAL SKILLS:
Operating Systems: Windows, Linux, Pocket PC, Win CE
Servers: Citrix, Windows Server, SQL Server
Databases: SQL Server 2000, SQL CE, MS Access, Sybase and Oracle
Application development Tools: Visual Basic, Power Builder, eVB, .NET, Crystal Reports
Languages: SQL, C, C++, C# & JAVA
Web tools: HTML, XML, MS Front Page
Business Intelligence: Business Objects, Crystal Reports, Cognos
Testing Tools: Test Director, Quality Center, Quick Test Pro, Load Runner
Methodologies: RUP, OOAD, UML, RAD, Waterfall, Scrum, Agile andBusiness/Data Modeling
Business Modeling Tools: MS Office, BPMN, UML, DOORS, Rational Rose and MS Visio
PROFESSIONAL EXPERIENCE:
Confidential, EI Segundo, CA
Sr.Business Analyst
Responsibilities:
- Acted as a liaison between the project group and the operations group.
- Helped design scope document and to coordinate with top management for the approval process.
- Interviewed various personnel including broker dealers and traders to understand the current process and the future requirements.
- Conducted JAD sessions with Subject Matter Experts to identify business rules, functional requirement and non-functional requirements
- SolvingeCommerceissues and implementing state of the art technologies to improve the business performance of the clients
- Putting a strategy around the structure and management of a high profile product catalog and extreme busyeCommercechannels
- Developeddigitalstrategy plans for B2B clients following theDigitalAnalytics skills.
- Analyzed and managed Supply Chain reports, dashboards and performance metrics.
- Wrote copy for thedigitalteam site and encouraged user adoption of the site.
- Worked as adigitalanalystfor management and development of creative services anddigital marketing.
- Extensively conducted JAD sessions to understand the business requirements
- Prepared graphical depictions of use cases activity diagrams, system context diagrams, sequence diagrams, use case diagrams and wire frames for ecommerce web page development.
- Provided Agile coaching in the position of Senior Business and Requirements Analyst and QA Lead on the company's first pure Agile/Scrum Team (some of which were familiar with Agile and some that had not yet worked in Agile).
- Tracking and reporting budget and cost allocation variances and performing cost/benefit analysis.
- Extensively involved in Business Process Modeling
- Worked on a variety of short and long-term projects for customers and internal clients delivering business intelligence solutions built onSAPBI platform.
- Created the AS IS and TO BE business processes
- Used Master Data Management (MDM) technology, tools to create and maintain consistent and accurate lists of Master Data
- Worked with thecontentmanagementteam on display ofcontenton BOL pages.
- Documented the business requirements following the RUP methodology using rational requisite pro
- Created a product development methodology handbook with deliverable-based project management, including a change management methodology used for developing new features and enhancements.
- Custom tools upgrade client had created marketing, merchandising, promotion and product tools to support their custom web application which needed to be re-architected to work with ATGs eCommerce suite
- SAP Supply Chain Subject Matter Expert (SME) - Utilized knowledgeable on several SAP modules on processes and configuration and master data.
- Used rational tools for version control and defect management
- Facilitated requirement gathering sessions with the team to collect the business standards, security and service level requirements and studied the business process
- Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
- Identified User Story points with the Developers and assigned user stories to Sprints in Agile Methodology.
- Authored the Business Requirement Document (BRD).
- Created Wire frames and Activity Diagrams using MS Visio to outline the "To-Be" screens and "To-Be" processes respectively.
- Developed Business rules for the equity trading system based on technical chart analysis and fundamental analysis and trends.
- Used rational Rose to create use cases for different scenarios and cases.
- Developed Business specification diagram so as to understand the whole work flow.
- Created UI Specifications and wire frames.
- Developed activity diagrams in Rational Rose software, so as to have a diagrammatic view of the workflow.
- Collaborated with the QA team for developing scenarios for validation and testing.
- Responsible for end user training and P&Ps
- Got involved in the User acceptance Testing (UAT) and SIT and documented the test scenarios and outcomes.
Environment: Advance Plex, WebSphere commerce 7.0, AS400, UML, .NET, Agile ( Scrum ),GPP, AS/400, Hybris, Mainframe/DB2, J2EE, RUP, UML, Use Case diagrams, Microsoft Visio, MS Project.
Confidential, Menomonee Falls, WI
Sr. Business Analyst
Responsibilities:
- Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
- Conducted extensive requirement analysis
- Using Shared Containers and creating reusable components for local and shared use in the ETL process.
- Prepared Need Analysis Documents of the requirements gathered through JAD sessions.
- Extensively used Visual Basic to create macros in order to make data migration testing more useful and compared results from the legacy databases to the new CRM database.
- Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
- Provided oversight of alldigitalmarketing projects coordinating global implementation.
- Proactively developed, implemented & maintain centralized databases for contract reviews and records management resulting in improved data integrity and metrics reporting as well as creating central repositories for historical supply chain data.
- Provided recommendation for use of ATG Commerce for B2B and B2C business.
- Integrated data from client ERP systems withHybrisprice management and product modules on a monthly basis.
- Basic understanding of procurement, spend category management and project management methodology's, and e-procurement processes.
- 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.
- Extracted, discussed, and refined User and Business Process Requirements from team. Also, co-authored User and Functional Requirements.
- Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
- Acting as a main point of contact between the business and technical teams to deliver high quality, crisp requirements for the implementation of a complete end-to-endeCommerceapplication utilizing ATG (Oracle Web Commerce) out of the box functionalities with customization
- Drafted User Stories and Use Cases and Identified User Story points with the Developers and assigned user stories to Sprints in Agile Methodology.
- Provided market research solutions for the consumer packaged goods market.
- Data Taxonomy Creation - Creation of standard data elements withincontentmanagementsystemsto provide standard naming for conventions for fields imported into the Corporate Data Warehouse
- Experience creating user experience deliverable including information architecture and Wire frames and work flows.
- Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
- Knowledge of Agile and Scrum were used to aid in developing a product that was traditionally Waterfall in making the transition from Waterfall to an Agile approach.
- Extensive experience in modeling the AS IS and TO BE ecommerce solutions.
- Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
- Experience as an external e-commerce solutions provider.
- Ensure integrity and validation of data in various reporting systems (SQL server 2008, 2012, SSRS, SSIS, SharePoint and AS400).
- Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
- Conducted GAP Analysis between the existing projects and the proposed project to map the systems and evaluate their utility toward the new project.
- Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
- Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing).
Environment: Windows NT 4.0, AS400,Erwin, XML, Dbase3, Hybris, DOS and UNIX Sequential Files, Java, NUnit, Data Stage, ETL, MS Access, HTML, ERWIN.
Confidential, Chicago, IL
Business Analyst
Responsibilities:
- Responsible for requirements gathering, analysis, detailed process flow design, user acceptance testing and rollout of new & modified feature functionality deployed on the E-commerce website applications.
- Conducted project discovery through the interviewing of key stakeholders' to flush out business rules, operational specifications and interface specification solutions to address identified business opportunities and/or strategic initiatives.
- Gathered and validated requirements, resulting in detailed business rules, functional requirements and process design.
- Successfully collected, analyzed and documented requirements from the business for a new Shareowner Services Web Portal.
- Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
- Act as a liaison between business users and technical departmentManage a team of subject matter experts for E-Commerce user acceptance testing efforts.
- Employed Rational Clear Quest for effective Change Management (Scope Creep) and bug tracking during the testing lifecycle.
- Incorporated Agile methodology and SCRUM techniques to manage requirements
- Developed User Stories throughout the Agile Lifecycle using tools such as JIRA
- Participate in Daily Agile Scrum "Stand-up", Biweekly Sprint Planning and Retrospective Sessions and update the team on status of upcoming User Stories
- Managed and led various process improvement teams and data integrity initiatives utilizing problem-solving, communication and presentation skills in support of strategic departmental objectives in improving the end to end supply chain process
- Involved in gathering Business Requirements and Expectations from Subject Matter Experts (SMEs) and defining business processes, identifying risks,
- Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
- Well versed with all stages of Software Development Life Cycle (SDLC) i.e. Requirement(s) gathering & analyzing, Design/redesign, Implementation and Testing.
- Performed Business Process Modeling using Visio.
- Identified, researched, investigated, analyzed, defined and documented business processes.
- Worked on Master Data Management (MDM) for maintaining the customer information and also for the ETL rules to be applied.
- Extensively involved in the modeling and development of Reporting Data Warehousing System
- Was involved n the creation of new E-Commerce Products (Arrival Notices and Customized Reporting)
- Accumulated system requirements from various departments through surveys and interviews.
- Involved in prioritizing the defects and writing business requirements to resolve them.
- Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
- Acting as a main point of contact between the client and technical teams to deliver high quality, crisp requirements for the implementation of a complete end-to-endeCommerceapplication utilizing ATG (Oracle Web Commerce)
- Extensively used .Net validation controls to validate the controls used in patient registration form.
- Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile/Scrum.
- Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
- Made sure developers completed unit testing and created production forms. Conducted regression tests using automated testing with Ruby and Watir
- Gather requirements from business owners, perform system analysis & create business and functional requirement documents /user stories in Rally for the Change Request/Enhancements.
- Create technical design documentation for the data models, data flow control process, metadata management.
- Rewrite, Add and Define, Rewrite existing requirements, breakout into new requirements, and create additional documentation where appropriate.
- Analyzed the data collected and process maps to determine the root causes and identify opportunities.
- Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
- Created business requirement documents and integrated the requirements and underlying platform functionality.
- Interfaced between Business new product builders and System platform builders.
Environment: RUP, AGILE, UAT, iRise, GAD (Gap Analysis Document), B2B, B2C, MS Visio, Java, PHP,J2EE technology, .NET, ASP.NET, RUBY,SQL Server,Rational Clear Quest,informatica, Windows 2000 Advanced Server, UNIX / Oracle Platform.
Confidential, New York, NY
Business Analyst
Responsibilities:
- Drive the completion and complete alignment of system design from business requirements and architectural design.
- Actively involved in various e-commerce initiatives, including custom application development and front end features on the e-commerce platform. The upgrades were done to the legacy platform and new features development for existing retail clients
- Provided Midwest Leadership with the relevant data to discuss Call Center remediation with the Business Process Analysis team and the Call Center ops teams.
- Worked on defining and customizing Service Notifications, Repair Sales Orders and Service Orders
- Document and analyze business requirements, functional requirements, system capabilities, and detailed design.
- Expertise in using Rational tools for creating use cases, version control, and defect tracking and monitoring and used the Rational Unified Process (RUP) methodology in all areas of the software development life cycle (SDLC).
- Created macros for preparing test cases in Excel for validating process of P&L tool, order management, Allocation Strategies and Modeling.
- Prepared the UI wireframes inclusive of mouse over, clicks and double clicks etc.
- Prepared Use cases and Data flow diagrams and Work flow diagrams, considering the scope of the project with MS VISIO.
- Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
- Gather requirements for the listed options risk management system, specifically for index options risk management spreadsheet.
- Defining requirements for product control and risk management end of day feeds.
- Developed demonstrated prototypes including data models, business objects universes, reports and business dashboards and received their feedback to define the information access strategy for an integrated data warehousing and reporting solution.
- Participated in Scrum meetings using Agile for AMS application
- Provided regular reports to Global Supply Chain, Sales and Operations leaders to better manage costs, inventory control and identify improvement opportunities
- Worked on MS Excel Macros for creating automatic reports
- Providing user andcontentmanagementsupport for SharePoint, including assisting individual users with developing SharePoint knowledge; building various publishing, team, and personal sites; creating web parts; and adding permissions.
- Involved in the system workflow analysis and contributed to the overall work flow diagram for the website.
- Ensure consistent and effective communication among all parties.
- Proactively identify and resolve issues by working with all portfolio teams.
- Create and publish periodic executive reports.
- To execute Mobile Application test cases, FT regression test cases on various new builds against Test plans and procedures defined by SEMC and log the bugs.
- Conducted and participated in Review & Peer Review sessions with SMEs and vendors to gather business and technical requirements using MS NetMeeting, MS Live Meeting, email and conference calls.
Environment: Ascential Data Stage 6.0(Manager, Director),Java, J2EE, Oracle, MS Project, MS Word, Excel, PowerPoint, MS Live, MS Visio, Business Objects,IBM DB2/UDB Universal Database Oracle 8/9i, MS SQL Server 7.0, Agile,HTML, XML, UNIX, Windows NT, Sybase.
Confidential, Atlanta, GA
Business Analyst
Responsibilities:
- Established a Business Analysis methodology around the Rational Unified Process.
- Reviewed Use Case, User Interfaces(UI), ISD, Business Rule Catalog(BRC) for elaborating the data elements.
- Worked as business analyst to support the re-design of the Mortgage Asset Management System.
- Developed project plans and managed project scope.
- Involved in Requirement Scoping, RFP documenting and analyzing high priority requirement for implementation; Created BRD, functional Requirement documentation and use case documents using Agile methodologies (used JIRA tool) and utilized SQL database to store information.
- Eliciting, analyzing, documenting and validating business requirements and user stories, process flows for the new ATG e-Commerce Platform spanning all aspects of browsing and purchasing hardware and services
- Added much efficiency to the delivered upgrade scripts and steps. These conversions involved multiple software applications (General Ledger, Accounts Payable, Accounts Receivable, Purchasing, Inventory, and Fixed Assets) across many databases.
- Work with Customers to obtain requirements through surveys, site visits, business process descriptions, workflow analysis and use cases
- Custom tools upgrade client had created marketing, merchandising product tools to support their custom web application which needed to be re-architected to work with ATGs eCommerce suite.
- Submitted proposal, gained approval for an enterprisecontent/documentmanagementsystemto replace BMS.
- Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
- Performed extensive Requirement analysis and developed use cases and workflows.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
- Played a key role in the planning, User Accepted Testing, and Implementation of system enhancements and conversions.
- Contributed on the design of mainframe batch processes using DB2, JCL, COBOL, IBM Utilities, advanced BMC Scheduling techniques, and Connect Direct processes/jobs.
- All the test scenarios which have been satisfied with the functionality are moved to automation testing using Quick Test Professional.
- Developed business requirement specification documents as well as high-level project plan.
- Assist the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations.
- Conducted benchmarking activities to identify best practices.
Environment: Mainframes, COBOL, JCL, Db2, SQL, Agile,Oracle, Rose,.Net, MS Word, MS Excel, MS Visio, LoadRunner, WinRunner
