SUMMARY

• Over 10 years of experience in IT industry including 8 years as a professional IT Business Systems Analyst in e - Commerce arena (Retail, Hospitality, and Telecom industries).
• Experience with many different B2B and B2C e-Commerce IT applications in ERP, Supply Chain, CRM, Billing & Invoicing, Incident Management, Loyalty, Payments, POS, Call Center, Customer Service, Reservations, Web Content Mgmt. (WCM), Digital Marketing, etc.
• Strong facilitation (and meeting conducting) skills and experience in leading meetings including Joint Application Development (JAD) sessions, focus sessions, WebEx/Skype/Go-to-meeting meetings, etc.
• Experience in Web Content Mgmt. System (CMS), web traffic analysis with tools like Google Analytics.
• Experience in gathering requirements through in person and group interviews, Joint Application Development Sessions (JAD), focus sessions, etc. with variety of stakeholders and SMEs.
• Experience in Data Warehousing (DWH)/ERP, ETL, Business Intelligence (BI)/Business Reporting
• Experience in RDBMS Data Analysis, Data Mapping, Data Validation, Data Cleansing, Data mining, Data Modeling, Master Data Mgmt. (MDM), etc.
• Experience in writing SQL queries/scripts for data analysis and QA report testing.
• Experience in widely used SDLC methodologies such as Waterfall, Agile-Scrum, and RUP.
• Hands-on experience in creating project documentations such as Business Requirements Documents (BRD), Functional Requirements Documents (FRD/FSD), Use Case Documents, Project Charters, Requirements Traceability Matrix (RTM), etc.
• Experience in Object Oriented Analysis and Design (OOAD) approached UML: Aactivity/Swim lanes diagrams, Use case diagrams, Sequence diagrams, Class Diagrams, etc.
• Experience in performing Gap Analysis (As-Is & To-Be) situations and plan the milestones accordingly
• Experience in Business Process Modeling (BPM), Process Analysis, and Business Process Re-Engineering
• Experience in creating GUI screen mock-ups, Wireframe diagrams, and screenshots (Prototyping)
• Experience in QA testing and creating and reviewing test cases, and User Acceptance Testing (UAT)
• Experience in creating and maintaining Requirements Traceability Matrix (RTM)
• Excellent communication and organizational skills including the ability to multi-task prioritize and manage increasingly complex issues. Experience in COTS products with RFI & RFP preparations
• Experience in Project Management & PMO: Project Charter, WBS, Gantt Chat, Project Scheduling, Record keeping & presentation, ROI, Cost/Benefits Analysis, Budgeting, Resource allocation, Change Management/Change Control, Risk Analysis, Project health monitoring, etc. PMO: Project Standards, Governance etc.

TECHNICAL SKILLS

Programming Languages: C++, Java, JavaScript, XML, HTML, Visual Basic, SQL, Pl/SQL.

Databases: SQL Server, Oracle, MS Access, DB2, Informatica, Business Objects, SSAS, SSRS

Operating Systems: Windows 97/200/XP/Vista/2010, Linux, UNIX, Mac OS.

Networking: TCP/IP, VPN

QA Testing: HP/Mercury Quality Center, HP ALM

Other: MS Office 365/MS Office (Words, XL, PPT, Publisher, OneNote, Outlook), MS Visio, MS Project, Citrix, Visual Studio, Notepad++, Eclipse, Rational Rose, DOORS, TOAD, JIRA, SOA, Salesforce.com, SOAP, REST API

PROFESSIONAL EXPERIENCE

Confidential

Business Systems Analyst/Scrum Team Member

Responsibilities:

• As a team member of the scrum team, worked with the Product Owner and the Scrum Master to review, estimate and prioritize the user stories and assisted creating the product backlog and the sprint backlog.
• Assisted the Scrum Master to facilitate sprint planning, sprint review, sprint retrospective, and daily scrum meetings. Helped the scrum team to understand and break the EPICs to manageable user stories and extract the functionalities in the user stories to build the products.
• Worked with the Product Owners and conducted JAD/focus sessions with SMEs, key business stakeholders, other IT staff, and the scrum team to further discuss/clarify the user stories/ requirement and business process information on ERP system design and implementation.
• Worked with main business groups such as Customer service call centers, Sales Teams, Accounting, etc. to gather CRM specific user and Business Intelligence (BI) data requirements/user stories and business rules.
• Performed data analysis and rewrote the user stories when necessary for data needs. Involved in ETL processes.
• Worked with B2B & B2C related SMEs to find current gaps/issues in the areas such as customer relations, billing & invoicing, Pricing, POS, delivery time, data security (entire system and individual accounts), etc. and find the better ways to integrate the requirements to the CRM application.
• Worked with the Digital Marketing team to streamline the proposed digital marketing campaigns. Analyzed the campaigns and fine-tuned/reviewed the e-mail, TV, bill boards, and other digital contents for better outcome.
• Engaged in core marketing initiatives like Heat Mapping, Up-sell, Cross-Sell products alignment, Flash Sales, etc. to identify specific user requirements and pain points.
• Participate in the incident and problem management processes, accountable for resolution, root cause analysis, business reporting and user communication; Pull documenting tickets from Service Now.
• Used SOAP web service for sending files in XML format.
• Worked with the Customer Service Team and analyze the current incident and ticket issuing process for improvement through IT with business process re-engineering approach.
• Also documented user requirements focusing web features to improve the customer experience.

Confidential, Seattle, WA

Business Systems Analyst

Responsibilities:

• Served as a liaison between the Product Owners, SMEs, scrum team, Business users and the service delivery team to optimize the existing reservation, baggage tracking, departure control business processes.
• Collaborated with different teams to streamline workflow, communication and ensure optimal productivity in user story review sessions. Helped QAs in the scrum team to identify the functionality and prepare the test cases.
• As a scrum team member, assisted the Scrum Master and the Product Owners to review and break the complex user stories to simple user stories, estimate and prioritize the products and to create the product backlogs and sprint back logs. Worked with the scrum team to extract functional specs from the user stories and test them.
• Assisted the Scrum Master to facilitate the sprint planning, daily scrum, and sprint review meetings and led the scrum team for end-to-end delivery of products within strict timelines.
• Worked with the users to create/write quality user stories and reviewed them to make sure the right features/functionalities were captured though the user stories.
• Performed root cause analysis with business users and Salesforce.com SMEs to understand the bottom issues.
• Worked with the Product Owners and the Scrum Master to prioritize and estimate the user stories/products, create the Product Backlog, Create the Release Backlog and the Sprint backlog.
• Helped the Scrum Master to conduct the daily scrums and also helped maintaining the burn-down charts for monitoring the project sprints/workload. Participated on all the Agile ceremonies and followed up.
• Worked with the CRM, back office SMEs on AP, AR, Billing & invoicing, GL, and other accounting users to discuss and understand the real issues and the user stories.
• Worked with the supply chain and CRM SMEs to understand the current issues and find best possible solutions in procurement and order mgmt. Reviewed the specific user stories on order mgmt. (ex: Procure-to-Pay) for clarity.
• Analyzed the data sets/feeds for data anomalies and worked with the DBAs to find solutions in data corruptions.
• Performed Data Analysis, Data Mapping, and Validation to reformat the current reports based on the Business Intelligence (BI) data requirements. Involved in ETL processes. Used SQL queries. Used Web Services API Layer.
• Attended in-house Agile-Scrum professional training program.
• Worked with Architects, Developers, and DBAs to find best solutions for architecture, technology and business needs Created wireframes and screen mock-ups for suggested GUIs

Confidential, Alpharetta, GA

Business Analyst & Data Analyst

Responsibilities:

• Designed the business requirement collection approach based on the project scope and SDLC Methodology.
• Facilitated/conducted JAD sessions with SMEs, key business stakeholders and other IT staff to collect requirement and business process information.
• Worked with main business groups such as Customer service call centers, Sales Teams, Accounting, etc. to gather CRM specific user and Business Intelligence (BI) data requirements and business rules.
• Worked with B2B & B2C related SMEs to find current gaps/issues in the areas such as customer relations, billing & invoicing, delivery time, data security (entire system and individual accounts), etc. and find the better ways to integrate the requirements to the CRM application.
• As a team member of the mobile app development team, based on the customer feedback and market research, documented business requirements for ( both iOS and Android) mobile apps focusing on improving the customer experience on tablet and phones. Worked on contents re-arrangements.
• Worked with the Customer Service Team and analyze the current incident and ticket issuing process for improvement through IT with business process re-engineering approach.
• Also documented user requirements focusing web features to improve the customer experience.
• Developed business process models (BPM) for existing (As-Is) and future (To-Be) business processes.
• Performed extensive requirement analysis including data analysis and gap analysis.
• Used Prototyping method to gather additional requirements from the users in order to describe the business needs in terms of the system being created checked reports using TOAD (Oracle) for errors and provided the information to appropriate department for further investigation. Also worked with developers on APIs.
• Jointly created the Business Requirements Document (BRD), Use cases, and Functional Requirements Document (FRD). Created the UML Diagrams such as Activity/Swim Lane, Use Case to model the requirements.
• Created wireframes for GUIs (web screens) based on the new user requirements and suggestions.
• Used proactive approach to detect errors by using SQL commands to pull reports to check for RDBMS data errors. Worked with the end users on production to see post-production defects on all the web applications. Used XL (pivot tables) and SQL. Worked with DBAs to identify the new data elements and create/modify the data tables.
• Involved in ETL process and helped the data team by performing data mapping and data validation
• Heavily involved in QA testing and helped QA to create the test cases. Heavily involved in UAT.
• Assisted the PM and helped creating the Project Charter, Project Mgmt. Plan, and Project Schedule.
• Worked with the PMO to establish Agile - Scrum methodology within the IT department
• Take a major part of the Change Control process and followed up all the Change Request (CR) with impact analysis on Scope, Schedule and Budget constraints and worked with the Change Control Committee.

Confidential

Business Systems and Data Analyst

Responsibilities:

• Facilitated JAD sessions and gathered user & data requirements on loyalty programs and documented the Business Requirements Document (BRD) accordingly covering each areas.
• Jointly worked on the functional requirements Document (FRD) and use cases.
• Worked with DBAs to modify and design data models and set the data structures accordingly for features such as Loyalty point calculations, rewards, payments, etc.
• Worked with the mobile app development team on both iOS and Android technologies. Reviewed and cleaned up the client’s mobile specification and rewrote the functional specs for mobile apps.
• Participated in the pilot run mobile apps on the Apple iPhones and iPads.
• Also involved in implementation of new POS system and gathered specific user requirements and integration specifications. Worked with data security and systems security related business rules and technical requirements.
• Applied OOAD-UML approach to model the user and data requirements and created many data flow diagrams.
• Created reports for multiple purposes using SQL queries, and performed Data analysis on RDBMS / relational databases using SQL and XL. Involved in ETL process. Informatica was used for ETL process.
• Involved in creating Entity-Relationship diagrams for the design of RDBMS database.
• Worked with DBAs on RDBMS data structures such as Star-Schemas, Data marts, etc. and helped to identify key data elements. Worked on the API documentation with the developers and data architects.
• Using Google Analytics, performed web traffic analysis.
• Worked with the QA testers on functional and regressions testing and also involved in UAT.

Confidential

Responsibilities:

• Worked with the senior BAs and involved in gathering user/business requirements, creating business and functional requirements document (BRD & FRD) and analyzing data/work flows, defining the scope, financial projections and cost/benefit analysis, etc.
• Worked with the QA team and involved in designing and developing the test plan and test cases and UAT.
• Worked with Users and Technical team in managing and handling User requested Changes and User Conflicts.
• Worked with the Accounting dept. to streamline the AP, AR and Billing/Invoicing process.
• Developed documentation templates, specifications and schedules for technical writing deliverables.
• Worked on the wireframe diagrams and screen mock-ups for UI adjustments and reviews.
• Worked on Business Process Modeling (BPM), and UML (Activity, Use Case, and Class) diagrams.
• Performed Data Analysis on various types of data and data mapping, data cleansing, data validations, etc.Also, involved in ETL.