SUMMARY

• A successful Business Systems Analyst and a proven track record of over 7.5 years of experience in Information Technology, providing business solutions for client/server, web - based and Service Oriented Architectures.
• Extensive experience working in diverse business and technical environments and possess domain knowledge in Financial, Property and Casualty, Insurance Claims with Reporting and Analytics.
• Expertise in Software Development Life Cycle (SDLC) including Waterfall, Agile, Rational Unified Processing (RUP), Unified Modeling Language (UML), QA methodologies and defect management.
• Professional experience working closely with clients on large-scale collaboration and content management projects; communicate and present concepts and deliverables to clients.
• Proficient in conducting Requirements Elicitation Sessions understands BI Implementation and Data Lineage processes and can provide Data Governance and Deployment strategies for new/sustaining development.
• Extensive experience in system analysis, master data management, troubleshooting data dependencies, review data loss, data inconsistencies and documenting RCA - root cause analysis for systematic procedures in problem identification through technical expertise and provided architectural information to Master Data Management to EDW teams
• Worked with stakeholders to developCollibraData Governance, Information Security, Risk Management and Compliance blueprint for success and architecture.
• Experienced in rich UI development strategies using Mendix Application Platform and Salesforce integration for building enterprise ready applications and seamless integration.
• Worked extensively on Requirements Gathering, Gap Analysis, Business Process Reengineering and development of functional specification for Enterprise software development companies.
• Proficient in SQL queries, Stored Procedures and PL/SQL programs for Data Analysis purposes.
• Hands on experience organizing requirements, detailed Test plans, Test strategies and procedures, Test scripts, Test cases and test reports and thus managing Life Cycle of various cross functional projects using all the modules in HP Application Life Cycle Management (ALM) and coordinate UAT efforts.
• Expertise in performing different types of testing: White Box, Gray and Black Box Testing - Unit, Module, Regression, Performance, Functionality, GUI, Integration, System, User Acceptance Testing and Database, End to End testing of client/server, web based and Data Warehouse applications.
• Expert in implementing best practices in Agile and Waterfall delivery for solution design.
• Experienced in performing software Requirements Traceability matrix using JIRA and Confluence
• Efficient in Project Management skills - Capacity Planning, Risk Management, Budget-Scope estimates, Resource ramps and structure, Release and Iteration Planning, Define Release scope and documentation.
• Strong verbal/written communication and interpersonal skills, ability to solicit participation and input from others. Possess strong analytical and problem solving skills, detail oriented and a team-player.

TECHNICAL SKILLS

Databases: Oracle, MS Access, SQL Server2012, DB2, Sybase

Modeling Tools: Rational, MS Visio, UMLet, Mendix

Change Management: Clear Case, SharePoint, Doors, RequisitePro, StarTeam

BI Tools: Business Objects, Tableau 9.1, Advanced Excel, Power Pivot

Testing Tools: HP ALM, Quality Center, Dynatrace, PerfMon, Selenium IDE

Database Tools: SQLPlus, TOAD, SQL Developer, Workbench

Defect Tracking Tools: Rational Clear Quest, HP Quality Center, ALM

Operating Systems: iOS, Windows Server 2012, Ubuntu, Linux

PROFESSIONAL EXPERIENCE

Confidential

Business Systems Analyst

Responsibilities:

• Participated in and represented the business in the full life cycle of issue identification, incident management and remediation
• Communicating to various levels of the organization, internal and external to DPG, about production issues impacting DPG customers, products and services.
• Responsible for requirements gathering, requirements documentation and creating Agile User Stories for enhancements to business rules.
• Identified issues or root cause through data analysis using various tools
• Developed and maintained strong relationships with technology groups and business partners to ensure proper engagement during incident management.
• Involved in mentoring specific projects in application of the new SDLC based on Agile Solution Delivery, especially from the project management, requirements and architecture perspectives.
• Involved in all SDLC stages under Agile process in applications including Requirement Analysis, Implementation, Testing, Deployment and Maintenance
• Been a liaison between line of business teams (eg. product development, project/business analyst, compliance) and technology teams for how systems are working in Production.

Confidential, Dover, NH

Sr. Business Systems Analyst

Responsibilities:

• Responsible for the management of the software process from requirements gathering, documentation, management approval, client approval, development, to testing and final presentation to the client.
• Responsible for Requirements Elicitation, documentation and sign off for UI enhancements and implementation of Box code with Mendix platform.
• Performed GAP analysis on existing architecture and services code and created a traceability matrix for requirements and rapid application development code for Mendix code leverage and rich UI development.
• Worked with integration partners and documented business scenarios for DocuSign and Office365 integration on Mendix platform, I was the subject matter expert for Claims Submissions and workflows.
• Performed data preparation steps including data extraction of target data from multiple databases, integration of multiple datasets and creation of derived variables, application of business rules and wrote Use Cases for quality control checks to help QA teams.
• Worked in environment - driving business outcomes in Agile ways of working.
• Participated in manual testing including System, End-to-End, Regression and User acceptance testing.
• Provided Analyst support across all Software Development Lifecycle phases, and created deployment plan.
• Created Requirements Traceability matrix using Confluence and integration with JIRA, created JIRA Dashboards to demonstrate project tracking, customer reports, status reports, iteration burndown, etc.
• Coordinated UAT test efforts, worked with release engineering teams on defect fix and code migration to higher environments, re-testing defect corrections and approvals.
• Worked in Agile framework for product development and delivery, performed user story documentation, elicit requirements in story documents and story mapping with functional requirements-FRD.
• Used AgileScrumto createuser stories, specify acceptance criteria, groom product backlog, and participate in Sprint events.
• Acted as the liaison between the business and the technology area to implement software upgrades, create new reports, document business use cases, conduct user acceptance testing, and design future enhancements for the migration to Medix platform platform.
• Collaborated with functional analysts and actuarial teams to document mock-up screens and developed UI specifications with page navigations and content managed by Development teams for UI development.
• Created Page Templates, Layouts and Themes for UI framework for UI Development team and QA testing.
• Used JIRA for User Story preparation, tasks for development and QA, managed product backlog for iterative development and focused for March 2017 planned release into production.
• Managed Product backlog, release work items in Jira, reported to senior management using Dashboards.

Environment: Agile, Scrum, Mendix Platform, UML, SQL, JIRA, Office365, EDI, Java/J2EE, Web Services.

Confidential, Hartford, CT

Business Analyst

Responsibilities:

• Responsible for requirements documentation, review, management and sign-off for Claims Network and documented Claims process for registration, settlement and claims disbursement to myAccounts.
• Enhanced the infrastructure of Claims Management System to provide non-overstating, accurate consolidation of transactional data to enable business intelligence to track the product association of a customer and also to analyze the data on various reporting attributes like product, time, person, etc.
• Worked on Impact Analysis, High Level Design, Detailed level Design, Coding, Peer Review, Testing, Implementation, Configuration Control, and coordination with Onsite team.
• Gained expertise in developing data/dimensional models for Emerge data warehouse, and data mapping; Creating, testing, debugging and tuning various database objects.
• Developed multi-dimensional data models in ERwin and provided Data Mapping documents.
• Created Data Model using Erwin and Visual Studio tools, worked with ETL engineers and SSIS engineers for requirements to Data extraction, create and validate extract packages and validated data profiling tasks.
• Liaised between technical staff business users by having a thorough understanding of interpreting customer business needs and translated them into application and operational requirements.
• Proactively communicated and collaborated with external and internal stakeholders to analyze information needs and functional requirements and deliver the following artifacts as needed: (BusinessRequirements Document, Functional specifications,Businessand Process flow diagrams, Use Cases, GUI/Screen and Report mock-ups).
• Provided IT technical expertise coupled with an understanding of property and casualty insurance that support the maintenance and development of the company’s software applications.
• DocumentedConfiguration requirements,BRD s, mapped systems with Claims Center data dictionary, wrote new rules and modified existing ones.
• Prepared use cases and/or user stories for all functions, mapped all the use cases against functional requirements and modified documents for plans and benefits for new workflows.
• Extensively performed Business Process Mapping (BPM) and XML data mapping documents.
• Communicated with Development and QA teams to ensure business requirements and expectations are understood, clearly documented and successfully implemented.
• Followed and supported change management process, including documenting scope and impact of change.
• Collaborated with integration users and technical team to develop and review requirements.

Environment: MS Visual Studio .NET, Windows Server 2012, UNIX / Oracle Platform, MS Visio, Office 365, Sharepoint2013, Claims Center, Policy Center, Erwin

Confidential, Philadelphia PA

Business Analyst

Responsibilities:

• Responsible for requirements gathering, requirements documentation and creating Agile User Stories for enhancements to business rules from T+1 and T+2 security transactions.
• Met with brokerage group and client partners to determine user requirements, utilized customized template models in Office 365, developed business processes, standards, procedures and created Business Requirement Document, Functional Specifications and managed document repository in Sharepoint2012.
• Interacted with the SME’s and stakeholders to get a better understanding of client business processes and gather business requirements.
• Worked with integration analysts to understand shared code, used U-Deploy to making build deployments to QA and INTG environments, also worked with developers in code review stages.
• Worked with both Business and Technology teams to translate business requirements into usable, codable and testable User Stories, created and managed Product Backlog and Iteration Backlog.
• Recommend strategic initiatives and analyze OTC derivatives protocols and practices around DTCC.
• Assessed integration requirements with Asset Mix information, Asset Layout and Customer Derivatives.
• Analyzed business requirements and developed Use Cases, Activity and Sequence in UML models.
• Derived Functional Requirement Specifications (FRS) based on User Requirement Specification URS.
• Understood and articulated Business Requirements from user interviews and convert requirements into technical specifications, provided technical reviews to system and architecture teams from Change Requests.
• Analyzed methodology for creating and maintaining Unique Client Identification Methodology (ERM).
• Managed Iterative Development and Release pipeline, used JIRA and Confluence for Release reports.
• Defined program and project goals, objectives, products, services, constraints, assumptions, risks and facilitated processes by working with the project team, sponsor, and stakeholders to baseline the scope of the work and enable development of the plan.
• Worked in Agile Delivery Model to design User Stories for iterative development, worked with delivery teams to translate system requirements into story documents, received input and estimates for Scope capture.
• Worked with Data teams, documented specifications for TAM Analytics and used Tableau for reporting.
• Responsible for extensive level of project documentation. Wrote concise detailed system requirements specification (SRS) documents and user documentation in accordance to guidelines and standards of a level where developers can interpret, design and develop the application with minimum guidance.
• Ability to work with all members of the project team, following the project through the Systems Development Life Cycle and ensuring that business objectives are met.
• Worked extensively on the documentation of Data Requirements, Data Management Plan, Scope of the project, and functional requirements document.
• Assisted Product Management in creating Release pipelines based on system scope, performed Scope management, itemized backlog items into planned releases and created Story Board presentations to teams.
• Developed strategic partnerships with the business units to develop a solid knowledge base of the business line; including the business plan, products, and process and revenue streams.
• Maintained Issues Tracking Worksheet to track issues and rectify it accordingly and used HP ALM for Defect Management and performing User Acceptance Testing. I have been the owner of UAT for SEI business teams.

Environment: Rational Requisite Pro, JIRA, UML, Rational Rose, JAD, MS-Office, Apache Tomcat, Sitescope, U-Deploy, Jenkins and Product Management.

Confidential, Atlanta, GA

Business Analyst

Responsibilities:

• Coordinated with the Business teams in Requirements Elicitation, conducted workshops.
• Created system requirements document for cloud integration of LOS and Big Data management.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Worked with ETL teams and Data Management teams to understand OLAP processing systems, worked with technical teams to define functional requirements for LOS data mapping and bootstrap utilities.
• Documented Screen Design Specification (SDS) documentation for LOS integration - Loan Pre-request electronic forms, Mortgage Loan Origination form, Loan Information, Employment & Incomes screens, etc., and drafted UI wireframes documents for review with business teams.
• Created data models for backend system integration with EDW, validation tested target systems for data integrity, performed database validation and used SQL queries to perform validation.
• Used SQL Developer to connect and query multiple data repositories, performed SQL JOINS, SQL functions to extract data, data mining and validated results with functional teams.
• Used data repositories to design reports, visualization of Business Intelligence models and demonstrated to business teams on graphical representation of charts, data analysis and trending on LOS over time.
• Assured that all Artifacts are in compliance with corporate AGILE Policies and guidelines.
• Assist in the planning and coordination of all required tasks prior to each sprint to ensure all necessary artifacts are ready for the Scrum team's consumption.
• Streamlined reserve review analyses through highly automated Excel spreadsheets using macros and pivot tables making the reserve process efficient and allowing more time for analysis of results.

Environment: HTML, Agile, Scrum, JavaScript, MS Office, SOAP, Quality Center, MS Visio, Virtualization, ETL, Big Data platforms, SQL Developer, Reports, Pivot Tables, Charting and Reports.

Confidential

Business Systems Analyst

Responsibilities:

• Worked on FinacleCRM (Customer Relationship Management), a universal banking solution by TCS, using technologies such as Java/J2ee, PL/SQL, JavaScript, and XML/XSL.
• Carried out implementation of enhancements in the base product using Java/J2EE, JS, PL/SQL, and XSL.
• Prepared high level (HLD) and Low level (LLD) design documents and UML documents for application design and system workflow for technical requirements.
• Extensively used XML for web services development and testing, performed XSD data mapping updates.
• Identified UAT Test cases, and implemented Integrated Unit Testing (IUT) of base FinacleCRM modules.
• Performed UAT Testing for FinacleCRM web application.
• Developed effective test plans/scenarios through consultation with clients, analysts and development team.
• Derived UAT test cases from use cases/user stories, and tested various ETL process transformation rules based on log files, data movement using SQL, Splunk tool.
• Developed SQL queries to retrieve or create test data from different Oracle test databases.
• Creating and setting up test data, executing batch jobs via Autosys using JILs.
• Performed functional testing, sanity testing, and regression testing involving multiple test environments.
• Performed UAT testing in the UAT environment prior to notifying to the customer to start performing UAT testing.