SUMMARY

• 7 years of hand on experience working as Business/Systems Analyst and Data Analyst with expertise in data governance, data analysis, and data management processes.
• Strong working experience in various SDLC models such as Waterfall, Agile/Scrum.
• Writing & documenting Business Plan, Business Requirements Document and Functional Specification Document.
• Understanding of privacy regulatory frameworks such as CCPA and GDPR.
• Hands on experience working on PbD guidelines (Privacy by Design Center of Excellence) to ensure data was handled and processed as per the guidelines.
• Expertise in working with multiple teams in order to formulated comprehensive PbD framework.
• Expertise in translating business and user requirements into System Specifications.
• Experienced in various requirement analysis techniques such as JAD sessions, brainstorming sessions, requirement workshops, and grooming sessions.
• Extensive experience working on Data Mapping, Data Quality Checks, ETL Rules, and Data Validation.
• Extensive knowledge of Software Development Life Cycle (SDLC) methodologies (Waterfall & Agile) and understanding of various phases such as requirements, analysis, design, development and testing
• Hands on experience identifying transformation rules for ETL.
• Expertise in creating ER diagrams and logical data models for data updates.
• Experienced with Data Quality Management, Metadata Management, Master Data Management, Process Modeling, Data Dictionary, Data Stewardship, Data Profiling, & Data Quality Standards.
• Expertise in understanding workflow concept, ability to gather & document the 'As - Is' & 'To-Be' processes.
• Proficient in maintaining Test Matrix and Traceability Matrix and performing GAP analysis.
• Hands on experience writing SQL queries for data validation.
• Good knowledge of Health Insurance Plans and Expertise in determining the membership eligibility, billing experience within life and disability in health plans.
• Experienced in conducting User Acceptance Testing (UAT). Experienced in collaborating efforts with Production Support, Engineering, and other teams during production deployments and data fixes.
• Experience in managing requirements from project inception through release.
• Successful as a team player to work in conjunction with other DBAs, testers, developers and team members in validation & testing complex scenarios and in the maintenance of Quality Standards in projects.
• Highly motivated, organized and results and detail oriented with good interpersonal, communication and presentation skills. Proven capability of adapting to new and fast changing technologies.

PROFESSIONAL EXPERIENCE

Confidential, Warwick, RI

Sr. Business System Analyst

Responsibilities:

• Worked closely with various internal stakeholders such as data stewards, master data management team, and policy owners to ensure PbD guidelines and standards are successfully communicated across the board.
• Through presentations and demos ensured that PbD standards were integrated across systems for data processing, data storage, data privacy, and data sharing.
• Followed certain rules while implementing Privacy by Design (PbD) principles, such as Collection Limitation, Data Minimization, Use, Retention and Disclosure Limitation.
• Captured details around End-to-End Security for data as part of Privacy by Design (PbD) Center for Excellence implementation.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Scheduled meetings / follow-ups to assess gaps in processes.
• Worked with Hadoop Developers in creating staging layer, transformations layer and target data warehouse
• Ensured single point of accountability for project success, and ensured separation of stakeholder management and project decision making activities as per Project Governance Framework.
• Ensure the business metadata definitions of all data attributes and entities in a given data model are documented to meet standards.
• Analyzed data lineage for various data elements for FR Y-14 Report. Specifically, validated data for Counterparty Risk, Securities, Retail, and other Schedules.
• Created and maintained data dictionary for FR Y-14 data elements.
• Analyzed data errors across multiple FR Y-14 schedules.
• Perform data profiling in the source systems that are required for financing
• Worked on Views and Dashboards in Tableau. Managed custom views such as Bar Chart and Table views. Managed dashboards with Views and Tables.
• Created multiple deliverables including Business & Technical Requirement Documents, Use Case Documents, and Mapping documents.
• Collaborated with AML SME in identifying possible enhancements to AML monitoring tools and processes and communicating them to the financial intelligence manager.
• Worked with the project manager for planning and organizing the project activities, and in communicating with other business center mangers and stakeholders of the project.
• Worked with the project manager to estimate best/worst case scenarios, track progress with weekly estimates of outstanding work, conducting informal meetings and as needed
• Facilitated Scrum meetings: Sprint planning, Daily Scrum, Sprint Review, and Retrospective sessions.
• Analyzed and prepared executive monthly reports on digital initiatives and their impact on quarterly goals
• Extensively worked on migration project by creating migration rules and migration template
• Involved in creating Entity-Relationship diagrams for the design of database.
• Designed and developed the architecture of business intelligence components including data models, ETL, and enterprise reporting.
• Testing of all reports, including but not limited to, stress testing of reports and data elements, including report refresh performance and data accuracy testing leading to proper performance tuning.
• Documented the Requirement traceability matrix (RTM) and created UML Modeling such as creating Activity Diagrams, Flow Diagrams using MS Visio.
• Involved in writing extensive SQL Queries for back end testing oracle database.
• Wrote SQL queries to validate data from multiple tables.
• Documented Business validation rules and data quality checks rules for ETL batch jobs.
• Worked closely with analytics team to create various BI reports.

Confidential, Boston, MA

Business/Data Analyst

Responsibilities:

• Responsible for representing the Development in high-profile application projects, including Online and Mobile Banking applications.
• Mapped requirements for logical data models to support the Data Warehouse.
• Reviewed data model and reporting requirements for Reports with Data warehouse/ETL & Reporting team.
• Documented detailed requirements for data privacy as per PbD guidelines and standards.
• Analyzed data elements for multiple FR Y-14 (Annual & Quarterly) schedules to analyze end to end data, data errors, and process gaps.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Design and implement metadata change management and deployment process while moving metadata from one environment to other
• Involved in Data profiling of source system as part of technical feasibility study for the business requirements.
• Extensively used MS SharePoint a content management platform, for managing content across the organization within a shared repository.
• Used different ad-hoc analysis, the Reports assist in defining strategy for each customer category.
• Worked on data modelling and produced data mapping and data definition documentation
• Managed content revisions for published content in Tableau.
• Created detailed data dictionary as the main source for data mapping repository for multiple source systems and target system.
• Involved in creating Data Flow Diagrams for Database of the Investment Portfolios
• Scheduled meetings with developers, System Analysts and testers for the preparation of UAT and make the test material ready keeping in mind, the scope of the project.
• Created detailed functional and technical specification documents for data quality checks for ETL batch jobs to extract data from multiple source systems and load in target data warehouse, to be utilized in multiple reports.
• Validated data accuracy during data mapping and extraction throughout the ETL process.
• Ensured that data in reports and Data warehouse matched the data from source system.

Confidential, Clifton, NJ

Business Analyst

Responsibilities:

• Gathered user feedback during various stages of migration process to ensure smooth transition for internal teams and also for the external users.
• Designed the business requirement collection approach based on the project scope and SDLC Methodology.
• Developed business requirement specification documents as well as high-level project plan.
• Worked to create Data Mapping Documents and worked with business to write transformation rules
• Facilitated and managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
• Did Data cleansing to detect and correct corrupt data. I was responsible for creating and maintain end-to-end data mapping and data conversion spreadsheet.
• Attended JAD Sessions in order to capture Business rules around Data elements on the User Interface system
• Conducted interviews with key business users to collect requirement and business process information.
• Performed extensive requirement analysis including data analysis and gap analysis.
• Conducted Data Analysis on client profile data to find missing data fields in database and customize them.
• Designed and developed all Use Cases and UML models as per requirements.
• Developed Sequence Diagrams, Activity Diagram, and Data Flow Diagrams using UML.
• Documented data-mapping best practices including visual processes and trained team members on data mapping process.
• Designed and implemented SQL queries for QA testing and report / data validation.
• Used Quality Center for requirement management, defect management, and reporting.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Performed User Acceptance Testing (UAT).
• Used SharePoint for document sharing and feedback gathering during UAT.