Home

GARIMA - SR. BUSINESS ANALYST

[email protected]

Location: Remote, Remote, USA

Relocation: Yes

Visa: H1B

GARIMA SR. BUSINESS ANALYST [email protected] || 817-678-0872 Only Corp to Corp SUMMARY OF SKILLS & EXPERTISE Business Analyst professional with over 18 years of experience. Excellent analytical skills to understand the business process functionality and to translate them to Business Requirement Specification and System Requirement Specifications Solid understanding of Software Development Life Cycle (SDLC) processes including requirements gathering, analysis and design, development tools technologies and release. Experience in varying environments utilizing SDLC and ITIL Framework. Good understanding of Project Management Practices and Principles including Time Management, Budget Management, Resource Management, Risk Management and Change Mgmt. Experience in conducting GAP analysis, Impact analysis, SWOT analysis, Cost benefit analysis and ROI. Experience in implementing Rational Unified Process Methodology (UML) using Rational tools, working with Agile Development methodology by implementing and delivering Business Processes in iterations. Experience in database modeling and development of Entity Relationship Diagrams (ERD), SQL (ad hoc queries), Data migration, Data mapping, ETL, MDM and reporting process. (KPIs). Proficiency in value stream mapping, process modelling and mapping tools (e.g., Microsoft Visio, Lucidchart) and familiarity with business process management software. Experience in mobile app development and implementation including hardware confiscation and optimization. Knowledge of Kimball data warehouse design principles and strong experience in database modeling and development of Entity Relationship Diagrams (ERD), SQL (ad hoc queries, stored procedure), Data migration, Data mapping, ETL, MDM and reporting process. (KPIs). Understanding of Web Services and API technologies like REST/SOAP using XML, was also involved in gathering requirements for client-side and server-side validation and their testing using Postman, SOAP UI and documented them using tools like Swagger, POSTMAN. Familiarity of SNOWFLAKE, Talend, Power BI, Azure Data Lake Storage. Understanding of various financial products ( Loans, Derivatives, Repos, Reverse Repos, Swaps etc.) and GL postings. Excellent communication and technical writing skills in large corporate environments. SKILLS Methodologies : RUP, UML, CMM, ISO, DMAIC, Scrum, Agile, Kanban Project Management Tools : Microsoft Project, MS-Office, Excel, Power Point Content Management Tools : Microsoft SharePoint, Documentum, ServiceNow Document Design Tools : Rational SoDA, Rational Requisite Pro, Visio Testing tools : Serena, QTP, HP ALM Business modeling tools : Microsoft Visio 2007, Rational Rose, Figma CERTIFICATIONS Certified Scrum Master, CSM, Scrum Alliance, 2024 Certified Scaled Agile Product Owner, Safe Certification- In progress PROFESSIONAL EXPERIENCE Teachers Insurance and Annuity Association of America (TIAA), Edison, NJ Sr. Business Analyst (Remote) April 2023- Current Worked on data architecture remodeling by identifying, creating, and connecting APIs as part of company wide effort for minimizing the dependency on old AS400 based backend data interface systems. Assisted and contributed to the design, development, and deployment of business systems to meet our Retirement Plans and Pension division goals and objectives. Develop and utilize a deep understanding of how various retirement plans systems communicate and share data with each other. Gather and analyze business requirements and write Business Rules Document as part of the vendor guidelines of the documentation. Perform data analysis for the existing system and identify changes for the internal schema for performance, also perform data mapping from source to target using Business Process Mapping Notation (BPMN). Participate in Design walk-through with SMEs to baseline the business architecture. Identified applicable technology alternatives to given business problems in collaboration with Product owner and technical lead. Worked on Altassian(JIRA)/Confluence (Agile Management Tools) to log user stories and create product backlog and prioritize stories. Also, to plan the sprint and epics and identify the dependency between functions. As part of Agile Kanban SDLC methodology, participated and conducted agile ceremonies like PI planning, Sprint planning, daily standup, user story grooming session, sprint review, retrospective meetings. Worked closely with QA team and developers to clarify/understand issues, resolve and provided feedback to nail down the bugs. Worked with project team to ensure that logical and physical data models were developed in line with Key standards and guidelines. Perform source to target data mappings, business rules and data definitions as well as define the Key identifiers for each mapping/interface. Documented data quality and traceability documents for each source interface as well as used the tool Snagit to document current process and define future process. Used Lucid Chart to create Swim Lane and process flow diagrams. Used Visio to create mockups and diagrams too. Used SQL Developer to perform data check while data mapping. Used HP ALM to log test cases and test scenarios and defect entry for defect discussions. Worked with Project and Release Management to sequence/coordinate development activities within software development environment methodologies. Identifies applicable technological alternatives to given business problems with the assistance and direction of the Senior Business Analyst and Business Solutions Consultant. State of New Jersey, Deptt of Economic Development (NJEDA), Trenton, NJ Sr. Business Analyst (Remote) Aug 2022- April 2023 Participated in multiple waterfall Salesforce CRM solution projects by completing and updating requirement documentation; managing requirement scope; adjusting schedules when necessary; determining daily priorities; ensuring efficient and on-time delivery of project tasks and milestones; following proper escalation paths; and managing customer and supplier relationships. Lead and delivered successfully the first Agile Scrum (SDLC) initiative which included agile coaching of the stakeholders as well as the dev and testing team. Used Azure DevOps as a one stop Agile solution to log user stories and defects and generate reports of work progress. Conducted Agile ceremonies like Sprint planning, Daily standup meeting, story grooming sessions, product backlog refinement, sprint review and sprint retrospective. Provided project level analysis producing required project analysis documentation (business requirements, scope matrix, User stories, use cases, sequence diagrams, future state proposals, UAT plan) as part of project management responsibilities. Used Visio to create Swim Lane and process flow diagrams and also Figma to lay the foundation of the Business Process Modeling Notation. Collaborated closely with developers to implement the requirements, provide necessary guidance to testers during QA process. Also worked on Identifying improvement opportunities (proactive and reactive) including documenting business and systems requirements Also worked to understand and negotiate the needs and expectations of multiple stakeholders as and when needed. Served as a liaison between Operations and IT to assist or gather business requirements needed for system modifications, enhancement, and implementations. Created and maintained issue logs, meeting minutes, meeting schedules, project summaries and updates. Met with project team regularly to review project deliverables and deadlines and then helped the testers to complete their testing and retesting of bugs and enhancements. Handled day-to-day operational requests from the business to accommodate changes to the Congnito Form samples which were locked as requirements before sprint planning. Developed understanding of Licensing and permitting process and created user manuals for end users using snagit. Worked with data analytics team to get their signoff to follow the companywide guidelines for data modeling, data taxonomy. State of New Jersey Judiciary(Courts), Trenton, NJ Sr. Business Analyst (Remote) April 2021- Aug 2022 Worked on automation, enhancement and maintenance of ecourts expungement portal for both internal and external users and improve the client experience of initiating and completing and expungement. Worked on solving helpdesk issues generated by both internal court staff and external users such as prosecutors, public defenders, Private Attorneys, pro se users and other parties like police department. Also worked on a Dynamics 365 CRM based solution for an internal application related to travel advisory. Also worked on analyzing and designing business requirement for Data Marts and Data warehouse by connecting with data and ETL teams. Identified and wrote data sources and identification rules for storing data in data warehouse. Accessed data from AS400 systems of Promis Gavel for criminal court data, ACS for Municipal court data and FACTS for family court data. For above AS400 applications, validated prod support issues and created test data in the test environment for testing and root cause analysis. Also worked on creating a feasibility analysis to decrease the dependence on AS400 system and its downstream effect as a companywide project to replace AS400 applications. Used a home-grown config to search, parse and extract the xml log files in production in order to triage the production support issues. Worked on Agile SDLC implementing scrum iterations to deliver projects which included daily standups and weekly grooming sessions. Used agile management tool Azure DevOps to create storyboards, functions, epics, User stories and then follow them up to complete within a certain timeline within an iteration. Documented Requirement Traceability Matrix in Requisite Pro for traceability of requirements through test cases. Actively work with product owner to plan and refine product backlog along with execution and reporting of the smooth movement of Agile Studio cards across project. In order to create prototype and wireframes for the user experience enhancements and inclusion of new features used UI/UX tool AdobeXD. Coordinate with standards team to get approvals for mockups and Wireframes for UX design changes in AdobeXD obtain information on project limitations and capabilities, performance requirements and interfaces. Experience working with Analytics team on data management for data modeling, data taxonomy involving data governance. Participated in End-to-End testing, Integration Testing, User Acceptance Testing (UAT) and Regression testing for each scrum with an extensive use of Snagit tool to take screenshots. Used SQL developer to perform queries to fetch data from database to perform data analysis for testing. Also participated in creating test cases and test scenarios for testing of the user stories and setting up automated test scripts in HP ALM. Cox Automotive, Atlanta, Georgia Sr. Business Analyst (Remote) Jersey City, NJ June 2020- April 2021 Enhance the user experience of website and improve the client experience of digital selling, buying and auctions. Also worked on supporting day today production issues generated by business groups across the customer locations for business in a call center set up. Worked on a lift and shift project and conducted reverse engineering of legacy applications to accelerate system redesign and modernization efforts using webservices. Used Splunk to search, parse and extract the xml log files in production to triage the production support issues. Also worked on value stream mapping, process modelling using tools like Microsoft Visio, Lucidchart and also worked with business process management team. Familiarity with XML, XSD language as had to go through the logs in order to triage application prod support . Used Splunk tool to search, XML log files in production to analyze the root cause behind the issue being reported. Extracted the XML log files for further analysis of the developer into the file to triage the issue further. Worked on Agile SDLC implementing scrum/Kanban iterations method wise to deliver project. Worked on analyzing Datawarehouse for Data Integration and lift and shift project. Used Power BI for querying the data and worked on data mapping for reporting related projects. Used agile management tool Azure DevOps to create storyboards, functions, epics, User stories and then follow them up to complete within a certain timeline within an iteration. Actively work with product owner to plan and refine product backlog along with execution and reporting of the smooth movement of Jira cards across project. Coordinate with different stakeholders across functions and different teams to design mockups and Wireframes for UX design changes in Figma and lucid chart and obtain information on project limitations and capabilities, performance requirements and interfaces. Coordinated with data governance team to figure out the dependencies of the API. Work on resolving the support tickets generated by the dealers, sellers and end users during their day to day business on Service Now. Also worked on collecting requirements for customization of chatbots feature through Microsoft Azure. Retrieve and triage data for analysis of system capabilities and requirements by accessing the API services through POSTMAN and accessing GITHUB repos to see the code when needed. Worked with code base located in different legacy data sources and also in webservices like JSON, REST and Mashery API. Worked on creating user stories in JIRA for data migration from AS400 to REST APIs to make it more efficient way of data handling. Triaged endpoints of Rest and JSON APIs to cite in the JIRA cards for the dev team to find exact data location. Used Power BI to run SQL query to test data while performing any test required during the production support. MTA (State of New York), Manhattan, NYC Lead Business Analyst Aug 2016- May 2020 Worked on Application Rationalization Project (ARP) with PMO to identify application redundancy and phase out across MTA. Also worked on Hours-of-service application for LIRR, MNR under MTA. Prepared As Is (current state) and To Be (future state) diagrams documents for applications to identify gaps in what they want vs what they have. Also helped the Project Manager in reviewing the scope of the project, timeline, budgeting and managing the risk log on SharePoint. Helped Project Manager in preparing decks (PowerPoint slides) for steering committee meetings and timeline review meetings. Used JIRA/confluence as Agile Management Tool to create storyboards, user stories, functions and different tasks and test scenarios. Understanding Central Federal Regulation to ensure that BRD (Business Requirement Document) captures it for application to be compliant with regulation. Worked with the ethics and compliance department and liaised between the compliance director and business stakeholders as well as the IT team since it was an application for employees to comply with the laws and policies related to Hours of Service. Worked in Agile scrum SDLC methodology and lead and coached Scrum adoption and planned scrum implementation. Used Visio to create Swim Lane and process flow diagrams. Used Balsamiq to create mockups and wireframes. Used SQL developer to query data in order to do data analysis during requirement gathering and test execution. Used HP ALM to log test scripts and test scenarios, so that the defect logs could be traced back to requirements. Knights of Columbus, New Haven, CT Sr. Business Analyst April 2015- July 2016 Worked on implementation of AWD 10.1(Automated Work Distributor) a COTS product to automate existing workflow. Worked on Business Process Mapping Notation(BPMN) in AWD to define the ITIL process of workflow for different streams in the company. Closely worked with vendors, higher management, and business users to create business requirements document (BRD)and implement document automation and customer communications management. Created Business Process modeling diagrams in AWD as well as Visio diagrams for better understanding of future state workflows. Worked in an Agile/scrum based SDLC as a Business Analyst and participated in daily standup, sprint review and sprint retrospective meetings using Rally tool. Familiarity with Policy Admin System and pension plans like Annuities and retirement plans like IRA, 401k, 403b, 457b. North Mill Equipment Finance, Norwalk, CT Dec 2014- March 2015 Sr. Business Analyst Worked on gathering business requirements for a Salesforce CRM Application for Loan origination and equipment deals. Worked in an Agile/scrum based SDLC as a Business Analyst and participated in daily standup, sprint review and sprint retrospective meetings using Rally tool. Conducted GAP analysis by understanding the AS-IS system and the TO-BE system requirements by having discussions with the SME's. Worked with Informatica (ETL) to validate data mapping from Salesforce to old data system to enable reporting. Voya Financial (Formerly ING U.S.), Hartford, CT Sr. Business System Analyst Feb 2014 Dec2014 Worked on major cross-functional Rebranding project and on enhancement of client-facing application (VB.Net) being used by customers to access their pension plans and retirement plans. Worked on client facing applications for accessing Annuities and retirement plans like IRA, 401k, 403b, 457b. Also worked on enhancement and maintenance of an application for Securities Lending and Collateral Management. Conducted GAP analysis by understanding the AS-IS system and the TO-BE system requirements by having discussions with the SMEs of the application for new branding to Voya from ING. MAPFRE Insurance Group, Columbus, OH Sr. Business Analyst Jan 13 Jan 14 Used both Agile/Scrum methodology for the web application used by Agents and Underwriters for providing new Insurance plans and Renewals of a group/company. Understanding of Guidewire while working on claims related support issues. Worked on implementation of Service Now as incident management system (ITIL, ITSM solution) as a member of production support team in Property and Casualty Insurance domain (P&C). Managed a team of offshore developers in Europe and a team of offshore testers in South Asia. Wrote standard and complex SQL queries using MS SQL Server and also in Mainframe for data validation process. Fifth Third Bank, Cincinnati, OH Business Analyst Sept 11 Dec 12 Worked on a data driven project of data migration from old legacy system to SAP CRM, where in, conducted data mapping and data cleansing using ETL solution using MDM tool of Informatica. Delivered business requirement documents (BRD), functional specification documents, Use Cases, test plans, and requirement traceability matrices. Also, created requirements for PL reconciliation between GL and deal capture system for products such as Commercial paper, swaps, exotic, MM, FX - sourced from summit, Loan IQ and Murex Nationwide, Columbus, OH Business System Analyst Sept 10 Aug 11 Used Agile/Scrum methodology as well as Waterfall methodology for the web application used by Agents and Underwriters for providing new sale Insurance plans, pension plan, retirement plans and Renewals of a group/company. Gathered requirements, identifying and preparing Use Case specification documents, created Trace-ability matrix and tagging it in the Rational Requisite Pro. Performed extensive data analysis and data integrity testing for loading and validation of the data set output. Key Bank, Columbus, OH Business Analyst July 09 Aug 10 Assisted Middle Office in the Trade Reconciliation and Sign Off NAV process. Assisted Front Office in Leverage-Deleverage process of flipping money between equities and fixed income portfolios. Assisted finance team with monthly quarterly and yearly reconciliation between GL and Front office systems. Wrote standard and complex SQL queries using MS SQL Server for data validation process. Fannie Mae, Herndon, VA Business Consultant April 08 June 09 Served as a liaison between Mortgage specialists and the project team and gathered user requirements and specifications for designing a Mortgage based loan system. Federal Reserve Bank, Richmond, Virginia Business Analyst March 07 April 08 Gathered user and business requirements through interviews, surveys, prototyping and observing from portfolio managers and UI (User Interface) UTV Software Communications Limited, New Delhi, India Business Consultant July 05 Feb 07 Prepared logical data model in the form of Business Context diagram to include various entities and attributes in order to facilitate the design of Data model in the form of ER Diagrams. EDUCATION Bachelor of Arts, Patna University, India 2003 MS in Engineering Management, ITU, San Jose, California, 2015 Keywords: cprogramm quality analyst user interface user experience materials management business intelligence active directory information technology golang hewlett packard microsoft procedural language Connecticut New Jersey Ohio Virginia