SUMMARY

• Business Analyst with 9 years of proven work experience in agile environment leading all Scrum ceremonies.Have been versatile working in different environments using agile.
• Acted as a liaison between technology and the business.
• Worked in all phases of SDLC with proficiency in Requirement gathering, Analysis, Design, Documentation, Data Analysis, Data Mapping and Data Modeling, Testing, Implementation managing business analyst functions and providing executive level support to principals.
• Superior interpersonal and analytical expertise with a flair for increasing organizational cohesiveness and profitability through talent assessment and employee management.
• Utilize management experience to align financial and business activities with organizational goals, fostering business growth.
• Comprehensive knowledge and experience in Software Development Life Cycle (SDLC) with business process models: Waterfall & Agile (Scrum) methodologies, Scaled Agile Framework (SAFe).
• Good understanding of the AS - IS and TO-BE business processes (GAP analysis) and experience in converting these requirements into technical specifications for preparing test plans
• Participate in various Agile Ceremonies; identify/define business processes/ User goals/User stories. Managed various stakeholder's groups, gather & manage Business, functional & non-functional requirements.
• Proficient in creating various documents like Business Requirements Document (BRD), Functional Requirement Document (FRD), Functional Specification Document (FSD), Systems Requirements specifications (SRS), Object Oriented Analysis and Design (OOAD).
• Extensive experience in Guidewire configuration and integration experience with claim center, policy center and Billing Center.
• Strong experienced in all insurances such as Property and Casualty Insurance including Auto, Home, and Marine.
• Worked in various healthcare functional areas like Enrollment/Membership, Benefits, Claims, Providers, Eligibility, Encounter, Estimator, Payment solutions, Population Health Management.
• Strong working experience and familiarity of emerging regulatory standards including Basel, Dodd-Frank Act Stress testing, CCAR, KYC and AML.
• Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Personal Property Casualty, Group and Life Insurance Systems
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) and established service level requirements which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Integrated Pershing's NetX360 Web services for opening Brokerage and Managed Account for Private Bank Customers via Straight Through Processing
• Working Knowledge of Equities, Fixed Income, securities, investment performance, IRA's, foreign exchange, bonds and derivatives, insurance, mutual funds and check processing, trading & risk environment, credit, interest rates, Treasuries, alternative investments - Commodities, Foreign Exchange Trading.
• Responsible for the Integration, Functional, System and Acceptance testing of the IVR applications.
• Extensive working experience in Sitecore platforms like Web Content Management.
• Expert at interacting with stakeholders, Subject Matter Experts (SMEs) and end-users to understand, analyze, communicate and validate requirements using Joint Application Design (JAD), Joint Application Review (JAR) sessions
• Assisted teams in creating different SSIS and SSAS packages in different Control Flow and Data Flows.
• Experienced in writing User stories with acceptance criteria or User stories with Use case
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, using UML and Business Process Modeling (BPM).
• Verified that Risk-Weighted Assets (RWAs) were adequately measured against Tier 1 capital to ensure AIG's capital ratios meet regulatory capital requirements.
• Experience developing various state, activity, class and Use Case Diagrams to better understand the process dataflow
• In depth knowledge of Rational Unified Process (RUP) methodology
• Developed various Flowcharts, activities, Use cases, state charts and process flow diagrams to better communicate and visualize the business flow using Unified Modeling Language (UML) tools
• Proficient in ensuring that business goals are met throughout the product lifecycle. Proficient in creating Behavioral and Structural UML diagrams including Activity, Sequence, Data Flow and ER Diagrams.
• Performed rigorous testing with QA team to prevent potential production issues and ensuring that the application is functioning as per the business requirements
• Involved in all phases of Product Lifecycle Management (PLM).
• Involved in GUI testing, Functionality Testing, Regression testing, System Testing, Unit Testing, Integration Testing, Performance Testing, and Stress Testing.
• Monitored UAT and regional teams testing plan to match BRD and lead bug triage sessions.
• Effectively communicated with testers and management in TRIAGE meetings to decide priority (P1-P3) and severity (S1-S3) of bugs and work items based on end user feedback from User Acceptance Testing (UAT)
• Hands full of experience in MS Office Suite, MS Project for Project Plan, MS Visio, Rational Suite Rational Rose, Rational Requisite Pro, Rational Clear Case and Rational Clear Quest.
• Expert in UAT during solution implementation Phase (manual testing). Also interacted with team of QA to convey business requirements
• Good knowledge of Wealth Management Accelerator (WMA), Wealth Management
• Wrote Process approach documents and SIPOC mapping for TL 9000 quality compliance
• Proficient in developing & automating reports, iteratively build & prototype BI dashboards using Tableau to provide insights at scale, solving for analytical needs of business team.
• Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
• Knowledge of all Commercial Insurance Rules and State Filing Requirements/ISO/NCCI
• Coordinate deployment of IT solutions on Clouds (AWS, Microsoft Azure)
• Have strong knowledge on fraud and anti-money laundering applications.
• Design, documentation and review of business documents like business Requirement Document (BRD), Functional Requirement Document (FRD) and System Requirement Specifications (SRS).
• Microsoft Dynamics CRM 2015, CRM 2013, CRM 2011, 4.0 Business Analyst, Technical Analyst, System Administrator, CRM UI Configuration Manager, and CRM Reports, View Workflows, Dialogs, SSRS design expertise.
• Advanced and expert skills in various BI tools like Tableau, Power BI, Qlikview,NPrinting and MS Excel including PowerPivot and PowerQuery
• Strong experience on various P&C insurance modules including Claim Management, Bill Management, Policy Management, Payments, Claim Offline Tool and Medicare Claim Reporting Tool.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis and ROI Analysis.
• Organized weekly project status meetings and task review meetings documented and disseminated meeting minutes effectively
• Utilized a combination of business knowledge, technical skills, and strategic analysis to provide solutions and creative insights to critical business problems
• Good Communication skills and capable of working independently and as well as a part of a team.
• Capable of forming and maintaining positive and productive working relationships in internal, external, independent and team environment

TECHNICAL SKILLS

Process Methodologies: RUP-Rational Unified Process, UML- Unified Modeling Language, Waterfall, Agile, Scrum process, Kanban

Project Management: MS Project, Excel Spreadsheets

Languages: C, C++, SQL, Oracle, Java, AML Language

Universal: VISIO

Quality Management: JIRA,Rally,Confluence, Mercury Quality Center, Analysis

SDLC process: Clear Management, Clear Quest, SharePoint

Object- Oriented: Rational Rose

Office Tools: MS Word, Excel, Power Point

Testing: Unit Test, Win Runner, Load Runner, and Manual Testing, UAT-User Acceptance Testing, Selenium

Databases: MS SQL Server, MS Access,Balasamiq

ETL Business Intelligence Tools: Alteryx 9.x, SSIS,SSAS, Tableau 8.x, 9.x, 10.x, Cognos, TIBCO

Web Languages: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Wyomissing, PA

Business System Analyst Risk/ Finance Domain

Responsibilities:

• Thoroughly studied the capital market structures and account reconciliation systems to have a clear understanding of the Financial business processes and associated system workflow
• Interacted closely with stakeholders and Subject Matter Experts (SME) for gathering requirements and created Product backlogs
• Collaborated with Scrum Master and Scrum teams in Sprint Planning meeting and Sprint review meetings. Prioritized Sprint backlogs and managed changes to Product backlogs
• Actively tracked the ROI for various components of the project
• Used ETL Process to map data from different sources to the target data-mart in IBM Cognos Data Manager, thereby reporting and analyzing events and metrics.
• Documented REST API via JSON using documentation tools(Swagger), used Swagger Specification and converted it API documentation and used Plugins for integrating with JAVA.
• Extensively used BI for analyzing securities including equity, foreign exchange, bonds; building analysis flow for portfolio rebalancing and monitoring asset class performance
• Created Single Sign On (SSO) Process Flow Diagram's utilizing Microsoft Visio tool by discussing with Technical Leads and Lead Business Analyst.
• Communicating key risks metrics as well as analyzing and providing commentary on daily and weekly movements to senior management through regular Meetings and Presentations.
• Extensively involved in the deployment of Data Warehousing System.
• Established processes for GDPR cookie compliance with OneTrust and internal auditing.
• Running adhoc reports and SQLs for data imports from different departments to BI platform for data analysis.
• Worked with SharePoint developers and stakeholders from 9 different teams to document requirement to migrate content from SP 2010 to SP 2013 and get UAT signed off post migration.
• Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market
• Actively worked with the Capital Market and financial trading team to develop Equities, Futures, Forwards, Options, Derivatives online trading facility
• Utilize Microsoft Excel to create spreadsheets that require sorting, organizing, and manipulation of data in accordance to project specifications (pivot tables, vlookup, and IF nested statements)
• Used Application Management tools for managing requirements and defects, specifically ServiceNow and HP Quality Center.
• Create data mapping documents to define required elements on inbound SWIFT, XML or FpML messages, as well as to define the expected data format; specific to OTC derivatives, ETD's, Commodities and FX transactions.
• Worked in ARGO Sales & Service (SNS) & Loan Origination System (LOS) application for the defects and enhancements for the releases.
• Participated in requirements gathering, high level design, as well as low level design for the new (IBM product) check processing (IPD - Image payments director) slated to replace existing CPCS. This effort was to implement a more scalable check processing system using more current language's (JAVA), and distributed hardware.
• Experienced in API Integration and Single Sign On (SSO) into a Service Oriented Architecture (SOA), web orchestrating service applications through the SSO services.
• Managing Service Now Integration with vendors system for Incident, Problem, Request and Change modules.
• Offered data support and checking using SQL/Query and developed complex spreadsheets using VBA\SQL.
• Worked with requirements analysts and Subject Matter Experts to identify, understand, and document business needs for the data flow to create market risk and credit risk modules
• Played a lead role in conducting JAD/JAR sessions, got requirement specification documents including Project Objectives, Business Requirements, and Business Rules sign off
• Consulted the business users and SMEs, helped to create Product Backlogs to prioritize features and subsequently created Sprint Backlogs
• Involved in content management change control and Version Management. Performed regular updates to various static web pages.
• Participate in JAD sessions with cross impacted IT teams to help ensure they have the information theyneed to determine their involvement (including PPL hours and commitments) and get the informationneeded for the cross impacted teams to plan their work efforts.
• Participated in JAD sessions with the reporting team to determine requirements for data that will besent from AEM to report environment to meet the business reporting needs.
• Create functional specifications for the data files that will be sent from AEM to report environment team, based on the data models created by the architectural and reporting environment teams.
• Performed rapid prototyping and screen Mock-up utilizing I Rise
• Used SAS and SQL to retrieve, validate and manipulate data
• Assisted Testing teams to build test plans, approved test cases for functional requirements verification and to check the functionality of the application
• Risk management: Market Risk using VaR, Historical Simulation, Variance-Covariance and Monte Carlo Simulation, Option Greeks, Credit Risk using Sensitivity analysis, Break Even analysis, Duration/Complexity Analysis, Scenario Analysis, Stress Testing and Back Testing.
• Tested the call flows for the IVR (Interactive Voice Response) System
• Review possible check fraud and unauthorized withdrawals. Identify red flags related to the various fraud types for retail banking or credit card products.
• Focused in Comprehensive Capital Analysis and Review (CCAR) Reporting, Governance, Risk & Compliance (GRC) and Dodd-Frank Regulatory Reporting, including FRY 9C, FRY 14M/Q/A.
• Conduct surveillance of SEF trades across multiple asset classes (rates/FX/credit/equities /commodities)
• Involved in the migration activities, where some part of SAP EP was migrated to JAVA
• Examines and evaluates the purpose and content of current business reports to identify opportunities for improvement and automation through macros, VBA, or SQL.
• Responsible for generating quick excel reports using Pivot Tables, and Advanced Formulas (Vlookups, Countifs, Sumifs, Sum product, match, offset, lookup, Hlookup, if conditions) Excel Macros (recorded, modified and executed) to automate some of the testing and reporting tasks
• Created UAT test plan (for AP &eBanking modules) that included test approach, test security, development & execution of complex use case user acceptance test scripts, scheduling of testing efforts, defect tracking for regression, training considerations
• Developed User Manuals, presentations and training manuals as per project specifications and timelines
• Provided status update to the Project Manager of progress made on work products and milestones achieved
• Reviewed by scrum team and BA team to improve their performance.

Environment: Agile, Windows, MS SharePoint, Oracle, .NET.IVR,Minitab, QI Macros,PowerBI, OBIEE, Cognos, Tableau, BABOK, MS Office Suite (Word, Excel, Power Point, Outlook), V-Lookups. Pivot Tables. JIRA, MS Visio, TL 9000 metrics, SQL server 2012, SQL, Mercury Quality center

Confidential, Austin, TX

Business System Analyst Finance Domain

Responsibilities:

• Implemented and integrated RUP solutions with a complete line of traceability for all the artifacts of web development projects.
• Supported the implementation, and ongoing improvement for a portfolio of ITOM processes for continuous tracking, reporting, and data quality
• Served as the 'AFS to Loan IQ' data mapping SME for the LIQ (Version 7.4) Conversion project.
• Worked closely with LPT team members, onshore and offshore developers, and business SME's and IV&V testers to ensure that all Loan IQ API data mapping documents were accurate and up to date.
• Wrote and maintained the 'Data Lineage Document', a comprehensive, high level data mapping document which captured every donor field being converted to Loan IQ and was used as a reference by the entire project.
• Responsible for ensuring accuracy, efficiency and timely flow of trade data between Loan IQ and Trade Settlement platforms as per LSTA guidelines.
• Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Pega Business Process Management (BPM) tool.
• Created complex Metrics Packet for the PMO team, Updated databases and amended training documents
• Triaged, remediated, researched, tracked and helped resolve Quality Center defects assigned to the LPT Loan IQ Conversion team through all the environments
• Worked on Table Maintenance, Adhoc query modules.
• Act as lead for desktop installation of NetX360 system of over 200 users
• Direct efforts for development of entitlement services for NetX360 system users by leading a selected team including access control/provisioning staff
• Creation and management of the GDPR traceability matrix to ensure all articles are implemented
• Analysis of current business procedure to ascertain GDPR gaps and means of bridging said gaps
• Design of the current processes that relates to GDPR personal data definitions
• Experience in creating Created Customer, Deal, Facility, Outstanding and many other transactions in Loan IQ.
• Worked on several LIQ interfaces, writing business, functional and data mapping documentation for several new Loan IQ batch and real time interfaces.
• Build Macros in Excel, using the record macro feature to automate sorting and filtering of large data sets. Created Pivot Tables making data user friendly for front end users, helping to manage a pipeline
• Merger related tasks included creating and maintaining data and process flow charts, as well as complex data mapping / data transformation spreadsheets.
• Worked with various teams to create 'As-is' and 'To-be' flows for identified critical data elements using MS Visio and PowerPoint.
• Designed various report layouts of different source systems that are built on the data marts based on the user requirements for different line of Business (Investment Management, Investment Services, Wealth management and Regulatory reporting teams).
• Data entered info via use of Calyx Point & DU & LP to prepare for underwriting
• Gathered functional requirements and wrote BRD's, FRD's (functional requirements specifications) and FSD's (functional system designs) for numerous Loan IQ downstream applications.
• Responsible for SIT (System Integration Testing) test planning, data validation and defect analysis using HP AML Quality Center.
• SME in Handling E-CIF/CRM functionality testing and queries individually or with surround systems such as internet banking, FEAS, IVR, CAPS, RLS.
• Used SQL to query data from the Security Master Database and gathered reference data from multiple live data feed sources such as Bloomberg, Thomson Reuters.
• Perform Sprint Demo during Sprint review ceremony and record feedback
• Identification of Performance Scenarios/Interfaces in the application based on the NFRs.
• Investigated software bugs and interacted with Dev team to resolve bug issues using MTM. Effectively involve in logging bugs, reviewing solved bugs and analyzing test result using MTM
• Development of the Content Management system and followed up closely with the development team for successful completion of the Content Management System
• Conducted daily scrum meetings to coach and mentor the self-organized, cross-functional Agile Project team on key principles of Scaled Agile (SAFe) competencies & practices including team ownership, commitment, effective user stories, agile estimation, and transparency.
• Compare current reports against new LOS functionality to identify reports that can be retired due to new system integrated workflow processes.
• Sent weekly dashboard reports to management with updates of the development process of the Content Management System.
• Performed requirements modeling and developed Analysis Diagrams, Activity Diagrams, Sequence Diagrams, and State Diagrams, Data Models, and Use-Case relationships using RUP tools in Agile Methodology.
• Assisted development teams in Testing for Bug Fixes in the daily builds and turn around for immediate fixes.
• Gathered Business Requirements from Product Owners to document requirements for mobile applications updates.
• Developed and expanded agile processes within the team such as estimation, task breakdown, sprint review, showcasing, and retrospective
• Designed various report layouts of different source systems that are built on the data marts based on the user requirements for different line of Business (Investment Management, Investment Services, Wealth management and Regulatory reporting teams).
• Worked very closely with Developers and resolved any issues they have during development cycles and co-ordinate with Business for any clarifications.
• Create weekly Status reports for Business to track the progress of the project and highlight any deviations from the proposed plan.
• Analyzed Java, J2EE environments and platforms that currently ran the organizations different locations. Identified and optimized Process Flows and underlying processes. Prepared business case documents for each location
• Provided coverage for AML compliance monitoring, CIP, KYC and OFAC. Assisted the Internal Audit Analyst for various work-streams within CCAR Audit - e.g. Basel III, Treasury/Liquidity, RWAs, Capital Policy/Planning, Risk Identification.
• Involved in the BRD, FSD and DDR reviews with Business, Developer and Mapper.
• Worked as a liaison among stakeholders to elicit, analyze, communicate, validate and document requirements for changes to business processes, policies on information systems including User Accounts Management (UAM), TDA Web, and Investment Portfolio & KYC Admin tools.
• Worked with Project Manager and Development Leads in creating Project Plans and updating the daily tasks.
• Assisted Testing Teams in translating Use cases to Test Cases. Also worked closely with Testing Lead in creating and validating Test Plans.
• Tracked all major and minor Bug fixes through completion. Validated production reports and escalated production bugs for immediate fixes.
• Maintained and kept track of stakeholder's request for enhancements and changes using Unified Change Management Tool (UCM) such as Rational Clear Quest and JIRA
• Used Rational Clear Case, Configuration Management Tool to maintain different builds of the application with description about all changes and versions.
• Interacted extensively with customers and UI designers to determine ways to improve the UI feel and the user experiences. Documented the gathered business requirements into detailed Business Requirement Documents (BRDs) for BASEL III and its Addendum.
• Created User Manuals and provided User Training for the changes made to Mobile and Website.

Environment: Windows, MS SharePoint, BosWeb, Kofax Thin Client, VEO Admin, Adobe Acrobat X Standard,SSQ, QC, Contact, NETX360, OFA (One for ALL), Laser Fiche, Policy Decisions, SNAP, PayPro, PMS (Mainframe), HP Application Life Cycle Management, DevInt, Documentum, Appway, Clientworks, BranchNet, AXA, Microsoft Lync, PGP,MS Office Suite (Word, Excel, Tortoise SVN,Power Point, Outlook), RDMS, JIRA, Rational Clear Quest, MS Visio, Java EE7, SQL server 2012, SQL, HTML, UML

Confidential, Rockford, IL

Business Analyst Insurance Domain

Responsibilities:

• Application of Simulation to understand the current system and identify problematic areas
• Used Simulation to verify the impart of Variability on the system and identified different levels of improvement
• Worked closely with the program manager and Project managers to define the scope and high-level requirements for the program
• Worked on the Claim Center integrations - Acuity(Litigation Management), Contact Manager, External Accounting Systems, ISO, OFAC
• Performed analysis of published Circulars from ISO/NCCI and other regulatory Bureaus for system impact and prepared detailed business and functional requirements.
• Planned activities for the BA group and provide estimates for BA activities
• Supported development of Project initiation, Project Charter and Project plans
• Worked in developing the wireframe and mock-ups for the prototype of the web-based portal application in MS Visio
• Extensive understanding & experience of migrating insurance suite solutions to Guidewire solutions.
• Created Process blueprints for Cost and Time estimates for migrating existing Savion Business Process Applications to IBM BPM.
• Provided detailed walkthroughs to all stakeholders Strategic Team, Business Users, development and testing teams and ensured functional adherence for Guidewire Policy centre implementation.
• Create mapping documents for ETL implementation; Create mapping documents from data source to Teradata target tables.
• Manipulate advanced Excel spreadsheets and data using intermediate to advance skill levels
• Worked on various User Stories related to Claim Center(Financial Summary, Reserves, Payment Exceptions, FNOL Process, Recovery, Vendor Ratings, Modular Reporting, ISO Claim Search, Internal Drafts, Reallocation, Payment Allocation, Reserve Allocation, Work Matter Summary, Maintain Work Plan, Maintain Activities, Executive Dash board, Special Investigation Unit, Claim Metrics and Cash Flow Management)
• Experience in Guidewire Claim enters, Policy center and Billing enter, claim center Integrations and Configuration User Stories.
• Excellent skill in creating Unified Modeling Language (UML) standard diagrams including Use Cases, Activity Diagrams, Data flow diagrams and Sequence diagram.
• Defined logic to correct many funds in AIS Dashboard for Master-Feeder Fund Structure for the fixed income instruments like Hedge Funds.
• Involved in preparing and reviewing Test Plan, RTM, Test Cases, Test report and resolving UAT issues. Involve in extensive data analysis on Teradata, and Oracle Systems Querying and Writing in SQL and Toad.
• Gathered business requirements for Auto Finance stakeholders.
• Scheduled and led requirements gathering through JAD sections for elicitation and documentation
• Document detailed business requires, Business rules, rating requirements, and coverage requirements
• Analyze Insurance forms and document forms requirements
• Compared actual and expected test results, discussed the defects in defect meeting with development team and then recorded/reported/tracked all Defects to Developers using a web-based tool called Rally (Bug, Issue and Project Tracking tool).
• Conducted JAD sessions and interviewed SMEs, asking detailed functionality aspects of Business Process (BPM) and carefully updating the information to the requirements in an easily understandable format.
• Worked closely with architect team to design solution to meet business needs
• Provided testing documents including test plan, test cases and verifications
• Performed GAP analysis and traceability matrix to trace missed requirement and variations in the actual results(As-is) as against the expected(To-be) software product states
• Acted as a liaison between Business users and project team (SME's, developers, testers, data team, Architects) to define business requirements and analyze the functional requirements for Personal Lines P&C Insurance.
• Used Rational Requisite PRO and DOORS in various P&C projects for requirements management and traceability among requirements, uses cases, business rules and test cases.
• Compared actual and expected test results, discussed the defects in defect meeting with development team and then recorded/reported/tracked all Defects to Developers using a web-based tool called JIRA (Bug, Issue and Project Tracking tool).
• Worked in Property&Causality (P&C)- Commercial lines & Homeowners insurance
• Compiled detailed documentation for technical teams (architect and QA) involved to be clear on the nature and item being worked on
• Gathered requirements for a fully electronic auto insurance contract process
• Create wireframes using Axure RP Pro based on collaboration with use cases and Visio flows
• Laid down the guidelines for a smooth flow of the different project elements in P&C domain, in different iterations and phases of the Software Development Life Cycle (SDLC)
• Provided hands-on instruction and guidance on how to prototype various JSON producing RESTful web-services and database systems using PHP, Node.js, and Python Django web frameworks during the senior project experience.
• Worked on various Guidewire integration concepts like Messaging, Batch Processes, Plugins, and Web Services and worked with Technical and Business leads during Guidewire Policy Centre implementation.
• Developed UAT and System Integration Testing (SIT) plan, facilitated UAT and SIT testers as well as Triage defects periodization and solutions
• Elicited and drafted requirements for financial system transaction posting for SAP FS-CD (SAP for insurance collection and disbursement).
• Worked with data analysts to identify, design and implement solutions for extraction and integration of data for creating reports, decision making with using SSRS and SSIS
• Assisted in issues resolution and escalation as well as patronization and tracking
• Actively involved in brainstorming and JAD session with the client in order to identify all the business requirements for P&C project development.
• Carry out Metadata and data quality control for market risk, credit risk, interest rate risk, counter-party risk, liquidity risk, operational risk, inflation risk, and systematic risk data.
• Used Waterfall methodology of SDLC to manage projects

Environment: Agile Scrum, HTML 5, SAP CD,CSS,Adobe Photoshop, Windows Forms, Web Forms, Doors,IBM BPM, MS Visio, Arena, SQL Server, Win Runner, Rally, Clear Quest, SSRS, SSIS Load Runner, Window 8

Confidential

Business System Analyst

Responsibilities:

• Analyzed balance sheet, P&L, cash flows, job costing and budget variances for multiple entities.
• Interviewed the **** (state) transportation department stakeholders and SMEs to elicit business rules, understand processes, information, and systems in use.
• Reviewed the legal background, legislative history, administrative case law, and court decisions that interpret the policies and regulations for these government programs
• Involved in development & documentation of Software Requirements Specification (SRS) using TIFIA loan
• Reviewed and evaluated financial models and forecasts, particularly sensitivity analyses of Borrower’s base case models.
• Administered the entire Automated Test Framework.
• Created the complete Manual Regression Test and later turned it into Automated Regression Test Package by using Selenium IDE (Rails & Ruby).
• Managed the review, execution and delivery of amendments, consents and waivers to the credit agreement and is primarily responsible for obtaining all necessary internal approvals for said documentation changes with minimal senior supervision.
• Established processes for GDPR cookie compliance with OneTrust and internal auditing.
• Participated as department-stakeholder of city-wide Business Intelligence Procurement Committee (hands-on testing over a dozen BI Tools including Tableau, Alteryx, Power BI, Qlikview, SiSense, Birst, and Logi Analytics)
• Participated as the TIFIA representative on the oversight group, if any, formed to protect the interests of the senior lenders during the life of the senior loan.
• Worked with the Bureau lead underwriter for credit negotiations and assigned USDOT financial and engineering staff, write the Project Monitoring Plan for each credit agreement.
• Added Oracle ECOs to the process for Prototype BOM, routing, Transfer Prototypes to Prod, Production BOM mass changes.
• Implemented Kanban Planning system
• Reviewed monthly reports from the construction contractor, the borrower, the independent engineer (or lender’s technical representative) and USDOT engineering staff to identify issues of concern that could prevent project completion within the approved budget.
• Developed wireframes and mock ups using Adobe Dreamweaver
• Coordinated all disbursements of TIFIA loan proceeds through Oracle to ensure timely and accurate payment for eligible project costs.
• Conducted reviews to ensure compliance with all covenants and prepared notices of default litigation and other adverse events. Develops and updates tracking reports on revenue performance. Reviewed updates to traffic and revenue studies, as appropriate. Identifies and monitors issues that could prevent timely repayment of the TIFIA loan.
• Conduct periodic site visits to projects funded by TIFIA loan proceeds to document the progress of each project and identify risks to project completion or repayment of the TIFIA loan.
• Reviewed monthly and annual financial status reports from the collateral agent or borrower. Reviewed quarterly and annual audited financial statements submitted by the borrower. Advised USDOT management regarding any early warning signs of potential adverse financial conditions that could prevent timely repayment of the TIFIA loan.
• Developed relationships with IT teams and customers to gather requirements and understanding of their business needs and addressed initiatives using Office 365 products and technologies.
• Experience in data migration Masterworks via FTP to a Amazon cloud (AWS).
• Monitored compliance with debt service coverage or loan life coverage ratios and rate covenants.
• Coordinate annual review of the borrower’s loan amortization schedule. Provide copies of loan amortization schedule revisions to the borrower.
• Extracting, Scrubbing and Transforming data from Main Frame Files, Oracle, SQL Server, DB2, Teradata and then loading into Oracle database using Informatica, SSIS
• Performed ETL processes; scrubbed data; and performed data mapping using MS Excel and MS Access to ensure data quality and workflow processes were following the new government mandated policies and standards.

Environment: My SQLserver, Waterfall,Oracle SQL, PL/SQL, Assura, SSIS, Office 365,SSASKanban,JAVA, Groovy & Rails - Grails, Selenium IDE,Cognos, MS Visio, ETL, Microsoft Excel, Microsoft Word, Tableau

Confidential

Business Analyst

Responsibilities:

• Acted as a liaison between the project group and the operations group.
• Helped design scope document and to coordinate with top management for the approval process.
• Form the requirements and using technologies such as JavaScript, XML, LDAP, AML language (like XML), and TIBCO configure and provide custom enhancements to the client
• Interviewed various personnel including broker dealers and traders to understand the current process and the future requirements.
• Designed the prototype of the Data mart and documented possible outcome from it for end-user.
• Extensively conducted JAD sessions to understand the business requirements
• Involved in generating various reports using the SQL Server Reporting Services (SSRS).
• Involved in design, development, implementation and roll-out of Micro Strategy Business Intelligence applications
• Created dashboards through Power-BI and effectively showed trends in our portfolio
• Managed ERP and EPM SaaS Applications with a background in Oracle On-Premise Solutions. Engaging Upmarket Accounts providing solutions for ERP and EPM applications in the Cloud.
• Tracking and reporting budget and cost allocation variances and performing cost/benefit analysis.
• Custom tools upgrade client had created marketing, merchandising production, batch support tools to support their custom web application which needed to be re-architected to work with ATGs ecommerce suite.
• Used CSS, HTML and JavaScript for GUI front end designing and validations.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools).
• Maintained the product catalog, search and navigation, search engine optimization (SEO), Business Intelligence (BI) and personalization, etc.
• Created Visual Basic macros to streamline data categorization and reconciliation
• Extensively involved in Business Process Modeling. Created the AS IS and TO BE business processes
• Worked with third party integration, Google Analytics, Ruby/Watir, data verifications/backend testing, defect management, SQL, API implementation, UNIX shell commands, process modeling.
• Creation of business and functional requirement documents and use cases supporting them with wireframes and other visual documentation as required.
• Documented the business requirements following the RUP methodology using rational requisite pro
• Used rational tools for version control and defect management
• Authored the Business Requirement Document (BRD).
• Experience in all phases of Full Life-Cycle Oracle E-Business Suite Financials implementation i.e. Requirements Definition, GAP Analysis, Process Modeling and Implementation.
• Designed the screen mockups using Balasamiq.
• Developed Business rules for the equity trading system based on technical chart analysis and fundamental analysis and trends.
• Used rational Rose to create use cases for different scenarios and cases.
• Analyzed, cleaned and reorganized data by using tools including Excel, Alteryx and Pivot in Tableau
• Developed Business specification diagram to understand the whole work flow.
• Created UI Specifications and wire frames.
• Lead multi-disciplinary project teams through all phases of the project life-cycle providing coaching, motivation and inspiration. Projects were executed using Sitecore and .NET.
• Involved in development and testing of POS Point of sale systems and applications for Payment Card Industry (PCI) Compliance initiative.
• Create the wireframe of Functional work flow using the Balasamiq tool
• Provided recommendation for use of ATG Commerce for B2B and B2C business.
• Developed activity diagrams in Rational Rose software, to have a diagrammatic view of the workflow.
• Used Invasion in enhancing the user experience; worked closely with the technical and programming team to prepare Screen Mockups, User Interface designs using wireframe prototype for this Ecommerce mobile/web redesign.
• Researched system architecture of Cartlane’s proprietary PCPO (PC PurchaseOrder) and SSO (Store Specific Order) applications in the replenishment department, with the aim of converging the features of both applications onto a single .NET platform that could function on Windows 7
• Designing the integration of BI data to implement Order management & consumer systems with workflow and dataflow from various sources like GMF, DNB
• Developed various Custom Objects, Tabs, Entity-Relationship data model, validation rules on the objects and tabs, Components and Visual Force Pages
• Perform Teradata (Enterprise Data Warehouse) validation and analysis to identify the accurate data source and to track data quality to detect/correct the invalid data.
• Collaborated with the QA team for developing scenarios for validation and testing by using Red Hat Stack.
• Responsible for end user training and P&Ps and Support for a major effort to improve the Warehouse Management System (WMS) capabilities of Supply Chain
• Got involved in the User acceptance Testing (UAT) and SIT and documented the test scenarios and outcomes.

Environment: RUP, JavaScript, Oracle, Red Hat Enterprise Linux Server, COBOL, CSS, HTML,Google Analytics, R, R Studio,Alteryx, Tableau XML, LDAP, AML language, Balasamiq, TIBCO, MS SharePoint, MS Office Suite (Word, Excel, Power Point, Outlook), Unit testing