Data Analyst

JAIMIN SHAH BUSINESS ANALYST

862-***-**** **************@*****.*** www.linkedin.com/in/jaiminshah17

OVERVIEW:

Business Analyst with around 6 years of experience in eliciting and documenting business requirements, requirements analysis, prioritization of business needs and solutions, customer relations, team leading, resource management and project management in various industries such as Finance and Banking.

SUMMARY:

Around 6 years of professional experience as a Business Analyst working on design, analysis process flows etc.

Skilled in gathering business and application requirements, Business Processes, identifying risks, impact analysis, UML modeling, and Sequence and Activity Diagrams using Rational Rose and Microsoft Visio in Information Management processes.

Proficient in authoring Business Requirement Document, Narrative Use Cases, creating Use Case diagrams, Sequence Diagrams, Activity Diagrams and other UML based diagrams using MS Visio, Rational Rose.

Translate stakeholder requirements into different tangible variable such as System/functional specifications, Use Cases,User stories, workflow/process diagrams, lineagemapping/Data flow/ Data Model docs. This includes gathering all mapping information from all legacy systems.

Advanced knowledge of the design, development and implementation of SAP business intelligence solutions.

Closely worked with SMEs, Product Owners, Delivery Managers, Business Stakeholders and Vendors for managing access levels.

Expertise in preparing Business Requirement Document (BRD), Use Case Specifications and Functional Specifications.

Experience working in a matrix environment, enhancing UI applications, creating data sets, extracting and synthesizing data, conducting and interpreting quantitative and qualitative analyses.

Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.

Extensive Experience in all the phases of Software Development Life Cycle including: Requirements Gathering, Feasibility study, Analysis, Design, Development, Testing, Deployment and Maintenance.

Excellent knowledge and deep understanding of industry standard methodologies like Iterative Software Development Life Cycle Process as per Rational Unified Process (RUP), Capability Maturity Models (CMM), ISO9000 and Six Sigma and Rational Tools used during various phases of RUP. Also worked using various methodologies such as Agile Software Development, Scrum, Sprints, Rapid Application Development (RAD), Joint Application Design (JAD) and Prototyping.

Demonstrated skills in critically conducting the GAP Analysis throughout the projects in evaluating/analyzing the existing standards and policies to determine the improvements.

Regulatory experience for Trade and transaction for e.g. MiFID, CFTC, Dodd Frank, SFTR etc.

Lead and run Smoke Testing, Regression testing, Black box testing, White box testing, automation testing and full SDLC testing.

Strong knowledge of Business Intelligence, Data Warehousing, Data Modeling and Analytics concepts with expertise in grasping transaction flows and process management.

Designs and develops analytical queries, reports and visualizations utilizing the Enterprise Business Objects Suite of tools (e.g., Crystal Reports, Web Intelligence Reports, Lumira Visualizations and OLAP queries)

Developed extensive skill set around SQL querying – data extraction and validation, ad-hoc user reports generation and root-cause analysis for data discrepancies.

Experience defining and adopting data standards and regulations (i.e. GDPR, CCA, BCBS, PIPEDA, etc.)

Experience defining data governance stewardship and data elements certification processes.

Expertise in Data warehousing and BI tools (SQL server Reporting/Analytical tools).

Knowledge of ITSM (Infrastructure Services Management) and ITIL (Information Technology Infrastructure Library) methods and processes.

Expertise in reviewing Test Procedures, creating Test plans, defining System & Integration Test Cases, executing Test Cases, Test Data reviewing and maintaining and executing detailed Test scripts for User Acceptance Testing (UAT), analyzing bugs, interacting with team members in fixing.

TECHNICAL SKILLS

Methodologies

SDLC, STLC, Waterfall, Agile, JAD, Scrum, Waterfall-Scrum Hybrid, ITIL, ITSM.

Project Management Tools

MS SharePoint, MS Project, Confluence, Citrix Podio, MS Dynamics 365, CA Clarity

Requirements and Defect Management Tools

MS Office, JIRA, Rally (CA Agile Central), HP ALM, Team Foundation Server (TFS), Bugzilla, Rational Clear Quest, Rational ClearCase, SharePoint, PeopleSoft HCM.

Design and Modelling Tools

MS Visio, Smart Draw, Lucid Charts and Visual Paradigm, Erwin

Statistical Tools

SPSS, SAS,Trillium.

Version Control tools

GIT, CVS, Eclipse.

Change Management tools

Jira, Rational Clear Quest, Test Director.

Reporting and Data Analysis tools

Tableau, Power BI, Control – M, MS SQL server, MySQL workbench, MS Access, IBM SPSS statistics, IBM SPSS Modeler, Informatica Power Center, Data Quality Center, MS SSRS, Cognos 8.3 BI, data studio, Oracle, NetSuite

Languages

UML 2.0, CSS, HTML, SQL, Oracle, C, C++

Testing tools

HP QC, Selenium, Cucumber, Test director, SOAP UI, POSTMAN.

Operating Systems

Windows XP, vista, 7, 8, 8.1, 10 Unix, Ubuntu

CERTIFICATION

Professional Scrum Master https://www.scrum.org/certificates/464107

EDUCATION

Master in computer Science PACE University

WORK EXPERIENCE

Sr. Business Analyst / Data Analyst

Citi Group – New port – NJ January 2020 – Present

Project Description: Serves as a compliance risk manager for Independent Compliance Risk Management (ICRM)’s Data Quality & Surveillance Operations team responsible for data integrity management that impacts a suite of surveillances designed to detect behaviors that may violate regulatory rules or internal policies and procedures. When potentially anomalous behavior is detected, the team is responsible for escalating the activity and working collaboratively with partners across the first and second lines of defense and technology to determine the appropriate resolution of the matter. The ICRM Global Markets Surveillance platform encompasses a number of surveillance related portfolios including trade surveillance, e-communications and voice surveillance, employee trading, outside activities surveillance, and information barrier surveillance.

Key Responsibilities:

Identify, triage, escalate and remediate data issues that negatively impact surveillance(Capital Market, Cash Equity, Options, Futures, OTC commodities, Retail, Information Barrier surveillance group) scenarios and surveillance reviews. Improving data quality by coordinating with Information Technology on the timely implementation of enhancements and proactively addressing potential issues.

Implemented working sessions(JAD) with IT teams and front office staff to accurately capture data requirements which improved data quality by 90%.

Worked on SAFe framework with other scrum teams, Attended Scrum of Scrums to coordinate dependencies across various other scrum teams in Agile Release train, worked with Release Train Engineer, System Architects and system Team for Infrastructure requirements and to support integration testing.

Responsibility for the production of all formal documentation related to the IT infrastructure.

Maintaining Data quality high threshold at 99% and low threshold at 98%.

Monitored and provided daily status report and weekly status presentations so that extremely aggressive deadlines of this project can be met. Highlighted and escalated the various issues and risks in daily status Report and with higher Management and Customer.

Attended daily customer calls to track the progress of the Project and discussed the issues in product conversion and Interfaces and corresponding action items.

experience implementing integrations and building custom connectors leveraging APIs, Collibra.

Facilitated the daily management call, Toll – Gate Meetings, to monitor the health of the project and discuss the key focus items and issues. Monitoring offshore productivity and utilization.

Management of schedule and budget related to the IT infrastructure build.

Coordinated with various groups and the Leads so that action items are met, provided guidance and direction to the team in terms of approach. and solution, Responsible for all Offshore delivery of the Project and meeting the target dates for the various phases of the Project Day. Single point of contact for all escalations and issues from Offshore.

Worked with regional leads to perform internal audit and identify gaps in surveillance to improve compliance and provide training as needed.

Supported the successful decommission of MANTAS surveillance and migration to Big Data surveillance software leveraging big data tool (HUE,HIVE) and SQL queries.

Developed workflows to map domains, critical data elements and business rules.

Review data scorecards and Red Metrics for surveillance, escalating and resolving data quality issues including remediation of regulatory commitments that target to improve the quality of surveillances.

Managing a team of junior compliance staff, reviewing staff assignments and contributing to decisions regarding hiring, compensation, performance appraisals, staff development, training, etc.

Generating reports, performing data analysis, and providing troubleshooting support on multiple projects. Also supporting aspects of planning and executing projects to assist the Firm in complying with regulatory and legal requirements.

Overseeing the monitoring to adherence to ICRM’s Risk Policies and relevant procedures; preparing, editing and maintaining ICRM program related materials; interacting and working with other areas within Citi, as necessary; and keeping abreast of regulatory changes, new regulations and internal policy changes in order to further identify new key risk areas.

Monitor data control report, identify and report issues to responsible technology team.

Lead team to perform initial analysis to identify the root cause, work with responsible team to find solution, perform UAT as well as after implementation check.

Worked with cross-functional teams to structure problems, identify appropriate data source, extract data and develop integrated delivery solutions.

Maintenance of portfolio level plans including associated resourcing plans for the entire infrastructure team.

Participated and provided technical leadership in all phases of BI projects: from discovery and planning through implementation and delivery.

Supported the planning and coordination of data governance activities.

Developed and maintained an enterprise data architecture roadmap to improve the maturity and effectiveness of enterprise data management.

Confluence was used to maintain project documents such as project plans, project scope, and status reports and to assign tasks.

Managed financials, budgets, invoicing and forecasting in terms of resources and costs for financial year.

Tracked team progress by creating sprint burndown charts and Release burndown charts.

Perform sprint retrospectives to capture lessons learned and what can be improved in next sprint.

Act as liaison between business stakeholders and development team in order to elicit, analyze, document, communicate and validate business requirements.

Perform master and reference data lookups and prepared Pivot Tables.

Perform root cause analysis on failures. Resolve performance tuning related issues and queries.

Able to properly document (functional & technical) source to target mappings, process flows, and business requirements.

Conduct proof of concept(POC) for SMARTS monitoring System to evaluate viability of system within the fixed income, Equities group.

Partner with stakeholders to improve/streamline processes, produce and automate report.

Maintain and present to management quarterly statistics to identify trends and patterns used to escalate any appropriate action.

Work with stakeholders to understand to perform exposure analysis, evaluation, and problem solving.

Understand risk system concepts, software framework, and data requirements. Utilize the knowledge to perform various analyses to support CCAR model validation.

Work with other Risk Analyst teams and Model Validation to build up models and applications for risk analysis, CVA CCAR and Basel III RWA CCAR.

Work on multiple risk management applications to leverage system functionalities for stress testing and regulatory capital calculations.

Handling ad-hoc QIS analysis from regulators. business needs and deliver data analytic solutions.

Environment: Agile/SCRUM, Windows OS, SharePoint, JIRA,MS Excel, Actimize, MS Word, MS Visio, MS PowerPoint, MS Access, HP Quality center, SQL Server, Data visualization, SMARTS, FINRA, Bloomberg, Fidessa, MANTAS, Collibra

Sr. Business Analyst / Data Analyst

Union Bank Of Switzerland – Weehawken - NJ Feb 2018 – January 2020

Project Description: This application provided a comprehensive and fully integrated collateral management platform for marginal trading and repo & reverse-repo transactions. This application automated the collateral evaluation process and streamlined collateral monitoring. It took care of 1) charging optimal collateral amount for Marginal Trading of Equities and Fixed Income products (Treasuries, Corporate Bonds and Agency Debt) and 2) evaluating the market value/returns of pledged collaterals for repo transactions. The application had two additional modules - the Collateral Monitoring module which used market data to monitor credit risk exposure in portfolios and the Client Management module that was used to set up accounts and manage margin calls. The system also had an external client-facing web-interface that allowed institutional or individual traders to manage their portfolio and to monitor the performance of their investments.

Key Responsibilities:

Liaison between stakeholder’s system users, clients and managers, software development team and the QA team to gather requirements.

Facilitated Joint Application Development (JAD) sessions to identify the business rules and requirements and then documented them in a format that can be reviewed and understood by both business people and technical people.

Conducted Database analysis via Microsoft SQL Server to run ad-hoc reports weekly/monthly for upper management using SQL queries to generate excel reports/charts.

Engaged in project initiation activities such as developing the Project Charter, Project Scope and assisting the management in resource and budget estimation.

Created Business Requirements Document and converted them into System Requirement Specifications Document.

Implemented business modeling, data modeling, and object modeling using MS Visio to develop the business architecture for the application.

Expertise with SPSS tools to statistical analysis.

Analyzed requirements and created Use cases, Use Case diagrams, Activity Diagrams using Enterprise Architect.

Gathered requirements to implement Master Data Management.

Performed cleansing, de-duplication, and harmonization of data across various systems.

Day to day administration of Control – M Server and its components, production batch schedules and ensure continuity of business services.

Build and manage job flows, calendar requirements and scheduling criteria.

Perform data profiling and define transformations and As part of Data Quality analysis: Traced Data Lineage of data elements.

Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like table reorg, add enough spaces to database.

Involved in preparing a simple and detailed User manual for the application, for an intended novice user.

Proficient in defect management using JIRA.

Tracked and communicated team velocity and sprint/release progress and another metrics

Created and published weekly status reports and weekly dashboards

Ensured timely review, approval and sign-off the deliverables.

Worked with SIT team in development of System Test Cases.

Created Test Strategy developed UAT Test cases and execution of Test cases.

Identified Business need for Load Testing and issues with application.

Conducted Load Testing and collated the Test Results.

Worked with Project management team for vendor selection process.

Prepared test plans and executed Unit Testing, Integration Testing and User Acceptance Testing using test cases to endure that the systems conformed to specifications of business requirements performance criteria.

Work with clients to determine business requirements, priorities, define key performance indicators (KPI) and develop BI and data warehouse strategy.

Performed cleansing, de-duplication, and harmonization of data across various systems.

Work with CORE team and EDW team on systems integration. Identify and capture Interface requirements between new platform and claims systems. This includes BRD, Functional-Non-Functional Requirements, identifying APIs, Data specification document and data mapping document.

Combines customer data from Dynamics 365, Office 365 and third-party data sources, and helps users find actionable insights from that data.

Meet with POs, SMEs and Data team to identify and capture data migration requirements and specifications from legacy system to new platform.

Collaborate with solution architects, data architects and developers and conduct system impact analysis on various systems including downstream and upstream systems.

Created functional and technical specifications documents and conducted review meetings with users and technical teams.

Developed Tableau data visualization using Scatter plots, Geographic Map, Pie charts, Bar charts, etc.

Created dashboards using calculations, parameters in tableau and created calculated fields, groups, sets and hierarchies etc.

Extracting data from multiple data sources and created tableau data extract files (TDE) for fast query execution in tableau.

Creating packaged tableau workbook files (TWBX) and shared with the users to help them analyze off-line data.

Utilized Tableau Server to publish and share the reports with the business users.

Environment: Agile/SCRUM, Windows OS, SharePoint, Web services, JIRA,MS Excel, MS Word, MS Project, MS Visio, MS PowerPoint, MS Access, HP Quality center, SQL Server, Tableau Server, Data visualization.

Sr. Business Analyst / Data Analyst

Sahara India Financial Corp, Vadodara - India May 2016 – July 2017

Project Description: Responsible for gathering requirements, creating use cases, performing data/ gap analysis, recommending solutions for a data repository/ financial reporting dashboard/ERP (with granular drill-down capabilities), and, ultimately, working with developers to perform UAT. This was a high visibility project whose goal was to automate a global, daily anchored (e.g. reconciled to G/L) balance sheet for senior managers across many Managed Segments & Geographies. Although this was a waterfall project using the full SDLC lifecycle, it also involved Agile concepts with regards to daily scrums and sprints for creating testing tools, data analysis, and other ad hoc projects.

Key Responsibilities:

Adapted Agile-Scrum methodology for application development, managed project deliverables such as product backlog and sprint backlogs along with handling supervisory duties - planning and follow-up meetings.

Performed project management activities – drafted Project Plan, Statement of Work, Scope Document, Risk Management Plan, Estimation Deliverables, Resource Allocation and Budgeting.

Helped the Product Owner in grooming and prioritizing the product backlog.

Facilitated Sprint Planning meetings, Daily scrum, sprint review, product backlog refinement meetings and sprint retrospective meetings.

There were several complications on the solution design and performance tuning aspects of the project but could successfully deliver the Monolithic and Lean Services to production on time after getting sign off on regression testing from all the existing legacy consumers.

Helped the team to write and split User stories, breakdown Epics and estimate user stories.

Used JIRA to maintain product backlog and sprint backlog and to create and track user stories, Sprint planning, tracking and managing sprints, created status reports and burn down charts.

Interviewed front office (Trading Desk, Client Services), middle office (Risk, Collateral Managers), back-office (Settlement Operations); facilitated JAD sessions to gather, analyze, document business requirements.

Perform Business Process Reengineering, by doing paired-programming with JAVA developers to understand and analyze code for Java mainframe.

Prepared graphical depictions of Use Cases, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and creation of technical design (UI screen).

Training and mentoring the team on enforcing agile operations and scrum principles.

Assisted in Data profiling and checking for data integrity by looking for various data anomalies and doing data normalization, Metadata Management and data verification using Informatica Data Quality Center.

Extensively used SQL queries to run data extracts, validations and to generate performance and risk reports.

Participated in Quality Assurance tasks by working with the team to develop Test Plan, identify Test Scenarios and to build Test Cases; generated Test Scripts using Test Complete for automated testing.

Creating and scheduling jobs on the Control – M tool in both Distributed and Mainframe Environment (Test and Production).

Implementing Control – M Security options by defining users and user groups and by selecting configuration options.

Created Requirements Traceability Matrix (RTM) to link each requirement,test cases ensuring correct identification of components that are affected in case there are changes in requirements.

Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.

Facilitated the UAT testing by working as a liaison between the end users and functional testing team, setup test environments and monitored the progress.

Had regular meetings with offshore team to understand progress, challenges and remove blockers for the scrum team. Provide agile guidance and direction to offshore and onsite scrum teams.

Worked on a Business Intelligence reporting system that was primarily functioning on Oracle Applications OLTP environment with Business Objects for Business Intelligence reporting Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.

Capture requirements for Risk Management Metrics (BI Reports & Dashboards) – establish KRI (Key risk indicators), provide training on capturing data and track them using report.

Worked with Production Support to provide training and technical support to business users after the project roll-out; captured and documented enhancements and monitored system performance as a part of this team.

Environment: Waterfall-Scrum hybrid, Windows XP professional, Spring Boot, Broadridge, MS Office suite, MS Project, GAAP Accounting, Oracle Platform, Oracle Application server, Ansible, SQL, SQL server, MS Visio, Bugzilla, HP QC, TFS, Rally, Informatica Data Quality Center, SOAP UI.

Business Analyst

Bank of Baroda, Vadodara - India Jun 2015 – Apr 2016

Description: Responsible for gathering and documenting SME Requirements for a multi-million-dollar SDLC project whose scope was to build a Data Warehouse/ BI tool for Investment Accounting and Reporting Operations. Project was forecasted to create substantial cost savings by eliminating redundant processes while drastically reducing the reporting cycle and improving accuracy. In addition to preparing the necessary artifacts for IT, informally served as a project coordinator in assisting the PM.

Key Responsibilities:

Interacted directly and assisted project manager and team members to allow compliance with successful implementation of project within time and cost.

Performed business requirement analysis and translated them to CRM(Salesforce).

Used SQL, spreadsheet (Excel) on daily basis to accomplish tasks.

Assisted in building a business analysis process model using Rational Rose and Visio.

Performed requirement analysis, went through all the use cases and workflows.

Responsible for writing Validation Summary Report to establish documented evidence that the system was validated.

Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML.

Provided key input in working with users in defining project and system requirements.

Periodically reached out to the team to track actual progress against plan Update the Project plan daily with actual progress.

Coordinated with QA PM for the vertical and plan the UIT and Functional Testing of the Widgets in the vertical, Share the Dev Plans with QA and review the QA plans.

Attended Daily stand up calls with Offshore PMs to ensure road blockers for offshore work are removed. Involved in planning, Time and Resource Estimates and monitoring activities with Offshore PMs and to discuss the status, issues and risks and come up with mitigation plan.

Excellent in Developing and evaluating Business Process Models.

Helped to create provider Reports like transactional processing and financial reports.

Worked with project team and make plan for its completion by using work breakdown structure through MS Project.

Performed Data Mapping between source to target system, created logical data modeling, Class diagrams and ER Diagrams.

Environment: Microsoft SQL, MS Excel, MS Word, MS Power Point, MS Visio, MS Access, MS Project.

Contact this candidate