PROFESSIONAL SUMMARY:

• With more than 10+ years of IT experience with and as Dynamic Market/Business Analyst for over 7+ years of experience interfacing at all levels to ensure organizational goals are attained. Demonstrated skills in E - Commerce, online advertisement and marketing, and web analytic and improvements to IT infrastructure
• Team leader/Project manager for mobile app development.
• Strong problem solving and troubleshooting skills with the ability to exercise mature judgment.
• Excellent skills in implementing, reporting, and analyzing daily, weekly, and Ad hoc web analytics reports.
• Strong analytic skills in interpret data analysis. Ability to develop presentation charts with actionable insights to help internal business partners drive change.
• Strong Knowledge in PayPal pro-version and Authorize.net.
• Extensive knowledge in web analysis including website usage, traffic, page views, exit and bounce rates using Google Analytics, Oracle ATG, Marketing Suite, and Omni Channel portal.
• Expert Knowledge in the procedures of in maintaining and managing the content management system in E-Commerce platforms such as ATG E-Commerce, IBM WebSphere and Magento.
• Expert in facilitating all levels of management, developers, QAs, stakeholders, marketing team, business users and off-site teams in requirements gathering, analyzing and documents developing.
• Expert in writing documents like Business Requirements (BRD), Functional Requirements (FRD) and Software Requirements (SRS) that match Technical system setups.
• Proficient in creating UML diagrams like Use Case Diagrams, Activity, Sequence, Class, Workflow, Process flow, Data flow and Deployment Diagrams.
• Product Data Management and QA methodologies such as making Test Plans, conducting User Acceptance Tests and creating & executing Test Scripts, Test Cases.
• Proficient in creating mapping spreadsheets, Source to Target mapping documents including transformation rules.
• Experienced in Data Analysis, Data Quality Management, Entity Data Model, Data Profiling, Data Cleansing, and Data Integrity as well as maintaining reference data and defining transformation rules for Data load and Data extract processes.
• Experience in writing SQL queries for data validation exercises using Oracle SQL Plus, SQL Server and TOAD, Oracle 10g/11g/12C.
• Capable of working in a group as well as independent environment with excellent communication skills in Mandarin, Cantonese and English.

TECHNICAL SKILLS:

Requirements Gathering, Business Requirements, Business Processes Research, Analysis, Documentation, Use Cases, Interviews, Prototypes, JAD Sessions, Waterfall, Agile Scrum, JIRA, Confluence, Service Desk, UML, SQL, HTML, MS Windows, MS Office suite, SSIS, Informatica, MS Visio, MS Project, Adobe Photoshop, Adobe Online Marketing Suite, WebSphere Commerce, Google Analytics, Drupal, Joomla, Oracle ATG, Rational Enterprise Suite, Erwin, Test Director and QC

PROFESSIONAL EXPERIENCE:

Confidential, New York

Sr. Business Analyst

Responsibilities:

• Worked closely with Marketing Team, conduced JAD section to define the project scope, risks, and approach of the project based on vision documents. Analyzed requirements and develop requirements documents by JIRA with Confluence and Service Desk.
• Conducted Gap Analysis to show the current and proposed functionalities of the system. Identified system gaps and developed Functional Requirements documents that supported overall strategy, goals, and objectives.
• Facilitated discussions involving key marketing managers from both business and IT side to elicit high level requirements and estimate project feasibility.
• Team leader for mobile app development, in charge of project management for the entire process for mobile app developing, including object defined, requirements gathering, interface designing, Confidential .
• Generated online system architecture diagrams and mobile apps use cases diagrams by Ms Visio.
• Worked with architects and developers, developed system functionality requirements for development team.
• Liaised with the development team and the project manager on project deliverables and schedules.
• Conduct inventory, pricing and shipping cost analysis, competitor scans; coordinate marketing and merchandising initiatives through sales, promotions, rewards and loyalty program based on Magento Enterprise Platform (Omni-Channel) between online website and mobile app.
• Documented to modify checkout button for SSL support and checkout for guest visitors.
• Upgraded customer service to enhance features for customers’ accounts, contact us form, compre-hensive order tracking and history. Planned and executed all online sales initiatives and promotions.
• Analyzed to modify the various payment methods such as credit cards, PayPal, Authorize.net and checks.
• Designed and documented UML Use Cases, Sequence diagrams, Class diagram, and Activity diagrams.
• Maintained Requirement Traceability Matrix for the current business processes and proposed changes.
• Implemented ATG commerce suites for multiple sites and ran testing, data cleansing and data validation
• Analyzed visitors’ behavior on the website and optimized it for better results.
• Wrote basic SQL queries against different databases and analyzed different reports based on company’s requirements.
• Created and documented test plans, test cases and test scripts for focused manual system and integration / functional testing based on Business Requirements and Functional specification documents with QA team, and guided with system integration and performance testing.
• Conducted UAT, documented and reported all user feedback to management, and developed training materials for end users to adapt to new system.
• Involved in preparing a simple and detailed User Manual for marketing and sales team.

Environment: Oracle ATG, JIRA, Confluence, Service Desk, Magento, RUP, UML, PIM, MS Excel, MS Word, Unified Modeling Language (UML), Ms Visio

Confidential, Irvington, NJ

Jr. Business Analyst

Responsibilities:

• Interacted with project sponsors, business owners and end users in the client organization to understand business and project objectives.
• Conducted interviews, survey and workshops with Marketing Team and Sales Reps team to collect requirements and business process information.
• Collected detailed requirements from E-commerce Systems including our B2B websites.
• Created Business Requirement documents and converted them into system functionality documents.
• Created Use Case diagrams, Behavior Diagrams, Sequence Diagrams based on UML methodology using MS Visio.
• Assisted developers by creating use cases and test cases to add new features to the website.
• Screen Mockup, generated system architecture diagrams using MS Visio.
• Managed requirements for infrastructure (environments, network, Confidential .) to guarantee all release environments are ready and consistent.
• Maintained and monitored the project progress, developed and implemented detailed release plans for both scheduled and unscheduled releases using Ms Project and Excel.
• Involved in data analysis and generated reports with Business objects.
• Using Oracle ATG, worked on search options so that dealers could quickly and efficiently navigate the website.
• Conducted inventory, pricing and shipping cost analysis, competitor scans; coordinate marketing and merchandising initiatives through sales, promotions, refer-a-dealer, rewards and loyalty program.
• Prepared use cases for structure of shopping cart, check out process and payment submit.
• Enhanced search options so that shoppers could quickly and efficiently navigate the website.
• Generated and analyzed reports for the E-Commerce tracking and product goals.
• Assisted developers by creating use cases and test cases to add new features to the website.
• Using Google Analytics generated reports about website traffic and traffic sources.
• Analyzed visitors' behavior on the website and optimized it for better results.
• Developed the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge
• Worked on the development and changes to the look and feel of the web application and performed user acceptance testing (UAT) for errors and System Testing.
• Tested various online payment system gateway (PayPal, Target Business Card, Target Debit Card)
• Designed and managed creative marketing campaigns containing web and email activities and conducted multivariate A/B testing for offers.

Environment: Oracle ATG, Google Analytics, Windows, MS Office, Rational rose, MS Visio, Agile Scrum, SQL, HTML, XML, UML, IRA, Confluence.

Confidential, Lancaster, PA

Jr. Business Analyst

Responsibilities:

• Conducted JAD sessions with management team, SME (Subject matter expert), Marketing teams and developing team for critical issues. Quickly gather business & functional requirements. Analyzed requirements and develop requirements documents in JIRA.
• Developed creative ideas and improvements for site content, enhancements and site functionality.
• Facilitated meetings with developers, system analyst and testers to collaborate resource allocation and project completion.
• Assisted the Project Manager with project planning, team coordination, communication, and research collaborations.
• Prioritized user stories from product backlog and helped generate release backlog and sprint backlog using Microsoft Excel.
• Identified the gaps in business and system requirements in integrating/ customizing ATG commerce suite in comparison with the legacy of online application.
• Transition the catalog and content support teams from the legacy platform in the ATG Web catalog platform.
• Documented and analyzed the business process for receiving and processing customer sales and covered business-to-business (B2B) and Business-to-consumer (B2C).
• Synthesized programs’ data into an automated executive dashboard; analyzed the data and made recommendations for growth opportunities.
• Analyzed data from Google Analytics such as website usage, page views, exit, traffic source and bounce rates to find popular products.
• Managed and maintained the online infrastructure, E-Commerce platforms and all related technical operations of business through Site Catalyst.
• Wrote SQL queries against different databases and analyzed different reports based on company’s requirements.
• Created UAT documents for end-users and played a key role in Beta Testing to transit project smoothly.
• Helped create analysis of within site search productivity and make recommendations on improvements that can drive sales increases.

Environment: s: Agile Scrum Development, Oracle ATG,, MS Excel, Google Analytics, MS Word, MS Visio, MS Outlook, MS Excel, Oracle database, Rally, MS Visio (BPMN), UML, MS Quality Center. JIRA, Confluence, Service Desk.

Confidential, Newark, NJ

Business and Marketing Analyst

Responsibilities:

• Gathered and presented information, made recommendations and critical thinking for all Sales reps.
• Conducted meeting with sales reps, conducted interviews and survey with biggest distributors for gathering requirements and data for business needs.
• Analyzed sales data and Market data, generated business developing scenarios for future business planning. Provided external news, market trends and best practical sales plans.
• Designed and implemented the ETL Architecture to build custom Data Warehouse based on data from SAP ECC applications.
• Designed processes to minimize data quality risks and proactively identify potential data issues.
• Activated and enhanced business content objects; enhanced standard SAP data extractors and create generic data extractors.
• Develop Informatica programs to extract, transform and load data from SAP ECC into the Custom Data Warehouse.
• Developed and implemented new marketing strategy models, testing new models followed by marketing plans.
• Conducted deep dive analyses, produced weekly, monthly and quarterly reports by using existing template and methods.
• Continuously monitored project elements, identified Potential problems and managed resolution.
• Worked collaboratively with clients and sales reps, provided updated on projects status.
• Supported the E-Commerce team with e-audits, ROI measurement, input into business planning, and ensuring content compliance.
• Delivered full promotional analysis of all E-Commerce RE activity to ensure most efficient promotion program and optimum ROI returned.
• Conducted regular reviews of all external news, trends, and the best practical plans and to share findings, implications and ideas with the E-Commerce team.

Confidential

Industry Analyst

Responsibilities:

• Data gathering and Financial Statements analyzing; indentified and assessed risks.
• Performed Cost Profit Analyses, Value at Risk (VaR) and ROI analyses
• Prepared reporting packages and highlight potential risks for review by risk team.
• Involved in creating stress testing scenarios models for small size corporation loan.

Confidential

Part-time Website Developer

Responsibilities:

• Built and maintained university online for Student information dashboards system for Confidential .
• Conducted meeting with school leaders, distributed survey to students for gathering the requirements for building the web-base student information management system.
• Collected detailed requirements for student information management online system including online application, online classes registration, online information management, online tuition payment, and Confidential .
• Interacted with business heads to finalize the Business Requirements for the application.
• Website interface designed and Mock-up by using Dreamwarever, photoshop and .NET with developing team.
• Developed UML Use Cases using and developed a detailed project plan with emphasis on deliverables.
• Performed Unit Testing and User Acceptance Testing and documented detailed defects.
• Managed various tests, stored test information, reviewed and analyzed test results.
• Conducted presentations of the Q/A test results with analysis to the stakeholders and users and documented modifications and requirements.
• Data Migration and online interface upgrading from different versions.
• Conducted online and paper survey, collected feedback from users, put feedback into case backlogs dashboards for analyzing and website upgrade use.