Post Job Free

Resume

Sign in

Ms Sql Product Management

Location:
Riverview, FL
Posted:
October 20, 2023

Contact this candidate

Resume:

Function Areas

Operations, Servicing, Originations, Product Management, Intake Management, SNOW DriveFax, Dot Net, SSAS, BI SSRS, DocuSign, IVR, FileNet, Accounts Receivable, Accounts payable, Cashflows, Dealer Track, Maintenance manager, Debt Manager, Correspondence, Fraud, Extn

EDI, X12, Project Estimates, Healthcare system/domains, On Exchange, OFF Exchange, State Based Exchanges, EDI 834, ACA,864,837

Tools

JIRA, Confluence, Win Runner, Load Runner QTP, SQL plus, MS SQL, Oracle, Rational Test Manager, Rational Clear Case, Rational Clear Quest, UNIX, JIRA, Team Tracking, QC/HP ALM, SharePoint, Service Now, AWS Azure Dev Ops.

Software/Operating systems

JIRA, MS Visio, MS Office Suite, Healthcare systems, MS SQL, Micro strategy, Data Mining, MF and web based, Lotus Notes, Visual Basic, Visio 5.0, HTML, Web Logic, WebEnsure, G2E, CSR, Solaris, DOORS, Healthcare Systems, XML SPY, Micro services, Web API’s, GCP/AWS, Swagger, Redis, Kibana, IntelliJ IDEA, Spring Boot, Angular JS, Visual Studio Tool,

Databases

MS Access, Oracle, SQL, ODBC, TOAD, COBOL

Education:

BS in computer science with PGDCA.

Certified SAFe® 6 Product Owner/ Product Manager

Certified SAFe® 6 Leading Safe Agilist

Six Sigma and Lean Canvas Trained

KANBAN and SCRUM- AGILE practitioner

HIPPA CERTIFIED.

Hemalatha Tumuluri

ad0iri@r.postjobfree.com

302-***-****

(References provided on request)

Polished IT professional with successful history of products and product lines of all stages of lifecycles to delivery, mentoring, training teams with over 15 years of experience in various domains, including Lease, Retail, Banking, Healthcare and Finance. Over the last 10 years have adorned roles focusing on delivering and supporting transformations, change management, Risk management, regulatory and compliance. Highly involved in delivering the targeted roadmap related projects by mentoring and training both global and onsite Business Analysts and Technical Writers. Adapting quickly to new roles and responsibilities that are part of product management roadmap for delivery which boasts revenue generation, lean methods by reducing waste and empowering teams and leadership to recognizing tremendous value add to the company on exceptionally large and complex projects. Accomplished strategic way of delivering initial high-level analysis for roadmap initiatives as a vision to define impacts with full dedication to product/project success. Driving towards success through tangible metrics and KPIs for team performance and career development thereby retaining knowledge and talent.

Manager Business Analysis Auto Finance Industry Experience.

Experienced manager with a strong background in business analysis and the auto finance industry

Proven record in leading agile transformations in large-scale organizations, specifically within change management

Deep understanding of the auto finance market landscape, including industry trends, regulations, and customer needs

Skilled in identifying business opportunities, driving process improvements, and delivering strategic solutions to enhance operational efficiency and productivity.

Strong leadership and team-building abilities, with the capacity to inspire, empower and motivate cross-functional teams to achieve project goals and meet deadlines in fast paced environments.

Proficient in agile methodologies and frameworks, including SAFe, Scrum and Kanban, with a focus on Lean, iterative delivery and continuous improvement.

Excellent communication and stakeholder management skills, capable of effectively collaborating with stakeholders at all levels of the organization to ensure alignment and successful project outcomes.

Demonstrated ability in data analysis and modeling, utilizing tools and techniques to extract insights and inform decision-making processes.

Purposeful mindset, with a drive for achieving tangible outcomes and delivering high-quality solutions on time and within budget.

Initiative-taking and adaptive approach to change management, with a keen eye for identifying risks and implementing mitigation strategies to ensure project success.

health industry and MMIS / FFM experience.

Over 13 + Years of experience in the Field of Product Management, Managing, Business Analysis, Technical Writing and QA

Conduct project and product deep dive, JAD sessions to gather stakeholder requirements for large to complex system changes and issues.

Communicate effectively on requirements management plan including organizational standard stakeholder, Functional and Nonfunctional requirements, user stories and use cases along with the system process flows which support all product lines in cross functional large teams to support delivery of finalized successful product/projects for clients.

As an Intake manager always collaborate with both internal and external cross functional teams in defining the impacts on multiple product lines

Worked extensively for maintaining SharePoint – worked on document repositories, mapping documents and companion guide gap analysis performed.

Have worked on ACA (Affordable Care ACT) project since inception of healthcare.gov.

Created Mapping document for converting of EDI into XML and XML into standard XML format.

Experience using web services tools such as SOAP UI, AWS/GCP and Micro Services for datacenter enhancements and collaboration for effective delivery.

Heavily Involved in 820, 834, Medicaid, SEP, CIC Agent/Eligibility support, TA1, 999, mapping of input vs output data content as a SME

Strong analytical, communication, time management skills in handling multiple projects in both Healthcare and Financial domains

Senior Business System Analyst/ Lead Project Business System Analyst

Responsible in maximizing the value of the product resulting from work of development teams in grooming and refining the Product Backlog

Managing the Product Backlog by expressing and defining items priorities.

Ensuring the backlog is well defined, visible, transparent, and clear on the scrum teams to deliver.

Analyzing business requirements at distinct stages of software development life cycle (SDLC)

Collaborate and work closely with the development teams to adhere to the set of requirements delivered for each sprint.

Clear understanding of the business processes of a section or whole organization to implement knowledge in required manner.

Created Basic and alternative flow for each functionality during requirement gathering phase.

Project Plans and Timelines – Work with end-users to determine scope, identify tasks and dependencies, provide estimates, and evaluate resource needs and availability; revise project plans to reflect progress and changes in scope and priorities.

Heavily involved in research before Project initiation.

Perform Gap analysis to know the AS-IS and TO-BE processes for stories accomplished.

Manager Business system Analysts/ Intake process Experience

Experienced in analyzing business requirements at various stages of software development life cycle (SDLC) models such as Agile, Scrum, Waterfall, and RUP.

Managed over a team of between 5 to 20 resources.

Monitor overall team progress and address issues / blockers.

Conducted Joint Application Development (JAD) sessions and interviewed Subject Matter Experts (SMEs) and meeting with clients, teams and other stakeholders for proper requirements gathering.

Drafting with ease user stories and acceptance criteria for product and project within JIRA (both Next Gen and Classic software used within the organization

Worked on Quality Center ALM, JIRA defect Tracking and Created reports / Test / UAT Metrics using ALM / And manual methods.

Analyzed existing business processes and identified areas for process improvement.

Gathered and Created Workflows, E2E Mapping, E2E Use cases, Test cases.

Clear understanding of the business processes of a section or whole organization to implement knowledge in required manner.

Created Basic and alternative flow for each functionality during requirement gathering phase.

Project Plans and Timelines – Work with end-users to determine scope, identify tasks and dependencies, provide estimates, and evaluate resource needs and availability; revise project plans to reflect progress and changes in scope and priorities.

Heavily involved in research before Project initiation.

Documented and Analyzed Business Requirements Document (BRD), System requirement specification (SRS), System Design Specification (SDS) and functional specifications.

Development of UAT, planning Test scenarios to meet the product’s business requirements, and Proficient in both Manual and Automated Testing Techniques.

Involved in developing and maintaining Requirement Traceability Matrix and Gap Analysis

Direct experience for modeling Use Case Diagrams, Activity Diagram, Process Flow Chart and Collaboration Diagram.

Developed, proposed, and documented new process to streamline recruiting processes.

Function as liaison between the Business and entire Project team

Organize & prioritize requirements, Provide productive expertise.

PROJECTS

Client: Santander Consumer USA

December 2021 – Current

Industry: Retail, Lease, Banking, Servicing Consumer

Location: Tampa, FL

Position: Manager Business Analysis

Responsibilities:

Overseeing and managing a team of thirteen business analysts, providing guidance, mentoring, training and support to ensure successful implementation of the Agile framework.

Developing on creating a consolidated roadmap for Program Increment planning quarterly and to align the BOW associated deliverables.

Collaborating with key stakeholders, such as senior management, product managers, product owners, and development teams, to define features, objectives, and deliverables within the scope of the leasing and retail servicing consumer domain.

Developing and maintaining a comprehensive understanding of leasing and retail consumer industry trends, regulations, and best practices to inform strategic decision-making and identify potential business opportunities.

Leading the analysis and documentation of business requirements, features, user stories, and acceptance criteria, ensuring clear and concise communication between the business and development teams.

Conducting thorough analysis of business processes, systems, and workflows to identify areas for improvement, streamline operations, and drive efficiencies.

Facilitating PI Planning, sprint planning, stand-up meetings, retrospectives, and other Agile ceremonies to ensure timely delivery of high-quality solutions aligned with business priorities.

Tracking and reporting on project/feature progress, risks, and issues, utilizing Agile project management tools and techniques.

Fostering a collaborative and innovative team culture, promoting knowledge sharing, and encouraging continuous professional growth among team members.

Providing regular performance feedback, conducting performance appraisals, and identifying training and development needs to cultivate a high-performing team.

Ensuring compliance with organizational policies, standards, and regulatory requirements throughout the project lifecycle.

Building strong relationships to collaborate with cross functional teams, external stakeholders, including vendors and partners, to facilitate successful project delivery and support ongoing business relationships.

Participate in defining strategic roadmap for IVR and payment related services like ACH, aligned with organization’s digital strategy and customer demands.

Conduct market research and competitive analysis to identify opportunities for innovation and differentiation.

Involved in prioritizing feature development based on business value, customer feedback, and strategic demand.

Define KPI’s and feature delivery metrics for BA’s success based on end-to-end product development lifecycle, timely delivery and alignment with business goals and objectives to track performance and empower the team towards success.

Gain deep understanding of customer needs and use feedback from internal and external partners to drive delivering standards.

Foster strong relationships with internal stakeholders for alignment and support to help expand knowledge base by preparing job aids.

Environment: JIRA Cloud, Confluence, Micro Services, DevOps, Mongo DB, Web API, GCP/AWS, UML, HP Quality Center, MS Visio, MS Outlook, MS Teams, MS Excel, DB2 Mainframe, Oracle, MS PowerPoint, Pay Near Me, Tokenization, Kafka, DocuSign, Drive Fax, FileNet, XML, Dot Net.

Client: Centene Corporation

January 2021 – December 2021

Industry: Health Insurance, Go TO Exchange, FFM / ACA /OFF Exchange/Private Exchanges

Location: Tampa, FL

Position: Senior Business Systems Analyst/ Project lead Business System Analyst

Responsibilities:

Collaborate with Business Team to understand, maintain and prioritize the product backlog.

Manage product backlog to best achieve goals and mission from design workflow, draft spikes, and enablers so the development team works on delivering real-time enrollment processing.

Ensure the product Backlog is visible, transparent, and clear for the scrum teams to work on upcoming sprints and that the development team understands to the level needed.

Decreasing the time to reach determination for an enrollment request, helping the organization better meet the mandated SLA’s and KPI’s that are visible to user for reporting purposes.

Reduce overall operational complexity by providing the automated data validation to all input and processing points which in turn decrease the opportunity for error due to human intervention.

Meet with development team on daily scrum to inspect progress towards Sprint Goal and to collaborate what needs to do and adapt the constantly evolving Backlog as needed.

Provide vast knowledge and expertise in the healthcare business to support future membership growth and robust scalability.

Integrate and provide information across multiple enrollment sources that result in greater operational efficiencies and increase the member data accuracy.

Contributing to an overall positive member experience which is a key for success throughout the organization.

Decomposition of large Epics to workable items and user stories for team to develop and Test.

Ensure requirements captured from the business to be appropriate with thorough data analysis, GAP analysis and current system behavior by reducing bugs and defects.

Ownership of backlog grooming of user stories and Acceptance criteria for the development team delivered within 2-week sprints with least to no defects.

Participate in BSA planning and grooming sessions to provide valuable inputs from system behavior and design and to timely deliver assignments.

Drive innovation proactively to identify and implement innovative ideas in design/ technologies which are to improve customer experience and/or create differentiation.

Create and delivered automated solutions driving relevant insights with partnership of multiple business leads and architects.

Engaged with stakeholders for input and feedback on understanding business deliverables.

Point of reference within team retrospectives to provide valuable and honest feedback on what went well and what!

to improve for upcoming sprints.

Participated in detailed sprint planning sessions along with senior leadership, Development managers, Development teams and system architects to provide clear understanding of the user stories/enablers/Spikes delivered.

Defined structure to help retrospective to be extremely productive and beneficial to the team.

Understanding team concerns and design collaboration within multiple teams to avoid last minute delivery changes to the sprint deliverables and specific goals.

Work closely with UX designers, front end and backend development team for story grooming and detailing of the design.

Ensure the contracts received in a timely manner from cross functional teams that impact delivery of the sprint designated stories on potential API’s/ swaggers/payloads.

Complete mapping documents and data models changes including reference data updates and additions in advance to avoid delays for development.

Collaborate with UX designer to create innovative workbaskets for users to work and assign system tasks in timely manner.

Ensure the configurations, rules, validations worked in accordance with cross functional teams and Shared services so there are no downstream impacts.

Assist with any requirements gaps, break fixes, issues during post deployment periods and bugs opened by both UAT testers and Business users.

Environment: JIRA, Confluence, Micro Services, DevOps, Mongo DB, Web API, GCP/AWS, UML, HP Quality Center, MS Visio, MS Outlook, MS Excel, DB2 Mainframe, Oracle, MS PowerPoint, Pay safe, Tokenization, Kafka, Azure Dev Ops

Client: Health Plan Services, WIPRO limited

May 2016 – January 2021

Industry: Health Insurance, Go TO Exchange, FFM / ACA TPA

Location: Tampa, FL

Position: Business Analysis and Intake Manager

Responsibilities:

Recognizing the efforts at the company level have promoted to take the Intake manager role being a liaison between the external clientele and Internal Leadership and received applauds for ease in handling executive correspondence for all intake requests.

Promoted to multiple roles part of IT leadership as a Business Analyst to be a Manager of the team of twenty analysts both onsite and offshore on Obama care Healthcare.gov related large to complex projects.

Worked on Agile with Scrum methodology throughout the projects drafting user stories and acceptance criteria.

Develop strong relationships with business and technical stakeholders.

Ensure alignment around scope and project objectives to ensure project ideas budgeted properly.

Reporting consistently of intake statistics internal and external stakeholders

Earned valuable trust of leadership within the organization and served as an Internal and External evangelist for product offering and collaborating with key client partners.

Ability to mobilize and motivate matrix teams towards a common vision and common set of objectives.

Provide management support for an assigned group of project ideas and help facilitate prioritization for company and departmental resources.

Provide guidance to the governance process for intake deliverables and updates to steering committees.

Facilitate resolution of issues, risks, and roadblocks for intake assessment

Anticipate and diagnose issues, evaluate, and develop alternative courses of action and recommend and/or implement creative and effective solutions to ensure timely resolutions.

Managing multiple initiatives simultaneously as an acting Product Manager and product owner, guiding a team that charged with a product line contribution as a business unit. This extends from increasing the profitability of existing products to developing new products for the company. Build products from existing ideas and help to develop innovative ideas based on industry experience and contact with customers and prospects.

Possess a unique blend of business and technical savvy; a big-picture vision, and the drive to make that vision a reality.

Understand both Market and client problems and find innovative solutions for the broader market.

Collaboratively worked with an engineering counterpart in defining product release requirements and work with marketing communications to define the go-to-market strategy, helping them understand the product positioning, key benefits, and target customer.

Strategic efforts collaborating with cross functional teams that supported in their tactical work.

Managing the entire product line life cycle from strategic planning to tactical activities

Specifying market requirements for current and future products by conducting market research supported by on-going session with customers and non-customers or third party for the clients.

Developing and implementing a company-wide role-based plan, working with all departments to execute, analyzing potential partner relationships for the product.

Acting as a product Owner or SME for the Business Product for multiple products and be responsible for Business

Ownership of the key systems/tools in the enrollment process

Help the BA teams to define requirements and roadmaps for these tools streamlining the enrollment process resulting in improved operational efficiencies, less fallout (error rates) and improved Member satisfaction.

Conduct internal focus groups with users to obtain input and feedback on requirement plan and delivery and understand the development and testing team’s pain points.

Establish structured communication vehicles to gain input from Carriers/AE/AM’s

Partner with IT on system design efforts and maintain knowledge of best practices within the industry as well as regulatory updates.

Ensure roadmaps aligned with MIE framework and strategy.

Prioritize requirements & work with governance to establish roadmaps and deployment dates.

Partner with IT to manage product within budget and required timelines.

Work with training to develop materials/programs for roll-out of MIE functionality.

Assist and support with Companion Gap analysis for BA team and QA for test scenarios.

Manage acceptance criteria for requirements and user stories to deliver and results for change control and operational readiness.

Manage business operations and training readiness, stakeholder, and deployment activities for implementations.

Measure and monitor success against assumed goals and ROI targets during post deployment for each project and resource within the BA team.

Conduct direct feedback sessions on site to include side-by-sides, site calls, remote monitoring during warranty and post deployment periods.

Assist with any requirements gaps, break fixes, issues during post deployment periods.

Establish leadership cadence and structure with AEs on client communication.

Environment: Service Now, JIRA, Micro Services, Web API, GCP/AWS, UML, HP Quality Center, MS Visio, MS Outlook, MS Excel, SOAP UI, DB2 Mainframe, UNIX, SQL Wizard, ODBC, Datalink, MS PowerPoint, Pay safe, Tokenization

Client: H Centives

March 2012 – May 2016

Industry: Health Insurance, Go to Exchange, FFM / ACA

Location: Columbia, MD

Position: Sr. Business Analyst / Business System Analyst

Responsibilities:

Working as a Business Analyst on Obama care Healthcare.gov related projects such as SEP / NON-SEP / 1095

Work on Agile with Scrum methodology throughout the project.

Conducting testing team assigned on PROD issues and daily release notes.

Monitor Test evidence file, attend defect status calls.

Managed overall Project Budget, Resource Allocation

Managing and directing Project staff to achieve deliverables.

Accountable for the quality of test services during entire QA Phases.

Monitor overall Teams performance and provide instructions/HELP to improve and follow the correct Procedures.

Lead a team of 20+ resources, including mentoring, managing workload priorities, measuring staff performance, and promoting professional development.

Created detailed functional specification for processing X12 EDI transactions such as 820, 834, 835, Claim Processing, and Cobra Transactions.

Created mapping document to highlight the updated process and code validation for ICD 10 codes.

Also worked on 820 and 834 processes, including syntax and business rules for X12 HIPAA 4010 and 5010 validations for loops, segments, elements, qualifiers, and code sets. Validated Premium Payments, Payment Reconciliations and Discrepancies in Payment Reconciliations, communicated the gaps with stakeholders.

Created Technical Specification document for outlining the field mapping across multiple applications. Highlighted the data archival process during ETL.

Wrote detailed business validation rules for Data Archival & Data Purging.

Created EDI Export and Import processes and worked with EDI Trading Partners, Payers, or Vendors.

Involved in Defining and Analyzing the Testing Requirements based on application functionality.

Gathered Test Data Requirements for data conditioning from Business Units to Test total application functionality.

Involved in User Acceptance Testing (UAT) with application users and answered the Quality Assurance questions to UAT.

Executed Test cases before and after bug fixes for each build for QAT & UAT.

Interacted with developers regarding priority of bugs and updated the status Test execution result and of bugs once fixed.

Configured RQM with project to upload all Test cases to RQM from Excel.

Performed Enterprise Application Logging (EAL) testing to ensure correct data stored by running daily batches manually.

Lead four people team during Data Conversion part of the project.

Managed change requests, defects, enhancements, issues, and documentation changes using Clear Quest (CQ)

Responsible analyzing system requirements and developing Test cases in Quality Center for the project based on SDLC.

Designed, wrote, and executed repeatable Test cases/scripts using Quality Center

Conduct root cause analysis of identified defects, providing development/business partners with sufficient detail to understand, replicate and resolve.

Environment: UML, HP Quality Center, MS Visio, MS Outlook, SOAP UI, DB2 Mainframe, UNIX, SQL Wizard, ODBC, Solaris (OS), QTP, Rational Req Pro. Jira, FACET, TIBCO

Client: Blue Cross Blue Shield Jan 2009 – April 2012

Industry: Health Insurance

Location: Washington DC

Position: Business Analyst/Sr. System Analyst

Responsibilities:

Worked on Agile methodology.

Heavily involved in scope management and change management.

Created and updated requirements in Quality Center and link requirements to Test scenarios.

Worked/Define solutions for a healthcare overall flow of the application.

Created BRD and FSB documents during initiation and change request phase.

Managed change request and priorities the same after discussion with the business and Dev Team.

Backlog requirements and worked on user stories with development team to explain workflow + clarify requirements.

Worked on multiple projects where roles assigned as a BA and roles assigned as a QA.

Created High level stories scenarios for UI to identify and validate business overall and detail functionality requirements.

Processed X12 EDI transactions such as 820, 834, 837 Claim Processing, Cobra Transactions

Work with business partners and other groups to lead Quality strategies for projects and platforms.

During UAT/PROD monitor defects and to make sure they are Re-validated and assigned to the correct resources.

Created Production checkout list to make sure project go LIVE with close to zero defects.

Coordinated testing commencement, execution, and delivery of quality product with release management and development teams.

Conduct UAT Testing during UAT phase and support client after Production checkouts.

Created Business Rules for multiple carriers and implement the same in Business Rule Engine

Installed Quality Center ALM, Design overall folder hierarchy structure, designed and created/customized all modules as per Company requirements.

Designed and Created Quality Center reports and helped resources to understand QC by scheduling weekly sessions.

Created and Maintained Test Matrix and Requirement Traceability Matrix.

Coordinate meetings with Project Managers to understand projects schedules to set QA priorities.

Communicate project status, issues, and project plan to management and the project team.

Involved heavily in creating and running UAT test cases and test scripts. Also, MS-Access database and generated reports for UAT test cases. Write and execute complex SQL queries to validate successful data migration and transformation.

Identify and log defects if/when a test fails, if necessary, using SQL to narrow down the root cause of the problem for efficient investigation by the development team

Provide feedback regarding requirements documentation for incomplete/un-testable requirements.

Involved and support the QA team in fixing up the open defects in MQC by working with the current business processors and developers.

Environment: XML, Quality Center, Ms. SharePoint, UNIX, SQL, Web gateway tool, ODBC, ETL, Web services.

Client: Aetna Aug 07 –Jan 09

Industry: Health Insurance

Location: Bloomfield - CT

Position: QA Analyst / SME

Responsibilities:

As a QA Analyst / SME worked with other QA in Unit Testing tasks, Trading Partners for connectivity issues; liaison between customers and corporate staff or between IT and Business Units as well as performing system matrix testing.

Performed impact analysis. Work with trading partners, clients, management, technical and non-technical personnel to create use cases and system validation artifacts and testing documentation and performed medical coding testing.

Collaborated with providers and Medicare or Medicaid entities to validate EDI transaction sets or Internet portals. This includes HIPAA 4010; 837, 835, 270/271, and others. Provided healthcare provider problem resolution.

Have experience designing and writing training manual templates, design formatting, project planning and writing technical documents.

Created technical documentation, Reviews, analyzes, and evaluated business systems for end user needs, including Companion Guides, business process reengineering, including GAP analysis and documenting requirements, documenting processes, workflows.

Created test plans and test procedure templates and guidelines used by the QA team.

Also worked on 837 and 835 projects, including syntax and business rules for X12 HIPAA 4010 and 5010 validations for loops, segments, elements, qualifiers, and code sets. Create export and XML processes for Lotus Notes

Involved in Backend Database manual testing in Oracle using SQL.

Developed SQL



Contact this candidate