SUMMARY

• 10+ years of experience as a Business Analyst/Business System Analyst in industry domains including Banking, Healtcare, Financial, Insurance, and Retail.
• Skilled Business Analyst in PMO environment who leads projects to successful completion and acts as liaison between business users and technical development teams to bridge gaps.
• Strong understanding of financial valuation concepts and various capital market instruments and processes including Equities, Fixed Income, Foreign Exchange, Derivative (OTC) & Back - Office operations, Basel III, Dodd-Frank Act and Comprehensive Capital Analysis and Review (CCAR).and experienced in Black Rock Alladin, Bloomberg, Reuters.
• Well versed with Investment banking (Equity trading, Future's market, Forex market), Commercial Banking and Retail banking (Mortgage, Student loans, Credit and Debit cards).
• Extensive experience with being a Functional Expert in Supply Chain (SCM) modules and Financials modules (ERP) of OM, Shipping, AR, INV, GL, Advance Pricing, Inventory.
• Comprehensive knowledge in implementation of business systems including Procure to pay (P2P), Order to Cash (O2C), inventorymanagement and financial modules.
• Worked on various CRM salesforce.com standard objects like Accounts, Contacts, opportunities, Products, Price books, Cases, Leads, Campaigns, Reports and Dashboards .
• Good understanding of Healthcare Industry claims management process, Medicaid and Medicare Services, Health care Reforms and Insurance sector.
• Experience in HIPAA transactions 837(Institutional/Professional), 835(Payment Remittance Advice), 270 (Eligibility Request) / 271 (Eligibility Response), 276 (Claims Status Inquiry Request) / 277 (Claims Status Inquiry Response), 834(Benefit Enrollment and Maintenance Transaction), 278 (Prior Authorization), 997 (Transaction Acknowledgement).
• Experience on Guidewire (P&C) Policy Administration System (PAS).
• Working knowledge of Amazon Web Services (AWS) and Cloud Data Management.
• Expericed with cloud marketing, marketing automation, cloud sales (CRM Salesforce), APTTUS, Pardot, Wave Analytics, Discovery, quote to cash C2C,and CPQ.
• Exceptional problem-solving and communication, with in depth understanding of Big Data Application, Databases, Enterprise Architecture and Cloud technologies. Enjoy getting hands-on development experiences.
• Worked on Home/Dwelling/Auto lines of business in P&C domain.
• Proficient in designing placeholders for ads and integrate with ad-exchanges. Shopping carts, site themes and payment gateways in CMS like Drupal, Joomla, ATG and self-hosted websites.
• Experience with different payment gateways (Pro PayPal, Authorize.net) for e-commerce solutions and documentations.
• Experience in working on Oracle Identity Management System to include: OIM, ORM, OAM and OTM pieces.
• Extensive experience in project management best practices, processes, & methodologies including Waterfall, Agile, SCRUM, and RationalUnified Process (RUP), Scaled Agile(For large teams), SAFe.
• Worked in Agile environment and involved in sprint planning meetings.
• Participated in Scrum meetings to handle unpredicted changes and effectively deliver the product with in the given deadline.
• Been part of SAFe Scale Agile team and managing big teams of more than 30 people.
• Experience with the Atlassian JIRA and Confluence.
• Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.
• Good understanding of Data Warehousing concepts including Data Marts.
• Experience in prototyping of web based applications for critical IT projects for a better user experience using iRise and Gliffy.
• Strong Understanding of Data Modeling and Business Process Modeling.
• Experience in consulting with business clients, creating Tableau dashboard reports, collaborating with developer teams, using data visualization tools, and using the Tableau platform to create business intelligence visualizations.
• Excellent skills in performing Gap Analysis, Feasibility Analysis, Knowledge with BABOK standards and methods, Strengths, Weakness, Opportunities, Threats (SWOT) Analysis to check the compatibility of the existing system infrastructure and server technology with new Business Requirements.
• Proficient in executing Test Plans, providing Test Data, conducting unit test, documenting test cases and in Manual Testing - Functional, Database, Black Box, Positive-Negative, and Regression testing.
• Experience in writing User manual, conducting functional walkthroughs, and in performing extensive User Acceptance Testing (UAT).
• Ability to manage multiple, concurrent projects, activities and tasks under time constraints.
• Pragmatic approach towards any task, excellent communication skills, have handled stakeholder conflicts and delivering as per promised on a strict and disciplined time line.
• Bringing whole team on the same platform, having communication channel open both ways in business terms with sponsors and technical with architect, developers, QA teams and implementation teams.

TECHNICAL SKILLS

Business Analysis Skills: Scope Initiation, Business Proposals, Requirements Definition, Problem Resolution, Structured Walkthrough, Workflow Analysis, Gap Analysis, Design Review, Business Process Management, Product Management, Business Impact and Risk Analysis, Gate Review, Confirmations, Post-Implementation Review, Defect Management, Data Analysis, Data Reconciliation, Data Governance and Data Management.

Project Management Skills: Change Management, Client Relationship building, Risk Management, Strategic Planning and Reporting, Technical Writing, Budget Planning & Cost control, Vendor Management, Strategic Change Management, Onsite-Offshore Management, Virtual team Management.

Testing Tools (QA): HP ALM, HP Quality Center/Test Director, HP Performance Center/Load Runner

Business Process Modeling: UML/ Use Case Diagrams, Class Diagrams, Object Diagrams, Package Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Communication Diagrams, Component Diagrams, Deployment Diagrams, Process Flow, ER Diagrams and Data Flow Diagrams (DFD)

Database: Oracle 11g, 10g, Oracle 9i, Oracle 8i and Rainstor file system, NoSQL (Mongo DB)

Oracle Applications: OAM, OIM Suite, Oracle 11i &R12 - GL (SLA ), AP, AR, FA, CE, OM, PO

Languages: SQL, UML

Operating Systems: MS-Windows

MS Office: Word, Excel, Outlook, PowerPoint, Visio, Project

Collaboration Tools: Microsoft Live meeting, WebEx Products, SharePoint

Miscellaneous: Salesforce CRM, Tableau, Amazon Web Services (AWS), Guidewire 6.0, Actimize (AML), iRise, Gliffy, JIRA, Black Rock Alladin, Bloomberg, IBM Rational Rose, Smart Draw 2008

PROFESSIONAL EXPERIENCE

Confidential

Business Systems Analyst

Responsibilities:

• As soon the project was identified reached out to stakeholders and gather more information about project on high level.
• Organized and hosted API Intake Interview with the projects. Engaged with project team and Middleware team (Solution Architects, Product Owner, Principal Architect and assisted in decision making, of the solution)
• Balanced the workload and requirements distribution with the POD’s as majority of the project requirement were Waterfall and Middleware being in Agile.
• Worked hand in hand with two Product Owners, briefing them on the requirements gathered, analyzed if bank have any existing API’s or services that bank can leverage or enhance.
• Created Epics, use-cases, user-stories, with definition of done& Acceptance Criteria on JIRA board.
• Maintained, updated, uploaded Middleware related documents on Confluence.
• Provided budget estimates to the project and intial analysis on the list of the services available based on the project requirement.
• Worked and created mapping documentation, component design document, and broker services document, uploaded on SVN for middleware on SVN.
• Worked on the frist ever project to instantly issue a debit-card to the customer. Backend was vendor. Constantly engaged with vendor and flushed out the design/YAML/Swagger needed for development. Helped solution architects in resolving the complex logic and workflow of the requirement.
• Supported end to end development from gathering the requirement, assisting with desing, development and deployment.
• Gathered test account data for the testers, for dev and SIT regions.
• Helped tester writing the test cases, and handing off the testing to do component testing in SIT region.
• Worked on Customer Care project, and dealt with all they types of accounts for both consumer tower and commercial tower, Savings, Checking, Credit Cards, ALS, AFS, Mortgage, Brokerage, Purged Accounts, SBA (Safe Deposit Box), RMS(recovery management system). Project had two work flows an unique requirement to identify MLS (service members on Customer level to the account level).
• Helped designing Customers API on swagger, and lone handedly created API User Guides for enterprise wide standard API.
• Constantly engaged in with stakeholders and understanding the requirements. Identifying the back-end services, engaged with backend resources for mapping of the middleware API fields to the back end fields.
• Worked on Real Time Payments requirement, to have a real time payment interface, from intiating the payment, or requesting the payment, identifying the receiving bank is part of the network, knowing the status of the bank whether online or not, and receiving the payment.
• Worked on Composite Deposit account(CD) a product within Savings Account, on how the payment and interest distribution spread should be whether direct deposit, pay to the affiliate, pay by check, or the pay to the joint-account holder.
• Engaged with Access Optima, and integration of payments API with backend system of recordLoanIQ, worked on multiple requirements from getting the accoutlist, and transaction history and merging them into one response for the report generation for front end users.
• Worked on Loans API, and the error handling and messaging of the transaction status to the customer. Helped developers with the IIB Component development and writing the logic.
• Managed all deployments in across all regions SIT, QA and Prod migrations. Sending out email communications to all the consumers on the deployments and the changes on the version of the API.
• Worked on salesforce for commercial banking and cosumer banking, on asset finance for lending & Loans portfolios, SSO, requirements.
• Helped in development of Year End Tax Reporting services, adding new fields that IRS requires and supported end to end migration till Prod and delivered product on time due to compliance time-bound requirement.
• Reviewed SRD & BRD for the projects flushed out Middleware requirements, gathered solution architects on the design and logic of the new services to be built or enhancing the existing one.
• Worked with off-shore teams on many requirements, which included developers & testers.
• Engaged with project on ACH calims, on reversal payment and stop payments, PEP+ as vendor.

Environment: - JIRA, Swagger, YAML, APIC, SOAPUI, Lucid Chart, MS Word, Excel, IBM-IIB Portal,JSON, JAVA, XML SPY, XSD, WSDL,Jenkis, Github SVN/Tortoise.

Confidential - Austin, TX

Senior Business Analyst

Responsibilities:

• Engaged in migration process strategy of entire data, which included all 7 regions across the globe.
• Constantly engaging with business on their needs and assuring them on the data migration and compliance on GDPR (which got into effect while ongoing project).
• Validation of SOX compliance.
• Been part of the decision making and finalization of vendor and intranet product. (O 365, Bonzai).
• Part of the monthly budget meetings, and leveraging the IT teams for approving the upcoming projects by giving presentations to the Executive Branch.
• Worked as Finance BA on creating Deal Reviews, and giving executive summary for budget approvals, and creating CAPEX &OPEX requests for final decision making.
• Constantly engaged with vendors and briefed them with the requirements, scheduling them for the business team for demo sessions and handled the entire NDA agreement process before engagement of the vendor and client.
• Detailed out the migration process, and the elements of the data that needs to be intact.
• Created backup data plan with retention period of 5 year, and ran SQL queries to verify the backup data is accessible.
• Co-ordinated and organized off-shore teams during GO-LIVE and accessing Akamai for any redirects needed.
• Managed entire project on Microsoft Project, scheduled daily sync ups with Product Owner and resolved any issues such as GDPR, migration strategies, approvals needed, financial road blocks.
• Was the power user, for the new intranet, and trained KPIs, and other employees of the organization on how to create their pages, where the data resides, how sharepoint works, how to migrate archived data to the new intranet pages.
• Supported all the issued tickets and resolved on a timely manner.
• Created stake holders list (80), from each business unit for the Business Process Alignment and Management. (BPM)
• Assisted a rigorous 39 days’ workshop “Sales Simplification Workshop”.
• Understood the pain points of each business units and made extensive notes, gathered requirements.
• Did AS-IS and TO-BE analysis, found GAPS and resolved those GAPS in the process.
• Mapped business requirements with different units who were working on the same opportunity but had no visibility on other BU.
• Captured TO-BE process from white board to MS-Visio and Lucid Chart simultaneously and presented to the stakeholder, had one on one sessions, JAD sessions and brain storming with Executives and other stakeholders on how to enhance & improve the current business process.
• Worked with MDM consultant to organize the data.
• Engaged with Forecasting team, on how to improve the data quality and have a better and accurate quarterly forecast. (Resolved OPN challenges via data cleansing)
• Created RFP for multiple business units, forecasting, pricing, marketing communicating with stake holders and validated it with both IT and business units
• Helped CPQ (Pricing team) on MS-CRM dynamics (COMPETE) for the post pricing process. Capturing the DPA (Disti Pricing Agreement).
• Redesigned organizations opportunity pipeline.
• Maintianed Clarity and Troux on a weekly basis for internal reporting of the status of the project for executives.

Environment: NDA, Sharepoint, Bonzai, O365, MS Project, Lucid Chart, MS Visio, Aure, SQL, Power BI, whiteboard, Excel, Powerpoint, Akamai,EPM, EDW, SAP, Marketplan, SilverPOP, MS-CRM, Clarity, Troux.

Confidential - New York, NY

Senior Business Analyst

Responsibilities:

• Experienced in working with clients to map out their existing Business Processes and providing system-based solutions that increase efficiency and reduce operating costs.
• Connected different departments of the city for a better communication channel, and significantly reducing the pending case processes.
• Gathered requirements while communication with various stakeholders from many departments, and tailored a fuctional plan for the system based on reliabitity, performance, and security .
• Organized JAD sessions, brainstorming, focus groups, and surveys for requirement gathering and translating it to BRD & FRD .
• Communicated with SMEs on regular basis to understand the city processes and dependencies of each department on one another.
• Executed duties of data collection from 3 rd parties, client facing through modes of email, phone and in person.
• Work on various salesforce.com standard objects like Accounts, Contacts, Leads, Campaigns, Reports and Opportunities.
• Involved in Salesforce.com Application Setup activities and customized the applications to match the functional needs of the organization.
• Maintain release notes and release plan for every release. Effectively communicate with client, team in Knowledge Transfer sessions.
• Closely work with SalesForce.com teammates while implementing the solutions for the requirements.
• Develop several Triggers, Apex classes and Visual force pages as part of the application development.
• Work on various salesforce.com standard objects like Accounts, Contacts, Leads, Campaigns, Reports and Opportunities .
• Prepare estimations - effort and cost estimations to augment sales proposals - Support at external and internal customer facing events - as a technical representative to support business calls - Build custom demonstrations and deliver Proof of Concepts (POC).
• Participate in requirements Gathering and Involved in Salesforce.com Application Setup activities and customize the apps to match the functional needs of the organization.
• Create page layouts, search layouts to organize fields, custom links, related lists, and other components on a record detail and edit pages.
• Implement pick lists, dependent pick lists, lookups, junction objects, master detail relationships, validation and formula fields to the custom objects, Web to case, Email to case.
• Integrate SFDC system with Microsoft Outlook .
• Create workflow rules and definerelated tasks, time triggered tasks, email alerts, field updates to implement business logic.
• Develop Custom Reports and Dashboards as per given requirements.
• Create test scenarios on Sandbox environment, created packages and moved it between Sandboxes and Production environments to place final implementations.
• Hands on working experience in Profile, Roles, Permission Sets, Role Hierarchy, Custom Profiles and public Groups creation and user management.
• Work with the client to understand their current business issues and pain points ; identify the desired to be process models and solution architecture that will address the issues and pain points.
• Involved in Salesforce.com Application Setup activities and customized the apps to match the functional needs of the organization.
• Interact with various business team members to gather and document the requirements.
• Implement the requirements on Salesforce.com platform and Force.comIDE Plug-in using Eclipse.
• Work on various salesforce.com standard objects like Campaigns, Leads, Accounts, Contacts, Opportunity, Forecast, Cases, Reports and Dashboards.
• Implement Web-to-lead to track and solve leads from the website.
• Create different workflow rules and Approvals for various campaign processes .
• Design and develop the Customobjects, validation rules, Page layouts, Custom tabs, components, Visual Force Pages to suit to the needs of the application.
• Worked on Visual force pages functionalities in sand box before it is given for deployment.
• Assisted with APEX classes to developers in implementation and integration with external sources.
• Worked on Wave Analytics, uploading of data of various formats converting to CSV, creating datasets and drilling down to specific zones to focus more on the client market.
• Using different connectors Dell, Boomi, Mule for data uploading into Wave Analytic Platform.
• Capturing BI requirements and design them into dashboard(Wave Analytics).
• Using and creating back end Json, editing over Json lint in a more organized form and applying changes to it as per scenario and situation.
• Securing the data on Wave Analytics Platform and access given to people to who it concerns.
• Created and edited SAQL for data manipulation and editing on Wave Analytics.
• Used different transformations append, augment, delta etc.

Environment: Saleforce.com platform, Apex, Visual Force, Data Loader, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Security Controls, Sandbox data loading, Data Loader, SF Explorer and Eclipse IDE Plug-in, AppExchange apps, Flows, SOAP/REST API Wave Analytics, Agile/Scrum Framework.

Confidential - Boston, MA

Business System Analyst

Responsibilities:

• Gathered and Business and Functional Requirements (BRD, FRD), during JAD sessions.
• Interacted with the stakeholders, developers, Project Manager and SME have to formulate Business Processes.
• Worked with marketing team for revenue generation aspects and finding target audience.
• Prioritizing requirements along with product owner in backlog which adds the most value, and is a stable and viable product.
• Worked in Cross Functional team environment, served as a liaison between SME's, Project Manager, and stakeholders to ensure accuracy in the SFDC implementation and other business requirement.
• Developed Customer portal to implement Web-to-lead functionality and enable lead capturing in real time and implemented and automation products with marketing automation techniques.
• Maintained and improved existing Salesforce implementation. Created Fields, Record types and Page layouts.
• Created newreport types, new reports and dashboards to monitor and issue regular key productivity indicator reports and chart.
• Created Email Templates and letterheads and used them in workflow Email alerts.
• Worked on Process flows, Wireframes and Mockups for the application.
• Configured/Created Profiles, Roles, and Permission Sets, Sharing Settings, Custom settings for the organization and setting up Field-level, Object-level security rules for the application.
• Developed Validation rules, Workflows and Formulas in different scenarios.
• Used Apex Data Loader to Load the data in to application.
• Worked with Lightening components, which help to build communities better.
• Worked with Apex Classes and Apex Controllers, Apex web services, Apex callouts.
• Working on the administrative part of the application in Salesforce.
• Researched and updated the new abilities of Salesforce into the organization.
• Performed Unit testing, Integration testing, Bulk testing, Staging and User Acceptance Test in Full Sand box
• Documented the entire process starting from Requirement document to end user training document.
• Developed attitude and capability to handle multiple projects at the same time including Onsite/Offsite co-ordination and also with offshore teams.
• Helped in conducting Gap Analysis (GAP),User Acceptance Testing (UAT), and System Integration testing.
• Designed Escalation rules, Automatic case generation and their escalation to call center representative, and generated email alerts for quick issue resolution.
• MDM managed information about products, with a focus on data required to market and sell products.
• Provided in-depth analysis to resolve production and application issues.
• Provided a concrete explanation of resolutions to issues, inquiries and requests.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.
• After deployment of the product giving end user proper training on how to consume the product.
• Training other staff member on how the process would work by creating pipeline, and building process builder and process visualizer.
• Involded in creating dashboards, reports as needed using Tableau Desktop and Server.
• Created users, groups, projects, data connection settings as Tableau Admin.
• Extensively used TabAdmin and Tabcmd commands in creating backups of Tableau repositories.
• Installed latest versions of Tableau and keeping the system upto date.

Environment: Salesforce.com, Apex (Classes-Controllers-web services), Outbound messaging, Data Loader, Wiki pages, MS Project, MS Visio, UML, JIRA, Agile, Tableau, Windows,SQL,SAS.

Confidential - Indianapolis, IN

Business Analyst

Responsibilities:

• Functioned as a business analyst for the company that creates business applications and middleware that utilize a rules based engine to determine eligibility for insurance and health care companies such as.
• Perform business process analysis of eligibility and case management. Validate the automated system supporting the operations of the client.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Created use case scenarios and documented work flow and business process using MS Visio.
• Gathered and documented business requirements for existing and future business systems.
• Analyzed and tested various Common Eligibility Outbound Interface Process and other Inbound/ Outbound Facets interfaces.
• Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns.
• Analyzed current MMIS and EDI claims and documented the requirements to implement new MMIS automated system.
• Defined Functional Test Cases, documented and executed manually using quality center.
• Analyzed trading partner specifications and created EDI mapping guidelines.
• Responsible for Data Manipulation and Data Validation using SQL queries in a MS SQL Server.
• Helped with building ICD 9 to ICD 10 crosswalk map by grouping thousands of codes and ranges in Clinical, Benefits, Financial, Medical policy waves.
• Participated in Forward Mapping and analysis of ICD 9 - ICD 10 Conversion, for CM (Diagnosis Codes) and PCS (Procedure Codes).
• Working within a growing environment of X12 HIPAA Transaction Processing 837 I, P, D, 835, 834, 820, 270, 271, 276, 277, 278, EDI, Privacy, Security, and Medicaid.
• Worked with multiple teams to improve the overall reporting of the Claims, payments, Real-time adjudication information.
• Developed test cases based on the crosswalks and compliance guidelines for 837 Professional and Institutional claims and for 270/271 Eligibility inquiry and response.
• Assisted in designing and developing Use Cases, Activity Diagrams, Sequence Diagrams, Object Oriented Design (OOD).
• Reviewed EDI companion guides for all payers to ensure compliance, edit integrity and maintain up-to-date list of payer contacts.
• Written test cases, test scenarios, and prepared test data to conduct the manual testing of EDI files and the mainframe screens.
• Tested the application manually by executing Test Cases in Quality Centre prior to Automation and Involved in automated testing.
• Performed functional testing with the development team as well as User Acceptance Testing and Regression Testing of the application using Quality center and JIRA for prioritizing defects and assigned it to the developer to fix the bugs.

Environment: Agile/SAFe(ScaleAgile), MS Office Suite, MS Visio, MS access, SQL, Quality Center, JIRA, Java Script, Project Management, QTP