SUMMARY:

• Eight plus years of experience in analysis of large scale business system, in Banking, Manufacturing & Telecom Sectors.
• Experienced in authoring Use Cases, Functional and Technical Specifications, reporting and testing.
• Experience in working with different Software Development Life Cycle (SDLC) methodologies like Waterfall and Agile methodologies, for example, Scrum - Waterfall (Hybrid), Kanban, Scrum and Safe 4.0.
• Comprehensive knowledge of PCIDSS, OCC, OFAC, Banking Secrecy Act, FACTA, ECOA, Customer Risk Scoring (CRS), Know Your Customer (KYC), Sanctions Screening, Partner Due Diligence (PDD), Electronic Fund Transfer, Transactions Monitoring compliances and integration.
• In depth experience in Requirements gathering, Functional and Technical design docs, Data Cleansing and Process Flow diagrams, Data Analysis, Linear and conceptual data modelling.
• Hands on with SQL including Joins, Constraints, Indexes, Views, Functions, Primary Keys and foreign keys.
• Proficient in Database management systems, with queries such as Update, Create, Selection. Expert in query optimizations for Joining and Projection.
• Highly proficient in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling using Third Normal Form (3NF) and Multidimensional Data Modeling Schema for various business processes and environments.
• Experienced in developing Conceptual, logical models and physical database design for Online Analytical Processing (OLAP) and Online Transactional processing (OLTP) systems using ERWIN.
• Elicited the requirements using techniques such as survey/questionnaires, Brainstorming sessions, Requirement workshops, Document analysis and Joint Application Development (JAD) sessions with internal & external stakeholders.
• Extensive SQL experience in querying, data extraction and data transformations
• Experienced in Business Analysis, Data Analysis, Quality Analysis and Project Management.
• Specialized in business products, operations and Information Technology on the Banking domains, such as Anti-money laundering, Payment systems, Fraud detection, Automated Clearing House.
• Experience in working with risk management team in Risk analysis, risk management and risk mitigation.
• Proficient in Migration Projects, performing GAP Analysis, creating Software Specific Documents, and assisting the database and security team in back-up and securing the company’s digital artifacts.
• Expertise in creating Unified Modeling Language (UML) diagrams like Use Cases, Sequence Diagrams, Class diagrams, Activity diagrams, Data Flow Diagrams, ERD diagrams converting them into functional requirements.
• Efficient in Prototyping Application User Interfaces using Wireframes and Mock-ups with focused attention to detail in enriching User Experience and User Interaction.
• Proficient in working with Hadoop Ecosystem using products like Kafka, Solr, Lucene, Pig, Hive, Hiveserver, Spark, Oozie, Zookeeper
• Thorough understanding of n-tier architecture, understanding of request and response flow. Understanding appropriate technologies for business requirements (SOAP, REST, AJAX, JSON, and XML). Gathered requirements for Client-Side Validation, and Server-Side Validation. Experience in API documentation.
• Extensive experience in creating highfidelity and low fidelity mockups and wireframes using tools like Balsamiq.
• Experience with Data warehouse architectures, (Centralized, Federated, Hub and Spoke) experience with ETL processes, cleaning and cleansing data, Data Table structures, Schemas, Data Marts and OLAP operations, for example, Roll-up, Drill-down, slice, dice and pivot.
• In depth knowledge of User Acceptance Testing (UAT) with experience in creating test cases and test plans & release skill sets. Assisted the Quality Assurance (QA) team to perform Black Box, White Box, Alpha, Sanity, Smoke, GUI testing, Functionality, Regression, System, Unit, Web Service, Performance testing.
• Expert in analyzing and reporting using tools like Tableau, IBM Cognos, Oracle BI, SSRS.
• Facilitated Sprint Ceremonies (Backlog grooming, Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective) for Agile Scrum Methodology as Scrum Master.
• Experience in writing User Stories following the INVEST criteria, experience in defining acceptance criteria and prioritizing User Stories based on MOSCOW, KANO. Experience in estimating User Stories using different estimation techniques such as T-Shirt Sizing, Planning Poker and Relative Mass Value.

TECHNICAL SKILLS:

Waterfall, AgileScrum, Waterfall: Scrum Hybrid, Kanban, Scrumban and SAFe.

Business Skills: Change Management, Project Planning, Process Modeling, Risk Management, JAD Sessions, Impact Analysis, GAP Analysis, SWOT Analysis and Cost-Benefit Analysis.

Project Management Tools: JIRA, Rally, Confluence, Version One, Unified Modeling Language (UML), Lucidchart.

Modelling Tools: Wireframe.cc, Moqups, MS Visio, Balsamiq, SharePoint Designer, CA Erwin.

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Project, MS Outlook, MS SharePoint.

Testing Tools: HP QC, HP ALM, HP LoadRunner, Cucumber, Selenium, POSTMAN, Swagger, SOAP UI.

ETL and Reporting Tools: Tableau, QlikView, Informatica, Spotfire, IBM Cognos, SQL Server Data Tools - BI, PowerBI.

Languages: VB, JavaScript, Node.JS, C#.Net, ASP.Net, SQL, T-SQL, PL-SQL.

Web Technologies: WSDL, XML, HTML, SOAP, Web Services, REST API.

Databases: SQL Server Management Studio 2014, Oracle 11g/12c, MySQL Server 2012, MS Access, Team Foundation Server (TFS) 2012.

Data Warehousing: OLTP, OLAP, Data Marts, Data Mining, Slicing/Dicing, Drill Down/Roll up, Pivot, Data Mapping, Data Modelling, Star and Snowflake Schema, ETL.

PROFESSIONAL EXPERIENCE:

Confidential, Clearwater, FL

Datawarehouse Analyst

• Initiated research and analysis of assigned business area and functions to elicit client and internal project needs.
• Defined JSON data structures for NoSQL (Mongo DB) solutions.
• Designed and model to-be processes, perform gap analysis, evaluate data integrity and identify areas for improvement. Analyzed XML and JSON schemas to document existing data structures and perform data mapping.
• Interpreted standards and other API documents to identify and assess potential data sources, data flows and analyzed existing Data Warehouse structures and methods for data delivery. Created System Data Flow diagram using Visio.
• Created complex SQL queries to perform analysis for ongoing projects.
• Wrote Functional Requirement documents after analyzing stakeholder objectives and ensure their business requirements are prioritized.
• Created Users stories, test strategy, test plans, and acceptance criteria in Jira to ensure solution meets traceable business requirements. Use Jira Query Language to track issues.
• Worked with offshore development team to drive API development project. Tested Java APIs using Postman. Created Test cases using SOAPUI and documented it.
• Used MongoDB Compass for database management. Used MongoDB queries to validate data in test environment.
• Worked with Salesforce, website and Oracle EBS teams to ensure successful data migration.

Environment: Oracle 12c, Salesforce Lightning, MS Visio, MongoDB, Erwin, Oracle EBS ERP, Excel, XML, JSON, Postman, SOAPUI, JIRA, Confluence, Tortoise SVN

Confidential, Warren, NJ

Sr. Business Systems Analyst

• Obtained requirements using various techniques such as JAD, questionnaires, Document Analysis, and Interviews with various Stakeholders. Analysed & prioritized those requirements with the help of stakeholders.
• Teamed with the corporate business team, and the technical team to document and maintain the Customer Risk Scoring (CRS), Know Your Customer (KYC), OFAC Sanctions Screening, Partner Due Diligence (PDD), Transactions Monitoring, Suspicious Activity Report (SAR) compliances.
• Created conceptual, logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Developed PL/SQL triggers, functions, procedures, packages, indexes to implement business logic.
• Performed GAP Analysis to identify the as-is and to-be business processes.
• Maintained the requiremets traceability matrix (RTM) for tracking the origin of the project status using HP-ALM.
• Interacted with the Stakeholders and assisted the Product Owner to write User Stories, help in prioritization and assist in defining the acceptance criteria.
• Worked with the system architect to design and understand the system, and created various UML diagrams such as Use Case, Activity Diagram, Sequence Diagram and Data Flow Diagram using MS Visio.
• Performed SQL queries (CRUD operations) to perform data validation and data presentation activities on Oracle Database.
• Performed data extraction, cleansing, transformations like unconnected and connected Lookups, Routers, Joiners, Filters, Aggregators, union using Informatica Power center, data integration and loading data from heterogeneous source systems into the target Oracle database. Mapped the data from the source system into the targeted system for checking data integrity and data consistency passing through the Operational Data Store.
• Performed data validation testing
• Used drill-down, and slicing methods on Teradata Data warehouse to create data marts.
• Performed source to target testing and tested data before moving into production environment using informatica data validation.
• Performed functionality testing, reliability testing, load testing, and utility testing on the SOAP and REST API web-services also documented the API functionalities using Postman.
• Worked extensively in Testing the REST APIs in terms of load testing, functional testing and Security Testing of OAuth2.0 using Postman.
• Used JIRA and Confluence for defects tracking, and organizing and collaborating teams for meetings and emails using MS Outlook.
• Experienced on working with Reporting tools like Excel and Tableau to prepare dashboard reports and data visualization.
• Collaboraetd with the UX team to create wireframes and mockups for the front end using Balsamiq.

Environment: Oracle 12c, MS Visio, Balsamiq, Erwin, Informatica Power Center, Selenium, Hadoop Stack, Oracle ERP, Tableau, XML, Oracle Business Intelligence, JIRA, Confluence, Windows OS.

Confidential, Boston, MA

Sr. Business Systems Analyst

• Interacted with stakeholders and elicited the requirements using different elicitation processes, such as interviews, brainstorming. Conducted JAD sessions with the SMEs to understand better about the requirements.
• Created, analyzed and reviewed the functional and technical artifacts such as Business Requirement Documents (BRD), Functional Requirement Documents (FRD) and Software Requirement Specifications (SRS).
• Involved with the developers and architects in various stages of the migration planning for client applications utilizing the AWS stack (Including EC2, Redshift, Dynamo DB, KMS, ELB, Elastic IPs, Auto Scaling, S3, EBS, Glacier, RDS, Cloud watch, Cloud trail, Athena).
• Performed basic operations like create, describe, update table in AWS Dynamo DB which is a NoSQL database.
• Created logical data model from the conceptual model and its conversion into the physical database design using Erwin.
• Worked closely with data integration team to design, develop and test interfaces using ODI 11g.
• Reviewed Informatica and ODI Flows in order to validate that the data has been loaded as expected.
• Maintained the required traceability matrix (RTM) for tracking the origin of the project status using Confluence.
• Monitored and administrated the company's Salesforce sales cloud application by creating workflows for email alerts,lead escalation and automated lead routing.
• Assisted the Product Owner in writing User Stories, and prioritized and estimated them, also worked with the team to develop the acceptance criteria.
• Used JIRA and Confluence for defects tracking, and organizing and collaborating teams for meetings and emails.
• Constructed various UML diagrams such as Use Case diagrams, Class Diagrams, Activity Diagram, by working with the system architect, and development team lead, using tools such as Smart Draw and Microsoft Visio.
• Worked with the front end development team to create the functionalities in .Net Framework using MS Visual Studio.
• Used Teradata to store the large SQL datasets.
• Created source to target mappings using Informatica Powercenter.
• Worked with the development team to create, SOAP and REST API and documented and performed regression and security testing of OAuth 2.0 on them using tools such as Mulesoft Anypoint.
• Assisted the Quality Assurance team in performing functionality testing, reliability testing, and utility testing on the API web-services and their documentation using tools like Postman and Swagger.
• Created Test Plans, Test Cases, and assisted the Quality Assurance team in performing sanity testing, regression testing, user acceptance testing, and system testing.

Environment: MS Visio, Smart Draw, ODI 11g, Erwin, Teradata, Dynamo DB, Informatica Power Center, My SQL, Oracle Database, .Net Framework, Postman, Swagger, Salesforce CRM, MS SharePoint, Confluence, OAuth2.0, Windows OS

Confidential, New York City, NY

Business Systems Analyst

• Elicited business requirements from stakeholders and clients to better understand their business needs through Interviews, Requirement Workshops, Surveys/Questionnaire and Document Analysis.
• Performed SWOT Analysis, Feasibility Analysis and Data Analysis.
• Created dimensional model based on star schemas and designed them using Erwin.
• Prepared and submitted state required regulatory reports, verifying company compliant with state requirements, avoiding unnecessary fines.
• Facilitated Joint Application Development (JAD) session between Stakeholders, Subject Matter Expertise (SME), End Users and the Development team to discuss functionalities, interdependencies and issues for the project.
• Created Roles,Users, Public Groups and implemented role hierarchies and record level permissions to manage sharing access among different users on marketing cloud of SFDC.
• Added new custom objects, assigned fields, custom tabs, designed page layouts, components, custom reports in SFDC.
• Designed and deployed validation rules, dynamic workflows, approval processes and auto-response rules for automating business logic with sales and marketing cloud on SFDC.
• Maintained process maps and associated Risk Matrix to implement necessary enhancements.
• Developed Business Requirement Document (BRD), Functional Requirement Document (FRD) and System Requirement Specification (SRS) to assist the Product Owner in prioritizing the requirements.
• Documented Key Performance Indicators (KPIs), requirement changes to evaluate the project success.
• Developed Acceptance Criteria working with Product Owner and Stakeholder based on Request for Proposal (RFP), project scope and vision to ensure the stories satisfies Definition of Done.
• Evaluated Service Level Agreements (SLA) on weekly basis to provide task based reports to the Manager.
• Documented change requests to accommodate new developments and examine the risks that might occur.
• Created Business Process Models using Activity diagrams, Use Case diagrams and Swim-lane diagrams to have a deep insight to plan setup and plan configuration for Business Process Improvement.
• Developed wireframes and mock-ups for the application using Balsamiq in order to generate a throwaway prototype which assisted developers in writing efficient code for creating user friendly UI.
• Gathered customer data and wrote complex SQL queries for QA testing, performed CRUD operations and data analysis to validate report in MS SQL Server.
• Supported in creating SSIS packages for loading the data from different data sources like Excel, Access, Flat files and XML to create and maintain the database.
• Performed Data Mapping to integrate data from various Data sources and Data Profiling for examine, monitor and cleanse the existing data to make better business decisions.
• Good knowledge on APIs like SOAP and REST and different HTTP methods like GET and POST. Followed Code First approach based on which API document was created in Swagger.
• Used Mulesoft to integrate various APIs to test for their performance and functionality.
• Created Test Plans, Test Cases and Test Scenarios for performing Integration Testing, Back Box Testing and Regression Testing to assist Development team in writing high performance code.
• Performed Automation Testing to run pre-scripted tests on software application in Cucumber.
• Developed interactive dashboards and visualizations using Tables, Charts and statistical graphs for making better business decisions in Tableau.
• Continuously monitored and tracked the product quality throughout the entire lifecycle of the product in order to reduce defects and fix the already existing one in a cost effective manner.

Environment: Agile-scrum,Erwin, XML, Web Services, MS Office, provided, MS Visio, MS SQL Server 2012, JIRA, UML, Tableau, QlikView, Swagger, MS Project, SSIS, Cucumber, Wirefeames.

Confidential, Columbus, Ohio

Business Analyst

• Gathered requirements by holding one to one meetings with customers and convert them into Business requirement document (BRD).
• Provided direct support to Salesforce users during post-implementation issues and migrated metadata from dev environment to production.
• Increased efficiency of review time by 15% by creating pivot tables and charts in MS Excel using worksheet data.
• Created user stories and acceptance criteria from requirements that were gathered.
• Developed Test Cases, User Acceptance Testing (UAT), and Regression Testing to assist with Quality Assurance (QA) and verify that requirements were fulfilled.
• Elicited requirements using interviews, document analysis, JAD sessions, business process reviews and site visits.
• Planned and scheduled software releases and prioritized product backlog.
• Specified customer requirements using UML diagrams.
• Evaluated and documented risk related to requirements implementation, testing processes, and project communication when sprint planning.
• Worked with SOAPUI4.5 to perform load test, reliability test, utility test and document and ensure that proper business requirements and validations existed in the SOAP API.
• Designed Business Unit and Customer workflows with Visio.
• Created SQL queries to mine data from database servers.
• Authored and managed Requirement Traceability Matrix (RTM) documents.
• Facilitated Defect-Triage meetings with cross-functional teams to plan defect fixes, tracking them using HP-QC.
• Performed analysis and mapping of functional and non-functional data elements from source to target data management components as per requirements.
• Participated in Scrum Ceremonies: planning, daily stand-up and review
• Implemented network configuration management using Git and Ansible.
• Experienced in data analytics using Power Pivot, Power Map, Power Query, Data cleansing etc. in Excel.
• Implemented business rules for network data, before loading into target system and generated reports for purpose of finding patterns and trends in complex, multivariable data sets using complex SQL operations.
• Using SQL Server to write queries to join, search, and index database.

Environment: Git, Ansible, Visio, Wireframes, Servers, Windows OS, Excel, Jira, MS SQL Server, IBMCognos, HP-QC.

Confidential

Business Analyst

• Facilitated collection of functional requirements from system users and preparation of business requirement documents (BRD) to articulate appropriate scope of work for technical team to develop prototype and overall system.
• Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different business groups and programmers.
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Designed Data Stage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Ensured and documented that the system follows the regulatory compliances provided by NACHA such as Electronic Fund Transfer (EFT), maintain the Banking Secrecy Act and other compliances like PCI.
• Gathered Requirements to assist in Billing Center process of ODFI to support their payment cycle.
• Operated SWIFT messaging service for financial messages, such as letters of credits, payments and securities transactions, between member banks worldwide.
• Work with the Business Analyst in understanding the BI to perform in the Data Warehouse.
• Performed Data Modeling and Data Mapping to identify different data sources, integrate data and transform data to the required target using the Informatica PowerCenter tool.
• Performed Data Normalization to validate data and verify the same to increase Data Integrity ensuring to have accurate data. Assisted in extracting usable data and finding anomalies from large data sets.
• Assisted Data Architect in loading data from Data Warehouse into OLAP and perform different OLAP operations like Roll-up, Drill down and Slicing/Dicing as per the requirement.

Environment: MySQL, Informatica Power center, MS SharePoint, MS Excel/ Access, Scrum, MS Project, Selenium, MS SQL Server, MS Project, Tableau, MS Visio, JIRA, GAP Analysis, Lucidchart, Confluence, Balsamiq, Erwin

Confidential

Jr. Business Analyst/SQL developer

• Worked with a team of seven members to build and design a web application to span over the end-to-end processes integrating various business functions reducing process time.
• Created user stories and acceptance criteria from requirements that were gathered.
• Developed Test Cases, User Acceptance Testing (UAT), and Regression Testing to assist with Quality Assurance (QA) and verify that requirements were fulfilled.
• Elicited requirements using interviews, document analysis, JAD sessions, business process reviews, and site visits.
• Used T-SQL to develop stored procedures, tables, views and functions to add new features for current program.
• Improved performance of database by deleting useless tables, store procedures and views in the databases.
• Performed operations such as Fine-tuning highly complex TSQL stored procedures for maximum efficiency.
• Analyzed the existing application programs and tuned SQL queries using Execution plan, SQL performance Monitor, SQL Profiler.
• Created and wrote database objects such as tables, indexes, views, procedures, functions, and triggers.
• Gathered requirements by holding one to one meetings with customers and convert them into Business requirement document (BRD).
• Develop ETL mappings for flat-file data sources (XML, .csv, .txt) and loading the data from these sources into Dynamic CRM portal with SSIS tool.
• Created and modified several Scripts according to the changing needs of the project and client requirements.
• Worked with team and client closely and prepared the data mapping document.
• Designed and implemented report layouts using Excel.
• Created dashboards in Excel for data interpretation and reporting by using Pivot Tables and VLOOKUP for various releases monitor network KPIs.
• Worked on data analytics using Power Pivot, Power Map, Power Query, Data cleansing etc. in Excel.
• Increased efficiency of review time by 50% by creating pivot tables and charts in MS Excel using worksheet data.

Environment: SQL, T-SQL, SQL Server, Linux(RHEL, Centos), MS Excel, MS Access, Routers, SSIS, Windows Active directory.