SUMMARY

• Around Eight years of experience as Analyst in Health, Mortgage, and Finance with extensive knowledge and experience in business requirements gathering, database design and development of Web Based, and Client/Server applications in Design and Testing.
• Elicited requirements using interviews, document analysis, requirements workshops, surveys, site visits, business process descriptions and successful in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML), MS Visio and USE cases.
• Participated in business inception process, user meetings and prepared various documents like BRDs (Business Requirement Document), FRDs (Functional Requirement Document), Use cases, sequence diagram, process workflows, RTM (Requirement traceability matrix), STTM, CR (Change Request) documents etc.
• Extensive experience of Systems Development Life Cycle (SDLC) & Software Testing Life Cycle (STLC) well known in Agile/ water fall methodology.
• Assessed business operations and processes of assigned business unit to understand procedures, information flows, decisions, and communication pathways.
• Performed analysis and evaluation throughout the process, application, system, or software development life cycle which includes planning, requirements, design, acquisition, development, integration, installation/deployment, testing, or training.
• Experienced in writing MS - SQL/PL-SQL queries and preparing Test Plan, Test Cases and Test scripts and performed RCA (Root cause analysis) on defects.
• Knowledge in the ETL (Extract, Transform and Load) tools SSIS to extract data into a data warehouse/data mart and extensive knowledge in the Business Intelligence (BI) tools SSRS/Tableau.
• Having experience in critical evaluation of information gathered from multiple sources, reconciliation of conflicts, decomposition of high-level information into details, abstraction from low-level information to a general understanding, and discerning user requests from underlying true needs.
• Extensive experience in Data warehousing concepts, design and development process and have knowledge in developing Data marts, data mining, data mapping, data governance, data profiling and OLTP and OLAP processes.
• Extensive knowledge in Data modeling concepts, involved in Physical, logical, and conceptual data modeling process.
• Strong Communication, Analytical, critical thinking and Presentation Skills substantiated in past assignments with developers, project managers, subject-matter experts, stakeholders, system implementers, and application end-users.
• Creative and Enthusiastic Self-Starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments.

TECHNICAL SKILLS

Operating Systems: Microsoft Windows XP, Windows versions

Databases: MS-Access, Microsoft SQL Server, Oracle SQL, Teradata SQL

Programming Languages: SQL, PL/SQL

Utility Tools: MS Office Suites, MS Project, ServiceNow, Jira, Confluence, SharePoint, Q-test, MS Visio, UltraEdit

PROFESSIONAL EXPERIENCE

Confidential, Norfolk VA

System Analyst Sr.

Responsibilities:

• Performing as a liaison between the Technical/Business, Functional, User, Stakeholder teams in translating the Business Requirements into Functional, Technical/Non-Technical and Operational Requirements.
• Using Agile-Scrum/Kanban methodologies wrote user stories, Acceptance criteria, created Business Requirements Documentation (BRD), Mapping documents and participated in the various agile ceremonies like stories grooming/backlog prioritization/Sprint retrospective meeting/agility health assessment etc.
• Involved in the development of the End-to-End implementations in working with the internal and external partners for different Medicaid/Medicare/CareMore/Vendor Extracts products consuming facets provider data and vendor data.
• Facilitating daily stand ups, addressing deliverables along with the Scrum Master/Product owner to elicit, analyze, communicate, and validate requirements and business processes, submitting estimates/LOE’s and meets DOR (Definition of Ready) to move Jira tickets across the boards.
• Played a key role in the implementation of new markets and developed Provider Network Files for the states and Directories for the members. Analyzed the provider’s information in the FACETS/SAPI Database and inhouse built AGPDM Datamart to extract the provider’s data in the final submission reports in SSRS and Excel based reports.
• Wrote SQL queries for abstracting data from SQL Databases and involved in SIT/UAT/Regression testing, created test cases, and stored in the Q-test.
• Fundamentally transformed the team’s dynamic by driving collaboration, leading cross-training efforts, integrating agile practices, securing fundings, and continuously assess team’s processes to identify and implement improvements.
• Worked as a Team player in the Business consolidation process, preparing scope documents, writing Blueprints, functional specification documents and preparing MOM (Minutes of Meeting).
• Assist End users in UAT (User Acceptance Testing) environment to test the data for the new and modified codes, SSRS reports, data migration and create UAT documents.
• Helped in automating team’s productivity metrics, updating executive’s summary reports, and preparing team’s reports for leadership and collaborating with the upstream and downstream partners for data consumption and delivering reports.

Environment: Microsoft SQL, Oracle, Jira, Q-test, MS Office, MS Visio, Agile Scrum/Kanban, UML, MS Project, MS Access, MS Excel, and MS Word, SSRS, SharePoint, Confluence, MS Teams, Service Now, UltraEdit

Confidential, Urbana, MD

Business/Data Analyst

Responsibilities:

• Actively Participated in Business inception process, Deep dive assessments to understand the business needs and the data migration process.
• Leading business system design, integration, implementation, and support with principal responsibility for overall functionality and project delivery.
• Responsible for developing documentation of system changes and documenting BRDs (Business Requirement Document), FRDs (Functional Requirement Document), CRs (Change Request), TDD (Technical Design Document), Use cases, ERDs (Entity Relationship Diagram), flow charts.
• Involved in mapping the attributes from the Source table to the Target State Data Glossary, understanding the transformations logic and involving with the Users to maintain the documents for the mapping rules and prepared STTM documents.
• Performed GAP analysis, analyzed the AS-IS and To-BE process and analyzed the project scope and timeline and deliverables for the project progress, captured user stories in Jira and followed agile process.
• Involved in analyzing the data and helping the ETL developers to load the data in SQL server database using the SSIS tool.
• Actively involved in the processes of manual excel uploads in the database and provide support in extracting, cleansing, transforms, integrating and loading data into data warehouse.
• Good knowledge in the process of developing Data warehouse, data mart, data governance, data integrity, data mining and data profiling and familiar with the top-down and bottom-up approach of the data warehouse.
• Wrote SQL queries to validate and created test scripts, test cases to perform data validations.
• Involved in preparing data mapping documents as well as business Meta data and technical Meta data and data dictionary for the database.

Environment: Windows, Oracle, MS SQL, MS-Project, MS-Office Suite, MS Visio, MS Visual, AGILE, SSRS, Tableau

Confidential, Jersey City, NJ 

Business System Analyst

Responsibilities:

• Liaison between the client, finance team and development team to support the client’s data analysis and reporting needs, and business requirement gatherings for the client’s need.
• Elicited the requirements for the implementation of a web-based application, documented all the requirements and prepared BRD’s, FRD’s to meet the business needs.
• Worked with the CTB (change the Bank) team to support developers to manage the database, to develop the new reports and providing production support for the data consistency in the reports.
• Used SDLC (System Development Life Cycle) methodologies agile methodology to work in an application consolidation project.
• Wrote SQL queries for abstracting data from SQL databases, analyzed business logics, validating, and verifying reports provided to the users through the web-based applications.
• Owned the entire onshore business process and interacted with the offshore technical team, developer(s), and management to get the requirements, document them, design templates, and write specifications.
• Working and coordinating with the SL1 (Service Level 1) and SL2 (Service Level 2) team to provide production support to the Users to deliver regulatory reports, revenue reports through reporting tool COGNOS and web developed applications.
• Performed manual front-end testing to check all functionalities of different modules and Facilitated user acceptance testing and test strategies for the Users as well as worked with QA to prepare Test cases, Test plan and wrote Test Scripts etc.
• Analyzing the stored procedures, validating the flow of data from the staging tables to the Main tables and verifying data in the reports and solving the bugs and issues with the data.

Environment: Microsoft SQL, Oracle, HTML, XML, MS Office, MS Visio, RUP, UML, MS Project, MS Access, MS Excel and MS Word, Micro Strategy, Windows 7, COGNOS