SUMMARY

• Professional Business Analyst with 8 years of experiences working in Banking Domain as well as Telecommunicating with key stakeholder and business communities to comprehend the overall business vision and the business process flow for each project and Requirement Gathering, Documenting and expertise in SDLC and Agile Frame work.
• Actively participated in all stages of Software Development Life Cycle(SDLC) methodologies such as Waterfall and Agile Methodologies such as Water - Scrum Fall Hybrid and Scrum, proven success in conducting as-is and to-be analysis, Gap analysis, Risk analysis, Impact analysis, Cost benefit analysis, ROI analysis.
• Domain expertise in Banking compliance like US GAAP/IFRS compliance and reporting, Statement analysis, Trend forecasting, SOX, FASB accounting standards Auditing assurance standards, Dodd-Frank reform, FINRA regulation, OFCA regulation, SARC regulation, clear understanding of Credit risk and liquidity risk.
• Experienced in CCAR regulatory reporting and provided requirements for CCAR Dashboard and CCAR stress test for banking balance sheet assets management and TSA module enhancement.
• Experience in Banking Data warehousing developed test-plan, test cases for the adjusting application identified BASEL data requirement and produced data mapping utilizing company standards, Processes and procedure.
• Extensive knowledge in banking standards for Customer Due Diligence (CDD), Customer Information Program(CIP), Anti-money laundering (AML) compliance, Know Your Customer(KYC), Enhanced due diligence(EDD), Special Customer Type (SCT), Wealth management customer risk types.
• Experienced in conducting Rapid Application Development (RAD) and Joint Application development (JAD) session, Interviews, Focus Groups, Brain Storming to converge early towards a design acceptable to the customer and feasible for the developer and to limit a projects exposure to the force of changes.
• Proficient in creating Risk Analysis documents, Risk Management Plan, User Requirement Specification, Functional Requirement Specification, Data Flow Diagrams.
• Expertise in performing in User Interface Design through Wireframes and Mock-ups, Familiar with conducting usability studies for the purpose of user interface and layout improvements.
• Ability to organize, document and track changes and defects using MR tools like Clear Quest, assisted UI
• Expertise in Gathering requirements, Analyzing them, Data modeling, Business process flows, Implementation plans, Writing business requirement document(BRD), Functional Requirement Document(FRD),Software Requirement Specification(SRS),Requirement Traceability Matrix(RTM), SWOT Analysis, Project Charter.
• Extensive experience in requirement documents, use case documents and design document such as Software design document(SDD), User interface design, Designing of application architecture, Created Work Breakdown Structure (WBS) and Perform Cost benefits Analysis, ROI analysis, Project Timelines and Project Schedules.
• Evaluated Change requests by performing Impact analysis on the Triple constraints of the project.
• Experienced in Extracting data from external sources, Processing and loading data files (ETL Process).
• Highly Proficient in Database concepts like Data Warehousing, Data Marts, Data-Entity Relationships along with knowledge of Data modeling, Normalization, Data Table Structure, Mapping Schemas, Data Marts and OLAP operations such as Roll-up, Drill-down, Slice, Dice, Pivoting.
• Knowledge of data warehouse architecture and designing Star Schema, Snow flake Schema, FACT and Dimensional Table, Physical and logical Data Modeling using Power Designer.
• Worked extensively with Data Modeling tools identifying the key elements and table structures to aid database designing, experience in Data Manipulating component definition for programming and writing PL/SQL queries
• Proficient at creating Data Mapping Document and identifying various transformation rules to cleanse the data and improving Data Quality by using Informatica.
• Understanding of Web Services like REST/SOAP using XML, WSDL and UDDI using internet protocol suite like HTTP under Three-Tier Service Oriented Architecture (SOA) was also involved in their testing using SOAP UI.
• Designed and implemented SQL queries Joins, Unions, Outer Joins, Group by, Order by and aggregate functions to extract data from different databases (Oracle, SQL server)for timely reporting and validation.
• Experience in coordinating UAT by developing Test plan, UAT test Scenarios, Test cases, Test data to be used in testing based on business and user requirement.
• Expertise in Back-end testing using SQL Queries on Database tables, Reviewing Performance, Reliability, Regression, Stress, Load and Volume Testing.
• Facilitated functionality testing such as Unit testing, Black box testing, Smoke Testing, System testing, Integration testing, Regression testing and Enhancement change management within various iterative models like agile and traditional methodologies like Waterfall.

TECHNICAL SKILLS

Business Skills: Business Process Analysis & Design, Gap Analysis, Impact Analysis, Data Modeling, JAD Sessions, Requirement Gathering, Requirement Elicitation and Documentation, Use Case Modeling, Change Management, Conflict management, Project planning, Project Scheduling, Project budgeting, Root-Cause Analysis, GAP Analysis, SWOT Analysis.

Domains Skills: Credit Risk, BASEL 1,2,3, Dodd-Frank Act, Foreign Bank Organization, Sarbanes-Oxley Act, Bank Secrecy Act, AML, NMLRA, SAR, CTR, KYC, PCI-DSS and FINRA

Methodologies: SDLC, Waterfall, Spiral, RUP, Extreme Programming, Scrum, Waterfall Scrum

ETL Tools: Informatica Power Center 8.x/9.x, SSIS, SSAS

RDBMS and Databases: Oracle 9i/10g, MS SQL Server 9.x/10.x, MySQL, Teradata, Cassandra

Reporting Tools: IBM Cognos BI, MicroStrategy, Business Objects, SSRS, Tableau

Project Management: JIRA, Confluence, Microsoft Project, MS Visio, Ms share point, Rational rows, Smart Draw, Mockup Screens.

Change Management Tools: Rational Requisite Pro, Clear Quest

Development Tools: Eclipse IDE, MS SQL Server 2005/2008, XML Spy, Erwin

Testing Tools: HPQC v10.0, HPALM v11.5, Load Runner, SoapUI, Selenium, BugZilla, Cucumber.

Web Development: Java, HTML, CSS, JavaScript, JQuery, XML, SOAP, RESTful

Operating Systems: Windows XP, Windows 10, Mac OS

PROFESSIONAL EXPERIENCE

Sr. Business System Analyst

Confidential - Warren, NJ

Responsibilities:

• Assisted in Designing BSA/AML documents that ensure compliance efforts are maintained in federal regulations and also documented the payment gateway platform business process.
• Analyzed SWIFT and MQ Series data volumes to derive data mapping, Operating SWIFT messaging service for financial messages, such as letters of credits, payments, between member banks worldwide.
• Interviewed Business users, stakeholders and Subject matter expert to determine business needs, gathered and analyzed the requirement from clients.
• Elicited requirements from business units and other stakeholder to gather functional and non-functional requirement using techniques like Document analysis, Joint application development.
• Conducted Cost benefit analyst identified and documented AS-IS and To-BE processes to meet capital requirement regulations for AML/BSA compliance.
• Assisted Product Owner in creating the user stories, grooming and prioritizing the product backlog and conducted the daily scrum in the absence of the scrum master.
• Prepared Business Requirement Document (BRD) and Functional Specification Document (FRD) from the elicited requirements and helped the product owner and developing Team in making user stories by using Three C’s and developing the acceptance criteria for them.
• Created various Reports and Report folders to assist managers to better utilize Sales force as a sales tool and configured various Reports for different user profiles based on the needs.
• Provided support ongoing salesforce.com maintenance and administration services including periodic Data cleansing, Custom objects, Workflows and Triggers.
• Created and maintained Requirement Traceability Matrix(RTM) to ensure all the requirements are fulfilled and ensure that the all the test cases are been executed according to the proposed plan.
• Developed several Use Case, Activity, Sequence and Swim lane Diagram using Visio according to the company’s template for better understanding and implementation for the developer and uploaded them into Confluence and linked the diagrams with the JIRA.
• Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application, planned and defined system requirements to Use Case, Use Case scenario and Use Case narrative.
• Assisted in generated SQL creation for user defined functions, Complex stored procedures, Query itemization and SQL scripts and Building reports, Scorecard, and Dashboards.
• Assisted in Developing SQL queries to fetch complex data from different tables in remote database using Joints, database links and formatted the results into reports and kept logs.
• Assisted in creating the Data profiling stored procedure using dynamic SQL as well as generating complex scripts to schedule using SQL to test various reports and ETL load jobs in development and QA.
• Created SQL Scripts to install create and drop database object, including tables, views, primary key, indexes, constraints, packages, sequence, grants and created the changes in the database according new requirement.
• Instrumented Informatica Power center we Extracted, Transformation and loaded into data warehouse.
• Involved with the designer in creating Snow Flake, Star Schema following the Normalization rules for Datawarehouse
• Assisted Test Engineers with Test scripts, Test cases and ensured that they met the requirements.
• OperatedAutomation Testing, White Box and Black BoxTesting, Business functionality and created Automation Scripts using Selenium and Cucumber.
• Groovy scripting and Restful Web Services.TestedSOAP-based Web Servicesfor enrolling customers information.
• Build Test plan and Test summary documents per SDLC standards and created Test Cases, Use cases and performed Unit &Integration testing.
• Collaborate withUI/UX, API and System teamsto support development initiatives Knowledge ofJSONinvolved.

Environment: -Atlassian JIRA, HTML5/CSS3, JQuery, JavaScript, Angular4.0, XML, JSON, NODE.js Ajax, Draw.io, VISIO, Informatica, Rational Rows, Tableauv9.0, MSofficesuite2013 (Excel, word, Power Center, Draw.io), Sales force, Selenium, Cucumber, Water-Scrum-Fall Hybrid.

Business System Analyst

Confidential - Wilmington, Delaware

Responsibilities:

• Developed and maintained Credit and analyzed data to give insights and optimize credit decision like accept, decline, Pricing and Credit line and build optimize existing customer management.
• Keeping up-to-date on application regulations and compliance requirements with possible interactions with the internal and external regulators and develop the analytical reports.
• Performed data analysis, feed analysis on the staging and data warehouse using complex queries and reporting tools.
• Mapped business functions t underlying data and data models, performed data reconciliations, gap analysis at function and data level for Basel III and CCAR reporting.
• Ensuring the Data quality by checking the completeness, consistency and accuracy of risk data for regulations of BASEL III and Comprehensive capital analysis and review (CCAR).
• Expertise in designing and developingAPIdocuments for bothWeb Services and REST services, Policy, SOAP, WSDL, HTTP, JSON, XML Tools palettes.
• Acted as a Liaison with the Business and functional owner to understand the risk associated with the complex products to prevent loss or other negative risk exposure to the bank.
• Performed elicitation like Joint Application Development and Focus groups to elicit functional and non-functional requirements to have a better understanding for the development team.
• Createdmock-upsand other creative whenever they were needed for illustration purposes.
• Design wireframes using MS Visio, created Email templates in Text HTML Visual Force necessary for application.
• Documented Business Requirement Document (BRD), Functional Requirement Document (FRD) using gathered requirement using SDLC policies and Guidelines.
• Maintained Requirement Traceability matrix (RTM) to have a complete track whether all the requirement and make sure that all the test cases are be mapped and executed accordingly.
• Designed Use case, Activity diagram and Swim lines using Visio according to the requirement so that the developer have a better understanding of the requirements and functionality.
• Worked on various Sales force Standard objects like Accounts, Opportunities, Leads, Campaign and Reports and developed business documents for Salesforce.com Custom objects.
• Involved in Business analysis and Technical Design session with business and Technical staff to develop requirement document and ETL specifications created dashboard by embedding reports and providing intuitive drilldown and exploit the benefits of analytics.
• Performed extensive data modeling to different between the OLTP and Data warehouse data model.
• Used SQL*Loaders to load bulk data from various Flat Files used SQL for DDL commands utilized SQL to createRiskssignals and Extract large subsets of data.
• Created Test plan based on User Requirement Document and prepared test case using Test Director/Quality Center to resolve the issues related to requirement during system testing UAT.
• Performed extensive Manual Testing to verify the application is complete and stable and identify the timelines for different kind of testing to be performed and estimate the risks involved.
• Performed Test data analysis and ensure data requirement are met prior to start of various testing.
• Performed BDD Testing using Cucumber Features in Gherkin format and wrote queries to extract the data for the Testing Purpose.
• Identified Software Defects and interacted with developers to resolve them and provided full support to the Test team using Quality Center

Environment: -Sale Force, Informatica, HTML5, CSS3, JavaScript, React and NodeJS, JQuery, XML/Json, SQL, Cumber, Gherkin, MS Visio, Mockup, MS office suite 2013(Excel, word, Power Center, Draw.io) Waterfall methodology.

Business Analyst

Confidential - Framingham, Massachusetts

Responsibilities:

• Designed and Operated and identifies the controls of the gaps and deficiencies in the design and controlled gaps and deficiency in design and escalate issues for product owner on timely basis.
• Performed the re-tests of Corporate Audit Division and control deficiencies and maintain and serve as a liaison with the business unit compliance officers other retail lending officers.
• Work collaboratively with business unit compliance officers to successfully implement any procedural change resulting from testing and monitoring and continuous observations.
• Collaborated with the Stakeholder very closely and produce requirements determine the feasibility and analyze the requirements determine the feasibility and analyze the requirement and recommend design solution option to the stakeholders and all other business units.
• Assisted and conducted the sprint planning based on the new backlogged requirement and lead few daily scrum meetings in the absence of the scrum master.
• Conducted the GAP analysis to understand and identify the deficiency of the existing applications and generated documents using software for Procedure research.
• Documented the Business Requirement Document (BRD)Functional Requirement Document(FRD) and was involved in writing the user stories and acceptance criteria for the functionality.
• Developed the Use cases according to the requirement gathered and created the use case and activity diagram to have the better understanding of the requirement and better picture for the developer.
• Analyzed and updated the test plan/Stagey for the customer information and managed the information and online payment options applications and database platform and generated the reports.
• Created dashboard using Informatica by embedding reports and providing intuitive drilldown and linked to exploit the benefits of analytical and develop the required documents and ETL specifications.
• Performed SQL queries to conduct back-end testing and performed UI testing on application web interface.
• Hands-on in usingSQL queriesto perform Data Analysis and Data Mapping onSQL Server Databases ExecutedSQL queries forextracting and modifying data from the database.
• Involved in the preparation of the Test data required for executing Test case and testingDifferent Web Services on SOAP UI tool with different response XML and JSON.
• Performed Regression testing on the application for testing validity of functionality in different versions application.
• Documented Manual Testing and also kept track of defects found during this testing. Designed and Documented Test Procedure and Test cases for user acceptance, functional and integration testing.
• Developed Test cases manually and generatedAutomationScripts using open source tools like Selenium Web Driver, SOAP UI, and Maven.

Environment: -HTML, CSS, XML, SQL, Migrated from angular2.0 to angular 4.0, NodeJS, bootstrap, JSON, Excel, Outlook, Power Point, Maven, Soap, Selenium, Informatica, Windows and Scrum methodology

Jr. Business Analyst

Confidential

Responsibilities:

• Performed requirement gathering and analysis by actively soliciting, analyzing customer requirements and prepared the requirement specification document for the application.
• Involved in gathering reporting requirement from the business users, Involved in building data warehouse application.
• Developed information cycle diagram, data flow diagrams, in MS Viso.
• Writing data mapping documents, data transformation rules and maintaining data dictionary, data migration and interface requirements documents to update Microsoft share point portal with the updated project documentation.
• Created logical data modeling using tools like CA Erwin data modeler.
• Able to analyze and map source to target mapping using client tool CDMA(Code and Data Mapping Application)to further develop enterprise data warehouse.
• Designed and created Data Quality baseline flow diagram, which includes error handing and test plan flow data.
• Applying Master Data Management (MDM) concepts for data alignment, maximizing analytics and business intelligence promoting corporate objective and initiatives.
• Gathered and updated requirement as per business user feedback and changes, involved in generating test plans and test specification as per business requirements.
• Prepared test data for positive and negative test scenarios as per application specifications and application requirement and wrote test plan.
• Validated ETL mappings and tuned them for better performance and implemented various Tuning techniques.
• Manually performed integration and build verification testing responsible for defect tracking and reporting participated in the bug review meeting.
• Created Test Plans, Test Cases, and Test Scripts for all testing events such as System Integration Testing (SIT), User Acceptance Testing (UAT) and Unit Integration Testing.

Environment: -DB2, CDMA, ERWIN, Data stage, Informatica, Cristal Reports, SQL, MS visio, Share point 2010, Quality Center

Jr. Business Analyst

Confidential

Responsibilities:

• Worked with client, Stakeholder and business owners to produce requirements, determine feasibility, analyze requirement and recommend design solution options and conducted Business process evolutions to gain technical knowledge of business requirement.
• Assisted to conduct the sprint planning based on new and backlogged requirements and lead daily scrum in the absence of the Scrum master.
• Gathered requirements and prepared Use Case (General System Design document and Detailed System Design Document) by interviewing Subject Matter Expert and End-user.
• Conducted Gap analysis to understand the deficiency of the existing application Architected and Developed Payment processing engine to process dealer’s payments.
• Involved in Business analysis and Technical design sessions with business and Technical staff to develop requirements document, and ETL specifications.
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of analytics managed the project in breaking down the existing EDW to manageable Data Marts.
• Performed SQL queries to conduct back-end testing and performed UI testing on application web interface.
• Involved in the preparation of the Test data required for executing Test case and testingDifferent Web Services on SOAP UI tool with different response XML and JSON.
• Used SQL Server Profiler to trace the slow running queries and the server activity and executed SQL task to insert transaction log data into the SQL table.
• Performed Regression testing on the application for testing validity of functionality in different versions application.
• Documented Manual Testing and also kept track of defects found during this testing and designed and Documented Test Procedure and Test cases for user acceptance, functional and integration testing.
• Tested Web services (SOAP and REST) using SOAP UI & HP services Test and application complete business flow.

Environment: -Ms-Sql Server, Data Warehouse Bus Architecture, Ms-Visio, UML, Quality Center, MS Office, JIRA, Hp ALM, People soft GL, XML, HTML, CSS, ANGULAR, NODE.js. WATER-SCRUM-FALL Hybrid

Jr. Front End Developer

Confidential

Responsibilities:

• Handled all aspects of the web application including maintaining testing debugging.
• Developed web presentation layer using JQuery, HTML, CSS according to internal standards and guidelines.
• Used Angular.js, JQuery, JavaScript, HTML and CSS for front end web designing.
• Created Dynamic web pages using web control and styling pages Using CSS and developed JavaScript.
• Built HTML template for high traffic and complex data driven websites.
• Used CSS in various Styles and responsible for coding and bug fixing.
• Involved in Unit testing of the application according to the Unit test case written.
• Used Data Grid, Data List and Data repeater to display data from the database and was involved in creating the stored procedure and the user Defined Functions.
• Coding of the web parts and lists and unit testing of the applications.

Environment: -Visual studio, CSS, JavaScript, HTML, object relational mapping tools, SOAP.XML, Visual Studios 2008, Windows Server 2003 and SQL server 2005, Visual Studio 2008 and Microsoft .net 3.0

Jr. Front End Developer

Confidential

Responsibilities:

• Used HTML, CSS, JQuery to create the front-end portion of responsive web pages.
• Designed CSS to develop text shadow, animation effect and elements that can be used by customer.
• Developed fast loading images using Adobe Photoshop and used JSON for sorting and exchanging information between browsers and servers.
• Played a key role in transforming the mockups to dynamic HTML pages.
• Involved in writing application level code to interact with the Web Service.
• Assisted in creating the Test Cases for unit testing.

Environment: - HTML, CSS, XML, XSLT, JQuery, Eclipse, Windows XP, Web services, Ajax, Angular.