PROFESSIONAL SUMMARY:

• Business Analyst with 8 years’ experience working in retail, e - commerce, banking and Healthcare industries. Extensive experience working with waterfall and agile methodology.
• Expert level skills in MS Office products like MS Word, MS Excel, MS Project, MS Visio, MS PowerPoint, MS Visual Studio and MS SharePoint and other tools including Balsamiq, Postman, SQL, Confluence, Python, HDFS,Tableau, Troubleshooting and Jira.
• Experience in each phase of the Software Development Life Cycle (SDLC); Project Scope, planning and performing Requirements Analysis, Business Requirements, Business Rules, Business / System Process Modeling ( BPM), Process re-engineering(improvements), Design, Development, Data Conversions, QA, Test Planning, PeopleSoft, Test Development, UAT, Project Deployment Planning, User, Documentation,Ms Visio, Production Migration, Post production Support.
• Understanding of Salesforce.com CRM and its development life cycle and prior experience in EMR/HER and Etmf.
• Experience and understanding of health care industry, enrolment, eligibility, claims management process, Medicaid, EDC and Medicare Services.
• Experience in writing and organizing epics, user stories, Requirement Traceability Matrix, sprint backlog and deployments as per business priority.
• Expert level experience creating as-is business process flows and to-be business process flows and conducting GAP analysis.
• Experience in creating RESTFUL Services and consuming Web API,PoweBuilder, Rest API which communicate data using JSON over HTTP protocol.
• UX/UI Interviews and Design experience: Translated technical and UX/UI interview data into high-fidelity and interactive UX prototypes. E.g. Produced UX/UI designs (desktop and mobile) for website and SAAS platform, which were used for developing the website andSaaS platform.
• Data modelling and analysis skills - SQL stored procedures, advanced Excel macros, Devops,VBA.
• Proficient in elicitation techniques like interviewing, brainstorming, focus groups, prototyping, cost/benefit analysis and risk analysis.
• Experience providing post-production support to the end users by writing manuals, organizing post go live calls to document the issues and then mitigate them with the team.
• Proficient in transforming business requirements into functional specifications, focusing on workflow analysis and design, user interface design, process flow modelling, dataflow diagrams and business process reengineering and creating BRD,FSD and SSDused Lucid Chart to generate Business Process Flow charts for easy validation of BRD and FRD .
• Extensive experience in conducting Business/User Acceptance Testing (BAT/UAT) and subsequent Demos for the IT team in Sprint Review/Meetings and maintaining SLA .
• Created Source to TargetData mappingdocuments indicating the source tables, data types, transformations required and business rules to be applied using SSIS.
• Extensive experience in development of a Data Warehouse and in Performing Data Analysis, Data Profiling and Data Mapping from an Operational Data Store to an Enterprise Data Warehouse.
• Administering and configuring Salesforce, created objects, layouts, reports, dashboards, validation rules, workflows, triggers, tasks, templates, loaded and updated data using Data Loader, resolved user problems
• Reviewed and approved the Test Plans, Test Requirements, Test Cases, Test Reports and performed defect management as required by the project. Performed manual testing, recreated scenarios and provided support to developers to fix defects in the system.

SKILLS MATRIX:

SDLC Methodologies: Waterfall, Agile Scrum

Business Skills: Project Management, Business Process Analysis & Design, Requirement Gathering, Use Case Modeling, ETL, BI Reporting, Gap Analysis, Data Mapping, Data Warehouse, Data Lake, Data Modeling and Webservice API Specification.

Language: SQL, HTML, CSS, JavaScript, Java

Database: Oracle, SQL Server, MS Access, MySQL

Requirement Management tools: Office tools MS Suite, Microsoft Share Point, Power BI, JIRA, Python, Tableau, Confluence, TFS, SharePoint

Design Tools: MS Visio, Mock - up Screens, Balsamiq, Lucid Charts

Other Tools: Postman, MS Excel, MS Word, MS PowerPoint, MS Visio, Lucid Charts.

Operating Systems: Windows, IOS & Android

PROFESSIONAL EXPERIENCE:

Sr. Business System Analyst/ Project Manager

Confidential, Paramus, NJ

Responsibilities:

• Defining project requirements by identifying project milestones, phases and elements; forming project team and establish project budget,studying current practices and design modifications to improve systems.
• Participating in activities to support the rollout of the new system(s) and contribute to the establishment of future policies, procedures, and standards.
• Acting as a liaison between the Corporate Finance Clients and Technology department of Prudential Financials.
• Creating cross-tab reports, MS excel based reports with dynamic data content changes, slicers, time-slicers, graphs, integration with SQL Server Environment and other solutions for day-to-day data analysis.
• Involving in Requirements Elicitation and business analysis through PLC of an online portal to provide visibility to corporate customers on their Equity and investment positions, FX, integration with market data and analyzed the traders fixed income business requirements.
• Writing Functional Specifications that included UML Diagrams and Use Case using Rational Rose and preparing Business Documents.
• Creating ad hoc reports using multiple systems including Microsoft Dynamics Reports, Dashboards, Power BI Reports and Dashboards.
• Analyzing metrics reports that were created in IBM Cognos within SQL, UI, Oracle, and Tableau environments.
• Responsible to track, document, capture, manage and communicate the requirements using requirement traceability matrix (RTM) which helps in controlling numerous artifacts produced by teams across the deliverables for a project.
• Managing and keeping track of product backlog, sprint backlog and time estimates using Agile tools like Jira.
• Creating and analyzing complex customer business requirement documents ( BRD), performing requirement analysis. Producing Use Cases, User Stories and detailed documentation for stated requirements.
• Coordinating all phases of mortgage loans from origination to document collection, loan processing & pre-underwriting; pre-qualified/pre-approved loans, evaluated applications & reviewed credit history, financial statements, to determine loan risk.
• Conducting JAD/RAD Sessions/weekly meeting/walkthroughs to monitor the project progress.
• Making presentations to senior management to outline project process and phases whose result will help them to reduce their cost significantly.
• Working with Project managers and creating various project management artifacts like Gantt charts, work breakdown structures and milestones after collecting details regarding efforts from development and business team.

Sr Business SystemAnalyst/ Product Owner

Confidential, North Bergen, NJ

Responsibilities:

• Established and implemented best practice procedures for system maintenance and optimization, configuration development, testing, data integrity and backups.
• Acted as a project lead in using agile methodologies to determine the most economical route to implement complex requirements without compromising the integrity of the system.
• Worked in cross functional project teams that include ETL development, sales operations, Data Quality Assurance and Data visualization.
• Developed Web Services by writing Restful API with responses in JSON and XML.
• Created and continuously improved project management best practices to ensure a nimble and consistent approach in managing and delivering projects. Conducted project reviews to ensure adherence to the project management methodology.
• Designed high-fidelity UX/UI prototypes and converted them into HTML/CSS. E.g. Designed desktop and mobile mock-ups for the Aptos user app and converted the mock-ups into web pages.
• Worked as subject matter expert for data, analytics, and testing within a business unit to ensure accurate and proper interpretation of core business metrics and consumer behavior.
• Developed an ETL for moving/cleaning data from multiple sources to a data warehouse, then to a data lake for reporting using SQL stored procedures and SSIS.
• Analyzed workflow systems to identify opportunities for improvement and developed flowcharts using Lucid Chart.
• Provided application software development services and technical support and supported on-call support and troubleshoot applications as required.
• Documented BPM, process and workflow diagrams, requirement documents, use cases, user stories, mockups, wireframes, flow charts, current state and future state business processes.
• Coordinated responses across the program related to management guidance, data calls, project decisions, business intelligence development KPIs, enterprise reporting IT Portfolio, IT Strategic Planning (using MS Power BI, SharePoint Dashboard, Tableau and MS Excel) and other topics.
• Coordinated with the development team to develop various prototypes for better understanding of the User Experience and User Interface by constructing Wireframes and Mockups with Balsamiq.
• Created and maintained Jira Epic, features, stories and related work tasks, providing and updating as necessary the Acceptance Criteria.
• Involved in all SDLC stages under Agile process in applications like user stories analysis, implementation, testing, deployment and maintenance.
• Maintained and updated existing suite of reporting of all API calls and overnight ETL data warehouse transfer.
• Elicited, critically evaluated, documented, and identified missing business requirements.

Technical System Analyst

Confidential, Eagan, MN

Responsibilities:

• Developed ad-hoc reports to conduct data analysis and validation.
• Developed functional and visual prototypes with operations management to define requirements.
• Created data mapping documents for integration between blue cross billing data warehouse and database documenting the source and target attributes and other translation rules like data merging, data cleaning, data conversion etc.
• Recommended technical alternative solutions to management as a course of action that best meets the organization's goals.
• Worked with the Claims staff to document the "as is" claims process and make recommendations for the "future" process which included the new HiPAA guidelines and HL7.
• Worked closely with business leadership to respond to, and proactively identify, challenges that can be solved with system and/or process improvements.
• Provided production support along with problem management and working to make sure that defects and issues in the System would be resolved into ensuring that system issues would not affect claims processing and financial operations.
• Maintained the Requirement Traceability Matrix RTM to ensure completeness.
• Led UX/UI and interaction design, defined UX/UI and user flows creating A&G and claims user interface for A&G investigators and other business users.
• Assisted in design of logical/physical data models (relationship, cardinality, attributes and candidate keys) as per business requirements using Erwin Data Modeler and ER Studio.
• Worked with Project managers and created various project management artifacts like Gantt charts, work breakdown structures and milestones after collecting details regarding efforts from development and business team.
• Responsible for the SQL Querying and Table Uploads to the department Databases. And support for other groups within our department.
• Successfully completed all JIRA tasks aligned with projects that Increased adoption of Microsoft Power BI enterprise wide, rebuilding Excel, Teradata, Oracle (BO) reports in Power Bi to decrease the load on the company's server (EDW).
• Designed, developed and tested system business intelligence solution components.
• Acting as SME mentored business users in business intelligence reporting navigation, interactions and usage.
• Conducted interviews, meetings and JAD sessions during the process to capture business processes, rules, and system requirements.
• Analyzed the customer insights data through Tableau and drawn conclusions, communicating the results in a clear, conciseand actionable manner.
• Created process flows, process maps and other data lineage and data mapping documentation as required to complete assessments

Business System analyst

Confidential, Boston, MA

Responsibilities:

• Extracted, transferred and loaded information from multi-terabyte data sources including sales, clickstream, product, and customer databases to deliver business insights and recommendations.
• Maintained and improved upon internal KPI reporting hosted both in Tableau and Google Sheets utilizing Python to refresh datasets and perform ETL.
• Increased on-time delivery by working closely with each project manager to implement a more stringent project management methodology to counter scope creep and to better manage change.
• Managed users, Group, role and permission in Jira and Develop custom Dashboard, filters and report in Jira.
• Modified, tested, and validated system configuration. Prepare detailed functional specifications for development activities including workflow, reports, interfaces, conversions, enhancements, and forms.
• Created project documentation to support analysis at various levels. Responsible for understanding the BRD and creating documents such as SRS and Data Flow Diagrams, user stories ( for Agile projects) .
• Performed impact analysis for changing requirements and coordinated with business users and Project Manager for prioritizing the testing/release of the changes through CAB.
• Created prototypes for reports using Balsamiq tool and regularly getting feedback from end-users
• Performed deep-dive analysis, including the application of advanced analytical techniques, to solve some of the more critical and complex business problems including website funnel progression, customer segmentation and targeting, and supply chain optimization.
• Developed data visualizations, including reports, dashboards, and analyses in Tableau to distribute data insights in an easy to understand manner for other working employees.
• Produced and presented various Use Cases, Sequence Diagrams, Flow Charts, and Activity Diagrams.
• Followed AGILE methodology when created self-organizing team, induced enhanced communication for quick issue resolution & minimization of change control processes & its impacts.
• Participated in the development of roadmaps and standard processes for Identity Access Management solutions.

Business System Analyst

Confidential, Tampa, Florida

Responsibilities:

• Configured facets modules such as Claims,, Billing, Benefit and plan
• Analyzed requirements, procedures, and problems to automate processing or to improve existing business systems.
• Conducted Scope Analysis, Stakeholder Analysis, GAP Analysis, Traceability Matrix and used MS Visio and Lucid Charts for Business Process Modeling adopting UML standards.
• Wrote clinical reports to meet the data needs of multiple hospitals and an extensive physician network using SQL and SAP Business Objects.
• Recommend changes for system design, methods, procedures, policies and workflows affecting Medicare/Medicaid claims processing in compliance with government compliant processes like HIPAA/ EDI formats and accredited standards ANSI.
• Lead creation of audit plans, schedules and testing of system upgrade and new configurations.
• Documented and controlled all changes made to productions systems via change control process.
• Created multiuser, real-time, robust database solutions.
• Acted as content expert to provide business and technical expertise in requirements solicitation, system analysis, technical design, programming and documentation of business applications/systems.
• Gathered analyzed and documented business and technical requirements from both formal and informal sessions and validated the needs of the business stakeholders. Conducted user interviews and documented business and functional requirements into the Product Backlog.
• Claim validation and Pend/Denied Claims Analysis for the Health plans Medicaid programs.

Business System Analyst

Confidential

Responsibilities:

• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling (BPM).
• Worked closely with business process owners and users to analyze and document business practices and processes, reviewed designs and implemented user acceptance testing.
• Provided ongoing support for existing RPA deployments; from an exception follow-up, maintenance, and enhancement perspective.
• Involved in gathering the requirement with the SMEs to get the maximum information about the work-stream including Commercial Mortgage Servicing, Loan Monitoring, and Asset Management.
• Managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
• Designed and developed various reports as per business requirements using advanced SQL queries, SQL Reporting Services and Excel.
• Clarified QA team issues and reviewed test plans and test scripts developed by development team and QA team to make sure all requirements have been covered in scripts and tested properly.
• Investigated issues in the production environment (running processes, maintaining resource virtual machines, viewing logs, etc.)
• Expedited process of solving issues that arise in the day to day running of process and assisted in the provisioning of timely solutions as required
• Communicated and escalated software-related issues to the development team, suggesting improvements and potential risks with business.