Business Analyst/data Analyst Resume
SUMMARY
- I have 7years of IT experience in development, design, modeling, business analysis in different domain and business processes working on both hardware and software asset management.
- I served as the point person for maintaining vendor relationships, purchasing, and tracking corporate assets, and consistently improving related processes.
- I have background in conducting vendor research, equipment sourcing, bidding, and documentation to determine best sources as well as obtaining fair market value for all purchases.
- I was responsible for reviewing solicitations, proposals and other terms & conditions of procurement Comprehensive knowledge and experience in all facets of Software Development Life Cycle (SDLC) with business process models: Waterfall, Agile Scrum, Kanban methodologies, I have performed license and software inventory documentation based on corporate requirements, reconciliation between asset records in the Service - Now central repository with other relevant data sources and investigated and resolved exceptions and data accuracy issues.
- Decisive, action-oriented, results focused and accomplished professional 7+ Years of IT experience in development, design, modeling, business analysis in different domain and business processes.
- Comprehensive knowledge and experience in all facets of Software Development Life Cycle (SDLC) with business process models: Waterfall, Agile Scrum, Kanban methodologies.
- Expertise in Requirements Gathering through direct user interviews and workshops.
- Expertise in conducting Gap Analysis and User Acceptance Testing (UAT). Involved in Joint Application Development (JAD) workshops and requirement elicitation sessions with end users/clients/stakeholders and developing groups.
- Hands on experience in analyzing and documenting Business Requirements Documents (BRD), Functional Requirements Documents (FRD), Use Cases and Requirements Traceability Matrix.
- Excellent analytical skills in understanding the business process (AS - IS and TO-BE), understanding the functional requirements and translating them to system requirement specifications.
- Expert in tracking & managing requirements through Requirement Traceability Matrix (RTM).
- Used Unified Modeling Language (UML) diagrams (Use Case diagrams, Sequence diagrams and Activity diagrams) for specifying, visualizing, constructing, and documenting the artifacts of software system through MS Visio, Visual Paradigm, Rational Rose etc. resources.
- Extensive knowledge of project life cycle, project management processes, principals, knowledge areas and various project management tools MS Project.
- Facilitated scrum meetings, sprint planning, review & retrospective sessions, and ceremonies.
- Gathered and analyzed business requirements and produced specification documents for new project requests.
- Good experience in Scrum meetings to communicate project status to Program Management and coordinate planned risks and dependencies across the Program.
- Experience in developing ad-hoc queries and reports for clients and provide analytical support and recommendation, as necessary.
- Experience of Jira, Rally, Kanban board to manage tasks in the project. Prepared risk-register to define the effort to design a project.
- Experience of working on multiple projects, engaging all stake holders, working with cross-functional team members, and ensuring delivery of high-quality projects within budget & schedule.
- Experience as Business and Technical Analyst in the implementation and integration strategies within a team-oriented environment, utilizing quantitative and qualitative analytical skills.
- Experience configuring rules, monitors and management packs in SCOM and involved in testing reports for correct mapping of the objects and data.
- Expertise in data modeling for data warehouse/data mart development, data analysis for online transaction processing (OLTP) and data warehousing (OLAP)/business intelligence (BI) applications.
- Managed various stakeholder's groups. Gathered and managed Business, functional and non-functional requirements. Wrote user stories with acceptance criteria or user stories with use case.
- Strong working experience and familiarity of emerging regulatory standards including Basel, Dodd-Frank Act Stress testing, CCAR, CCPA, KYC and AML.
- Was responsible to track, document, capture, manage and communicate the requirements using requirement traceability matrix (RTM) and established service level requirements.
- Strong financial service knowledge, including equities, fixed income, securities, and investment performance.
- 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), and joint application review (JAR) sessions.
- 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.
- Proficient in developing and automating reports, iteratively built and prototyped 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.
- Coordinated deployment of IT solutions on Clouds (AWS, Microsoft Azure).
- Performed design, documentation, and review of business documents like business requirement document (BRD), functional requirement document (FRD) and system requirement specifications (SRS).
TECHNICAL SKILLS
Process Methodologies: RUP-Rational Unified Process, UML- Unified Modeling Language, Waterfall, Agile, Scrum process
Project Management: MS Project, Excel Spreadsheets
Languages: C, C++, SQL, Oracle, Java, AML Language
ITSM Tools: ServiceNow: Jakarta, Kingston, London, Madrid
Quality Management: JIRA, Rally, Confluence, Mercury Quality Center, Analysis SDLC process
Clear Management: Clear Quest, SharePoint
Object-Oriented: Rational Rose (Rational Suite Rational Rose, Rational RequisitePro, Rational Clear Case and Rational Clear Quest)
Office Tools: MS Word, Excel, Power Point
Testing: Unit Test, WinRunner, LoadRunner, and Manual Testing, UAT-User Acceptance Testing, Selenium
Databases: MS SQL Server, MS Access, 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
Business Analyst/Data Analyst
Responsibilities:
- Enterprise content or document management, ECM system analysis and administration, SDLC, data analysis, application integration, document migration, ECM implementation and modification, ECM testing and troubleshooting.
- Worked with ECM components such as content capture and recognition, content management, content delivery, content storage and preservation; workflow processes, networking, and network security, ETL processes, business process and records management, and ERP integration.
- Worked with Open Text ECM Suite, ECM technologies such as FileNet, Documentum, Mobius and Image Right; Windows and SQL Server, MS Office Suite, Oracle database, SQL, Java and HTML languages, Open Text Content Server 10 and 16, and SAN/NAS systems.
- Involved in creating technical design documentation for migration from existing technologies to ServiceNow.
- Worked on various modules of ServiceNow like incident management, change management, problem management, Service Catalog, user administration, reporting and discovery.
- Served as the point person for maintaining vendor relationships, purchasing, and tracking corporate assets.
- Conducted vendor research, equipment sourcing, bidding, and documentation to determine best sources and obtain fair market value for all purchases.
- Reviewed solicitations, proposals and other terms and conditions of procurement.
- Negotiated pricing and payment structure based on assets and other services delivered by vendors.
- Developed relationships with vendors to ensure that all aspects of the purchase to payment process are maintained.
- Performed license and software inventory based on corporate requirements.
- Established, maintained, audited, and reported on process and procedures for purchasing and tracking hardware and software IT assets, furniture, as well as general goods and services.
- Performed reconciliation between asset records in the Service-Now central repository with other relevant data sources.
- Investigated and resolved exceptions as well as data accuracy issues.
- Excellent analytical, strategic, and technical planning skills along with the ability to troubleshoot complex ECM issues.
- Was responsible for creating various workflows for incident management, change management, service requests and SLAs.
- Used the Application Programming Interface (API) that provided the classes and methods which were used in scripts to define functionality.
- Managed imports of CI application/infrastructure data within the CMDB tables in ServiceNow.
- Implemented CMDB bi-directional web services integration. It involved consuming RESTful web services, publishing SOAP web services, using business rules, script includes, UI actions and other ServiceNow scripting modules to support data synchronization and business logic.
- Was involved in developing service catalogs which included creation of new catalog items, designing workflows and execution plans.
- Was involved in redesigning the workflows using ServiceNow workflow editor.
- Integrated ServiceNow Dev instance with the existing LDAP and Single Sign-On (SSO) solution.
- Designed email templates by using HTML and jelly scripting and used them in notifications.
- Developed workflows and in customizing the applications in ServiceNow using JavaScript, AJAX, and HTML.
- Customized form design and layout for various ITIL process for incident management, problem management, knowledge management, change management, asset management and Service Catalog.
- Solid leadership and team-working skills with the ability to cope with fast-paced and dynamic work environment
- Provided effective communication and presentation skills and the ability to support technical teams and business users.
- Excellent organizational and multi-tasking skills with the ability to complete projects within specified deadlines and budgets.
- Utilized strong researching skills to recognize and adopt best practices for enterprise content management and governance.
Confidential, Dayton, OH
ServiceNow Business Analyst
Responsibilities:
- Implemented different modules of ServiceNow as per client's requirement and process - Incident Management, Problem Management, Change Management, Asset Management and Service Catalogs.
- Performed reconciliation between asset records in the Service-Now central repository with other relevant data sources.
- Point person for maintaining vendor relationships, purchasing, and tracking corporate assets.
- Reviewed solicitations, proposals and other terms and conditions of procurement.
- Develop relationships with vendors to ensure that all aspects of the purchase to payment process are maintained. Conducted vendor research, equipment sourcing, bidding, and documentation.
- Performed license and software inventory based on corporate requirements.
- Establishing, maintaining, audit and report on process and procedures for purchasing and tracking hardware and software IT assets.
- Worked with process owners and business stakeholders to translate business requirements into functional requirements within ServiceNow.
- Interfaced with cross functional team members within EDW system and across the organization to resolve issues.
- Ensured development opportunities on ServiceNow platform are identified to meet evolving business needs and align with key business strategies.
- Coordinated and participated in ServiceNow incident/request management testing lifecycle.
- Used JavaScript to create Business Rules, Client Scripts, UI Policies, and UI Actions.
- Created various workflows for incident, change management, service requests and SLAs.
- Assisted in the import of configuration and asset data.
- Worked on implementation, customization, and configuration of different Service Manager modules like Change Request, Service Desk, Service Catalog, and Problem.
- Participated and assisted in meetings as a member of the NCP and international team.
- Loaded the landing tables from different systems - Salesforce, Oracle and flat files using Informatics PowerCenter capabilities.
- Was involved in all phases of product lifecycle management (PLM).
- Created PLM/XML action to add pre action check if required datasets is present or not before exporting business object.
- Worked with SharePoint developers and stakeholders from nine different teams to document requirement to migrate content from SP 2010 to SP 2013 and get UAT signed off post migration.
- Gained experience in Guidewire claim enters, Policy center and Billing enter, claim center integrations and configuration user stories.
- Utilized Agile methodology and PLM.
- Implemented ServiceNow ITSM modules including Incident, problem, change, and Service Catalog.
- Ran ad hoc reports and SQLs for data imports from different departments to BI platform for data analysis.
- Was 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).
- Had extensive experience in Guidewire configuration and integration experience with claim center, policy center and billing center.
- Wrote 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).
- Created and managed GDPR traceability matrix to ensure all articles are implemented.
- Analyzed current business procedure to ascertain GDPR gaps and means of bridged said gaps.
- Developed complex scripts to load data from landing system to staging and finally to EDW.
- Developed Teradata user views for analytical purposes.
- Worked with UAT users and business users to understand the requirements and fill out any gaps.
- Migrated the code to higher environments - QA, UAT, pre-prod and production.
- Created Tivoli Maestro jobs to schedule the data loads to EDW.
- Worked in multiple small to medium sized projects relating to the delivery of applications (changes) in parallel.
- Had 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.
Confidential, Los Angeles, CA
Business System Analyst
Responsibilities:
- Thoroughly studied the banking 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.
- Communicated key risks metrics as well as analyzing and providing commentary on daily and weekly movements to senior management through regular meetings and presentations.
- Performed license and software inventory based on corporate requirements.
- Establishing, maintaining, audit and report on process and procedures for purchasing and tracking hardware and software IT assets, furniture, as well as general goods and services
- Performed reconciliation between asset records in the Service-Now central repository with other relevant data sources; investigate and resolve exceptions and data accuracy issues.
- Was extensively involved in the deployment of data warehousing system.
- Established processes for GDPR cookie compliance with OneTrust and internal auditing.
- Gained experience with Privacy Technologies such as OneTrust and TrustArc.
- Monitored and analyzed the results, trends, patterns, and events from Data Security and Privacy Compliance Tool OneTrust to enforce Data Privacy and Security requirements.
- Implemented a consent management tool that will help us manage consent from our clients and employees, to ensure we use their data as per the consent they have provided. Informatica, OneTrust, TrustArc were the leading systems in this space.
- Created PL/SQL procedures, functions, packages, and triggers.
- Did bulk data collecting, performance tuning of huge data with use of PL/SQL collections and records.
- Gained knowledge of Oracle, SharePoint, Visio, IBM Rational ClearCase, RequisitePro, and UML/XML models.
- Used Microsoft SharePoint as a web-based content management system as well as a document/project management tool.
- Enhanced enterprise content management (ECM) catalog management and REST API set capabilities.
- Developed SQL queries for the manipulation of data and transferring data.
- Conducted market research and analysis in capital markets consisting of stock market and bond markets.
- Implemented and enhanced enterprise content management (ECM), BPM, Data warehouse/ETL and Java implementations and increased publishing capabilities of Springer Nature such as migration to cloud Centralize Content Management Platform.
- Implemented an enterprise content management (ECM) system with BPM, scanning, record management and reporting capabilities for XML.
- Generated server-side PL/SQL scripts for data manipulation and validation for remote instances.
- Actively worked with the capital market and financial trading team to develop equities, futures, forwards, options, derivatives online trading facility.
- Have been extensively involved in (ECM) roadmap and strategy consulting, including assessment of business requirements, defining ECM strategies, creating implementation roadmap, and execution.
- Utilized Microsoft Excel to create spreadsheets that require sorting, organizing, and manipulation of data in accordance to project specifications (pivot tables, v lookup, and IF nested statements).
- Used application management tools for managing requirements and defects, specifically ServiceNow and HP Quality Center.
- Created UAT test plan (for API and e-banking modules) that included test approach, test security, development and execution of complex use case user acceptance test scripts, scheduling of testing efforts, defect tracking for regression, training considerations
- Reviewed by scrum team and BA team to improve their performance.
Confidential
Business Systems Analyst/Financial Analyst
Responsibilities:
- Worked with end users to Map Business Processes (BPM) to technical specification.
- Created daily, weekly and summary reporting and performance insights for the following programs: even performance for tab, including advertised vs. non-advertised sales, power hours, early Birds, BOGO and like-themed events.
- Generated dashboards, metrics, analytics, goals, alerts using BusinessObjects XI enterprise edition to streamline processes and procedure.
- Was responsible for POS installation in the metro-city area.
- Worked with system Analysts to create application', prepared functional and non- functional requirement document.
- Developed USE cases for the application and prepared the detailed workflow diagram based on the proposed enhancements, business logics and rules and translated them to use cases for live archive.
- Organized JAD sessions with business stakeholders/SMEs for gathering requirements for the new upgraded platform: estimated project resources, timing, and sequence of deliverables.
- Led analysis planning and execution and authored business requirement, process diagrams (BPMN), and UI designs for new web-based order management system.
- Designed and created business process classification frameworks with various levels of detail and levels of decomposition for both end-to-end sector and cross-sector process models using BPMN modeling standards.
- Researched system architecture of proprietary PCPO (PC purchase order) and SSO (store specific order).