SUMMARY:

• Confidential IT Business Analyst and professional project manager PMI© with 9+ years of experience in Investment banking, compliance, risk and regulatory processes, capital market, retail, and supply chain management including 2 years of programming experience using Java/J2ee technology.
• Wide range of skillset in eliciting, reviewing, auditing, and analysing requirements through interviews, JAD sessions, workshops, and existing system documentation, and create BRD (business requirement document), FNFRD (functional/non - functional requirement document), user stories, use case document, SRS (system requirement specification), technical specification documents, deployment documents, change requests, API, ER diagrams, data dictionary, test case generation, ETL process - source to target mappings, SQL joins and UML diagrams such as activity, class and sequence diagrams and flow charts.
• Expertise in studying and analysing business process model (BPM) “AS IS” & “TO BE” state, performing GAP Analysis, implementing strategic planning tool as SWOT Analysis, Cost Benefit Analysis, Project pre-feasibility.
• Lead the SCRUM team as a SCRUM Master and implemented core concepts of SCRUM methodology in Agile environment. Responsible for arranging and participating in meetings including product backlog grooming, sprint planning, daily stand-up review, retrospective, deployment, and Change Control CAB meetings. Served as the primary point of contact for all project-related issues and their resolution. Resolving conflicts with diplomacy and sensitivity in a timely manner to shield SCRUM team from outside distractions and interferences.
• Implemented Project management best practises including creating project charter from SOW and RFP, communication plan, work breakdown structure (WBS), schedule (time) and cost management strategies, resource planning, analysing, and identifying risks, root causes and its impact and risk mitigation strategies, defining business processes, manage and track project progress against the project plan, create project status report and communicate with sponsors and stakeholders.
• Huge expertise in Confidential Office suite including Excel, Word, Power Point, Visio, Share Point, SQL programming including writing PL/SQL query, stored procedure, and triggers with Oracle & SQL server database.
• Clear fundamentals about data warehousing concepts, including ETL, data gathering, data analysis, data management, data governance, data migration, data integration, data validation, data reporting, data modelling, data structure and data quality and ERP/CRM systems including SAP, JD Edwards, Confidential Dynamics Nav 365.
• Self-motivated, fast learner, and can work under tight deadlines with high pressure environment. Strong written, verbal and presentation skills, analytical & lateral thinking, negotiation, leadership, and interpersonal skills. Easily read, understand and debug programming code and can explain it to nontechnical users.

TECHNICAL SKILLS:

Technical Skills: SDLC, Agile, Scrum, CRM, SQL Server, Oracle PL / SQL, MS Office Products like Access, Excel, Power Point, Visio, Share Point, SAP ERP, JD Edwards, MS dynamics nav, ERP, CRM, ERM, Core Java, XML

Functional Skills: Investment, Capital market, Compliance, Risk and Regulatory, Stocks, FINRA, SEC, Retail Operations (POS), Ecommerce Order Processing, Supply Chain Management, Order to Cash & P2P (Procure to Pay) Cycle, Inventory Management (Procure, Replenishment Models, WIP, Finish goods), Production Planning, Warehouse Management (WMS), EDI transactions

PROFESSIONAL EXPERIENCE:

Confidential, NC

Sr. IT System Analyst

Responsibilities:

• Lead analyst responsible for eliciting, defining user stories in multi phased multi team cross functional project affecting many business groups.
• Discovered, investigated, and prototyped new solutions for process and system efforts. Prepared business requirement documents BRD, functional specification document FSD, and process flow diagrams to demonstrate current “As-IS” and future “To-be” process.
• Business liaison between business and development and QA team to fill the communication gap and responsible for smooth transition of requirements.
• Part of an agile value stream. Participated in daily scrum, weekly sprint planning and retrospective meetings. Worked with product owner and leads to identify and prioritize items falling behind on date commitments.
• Managed internal audit project successfully from start to finish.
• Involved in deployment process creating deployment documents and getting business approvals for the install. Validating the install after a few validation tests along with the QA team.
• Created Test scripts and test cases using HP ALM and linked requirements per RTM to make sure all the requirements are traceable.

Confidential, Baltimore, MD

Sr. Business Analyst/Jr. Project Manager

Responsibilities:

• Driven the project from initiation to closing phase implementing project management best practises per PMI specification.
• Understood and studied the business case and prepared project charter explaining high level requirements, acceptance criterion, key stakeholders, project assumptions and constraints.
• Created a clear and concise project communication plan including critical milestones, budget estimate, resource allocation, risk analysis, contingency plan and assign role & responsibilities, RACI Matrix to both execute and monitor project progress and periodically adjusted along the way as needed.
• Effectively communicate project expectations to stakeholders and deliver project progress report to project sponsors in a timely and clear fashion.
• Worked with risk management team to assess risks and strategies to mitigate them by implementing rules and contingency plans to prevent email misdirects.
• Participated in 2018 budget planning sessions and helped project manager in cost estimation, time management and prioritizing backlogs using MS Project.
• Demonstrated data analysis skills by writing advanced SQL quarries involving multiple tables and SQL joins which significantly reduced the time to fetch the result set.
• Created Test scripts and test cases using HP ALM and linked requirements per RTM to make sure all the requirements are traceable.

Environment: MS Excel, MS Word, MS Visio, HP ALM QC, JIRA, MS Project, Agile (SCRUM), Oracle SQL

Confidential, Owings Mills, MD

Sr. Business Solution Analyst /SCRUM Master

Responsibilities:

• Elicit requirements for multiple cross functional agile teams requiring various new features and enhancements for Enterprise Request Management (ERM) - Service Now using JAD sessions and multiple brainstorming sessions.
• Analysed requirements using various data modelling techniques like sequence diagram, activity diagram, workflow diagram etc. using IBM Blueworks live.
• Created and maintained business process documentation including BRD, FRD, workflows, RACI matrix, test cases, and requirement matrix (RTM) on MS Share Point.
• Worked 30% of the time as a SCRUM Master for a web development UI/UX project responsible for organizing sprint planning meetings, daily stand ups and creating burn down chart as the sprint progresses.
• Helped product owner to make the product backlogs in good shape and make them ready for the next sprint.
• Lead biweekly sprint planning, daily stand-up, and sprint retrospective meetings.
• Used JIRA as an Agile management tool to upload and maintain product and sprint backlogs, user tasks, and burn down chart.
• Experience in writing SQL queries in Oracle, and test case planning, specification and managing user acceptance testing using HP ALM.

Environment: MS Office, MS Excel, IBM Blue works live, Service Now, Enterprise Request Management ERM, HP ALM, Share Point, MS Project, Agile (SCRUM), Data modelling techniques, SQL, JIRA

Confidential, NJ

Business Analyst I

Responsibilities:

• Elicit requirements for specific integration between TVE, ERP systems - MIPS and JD Edwards to analyse GAP between existing business process model “AS IS” system and “TO BE” system.
• Prepare business requirement documents BRD, functional requirement document FNFRD, data flow diagram DFD and build data analysis logic for master data integration for firm’s all types of items, item suppliers and their geographic locations.
• Draw process flow diagram using UML diagram tool Visio mapping the new business requirements and ETL functionalities.
• Worked as data analyst on a project writing SQL queries using inner joins across multiple tables to identify duplicate vendor records to create exception report and dumped them into Excel sheet. Created small SQL script/stored procedure to merge duplicate records and delete redundant records under DBA’s supervision.
• Update and enhance existing functionality as well as work with UI/UX team to provide wireframe/mock-ups/prototype for new features to create and manage various types of supplier, their contract and identify attributes to be integrated with TVE web portal.
• Prepared UAT test cases and mapped them with requirements in RTM (requirement tractability matrix) to ensure all business requirements are being tested thoroughly.
• Used JIRA as project management tool to create and maintain user stories and product backlogs and for defect tracking.
• Involved in Agile (SCRUM) development methodology by participating SCRUM/Sprint planning meetings, daily stand-up meeting and helped scrum master track down Sprint burndown charts, task burndowns.

Environment: Agile, Scrum, MS Office, MS Excel, MS Visio, Share Point, JD Edwards ERP, JIRA

Confidential, WA

Jr. Business Analyst

Responsibilities:

• Conduct meetings with various suppliers to Onboards them for Drop Ship projects and exchanged requirements for packing slip and shipping label and instruction guide for setting up EDI connection, XML file format and Inventory data feed.
• Design and implement EDI 846 inventory feed and setup EDI 850 mapping rules in our SAP for purchase orders.
• Created EDI Maps for various EDI ANSI X12 standard documents (850, 856, 830, 862, 810, 997, 945, 940) and EDIFACT Messages (DELINS, DELJIT, DELFOR, INVOIC) using PaperFree ECMap.
• Researched and provided the logic for multiple sources of supply for single SKU for drop ship orders across US, Europe and Asian region based on the Plant, supplier, and SKU availability.
• Rescued one week for not getting project delayed by preparing, monitoring, and prioritizing project plan. Assigned right resources on right tasks by designing RACI matrix with project manager to achieve the deadlines.
• Designed logic for weekly dispatch schedule based on the order cycle and availability of product, use local transportation companies to set up XDX at warehouse for faster delivery from wholesaler to retail store.
• Define business process rules for SOB (Share of Business) process for optimizing procurement process to achieved 25% increase in smooth order cycle.
• Worked on defining rules in SAP to maintain info records for specific SKU, Supplier, and their plant location.
• Execute SQL queries using data analysis tool to verify data quality, QA testing and the code logics implemented as requested and prepared report using Excel.

Environment: MS Office, MS Visio, MS Excel, SQL Server, SAP, SharePoint, JIRA, EDI, ANSI X12, EDIFACT

Confidential, Silver Spring, MD

Java Programmer

Responsibilities:

• Worked under senior programmer’s supervision to implement new functionality using Java, JavaScript, JQuery, Ajax, JSON, JSP, Servlets and JSTL.
• Maintenance of existing application and development of new functionality as per the Business requirements using Java and Spring framework.
• Design and Develop components, UI interfaces and database using JSP, servlets.
• Wrote complex inner joins SQL queries and stored procedures.
• Implemented a SOAP based Web service using Axis2 framework with Jboss 4.2 GA with guidance from senior team members.