PROFESSIONAL SUMMARY:

• Qualified professional with over Six years of extensive experience in the field of Business Analysis, working with the technical staff to implement management and staff's business requirements into the software application in retail and Banking environments.
• Hands on experience and working knowledge of Software Development Life Cycle (SDLC), Agile/Scrum, Waterfall, and analyzing Statistical Data.
• Worked closely with project stakeholders, SMEs, and staff to understand the requirements and specifications for new applications along with enhancements to the existing applications.
• Experience in documenting requirements using Unified Modeling Language (Initial/High level Use Cases and Activity Diagrams) and building business process flow charts using MS Visio to communicate project functionality to the development team.
• Hands - on experience in conducting Cost-benefit analysis, Risk analysis, Return of Interest (ROI) analysis,
• Requirement Traceability Matrix (RTM), GAP analysis, SWOT analysis and User acceptance testing (UAT).
• Conducted JAD sessions, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications
• Experience working as Joint Application Development (JAD) facilitator and meetings coordinator with excellent interpersonal skills.
• Performed UAT and exposure to User Certification Testing (UCT) and Operational Readiness Testing (ORT)
• Expertise in understanding and supporting the client with Project Planning, Project Definition, Requirements Definition, Analysis, Design, Testing, System documentation and user training.
• Connoisseur in documenting
• Business Requirements Document (BRDs), Functional Requirements Document (FRDs), Non-Functional Requirements Documents, Use Cases, Test Cases and User Interface Prototypes.
• Skilled in writing SQL queries with understanding of Relational Database Management System (RDMS) and Business Intelligence (BI).
• Extensively worked and responsible for review and appropriate data sourcing of documents related to customer transactions that are flagged in according to AML / KYC compliance.
• Developed business requirements by analyzing the As-Is system and designing the To-Be system to streamline business strategies.
• Suggested improvements to business processes through better use of existing technology.
• Experienced in performing Business Process Reengineering/GAP Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Used SQL queries for the arrangement of customer data. Created and maintained end-to-end data mapping and data conversion spreadsheet.
• Creative and Enthusiastic Self-Starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments.

TECHNICAL SKILL:

Methodologies: RUP, Agile, Scrum, RAD, Waterfall and SDLC

Databases: Oracle, MS SQL Server, MS Access

Business Methodologies: RUP, RAD, JAD, GAP Analysis, SWOT Analysis, Root Cause Analysis, GANTT Charts, Python, C++

Languages: jQuery, JavaScript, Java, HTML5, CSS3, XML, SQL, PL/SQL

Defect Tracking: JIRA, Silk Central, Bugzilla

Bug Tracking Tools: Mercury Test-Director, Rational ClearQuest

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS)

Testing Tools: Quick Test-Pro (QTP), Test-Director, WinRunner, LoadRunner.

Office Tools: MS Project, Visio, Word, PowerPoint, Excel, Access, MS SharePoint

Operating Systems: Windows 8.1/8/7/NT/XP/Vista/2003, Mac OS X

PROFESSIONAL SUMMARY:

Confidential

Business Analyst

Responsibilities:

• Gathered and documented business requirements for existing and future business systems.
• Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Reverse Engineered the existing ODS in to Erwin.
• Responsible in writing & Execution of Test Plan and Test Cases for different applications like MBSG, PCC, Syndication Server. Etc.
• Defined Functional Test Cases, documented, Executed test script in Facets system.
• Generated test cases in Claims Analyzer Editor Professional to ensure unification with CPT-4 and ICD-9 codes
• Analyzed trading partner specifications and created EDI mapping guidelines.
• Generated test cases in Claims Analyzer Editor Professional to ensure unification with CPT-4 and ICD-9 codes. Worked on Implemented and Migration of HIPAA 4010/ICD 9/10, version for all EDI transactions.
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Reverse-engineer several databases, such as research, business, and clinical in order to extract metadata to leverage it for ETL design and reporting.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Used Query Analyzer, Execution Plan to optimize SQL Queries
• Created interface requirements documents which became the baseline and standard for all data exchanges
• Ensured that project requirements are properly tracked and documented.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• Worked in mainframe environment and used SQL to query various reporting databases
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting. Interface with internal customers. Provide ad-hoc reporting and analysis from data sources including PeopleSoft (SET) and Teradata
• Used Test Director, PL/SQL for testing the application
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Used different ad-hoc analysis, the Reports assist in defining strategy for each customer category. Informatica was used for ETL process and Business Objects 6.5.1 & XI R2 are used for Reporting duties.
• Tracked UAT issues/bugs and prepared reports.
• Capture and Formulation of Business Rules and delivery of Business Rules Templates.
• Creation of UML Diagrams including Context, Business Rules Flow, and Class Diagrams
• Created Business process workflow diagrams using Confidential business process modeler
• Implemented RUP recommended visual models to draft business requirements by using Use Case

Environment: Windows XP Professional, Oracle9i, MS Access 2000, MS Excel, RUP, SQL, UML, Agile, Rational Rose, Requisite Pro, Clear Case 2002, Rational Clear Quest 2002, Mainframe, MS Office suite, MS Visio 2003.

Confidential, Plano, TX

Business Analyst

Responsibilities:

• Implemented the entire Agile Methodology of application development with its various workflows, artifacts, and activities
• Gathered requirements from business users and analyzed them using Rational Requisite Pro by conducting user interviews, focus groups, surveys and document analysis.
• Collaborated with project manager to come with best security measure in the Salesforce CRM
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis
• Documented functional specifications to Confidential the loan approval process for home Confidential (from Confidential to servicing) and as well as non-functional specifications such as scalability, performance and reliability.
• Created standard and customized objects, tabs, and fields in Salesforce
• Developed reports and dashboards for data analytics and loan tracking
• Primary POC with the stakeholders to understand business needs clearly as well as develop relationships
• Assisted in providing thought leadership to evolve PMO best practices to abide by Laws and Regulations.
• Gathered business requirements through interviews, surveys, and observing from account managers and UI (User Interface) of the existing Brokerage Portal system
• Partnered with cross-functional teams to solidify requirements.
• Participated in the UAT for Customer/Loan Originator conversion for integration using Mercury Test Director
• Designed and developed Use Cases, conceptual model, behavior diagrams, Object-oriented Design (OOD) using Rational Rose according to the UML methodology as well as MS VISIO
• Used JIRA for Sprint storing creating, tracking and update for entire sprint.
• Acted as a liaison between business users and system development team during development process
• Noted any changes required to the existing system to help define the requirements needed for the new system using Confluence.
• Implemented a suitable Change Management process and supported the existing banking solution upgrade by coordinating multiple projects
• Supported IT & Risk Management in Business Continuity Planning for Item Processing department
• Developed and maintained the project plan using MS Project
• Participated and conducted scrum sessions with the Project Management team and QA Team meetings.

Environment: s: SDLC, Confluence, Agile Methodology, SharePoint, Selenium 2.0 - WebDriver, JIRA, SoapUI, Appium iOS/Android, T-SQL, Gherkins, Quick Test Pro, Java Web application, SQL, Java, JSP, Java Script, HP ALM, SOAP UI Web Services Tool, JMeter, XML, PL/SQL, SOAP-UI, SOAP UI.

Confidential - Buffalo, NY

Business Analyst

Responsibilities:

• Meeting with various stakeholders including Business, AML Governance, AML Operations, Testing, Application Support and Development team to perform Requirement elicitation process.
• Worked with the SME, Tech Lead and 3rd party vendors in gathering requirements and data
• Creating Business Requirements document, Functional Specifications, Technical Specifications and High-Level Design.
• Understanding the current business process, defining scope of the project along with vision statement.
• Actively participated in gathering requirements from various SMEs, Financial Analysts, Risk Analysts and Portfolio Management via JAD/JAR sessions.
• Involved in gathering the requirement with the SMEs to get the maximum information about the work-stream including Confidential Servicing, Loan Monitoring, and Asset Management.
• Created context sensitive on-line help files for a wholesale banking software. This involved creating animated help screens, writing RTF files, capturing screens, creating hotspots and compiling help files.
• Facilitated various JAD sessions with development architects and business leads to develop both high-level and detailed application architecture to meet business needs
• Managing Incident Management and Resolution (IMR) process and AML Data Quality Monitoring process.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational Requisite Pro.
• Responsible for reviewing, analyzing and identifying indicators of potential money laundering.
• Working experience with AML, KYC, BSA, OFAC & regulatory reporting guidelines and policies.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Successfully deployed both Actimize and Mantas custom compliance model implementations for various NYSE/SEC rules in Broker Compliance, Trade Compliance, Fraud (Payments) Solution, Private Banking Surveillance, Energy Surveillance domains.
• Written SQL queries for data validation and reporting.
• Strong knowledge and experience in Mantas AML software and has contributed to functionality imbedded in recent releases.
• Managed and helped write descriptive training and user manuals for Agile enablement project.
• Worked on data analysis of Mantas - Anti-Money Laundering (AML) Compliance data and supported user requirements.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• Provide support to the AML Compliance team for working on cases, securing all required advisory to the AML Compliance team in identifying the policy and process gaps for the cases they handle.
• Interaction with clients to understand a broad range of reporting requirements, and validating it with the regulatory requirements for reporting for a Prime Brokerage.
• Worked in the RUP Framework involved in iterations at each phase of the software life cycle.
• Developed business process models in RUP to document existing and future business processe.
• Responsible for establishing the initial customer risk assessment rating.
• Extensively Documented and created process flows and use cases for various scenarios involving shipping, transaction, transfer of goods etc.
• Assisting in identifying BSA/AML/OFAC compliance risk and ensures that proper controls, procedures, processes and training are in place to mitigate these risks.
• Assist AML Governance team in detecting, monitoring, analyzing, investigating, and reporting complex activity and relationships with respect to money laundering and terrorist financing to include recommending and assisting in the implementation of courses of action going forward.
• Wrote business requirements for the compliance department, to allow the Actimize compliance system to leverage off of systems installed by other areas of the company in an agile environment.
• Created alerts that complied with the Patriot Act that utilized customer rules and AML. Designed Actimize scoring rules for creating alerts.
• Responsible for Audit of Account Managers to ensure procedures for AML - KYC process are performed accurately.
• Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application and managed them using Rational Requisite Pro.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Identified opportunities to utilize data analytics (SQL, MS Access, MS Excel, and other data mining tools) to monitor, extract, transform and evaluate data.
• Designed and developed Use Cases using UML and Business Process Modelling.
• Used MS Visio for Process modeling and Business Process flow diagrams.
• Created test plans and scripts, facilitated user acceptance testing and tested strategies with developers and testing team.
• Designed and created Excel sheets to provide market analysis charts.

Environment: Microsoft Office Suite, MS Visio, MS Project, AML, Mantas, MS Visio, SQL, PLSQL, XML, Oracle, BI Reporting, VB, ASP, Crystal Reports, Mercury Test-Director, WinRunner, LoadRunner.

Confidential

Business Analyst

Responsibilities:

• Responsible for business analysis, requirement specifications, project planning and identifying the resources and implementation of the project.
• Developed the Project using the Iterative RUP model. The Project was streamlined through all phases of the RUP model starting from Inception through Transition. Used a Functional Decomposition strategy to divide system into sub-systems.
• Authored Computer Validation Report, which involved extensive research and interaction with SME's and our clients.
• Created business workflows on the claims module for the client to get a better understanding of the software and prepared a detailed BRD including all functional and non-functional requirements.
• UML was extensively used for specifying, constructing, and documenting the software system.
• Performed the Gap analyses of the earlier systems, generated a detailed Requirements document describing new system architecture through Use Cases and Activity diagrams.
• Created functional flow diagrams, context diagrams and other high-level diagrams for documenting the functionality of separate modules using MS-Visio and UML.
• Developed Class Diagrams, State diagrams and physical Component diagrams/ DFD's to capture the entire system functionality and thereafter built a framework for the software development phase.
• Utilized business and technical tools to develop business and system requirement analyses with supporting variance reports, current and target business process flows and traceability matrices.
• Designed message formats, queues, legacy systems interfaces, and worked with the business Users through interviews and JAD sessions. Created front-end prototypes as deliverables and projected the end-delivery modules.
• Prepared requirement specification, functionality trace matrix, quality assurance plan and designed test cases. Communicated with business, technology leadership for overall project/program office milestones.
• Prepared project charters to conduct professional meetings for the client and team members.

Environment: UML, RUP, MS-SharePoint, MS-Project 2000, MS-VISIO, CMMI, Quality Center, windows.