SUMMARY

• Over 8 years of experience as Business Analyst in the Information Technology Industry.
• In depth knowledge of Software Development Life Cycle process which includes Waterfall, Rational Unified Process methodology (RUP) and Agile Scrum.
• Active participation in discovery sessions, interviews, prototyping, document - reviews, plan setup, plan configuration with customers.
• Created UML Diagrams including Use Cases, Activity Charts, Sequence diagrams, Data Flow Diagrams and ER Diagrams using Rational Rose and MS-Visio thus defining the Business Process Model and preparing complex functional requirement documents.
• Capable in prototyping documents, models and attributes for consistency, completeness and risk minimization.
• Experienced in conducting Joint Application Development (JAD) sessions with end users, SMEs and stakeholders and Rapid application development (RAD) sessions.
• Involved in Client interaction and support to the marketing team. User meetings resolve implementation and performance issues.
• Experienced in Enterprise Business Analysis, Requirements Management, Software / Web Usability, Information Architecture, and Training Materials Development consulting services to corporate clients and maintaining SLAs.
• Simplified existing applications & integration architecture & build for scalability utilizing SOA as framework and Applied the "As Is" and "To Be" process designs in order to identify any potential process gaps and as well as improvement opportunities.
• Good knowledge of creating SQL Queries for Data Validation, Data Modeling, Data Integration and Data Warehousing.
• Experience with ALM(Application Lifecycle Management) tools like Rational Rose, Requisite Pro, Rational Clear Case.
• Experienced in TABLEAU DESKTOP 8.2, TABLEAU, SSIS, SSAS, SSRS and SharePoint.
• Accomplished at UAT (user acceptance testing), Functionality Testing, Unit testing, System Testing, Integration Testing and Regression Testing.
• Expertise in developing Test cases, Test plans and Test procedures in manual and automated test environments.
• Created Test Plan and executing Test Cases based on Design document and User Requirement document for testing purposes reports in Business Objects.
• Conducted GAP analysis, User Acceptance Testing (UAT), SWOT analysis, Cost benefit analysis and ROI analysis.
• Defects tracking prioritize outstanding defects in reporting system. Coordinate between development team and the management team to resolve any conflicts/defects in terms of requirements.
• Proficient in an array of continuous improvement tools centered on lean manufacturing and six sigma methodologies.
• Experience with implementation of Change Management, Content Management and Configuration Management effectively.
• Experience in General Ledger and Supply Chain management as well as designing solution for the same.
• Extensive knowledge of finance domain including but not limited to: Asset Management, Mutual Funds, Bonds, Exchange Traded Funds (ETFs), present value, future value, Credit risk management, Credit tracking, credit risk analysis, Trade Life Cycle, Fixed Income, portfolio management, Investment Banking, mortgage initiation, arbitrage, foreign exchange, options, asset allocation, SWIFT, amortization scheme, Derivative products such as Options and Futures, Sarbanes Oxley Act.
• Worked as a SharePoint developer with key responsibilities such as managing site collections, site configurations, site templates and web portal containing valuable information.
• Motivate team players with excellent business, analytical, communication, presentation, and written skills.

TECHNICAL SKILLS

SDLC: Agile Scrum, Waterfall, RUP

Supporting Languages: HTML, XML, SQL

PM Tools: Lean Management, SWOT, CBA, Clarity PPM, Impact, GAP, MS Project 2010, MS Office, MS PowerPoint

Modeling Tools: MS Visio, UML, Adobe Illustrator, Lucid Chart

Business Tools/Reporting Tools: MS Project, TABLEAU, TABLEAU DESKTOP 8.2, MS Visio, MS Excel, MS Word, MS PowerPoint, MS Access, Design Expert, JMP, Crystal reports, MS SharePoint

Supporting Tools: JIRA, Rational Requisite Pro, Rational ClearQuest, Rational ClearCase

Testing Tools: HP Quality Center, HP ALM

ETL Tools: Informatica 7, Informatica 9.0.1, IBM Cognos

Others: Oracle Documaker Studio, DB2, COBOL, VSAM, JCL, CICS, zOS

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Business Systems Consultant/Project Lead/PM

Responsibilities:

• Planned, supported and implemented an upgrade to Fee Management System Application; an effort to improve customer setup, payment processing and provide data integrity solution to reduce customer impact.
• Planned and implemented an upgrade from Internet Explorer 8 to Internet Explorer 11 for the legacy Fee Management System application, dealing with JavaScript fixes throughout the UI.
• Implemented a new package for Fee Management System application that enabled the system to better align with corporate goals and provide customers with flexibility of choosing the needed banking products and providing options of incoming fee deduct split into Commercial transfers versus Bank transfers (CTR vs BTR)
• Supported and implemented upgrade of FX currencies and Receiver side product allowing split of Bank transfers and Commercial transfers. Inclusion of new Repair Charges for organization’s revenue generation.
• Planned and implemented upgrade to the reporting tool Cognos, which now supports the legacy system’s data condition.
• Planned and supported Fee Management System JDK (Java Developer Kit) upgrade, update the underlying libraries.
• Planned, supported and implemented minimum payment limits at different levels for SWIFT, Fed Wire and CHIPS transactions.
• Assisted in the configuration, testing, and implementation of new technology infrastructures; implement administrative processes required to ensure optimum system operation.
• Developed standards and tools to service business operations; established governance models and worked as the focal point for related process areas and strategies.
• Established and integrated technology management policies to enforce and manage users, improve enterprise performance, and mitigate threats to service continuity.
• Communicated with all project participants and stakeholders throughout business technology initiatives, ensuring efficient business solution and communication throughout project lifecycles.
• Collaborated with stakeholders to assess business needs and translate requirements into effective technology platforms; align all development and administration efforts with business expectations.
• Educated end users by creating training documents, providing training session, and being actively involved with the user support to facilitate smooth adoption of new technologies.
• Using Mainframe to clear out transactions for routine processing.
• Supporting and implementing Dodd Frank, OFAC and GSMOS scans.
• Leading and mentoring BSAs and testers in multiple projects.
• Accomplished at UAT (user acceptance testing), Functionality Testing, Unit testing, System Testing, Integration Testing, Smoke Testing, Adhoc Testing, Spot Testing and Regression Testing
• Performed Data Analysis and Data validation by writing complex SQL queries
• Participated in QA meetings to discuss enhancements and modifications.
• Completed Defect tracking prioritization for outstanding defects in reporting system. Coordinated between development team and the management team to resolve any conflicts/defects in terms of requirements.
• Transitioned the documented business requirements into an actionable document by gaining approval from business user group.
• Gathered business requirements from business and converted them into technical document.
• Defined business needs and detailed requirements using case analysis
• Created SQL Queries for Data Validation, Data Modeling and Data Integration
• Created Test Plan and executing Test Cases based on Design document and User Requirement document.
• Involved in project release analysis, which included reviewing rejected defects, defects missed by QA and analyzing root cause and future actions
• Used MQJ to drop transactions in Integrated Fund Transfer Application and validate their processing in FMS.
• Created weekly and monthly UAT dashboards (status reports)
• Trained the entire team on running FMS Compares and creating dashboards.

Environment: MS Office Suite, MS Project, MS SharePoint, MS Visio, Hybrid, MS SQL, SSRS, MS Access, Quality Center, HP ALM, MQJ Explorer, Mainframe

Confidential, NYC, NY

Sr. Business Analyst/Scrum Master

Responsibilities:

• Involved in the SDLC phase of requirement analysis, design, and development of the intranet-based application.
• Facilitated user stories workshop. Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project specifications
• Prepared and analyzed the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Strong understanding of Data modeling in data warehouse environment such as star schema and snowflake schema.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral, Swim-lane Diagrams and creation of technical design (UI screen), UI Wireframes and Mockups using Microsoft Visio.
• Uploading, maintaining and distributing documents on MS SharePoint 2013.
• Created dashboards for a managerial overview with drill up and drill down capabilities using TABLEAU.
• Handling the design, development, testing and deployment of custom data warehouse systems.
• Performed Data Analysis and Data validation by writing complex SQL queries
• Prepared Logical Data Models that contained set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
• Identifying the appropriate data sources for loading data warehouse.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing (UAT).
• Conducted JAD/RAD sessions to allow different stakeholders to communicate their perspectives, resolve issues, and reach agreements.
• Worked on different Spotfire objects/visualizations like straight tables, line charts, bar charts and pivot tables etc. for dashboard design
• Extensively involved in Regression and Black Box testing, executing tests and tracking defects using Quality Center.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.

Environment: MS Office Suite, SDLC, Agile/Scrum, Tableau, RUP, SQL Server, UML, Tableau, MS Visio, Quick Test Pro, HPQC.

Confidential, Round Rock, Texas

Sr. Business Analyst/Scrum Master

Responsibilities:

• Conducted interviews, requirement workshops, focus groups, JAD sessions with SME, BO, Sr. Developers, Architects to further breakdown the requirements
• Studied current flow system of pricing, inventory and logistics department Confidential Inc.
• Gathered functional requirements for cloud web application, to meet the business requirements.
• Designed Graphic User Interface for mobile application with UI/UX team with Page flows, wireframes, page business actions and screen mock-ups, and also created dynamic GUIs in HTML and CSS
• Created static prototypes for internal application on iPhone and Android phones for Inventory control.
• Reviewed technical impact analysis, identifying and segregate relevant applications.
• Coordinated and assisted the team through designing, coding, testing, deploying, maintaining, and supporting client initiatives, by running sprint cycles
• Performed data mapping by understanding dependencies with other functionality and finding Critical Path Method
• Participated in Data base design sessions, Database normalization meetings. Worked closely with development team for SSIS, SSAS, and SSRS.
• Created XML schema using WSD to reduce redundancies in the development cycle
• Co-ordinated Post deployment support.
• Organized focus groups to discuss and ensure effective adoption of feedback to improve the usability of the mobile applications and web based applications
• Created data models and data flow diagrams for the TO BE process and performed Gap Analysis and analyzed AS IS and TO BE conditions
• Conducted Feasibility Analysis and Product backlog planning with the Product Owner.
• Maintained and kept track of stakeholder’s requests for enhancements and changes using Rational Clear Quest.
• Developed the business and functional requirement specification.
• Documented and prioritized the requirements.
• Created sprint burn down charts and release backlogs for effective Project Management.
• Utilized SharePoint as an administrator for document management, version control and creating team dashboards on the team site.
• Used Tableau for creating quarterly, monthly and daily basis summary reports for analyzing marketing conditions.
• Designed solutions to eliminate bottlenecks in the internal supply chain, by reengineering the demand forecast, production schedule and component parts.
• Worked with SQL queries to extract application data to perform application validations.
• Logged and tracked the defects using HP Quality Center. Created an error repository and managed the testing process with the QA team.

Environment: HPQC, UML, SCRUM, MS Access, MS Office, ASP, SQL Server, Tableau, Visual Studio, SDLC, MS Visio, BPMN, JAVA, VSM, SharePoint 2010, Version One, Informatica, Quest NetApp Solutions

Confidential, Charlotte, NC

Business Analyst

Responsibilities:

• Interviewed business users to gather requirements and analyzed the feasibility of their needs by coordinating with the Project Manager and tech lead.
• Identified and analyzed, defined opportunities for business process improvement, documented business processes and initiated efforts to make improvements.
• Contributed to the definition of scope, performed extensive requirement analysis and defined functional specifications.
• Involved in requirement scoping and identifying high priority requirements for implementation.
• Developed Use Case diagrams by analyzing the business process to describe system interaction and functional requirements of the system.
• Created wireframes and developed prototype of the graphical user interface (GUI) and demonstrated to the stakeholders and business users and took feedback from them.
• Worked closely with Developers for integrating the data from different databases for analyzing and reporting the data, and loading into the new system in the required form.(SSIS, SSRS, SSAS)
• Collaborated with DBAs to perform data mapping using MS Excel and executed complex SQL queries to filter data from the MS SQL database.
• Tracked defects in Quality Center and worked with QA team to resolve defects.
• Assigned problems to appropriate software development team for fixes.
• Worked with metadata management team and business data governance.
• Prepared UAT test cases created a list of UAT users and conducted UAT along with them.
• Provided live support and training for the end users.

Environment: MS Office Suite, MS Project, MS SharePoint, MS Visio, SCRUM, MS SQL, SSIS, SSAS, SSRS, Business Objects, Quality Center.

Confidential

Junior Business Analyst

Responsibilities:

• Collaborated with Stakeholders, (Subject Matter Expert) SME’s to get the requirements.
• Gathered functional requirements for cloud web application, to meet the business requirements.
• Designed Graphic User Interface for mobile application with UI/UX team with Page flows, wireframes, page business actions and screen mock-ups, and also created dynamic GUIs in HTML for better visualization and understanding of the software solution.
• Interacted with project managers, tech leads external teams and vendors to set the estimates for all the functional areas getting impacted.
• Participated in Data base design sessions, Database normalization meetings
• Extensively involved in Data mining, Data mapping and Data modeling
• Organized focus groups to discuss and ensure effective adoption of feedback to improve the usability of the mobile applications and web based applications.

Environment: Rational Requisite Pro, UML Use Cases, HTML, SQL, Use Case Documentation, MS Visio, TFS, Rational Clear Quest, SharePoint.

Confidential

Junior Business Analyst

Responsibilities:

• Interacted with the customers and internal stakeholders to gather user requirements and their expectations from the system.
• Involved in analyzing Business Requirements and developing System Specifications.
• Analyzed monthly/quarterly performance against plans and forecast and recommended corrective actions.
• Did rigorous load testing using Load Runner.
• Used Rational Rose to generate various UML Diagrams.
• Organized cross training of team members and users to become more responsive.
• Involved in incident reporting and change and configuration management procedures using Clear Case.
• Ensured that the modifications suggested by the users were incorporated into the application.
• Formed a bridge between the Project Manager and different teams with effective presentations.

Environment: Load Runner, UML, Clear Case, MS Access, MS Office, ASP, SQL Server, Visual Studio, SDLC.