SUMMARY

• A functional and technical Business/Data Analyst with over 7 years of experience in Gathering Requirement, Business Process Design, Data Management, Data Analysis/validation, Data Warehousing and Business Intelligence & Reporting Tools.
• Experience in query database, validating the data, failure analysis, and Root Cause Analysis using MS SQL and My SQL.
• Good understanding of the Data modeling (Dimensional & Relational)
• Excellent understanding of Data Governance artifacts such as Business Glossaries, Data Dictionaries, Business & Data Quality Rules, and Lineage
• Knowledge of documenting data lineage function in a financial institution
• Experience in the end - to-end documentation of data dictionaries and Data Quality Control Assessments for various applications
• Good knowledge of Business Intelligence Data Analysis Tools and reporting packages (e.g. Tableau, BI Power, Pivot Tables)
• Good Knowledge of Test Plan, Test Scripts and Test Cases for Functional, System, Integration and UAT
• Experience in creating Product Backlog, sprint backlog and managed and updated Issues (Epics, Stories, and Tasks) onto Jira. Participated in Sprint Planning, Daily Scrum Stand up and Sprint Retrospective meetings
• Excellent skills to create business Requirements Document (BRD), Functional and Nonfunctional Requirements Documents (FRD) and Use Cases Specification
• Proficient in creating various artifacts such as BRD, FRD, use cases, RTM, Process flow, Change Request, Test Plan/Case, defect Report
• Experienced in all phases of the Software Development Life Cycle (SDLC), Waterfall, Rational unified process (RUP), Agile Methodology (Scrum and Kanban methods)
• Advanced knowledge of MS Visio, Excel, PowerPoint, Word, Access, and Outlook
• Experience in analyzing and creating Use Cases, Use Case Diagrams, User Stories, Data Flow Diagrams, Business Flow Diagrams, Swim Lane Diagrams, Activity Diagrams, Sequence Diagrams, and other related UML diagrams
• Experience with compliances such as Anti Money Laundering (AML), Know Your Customer (KYC), Customer Due Diligence (CDD), Enhanced Due Diligence (EDD), OFAC and regulatory acts such as Bank Secrecy Act (BSA), Sarbanes-Oxley Act (SOX), USA Patriot Act, Dodd Frank Act, Gramm-Leach Bliley Act, Basel II, Basel II
• Excellent skills with project management tools such as Jira and Confluence
• Extensive Experience in Requirement Analysis, JAD sessions, SMEs and stakeholders’ interview, Business and system review and working sessions
• Strong process modeling using UML Methodology and MS Visio (Use Case diagrams, Activity diagrams, Data Flow Diagrams (DFD), Sequence diagrams, Business process flow diagrams
• Experience in Requirement/Change Management, Impact and GAP Analysis
• Good knowledge in the training of end-users. Documented Training Manuals for new product releases
• Excellent written and verbal communication
• Strengths include quick learner, excellent analytical & problem-solving skills, a team player and able to lead the teams and consistently demonstrated ability to achieve tight deadline

TECHNICAL SKILLS

Databases: MS-Access, MySQL, SQL Server

Tools: MS Visio, Rational Rose, Rational Clear Case, Rational Requisite Pro

Project Management and Tracking Tools: Jira, HP Quality Center, Rational Clear Quest, Rally

Content Management Tools: Confluence, SharePoint

Utility Tools: MS Office Suite, MS Project

Methodologies: SDLC, Agile, Waterfall, Scrum, Kanban, RUP

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Data Management Consultant

Responsibilities:

• Developed deep and broad partnerships across business, technology, and operations leaders
• Defined (As IS-To Be) by assessing and analyzing current application capabilities within the data domain against target Enterprise Data Policy compliance requirements
• An integral part of breaking down the EPICS into User Stories that the development team could estimate the work using Planning Poker method
• Managed and administered Jira/Confluence and defined Agile process flow into Jira
• Worked closely with the product owner and project manager to identify dependencies and risks of the project
• Contributed to the development of a plan and roadmap to implement required capabilities
• Drove improved metadata, data quality and control capabilities across the applications within the LOBs/domains utilizing matrixed operating model across DMI, Technology and Lines of Business
• Led, organized and provided direction on key activities against other priorities
• Analyzed, tested and developed key enhancements to high standard in Backend and User Interface
• Worked closely with SMEs and stockholders to gather Business Requirement Documents needed for creating new Business Rules Data Quality for the application enhancement
• Prepared and supported executive-level presentations and status updates
• Contributed to deliverables needed for regulatory and audit engagements and exams
• Assisted with performing a holistic review of risks associated with data activities and solutions
• Socialized data governance strategy, implementation approach, data privacy concepts, tools and processes to technology and business application leaders

Confidential, Lewisville, TX

Business Data Analyst

Responsibilities:

• Developed, enhanced and monitored data quality within the Customer Due Diligence Application and its business rules
• Analyzed, tested and developed key enhancements to high standard in Backend and User Interface
• Captured and analyzed Data failures and perform true failure/false positive analysis, root cause analysis to identify remediation/modification/enhancement game plan
• Actively worked in the Teradata platform and write SQL queries to retrieve the data from databases
• Worked closely with SMEs and stockholders to gather Business Requirement Documents needed for creating new Business Rules Data Quality for the application enhancement
• Defined current (As-Is) and future (To-Be) scenarios as well as Data Models for system enhancements to identify new related data quality rules (processes, models, use cases, user stories, plans, and solutions)
• Planned the UAT testing, test plans, test cases and worked with the business users for UAT Test execution and assisted in developing the training documents
• Identified and monitored system failures and act to correct problems. Ensures functional accuracy
• Conducted GAP Analysis and Feasibility Analysis along with Cost Benefit Analysis to document the shortcomings of the system in place
• An integral part of breaking down the EPICS into User Stories that the development team could estimate the work using Planning Poker method
• Performed elicitation techniques to obtain required information from stakeholders to form requirements
• Managed and administered Jira/Confluence and defined Agile process flow into Jira
• Worked closely with the product owner and project manager to identify dependencies and risks of the project
• Actively engaged in Agile environment and act as SME to implement the process into project
• Work closely with Project manager and product owner to capture the requirements for design the Jira dashboard to support project tracking and reporting
• Assist with writing and updating User Manual and training materials content and the delivery of training programs

Environment: s: Agile Scrum, Agile Kanban, Jira, Rally, Microsoft SQL, MS Visio, Tableau, and Confluence

Confidential, New York, NY

Business Analyst

Responsibilities:

• Worked with source system developers, SMEs, Data administrators, Data integration team members to determine the data transformation method and required ETL tools for data transfer
• Assisted with development team and data integration team members to perform data migration using extraction, transforming and loading to the database archives
• Actively participated in Data Warehouse modeling to support BI and reporting team
• Involved with creating project artifacts such as BRD, Use Case Documentation, FRD, Data Mapping Document, and Systems Requirements Specification.
• Developed STM in order to identify how data is being transferred from different sources through the data warehouse
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
• Transitioned from the Waterfall methodology to the Agile framework to improve productivity and continuous improvement of the release cycle and work prioritization
• Designed and implemented business visualizations, dashboards, and reports to deliver insights
• Working closely with QA team to support them in system, integrating, production and regression testing
• Involved in extensive Data Validation using several complex SQL queries
• Maintained Requirement Traceability Matrix (RTM) for requirement, design and test validation
• Prepared the complete data mapping for all the migrated jobs
• Preformed Requirements Gathering and Analysis from the business users and different level of managements to generate BRD, FRD and interacted with software development team as a liaison in helping them to understand the business and functional requirements
• Involved in SCRUM Framework using Agile Methodology and Iterative Software Development Life Cycle Process
• Facilitated JAD sessions and design meetings with the Stakeholders, SME’s and Leads of Interfaces
• Preformed User acceptance testing (UAT) such as business source data consistency, critical data elements validation, sample data validation, count and column check and referential integrity validation
• Developed dashboard from data warehouse in Tableau for reporting and analytical purposes
• Performed requirements modelling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations
• Created and executed Test Plans and Scripts to verify software functionality and adherence to business requirements

Environment: MS Office Suite, SQL, FRD, Data Mapping, UML, Agile, Scrum, RUP.

Confidential

Business Analyst

Responsibilities:

• Owned and documented project artifacts (e.g. Business Requirements Documents (BRD), Functional Requirement Specifications (FRS), Software Requirement Specifications (SRS), etc.) capturing viewpoints of stakeholders and transforming business requirements into technical specifications
• Facilitated meetings between business users and IT technologists
• Assisted the design team to design layout for FUSION according to stakeholder’s requirements
• Helped to add tabs for Loan Search, Customer search, Add/ Edit conductor information for business and personal account holders
• Helped to add the whole new section for sales referral, incentive information, book of business information
• Assisted UI Team to create mock-up screens and wireframes to portray the look and feel of the Potentially Shippable Product (PSPI) establishing the Definition of Done and Acceptance Criteria
• Documented components of BRD and SRS incorporating business, functional, non-functional, data and GUI requirements all together to serve as an information radiator for the project stakeholders
• Used Jira for maintaining and tracking issues, bugs, user story management, work flow management and creating Requirement Traceability Matrix (RTM) for transparent requirements traceability
• Created UML Diagrams like Use Cases, Activity and Sequence Diagrams using MS Visio for clear understanding of the vision document
• Conducted GAP Analysis and Feasibility Analysis along with Cost Benefit Analysis to document the shortcomings of the system in place along with identifying the advantages and functionalities of the proposed system
• Generated ad hoc reports by writing Structured Query Language (SQL) using special functions like Joins, Inner joins, Outer joins, implementing database connections to fetch data from the Servers

Environment: MS Office, MS-Visio, SQL Server