SUMMARY

• Over 7 years of professional experience as a Business Analyst in Retail and eCommerce Industry.
• Experience in implementation of end - to-end Hybris development projects and several Hybris enhancement projects.
• Extensive experience working with vendor e-commerce tools like Microsoft commerce as well as helping construct and integrate in-house ecommerce applications.
• Performed ETL to migrate and transfer legacy data and data from different source system into target data warehouse system in various platforms.
• Prepare and organize all digital assets for ecommerce website and online retail partner websites.
• Experience with customizing ETL (Extract, Transform and Load) process and implementing it in different database platform like Oracle, Netezza and Teradata using data integration tools and Unix shell scripting.
• Valuable knowledge and proficient in utilizing e-commerce tools such as WebSphere Commerce, Adobe Online Marketing Suite by Omniture to create site improvement recommendations to augment sales strategies and price Optimization.
• Experience with different payment gateways (Pro PayPal, Authorize.net) for e-commerce solutions and documentations.
• In depth understanding and experience of analyzing and testing website pages, shopping cart, check-out process, shipping process and online support.
• Leveraged opportunities presented by the burgeoning online/eCommerce space, and expertise in the retail business to create and launch the company.
• Extensively worked on HYBRIS ACCELERATOR based implementations. Experience with Core JAVA/J2EE, spring framework, hibernate, Java design patterns.
• Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using IBM’s Rational Rose.
• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
• Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents
• Strong knowledge of software Development Life Cycle(SDLC) and Software Testing Life Cycle(STLC), methodologies like Agile, Waterfall and Rational Unified Process(RUP).
• Expertise in understanding of Data Warehousing, OLTP and OLAP. Experience in SQL queries for creating database, Data Mapping Document, data modeling, and ETL.
• Strong process modeling using UML (Use Cases, Sequence Diagrams, Activity Diagrams, etc.).

TECHNICAL SKILLS

Business Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), MS Visio, MS Project, MS Access, MS Office Suite, Visual Paradigm, Business Object

Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modeling & Analysis, Business Environment and Market Research Analysis

Methodologies: RUP, AGILE, UML & Business/Data Modeling

Testing Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, PR Tracker

Operating Systems: Windows XP/95/98/2000, Mac OS X, DOS, UNIX, Linux

Databases: Oracle 8i/9i, SQL Server 7.0 & 2000; Access 2000, MS SQL Server, MySQL, DB2

Content Management Tools: Documentum, Sharepoint, Interwoven, Filenet

Languages: UML (Use case, activity diagram, sequence diagram, data flow diagram, component diagram), C, C++, HTML, Java, SQL, PL/SQL.

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Sr. Business Analyst

Responsibilities:

• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
• Co-authored business requirements document with project teams. Extracted, discussed, and refined business requirements from business users and team members.
• Analyzed shopping cart and site functionalities by using ATG Ecommerce. Developed and implemented Change Management and document version control process.
• Performance tuning of existing ETL jobs - SQL tuning, Informatica Performance tweaks, Job re-design.
• Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Business Process Models.
• Verified and maintained Data Quality, Integrity, data completeness, ETL rules, business logic.
• Responsible for metadata management & customization of different layers of Hybris ECommerce product and for identifying data anomalies, research and resolving data quality issues that would help in rolling out the Hybris to the customers end users.
• Identified and developed processes and procedures within applications that were cost-effective and met user requirements.Also worked on the initial Hybris POC to have Hybrid Solution to have master data Jobs to update the data base.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Used Rational Tools for creating use cases, version control and defect tracking, monitoring. Use Rational Unified Process (RUP) methodology in all areas of the software development life cycle (SDLC).
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Was involved n the creation of new E-Commerce Products (Arrival Notices and Customized Reporting).
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
• Worked with Front-end and Back-end systems
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Automated budget application using Excel to import and convert financial accounting data from several databases in multiple formats, and export reports to various stakeholders.
• 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.
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Designed flexible project foundation enabling rapid implementation of e-commerce website capabilities
• 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
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• The security will be implemented to control the visibility of dashboard reports and information based on the roles granted to the user.
• Reviewed Reporting and ETL technical design documented.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.

Confidential, Chicago, IL

Sr. Business Analyst

Responsibilities:

• Gather requirements by conducting meetings and brainstorming sessions with senior management of the Research Group and SMEs and document them.
• Analyzed business rules to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.
• Also performed the as-is and to-be Assessment to understand the underlying gap in the business process.
• Completed several large-scale data scrubbing and consistency of information projects across all platforms currently in use through Sequel Reporting Services.
• Automated reporting practice from copy and paste, redundant input, variable program data importation, and manual error-check; to macro-driven referencing techniques enabling single-click, live executive-level report generation for all users.
• Created program accounting for all departments; annual projected cost savings versus actuals accrued each year. Quarterly reports developed and posted allowing managers to monitor progress.
• Desktop application upgrade client created custom offline desktop application for their users to browse recommended products at their leisure which needed to be upgraded to work with new infrastructure, security and ATG eCommerce suite
• Drafted test plan, test cases and verified with SMEs, Developers and coordinated a sign-off meeting.
• Extensively used MS Visio to develop the solution concept, business timeline and wireframes.
• Included screenshots in the documents to help the discussion in meetings with users.
• Conducted JAD sessions, initiated scope and discovery meetings.
• Extensively working on use case development followed by correction cycle.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Testing the ETL data movement from Oracle Data mart to Teradata Data mart on an Incremental and full load basis.
• Collaborated with members of the Ecommerce team as well as Merchandising, Creative, and Brand Marketing teams to provide analytic support to measure performance of efforts. Assisted end-users in identifying key performance indicators for their areas and proactively share knowledge and learnings.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Have been working on exploring different software systems and databases in order to design a possible solution and identifying vital data points/elements.
• Worked with developers to make sure that they understood the Use Cases.
• Developed and implemented eCommerce strategy which included partnership with Google and Instacart.
• Assisted the ETL Developers to extract the data from various sources and loading them to data marts.
• Business Intelligence for ETL staging preparation of Business Rules for Enterprise Data Warehouse.
• Collaborated with stakeholders, and developers to successfully launch and create a roadmap for automation enhancements to Hybris (HMC). This involved gathering & documenting user stories, user acceptance criteria, low-fidelity wireframes,and design mockups.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Worked as a liaison between the Business and Technology Department.
• Responsible for managing the migration of the department’s website using Web Builder and ensuring that there are no broken links on the intranet.

Confidential, San Francisco, CA

Business Analyst

Responsibilities:

• Conducted user interviews, gathered requirements, analyzed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• 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.
• Responsible for identifying, documenting and testing the data mapping feeds from several reference data systems, to risk applications
• Developed Functional and Regression Testing scenarios based on XML and XSD schema validations.
• 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 Clear Quest.
• Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams (DFD).
• Used Rational Rose to designed and develop Use Cases Scenarios, Use Cases Models, Activity Diagrams, Sequence Diagrams, State chart diagrams, OOAD using UML
• Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2005 environment
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools.
• Created a massive custom eCommerce site featuring nearly a million products in thousands of categories and came up with novel processes to manage it efficiently at scale.
• Worked in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Coordinated JAD session with system analysts, development team, project manager for application development and Pre-validation specifications.
• Analyzed Functional requirements document, A&D document and developed Test cases to test GUI, Security, Performance and functional requirements of the application
• 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.
• Authored test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.
• Planning and creating test scenarios to ensure that the system modification will meet the specified business requirements.