SUMMARY

• Hand - on experience of 6+ years as an IT and Management Professional in Software Development Life Cycle (SDLC) with the ability to solve complex problems by applying technical and functional knowledge for business success. Ability to analyze business & system requirements and perform ETL operations using SQL queries.
• Strong understanding of Operational Data Store development and Data Warehousing.
• Proactively works with the business users) and technical stakeholders to analyze and define new product developments.
• Strong experience in concept Elicitation techniques - conducting User interviews, Document Analysis and also analyzing business requirements, working with legacy systems and re-engineering business processes.
• Experience working in Agile Scrum, Kanban and SAFE Agile environment, as well as Waterfall, with ability and comfort in taking leadership role to drive projects involving multiple stakeholders and opinions.
• Experience in defining business requirements i.e. functional, and non-functional Requirements while acting as a liaison to stakeholders/users (SME's) to communicate solutions, resolve questions, assess needs, and recommend changes.
• Proficient working with MS Excel Spreadsheet, G-suite, Charts, Vlookup and Pivot Tables.
• Detailed knowledge of Learning Management System (LMS), analyzing 27 million educational records.
• Familiar with HIPAA EDI transactions such as 835, 837 (P, D, I) 276, 277, 278 etc.
• Strong knowledge of Microsoft Azure DevOps (Git, CI/CD, Builds, Deployment, Pipelines, Boards, Repos).
• Experience in developing documentation using range of techniques: proficient in creating flowcharts, as-is/to-be process diagrams, data flow diagrams, use-case diagrams, statement of purpose documents, ERD diagrams, CDM (Canonical Data Models) on MS Visio for better understanding of the business processes.
• Experience with extracting data from Excel and SQL database to populate data in Power BI/Tableau and create dashboards.
• Ensuring implementation of PMO processes and proper usage of tools.
• Holds understanding of testing methodologies like Regression testing, tSQLt Unit testing, Integration testing, phases like SIT and UAT, and creating test cases, test scripts and plans.

TECHNICAL SKILLS

Programming and Database Languages: SQL, MySQL, T-SQL, XML, HTML, DAX, Python, PowerShell, C++

Hands-on Computer/System Applications/Databases/Processes: MS Visio, Erwin, Balsamiq, MS Visual Studio/ GIT Repository, MS Team Services, TOAD, SQL Server Database, SSIS/SSRS/SSAS, SSDT, ETL, MS SQL Management Studio, RDBMS, MS Project, Slack, MS Excel, MS Azure DevOps/Cloud (CI/CD), Google Suite, Azure Team Services, JIRA/Confluence/Share-Point, MS Office 365 Suite, MS Outlook/OneNote, Power BI, Domo, Git Bash.

Business/Data Analysis Skills: Waterfall/Agile Software Methodology (Scrum), Requirements Gathering, Business Process Modeling, Backlog Refinement, User Story Creation, Function & Non-functional Requirements, Technical/Non-Technical Documentation, Requirements Traceability Matrix, BusinessRequirement Documentation, Function/System Requirements Documentation, SQL Unit/Regression/System/Integration and UAT testing, Business Process Mapping, GAP/Risk/SWOT/Impact Analysis. Sprint Standup/Planning/Sprint Review/Sprint Retrospective, ETL Development, Data Migration, Data Mapping, Data Modeling, Data Analysis, Data Cleansing, Data Warehousing, Data Transformation, Data Governance, Dimensional Modeling.

PROFESSIONAL EXPERIENCE

Confidential

Analyst / Data Architect

Responsibilities:

• Extensive development work on Visual Studio 2019 and GitHub using Git commands and Git Bash.
• Validated already developed python reports . Fixed the identified bugs and re-deployed the same.
• Used Python scripts to update content in the database and manipulate files.
• Completed the iLearnNYC Learning Management Systems (LMS) Project for Summer Schools.
• Worked on iLearnNYC LMS to help the IT team create an online portal designed to broaden and enhance the DOE student information system and Course data structures.
• Facilitate PMO governance meetings, including setting up Agenda/Minutes/Action tracking.
• Establish positive, collaborative relationships with PMO team members, technology staff, management and business stakeholders to enable the PMO to support business goals and objectives successfully.
• Lead business systems and data analysis for the DOE Office of Data Management (DOE - ODM) through all phases of software development lifecycle and implemented agile methodology.
• Provide technical assistance in software product development and data evaluation by documenting stakeholders, business rules, requirements, processes and outcomes.
• Implement work plans and project schedules based on the scope and time frames set by the Data Architecture Lead, external/internal clients and other stakeholders.
• Managing and preventing integration problems by using Continuous Integration / Continuous Delivery (CI/CD)
• Used effective Adaptive (Scrum) techniques (user-stories and acceptance criteria) to conduct bi-weekly sprint team meetings in order to ensure that the development activities are streamlined using Azure DevOps team services.
• Demonstrated experience and understanding of the methodology testing in a DevOps environment, which include experience in using Azure DevOps for auto deployment of a build.
• Create dashboards on Power BI and Tableau from various data sources i.e. Excel and SQL.
• Worked with project leads to define requirements, develop project scope, and manage risk.
• Worked with DOE subject matter experts and business stakeholders on problem definition, the analysis of root causes, and the validation of solutions through data analysis.
• Leverage relevant business process, requirements lifecycle, and documentation standards across all areas of work to ensure qualify, efficiency, and sustainability of products.

Confidential

Business System Analyst

Responsibilities:

• Responsible for requirements gathering, risk analysis, project planning, scheduling, testing, defect tracking, management, and reporting.
• Conducted requirements walkthrough understand and document system and business requirements.
• Worked extensively with Subject Matter Experts (SME's) in understanding, extracting the User & Business Requirements pertaining to clients & wrote functional specification documents & non-functional documents.
• Excellent experience in directly working with end customers, managing internal and external customer relationship and communicating verbally and in writing on daily basis.
• Defined problem scope developed a root-cause analysis and completed solution validation for the business team.
• Collaborated with project managers to define project scope, requirements and manage risk.
• Developed functional specifications and system design specifications based on client wants.
• Executed SQL queries to join tables and to validate and provide relevant input data using Functions.
• Documented the technical/integration environment, and updated specification documents as necessary.
• Utilized a proprietary Access database to store requirements and Notes to document the test cases.
• Worked with UX and visual enhancement teams to ensure adoption of brand approval and framework acceptability for all front-end requirements.
• Responsible to create UI designs, UI mock-ups and write business rules based on that for IT and QA Team.
• Extensive experience in Requirement gathering, Quality Assurance and User training in SDLC methodologies
• Documented work through the creation of use cases, user stories, and activity, entity and data flow diagrams, using Visio for requirements clarity.
• Identified and created all necessary business use cases from requirements, created UML Diagrams including use cases diagrams, activity diagrams, sequence diagrams, and class diagrams using Microsoft Visio and Erwin.
• Adept in identifying Functional Points and converting Business Needs into Business Requirements Design (BRD) & Software Requirement Specifications (SRS), and user interface specifications.
• Participated in the UAT, Regression testing, System Testing and Unit testing with the team members to analyze the web development and relational databases functionalities.
• Worked closely with users, business supporters and technical supporters (QAs and Developers) to develop high quality Business Requirement Documentations and Functional Specification Documentations.
• Worked with the QA team throughout the Bug Lifecycle, to help fix the bug and re-run the test case.
• Preparing and maintaining Requirement Traceability Matrix (RTM), Testing Estimation, and Test Plan.
• Ensured issues were quickly identified, tracked, reported on, and resolved in a timely manner.
• Leveraged relevant business process, requirements lifecycle, and documentation standards across all areas of work to ensure qualify, efficiency, and sustainability of products.
• Ensured the timely delivery, data integrity and completeness of monthly KPI metrics at a business level to represent it to the senior management.

Confidential

Business Analyst

Responsibilities:

• Worked on artifacts such as Business Requirement Doc, Functional and Non-Functional requirements Documents Uses cases etc.
• Formulated system design, methods, procedures, policies and workflows affecting Medicare/Medicaid claims processing in compliance with government compliant processes such as HIPAA/ EDI formats and accredited standards.
• Well versed with claim adjustments, claim processing from point of entry to finalizing, claim review, identifying claims processing problems, their source and providing corresponding solutions.
• Was involved in managing the Daily Standup meetings and also ensured that quality standards were enforced as per the build-release schedule.
• Planned and executed multiple projects of various complexities including implementation, support, testing, and documentation and monitoring EDI systems - with data mapping, translation and interfaces.
• Modeled data for data warehouse and related data marts, using Structured Query Language (SQL) and other development/technical tools.
• Applied data cleansing techniques to ensure consistency amongst data sets and data marts.
• Created Data models using Visio for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Collaborated with stakeholders to develop new business processes, including modeled the Current Business Process (As-Is) and the Future Business Processes (To-Be), identifying gaps via Gap analysis.
• Responsible to prepare User Training Material, User Manuals for the deliverables and facilitated practitioner training sessions for users, marketing team, external agents.
• Facilitate Integrated BETA and UAT (user acceptance testing) with business and external agents.
• Collaborated with project leaders to define project scope, requirements and manage risks.
• Supported the implementation team to create the High-level and Low-level Process Flows, Technical Specification Diagrams.
• Thoroughly used database Testing for data mapping, Data testing between 2 web applications, inserting data, retrieving data using SQL queries.
• Completed documentation activities utilizing Unified Modeling Language (UML) methodology to prepare Use-Case Models, User Stories, Flow Charts, Activity Diagrams, Data Flow Diagrams, Entity Diagrams, and ER diagrams using MS-Visio.
• Experience in Medicaid Management Information System (MMIS). Expertise in various subsystems of MMIS- Claims, Provider, Recipient, Procedure Drug and Diagnosis (PDD), Explanation of Benefits (EOB).
• Used Azure DevOps team services to write user stories and update the sprint/product backlog.
• Write SQL test scripts to test members’ files and Ad-hoc analysis in SQL Management Studio and run ETL packages in Visual Studio using SSIS.
• Develop SQL test scripts, ad-hoc analysis in SQL Management Studio, and SQL Server Integration Services Packages (SSIS) for ETL processes to test members’ files for extraction from relational databases:
• Write highly complex stored procedures, T-SQL functions and unit test framework, with multi-table joins, group functions, subqueries, set operations, and user defined functions/views.
• Perform SQL Unit Testing and System Integration Testing.
• Collaborated with stakeholders on problem definition, root cause analysis, and solution validation, including through the utilization of data cleansing techniques
• Conducted functional walkthroughs, User Acceptance Testing (UAT) sessions, and supervised the development of User Manuals for customers.
• Prepared deliverables including Software Requirement Specifications, User Interface Specifications, screen mock-ups, report mockups.
• Used the SMART rule to make sure all the requirements align with the needs of the organization.
• Worked on different EDI healthcare transactions like 837-Institutional, 837-Professional, 837-Dental, 835-Claim Payment/Remittance Advise, 270/271-Eligibility Benefit Inquiry/Response, 276/277-Claim Status Inquiry/Response Transactions.
• Participated in grooming sessions with development, QA and PM’s to explain the requirements and objectives.
• Responsible to facilitate Requirement gathering session, Initiating, defining, Solution Scoping, preparing System documents with data dictionaries.
• Reviewed the test cases and worked with testers to review the Test Analysis Reports.
• Leveraged relevant business process, requirements lifecycle, and documentation standards across all areas of work to ensure qualify, efficiency, and sustainability of products.