SIDDHANTH REDDY

Business Analyst / Data Analyst

Phone: 469-***-**** E-Mail: ad0aal@r.postjobfree.com

Professional Summary:

7+ years IT experience specializing in comprehensive Business Analysis/Data analysis, ETL Development, Data Modeling, and extensive industry domain knowledge in Healthcare, Retail Pharmacy Insurance, Finance & Banking.

Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.

Highly efficient in Requirement Gathering, Modeling, Designing, Testing, Validation, Workflows, and Data Management.

Extensive experience in Waterfall and Agile (Scrum) methodologies, enterprise environments, architectural and solution design, implementation, and complex customizations.

Good experience in Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.

Worked in all phases of Software Development Life Cycle (SDLC) including UAT Testing, Production and Deployment.

Knowledge of SFDC.

Performed Data Extraction, Data Mining and Data Profiling by using SQL, Python and SQL Server Management Studio (SSMS).

Liaison to several cross-functional teams and in-depth understanding of the AS-IS and TO-BE business processes and experience in converting these requirements into technical specifications for preparing test plans.

Efficient in reformulating strategies through Process Re-engineering, Change Management, Release Management and Process Improvements.

Good UI/UX development skills.

Thorough knowledge in core Java concepts like OOPS, JDBC, JSP, HTML, XML, Angular Sand advanced Java concepts like hibernate and spring.

Involved extensively in designing/developing web based applications using HTML, CSS, JavaScript and XML

Lead planning meetings, eliciting requirements from stakeholders through Joint Application Development (JAD) sessions and Rapid Application Development (RAD) sessions, focus groups, and interviews for developing BRD, FRD, FSD and SOW.

Created Product Backlog, Sprint Backlog, Burndown chart, RFI, RFP and managed User Stories.

Expertise in conducting in-depth Problem Analysis, GAP Analysis, SWOT Analysis, Root Cause Analysis, and Impact Analysis. Assisted in conducting Cost Benefit analysis and ROI analysis.

Implemented data modeling techniques including data visualization, data warehousing and data mapping.

Conducted overall business management and data management by using Microsoft Excel and database tools including SQL, MySQL, and MS Access.

Hands on experience in Front-End technologies like Angular JS, JQuery

Prepared graphical depictions of project processes using Sequence diagrams, activity diagrams, Entity Relationship Diagram (ERD), Use Case diagrams, Wireframes, Mockups, including the business workflow.

Implemented Manual and Automation testing techniques by the creation of Test666 Scenarios, Test Plans, Test Cases, and facilitating Test Inspections.

Detailed knowledge on different modules within healthcare (Membership, billing, Enrollment, Claims, Capitation, Providers).

Good understanding about the Electronic Data Interchange (EDI) standard used in various business processes.

Strong Knowledge and understanding of ICD-9-CM and ICD -10-CM coding and claims processing.

Experience with HIPAA compliance and involved in up-gradation of HIPAA 4010 transaction to HIPAA 5010 in health care with strong understanding of Medicaid and Medicare rules and claim adjudication.

Knowledge in generating Reports, Analytic Snapshots and Dashboards, Enabling Email Services, and constructing Page Layouts.

Excellent interpersonal skills, effective writing, and oral communication skills.

Ability to work both independently and as part of a team to meet objectives. Possess ability to motivate a team towards successful completion of project milestones.

Technical Expertise

Domains

Healthcare, Finance, Retail, Telecom

Requirement Management

HP ALM, Blueprints, Doors, ERP, TFS

Document Creation/Management

MS Office Suite – Word, Excel, Outlook, Publisher, PowerPoint, OneNote,

MS Project, Adobe Acrobat, Lotus Notes

Content Management

MS – SharePoint

Database Management

MS-Access, SQL, MySQL, Oracle, Erwin, Guidewire, Informatica, ETL, STIBO

Business Modeling

Enterprise Architect, Balsamiq, MS-Visio, Rational Rose, Pencil

Business Intelligence

Cognos, Business Objects, Crystal Reports

Testing

Selenium

Bug Tracking/ Quality Control

JIRA, Rally, HP Quality Center

CRM

Salesforce, Pega, Dynamics 365

Languages

UML, HTML, CSS, XML, JavaScript, APEX, Visualforce

Operating Systems

Windows, Mac OS, Unix and Linux

Other Tools

PeopleSoft, PEGA, and Insurity

Methodologies

Agile-Scrum, Waterfall

Work Experience

Client: Cardinal Health, Inc, Dublin, Ohio January 2022 – Till Present

Role: Business Analyst/ Data Analyst

Project: Patient Assistant Services

The Patient Assistant Services project at Cardinal Health, Inc involved the role of a Business Analyst/Systems Analyst. The project aimed to enhance patient support and streamline healthcare processes. As part of the project, the analyst worked on identifying opportunities for improvement, analyzing data and systems, and proposing solutions to enhance patient services. The project aimed to ensure better patient care and facilitate efficient coordination between healthcare providers, patients, and other stakeholders.

Responsibilities:

Gathered, analyzed, and prioritized business requirements and system requirements that must be included while developing the software.

Performed data profiling in the source systems that are required for RML System.

Performed Data Extraction, Data Mining and Data Profiling by using SQL, Python and SQL Server Management Studio (SSMS)

Documented the complete process flow to describe program development, logic, testing, and implementation, application.

integration, coding.

Involved in Data Validation on the SAAS form of data using SOAP UI, SQL Developer and Python to ensure and

perform accurate data mapping.

Created new data constraints and leveraged existing constraints for reuse.

Created data dictionary, Data mapping for ETL and application support, DD, ERD, mapping documents, metadata, DDL and

DML as required.

Work on Data Migration needs and assist in designing, planning, and managing the Data Migration process.

Elicitation techniques used included interviews, surveys, prototyping, and developing mockups of the GUI.

Prepared Logical Data Models that contained set of diagrams, Business Requirement Documents, and supporting documents containing the essential business elements, detailed definitions, and descriptions of the end user requirements.

Conducted JAD sessions with data management team, SMEs, vendors, users and other stakeholders for open and pending issues.

Involved extensively in designing/developing web-based applications using HTML, CSS, JavaScript and XML

Coded HTML pages using CSS for static content generation with JavaScript for validations.

Collected, stored, reviewed, and modified requirements in MS Word.

Authored progress and completion report which were then submitted to project management on a weekly basis.

Formulated and executed business rules for Guidewire Claim Center.

Planned and defined system requirements through Use Case Diagrams, Use Case Scenarios, and Use Case Narrative using the UML (Unified Modeling Language) methodologies.

Created Activity Diagrams, and Sequence Diagrams in MS Visio.

Created State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams thus defining the Data Process Model and Business Process Model.

Worked on creation of wireframes during the Elaboration Phase.

Took part in data migration and data mapping activities to migrate from a legacy-based Java app to a salesforce cloud platform.

Created ER- diagrams, assisted in the ETL process as a part of data warehousing process.

Managed third party applications integrated into the Salesforce Org.

Created test cases and test scripts to check the functionality of application (UAT).

Performed manual front-end testing to check all functionalities of different phases.

Suggested measures and recommendations to improve the current application performance. Designed organizational tools and forms to facilitate accurate data collection and recordkeeping.

Involved in exploratory testing on the website.

Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.

Environment: MS Office, JIRA, SharePoint, Agile-SCRUM, MS-Visio, SQL, Salesforce, informatica, Team Foundation Server, Guidewire Claim Center, AWS

Fifth third Bank February 2020 - December 2021

Dublin, Ohio

Business Analyst/Data Analyst

As a Business/Data Analyst of E-commerce, an online banking application that enables customers to access their checking and savings accounts, and credit card account through the internet. This project involved developing the application using Servlets and JSP's under the Struts framework.

Responsibilities:

Involved in gathering business requirements from the end users and management.

Analyzed Requirements and created Use Cases, Use Case Diagrams, Sequence Diagrams using Rose.

Used Rational RequisitePro for Managing and Configuring the Requirement Analysis effort.

Associating Business Processes with data, job profiles and corporate applications.

Extracted the business requirements for E-commerce from various sessions with business leads and maintained them using

Requisite Pro, tracing them all the way to the system artifacts.

Involved in Capturing and Designing, Executing and Monitoring Business Process Management Activities.

Identified requirements by conducting JAD sessions with SMEs and Business Owners.

Interacted with Business Owners, Delivery Managers, Application Developers, Testers, and other IT staff to ensure successful teamwork and high-quality solutions in the development and delivery of new applications.

Prioritized requirements to be developed according to Agile methodology.

Performed extensive requirement analysis and gap analysis.

Evaluated the information gathered from multiple sources, decomposed high level information into details to gain understanding of end-to-end solution.

Coordinated and facilitated requirements analysis and walk through meetings.

Used sessions, workforce for running and loading the data from source to target data warehouse.

Utilized standard templates to write requirement specifications accurately and concisely.

Produced visual models for the application to create State Chart, Use Cases, Use Case Diagrams, Sequence Diagrams, and Activity Diagrams.

Coordinated business and IT signoff on requirements documentation. Created and maintained project schedule using MS Project showing all the deliverables target dates.

Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.

Worked as primary IT contact for team members developing and executing test plan.

Communicated business risks and project cross-impacts to Project Manager and BSA Manager - Support.

Working on the Business problems cited by the Account management team and provide Data backed recommendations/insights.

Generated Business intelligence reports using crystal reports, which were used to make strategic decisions.

Provided additional adjudication processing assistance to team members with complex reimbursement and client-related questions.

Involved in managing Test Requirement Management and Business Rules Management.

Environment: MS Office Suite – Word, Excel MS project, Microsoft Visio, Microsoft Share Point, Cognos, UML, JAD, GAP, PL/SQL, Agile Scrum, Jira, PEGA, Crystal Reports

Client: First Union National Bank, NJ (Off-shore Project)- Coveo Info Solutions, India July 2014– Jan 2019

Role: Business Analyst

Project: Transfer and Payment Service Up-gradation

Project Description:

The objective was with Union Bank’s Retail Banking transfer service customer can securely send money to friends, family or coworkers using an email address or mobile phone number. Customer can transfer money without using the recipient Bank account number. This service also allows customers to transfer money from Union Bank account to any other bank account.

Responsibilities:

Worked as a Business Analyst for multiple module wise development teams. The project followed a full project life cycle as per the SDLC specifications using MS Project.

Worked along with the team members to create Request for Information and Request for Proposal documents.

Categorized and prioritized requirements from end users and communicated with project manager to design the business requirements.

Created various Data Mapping Repository documents as part of Metadata services (EMR).

Provide inputs to development team in performing extraction, transformation and load for data marts and data warehouses.

Worked with project manager and high-level management team to identify Project Scope, develop work plans and schedules.

Generated functional requirements by collectively gathering requirements from all teams.

Created and maintained Business Requirements document and System Requirements document. In addition, was responsible for getting appropriate signoffs and approvals.

Assisted in GAP analysis and business process reengineering; identified and documented improving area to meet the end state requirements.

Developed BRDs and FSDs and designed Use Cases using Microsoft Visio.

Created wireframes and prototypes.

Worked with QA testing team to design test methods to verify the application's functions of generating consumer loan, home equity, refinance, and performing commercial loan activities.

Reviewed and modeled existing loan processing workflow; identified improved opportunities.

Assisted in UAT.

Environment: MS Office – Word, Excel, Access, and PowerPoint. UML, Axure, Waterfall Methodology, Balsamiq, Team Foundation Server, PeopleSoft

Contact this candidate