SUMMARY

• Self - driven, Proactive and Action-oriented IT Professional with 8 years of diverse experience in domains like Banking Finance and E-Commerce as a Business Analyst and Senior Business Systems Analyst.
• Built a strong relationship with key project stakeholders and business communities to comprehend the overall business vision for the project.
• Exceptional knowledge and comprehension of different software development methodologies such as Waterfall, Agile, Scrum, Waterfall-Scrum Hybrid.
• Excellent verbal/written communication skills; comfortable initiating conversations with both business and technology leaders.
• Expertise in design and documenting different artifacts including Software Requirement Specification, Business Requirement Document, Use Case Specifications, Functional Requirement Document.
• Assisted Project Managers in preparing Project Management Plans, Status Reports and Project Charter in MS Project and managing deliverables using Critical Path Analysis and Gantt Charts.
• Excellent in performing Impact Assessment, Cost-Benefit Analysis, Gap Analysis, SWOT Analysis to check the compatibility of the existing system infrastructure with new Business Requirements.
• Advanced knowledge of Banking, financial risk and Compliances issued by Regulatory authorities like FINRA, BSA, FRB, Credit Risk Rating and Loan Origination Systems.
• Elicited and gathered user and business requirements through Open Ended Discussions, Brainstorming Prototyping, Focus Groups, Interface Analysis, Document Analysis, and Requirements Workshop.
• Lead Joint Application Requirements sessions with the project sponsor, subject matter experts and end user representatives to minimize expensive rework or customer rejection once the system is delivered and help with Rapid Application Development activities.
• Successful intranslating business requirementsanduser expectationsinto detailed specifications employingUnified Modeling Language (UML), drawing UML diagrams, Activity Diagrams, and State DiagramsusingRational Rose & MS Visio.
• Conductedrequirement walkthroughsandUI walkthroughswith developers and QA team to help them understand the requirements and proactively identified feasibility issues.
• Developed Process flows, Wireframes, and Mockups to effectively conceptualize and communicate high-level design strategies and detailed interaction behaviors.
• Created and maintained Requirement Traceability Matrix (RTM) using MS Excel/HP QC.
• Collaborated in various types of testing like Functional (Black-Box), End to End Testing, Regression Testing, and User Acceptance Testing (UAT) Smoke, Integration, Functionality, Sandbox testing accompanied with expertise in developing Test cases, Test plans and Test procedures in manual and automated test environments.
• Extensive knowledge of SOAP/RESTful web services, AJAX, JSON, XML, XML Schema Definition (XSD).
• Used SQL queries to perform DML (Data manipulation language) operation to insert, update and delete the data for data analysis including joins, order by, and group by, procedures and functions.
• Profound knowledge in Big Data concepts including Hadoop Ecosystem consisting of HDFS, Name & Data Nodes, YARN with knowledge of libraries such as Pig, Hive, Flume, Sqoop, Spark, Impala, Kafka.
• Extensive knowledge in Data Migration using Data Warehousing concepts, migration from OLTP’s to OLAP cube using ETL tools such as Informatica Power Center; assisted Business Intelligence (BI) Team with Data Profiling to design intuitive dashboards for Business Reports through Tableau, Qlik View and IBM Cognos using Informatica Data Center.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Agile-Scrum, Waterfall-Scrum Hybrid, Scrumban

Business Skills: Gap Analysis, Change Management, Impact Analysis, Root Cause Analysis, SWOT Analysis, Project Planning, Budgeting and Scheduling

Languages: HTML, XML, CSS3, Java, C, C++, SQL

Web-Services: XML, REST, SOAP, JSON, API, AJAX

Databases: MySQL, SQL 2008/12, Oracle 9i, 10g, 11g (PL/SQL)

Big-Data: Hadoop, HDFS, Hive, HiveQL, Pig, Sqoop, MapReduce 2.0, Spark, Flume, Ambari, Kafka, HBase

Project Management Tools: HP-ALM, Rally, JIRA, Confluence, MS Project, MS SharePoint, MS Office Suite, VersionOne

Modeling Tools: MS Visio, Balsamiq, Mockup Screens, Erwin, draw.io

Analytics - BI Reporting Tools: MS SSAS, SAS, Excel, SSRS, Tableau, QlikView, IBM Cognos BI, Power BI, SAS Visual Analytics

ETL & Testing Tools: MS SSIS, Informatica Power Center, SAS Data Management, HP QC/ALM, Cucumber, Selenium, LoadRunner, SoapUI

Operating Systems: Windows, Linux, MacOS

Risk and Compliance: BASEL 1,2,3, CFPB, GAAP, OFAC, OCC, Dodd-Frank Act, Foreign Bank Organization and Volcker rules, Sarbanes-Oxley Act, Fannie Mae, Freddie Mac, Bank Secrecy Act, Investment Act, FINRA, FinCEN, MiFID 1,2, Loan Origination, Credit Risk, Market risk

Retail Banking: New Accounts, Checking and Savings Accounts, Statements, Pending and Cancelled Transactions,Reconciliation, Comprehensive Capital Analysis and Review

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, NY

Sr. Business Systems Analyst

Responsibilities:

• Interacted with the stakeholders to understand the current state of the system and defined future needs based on analysis of business requirements after implementing gap analysis.
• Highlighted risks in a timely manner by conducting SWOT Analysis, Cause-Benefit Analysis, Risk Analysis, Impact Analysis and ROI Estimation.
• Conducted JAD sessions for requirement elicitation and to allowed stakeholders to communicate their perspectives.
• Prepared ER Diagram, Use Cases and Data Flow Diagrams to communicate the page flow and financial user interaction with the CRM system.
• Facilitated Database Design sessions with Data Architecture and IT development team to define a DWH Design to meet Enterprise, Business, and Data processing requirements.
• Worked with the QA team for designing Test Plan, Test Cases, and Requirement Traceability Matrix for the User Acceptance Testing and Regression Testing, Black Box Testing and System Testing.
• Involved in generating Test Plans and Test Specifications, prepared test data for positive and negative Test Scenarios as per system specifications and requirements.
• Experienced in writing feature files in Gherkin language in Cucumber tool for BDD Testing.
• Used JIRA to create and manage sprint and product backlogs, to track issues, trace requirements.
• Involved in working with the Development team and the product owner in defining the acceptance criteria using Cucumber.
• Reduced risk and ambiguity by adding rigor to the Definition of Done and used domain knowledge and expertise to slice user stories based on business value.
• Created SAS datasets from Excel, Oracle database using SAS Macros.
• Used SAS/Access to communicate with Excel, Oracle & VBA for concatenation of all word files.
• Used SAS management console for importing data Analyzed data and producing tables and listings using Proc Mixed, Proc Lifetest.
• Extensively used different SAS procedures like Proc Means, Proc Summary, etc.
• Automated the Reports using SAS and Shell Script and thereby reduced the report production time from 2 days to 4 hours.

Environment: Waterfall-Scrum Hybrid, SAS Banking Intelligence Solution Suite 2.5, SAS HPA, SAS LASR Analytic, SAS MGMT Console 9.4, HiveQL, SQL, Hadoop, Hortonworks Data Platform, Apache Sqoop (v-1.4.6), Apache Spark (v-2.0.0), HBase (v-1.2.0), Apache Flume (v-1.5.2), Tableau (v-8.2.1), MS Visio, JIRA (v-6.3.3), HP ALM (v-11.0), Selenium (v-2.53) Cucumber (v-2.4.0).

Confidential, Baltimore, MD

Sr. Business Systems Analyst

Responsibilities:

• Managed the project by implementing Scrum development methodology.
• Reported status to BOs on time-to-time basis using MS Project for planning, scheduling, and status reporting.
• Assisted in Data Analysis to identify trends, patterns, correlations, and insights and present written business recommendations to the leadership in a clear and compelling way.
• Identified Source systems for financial data profiling of expenditure tracing and budget processes.
• Responsible for making Dashboard and modified representations to exhibit the reports according to business necessities that aided in vital choices and approved reports utilizing Power BI.
• Created Data Mapping Document after identifying facts and dimensions.
• Helped database developer in creating star dimension modeling and to create target database.
• Created Data Dictionary and have developed conceptual and logical entity relationship diagrams.
• Analyzed and Designed the Data Mart model using Star Schema model and assisted in increasing Data Integrity by performing Data Normalization and adding data verification and validation.
• Helped in developing slowly changing, rapidly changing and conformed dimensions and fact tables, based on the business requirement.
• Integrated the various OLTP to the OLAP by using Informatica ETL tool.
• Used Informatica in identifying business rules, and defining passive and active transformations like constant, look-up, data type conversion, and data transformation.
• Validated the request and response XML by verifying it against the XML schema and Defined the XML schemas to define the elements, sequence and data types for each element.

Environment: Agile-Scrum, HTML, XML, Oracle, Informatica 7.1, BO 6.5/ XIR2, Confluence, MS Visual Studio 2013, MS Office, MS Access, JIRA Rally, Power BI

Confidential, Boston, MA

Sr. Business Systems Analyst

Responsibilities:

• Conducted GAP analysis for AS-IS and TO-BE of the process to identify and validate requirements.
• Created UML diagrams like Use Case & Activity Diagram as well as created Prototypes using MS Visio to assist the development team and design team.
• Created the Project Change Request (PCR) process for the program to in corporate any new additions to the program after the scope is locked.
• Worked with QA team for designing Test Plan and Test Cases for UAT and regression testing.
• Manipulated the system for queries, reports and multiple screenshots by SQL Queries.
• Performed extensive data analysis using MS Excel and IBM Cognos to find a correlation between variables to establish Risk Baseline and validate it.
• Assisted the Data Warehouse team in designing a database schema and creating Entity-Relationship (ER) Diagrams to the proposed database.
• Collaborated with the ETL team to design the ETL process using Informatica Workflow Manager and communicate about the transformation logic and rules required for the new Datamart.

Environment: Waterfall, MS Visio, .Net Framework 4.0, MS SharePoint 2013, MS Project 2013(V15.0), MS Office, HP QC 11, Mock-up Screens, LoadRunner 11, Informatica Version 9.1, IBM Cognos.

Confidential

Business Systems Analyst

Responsibilities:

• Participating JAD sessions with SME’s and multiple teams for requirement gathering and refinement.
• Carried out an impact analysis of change requests, identified the effects on triple constraints and documented the Change impact document.
• Updated the BRD according to the results from CCB.
• Responsible for validating data that is passed between the front end and back end using SQL queries.
• Created Use cases, activity diagrams and Mock up screens using MS Visio and Balsamiq. Worked with UI team in creating GUIs using HTML.
• Used Share point for content management and document management.
• Created Requirement Traceability matrix (RTM) using HP QC tool and performed black box testing and functionality testing to test the major functionalities of the system.
• Used JIRA for allotting task and issue tracking, user story management, and requirement traceability.
• Tableau was used as a data visualization tool to communicate information clearly and efficiently via the statistical graphics, plots, tables, and charts selected throughout the project.
• Worked on documenting the request and response XML formats for the WSDL and worked on documenting the UDDI requirements for providing web services to third-party consumers.
• Responsible for validating SOAP API, XML documents in a service-oriented architecture.

Environment: Waterfall, Wireframes, SQL Server, MS Word 2013, MS Excel, MS PowerPoint, Visio, HP QC 11, SharePoint 2013, Tableau 8.0, Ajax, XML, Web Server, HTML 5.0, CSS3, JIRA.

Confidential

Business Analyst

Responsibilities:

• Gathered business & technical requirement from internal/external stakeholders thru elicitation techniques.
• Led and conducted a change management initiative to enhance a product workflow system.
• Implemented changes resulted in 33% growth in the relevant product development.
• Performed analysis to identify potential risk and took precautionary steps.
• Successfully led the transition of PPC project on different technologies and vendors to reduce the project cost.
• Planned and launched PPC project in 11 locations.
• Tracked & analyzed variation in product metrics using Google analytics for the Web/Wap, and App.
• Stats were communicated to the Mgmt. and the reasons were reported for any increase/drop metrics.
• Developed test plans for UAT phase, wrote step-by-step test cases and performed use case testing.
• Involved in drafting SLA, the MOM, performed quality oriented testing on the product in a joint effort with the internal technical team.
• Managed PAN India data collection & report delivery in a user-friendly format. Key role in ensuring data integrity and data management.
• Validated data in the reports against the database by developing optimized SQL queries.

Confidential

SQL Developer

Responsibilities:

• Incorporating all the build rules, writing the code using SQL*PLUS, PL/SQL and used SQL* Loader to load data into different tables.
• Mapping Operational Repository to Business Repository elements and incorporating the build rules.
• Monitoring of statistics taken by the process, narrow down most expensive and long-running queries to perform query optimization using SQL Server Profiler results and query plans.
• Based on the user selection, storing the output as a flat file for further processing for the next module.
• Extensively used SQL and PL/SQL in reports and involved Identifying and automating repetitive tasks.

Environment: Waterfall, HTML, CSS, Balsamiq, Erwin, Oracle 8i, PL/SQL, SQL*Plus, SQL*Loader, UML, Java, PHP, Navicat, SQL Server, MS Office, MS Project, SharePoint 2007