SUMMARY

• An IT professional with around 6 years of work experience as Sr. Business Analyst/SME and an exceptional record of delivering high performance technology solutions to meet challenging business demands.
• Good domain knowledge in Retail, eCommerce, Social Services, Investment, Financial & Banking services and work experience in Analysis, Implementation, Design, Development and testing Program development, Mobile Apps, Web Apps and Microservices, MDM, DW (Data - warehouse), OLAP system, OLTP system, ETL (Extract, Transform and Load) operations.
• Extensive experience in Software Development Life Cycle (SDLC) methodologies, frame works and processes. Experienced in managing requirements from project inception through release. Extensive experience working in Waterfall and Agile methodologies.
• Experience in JAD Sessions, Live Meetings and Interviews.
• Extensive experience in modeling the AS IS and TO BE solutions.
• Well versed in project management tools like MS Project for project planning, Project scheduling.
• Skilled in performing Gap analysis and Impact Analysis by identifying existing technologies, documenting the enhancements to meet the end-state requirements.
• Extensive knowledge of BI reporting, integration and Analytics.
• Experience in data mapping from (STM) source to target database schema.
• Experienced in using data flux for data cleansing and data validation.
• Strong understanding of the principles of Data Warehousing, Fact tables, Dimension tables, star and snowflake schema modeling.
• Expertise inData Analysisin Oracle and MS SQL Server.
• Experience writing SQL queries and optimizing SQL queries (Inner and outer joins).
• Expertise in Data Modeling, Data Analysis, Requirement Analysis, Business Modeling, Data Migration, Data Profiling, Data mapping, Data collection and ETL testing.
• Experienced in creating Business Requirement Documents(BRD), User Requirement Specification, and Functional Requirement Specifications. Experienced in creating Data Flow Diagrams, Use Cases, Use Case Diagrams & Activity diagrams.
• Experienced involvement in test management by developing Test Scripts, Test Cases and Test Plans for most of the testing sessions.
• Experience in logging defects and developing their traceability using RTM.

TECHNICAL SKILLS

Operating Systems: Windows 98/2000/XP/Vista/7

Methodologies: Agile (SCRUM), Waterfall

Software and Tools: Microsoft Office Suite, MS Project, MS Visio

Testing Tools: Mercury Quality Center 9.0, HP Quick Test Pro

UI Tools: Mockup Screens, Balsamiq.

Database Tools: My SQL, SSMS, Informatica MDM

Business Intelligence Tools: SSIS, SSAS, SSRS, Tableau, ETL

Document Management Tool: MS Share Point

Requirement/Test Management tool: JIRA, Confluence, Selenium, SOAP/REST services

PROFESSIONAL EXPERIENCE

Confidential, Oak Brook, IL

Sr. E-commerce Business Analyst/SME

Responsibilities:

• Worked closely with the product owner, stake holders and other business users to gather information about the business processes and the required improvements.
• Worked on JIRA requests filed on this project. Worked closely with the technical lead and other team members to groom the requests to epics and stories form the existing Enterprise artifacts.
• Created necessary JIRA tickets for features and sub-features of the Vendor Portal services requested. Also used Confluence to create solution pages to describe impacted legacy systems and data management.
• Worked withBusinessStakeholders/SME (Subject Matter Expert) for requirement gathering,businessanalysis, and translated thebusinessrequirements intoDataRequirements to build the Enterprisedatawarehouse Dimension (EDW) and FACT-Dimension tables.
• Prepared technical design requirements for enhanced API transaction from upgraded POS module.
• Developed mock screen using Balsamic and other tools to represent the Vendor portal UI changes.
• Produced Business Requirement Document(BRD) highlighting features and sub-features of the services requested.
• Developed work flow using Activity diagrams and Data Flow Diagrams(DFD) to analyze the business processes.
• Build dynamic project plan template for documenting various product deployment schedules.
• Proactively coordinated with the scrum master in conducting agile ceremonies, creating Service Level Agreement(SLA) recommendations, user guides and demo presentations.
• Actively participated in project planning activities by creating excel template with dynamic fields to plot project milestones and project timeline.
• Contributed in release planning activities by providing inputs of the complexity and status of the team work on behalf of the Project Manager.
• Organized meetings with other business units of the organization to represent product team and product capabilities for smooth systems integration and dependencies.
• Worked closely with the technical team to discuss and document Technical Specification Document specifying security and performance level requirements.
• Worked in agile process providing constant MVPs to businessteams to improve the quality of the product and avoid any unwanted development changes.
• Integrated AEM (Product MDM),AdobeCampaign (Vendor Portal)and CRM data to create real-time audience segments that improve customer experiences based on behaviors, traits and product ownership.
• Optimized online conversion rate usingAdobeAnalytics click stream data, and trained new teams to create new reports, build new dashboard and analyzecampaigndata.
• Coordinated with ecommerce platform(eCP) team to in corporate the enhancements of the new CRM features to be developed.
• Validated the eCommerce Platform(eCP) data in & out data flow via its integration with other systems of the Confidential environment.
• Worked withbusinessteams to define content testing strategy, executing A/B tests withAdobe Test & Target to find optimal solutions that drove engagement, registrations and sales.
• Proactively involved with the QA team triaging and tracking defects from Open through Resolved states.
• Developed and documented test scenarios, test plans and test cases for User Acceptance Testing(UAT) sessions. Also, created test manual for UAT as well.
• Organized and delivered user training and demo sessions with proficient presentations and user guide materials.
• Coordinate and/or execute plans to ensure that technical solutions meet the needs of the business.
• Manage ingestion of new data with cross functional teams of digital users, the project development team and project sponsors.
• Read, develop and test advanced SQL statements to support development and testing.
• Responsible for defect triage, which involved testing, identifying the type of the defect and assigning to the concerned resource for trouble shooting.

Environment: AWS, JIRA, JAD, Confluence, MS Visio, MS Project, VBA, ACM, AEM

Confidential, Columbia, SC

Business Systems Analyst

Responsibilities:

• Interfaced with DSS stake holders to gather requirements for new enhancements on the CSES application.
• Updated business requirements (general specification documents) and develop test cases.
• Interfaced with business teams to verify business rules, dependencies, and data elements around policies and regulations.
• Effectively collaborated with departments to identify, document and communicate business needs and provide IT solutions.
• Liaised in collaboration with end users (staff) and with build teams as PMO exercise to define SMART requirements. Simultaneously to run jobs within the development environment.
• Created project plan on a Project sheet with the milestone and expected dates to have a project timeline.
• Documented clear and precise training and demo materials in compliance with regulations and standard procedures.
• Interfaced with the PMOs and senior executives to present SDLC and product presentation before and after development to represent team work and accomplishments.
• Filled in for the Agile project management role by conducting Agile SCRUM ceremonies and motivated team to achieve agile SCRUM methodology by introducing Agile documentation.
• Updated test scripts based on the changes in the GSD (general specification documents).
• Performed gap analysis to identify impact on IS and access management systems.
• Involved in creation of data in CSES application based on the test scripts.
• Created design and activity diagrams representing business systems relations and integrations.
• Build, customize and configure tools for automating execution and verification of results for various test efforts.
• Execute and test the functional scenarios for a test effort.
• Worked with development, Business, QA, and Automation engineers to determine root cause of batch job execution problems.
• Provide design documentation like BRD; participate in technical specification review for the test automation projects.
• Provide metrics and project planning updates for the testing effort.
• Identification and construction of test scenarios.
• Generation of inbound files using GECS (Global Event Control Server) application and generation of expected results using same.
• Contributed to building tools for automating execution of the functional components and verification of expected results.
• The comparison of expected results using SQL. Performed backend testing using SQL.
• Extensively used SQL statements to check staging tables and batch status.
• Performed updates at backend as required.
• The organization of test cases and its associated automation through Quality Center/QTP.
• Created several automated and manual reports with insight on variety of system KPIs.
• Organized UAT session with business and end users. Developed user guides for the same.
• Provided training to QA team on the new integrated system to clarify many defects.
• Responsible for defect triage, which involved testing, identifying the type of the defect and assigning to the concerned resource for trouble shooting.

Environment: UML, Rational Clear Case, Rational Req Pro, MS Visio, MS Office Suite.

Sr. Business Analyst

Confidential, San Jose, CA

Responsibilities:

• Acted as a liaison between Business users and Technical team.
• Conducted JAD sessions, Focused group session and one to one meeting with business users and User groups.
• Coordinated with the PM/PMO to define project scope, features and sub-features by conducting and participating in the meetings.
• Developed high-level UML diagrams like, Activity Diagrams and Data Flow Diagrams using MS Visio.
• Organized multiple sprint meeting to prioritize requirements
• Created Functional Specification Document with wireframes to help developers understand the requirements.
• Developed user acceptance test cases.
• Performed User acceptance testing(UAT) by conducting user training and creating user manuals.
• Managed the quarterly releases starting from requirements gathering until production deployment.
• Reviewed Enhancement requests with the Business team and prioritize for implementation during Quarterly releases.
• Used test rail to monitor Burndown charts and any late sprints.
• Proactively coordinated with the offshore team with updates on the project progress.

Environment: Windows XP, MS Office Suite including Visio, ACM, AEM, ServiceNow.

Business Analyst

Confidential | Columbus, OH

Responsibilities:

• Interviewedbusinesssponsors to define current business requirement and develop a technology solution leading to a successful resolution.
• Repeatedly processed the information from the sponsors, redefined the business to make it an optimized solution and got it approved from the Business Sponsors and the SME.
• Developed, documented test strategies, test plans/test cases and conducted system integration and user acceptance testing for the Retail andBusinessBanking commercial application.
• Examined and reviewed reporting forBusinessBanking to enhance their delinquency monitoring process for SmallBusinessAdministration Loans.
• Used Application Lifecycle Management for requirement tracking, test cases, test scripts and defect tracking.
• Managed project initiatives, collaborating withbusinesspartners to ensure quality and time deadlines were achieved.
• Used Mercury Quality Centre to look up defects and issues raised by testing activities.
• Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
• Produced and managed documentation on release activities to support problem resolution.

Environment: Windows XP, MS Office, Windows Server, UML, HP Quality Centre