SUMMARY

• Business Systems Analyst with 10+ years of experience in Business Development Process and Systems and Data Analysis in teh healthcare domain. Certified Scrum Master with proven ability to work with self - organizing and cross-functional teams. Lean Six Sigma Green Belt certified in process improvement and business process re-engineering.
• Experienced in working in various software development methodologies such as Waterfall, Agile Scrum and Hybrid of Waterfall and Agile Methodologies, also has fair understanding of other industry standard methodologies like Extreme Programming, SAFE, Spiral and Kanban.
• Familiar with current healthcare industry standards such as CMS and MMA Guidelines, HIPAA guidelines (4010 & 5010) and EDI Transactions like 820, 834, 835 & 837, DHHS, SOX, FDA regulations.
• Hands-on experience on implementingCloud Solutionsusing various AWS Services includingEC2, VPC, S3, Glacier, EFS, AWS Kinesis, Lambda, Directory Services, Cloud Formation, Ops works, Code Pipeline, Code Build, Code Deploy, Elastic Beanstalk,RDS, Data Pipeline, DynamoDB, Redshiftetc.
• Hands-on experience on Architecting and securing teh Infrastructure on AWS usingIAM, KMS,Cognito,API Gateway,Cloud Trail,Cloud Watch,Config,Trusted Advisor, Security Groups, NACLetc.
• Expertise inDevOps, Release Engineering, Configuration Management, Cloud Infrastructure, Automation. It includesAmazon Web Services (AWS), Ant, Maven, Jenkins, Chef, SVN, GitHub, Serena Products, ClearCase, Build Forge, Serena PVCS, CVS, Tomcat, JBoss, LINUX etc.
• Strong experience in Claims Processing and Claims Scrubbing in HMO, PPO, Medicaid and Medicare.
• Extensive noledge of Medicaid (MMIS), Medicare, Procedural and Diagnostic codes and Claims Process.
• Proficient in preparing Business Requirement Document (BRD), Functional Requirement Document (FRD), System Requirement Specification (SRS), Use Case specification, Configuration Document, and RACI matrix.
• Collaborated on creating Work Breakdown Structure (WBS) using MS Project, tracking schedules and milestones.
• Helped business in decision making by providing SWOT Analysis, Feasibility study, Root cause analysis, Cost- Benefit Analysis, AS-IS To-Be business analysis, Pareto analysis, why-why analysis, Regression analysis.
• Proficient in networking with individuals at various levels while organizing, conducting and facilitating requirement elicitation sessions such as survey/questionnaires, interviews, brainstorming, focus group, requirement workshops, document analysis, JAD sessions, Interface analysis, Observation, Reverse engineering.
• Facilitated discussions for decision making and conflict resolution to ensure good work environment.
• Expertise in Graphic User Interface Design (GUI), Mocks-ups using Balsamiq tool, MS-VISIO and Smart Draw.
• Experienced in tracing requirements and verifying to Requirement Traceability Matrix (RTM).
• Proficient in writing TEMPeffective SQL queries in SQL, Oracle databases for business analysis and review.
• Designed and implemented SQL queries and stored procedures. Used functions like joins, unions, outer joins, group by, order by and aggregate functions to extract data for timely reporting and validation.
• Experienced in Data warehousing and ETL process. Well aware of teh DW creation process including OLTP, OLAP, Data marts, ODS, Staging, Data sources, Normalization, Dimension tables.
• Good noledge of teh Star and Snowflake schema, different OLAP operations such as slice, dice, roll-up, drill down and pivot, facts and fact tables, etc. transformation and validation rules.
• Involved in Data/Dimensional Modeling; Data mapping, Data integration, Data migration, Data Extraction, Transformation & Loading (ETL).
• Experienced in API testing using Postman and SoapUI to check if teh API response data is in JSON or XML format as defined in teh API documentation and required by workflow and resolve discrepancies.
• Worked with QA team to design Test plans and Test Cases for User Acceptance Testing (UAT) using Selenium, Cucumber, HP ALM.
• Experienced in Testing Life Cycle, Manual testing, Unit testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT), Load/Stress Testing, and Performance Testing.
• Generated multiple reports using different BI tools like Tableau, Qlikview and in-house reporting tools.

TECHNICAL SKILLS

AWS services: AWS- EC2, S3, RDS, EBS, ELB, VPC, Cloud Watch, NAT, Route 53, Dynamo DB, IAM, SQS, SNS, SES, Apache servers, Linux servers

Business Skills: Change Management, Problem & Incident Management, Impact Analysis, JAD Sessions, SWOT Analysis, Risk Management, Conflict Management, Pareto analysis, Effort and Impact analysis, Regression analysis, Why-Why analysis.

Business Intelligence tools: Tableau, IBM Cognos, Power BI, MS Excel

Business Modeling tools: MS Visio, Mockup Screens, Balsamiq, Unified Modeling Language (UML)

Project management tools: MS Project, MS SharePoint, MS Office 365 online

Requirement management tools: JIRA, HP ALM, Agile CA (Rally), Confluence, SharePoint

Reporting tools: Tableau Desktop, IBM Cognos, Qlikview

Architecture/Framework: Service Oriented Architecture (SOA), N Tier ArchitectureCloud Platform (SaaS & IaaS), Apache Tomcat Web Server, RedHat JBOSS.

Testing tools: HP ALM, Load Runner, Postman, SoapUI, Selenium, Cucumber

Databases: MS SQL Server, Oracle, IBM DB2, MS Access

Languages: HTML, CSS, XML, SQL, Java/J2EE, JavaScript, JSON, SOAP.

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Lead BSA

Responsibilities:

• Created business and technical requirements, functional specifications, gathered and translate functional requirements into technical requirements using Scrum methodology.
• Co-ordinated with onshore and offshore development teams for functional requirements specifications in form of use cases, process flows, and prototypes and management reporting requirements using multiple elicitation techniques such as interviews, focus groups, brainstorming, prototyping, JAD, etc.
• Prepared a detailed Business Requirement document (BRD), Functional Requirement Document (FRD) and System Requirement Document (SRS). Created mock-ups, low fidelity and high-fidelity wireframes using Balsamiq tool. Experienced in developing User Stories throughout teh Agile Lifecycle as well as created UML diagrams such as Use Case, Activity, ER diagrams with Lucid chart.
• Involved in designing and deploying a multitude application utilizing almost all of teh AWS stack (Including EC2, Route53, S3, RDS, Dynamo DB, SNS, SQS, IAM) focusing on high-availability, fault tolerance, and auto-scaling.
• Worked with security groups for EC2 instances along with designing IAM roles for Confidential services to interact with each other.
• Provisioning Confidential Dynamo DB for a fast and flexible NoSQL database service for teh applications dat need consistent, single-digit millisecond latency at any scale.
• Making use of Confidential Virtual Private Cloud ( Confidential VPC) for provisioning a logically isolated section of teh Confidential Web Services (AWS) cloud to launch AWS resources in a virtual network.
• Utilizing Confidential CloudFront as a Global Content Delivery Network (CDN) service for accelerated delivery of websites, APIs, video content or other web assets through CDN caching.
• Utilizing Confidential Route 53 TEMPeffectively for connecting user requests to infrastructure running in AWS - such as Confidential EC2 instances, Elastic Load Balancing load balancers, or Confidential S3 buckets.
• Created prototypes dat would custom fit teh needs for Dev, Test and Prod environments.
• Responsible for designing and developing new back-end services, maintaining and expanding AWS infrastructure and providing mentorship to others in my team.
• Manage teh execution of deliverables, both short and long-term, via clearly defined milestones, and timelines.
• Playing key role in migrating teh existing on-premise applications toAWS VPC.
• Responsible for creating Well-Architected Application on AWS usingAutoScaling, Lambda, SQS, SNS, ELB, Caching and database layer as necessary.
• Creating AWSMulti-Factor Autantication(MFA) for instance RDP/SSH logon, worked with teams to lock down security groups.
• AWS data backup (snapshot, AMI creation) techniques, along with data-at-rest security within AWS.
• Worked with Development, QA, and Production Support teams to communicate, verify, and test teh desired functionality changes. Helped teh Testing team in creating Test Plans, Test Scenarios, Test Cases and collected Test Data for successful completion of Integration Testing and Functional Testing.
• Performed Manual testing using, Integration testing, System testing, User Acceptance Testing with UAT cases and resolved issues with teh users.
• Created various charts, graphs, reports for business analysis using Tableau Business Intelligence tool. Report extractions to various formats, Snapshots, Dashboards, and Email generation according to application requirements in salesforce.

Environment: Agile/Scrum, Service Oriented Architecture (SOA), AWS (EC2, S3, VPC, Route53, EBS, RDS, ELB, CloudWatch, CloudFormation, AWS CLI, AWS Auto Scaling),, JIRA, Tableau,, UML, and UAT Testing

Confidential, Phoenix, AZ

Lead BSA

Responsibilities:

• Created business and technical requirements, functional specifications, gathered and translate functional requirements into technical requirements using Scrum methodology.
• Co-ordinated with onshore and offshore development teams for functional requirements specifications in form of use cases, process flows, and prototypes and management reporting requirements using multiple elicitation techniques such as interviews, focus groups, brainstorming, prototyping, JAD, etc.
• Prepared a detailed Business Requirement document (BRD), Functional Requirement Document (FRD) and System Requirement Document (SRS). Created mock-ups, low fidelity and high-fidelity wireframes using Balsamiq tool. Experienced in developing User Stories throughout teh Agile Lifecycle as well as created UML diagrams such as Use Case, Activity, ER diagrams with Lucid chart.
• Developed teh Requirement Traceability Matrix (RTM) for future references and tracking teh progress.
• Maintained defects by prioritizing them against teh backlog items and tracked them till completion using JIRA.
• Implemented customized CRM tool using salesforce to capture teh calls and chats of teh customers for analysis. Imported data from excel sheets in to Leads, Accounts, Contacts and Opportunities objects using Data Loader and Import Wizard. Designed various types Email templates for auto response to customers.
• Facilitated meetings with Salesforce developers in presence of Sales and Marketing team to discuss about teh data dat needs to be ingested into Sales cloud and Marketing cloud.
• Created Data mapping document to show teh fields and elements mapping from source to target systems and teh transformations required before updating teh elements in teh target database or system.
• Designed and implemented SQL queries and stored procedures. Used functions like joins, unions, outer joins, group by, order by and aggregate functions to extract data for timely reporting and validation.
• Extensively involved in mapping data from various sources to teh target database tables.
• Worked on API documentation using Swagger tool. Analyzed domain specific API’s while conducting teh Interface analysis, to interpret teh data formats in their WSDL/WADL for a thorough understanding of business requirements and supported integration of compliance REST API’s with Business Rules Engine.
• Performed API testing using Postman and SoapUI to check if teh API’s are returning teh data as defined in teh API documentation using Swagger tool and required by workflow.
• Worked with Development, QA, and Production Support teams to communicate, verify, and test teh desired functionality changes. Helped teh Testing team in creating Test Plans, Test Scenarios, Test Cases and collected Test Data for successful completion of Integration Testing and Functional Testing.
• Performed Manual testing using, Integration testing, System testing, User Acceptance Testing with UAT cases and resolved issues with teh users.
• Created various charts, graphs, reports for business analysis using Tableau Business Intelligence tool. Report extractions to various formats, Snapshots, Dashboards, and Email generation according to application requirements in salesforce.

Environment: Agile/Scrum, Service Oriented Architecture (SOA), Lucid Charts, JIRA, Tableau, Salesforce CRM, UML, and UAT Testing, Oracle Suite Commerce, Suite Commerce Advanced, MuleSoft, REST

Confidential, New York, NY

Lead BSA

Responsibilities:

• Created business and technical requirements, functional specifications, gathered and translate functional requirements into technical requirements. Conducted meetings with stakeholders from FIA, BPI, ITS Executive, Filenet, Broker, Network and Storage teams.
• Co-ordinated with development teams for functional requirements specifications in form of use cases, process flows, and prototypes and management reporting requirements using multiple elicitation techniques such as interviews, focus groups, brainstorming, prototyping, JAD, etc. Gathered requirements for One Number (IVRS system for SNAP) project and documented it.
• Worked with Business Analysis team to prepare a detailed Business Requirement document (BRD), Functional Requirement Document (FRD). Created mock-ups, low fidelity and high-fidelity wireframes. Experienced in developing User Stories throughout teh Agile Lifecycle as well as created UML diagrams such as Use Case, Activity, ER diagrams with MS Visio.
• Developed teh Requirement Traceability Matrix (RTM) for future references and tracking teh progress.
• Maintained defects by prioritizing them against teh backlog items and tracked them till completion using Rally.
• Performed functional unit testing of teh web services and OCR functionality. Trained teh Machine Learning System for teh new layouts and keywords.
• Designed and implemented SQL queries and stored procedures. Used functions like joins, unions, outer joins, group by, order by and aggregate functions to extract data for timely reporting and validation.
• Extensively involved in mapping data from various sources to teh target database tables.
• Worked on API documentation using Swagger tool. Analyzed domain specific API’s while conducting teh Interface analysis, to interpret teh data formats for a thorough understanding of business requirements and supported integration of compliance REST API’s with Business Rules Engine.
• Performed API testing using Postman and SoapUI to check if teh API’s are returning teh correct data elements as defined in teh API documentation using Swagger tool and required by workflow.
• Worked with Development, QA, and Production Support teams to communicate, verify, and test teh desired functionality changes. Helped teh Testing team in creating Test Plans, Test Scenarios, Test Cases and collected Test Data for successful completion of Integration Testing and Functional Testing.
• Performed Manual testing, Integration testing, System testing, User Acceptance Testing with UAT cases and resolved issues with teh users.
• Created various charts, graphs, reports for business analysis using Tableau Business Intelligence tool

Environment: Agile/Scrum, Service Oriented Architecture (SOA), MS Visio, Rally, Tableau, Confluence, Swagger, Informatica, UML.

Confidential, New Brunswick, NJ

Sr. Business Systems Analyst

Responsibilities:

• Created business and technical requirements, functional specifications, gathered and translate functional requirements into technical requirements using Scrum methodology.
• Worked on 5010 Transactions (837I, P, D, 835, 834,820,270/271, 276/277). Interacted with Claims including COB, Payments and Enrollment and analyzed related business processes to ensure compliance.
• Worked on claims process flow which includes receiving, eligibility and benefit level determination, apply pricing claim edits, apply proprietary claim edits, complete adjudication, generate EOB and send payment.
• Good noledge of claim elements such as ICD, Procedure codes (CPT), HCPC’s, Diagnosis codes, Taxonomy codes and also categories of claims such as Professional claims or Medical claims and Institutional or hospital claims. Good understanding of teh data elements of EDI file. Ensured compliance of Teh Medicare Access and CHIP Reauthorization Act (MACRA) with MIPS and APM for provider payments through QPP.
• Co-ordinated with onshore and offshore development teams for functional requirements specifications in form of use cases, process flows, and prototypes and management reporting requirements using multiple elicitation techniques such as interviews, focus groups, brainstorming, prototyping, JAD, etc.
• Worked with Business Analysis team to prepare a detailed Business Requirement document (BRD), Functional Requirement Document (FRD) and System Requirement Document (SRS). Created mock-ups, low fidelity and high-fidelity wireframes using Balsamiq tool. Experienced in developing User Stories throughout teh Agile Lifecycle as well as created UML diagrams such as Use Case, Activity, ER diagrams with MS Visio.
• Developed teh Requirement Traceability Matrix (RTM) for future references and tracking teh progress.
• Maintained defects by prioritizing them against teh backlog items and tracked them till completion using JIRA.
• Implemented customized CRM tool using salesforce to capture teh calls and chats of teh customers for analysis. Imported data from excel sheets in to Leads, Accounts, Contacts and Opportunities objects using Data Loader and Import Wizard. Designed various types Email templates for auto response to customers.
• Facilitated meetings with Salesforce developers in presence of Sales and Marketing team to discuss about teh data dat needs to be ingested into Sales cloud and Marketing cloud.
• Worked with Development, QA, and Production Support teams to communicate, verify, and test teh desired functionality changes. Helped teh Testing team in creating Test Plans, Test Scenarios, Test Cases and collected Test Data for successful completion of Integration Testing and Functional Testing.
• Performed Manual testing using, Integration testing, System testing, User Acceptance Testing with UAT cases and resolved issues with teh users.

Environment: Agile/Scrum, Service Oriented Architecture (SOA), MS Visio, JIRA, Tableau, Swagger, Salesforce CRM, Informatica, UML, and UAT Testing.

Confidential

Business Systems Analyst

Responsibilities:

• Established a Waterfall-Scrum hybrid analysis and development methodology. Conducted user interviews, gathering requirements, analyzing teh requirements using Requisite pro.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content. Responsible for indexing of teh tables in teh data warehouse.
• Wrote multiple SQL queries using functions such as joins, aggregate, order by, union, group by, like, triggers. Created stored procedure for frequently used queries.
• Data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data within teh database.
• Tested teh ETL Informatica mappings and other ETL Processes (Data Warehouse Testing). Involved in setting up different configuration environment for compatibility testing and manual testing. Prepared Test Plans for each release, wrote Test Cases and executed them as part of Functional Testing. Prepared Test Reports and Deliverables and submitted for version releases.
• Evaluated testing results for each potential release build using HP Quality Center and Bugzilla reports, listing summarized bug information in priority sequence, recommended viability of release for production.
• Developed various reports, graphs, charts, dashboards for business analysis using Tableau.

Environment: Waterfall-Scrum, SharePoint, XML, Rational Requisite Pro, MS Office Suite, MS Project, MS Visio, HTML, MS Windows, HP Quality Center, Bugzilla Tableau.

Confidential

Business Analyst / Risk Investigator

Responsibilities:

• Provided TEMPeffective project management assistance by Developing project plan, tracking project timelines using M.S. Project & preparing weekly project status report.
• Prepared and delivered business/system/functional requirements documents, created requirements traceability matrix using business requirements document, Functional design document and technical design document. Created Use Cases and BRD tan converted them into FRD using Rational Requisite Pro.
• Worked on digital platform and transactions for fraud detections which includes both external frauds and family frauds. Work closely with Partner teams like Lacoste.com, Junglee.com etc.
• Extracted data using complex SQL queries and functions such as joins, triggers, union, aggregate, like, etc. Worked on cleaning teh data and made sure teh data warehouse has teh right information for providing data.
• Created data mapping documents for teh movement of data from production databases to teh warehouse and from teh warehouse to teh policy and also involved in moving data from various sources to target data.
• Configured increment all aggregator transformation functions to improve teh performance of data loading. Worked Database level tuning, SQL Query tuning for teh Data warehouse and OLTP Databases. Assisted teh data architects and developers with transformation rules.
• Managed, assigned and triaged defects from Unit and UAT testing. Reviewed Test Plan and Test Cases/Test Scripts and managed defect tracking and triaging process.
• Generated multiple reports using SQL and in-house reporting tool for analysis and decision making.

Environment: MySQL, JIRA, Excel, Oracle, Informatica, SharePoint, HP ALMCertifications: