Avinash Singh

Sr. Systems Analyst

Experienced Senior Systems Analyst with over 10 years of experience and proven track record in optimizing operational
efficiencies and enhancing organizational performance through the strategic implementation of technology solutions. Strong
analytical skills, detail oriented, data driven, and proficient with various technologies as well as excellent facilitation,
interpersonal skills with focus in Business Process Re-engineering, Data Analysis and Enterprise Data Migrations, MDM and
DevOps Solutions.
CERTIFICATIONS
SCRUM MASTER – LINK
ADVANCED SQL - LINK
Data Science and Analytics with Python – LINK
PROFESSIONAL SUMMARY
 Proficient in System Development Life Cycle (SDLC) methodologies such as SAFe, Waterfall, Scrum, Waterfall-Scrum hybrid, XP
and RUP. Hands-on experience in all project phases, ensuring adaptability to various methodologies.
 Provided technical guidance and support to development teams on DevOps tools and practices, including CI/CD pipelines,
automation, and infrastructure as code (IaC) along with implementation of SaaS and PaaS solutions .
 Experience in meeting with stakeholders to identify business requirements and developing requirements documents and use
cases for technology solutions. Experience in evaluating technology solutions to meet business needs and Objectives.
 Developed common practice of Maintaining documentation of project status, including progress reports, issue logs, and action
items, ensuring transparency & accountability throughout SDLC project lifecycle. Possess Expertise in structured escalation
process for addressing project issues, ensuring timely resolution and minimizing impact on project timelines and deliverables.
 Efficient in eliciting requirements from stakeholders and end-users by utilizing methods like Document analysis, Interviews
(structured and Unstructured), Observation (Active and Passive), Brainstorming, Prototyping, Questionnaires, Focus Groups,
Requirement Workshops, and Joint Application Development (JAD) sessions to ensure understanding of project needs.
 Demonstrated adaptability and resilience in a dynamic environment, employing techniques such as prioritization matrices and
scenario planning, resulting in successful project outcomes despite changing priorities, and facilitated Code releases.
 Led the systems and process enhancement initiatives through proactive suggestions, competitive analysis, problem-solving, and
opportunity assessment, driving integration, and creative brainstorming to develop business cases for change initiatives.
 Experienced in conducting SWOT Analysis, Feasibility Analysis, GAP Analysis, Cost-Benefit Analysis, ROI Analysis, Risk Analysis,
Technical and Business impact Analysis, As-Is & To-Be Mapping, and Value Stream Mapping to yield project success.
 Expertise in Using multitude of visualizations and tools like Power BI along with programming languages such as Python.
 Possess expertise in creating essential project artifacts, including Project Vision and Scope statements, Work Breakdown
Structures (WBS), Project Charters, Business Requirement Documents (BRD/BRS), Functional Specification Documents (FSD), and
System Requirement Specifications (SRS). Additionally, adept in developing Risk Registers, Stakeholder Matrices, and RASCI
(Responsible, accountable, Support, Consulted, Informed) to promote engagement with key stakeholders.
 Proficient in analyzing business process workflows and developing detailed UML diagrams, including Use Case, Sequence,
Activity, and BPMN. Additionally, experienced in creating Data Flow Diagrams (DFD) and high/low fidelity prototypes including
wireframes, sketches, and Mock-ups utilizing tools such as MS Visio, Balsamiq, Lucid Chart, Miro and Figma.
 Proficient in Scrum ceremonies like Backlog grooming, planning, Daily stand-ups, Sprint reviews, retrospectives, and release
planning. Leveraged prioritization techniques such as MoSCoW, KANO, Walking Skeleton, Forced ranking and Estimation
techniques using Planning Poker, T-shirt sizing, Value Steam Mapping, 100-points, Rought order-of-magnitude.
 Proficient in writing and defining user stories, creation of MVP (minimum viable product), MMF (minimum Marketable
Features), MRF (Minimum Releasable Features) and producing PBI (product Backlog Items) with Acceptance Criteria.
 Adept in defining Acceptance Criteria, Definition of Ready, Definition of Done (DoD). Participated and Facilitated Agile
ceremonies including Backlog Refining, Sprint Planning, Daily Stand-ups, Sprint Reviews and Sprint Retrospectives.
 Expertise in contributing to Data Warehousing (DWH) projects, collaborating in designing Database Schemas (Star, Snowflake,
Galaxy), implementing Data Marts, and supporting OLAP operations. Engaged in stages of Extraction, Transformation, and
Loading (ETL) processes, including Data Staging, Mapping, Cleansing, Loading, Analysis, and Presentation.
 Proficient in data modeling techniques like conceptual, logical, and physical data models as well as database design principles
such as normalization and its techniques, integrity constraints and indexing strategies (compound and direct).
 Expertise in AWS, Oracle Cloud, and Azure platforms, adept at deploying and managing services like EC2, S3, RDS, Oracle
Database, Azure VMs, Blob Storage, to consistently implement scalable and secure solutions tailored to business needs.
 Skilled in data integration techniques like Health Information Exchange (HIE) and change data capture and handling semi-
structured/unstructured data. JSON, XML, NoSQL databases as well experience with big data technologies such as Hadoop
ecosystem, Apache Spark, and Kafka, and distributed processing frameworks like MapReduce and Task Parallelism.
 Experienced in creating API documentation using Swagger that defined input parameters and results and performed API testing
using Postman and SoapUI to test CRUD operations (GET, PUT, POST, DELETE) operations with HTTP requests and verified that
the response time and error codes were within expectations and satisfied the defined standards of quality and control.
 Proficient in mapping and documenting API requirements for REST and SOAP API in various testing environments.
 Adept at researching issues, developing recommendations, and engaging cross-functional teams to solve business and
technology problems and Experienced in working closely with operational support teams to resolve technical issues per
established SLAs
 Proficient in RDBMS (relational database management systems), SQL queries of diverse types like Data Manipulation Language
(DML), Data Definition Language(DDL), and the Data Control Language to perform analysis of data, verifying the results, creating
ad-hoc reports, metadata , Data Rule Engines and transformations rules.
 Implemented and managed TCP/IP, MLLP, SFTP, REST, and SOAP protocols for seamless data exchange and integration across
diverse systems. Expertise in configuring secure SFTP for encrypted file transfers, RESTful APIs for real-time interactions, and
optimized SOAP web services for structured communication, ensuring efficient system interoperability.
 Possess a clear understanding of transformation rules, aggregate functions, various operations like SELECT, GROUP BY & JOIN,
ORDER BY clauses, and used Stored Procedures, Triggers and Views for pulling data from various sources of data.
 Hands-on Experience in working in development environments such as JDE, JSP Servlet, Angular JS, and Azure DevOps.
 Articulated test cases for User Acceptance Testing (UAT) and documented the Test plan, Test cases, Test scenarios, Test Analysis
reports, Defect Life Cycle and Bug log using Selenium, Cucumber, Bamboo and Jenkins in different environments.
 Performed & assisted in Software Testing - Black Box, White Box, Grey Box, Manual, System Integration, Performance,
Regression, load, Automated, Functional, Non-Functional, Smoke and Sanity Testing, end-to-end testing of entire systems.
 Proficient in Statistical Programming languages such as Python, R Studio, and SAS for statistical analysis and reporting.
 Leveraged advanced proficiency in Business Process Design and Business Process Analysis Tools to streamline and optimize client
platform workflows, ensuring alignment with business model strategies and organizational objectives. Analyzed complex
business requirements, identified gaps, and recommended innovative solutions, resulting in enhanced business processes.
 Applied strong background in client platform and business processes to conduct thorough business requirement analyses,
identifying critical gaps and opportunities for process improvement. Utilized expertise in Business Model Strategy to develop and
implement tailored solutions, driving strategic initiatives and fostering sustainable business growth.
 Adept in visualization tools like Tableau, Power BI, OBI EE Looker Studio and AWS Quick Sight for generating different analytical
reports, Business Intelligence(BI) Reports, and develop dynamic KPI Dashboards to provide insights to stakeholders.
 Skilled in applying quantitative and qualitative statistical approaches to identify patterns, uncover opportunities, and propose
innovative solutions and Experienced in utilizing data mining, predictive modeling, and machine learning to draw insights.

Skills and Tools

Business Skills Project Management, Release management, Requirement Management, Change
Management, Risk Management, Defect Management, Impact analysis, Risk analysis,
cost/benefit analyses, ROI analysis, SWOT analysis, Stakeholder analysis, Market analysis, fit-
gap analysis, Root cause analysis, Feasibility analysis, User Research Analysis, Interface
Analysis, Document Analysis.
Methodologies Waterfall, Scrum, Waterfall-Scrum, LeSS (Large Scale Scrum), Scaled Agile Framework (SAFe)
Project Management Tools JIRA, Azure DevOps, Confluence, Sharepoint, Outlook, MS Project, Miro, Trello, VersionOne
Modelling Tools MS-Visio, LucidChart, Balsamiq, Erwin, Adobe XD, Sketch, Figma, Whiteboard, Miro, StarUML
Database/Data warehouses Amazon Health Lake, Azure SQL Database, Azure Datawarehouse, Oracle, My SQL, Snowflake
ETL Tools Informatica PowerCenter, AWS Glue, Ab Initio, Talend OpenStudio, AWS SnowBall
BI and Reporting Tools Microsoft Power BI, OBI EE, Tableau, AWS QuickSight, Excel, Qlik Sense, Looker Studio
Testing, Defect Tracking Tools Selenium, HP QC/ALM, Cucumber, Bamboo, POSTMAN, Swagger, JMeter, JUnit, Rollbar.
Technologies Amazon Web Services, Microsoft Azure services, Salesforce, Oracle, Azure DevOps, MuleSoft
ERP SAP S/4 HANA, Microsoft Dynamics 365, Oracle NetSuite ERP, Salesforce Customer 360
Programming Languages C++, Java, Python, SAS, R Studio, HTML, CSS, Angular JS, MySQL, Spring Boot, BootStrap

PROFESSIONAL EXPERIENCE

Client: Veeva January 2023 – Present

Sr. Systems Analyst Location: Boston, MA
 Worked in Scaled Agile Framework (SAFe) and collaborated with clients for SDLC project to understand their business needs.
Conducted User Research, Market research, SWOT analysis, and Stakeholder Interviews, including study teams, clinical
operations, data management, and regulatory affairs, to identify user-centered design and alternative solutions for SaaS product.
 Directed project oversight for multiple concurrent initiatives, for alignment with business goals, timely delivery, and budgets.
 Developed storyboards that included user personas and scenarios to illustrate how different users would interact with product.
Worked with UX designers to integrate storyboards into design process, ensuring end product met user needs and expectations.
Performed market research, gathered cost/benefit analyses, draft statement of work (SOW), Requests for Proposals (RFP)
 Conducted thorough As-Is state analysis of the current systems via document analysis and system analysis, by identifying the
pain points using Gap analysis and root cause analysis. Worked closely with cross-functional teams to gather requirements and
design To-Be state, ensuring alignment with organizational Business objectives and enhancing operational efficiencies SLA.
 Actively participated in project planning and requirement gathering sessions, providing technical insights and recommendations
for API and middleware service design. Supported the creation of project plans and schedules, ensuring alignment with business
objectives and timelines. Identified dependencies through Solution Dependency Board. Participated in PI Planning according to
PI Objectives, identifying MVP features (Committed, and Uncommitted) and ART (Agile Release Train), & conducting Inspect and
Adapt along with Kanban management through WIP (Work in Progress).
 Delivered regular project status updates to stakeholders through comprehensive reports and presentations, ensuring clear
communication of project progress, risks, and milestones. Designed and developed interactive project and portfolio dashboards
using Tableau, providing real-time insights into project performance, resource utilization, and budget status.
 Designed and executed a robust data integration strategy leveraging Salesforce Connect for real-time, bi-directional data flows
between applications and Salesforce CRM and other components. Implemented MuleSoft to orchestrate complex integrations
between multiple systems and developed ETL processes using Informatica to consolidate data into a centralized data
warehouse.
 Defined Project Scope, Objectives, and Success Criteria in collaboration with stakeholders. Gathered Functional, Non-functional
(NFRs), Data, and GUI requirements from the stakeholders and created a Project Roadmap outlining key Milestones and
deliverables. Translated high-level project roadmaps into detailed user stories within Jira, decomposing complex features into
tasks. Ensured that User stories met the INVEST criteria, with acceptance criteria and definition of done (DOD).
 Applied Joint Application Development (JAD) technique, utilizing techniques such as prototyping and user story mapping,
resulting in a collaborative & requirements gathering for User stories (vertical Slicing) with well-defined Acceptance Criteria.
 Implemented effective feedback collection mechanisms, such as surveys and feedback forms, resulting in valuable insights for
iterative improvements and enhanced user satisfaction. Applied user-centered design principles in collaboration with User
Experience design and application development for Epics and User Stories and BRD within Jira repository library.
 Collaborated with Product Owner to define dependencies & risks, devising strategies for mitigation. Documented these
strategies in Risk Management Plan& Contingency Plans on Confluence. Maintained RAID log to track Risk in Jira.
 Facilitated interviews, workshops with SMEs, stakeholders, and development teams to gather and align functional, non-
functional, GUI and data requirements, enhancing processes and user experience within Cloud and documenting in SharePoint
 Developed User personas, Mockups, and Wireframes to capture user-centric design principles and guide product development.
 Created Business Process Model Notations (BPMN) to visualize the workflow and utilized UML diagrams such as use case
diagrams, activity diagrams, & sequence diagrams using MS Visio to communicate flow of project & data warehouses (DWH).
 Performed assessing and documenting change requests, conducting impact analysis, recommending appropriate courses of
action, and utilizing change management in Jira to track and maintain change requests in collaboration with stakeholders.
 Created low-fidelity Wireframes and high-fidelity Mockups to visualize UX/UI changes of the system in collaboration with the
Design team using Figma. Took insights using Interface Analysis to elicit interactive elements and release note creation of the
application and collaborated with DB Admin to design artifacts, low-level system architecture diagrams and Data dictionaries.
 Engaged in Sprint Planning meetings, utilizing the 90-day method to define sprint goals in confluence, select Product backlog
items(PBI), & estimate implementation effort using Planning Poker and relative sizing techniques like T-shirt sizing.
 Conducted daily stand-ups, monitored sprint progress through burnup/burndown and velocity charts, tracked bugs and their
resolution, and collaborated with the team sprint deliverables are complete and ready for demo and deployment.
 Utilized Informatica to extract, transform, and load (ETL) data from various systems into the cloud EDC platform. Designed and
implemented complex ETL S2T (source to target mapping) to automate the data integration process.
 Created Requirement Traceability Matrix (RTM) and led vital testing phases, including integration and regression testing. Ensured
robustness and security, and prepared Test Analysis Report, encompassing security testing and other relevant aspects.
 Led the seamless integration of data in reporting, executing SQL queries to navigate relational databases for precise data
management, trend analysis, including data monitoring, predictive analysis, and compliance monitoring.
 Automated batch data extraction, transformation, and loading (ETL) processes to ensure timely data updates using Ab initio
sources. Utilized scheduling tools to automate the execution of batch jobs for EDW, ensuring it runs optimal times.
 Designed and developed an automated data integration solution using XSLT to transform data from Oracle ERP into XML format,
enabling seamless data exchange with external systems. Created XSLT templates to map Oracle ERP data to XML schema,
ensuring accurate and efficient data transformation, utilized MuleSoft for seamless ESB operations and integrations.
 Designed Custom Case management systems and Document Management Systems workflows to be integrated with the Quality
Management systems to streamline the approvals reducing the Average Handling time with new Web portal integrations.
 Utilized Talend MDM to maintain a golden record in AWS Redshift for customer profiles, reducing duplicate entries by 40% and
enhancing data reliability. Created complex SQL queries to extract and transform (ETL) large volumes of customer data from
Salesforce for quarterly business intelligence reports, for actionable insights to senior management
 SSIS was used for creating packages and automating ETL using SQL scheduler and created stored procedures, Views, functions,
TSQL and Triggers. Ensured system compliance with regulatory requirements and data standards for DWH.
 Led the implementation of Document Management System, overseeing computerized document creation, workflows, interfaces,
and storage to streamline document management processes. Designed and developed system interfaces to integrate Veeva
Vault with other enterprise systems, ensuring seamless data exchange and process automation.
 Conducted thorough interface analysis and testing, identifying and resolving issues to ensure smooth system integration and
functionality. Conducted complex business analysis and technical tasks, including project planning, process improvement, writing
requirements, system design, and data analysis, ensuring successful system rollout.
 Performed System monitoring using Prometheus, AppDynamics and Grafana during the go-live and monitored the overall
performance, taking insights to better prepare for releases and maintenance as well as fault tolerance.
 Developed and fine-tuned SQL queries, leveraging window functions and Common Table Expressions (CTEs) to perform
sophisticated data analysis on multi-terabyte datasets. Implemented robust backup and recovery procedures using pg_dump
and continuous archiving, ensuring zero data loss and minimal downtime in the event of system failures
 Managed AWS EC2 instances in Repositories for efficient deployments and track the instances of Registries through AWS ECS
 Implemented security monitoring solutions using AWS CloudWatch and IAM. Documented compliance and security practices.
 Utilized Jenkins - JUnit and JMeter integrated with Jira to promote CI/CD pipelines and release on demand (ROD)
 Identified stakeholders for User Acceptance Testing (UAT) and gathered feedback to facilitate changes, logging it in defect log.
 Performed query optimization and performance tuning on RDS databases on frequent functions in SQL for efficient management
 Tested and validated API endpoints to ensure functionality and performance meet business requirements. Created detailed
documentation of API specifications, including request and response structures, authentication, and error handling procedure
 Supported the QA teams in black-box testing, sanity testing, and system integration testing. Contributed to the formulation and
documentation of test plans, test cases, and test scenarios in an automation testing environment using Jenkins and Cucumber.
Utilized Zephyr for test lifecycle management and GitHub for Source Code management within JIRA and SharePoint.
 Developed Ansible scripts to automate application deployment, service restarts, and environment-specific configurations,
streamlining the release process. Integrated Jenkins with GitHub to trigger builds upon code commits.
 Developed and implemented middleware services using RESTful APIs with JSON, ensuring seamless communication between
different system components. Designed and created API payloads based on requirement and solution design, optimizing data
exchange and enhancing system interoperability. Utilized knowledge of REST principles to develop scalable API solutions.
 Supported the triage and resolution of application/system issues by conducting root cause analysis and identifying underlying
problems. Collaborated with teams to resolve API-related issues, ensuring less downtime & service disruption. Documented
issue resolution steps & preventive measures to improve system reliability & support future incident response efforts.
 Developed a suite of over 500-unit tests using TSQL EDW framework, ensuring the reliability and accuracy of all database objects
including stored procedures, functions, and triggers. Demonstrated hands-on knowledge in data querying, analysis, and mining
using TSQL, Oracle DB, for reports and analytics. Utilized query optimization techniques, indexing strategies, and execution plan
analysis to enhance database performance, resulting in a 12% reduction in query execution times.
 Led end-to-end API integration and testing initiatives, leveraging Postman for comprehensive operation validation across
multiple enterprise systems. Created detailed API documentation using Swagger, enhancing cross-team collaboration.
 Implemented Tableau Paginated Reports for table outputs, streamlining the creation of reports and regulatory submission
documents. Orchestrated Hypercare monitoring strategies, oversaw critical code releases, and managed go-live processes to
production, resulting in zero downtime during major deployments and improvement in system reliability.
 Delivered high-impact presentations to executives, clearly articulating project status, risks, and strategic recommendations.
 Implemented a comprehensive role-based testing framework, categorizing user roles across 7 distinct personas (Administrator,
Regular User, Guest) and developing over 200 tailored test scenarios, defect detection of user permissions and access control.
 Implemented a role-based regression testing strategy, prioritizing test scenarios based on role criticality and feature impact,
which led to a 25% reduction in overall testing time while maintaining 98% test coverage for high-priority user roles.
 Integrated ServiceNow for streamlined incident management, change control, and service request automation across the
system. Utilized ServiceNow's orchestration capabilities to automate complex workflows, significantly reducing process delays
 Utilized Python and SQL for ad-hoc based reports from IQVIA and Veeva Open Data and sharing insights of the project with
senior management teams.
 Used Tableau for detailed dynamic dashboard for Sales Analytics & Operations (SAO), and data cleaning process, allowing study
teams and Site Managers to interpret and analyze real-time and archival and ad-hoc reports. Established reporting mechanisms
such as Site task completion, feasibility Status, Adverse events, summary metrics through dashboards and graphs.
Environments: SAFe 5.1, MuleSoft Any point AWS S3, Amazon RedShift, AWS Kinesis, Jenkins; Ansible, Apache Kafka, Apache
Airflow, Figma, Informatica PowerCenter, Postman, Salesforce CRM, Swagger, Selenium Cucumber, Jira, Python, SharePoint,
Tableau, Microsoft Excel, PowerPoint, Confluence, Microsoft Office Suite (Word, Excel, PowerPoint, Outlook, Visio)
Client: Baylor Scott and White Health November 2021 – December 2022
Sr. Systems Analyst Location: Texas, Remote
 Conducted thorough As-Is and To-Be analysis to identify current system limitations using gap analysis and future requirements,
ensuring alignment with the SDLC project's business objectives and Project Roadmap of enhancing the mobile application.
 Implements a structured methodology to determine priorities and potential opportunities, partnering with stakeholders to
outline the minimum viable product (MVP) and cost/benefit analyses to identify improvements for subsequent phases.
 Performed Document Analysis and Business Process Reengineering (BPR) initiatives, mapping out existing processes and
identifying areas for optimization. Utilized pre-defined workflows (PDW) and Requirement Traceability Matrices (RTMs).
 Facilitated cross-functional meetings and workshops, utilizing SWOT (Strength, Weakness, Opportunities, Threats) analysis and
root cause analysis techniques to address complex business challenges and drive strategic decision-making processes.
 Collaborated with Product Owner to conduct cost-benefit analysis and feasibility studies to evaluate the financial implications
and return on investment (ROI) of the proposed system enhancements, ensuring alignment with organizational business
objectives.
 Conducted stakeholder analysis, employing techniques such as power/interest grids and influence mapping, to identify key
stakeholders and develop tailored communication and engagement strategies, ensuring Buy-in from Stakeholders.
 Developed and implemented comprehensive change management plans, including stakeholder analysis, communication
strategies, and training programs, to ensure successful adoption of new processes and the systems.
 Collaborated with stakeholders to define and prioritize requirements, conducting Joint Application Development (JAD) sessions
and to gather feedback and functional specifications, and alignment with user needs and listing out action items and insights.
 Actively participated in Agile ceremonies, including backlog grooming, sprint planning, daily standups, sprint reviews, and sprint
retrospectives, fostering collaboration and continuous improvement utilizing INVEST criteria in Jira for management, and
tracking user stories and their Epics. Fostered changing requirements using CAB tickets and prioritize development efforts
 Created documentations like PSS (project Scope Statement), BRD (Business Requirement Document), FRD(Functional
Requirement Document), SRS (System Requirements specification) to facilitate the overall development and implementation.
 Leveraged Prioritization techniques like MoSCoW and Estimation techniques like Relative Mass Valuation on the User stories in
Backlog Grooming sessions with the development teams and Product Owner and established sprint goals and Milestones.
 Led the integration salesforce and MyBSWHealth mobile application with other systems, seamless data flow for patient records,
lab results, and medication lists, which reduced medication errors and Care Management across BSW facilities.
 Build transformation pipelines and FHIR API resources and Extensions for seamless transfer of Lab tests, Medical Imaging Files,
as well as other XML, JSON files from HL7 2.X standards for Chronic Care Managed Outcome program (MCO). Performed data
mapping, following the rules and bindings from CIM (Clinical Information Model) to maintain the data quality of the system
 Configured audit trails and data lineage features to ensure regulatory compliance and support data governance. Leveraged
Informatica’s real-time data integration capabilities and change data capture capabilities to support instant data transfer.
 Conducted data mapping exercises using Informatica MDM metadata to align disparate data sources with HL7 international
standards. Standardized data formats to ensure uniformity and compatibility across integrated data models and platforms.
 Collaborated with cross-functional teams to define project objectives and deliverables, employing techniques such as goal
setting and milestone tracking to ensure alignment and accountability throughout the project lifecycle. Assisted Project Manager
(PM) in Creating RASCI (Responsible, Accountable, Support, Consulted and Informed) matrix.
 Leveraged data modeling techniques and entity-relationship(ER) diagrams to analyze and design data structures and schemas for
data exchange, and iteratively created prototyping and wireframing using MS Visio to visualize system requirements and user
interfaces. Utilized tools like Figma to create prototypes, for stakeholders to get feedback & validate experience decisions.
 Developed a secure mobile application for MyBSWHealth, incorporating features such as appointment scheduling, prescription
refills, and telehealth consultations, leading to increased timely follow-ups and reduction in missed appointments.
 Performed migration and validation of the dataset using Informatica MDM and validated S2T (source to target mapping).
 Monitored and assisted in Testing phases throughout the development, like Blackbox testing and System integration testing (SIT),
created Test Cases, and Test scenarios with error handling functions to track any bugs or defects through RAID log.
 Utilized Zephyr for test management to streamline development processes within the development workflows within Git
environment within Atlassian Jira and ensure efficient collaboration across teams and documenting it in SharePoint.
 Created and executed detailed test cases for various API endpoints, including GET, POST, PUT, and DELETE requests, to verify
correct data retrieval and manipulation using SQL and validated custom functions in SQL. Implemented automated test scripts
using Postman’s scripting capabilities (JavaScript) to validate complex business logic and ensure data integrity.
 Performed regular performance benchmarks and stress testing to identify bottlenecks and optimize system resources, improving
overall database efficiency and response times. Analyzed and refactored SQL queries to improve performance, reduce execution
time, and minimize resource consumption, achieving a 15% improvement in query performance.
 Utilized behavior-driven development (BDD) techniques to create role-specific Gherkin scenarios, enhancing communication
between stakeholders and improving test coverage by 15% for critical user workflows across all identified roles.
 Performed thorough API testing using Postman, to validate the integration and interoperability of the EHR system with external
systems and third-party applications. Documented API specifications and generated interactive documentation using Swagger.
 Conducted performance testing of APIs using Postman to evaluate response times, throughput, and scalability under various
load conditions. Identified performance bottlenecks and provided recommendations for optimization to improve API efficiency
 Implemented a structured release management process to coordinate the deployment of new system features and updates,
minimizing disruption to end users and ensuring smooth transitions between development and production environments.
 Conducted comprehensive User Acceptance Testing (UAT) to ensure the functionality through CI/CD pipelines using Azure
DevOps and usability of the enhanced Electronic Health Record (EHR) system, facilitating resolution of potential issues.
 Conducted staff training sessions via Learning Management Systems (LMS) to ensure end-users are equipped with necessary
skills and Documents to effectively utilize the enhanced system and deployed Level 2 support teams on ServiceNow.
 Designed and implemented custom visuals using R scripts within Power BI to perform advanced data analytics and provide
deeper insights into complex datasets. Designed dynamic visualizations within Power BI to perform data analytics.
 Utilized Power BI for ad-hoc reports and visualization for tracking provider enrollment, portal usage, performance metrics, and
user experience and created interactive dashboards for monitoring claims processing volumes, throughput, error rates, and
turnaround times, enabling proactive identification and resolution of bottlenecks and drive business objectives to make
decisions.
Environment: Agile-Scrum, Salesforce, MuleSoft, AWS SQS, AWS ECS, Docker, ServiceNow, Atlassian Jira, SharePoint, Figma,
Postman, Swagger, Git, Power BI, Python, Azure DevOps, Jenkins, SQL , MS Office tools (Word, Excel, PowerPoint, Outlook),
DocuSign, JavaScript, MS Fabric

Client: State of New Mexico October 2019 – June 2021

Sr. Business Data Analyst Location: Albuquerque, NM
 Collaborated with legal and compliance teams to navigate the complex use case and documented stakeholders, data flows, and
current (As-is) and future state process flows (To-be) to streamline Department of Child Support Services Operations.
 Conducted comprehensive Project Roadmap, and requirements gathering sessions, including Document Analysis, workshops,
interviews, and collaborative sessions with Child Support Services Division (CSSD), Human Services Department,
 Gathered, documented, validated, and maintained business, functional, and technical/non-functional solution requirements
essential for market analysis, and solution development processes, whilst also reviewed and analyzed regulations related to
Protected Health Information (PHI), incorporating appropriate data handling protocols into the SDLC format.
 Conducted periodic reviews of available data standards and versions, positioning HSD (Health and Safety Department) to support
emerging health care data standards and facilitate data sharing architectures using FHIR and HL7 standards.
 Employed business analysis like JAD, process flow diagrams and data dictionaries to facilitate alignment with stakeholder
requirements and operational workflows. Facilitated options analysis and supported business case development for proposed
automation projects, utilizing salesforce Service Cloud, Community cloud, Analytical Cloud, Integration and AppExchange.
 Assisted the Business/Product Owner in planning, MVP selection, and preparing for, and conducting user acceptance testing,
including developing test scenarios and test cases. Performed requirements traceability throughout the project lifecycle to
support user acceptance testing and production rollout, ensuring all requirements were met.
 Coordinated with cross-functional teams to allocate resources effectively in Child Support Service initiative, balancing workloads,
ensuring all projects were staffed appropriately to meet deadlines. Prepared detailed financial reports and budget summaries for
senior management, providing clear insights into budget performance and areas for potential cost savings.
 Organized and facilitated brainstorming workshops to gather diverse perspectives and generate creative ideas for project
improvements and new feature development. Documented key takeaways and action items from white boarding and
brainstorming sessions, transforming raw ideas into actionable insights and detailed project requirements.
 Decomposed complex concepts into smaller tasks using S.M.A.R.T criteria while maintaining end-to-end business process focus
 Led the alignment of project objectives with stakeholder needs and priorities and buy-ins effectively with offshore teams.
 Utilized Azure DevOps and SharePoint for Project and documentation management, providing role-based access(RBAC) to the
stakeholders. Working in Collaboration with Stakeholders and Development teams to produce detailed documentation, like
Project Scope statement, Product Vision, and business requirements (BRD) including Epics, User stories from IVEST criteria
 Captured business requirements for various Child Services modules, such as claims processing, provider management, and care
management & developed artifacts, including BRD, User Stories, Functional Specifications, RFP (Request for Proposal), Requests
for Quotes (RFQ), and Requests for Information (RFI) along with SOW(Statement of Work), Technical specification document
(TSD), that aligns with CMS guidelines and state-specific policies.
 Utilized case management features in Salesforce to track and resolve client inquiries efficiently. Integrated omni-channel routing
to manage service requests from communication channels, ensuring timely support and improved client satisfaction
 Developed a customizable web application portal allowing users to access and manage their child support cases, submit
documents, and communicate with service agents through a secure platform. Enhanced user engagement and self-service
capabilities, through Salesforce lightning component and Mobile application integration services for ease of use.
 Conducted comprehensive data mapping to align source data with the target EDW schema. Implemented complex data
transformations to normalize and aggregate data, enabling meaningful analysis and reporting.
 Actively participated in Agile ceremonies, including backlog grooming, sprint planning, daily standups, sprint reviews, and sprint
retrospectives, collaborated with the Product Owner to define acceptance criteria, ensuring alignment with project priority
 Used and enhanced Case Management (CMS) focuses on reducing AHT(Average Handling Time) on SR (service requests).
Implemented ESB (Enterprise Serial Bus) to integrate data models with Web Portal and Case Management Systems (CMS),
enabling seamless exchange of visit data and reducing verification time by 25%.
 Collaborated in the ETL process using Informatica MDM, facilitating the extraction, transformation, and loading of data into the
Enterprise Data Warehouse (DWH). Worked closely with the data team to ensure efficient and accurate data integration.
 Developed and configured DocuSign eSignature workflows to automate document approval process, ensuring compliance and
accuracy. Customized DocuSign eSignature forms using JavaScript to create form behaviors provide dynamic functionality.
 Leveraged ESB’s API Key management capabilities to ensure secure and scalable access to data and integrated MuleSoft ESB to
Program Integrity Module with Case management Module and salesforce Web Portal, enabling real-time monitoring and analysis
of case data to identify potential fraud using security measures such as OAuth and JSON Web Tokens (JWT).
 Wrote data validation queries in MSSQL after data migration to centralized repository to perform manual validation testing
 Presented status reports to customers, highlighting project progress, key achievements, and next steps, ensuring transparency
 Supported the QA team in developing test plans and test cases and test scenarios for Functional Testing, Non-functional testing,
Blackbox Testing, System Integration Testing, and Regression Testing for the system and its modules and created Requirement
Traceability Matrices (RTM), to support the backlog management, making it visible to the stakeholders.
 Utilized MuleSoft to integrate Salesforce with financial management and legal databases, ensuring consistent and accurate data
across platforms. Facilitated case management by enabling real-time data synchronization and reducing manual data entry
errors. Validated Data migration and schemas using SQL to generate ad-hoc based reports for relevant stakeholders.
 Performed API testing with POSTMAN, ensuring JSON data responses aligned with system requirements using swagger and
collaborated with the QA team in defect tracking and bug reporting, ensuring thorough validation against important business
requirements. Tested Data exchange formats in XML and JSON formats.
 Utilized PostgreSQL’s logical replication for near real-time data warehousing, enabling advanced analytics without impacting
OLTP performance. Designed schema migration system, allowing for zero-downtime upgrades across tenant databases.
 Performed API testing with POSTMAN, ensuring JSON data responses aligned with system requirements using swagger and
collaborated with the QA team in defect tracking and bug reporting, ensuring thorough validation against business requirements
 Implemented Power BI Paginated Reports for table outputs, streamlining the creation of reports and regulatory submission
documents. Orchestrated Hypercare monitoring strategies, oversaw critical code releases, and managed go-live processes to
production, resulting in zero downtime during major deployments and improvement in system reliability.
 Led User Acceptance Testing (UAT) using SQL for the application, documenting changes, conducting defect analysis.
 Developed interactive reports with advanced drill-through and drill-down capabilities, enabling users to navigate and explore
data hierarchies and details effectively. Utilized ad-hoc reports and dashboards for stakeholders, leveraging SSRS & Power BI.
Environment: Agile – Scrum, Informatica PowerCenter, Splunk, Tableau, POSTMAN, , Figma, Microsoft Office Suite (Word, Excel,
PowerPoint, Outlook, Visio), SSRS, swagger, SQL, SharePoint

Sun Pharmaceutical Industries Ltd. India May 2018 – September 2019

Business Systems Analyst/ SM Location: Mumbai, India
 Worked on analyzing project roadmap and requirements at all stages of the Software Development Life Cycle (SDLC).
 Conducted comprehensive brainstorming sessions, interviews, JAD Sessions, cost/benefit analyses, business rules analysis, and
customer journey mapping with clinical, administrative, and technical stakeholders to elicit MVP requirements.
 Implemented a real-time resource tracking system, allowing for dynamic reallocation of resources based on project priorities and
changes, resulting in reduction in project completion time. Led the reconciliation of project budgets, identifying discrepancies
and implementing corrective actions to maintain budget integrity and accuracy.
 Created UML diagrams like Use Case Diagram, Sequence Diagram, Activity Diagram to provide clear and comprehensive visual
representations, thereby facilitating streamlined development process to understanding of business requirements.
 Implemented an iterative development approach, utilizing both high fidelity and low fidelity prototypes to meticulously refine
and optimize the data warehouse design for optimal analytics capabilities using Figma.
 Developed Project Management Plan (PMP), Business Requirement doc (BRD), Functional Requirement doc (FRD), User
Requirement Specifications (URS) and Data Mapping Documents and data models for Waterfall-Scrum-Hybrid framework.
 Expertise in developing thorough and high-quality documentation, such as user stories, use cases, and test scripts.
 Proactively supported the Project Manager in proficiently managing Project scope, Schedule, interwoven Dependencies, Budget
allocation, Risk assessment, and comprehensive Status reports throughout the Project life cycle.
 Participated in Scrum ceremonies (Sprint Planning, Daily Scrum, Sprint Review & Sprint Retrospective), coaching the team in self-
management and adhering to time boxes. Maintained Impediment Log, proactively resolved impediments and blockers.
 Proficient in user story writing sessions with Product Owner, extracted User Stories and compiled Product Backlog with DEEP
user stories that satisfy INVEST criteria. Conducted Backlog Grooming Sessions with Product Owner and Development team to
refine Product backlog by applying Prioritization techniques (MoSCoW) and Estimation Techniques (Planning Poker).
 Created ETL documentation such as EDI X12 837(P,I), 834, and 835 Data mapping, transformation logic for Main Frame, updating
Meda data documents for new Platform, re-engineered and captured EDI transactions with legacy systems Enrollment -834,
Eligibility Transaction (270/271), Claims (837), Claim Status Request & Response (276/277), Remittance (835).
 Designed and configured ODI mappings and integrations to support real-time data synchronization between operational systems
and the data warehouse, enhancing data accuracy and availability. Utilized ODI’s knowledge modules (KMs) to automate data
extraction, transformation, and loading processes, reducing manual intervention and minimizing errors.
 Facilitated the creation of essential Scrum artifacts including Product Backlog, Sprint backlog, Release Burn down charts, Sprint
Burn down chart, User Story Mapping, and Scrum Planning Boards fostering efficient progress tracking.
 Utilized Informatica PowerCenter to extract data from structured (databases, spreadsheets) and unstructured (text files, XML)
sources into the EDW. Designed ETL processes to efficiently load large volumes of data into the warehouse (DWH)
 Conducted comprehensive data mapping using Informatica MDM to align source data with the target EDW schema.
Implemented complex data transformations to normalize and aggregate data, enabling meaningful analysis and reporting.
 Created SSIS packages to automate daily data imports from multiple systems, harmonizing diverse data formats into a
standardized data model. Implemented incremental load patterns using change data capture (CDC) in SSIS, minimizing data
transfer volumes and ensuring efficient updates of the central data warehouse.
 Ensured data governance using Dataverse, implementing data access controls, and auditing data usage.
 Developed error handling and logging mechanisms within SSIS packages, providing detailed audit trails for all data movements
to support regulatory compliance requirements. Utilized SSIS expressions and script tasks to implement complex data
transformation rules, ensuring compliance with standards for data representation.
 Collaborated in formulation and implementation of test strategy, test plan, test cases, test documentation. Facilitated functional
walkthroughs and provided support in User Acceptance Testing (UAT) sessions, ensuring alignment with business requirements.
 Maintained document repository in SharePoint and set up approvals, view permissions and notifications MS Power Automate
 Proficient in SQL query for database object management, Common Table Expression(CTE) and data visualization using python,
including tables, views, procedures, functions and visualizing query results in different types of charts and reports.
Environment: Waterfall-Scrum-Hybrid framework, Figma, Excel, Jira, Python, Sharepoint, Tableau, , Cerner, Informatica, Erwin,
Oracle, GitHub, Selenium WebDriver, Splunk, Cucumber, SQL, Microsoft Office Suite(Word, Excel, PowerPoint, Outlook, Visio)

Fortis Health January 2017 – April 2018

Business Analyst Location: Pune, MH
 Led comprehensive requirements analysis in SDLC format, employing techniques like document analysis and Joint Application
Development (JAD) sessions, eliciting business needs, defining MVP, ensuring nuanced stakeholder expectations.
 Conducted thorough impact analysis to accurately capture and document Business Requirements Document (BRD), Functional
Specification Document (FSD), Software Requirements Specification (SRS) using IBM Rational RequisitePro.
 Utilized Azure DevOps to deploy and create web applications using ASP.NET Model-View-Controller (MVC) architecture
 Executed extensive Gap Analysis and Fishbone Analysis using tools like Minitab to meticulously identify process inefficiencies.
Proposed and successfully implemented strategic enhancements for streamlined workflows, ensuring improved overall system
performance, and performed data modeling, designed logical and physical data models using ER diagrams in Microsoft Visio.
 Performed complex SQL queries using operations such as JOIN, GROUP BY along with aggregate functions and subqueries to
retrieve, manipulate, and analyze S2T (source - target mapping) of large datasets from EDW databases using Google BigQuery.
 Performed complex data analysis and created ad-hoc reports using Microsoft SQL (SQL Server Reporting Services (SSRS).
 Developed detailed Requirement Traceability Matrix (RTM) using IBM Rational RequisitePro that maps &traces requirements
with test cases helping in defining Entry and Exit Criteria to capture, track, and meet the requirements during the project
lifecycle.
 Created, documented, and maintained functional test cases, UAT and other artifacts like test data, data validation, harness
scripts, and automated scripts using HP Application Lifecycle Management (ALM)/Quality Center (QC).
 Assisted in Defect Life Cycle Management and creating Issue logs in HP ALM/QC and performed integration testing.
 Developed Power BI reports such as claims submission, financial performance, expenditure, and denials reports to convey
project status, changes, and key metrics to stakeholders, facilitating effective communication in the enhancement project.
Environment: Waterfall, .NET, ASP.NET MVC, SQL Server, Oracle, MS SSRS, Power BI, IBM CLM tools, Swagger, Jira, Microsoft Office
Suite (Word, Excel, PowerPoint, Outlook, Visio)
Cognizant April 2014 – December 2016
Web Applications Developer Location: Hyderabad, IN
 Performed analysis following SDLC project format, workflows to identify integration points and data exchange requirements,
cost/benefit analyses ensuring interface implementation determined in Joint application development (JAD) sessions.
 Developed HL7 standard interfaces for Diagnostics Imaging, hospital reports, and Practice Management (PM) by utilizing IntelliJ
IDEA and Eclipse IDEs for efficient coding and using Planview PPM for project management operations.
 With a team of 6, designed robust interface architecture and data exchange protocols adhering to HL7 standards, enabling
seamless interoperability with Cognizant’s systems, leveraging Apache Tomcat and Nginx as web development tools.
 Developed detailed interface specifications, data mapping documents, and collaborated closely with cross-functional teams to
facilitate integration between Cognizant and external systems, fostering efficient data exchange and operational excellence.
 Managed complex data sets using MySQL, MongoDB, and implemented RESTful APIs, ensuring optimized performance and
tested API integrations and GET, PUT, POST, DELETE operations using RESTAssured and SOAPUI.
 Led a team in developing scalable web applications using the latest technologies like CSS, Angular JS, and Spring Boot.
 Conducted rigorous performance and load testing of HL7 interfaces and web applications using industry-standard tools
like Selenium and JUnit, and integrated tests into CI/CD pipelines with Jenkins, ensuring code reliability, optimal performance.
 Created ad-hoc reports reports in Looker Studio; providing stakeholders with valuable insights and tracking critical key
performance indicators (KPIs) such as patient demographics, appointment scheduling efficiency, and revenue trends using
Tableau.
Environment: Agile – Scrum, Jira, IntelliJ IDEA, Eclipse, Git, AngularJS, SpringBoot, MySQL, MongoDB, Selenium, Junit, Jenkins,
Tableau, Looker Studio, Sharepoint, Power Automate, HL7 Toolkit, Nginx, Swagger, Microsoft Excel, PowerPoint, LookerStudio
EDUCATION
Master of Science in Data Science and Analytics – Grand Valley State University | Michigan
B. Tech in Computer Science and Engineering – SRM University, Chennai | Tamil Nadu