SUMMARY:

• An IT professional with 8+ years of experience, with solid understanding of a diverse range of business solutions and their applications.
• High - caliber presentation, client interaction, requirement gathering and analysis skills. Proven ability to demonstrate executive disposition; lead diverse groups of professionals to design, implement and support high quality Software Development Projects, working with end clients to define needs and to develop clean business solutions.
• Proven ability to gather and analyze quality data to assist management in the making informed, high quality decisions.
• Excellent knowledge of insurance, annuities, telecom, accounting and financial concepts.
• Excellent knowledge of Software Development Life Cycle (SDLC) including Feasibility Study/Gathering Requirements, Analysis, Design, Development, Testing, User Acceptance Testing (UAT), Implementation and Post-Implementation Validation.
• Proficient at providing documentation support including analyzing user needs to determine functional requirements, updating and maintaining existing technical application documentation, and determining any new system documentation required to meet the projects requirements.
• Experienced in facilitating Joint Application Development (JAD), Rapid Application Development (RAD) and Joint Requirement Planning (JRP) sessions, interviews, workshops and requirement elicitation sessions with end-users, clients, stakeholders and development team.
• Experienced performing functional testing, UAT and writing test script, plans and in setting up the UAT phase.
• Excellent knowledge and experience of creating source to target mapping, edit rules and validation, transformations, and business rules.
• Experienced with a wide range of content-oriented products/artifacts deployed via channels including Web Applications.
• Excellent knowledge of basic HTTP status codes 200,201,202,300*, 400,401,404,408,500 and other status codes as necessary for creating Interface Control Document (ICD) and Design documents for different web portals and web services for clients.
• Experienced with HTTP methods PUT, GET, POST, DELETE mapping for CRUD operations for RESTful API design.
• Excellent writing JSON and XML request and response for RESTful APIs along with validating the JSON structure during UAT and testing.
• Solid understanding of Use Cases, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams.
• Experienced in writing Test Plan, Test Strategy, Test Cases, and Traceability Matrix.
• Excellent communication and presentation skills. Experience in working with business users as well as computer professionals. proficient with Spring framework based technologies such as Spring Boot, microservices, facade patter, cache managers.
• Proficient working with Atlassian Suite: JIRA, Confluence, HipChat for managing change requests, bug tracking, project planning, user stories, Confidential planning, documentation updates, changes and keeping in touch with team members for delivering product in an agile environment with quality.
• Excellent with SQL queries for SQL Server, DB2 and Oracle. Experienced writing CRUD queries, stored procedures and triggers. Also, able to design the ER diagrams for table mapping with incoming and outgoing data.
• Experienced with Lean Six Sigma principles and helping the team follow those principles in an agile scrum environment.

TECHNICAL COMPETENCIES:

Business Skills: Business Process Analysis & Design, Requirement Gathering

Languages: SQL, Java, HTML, XML, JSON

Testing Tools: HP Quality Center, TOAD, SOAP UI, Rest Client, JMeter, SSMS

BI Tools: Tableau, Power BI, SSRS

Frameworks: Spring Boot, Spring Web Flow, Beans, IOC, MVC

Database: Oracle, SQL Server

Agile Tools: Rally, JIRA

Operating System: UNIX, Windows, MS-DOS

Office Tools: MS Office Suite, Visio, MS Project, Active Directory

Web Services: REST, SOAP

INDUSTRIAL EXPERIENCE:

Confidential, Melrose Park, IL

Business System Analyst

Responsibilities:

• Work Used Power BI, for visualizing and analyzing data, creating dashboards to access real-time information, creating reports and working with datasets. Asking questions and answering them in form of visuals like graphs and charts using the Q&A feature. Worked with conditional columns, transforming and manipulating data like splitting and merging columns, managing queries groups and then sharing it.
• Conducted Requirements gathering workshops with business process owners and global owners, and prepared / reviewed As-Is / To-Be process maps, Functional Specification Documents for assigned Core and Boundary Systems.
• Facilitated sign-offs from business owners, and technical / architectural reviewers, for the above documents.
• Gathered those requirements to develop the UI/UX designs, mainframe and the web portal backend. Designing team was involved to develop product catalog.
• Worked with network team, technical team and third party for SSL for electronic funds transactions.
• Actively participated during the Production releases of the products and provided go-live support during Production deployments.
• Facilitated JAD sessions with management, SME, vendors and other stakeholders for open, pending and critical issues. Sessions focusing on IT strategies.
• Performed Gap analysis and structured walk through of work flow with Actuaries and Underwriters to identify and fill the gap after the merger.
• Used Problem solving skills and built a liaison between business and technical ends of the project.
• Resolved system issues as they relate to production processing, report applications and system output.
• Researched in determining the reporting tool, and the allocation of direct access to backend tables for real-time Ad hoc Reporting and analysis.
• Assigned problems to appropriate software development teams for fixes and created tickets in JIRA to keep track of.
• Performed meetings and discussions to implement technology concepts.
• Created and managed project templates, use case project templates, requirement types and traceability relationships.
• Created user stories with in JIRA and validated each acceptance criteria for them were met after completion.
• Performed document management using Microsoft SharePoint.
• Developing Use Cases, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams.
• Designed SQL queries for Backend Testing and Report Generation accordingly based on the specifications.
• Worked with Cross-Functional Technical Team and Business Process Owners to coordinate / implement / review Validation Strategies for Data Conversion and Interface of Systems.
• Involved in Proof of Concept and Designing the solution to meet functional requirements of Quotes, Orders, Price Lists, Bill of Materials (BOM), Selectica and Oracle Configurator.
• Worked closely with Business Team and Technical Team to ensure the Business Requirements are understood, broadly communicated and clearly documented as per Juniper Standards.
• Executed maven build scripts for testing project build status in different environments and check test reports generated.
• Assisted project leader for project management and delivering projects.
• As a member of production support team, provided on-call support to all enhancements done on production servers.
• Performed Functionality, Integration, GUI, Regression, Usability and System testing.
• Used Quality Center to log all the test cases/scripts and generate a daily status report.
• Used Jira for tracking of the changes and updating the user stories. Used Confluence for writing wiki instruction pages.
• Tested the Applications compatibility on different browser versions of IE, Firefox and Safari.
• Designed the JSON and XML request, responses for various web services and other services in the ICD for technical team to review them created the PPT for show casing to business.
• Created the documentation for planning, testing and tracking and reporting status of UAT.
• Performed UAT with business users and SME from different departments.
• Participated in group testing and went to Confidential stores in the city to test the application for UAT.

Environment: Java, Siebel CRM, Jira, Confluence, SQL Server, QC, Spring, Microservices, Web Services, Jenkins, Maven, GIT, MS Office, Eclipse, SQL, Tableau, JMeter, RestClient

Confidential, Fargo, ND

Specialist/Business Analyst

Responsibilities:

• Worked majorly on all the derivative products, annuities. Advanced Knowledge of all CDS products: total return swaps, credit linked notes, asset backed securities, and mortgage backed securities. Also, familiar with CDS trade legal documents and the underlying mortgage-backed securities features.
• Derived Functional Requirement Specifications (FRS) based on User Requirement Specification URS. Conducted user interviews, understood and articulated business requirements and further converted requirements into technical specifications.
• Responsible for translating Business Requirement Documents into functional specifications and test plans. Closely coordinated with both users and developers for arriving at mutually acceptable solutions.
• Created documents of the use cases and created the use case, activity, logical, component and deployment diagrams using MS Visio and Rational Rose to communicate clearly with the development teams.
• Redesigned web services methodology for the application while implementing reusability from different servers. Liaised with the technology team to derive Functional Requirements.
• Responsible for Risk Analysis to detect the risks associated with the development of the new system. Additionally, formulated a Mitigation Plan to remove or reduce risks of high severity and one that would have major financial impacts.
• Setup agile environment using JIRA, created user stories and assigned them to team members.
• Participated in Confidential planning and review session for updating user stories in JIRA and noting down team feedback.
• Managed Change Requests from stakeholders by conducting extensive Impact Assessments to capture the expected consequence of such changes
• Responsible for creating and updating all documentation for the project, which required interacting with all concerned departments on a regular basis.
• Conducted Defect Validation using Test Director to screen the illegitimate defects raised by the QA and UAT teams before hitting Development.
• Developed a Credit Default life cycle process and prepared a power point presentation. Helped developers while they are preparing unit test cases and while preparing test plan.
• Developed documents for Credit Derivatives businesses and the end-to-end transaction lifecycle.
• Worked in product settlement, documentation, collateral & margining processes.
• Created cash flow models for Credit Default Swaps, Interest Rate Swaps, Total Return Swaps, Currency Forwards, Cross-Currency Interest Rate Swaps, Equity options, Structured products, Currency Futures, Options, Exchange Traded Funds (ETFs), and indexes.
• Prepared test cases and came up with a testing strategy for testing the Banking Application by analyzed the Business requirements and the Accounting, Budget, and Procurement systems.
• Developed Base line testing scripts for testing the future releases of the application using Test director. Participated in conducting Manual and Rational Tools for testing. Extensively used SQL for data integrity testing at the backend. Designed user and administrative privileges such as authentication.
• Documented workflow, Designed UI and results of business analysis and obtained sign-off from client on specifications.
• Created UAT/QA test plans, strong manual, functional, system and regression testing in an agile development environment.
• Worked with project team on: planning, analysis, requirements, design & testing and for production implementations.
• Worked with the technical team to ensure that varied changes including configuration change requests submitted by the test team are logged, cross environment impact is assessed and cross environment migrations are managed.
• Interacted with various members at the management level to understand business decision and analysis needs in order to generate appropriate and relevant data analysis reports. Extensively worked with Quality Analysts to make sure that the functionality meets requirements.
• Communicated with clients, settled credit derivative payments with sensitive clients and broker dealers, investigated the discrepancies and communicated with Middle Office, Front office to resolve the discrepancies on asset-backed credit default swaps.
• Appointed by senior management to work on process efficiency that would help the team reach their quarterly goals of reduction in breaks. On joining the team, created a macro system to streamline the process of cash settlements. Created the dynamics and mechanics of two major macros and programmed for large settlement database every month and for settlements on a daily basis.
• Created and modified Accounts, Contacts, Cases.Creating and customized Reports, Dashboards in SalesForce for the payment and orders. Created and moderated Chatters. Set up of Page layouts, custom objects, custom tabs, custom fields, Master - Child Layouts (field - info layouts). Improved workflow rules, Case assignment rules in SalesForce.
• Worked with the Information Technology teams on coupons, shortfalls and reimbursement reports for the entire team.
• Communicated with Middle Office on bookings and payments for clients and broker dealers.
• Worked with global clients, sales, strategist, traders and middle office to calculate structured product Credit Default Swaps (Credit Derivatives or CDS) interest, credit event fees, shortfall and reimbursements.
• Researched payment discrepancies to confirm compliance with ISDA Agreements.

Environment: Java, MS Office Suite, Visio, Quality Center, Telelogic DOORS, SharePoint, SalesForce, Java, MS Project.

Confidential, Overland Park, KS

Business System Analyst/ Production Support

Responsibilities:

• Worked on UNIX platform to maintain the quality of work orders that come in from Confidential .
• Interacted directly with users and provide level 2 / 3 technical support
• Worked extensively on UNIX having knowledge of UNIX commands and shell scripting.
• Provided assistance to the professional services team, and the sales team to facilitate ongoing efforts.
• Used BMS Remedy AOTS software for ticket management.
• Understood the different processes and applications used for Confidential to process work orders.
• Worked with business in eliciting various requirements and understand customer needs.
• Worked with technical team in developing new solutions and features for Confidential site for mobile, U-Verse, Direct-TV and other new features they wanted to support.
• Created the visualizations such as flow charts, use case diagrams, activity & sequence diagrams for review by team and business.
• Provided Siebel support for production environment daily for Siebel application defects, Siebel Configuration, Database extracts, Remote client/tools synchronization.
• Researched, validated, tested and determined bug fixes to existing code and environment related defects.
• Followed closely with management and testers on defect fixes during tri-weekly status meetings.
• Document defect fixes and provide unit test plans and root cause analysis.
• Coordinated and work closely with other clients' teams.
• Worked with technical team for Spring based technology discussion and solutions for implementing business needs.
• Drew the Visio diagram for the Spring Boot with microservices for providing various different services to client according to business needs.
• Performed the team code reviews before solution deployment to production environments.
• Tested multiple Citrix based test offices and production offices for data results.
• Facilitated JAD sessions for discussing feature priority and advantage and issues with the requirements being implemented and best possible route to complete task on time and following best practices.
• Responded to technical calls involving diagnosis and resolution of Advantage Support Contract customer’s server application issues.
• Performed UAT with end-users, business and obtained their sign off on resolved existing issues and new features implemented.
• Notified the management team of any potential escalations or complex problems
• Resolved technical issues in a timely manner
• Created API mapping and documents for various billing plans and for the payment api and the gateway used.

Environment: UNIX, SQL, Jira, Oracle, MS Office, Windows Server 2008, Remedy, VMWare, Putty, Siebel, Java, Spring, Web Services, Git, Maven, eclipse

Confidential, Cincinnati, OH

Business Systems Analyst

Responsibilities:

• Developed Software Requirement Specification (SRS) documents using Visio and MS Office (The requirements for this project are being subdivided into three separate Software Requirement Specification (SRS) documents, one for each release of the project).
• Coordinated all the testing activities between offshore and onsite as well as with development team.
• Reviewed all Requirement specification docs, Functional design docs for completeness and testability.
• Assisted the team while Test Case execution as PM.
• Liaison between client and Siebel teams to ensure work met client requirements. Communicated to Siebel team when business requirements changed.
• Worked with client to get the requirement and for reviews of requirement documents. Automate the system with the help of Quick Test Pro-Automation.
• Attended weekly test plan/project status meetings and reviews.
• Involved in build verification and release procedure.
• Maintained and ran Regression test cases. Managing and Analyzing and prioritizing defect lists and defect resolution.
• Monitored progress based upon schedules and requirements.
• Assessed and reporting on the quality and status of testing deliverables.
• Coordinated with technical leads for determining when fixes will be promoted to test environments. Documented all phases of QA process.
• Detailed repeatable end to end test cases for application, interviewed developers to gain detailed information on complex calculations and backend exception processing to validate the backend utilizing SQL Server.
• Analyzed, documented, and managed all project requirements and changes to requirements throughout the software development lifecycle as PM.
• Worked on creating web service documents, extracting wadl and wsdl files for technical team. Various Restful api request and responses in JSON and XML. Also, test the apis with technical team then performed UAT with business.
• Worked on documenting all the HTTP codes each web service will face and check with technical team before sharing across team.
• Worked with Excel for load huge data through PowerPivot from databases. Then used PowerView to view them and created Pivot tables and VLOOKUP’s on the aggregated data to group them according to business needs.
• Used various macros, functions provided by excel to filter and format data loaded according to business needs.
• Loaded the final excel sheet in Tableau to create graphical presentations with trendlines.
• Conducted user interviews, attended JAD (Joint Application Development) sessions, created agendas and documented analysis in requirement gathering.
• Responsible for post development peer reviews and deployment of packages.
• Identified the use cases from the gathered requirements and prepared a comprehensive Use Case Specifications document.
• Suggested changes when the user interface was confusing or needed rewording. Programmers incorporated these changes.
• Wrote SQL queries for CRUD operations, stored procedures with DBA assistances. Also, helped with the design of DB functions for checking insertions into tables and table data health.
• Verified and validated data model with changes to business information and rules.
• Prepared the detailed work flow diagram based on the proposed enhancement for the system.
• Extensively interacted with both user group and development team in coming up with structured charts, class and sequence diagrams.
• Identified, analyzed and documented defects, questionable functions, errors, and inconsistencies in application functions, outputs, online screens, and content in the eRoom.

Environment: RestClient, SQL Server, Java, Eclipse, MS Office, Lotus Notes, Jira, Confluence.

Confidential, Atlanta, GA

Business Data Analyst

Responsibilities:

• Co-ordinated with the Development team in Software development sessions, initiated code impacted changes in the existing documents as well as implemented changes in the software.
• Worked closely with offshore development team for Impacted systems in Test only, Test support only, JAD, ST/JST/UAT.
• Developed and Analyzed test reports and test plans
• Translated business requirements into architecture and functional requirements for developers.
• Developed schema objects (facts, attributes, hierarchies, transformations)
• Validated system design and architecture against business requirements.
• Developed provisioning templates for payment processes, claims - orders, property, life insurance, credit risk management.
• Designed and tested the integration of 3rd Party Restful APIs such as Google with Confidential ’s internal services for inventory backlog and other data related updates.
• Reviewed and validated EDI transactions such as 820, 832 and others in the supply chain management. Performed data mapping from XML and database to EDI files.
• Facilitated JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.
• Functioned as a business requirements Subject Matter Expert.
• Performed UAT with business users and confirmed all the logistics from each store for products matched the invoices returns in total.
• Created and tracked issues using JIRA and ensured each was resolved in a timely manner.

Environment: Windows, MS Office, MS Project, Visio, Linux, Oracle, Jira