SUMMARY

• Business System Analyst with 8+ years of experience, delivering sustainable solutions, across various fortune 500 organizations, with an in - depth knowledge and involvement in software development lifecycle, including proficiency in data mapping and work flow. Adaptive thinker, and deadline driven professional with proven excellence in delivering project artifacts and deliverables.
• Experience in liaising with business and technical stakeholders, Stakeholder Management, and SMEs.
• Experience in Software Development Life Cycle process which includes Waterfall and Spiral methodologies, and Agile Scrum.
• Experience as a certified Scrum Master, and adept in making User Stories, tracking velocity, and promoting a winning atmosphere in an agile environment.
• Experience in requirement gathering & elicitation techniques, with active participation in discovery sessions, interviews, prototyping, document-reviews, brainstorming, and requirement workshops.
• Experience in conducting Joint Application Development (JAD) sessions with end users, SMEs and stakeholders.
• Prepared pertinent documents like Scope Document, Gap Analysis Document, Business Requirement Document, System Requirement Specification, Functional Requirement Document.
• Experience in SWOT analysis, requirements analysis, Data Analysis, Impact analysis, Cost Benefit Analysis, Root Cause analysis and demonstration by the ability to research and to apply problem solving skills to complex technical problems.
• Developed Test Cases and Test Plans for Functional and Non-Functional testing, as well as facilitated UAT.
• Proficient in creating SQL Queries for Data Population, Data Validation, and Data Integration.
• Simplified existing applications & integration architecture & build for scalability utilizing SOA as the framework.
• Experience in Project Management, Business Process Mapping (BPM).
• Experience in creating Test Plan and Test Cases for Functional and Non-Functional testing.
• Extensive Knowledge of Financial Analysis, Forecasting, Valuation, Planning, and Budgeting.
• Worked on System Integration projects involving source-to-target mapping.
• Experience with Data Warehouse (DWH) system including OLAP concepts, Data warehouse modeling including star and snowflake schemas, concepts around Facts and Dimensional tables and how ETL and reporting tools work in DWH environment.
• Coordinated with Project Manager to create Work Break Down Structure (WBS), manage schedules, deadlines, resources and the project tasks using MS Project.
• Involved in Project Management activities like defining / managing project scope, schedule management, creating project plans, tracking and communicating project status and deliverables.
• Experience in identifying Key Performance Indicators (KPI), Enterprise Risk Management, and Change Management.
• An active team player, and an individual contributor, with excellent business, analytical, communication, presentation, and management, technical and written skills.
• Strong analysis and communication skills with an ability to transform the needs of stakeholders into Functional/Technical requirements, and eventually into Business Logics, Validations, and System Specifications.

TECHNICAL SKILLS

Modelling Tools: Rational RequisitePro, HPALM, UML, MS Visio, Rational Rose, Mockup Screens.

Methodologies / Frameworks: SDLC, Waterfall, Agile-Scrum, DMAIC, Lean

Database: MS SQL Server 2012/2008/2005 , MS Access.

Web Technologies: HTML, CSS, JavaScript, XML, Java, .Net, C#, AJAX.

Languages: BASIC, LOGO, JAVA, UML.

BI Reporting Tools: Tableau, Crystal Reports, IBM Cognos 10 (report & Query studio), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).

ETL Tools: Data stage, Informatica, Pentaho, Tableau, Toad.

QA Testing Tools: HP Quality Center, JIRA, Load Runner, MS Test Manager 2013

Documentation Tools: MS Office Suite, SharePoint 2010/2013, JIRA, TFS.

Data Warehousing: Data Marts, OLAP, ROLAP, DOLAP, MOLAP, HOLAP, Query/ReportingMultidimensional Analysis, Data Mining, Slicing/dicing, Drill Down/Roll Up, MDM.

Finance: Securities, Derivatives, Bonds, Mutual Funds, ERP, Equities, KPI’s, Pricing, Brokerage, Stocks, Bloomberg Data, CRM, FINRA, Swift Payments, Chips, Fedwire.

Project Management Tools: MS Project professional, MS Project Server.

PROFESSIONAL EXPERIENCE

Confidential, Herndon, VA

Business System Analyst

Responsibilities:

• Responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans related to commercial lending.
• Transformed the needs of stakeholders into various requirements, and eventually into Business Logics, Validations, and System Specifications.
• Actively involved in creating DATA ELEMENT MAPPING between several distinct data models.
• Acted as a consultant and a liaison to designers and data developers, concerning DATA MAPPING, and service-oriented architecture.
• Identified data relationships as part of DATA LINEAGE ANALYSIS and discovery of hidden sensitive data as a part fo DATA MASKING.
• Outlined UML diagrams depicting process data flow, data transfers, and data requirements.
• Worked extensively with SMEs in understanding and documenting the interface analysis, enabling myself to define the technical boundaries of the project.
• Assisted with product evaluation, product customization, and system integration. Conducted GAP analysis around the identification of business rules, business and system process flows, user administration, requirements, and assumptions.
• Created wire frames and developed a prototype of the graphical user interface (GUI) and demonstrated to the stakeholders and business users and took feedback from them.
• Conducted JAD sessions, focus groups, requirements workshops, Interface analysis and prototyping to effectively understand the analytical reports needed by the internal clients.
• Attended SLA framing meetings and extensively retrieved URLs from UDDI for the system to consume the web service of the credit administration.
• Produced a weekly 4-Box’ report, kept the project manager and the team updated, and identified potential risks and issues.
• Involved in creating client side validations, server side validations, and data base validations.
• Worked with Database developers in framing stored procedures using SQL and webmethods to communicate with internal and external webservices.
• Designed and developed Use Cases, Use Case Diagrams, and Activity Diagrams using UML.
• Supported testing, Test Cases in HP ALM that would test various Test scenarios.
• Authored business requirements documents with the business users. Extracted, discussed, and refined business requirements from business users and team members.
• Involved in documentation during various phases of development life cycle.
• Stepped up as a Scrum Master and conducted Daily Scrum meetings in order to track the progress of the team and resolve any impediments, Scrum review, and retrospective meetings.
• Calculated velocity, framed burndown velocity chart, re-populated the release backlog with unfinished user stories, and guided the stakeholders with the slice of potentially shippable product at the end of every sprint.
• Coordinated with the developers to frame business engine accessible inter-departments, and formulated web methods enabling the CRM department to conduct collateral calls.
• Conducted daily triage calls between concerned developers and testers, thereby monitoring defect life cycles.
• Tracked defects in Quality Center and worked with QA team to resolve defects.
• Coordinated activities between business unit and technical staff, developed new methods, policies, and procedures to meet the business needs, as well as acted as primary trainer in educating the business units, related to business applications.
• Performed UAT on business requirements, technical specifications and domain knowledge.

Environment: Scrum, MS Office Suite (Word, PowerPoint, Excel, Outlook), MS Project, JAVA, Visio, UML, Lucid Chart, Microsoft Project, Oracle, MS Excel, .Net.

Confidential, Philadelphia, PA

Business System Analyst

Responsibilities:

• Involved in identifying the problem definition as part of continuous process improvement using define, measure, analyze and improve (DMAI).
• Extensively interacted with data analysts during the ETL operations in identifying the source files/databases and implementing the transformation logic for achieving data uniformity in operational data store (ODS).
• Collaborated with various organization segments inclusive of HR to identify their expectations and data requirements from BI reports.
• Involved in SOURCE-TO-TARGET MAPPING, maintaing formal description of the data structures including DATA DEFINITIONS, DATA FLOW DIAGRAMS, etc.
• Framed various webmethods and XML outputs in my DATA MAPPING table to covert business requirements into technical requirements, thereby crystal clearing the expectations and duties of
• Conducted JAR sessions with focus groups, requirements workshops, Interface analysis and prototyping to effectively understand the analytical reports needed by the internal clients.
• Coordinated with the DW architects and developers to identify appropriate dimensional modelling (identifying dimensions/facts/referential integrity), measures (additive/semi-additive/non-additive) and sizing (in terms of number of columns, records per dimension and fact table).
• Gathered business requirements and understood the goals of the data warehouse.
• Used Mockup screens to convey the look and feel of GUI screens for the end users to developers.
• Established Requirements Traceability Matrix (RTM) using Rational Requisite Pro to trace the completeness of requirements.
• Successfully analyzed the functional/non-functional requirements of the data warehouse for generating BI reports and communicated the same to architects and developers.
• Involved in identifying and suggesting the different dimensions (slowly changing dimensions/rapidly changing dimensions) required for generating the reports and OLAP cubes to facilitate the multi-dimensional view of the data to generate slicing/dicing, roll-up/drill-down reports.
• Used various SQL commands like Create, Delete, Update, and Inner, Outer, Left, and Right Joins to update the database and retrieve data for data analysis and validation.
• Used Unified Modeling Language (UML) to prepare Use Cases diagrams, process flow diagrams, sequence diagrams from the gathered requirements and created diagrams using MS Visio.
• Coordinated with Project Manager to create WBS, manage schedules, deadlines, resources and the project tasks using MS Project.
• Extensively interacted with the designers, developers to ensure functional implementation of business requirements and QA Team in executing Test Plans, Test Scenarios, and Test Cases.
• Extensively used SQL Queries for data analysis, system verification, and validation.
• Involved in Project Management activities like defining / managing project scope, schedule management, creating project plans, tracking and communicating project status and deliverables.
• Coordinated the execution of Unit Testing, System Integration Testing (SIT), Performance & Service level testing and User Acceptance Testing (UAT).

Environment: Agile/RUP, Java, MS Office Suite (Word, PowerPoint, Excel, Outlook), MS Project, Visio, UML, SharePoint 2013, SQL Server Services, Alfresco, Tableau, Cognos, Informatica, Mockup Screens.

Confidential, Houston, TX

Business System Analyst

Responsibilities:

• Interviewed business users to gather requirements and analyzed the feasibility of their needs by coordinating with the Project Manager and technical 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.
• Partnered with the business stakeholders, process owners, users to identify their requirements, produced detailed specifications, planned the project deliverables with the software development team.
• Developed Use Case diagrams by analyzing the business process to describe system interaction and functional requirements of the system.
• Created wire frames and developed a prototype of the graphical user interface (GUI) and demonstrated to the stakeholders and business users and took feedback from them.
• Coordinated and conducted joint application development (JAD) and walk through sessions involving business unit stakeholders, technical analyst, project managers thereby utilizing strong interpersonal, oral and written communication skills.
• Worked closely with Developers to review user requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications.
• Extensively worked in Data Mapping within the three-tier architecture, as well as with the external web service used.
• Involved in including the stored procedures in the system in order to fasten the request and response defined with data mapping.
• Tracked defects in Quality Center and worked with QA team to resolve defects.
• Prepared UAT test cases created a list of UAT users and conducted UAT along with them.

Environment: MS Office Suite (Word, PowerPoint, Access, Excel, Outlook), MS Project, MS SharePoint, MS Visio, DATA MAPPING, SCRUM, Java, MS SQL, Business Objects, Quality Center.

Confidential

Business System Analyst

Responsibilities:

• Designed, implemented and loaded dynamic questionnaire system onto the database to facilitate customer quantify their risk tolerance and determine their investment strategy.
• Designed and developed the dashboard for real-time stock information by embedding AJAX in the java script, as well as access to 10-year stock information, trends & behavior.
• Participated actively in the designing of web pages. Prepared a pilot cut(beta version)
• Developed good knowledge of Equities, Fixed Income, Bonds and Bond maturity, Bond Pricing, rate of return, horizon time, stock size, sector, style, and price to earnings ratio, debt to equity ratio, market risk, and volatility.
• Designed and implemented Portfolio risk analysis System to automate hedging of various investment portfolios.
• Used statistical mathematical formulae like standard deviation, variance, and distribution curve.
• Participated as a team member and Scrum Master in various agile projects.
• Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Identified the requirements of the stakeholders and created Business Requirement Document (BRD) and Functional Requirement Document (FRD).
• Conducted JAD Sessions with users, developers, and database design team to deal with backend synchronization issues.
• Created Use-Case Models to depict Actors and Use-Cases in various Business Processes.
• Responsible for numerous decisions in respect to business policies, procedures, methods for implementation.
• Developed EXCEL models for Portfolio Risk and Return Analysis, as a basis for complex trading packages designed by programmers.
• Performed What-if analysis using Excel as per the requirements of the managers.
• Created various types of reports/sub-reports and drill downs like standard and cross tab reports with bar chart, pie chart and line-chart graph, representation reports using Crystal Reports.
• Involved in implementing Business Process Management Notation (BPMN).
• Used UDDI to identify relevant web services.
• Created deployment flowchart in conjunction with the development, infrastructure, and network teams containing instructions for maintaining the Application.
• Worked with a team of 30 bright professional to reach our objective with extreme precision

Environment: MS Project, Visual Studio, Crystal Reports, SharePoint, Web Services, MS SQL Server, HTML, XML, SQL.

Confidential

Business Analyst

Responsibilities:

• Obtained and analyzed a detailed knowledge of the business environment for the project.
• Conducted JAD Sessions with various stakeholders and the project team.
• Analyzed end user problems including automated and manual business processes and identified, researched, investigated, defined and documented business processes.
• Studied the existing artifacts such as the BRD & SRS documents as well as implemented business and compliance rules such as FINRA specifications.
• Involved in identifying multiple significant cases, red flags and patterns associated with the laundering of illicit funds.
• Involved in writing the Business rules which helped the developers for developing the Business logics.
• Made sure the data was stored in a centralized database for quick access by my team.
• Prepared project deliverables such as Business workflow analysis, process analysis, user requirement documents such as Use Cases and managed the requirements using Rational Requisite Pro.
• Involved in gathering the Data requirements, data visualization, and data analysis and defining the data, implemented change control processes and updated the impacted business process documentation.
• Actively contributed throughout the entire Scrum process in daily stand-ups, backlog grooming, sprint planning, sprint review and sprint retrospective meetings.
• Involved in Client-side, Server-side and Database validations.
• Prepared Data Mapping for better understanding and created Web services for interaction between systems.
• Used UML methodology to prepare Use Cases from the gathered requirements and created diagrams using MS Visio for easy understanding by the technical staff.
• Followed Software Development Life Cycle (SDLC) using Agile Methodology (Scrum framework).
• Used MS Project Professional to manage schedules, deadlines, resources and the project tasks.
• Used Microsoft Visio & Rational Rose for data modeling and data Visualization by creating ER diagrams.
• Extensively used IBM Doors & Excel for Data Analysis, project process traceability and management.
• Implemented the testing cycle schedules, timelines, test plan and test cases for system testing and developed user training manuals.
• Worked in liaison with data modeler’s in creating comprehensive data tables (Schemas) and data marts for easy understanding by the stakeholders using Business Intelligence Tools, with developers on data repository to extract the relevant data and create data marts using ETL tools such as Informatica.

Environment: MS Office Suite (Word, PowerPoint, Excel, Outlook), MS Project, Visio, UML, SharePoint 2013, SQL Server Services, Tableau, Cognos, Mockup Screens.

Confidential 

Business Analyst

Responsibilities:

• Performed business analysis including process re-engineering and requirements elicitation for integrating all the disparate systems into one synchronized system.
• Conducted walkthroughs with the different department head to have a deeper understanding of the requirement.
• Created project plans to take into consideration projects’ mission, process flows, timelines, and requirements to document them.
• Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams using UML.
• Experience in the planning, User Accepted testing, and implementation of system enhancements and conversions.
• Facilitated Joint Application Development sessions to identify business rules and requirements and then documented them in a format for inter and intra departmental reviews.
• Documented the User Manual and trained the end users for the application.
• Learnt the activities and deliverables by being actively involved in all phases of Software Development Life Cycle.

Environment: Clear Quest, Microsoft Project, Oracle, UNIX, MS Excel and MS Access.