SUMMARY

• Over 9 Years of experience as a Business System Analyst
• Deep knowledge of Ecommerce space including User Interface processes and tools
• Deep knowledge of B2B, B2C, O2O concepts
• Proficient understanding business needs and converting those to use cases and stories using JIRA/TFS
• Proficient knowledge of REST and SOAP Web services and HTTP status codes associated (20X,40X,50X, 30X)
• Writing request and response structures in XML/JSON for APIs
• Understanding of REST and SOAP web services
• Test REST and SOAP Web services using appropriate tools
• Ability to create and design of information architectures, wireframes, using user - centric design techniques
• Writing SQL queries and generating reports using BI tools
• Proficient with Microsoft Suite and Mapping Tools
• Strong verbal and written communication skills
• Ability to work on multiple initiatives at the same time

TECHNICAL SKILLS:

Business Skills: Facilitating JAD sessions, Business Process Analysis/Design, Gathering Requirements, Use Case Modeling, UI Mock Ups, Gap and Impact Analysis, Risk Assessment

Methodologies: Agile Scrum, Agile, Waterfall

Testing Tools: HP ALM/ QC, Test Director, Win Runner, Load Runner

Development Tools: Rational Products, MS Visio, SnagIt, Atlassian Suite, TFS, Rest Client, SOAP UI, Postman, Axure RP, Snagit, TFS

Languages: SQL, XML, JSON

Web Services: Rest, SOAP

Business Intelligence Tools: Tableau, Power BI

Business Modeling Tools: Rational Rose, MS Visio.

Operating Systems: Windows, Unix/Linus/Solaris

Microsoft Tools: Office and its add-ons, SharePoint

Databases: SQL Server, MS-Access, Oracle

PROFESSIONAL EXPERIENCE:

Confidential, Melrose Park, IL

Business System Analyst

Responsibilities:

• Facilitated the execution and implementation of key business initiatives involving technology components.
• Consulted, monitored and escalated observations and concerns to project management and business management throughout the project execution.
• Extracted, clarified and documented business requirements from all users.
• Managed business requirements and resolved issues while using effective change management processes.
• Supported the business and the development team throughout implementation.
• Proficiently lead system enhancements resulted from strategic planning.
• Ensured that approved proposals were carried through to deliver.
• Created and documented requirements for Technical and UX related Stories for business, product team, by working with CX team, Enterprise Team and other teams within Kohls
• Extensively used Postman and REST Client to test if Endpoints are reachable.
• Facilitated Joint Application Development (JAD) sessions, group discussions and WebEx meetings with the business users, SMEs to gather requirements and discuss any issues/risks that need taken care of.
• Assisted QA team close out Bug tasks and Triage Open Tasks with business and team members
• Documented the Business Process Flows, Business Use Cases, System Use Case, Business Rules and Use Case Realization following the Agile methodology.
• Assisted in the creation and execution of systems and applications and user acceptance test plans
• Worked with the JSON scripts to gather which SKU details were passed to SAL legacy DB.
• Managed documents within Confluence and created Wishlist wiki pages and updated CRM integration Pilot Pages
• Managed and updated several dotcom application Inventory pages
• Created Intake Requests with several teams within Kohls
• Used JIRA as a tracking tool, creating issues, keep track of release changes, bug tracking, cleaning up epics, and reviewing them in story review/design meetings.
• Worked with CX and Clothing Product Design teams to manage the Digital Assistant project and gather requirements to connect to API and get/Display the initial (raw) greeting
• Worked on analytics for Kohl’s customer service chat system, by organizing working session with A/B testing team
• Integration and System testing with dev team to ensure different lower (stage, MT) and Prod environment compatibility also report bugs and critical errors and working with team in fixing them asap. Worked with business and end users for user acceptance training and sign off.
• Assisted the Project Engineer with updating API documents for External Support Tendering for 3rd party sales.
• Created Functional: Miscellaneous Stories and Bugs which include several changes to Assured Living Forms
• Worked with CX strategist to create interface designs, and present UI mockups to the Product Management Team and pointing stories in collaboration sessions
• Worked with QA team to regress test tickets and see them through validation.
• Helped assist Back End team by creating tickets to update pdfs for Disclaimers and Terms and Conditions with the Storage team

Environment: Office Suite, SQL Server, SAL, Web Services, Atlassian Suite, Invision, POSTMAN, REST Client, SOAP UI.

Confidential, Fargo, ND

Specialist/Business Analyst

Responsibilities:

• Worked majorly on all the derivative products, annuities. Advanced Knowledge of all CDS products: total return swaps, credit linked notes, asset backed securities, and mortgage backed securities. Also, familiar with CDS trade legal documents and the underlying mortgage-backed securities features.
• Derived Functional Requirement Specifications (FRS) based on User Requirement Specification URS. Conducted user interviews, understood and articulated business requirements and further converted requirements into technical specifications.
• Responsible for translating Business Requirement Documents into functional specifications and test plans. Closely coordinated with both users and developers for arriving at mutually acceptable solutions.
• Created documents of the use cases and created the use case, activity, logical, component and deployment diagrams using MS Visio and Rational Rose to communicate clearly with the development teams.
• Redesigned web services methodology for the application while implementing reusability from different servers. Liaised with the technology team to derive Functional Requirements.
• Responsible for Risk Analysis to detect the risks associated with the development of the new system. Additionally, formulated a Mitigation Plan to remove or reduce risks of high severity and one that would have major financial impacts.
• Setup agile environment using JIRA, created user stories and assigned them to team members.
• Participated in sprint planning and review session for updating user stories in JIRA and noting down team feedback.
• Managed Change Requests from stakeholders by conducting extensive Impact Assessments to capture the expected consequence of such changes
• Responsible for creating and updating all documentation for the project, which required interacting with all concerned departments on a regular basis.
• Conducted Defect Validation using Test Director to screen the illegitimate defects raised by the QA and UAT teams before hitting Development.
• Developed a Credit Default life cycle process and prepared a power point presentation. Helped developers while they are preparing unit test cases and while preparing test plan.
• Developed documents for Credit Derivatives businesses and the end-to-end transaction lifecycle.
• Worked in product settlement, documentation, collateral & margining processes.
• Created cash flow models for Credit Default Swaps, Interest Rate Swaps, Total Return Swaps, Currency Forwards, Cross-Currency Interest Rate Swaps, Equity options, Structured products, Currency Futures, Options, Exchange Traded Funds (ETFs), and indexes.
• Prepared test cases and came up with a testing strategy for testing the Banking Application by analyzed the Business requirements and the Accounting, Budget, and Procurement systems.
• Developed Base line testing scripts for testing the future releases of the application using Test director. Participated in conducting Manual and Rational Tools for testing. Extensively used SQL for data integrity testing at the backend. Designed user and administrative privileges such as authentication.
• Documented workflow, Designed UI and results of business analysis and obtained sign-off from client on specifications.
• Created UAT/QA test plans, strong manual, functional, system and regression testing in an agile development environment.
• Worked with project team on: planning, analysis, requirements, design & testing and training for production implementations.
• Worked with the technical team to ensure that varied changes including configuration change requests submitted by the test team are logged, cross environment impact is assessed, and cross environment migrations are managed.
• Interacted with various members at the management level to understand business decision and analysis needs in order to generate appropriate and relevant data analysis reports. Extensively worked with Quality Analysts to make sure that the functionality meets requirements.
• Communicated with clients, settled credit derivative payments with sensitive clients and broker dealers, investigated the discrepancies and communicated with Middle Office, Front office to resolve the discrepancies on asset-backed credit default swaps.

Environment: Java, MS Office Suite, Visio, Quality Center, Jira, RestClient, Web Services.

Confidential, Fargo, ND

Business Data Analyst/ BI Analyst

Roles & Responsibilities:

• Gathered requirements and prepared Charter, Business Requirement Documents (BRD), System Requirement Specification (SRS) by interviewing Business Users, SME's or client.
• Setup bi weekly sprints in Rally for team’s Agile Scrum environment and conducted sprint review session to discuss the challenges faced and how one ca go about improving upon them in next sprint.
• Facilitated Joint Application Development (JAD) sessions and walk in interview with the business users to gather requirements.
• Created Use Case diagrams and Activity diagrams to depict the interaction between the various actors and the system in MS Visio for the Business Use Case and System Use Case. Translated use cases to user stories. Calculated and assigned timeframes, points for each user story in Rally for migration planning and bringing each module from other system into Johnson Control’s system.
• Used Power Designer to articulate and design UML: Use Cases Diagrams, Activity Diagrams and Sequence Diagrams adopting Agile/Scrum methodology. Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Created documents like the Business Glossary to facilitate the other teams in understanding client business.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector, and from excel, after its initial release and state’s procurement of license. Worked with Power BI and used dashboards from Tableau to make it more attractive.
• Proactively created report formats and delivered personalized messages from the BI platform through TableauServerto a wide range of users.
• Worked with SharePoint for managing the document repository for all project documents and sharing Power BI and SSRS reports across business users using SharePoint server.
• Worked with SharePoint Designer and server for creating wiki articles and publishing them for other teams to view and review by team members.
• Ran SQL queries as required for reading, loading, updating and testing data residing in different databases (Oracle, SQL Server). Created Stored procedure and triggers. Scheduled database jobs with DBA team to according to migration timelines to migrate the data from old system to new system. Wrote SQL queries for generating the reports in SSRS.
• Used Visual Studio to create SSIS ETL packages for performing source to target mapping and transformation.
• Designed the DataMart schema with Architect, DBA and technical lead for creating star or snowflake schema for the databases and using the best suited one based on business needs and reporting.
• Created Data repositories and reports using Informatica. Used Informatica to import health care data from 3rd party vendors and data warehouses. Additionally, used for data quality, data manipulation, data migration and source to target mapping.
• Performed UAT Testing for users with reference to the RTM document. Performed unit, functional tests according to Test cases and FRD specifications.

Environment: SnagIt, Office suite, SQL Server, Web Services, SOAP UI, Rest Client, Jira, Tableau.

Confidential, Chicago, IL

Specialist/Business Analyst

Responsibilities:

• Worked majorly on all the derivative products, annuities. Gained advanced knowledge of all CDS products: total return swaps, credit linked notes, asset backed securities, and mortgage backed securities. Also, familiar with CDS trade legal documents and the underlying mortgage-backed securities features.
• Derived Functional Requirement Specifications (FRS) based on User Requirement Specification URS. Conducted user interviews, understood and articulated business requirements and further converted requirements into technical specifications.
• Responsible for translating Business Requirement Documents into functional specifications and test plans. Closely coordinated with both users and developers for arriving at mutually acceptable solutions.
• Created documents of the use cases and created the use case, activity, logical, component and deployment diagrams using MS Visio and Rational Rose to communicate clearly with the development teams.
• Redesigned web services methodology for the application while implementing reusability from different servers. Liaised with the technology team to derive Functional Requirements.
• Responsible for Risk Analysis to detect the risks associated with the development of the new system. Additionally, formulated a Mitigation Plan to remove or reduce risks of high severity and one that would have major financial impacts.
• Managed Change Requests from stakeholders by conducting extensive Impact Assessments to capture the expected consequence of such changes
• Responsible for creating and updating all documentation for the project, which required interacting with all concerned departments on a regular basis.
• Conducted Defect Validation using Test Director to screen the illegitimate defects raised by the QA and UAT teams before hitting Development.
• Developed a Credit Default life cycle process and prepared a power point presentation. Helped developers while they are preparing unit test cases and while preparing test plan.
• Developed documents for Credit Derivatives businesses and the end-to-end transaction lifecycle.
• Worked in product settlement, documentation, collateral & margining processes.
• Created cash flow models for Credit Default Swaps, Interest Rate Swaps, Total Return Swaps, Currency Forwards, Cross-Currency Interest Rate Swaps, Equity options, Structured products, Currency Futures, Options, Exchange Traded Funds (ETFs), and indexes.
• Prepared test cases and came up with a testing strategy for testing the Banking Application by analyzed the Business requirements and the Accounting, Budget, and Procurement systems.
• Developed Base line testing scripts for testing the future releases of the application using Test director. Participated in conducting Manual and Rational Tools for testing. Extensively used SQL for data integrity testing at the backend. Designed user and administrative privileges such as authentication.
• Documented workflow, Designed UI and results of business analysis and obtained sign-off from client on specifications.
• Created UAT/QA test plans, strong manual, functional, system and regression testing in an agile development environment.
• Worked with the technical team to ensure that varied changes including configuration change requests submitted by the test team are logged, cross environment impact is assessed and cross environment migrations are managed.
• Interacted with various members at the management level to understand business decision and analysis needs in order to generate appropriate and relevant data analysis reports. Extensively worked with Quality Analysts to make sure that the functionality meets requirements.
• Communicated with clients, settled credit derivative payments with sensitive clients and broker dealers, investigated the discrepancies and communicated with Middle Office, Front office to resolve the discrepancies on asset-backed credit default swaps.
• Appointed by senior management to work on process efficiency that would help the team reach their quarterly goals of reduction in breaks. On joining the team, created a macro system to streamline the process of cash settlements. Created the dynamics and mechanics of two major macros and programmed for large settlement database every month and for settlements on a daily basis.
• Worked with the Information Technology teams on coupons, shortfalls and reimbursement reports for the entire team.
• Communicated with Middle Office on bookings and payments for clients and broker dealers.
• Worked with global clients, sales, strategist, traders and middle office to calculate structured product Credit Default Swaps (Credit Derivatives or CDS) interest, credit event fees, shortfall and reimbursements.
• Researched payment discrepancies to confirm compliance with ISDA Agreements.

Environment: Java, MS Office Suite, Visio, Axure RP, Quality Center, SharePoint, MS Project.

Confidential, CA

EDI Analyst / Business Systems Analyst

Responsibilities:

• Worked closely with product managers and other architects to develop an understanding of the business needs. Collaborate with architects and development teams to come up with high-level systems design that is aligned with
• Decomposed high-level business requirements from Business and develop lower-level stories/tasks that can be readily assigned to various project team members.
• Collaborate with architecture and development teams to document assumptions and provide software development estimates for new business features, identify dependencies and risks, and work with team to minimize, mitigate and/or workaround risks.
• Continued growth promoted to EDI Analyst/BSA maintaining all EDI support for Nike Team Sports; Team & Licensed apparel business EDI trading partners.
• GS1-128 carton label setup - determine format to meet the customer’s needs, achieve buy-in from customers, submit samples and implement
• Conducted gap analysis and use analytical skills to identify gaps
• Mastered EDI Processes-Setup, to test and implement all mandatory EDI mapping
• Monitored all EDI data communication and troubleshoot/solve all errors
• Developed and execute test strategies, plans, scenarios, and track resolution to identified defects
• Verbal and written communication is clear, concise and moves others to take action
• Created EDI documentation processes and procedures for high level users
• Partnered with internal Customer Service Team and sales to train and mentor on EDI processes/procedures
• Assisted in developing a tool; -EDI Handler- which enabled Customer Service to view and create EDI PO s
• Understand and practiced the basic concepts of project management methodologies; scope, time and budget
• Identify and resolve end user EDI issues in a timely manner
• Solidified networking abilities within the Nike Supply Chain
• Demonstrated effective meeting facilitation
• Participated in all Team Building events