Business System Analyst Resume
Newark, NJ
SUMMARY:
- Professional experience working in Finance and Healthcare Domain, specializing in Portfolio Management, Portfolio Reconciliation, Collateral Management, Asset management, Credit risk, Financial fraud detection, Claims, Providers, Benefits, Members and Accumulations. Operated in multiple roles such as Business Analyst, Business systems Analyst, Scrum master optimally.
- Worked closely with APIs and Web - services and documented the requirements to create APIs to suffice the need and worked closely on JSON and XML.
- Possess hands on Experience on Waterfall, Scrum, Waterfall - Scrum hybrid and Spiral methodologies.
- Understanding of other Industry standard methodologies like Extreme programming, Spiral Model, Lean and Kanban.
- Skilled in Gap analysis, SWOT analysis, Risk analysis, Cost benefit analysis, Impact analysis, Change management, Feasibility study and Viability study
- Proficient in networking with individuals at various levels while organizing, conducting and facilitating various elicitation techniques like Survey/Questionnaires, Interviews, Brainstorming, Focus group, Requirement workshops, Reverse engineering, Document analysis, and JAD sessions
- Highly skilled and adept at preparing various artifacts such as Business Requirement Documents (BRDs), Functional Requirement Documents (FRDs), Data mapping document and Data dictionary
- Possesses extensive knowledge in creating UML diagrams such as Activity Diagrams, Sequence Diagrams and logical and conceptual diagrams using tools such as MS-Visio
- Handling change request management, effectively implemented change by performing both business Impact analysis and technical impact analysis of the change on the scope of the project
- Collaborated in various types of testing like Functional (Black-Box) testing, End to End Testing, Regression Testing, and User Acceptance Testing (UAT) smoke testing, functionality testing, Sandbox testing. Accompanied with expertise in developing Test cases, Test plans and Test procedures in manual and automated test environments
- Assisted PO in breaking down Epics into User stories that satisfies the INVEST criteria. Skilled in Vertical slicing of User stories.
- Maintained various artifacts in Scrum like Product Backlog, Sprint Backlog, Sprint burn chart, Impediment list, Impact matrix used various prioritization techniques like MoSCoW, KANO, Walking skeleton, Validated learning and estimation techniques like Planning poker and T-Shirt sizing.
- Implemented Continuous Integration using Jenkins to speed up the development process.
- Used SQL queries to perform DML (Data manipulation language) operation to insert, update and delete the data
- Big Data concepts and Hadoop stack such as Spark, Hive, Pig, Flume, Impala, Sqoop, Kafka and Hadoop Ecosystem consisting of HDFS, Namenodes (MASTER), Data Nodes (Slave), HBase, Job Tracker, Task Tracker, MapReduce, Clusters and Nodes
- Data warehouse and related concepts of Entity relationships and Data structures. Competent in ER Modeling and Dimensional Modeling, Data modeling, Data migration, Data profiling, Data governance, Master data management (MDM), Schemas, Data mart, Operational Data Store, Data Vault
- Business Intelligence reporting and OLAP operations such as Roll-up, Drill-down, slice and dice and pivot.
- Service Oriented Architecture, N-tier Architecture, XML parsers, SAX, DOM, XPath, SOAP & RESTful web services
- Strong understanding on the concepts like AJAX, JSON documentation, XML schema definition (XSD), Extensible Stylesheet Language Transformations (XSLT), Web Service Description Language (WSDL), Universal Description, Discovery and Integration (UDDI) and API’s such as IIS, Apache
TECHNICAL SKILLS:
Finance: Portfolio Management, Asset Allocation, Mortgage operations, Credit Risk, Financial Instruments, Anti Money Laundering, Equities (Stocks, ETF, Equity Linked Notes), Fixed Income (Bonds, Convertibles, T-Notes, T-Bonds), Derivatives and Swaps (Options, Futures, Forwards), FX (FX Options, FX Futures, Currency Swaps, Currency Forwards, FRA), Money Market Instruments (T-Bills, Commercial Paper, Repos), and Mutual Funds
Risk and Compliance: Credit Risk, Market Risk, BASEL, DODD-FRANK, SOX, Bank Secrecy Act, GLBA, PCI DSS, SEC, FINRA and NYSE Regulations, Investment Act.
Healthcare: Claims, Providers, Accumulations, Members, COB, EOBs, Payments, HIPAA Compliance, Benefits, plans
Methodologies: Waterfall, Agile- SCRUM, Scrum-Waterfall Hybrid, SAFe.
Business Modelling Tools: MS VISIO, Balsamiq, Lucid Chart.
Project Management: Rally, JIRA, SharePoint, TFS, HP ALM, Confluence
Operating Systems: Windows, Mac OS, Ubuntu
Data Warehousing: Data Modeling, Data Marts, OLTP, OLAP, Data Mining, Slicing/Dicing, Roll Up/Drill Down, Pivot
Big Data Analytics (Hadoop): Apache Sqoop, Flume, Kafka, Storm, HBase, HDFS, Hive, Pig, Atlas, Ambari, Zeppelin, Mahout
Database/ ETL: MS Access, Oracle DB, SQL Server, Informatica- Power Center and Data Quality, SSIS, Erwin.
Reporting/ BI: Tableau, Oracle’s Business Intelligence Enterprise Edition (OBIEE), SSRS, IBM Cognos, Microsoft Power BI
Language: Java, C++, HTML, XML, SQL, Verilog
Defect Tracking/ Testing Tools: HP QC, Load Runner, Cucumber, Bugzilla, JIRA, Test Director, Soap UI, Cucumber, Gherkin.
Miscellaneous: Microsoft Office, NetMeeting, Adobe Photoshop, SSH, Google Sketchup, RedHat JBoss BMP suit, draw.io, Zoom, HipChat, AutoCAD
PROFESSIONAL EXPERIENCE:
Confidential, Newark, NJ
Business System Analyst
Responsibilities:
- Work as an integral part of API and Webservices team for developing new APIs and enhancing existing APIs to meet client requirements
- Actively engaged in transforming legacy web services (SOAP) into APIs (REST) and moving the data into Cloud for APIs to store/fetch data from cache
- Interface with client applications/project team to understand their needs, then work with analyst team and architects to develop an API that meets the client needs, document the API in Technical Requirement Document (TRD) and JSON swagger interface spec, and then walk the development team through the requirement/specs.
- Work on securing the APIs via APIGEE proxy.
- Gather requirements from business and document it in TRD for developers to develop as per the requirements
- Created Wireframes and Mock ups after closely collaborating with the stakeholders.
- Work with different teams to understand their data models and retrieve data required by the clients and bring it to our cache
- Develop technical requirements document, and api/web service interface specs in JSON - swagger documents, mapping documents and support the development of them through hybrid of agile and waterfall development lifecycle
- Update the error handling standards for better debugging the issues and for clients to understand the error codes and messages in an efficient way
- Work with architects in designing an efficient model for the API to have enhanced performance of the API and restrict the request and response elements only to needed to make API work as much faster as possible
- Assist SQA team with testing of APIs in different regions like dev, SIT, UAT and provided sign-off on the test plan and test cases on the API. Also supported APIs through UAT testing and also in production.
- Work on tools like Splunk and Postman to query the request and response of APIs across different regions for debugging and testing purpose
- Work on AWS platform to move the database to cloud and have separate cache for each domain in APIs
- Query on MongoDB to access database on cloud, understand data model and to understand sources of data
Environment: Scrum, WaterFall, scrum-waterfall hybrid, Java, Restlet, MS Visio, AWS, APIGEE, MongoDB, Oracle, NoSQL, JIRA, Confluence, Postman, Splunk
Confidential, New York City, NY
Sr. Business System analyst
Responsibilities:
- Assisted in creating a project plan, estimates, schedules, scope statement and establish project milestones.
- Defined the business rules by working with subject matter experts using ‘if’ and ‘then’ statements.
- Created Wireframes, Mock ups and high-fidelity Prototypes after closely collaborating with the business users.
- Created GAP analysis, Risk analysis, Cost-Benefit analysis, and Porter’s Five Forces Model to understand the as-is model.
- Interviewed Business users for eliciting requirements using JAD sessions, Survey/Questionnaire, Interviewing, Focus Groups and analyzed the feasibility of the requirements.
- Worked closely with Project Manager for any change request and helped to do Impact Analysis.
- Determined traceability and dependencies between the requirements using Blueprint.
- Created various UML Diagrams like use cases, activity diagrams, sequence diagrams using MS Visio.
- Assisted in the data mapping to create alerts, warnings and pre/post trade compliance rules from the enhanced system.
- Involved in loading and transforming large sets of structured, semi structured and unstructured data from multiple source system to Hadoop Data Lake.
- Involved in creating Hive tables, loading data and writing Hive queries as per business requirements.
- Involved in Technical writing and API documentation for REST API using JSON.
- Was a part of API testing and measured the data flowing between request and response.
- Implemented Jenkins process to build Jars that can be triggered by code commits to GitLab.
- Responsible for creating the Machine learning algorithm and training it.
- Created HBase tables to store the final aggregated data from Hadoop system.
- Implemented Continuous integration & deployment CICD through Jenkins for Hadoop jobs.
- Assisted in creating detailed test plans. Wrote test cases for integration, regression, end-to-end, smoke, sanity, functional, performance and stub testing.
- Assisted QA team to create the readiness document to move the system from testing to Pre-production environment.
- Designed the Test Cases and Test Plans for all processing using HPQC, hence developed the test scripts considering different testing such as Black Box Testing, Regression Testing, Smoke Testing and User Acceptance 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.
- Assisted the team in post-production maintenance of the system as a liaison between the business users and team.
- Creating the SLA documents and Run books to help the Hadoop Admins for Operations and Maintenance.
Environment: Scrum, Java, Eclipse IDE, Big Data, Hadoop cloudera(CDH) distribution 5.0,Linux, Hue, Oozie, Sqoop, Hive, HDFS, HBase, Flume, Jenkins, Kafka, Solr, Mockito, Zookeeper, MS Visio, JIRA, Tableau, Blue Print
Confidential, Malvern, PA
Sr. Business System Analyst
Responsibilities:
- Developed good knowledge of Financial Instruments, Asset Allocation, Commodities, Bond Pricing, Corporate Bonds, Fixed Income, Credit Risk and Market Risk.
- Conducted JAD sessions, document analysis and interviews with the stakeholders for the requirements elicitation.
- Assisted project manager in creating proposals and project budget allocations and worked on Project Charter and Work-Breakdown Structures using MS Project.
- Prepared Business Requirement Document (BRD) and Functional Requirement Document (FRD).
- Decomposed the scope from the BRD into user stories by conducting a story writing session with the product owner. and then the acceptance criteria for the PSPI (Potentially Shippable Product Increment)
- Created Activity Diagrams, Sequence diagrams, the use cases and use case diagrams using MS Visio.
- Did Impact Analysis, Feasibility Study, Cost-Benefit Analysis and ROI calculation in order to be prepared for potential business and technical risks to the system.
- Helped the developers in enhancing the GUI by using AJAX programming.
- Worked on Service-Oriented Architecture (SOA), REST, SOAP, XML and API.
- Generated various views for portfolios using SQL queries with Select and Where clause.
- Understood the data requirements to compute the risk-reward tradeoff and accordingly helped in designing the OLAP cube.
- Integrated the various OLTP to the OLAP by using Informatica as an ETL tool and tableau as the reporting tool.
- Conducted User Acceptance Testing (UAT) in conjugation with the QA team.
- Created test cases and test plans and tracked them to user stories with the help of a Requirement Traceability Matrix.
- Whenever needed, I also facilitated the Product backlog grooming meeting to reprioritize the Product Backlog.
- Extracted financial data from Bloomberg to a spreadsheet for analytics purpose.
- Created deployment flowchart in conjunction with the development, infrastructure, and network teams containing instructions for maintaining the Application
Environment: Scrum-Waterfall Hybrid Methodology, Version One, Tableau, AJAX, SharePoint (2010), Microsoft Office, HP ALM v11.5, Oracle, Spot-fire, HPQC, SQL Server, MS SSIS, MS SSAS, MS SSRS, MS-Visio, ETL Informatica
Confidential, Rockville, MD
Business System Analyst
Responsibilities:
- Conducted GAP Analysis to derive requirements for ACH processing.
- Used software methodologies including Agile (Scrum) Scrum - waterfall Hybrid.
- Initiated scrum process, coached team with Agile implementation and adapting to Scrum.
- Elicited demands from the stakeholders and analyzed them for consistency, completeness and flexibility.
- Gathered Requirements to assist in Billing center process of ODFI to support their payment cycle.
- 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.
- Utilized existing data of ACH from Data Center and integrated to enhancement for testing.
- Conducted User Story Writing Sessions to decompose BRD into User Stories 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.
- Used JIRA for issue tracking, user story management and requirement traceability.
- 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.
- Managed customer relations (CRM) using SAP CRM.
- Assisted in identifying risk needed to develop Risk analysis as required by NACHA and Fraud detection for red flags to report fraud, patterns and inconsistencies activities.
Environment: Scrum-waterfall Hybrid, MS Visio, MS Project, MS office, Fraud management, Risk management, Java, MySQL server 2012. Visual studio 2013, JIRA 6.3, Tableau 8.3, MS Office Suite (MS word, MS Excel, PowerPoint), MS Project, SAP CRM, IAS 2012.
Confidential, NYC, NY
Business System Analyst
Responsibilities:
- Understood state of art processes by interacting with stakeholders and documents analysis and performed GAP analysis to assist Product Owner and Project Manager in planning the transition.
- Facilitated JAD sessions as Moderator and conducted interviews with various Subject Matter Experts (SMEs) and stakeholders, process reviews and policy & procedure reviews to elicit requirements.
- Prepared Business Requirement Document (BRD/HLD) and assisted preparation of System Requirement Specification (SRS). Analyzed, modified and validated these documents.
- Managed and tracked requirements using HP ALM through Application Life-Cycle.
- Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.
- Assisted Data modeling process by creating conceptual and logical ER diagrams and designing database schemas to help development of an accurate Data Warehouse Structure.
- Integrated various OLTP to the OLAP by using Informatica as an ETL tool and used Tableau as reporting tool. Also maintained the Bill Inmon and Ralph Kimball Paradigms.
- Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity to maintain accuracy and effectiveness of data,
- Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries.
- Was involved in using Tableau for effective reporting to provide Business Intelligence (BI) to facilitate expenditure tracking using various matrices critical to decision making.
- Involved in implementation by assisting in the preparation of training module. Helped the end users getting accustomed to the system by live demonstrations and system tutorials.
Environment: Waterfall, MS Office (MS Word, MS Excel, MS PowerPoint), Tableau, Informatica, MS Visio, MS Project, HP ALM, Wireframes, Mock-Up Screens, MySQL Server, SharePoint, GAP Analysis, UML, UAT testing.
Confidential
Business Analyst/Java Developer
Responsibilities:
- Developed module which stored all the data pertaining to a client and deals in entering the client detail over the Internet, maintenance/administration of client data and allows various queries.
- Involved in Development and Analysis of this Enquiry module.
- Involved in front frameworks that consisted of HTML, JSP, and Servlets.
- Facilitated meeting and arranged JAD sessions with business users for requirement gathering.
- Served as a liaison between business team and the project team by assisting the business in identifying, understanding and documenting their business needs.
- Assisted in gathering requirements for the GUI (Graphical User Interface) Screens and designing.
- Created use cases and designed use case diagrams, class, sequence diagrams and activity diagrams.
- Responsible for preparing Software Requirement Specifications (SRS) and Functional Requirement Specifications.
- Conducted Project related Presentations.
Environment: Waterfall, MS Office, MS EXCEL, MS ACCESS, Load runner, windows 2000, clear case, UML and Bugzilla.
Confidential
Java Developer
Responsibilities:
- Involved in developing prototypes of the product.
- Involved in Analysis and Design of the project, which is based on MVC (Model-View-Controller) Architecture and used other Design Patterns like Singleton.
- Created UML Use Cases, Sequence diagrams, class diagrams and page flow diagrams using.
- Designed and developed UI using HTML, CSS, JSP, and Struts where users have all the items listed for auctions.
- Developed Authentication and Authorization modules where authorized persons can only access the inventory related operations.
- Developed Controller Servlets, Action and Form objects for the process of interacting with Oracle ADF database and retrieving dynamic data.
- Responsible for coding SQL Statements and Stored procedures for backend communication using JDBC
- Used Net Beans IDE to develop the application. Wrote JavaScript validations on the client side.
- Implemented Socket Programming to communicate with all the customers.
- Involved in unit testing and system testing and responsible for preparing test scripts for the system testing in UNIX Environment. Responsible for packaging and deploying components into the JBoss Application Server.
Environment: Waterfall, Java EE 5, Java Beans, JSP, JavaScript, Servlets, JDBC, Net Beans IDE v6.7, JBoss, XML, HTML, WSDL
Confidential
Jr. Java Developer
Responsibilities:
- Understood the business process and assisted in developing Java Server Pages using HTML/CSS for User Interface and Java classes for business logic
- Designed the Front-end Screens using Servlets and extensively used JavaScript for client-side validations
- Executed PL/SQL queries, procedures and created Java classes to communicate with database using JDBC connection
- Coded Data Access Object layer to send the data retrieved from Oracle RDMS database to the controller, through business delegate layer
- Coordinated with the back-end team for integration issues and participated in Code Review preparing Test Cases
- Involved to develop Multithreading for improving CPU time. .
- Used JDBC calls in the Enterprise Java Beans to access Oracle Database.
Environment: Waterfall methodology, Java, JSP, JavaScript, Servlets, Eclipse, PL/SQL, JDBC, RDBMS, Oracle, Apache Tomcat.