SUMMARY:

• 8+ years of work experience in the IT field and have held titles such as Business Analyst, Accounting Systems Analyst, Business Systems Analyst in the IT field.
• Worked for small, medium and, also large corporations in functional as well as projectized roles.
• Been a part of teams in various domains, but my expertise lies in the Banking Domain.
• Extensive experience communicating with Subject Matter Experts (SME’s), performing Requirements Elicitation, Business Analysis, Data Analysis and Documentation
• Interaction and coordination with technical and non - technical clients through SAFe Agile processes and utilizing SCRUM ceremonies and artifacts
• Comprehensive knowledge of Waterfall SDLC, Rational Unified Process ( RUP ) software development process framework, complete UML Artifact, scope definitions, and AGILE development framework with AUP, XP & Lean
• Worked in a Scaled Agile Scrum environment preparing artifacts such as BRD, FSD, SRS and presented them in the Daily Scrum, Sprint Planning, Release Planning ceremonies.
• Very proficient in Data Modeling, Data Flow Analysis, Transaction Flow Analysis, Alternative Path analysis, Data Security and Active Directory
• Extensive experience in analyzing and documenting business requirements and system functional specifications including Risk and impact analysis, conducting JAD meeting sessions with various stakeholders and the end users
• Worked extensively on performing ‘AS IS’ and ‘To BE’ analysis, GAP analysis and drafted Project Analysis documentations
• Ability to work cohesively with all Stakeholders to formulate Functional models and prototypes to meet stakeholder expectations, and Workflow optimization
• Exceptional ability to visualize and develop fully integrated solutions by assessing current situations and business issues from people, process, and technology perspectives
• Strong understanding of Business Process Management, Business Process Reengineering, Business Process Modeling, Business Analysis and System Analysis
• Strong experience in Requirement Management, Change Control and CRM systems
• Knowledge in Active Directory integrations with setting user profiles with privileges and rights according to their roles and responsibilities
• Extensive knowledge of Object-Oriented Analysis, MS Office Suite, MS Project, MS Visio and gathering user requirements and technical documentation
• Proficient in analyzing and creating use cases, activity diagrams, class diagrams and sequence diagrams using MS Visio, thereby helping the development team in understanding the requirements
• Knowledge of US GAAP, General Ledger Accounting, and Asset Accounting
• Knowledge of Financial and Management Reporting, Forecasting and Capital Budgeting, and KPI reporting for the business
• Designed and implemented SQL queries using joins, unions, outer joins, group by and aggregate functions to extract data from different databases ( Oracle, SQL Server) for timely reporting and Validation
• Experience in working on DB front-end like TOAD and SQL Server Studio including installation through remote site, setting up logins to different databases and different schemas
• Very good understanding of Database concepts like Data Warehousing, Data Structures, Schemas , Data Marts, Data-Entity relationships and User Administration
• Created ERD diagrams with data flows to show the conceptual model of the Data Warehouse data structure.
• Created Activity diagrams, Sequence Diagrams to depict the business working of the system models.
• Created object and class diagrams with the help of the development team to structure code using Balsamiq and Lucid Charts.
• Helped prioritize functional and non-functional requirements based on the MoSCoW model
• Used the INVEST and SMART criteria to build upon the technical and business requirements.
• Practiced SWOT analysis on requirements, test cases, and project initiation strategies.
• Working proficiency in the STLC and Application Life Cycle of system maintenance
• Utilized the KANO model in user story prioritization from the estimated product backlog including defects, changes, and functional user stories.

TECHNICAL SKILLS:

OFFICE and GSUITE, Excel Super: User, Advanced Macros, Power-Pivot, Power-Query

Web Development Tool: DHTML, Visual Basic

Business Analysis: Tableau Reports, Rational Rose, UML, Blueprint

Reporting Tools: SQL Server Reporting Services, Hummingbird

Project Tools: MS Project, Rational RequisitePro, Rational Rose, MS Visio

Testing Tools: Load Runner, Win Runner, Rational ClearCase, Rational ClearQuest

Methodologies: SDLC, Waterfall, Agile, Spiral, RUP, JAD, RAD, Scrum, SAFe

Statistical Tools: SPSS, SAS (Base Programming for SAS 9, Essentials)

ETL Tools: Informatica Power Center 7.2.1/Cloud

Languages: Advanced SQL, Oracle, Java, J2EE

Database: Microsoft SQL Server 2005, 2008, PL/SQL, Oracle 9i/10g, Teradata, DB2

BI and Other Tools: Balsamiq, Tableau, Jira, HP ALM, XML, SOAP, Oracle SQL, Informatica, AEM, Salesforce Cloud, AWS, Actimize, Cognos, Erwin, Rally, SAGE, REACTJS, TABLEAU, ASANA, OFFICE SUITE /WINDOWS, POWERBI, Actimize, MANHATTAN, HBS, Confluence

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Sr. Business Systems Analyst II

• Transitioned into a senior role as a BSA and adapted to systems development for retail banking data analytics.
• Performed AS-IS analysis of business by document analysis and observation method.
• Was involved in the planning stages of the project which included artifacts such as Cost-Benefit Analysis studies, Feasibility reports.
• Played an important part in the project initiation stage with the sign-off from the product owner after the above studies and strategies were accepted.
• Elicited requirements for the DWH by techniques such as semi-structured interviews and JAD sessions and helped document them in an RTM/RTD
• Facilitated requirements workshops based on SCRUM and BPM principles.
• Participated in feasibility studies and lead the GAP analysis on the TO-BE model of the project by which resulted in UML flow diagrams and conceptual data models.
• Assisted the PM in preparing/modifying the project schedule with the work breakdown structures and the SCRUM meetings.
• Assisted the PM in report generation, performance charts, and conveying important statistics to the stakeholders.
• Analyzed source data from flat files and Oracle database.
• Built logic from business calculations after gathering functional requirements.
• Performed difficult data extraction using informatica reverse engineering the process from target data requirements according to accounting guidelines.
• Helped QAs in writing test cases, scenarios, fixing bugs, and automated codes.
• De-normalizing and analyzing data with the help of ETL tools and BI interface Talend
• Created a plan for a central data warehouse from individual data marts from retail banking information and legacy systems.
• Helped prioritize functional and non-functional requirements based on the MoSCoW model
• Used the INVEST and SMART criteria to build upon the technical and business requirements.

Environment: Oracle SQL queries on our normalized ODS such as retrieve account balance, OLAP calculations and operations such as drill across, Informatica Transformations such as Joiner, Aggregator, Lookup, Java, Oracle SQL developer 16, GitHub, SharePoint, HP QC ALM.

Confidential, Johnston, RI

Sr. Business Systems Analyst

• Lead requirements gathering using JAD sessions, Survey/Questionnaire, Interview sessions, Focus Groups and analyzed the feasibility of the requirements and formulated and conducted GAP Analysis to derive requirements for ACH processing.
• Conducted PV FV formula, Cost Benefit analysis, Feasibility check, Impact analysis, Cost analysis, and evaluated Porter’s Five Forces.
• Coached the team and Implemented software methodologies including Agile (Scrum) Scrum - waterfall Hybrid.
• Interacted with SME’s, asking detailed questions and carefully recording the requirements in a format that can be understood and reviewed by both technical and business people.
• Created Mock-Up Screens and Wireframes using User Interface components for client verification.
• Adopted Entity-relationship modeling technique and developed Conceptual and Logical data model for DFI tables.
• Logged Data Mapping documents of various HTML field to XML tags and further onto tables stored in database.
• Conducted User Story Writing sessions and determine Acceptance Criteria for Potentially Shippable Product Increment.
• Helped the Product Owner to Prioritize the Product Backlog items for developing Sprint tasks by taking suggestions from the cross-functional development team.
• Highly proficient in writing and prioritizing user stories in Product Back Log with Product Owner.
• Analyzed the Iteration Burn Down charts and reviewed defects.
• Used JIRA for issue tracking, user story management and requirement traceability.
• Worked with the Product Owner during the Sprint Review Meeting for the Potential Shippable Product Increment (PSPI) and help decide which feature are DONE and satisfied using the Acceptance Criteria.
• Generated ad hoc SQL queries using joins, database connections and transformation rules to fetch data from the SQL Server database systems.
• Assisted with User Acceptance Testing, developing and maintaining quality procedures, and ensure that appropriate documentation is in place. Assisted in Black box, UAT and Regression testing.
• Extensively involved in the User Acceptance Testing phase to ensure the requirements and functionality of the system was in accordance to the users and their feedback was incorporated.
• Conducted Risk analysis as required by NACHA and maintained a Risk Register adhering to FASB and SOX guidelines.
• Communicated effectively across company contacts and clients regarding requirements, schedules and launches.

Environment - Java, Oracle SQL developer 12, GitHub, SharePoint, HP QC, Scrum - waterfall Hybrid, MS Visio, MS Project, MS office, Asp.net, C# .net 4.5, MS SQL server 2012. Visual studio 2013, JIRA 5.2, Tableau, MS Office Suite (MS word, MS Excel, PowerPoint), IAS 2012.

Confidential, Santa Clara, CA

Business Systems Analyst

• 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 via Load Runner.
• Assessed business priorities and advised business units on risks and Cost-Benefit analysis.
• Used Rational Rose to generate various UML Diagrams.
• Headed the creation of working walking skeleton of the integration model in our Initial Sprints.
• Organized cross training of team members and users to become more responsive.
• Participated in the development and preparation of the Test Plan with the testing team as well as ensuring testability, reliability, usability, maintainability and performance of the application.
• 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.
• Conducted User Acceptance Testing (UAT)
• Performed feasibility of the project by doing CBA whether the costs outweighed the savings we would make
• Built data models using root-cause analysis on the different problems and solutions for it
• Conducted brainstorming and focus group sessions to narrow down on the issue
• Facilitated an AS-IS analysis the problem and documented TO-BE of the solution in a BRD
• Helped developers build FRS for the correct implementation of the integration solution
• Developed webhook API code for the tracking and time tracker by external vendors.
• Enhanced the existing data warehouse to SCD 6 model to solve the anomaly discrepancy.

Environment: - JIRA -> GIT ->Maven->Selenium->Jenkins->Splunk->Product,

SCRUM, Spiral, Talend, Eclipse, Oracle, PHP, IBM web-services, Microsoft Dynamics.

Confidential

Operations Analyst

• Utilized Informatica for Extraction, Transformation and Loading; IBM Cognos for report generation of the data to be analyzed from the data warehouses and data marts.
• Created the following types of documents mainly: Functional Requirement Specification (FRS), Functional Test Summary, Chance Control Documentation and Validation Specification.
• Prepared Requirement Traceability Matrix and interacted with QA team to ensure quality of software.
• Was involved in creating the Project initiation document (PID)
• Was responsible for Cost benefit analysis, Risk assessment, and SWOT analysis.
• Wrote Business rules pertaining to shipping functionality.
• Was also responsible for resolving impediments during the entire project life.
• Handled Requirement churn during the project by performing Impact Analysis by checking the feasibility in maintaining the Triple Constraint.
• Used Web Services to connect the shipping services to the existing system with SOAP API.
• Logged and tracked the defects using HP ALM and created an error repository and managed the testing process with the QA team.
• Designed data models and conducted normalization and de-normalization of data to fit OLTP and OLAP frameworks, slicing and dicing of data marts for analytical decision-making support.
• Facilitated DA in Creating Staging Area, Source, Target Databases for ETL and mappings within LMA, ACBS and collateral accounts using Informatica.

Environment: SDLC Waterfall, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), MS Project, MS Visio, HTML, CSS, JavaScript, Asp.net, C# .net Visual studio, MS SQL 2008, IBM Cognos. Agile-Scrum, Oracle, Java, XML, Java Script, Oracle Warehouse Builder, Rally, TFS, MS Access, MS EXCEL, MS Word. Informatica PowerCenter RMWD modules, PowerBI & PowerQuery.

Confidential

Supply Chain Analyst

• Gathered non-functional requirements from different source systems - TMS, WMS, ERP, CRM, OMS for compatibility with the integration procedure.
• Performed CBA, and made project schedule with CPA using MS VISIO resulting in a go signal for the project
• Wrote business use cases and scenarios to measure project milestones using MS PROJECT
• Generated reports for my manager through PowerBI, and flow charts for the integration mapping
• Used Talend for the integration and placed error/bug checks and validation for the data to match the target schema.
• Connected API using SOAP UI to the external service providers by writing XML codes to the TMS, OMS, WMS, and CRM/ERP systems via creating a software module integrated to the ERP with a UI available to the customer service team and customers.
• Helped developers develop the UI vertically with MVP, tweaking the API feature by feature using conceptual models and assisted in code integration from repositories.
• Helped designers connect the UI to backend with Java codes through continuous deployment and continuous delivery principles.
• Performed risk analysis at every stage.

Environment - Node.js, Java, Apigee, HTML, Jenkins, Bamboo, XML, SAP HYBRIS, PowerPivot