Home

Shiva - (BSA)/ Quality Assurance Lead (QA)

[email protected]

Location: West Des Moines, Iowa, USA

Relocation:

Visa:

With more than a decade of experience, Shiva is a highly competent client orientated leader with extensive experience providing program delivery, service delivery, data analytics and business intelligence solutions for multi sector global organizations managing small to large scale projects within time and budget. Highly cross functional in the scrum team playing multiple roles by demonstrating strong leadership, willingness to learn, and adapt to changing client needs. Current Location : Iowa, West Des Moines, 50266 EDUCATION: Jawaharlal Nehru Technological University, Hyderabad, India. Jun 2007 Bachelor of Technology in Electrical and Electronics Engineering. Roles: Business Intelligence (BI) Consultant/ Technical Scrum Master (PSM)/ Business SystemsAnalyst (BSA)/ Quality Assurance Lead (QA) Technical SKILLS SAP Business Objects (BO), Tableau, Microsoft Power BI, Oracle Business Intelligence (OBIEE), Qlik View, Crystal Reports, Microsoft Business Intelligence (SSAS, SSRS), Lumira, Jasper Reporting, Xcelsius Dashboard, MS Office Tools, JIRA, Confluence, Control-M, Python, QTest, Bitbucket (Git), GitHub, AWS, HP Quality Center. Databases: PostgreSQL, Oracle,DB2, MSSQL, Teradata, MS Access, MS SharePoint OtherSKILLS Leadership, Strategic Planning Scrum Master, Process Improvement QA testing and SQL Scripting Business Intelligence Reporting Data Analysis/Modelling/Problem solving. Service delivery and program management Lead Business Systems Analyst/Data Analyst Domain Areas: Annuities, Pension Risk Transfer (PRT), Actuarial IT Property & Casualty (P&C) Insurance. Life & Health (L&H) Insurance and Reinsurance Medical Insurance Claims System (MICS) Certifications: Professional Scrum Master (PSM -1) https://www.scrum.org/user/519877 Certified Safe 5 Agile Practitioner SAP Global Certification: SAP Business Objects Analyzing and Visualizing data with Power BI Tableau 2022 Advanced: Master s in data science WORK EXPERIENCE1 TechnicalScrum Master/Lead Business Systems Analyst 2018 May Present Client Name: ATHENE, USA, West Des Moines IOWA/TCS Project: Actuarial IT Expertise in SQL scripting, requirement gathering, data analysis, mappings, and annuities domain knowledge training. Analyze business processes/systems and provide recommendations for improvement by studying business functions, gathering information, and presenting reports to executive team members to support strategic decision-making. Managing a team size of 19 associates. 6 onshore and 13 in offshore. Risk management, problem solving, data analytics, business process improvements, change management, data governance, IT service management and service delivery are keys skills. Collaborate with developers and write/execute user acceptance testing (UAT) scenarios to accurately infuse technological solutions to business-related problems while ensuring alignment with operational systems. Attend project planning meetings to define/document user business requirements and validate test cases against original requirements. Perform Root cause analysis/Impact analysis/Gap analysis. Review the artifacts and release management in INT, QA, Pre-Prod and PROD environments. Process improvements on run books, mapping documentation, JIRA Template, data models, month/Quarter end issue log, workflows, and architecture diagrams in confluence. LedScrum ceremonies like Product Grooming, Sprint Planning and refinement, Retrospective, Sprint Review, and Daily Scrum Meetings and tracked the project through Burn-Down charts using JIRA. Partners with Product Owners, technology,and SME s, business stakeholders, Actuaries to coordinate on comprehensive needs and potential interdependencies to support Supports medium to large scale complex projects. Create requirements and user stories around AWS cloud migration, S3 buckets, file transfers, Lambda, SNS, Athena DB andGitHub/Control -M jobs. Analyzed and createdsource to target mapping docs to extract the data from 15+ third part cedentapplication filesdata and 2Athene internal systems database to centralized Data Mart and worked on getting requirements for actuarial modelling needs like Alfa Inventory Liability (AIL), Account Value Roll Forward (AVRF), Hedging, Experience Studies, Cohort History reports for Deferred and Payout annuity policies. Support day-to-day Business operations and act as primary contact to intake and define new change requests; add new work to the team backlog and work with Product Owner to define priority,functional dependencies, scope, and roadmaps. Worked as end-to-end business system data analyst for the migration of 300Kannuity policies from old legacy system into new application and its impact on downstream users. Collaborate with the business users to understand current processes and document future state processes related to system enhancements. Worked with QA and UAT teams to develop test cases and regression testing to ensure deliverables. Business Intelligence Consultant 2013 Jan 2018 April Client Name: Swiss Re, Kansas Overland Park, USA/TCS Project Corso Information and Integration Reporting, Property and Casualty (P&C) Insurance Project : Swiss Re a global leader in providing technology enabled business solutions and services. In relationship with Swiss Re, Corporate Solutions (CSC) has empowered its business by reporting solutions on POINT-In Policy System, advanced Claims AC Systems and Automated Workflow Design Tool (AWD). It provides insurance coverage on Auto, accidents, Liability, Property damage by Wind, Fire, and Earthquake etc. AWD is an application used by the underwriters to create submissions with quotes to issue a policy to an insured. Once the quote is accepted, a policy will be created in Point-In application with all the business rules that are applied for coverages. Worked at client location in USA from 2013 to 2018 March. Prepare and distribute reports for both internal and external clients to assist management with decision making processes using SAP BI tools. Problem solving, data analytics, business process improvements, change management, data governance, IT service management and service delivery are keys skills. Applied strong problem-solving, communication, and analytical skills to perform SAP BO Universe data modeling by building the Star schema and resolving circular loops, synthetic keys, and ambiguous relationships through editing and transforming SQL scripts. Integrated multiple data structures and sources to support the full Software Development Life Cycle (SDLC) design, development, and implementation including data visualization, business intelligence, and data collection. Impact analysis of Advanced Claims System (AC) to Risk Master (RM) application migration on SAP Business Objects Reporting. SAP business objects 3.1 to 4.1 migration includes Web reports, Universe designer. Converted45+ legacy stored procedures to Universe data model and reporting. SQL Performance improvements from 30 minutes to < 5minutes. Created Corporate Executive Dashboard using Power BI. Converted 500+ legacy reports into 50+ useful operational reports providing centralized reporting solutions with improved data accuracy by >20%. Reduced maintenance cost by 50%. Provided 10+ virtual user trainings. Scheduling reports from the Broadcast Agent Server to only requested users. Automate report distribution using SAP BO Publication services to end users. Analyzed the existing OLTP system and designed and managed OLAP universes based on the Business Requirements. Weekly external meeting with clients and IT Manager to force see any application issues raised during report development, analysis, and testing for data quality. Plan upcoming bundle/release plan to production. Providing effort estimation, Release plan and development status tracker. Business Intelligence Technical Lead: 2011 Jan 2012 Dec Client Name: Swiss Re, Armonk USA Applications: Life and Health (L&H), Business of Future (BOF) Insuranceapplications Project : BoF (Business of Future) is the global Business Application for the Life & Health business within Swiss Re. BoF is split into several business components, Claims, Underwriting, Quote Treaty, and Information Exploitation and has a Framework and common controls component that provides shared services. Leveraged analytical mindset and problem-solving skills to provide tactical support to senior management by conducting research and analysis to develop sustainable solutions to business problems and requirements. Evaluated business processes, and anticipated requirements, unlocked areas for improvement, and assisted with the development/implementation of solutions to improve business operations. Partnered with IT Team for data collection, aggregation, cleaning, and visualizing data on dashboards by utilizing SAP Business Objects. Communicated key insights and plans to cross-functional team members and management. Performed detailed requirements analysis, documented processes, and liaised with key stakeholders to ensure timely and professional delivery of project requirements. Produced and presented reports with Key Performance Indicators (KPIs) to measure future opportunities in product placement and engagement. Consistently demonstrated excellent communication and interpersonal skills with a proven ability to work independently in a fast-paced, high-pressure environment. Documented complex business requirements by discussing the business problem with stakeholders and finalized system /reporting requirements. Instrumental in finalizing the object inventory, gap analysis, migrate objects, data validation, production cut-over, and validation for BW Consolidation Created infrastructure required for optimal extraction, transformation, and loading of data from various sources using SQL queries and ETL tools, supporting data cleansing and root cause analysis. Migration of Desktop Intelligence reports to SAP BOXI 3.1/4.1. Data analysis and Conversion of OLTP Universes to OLAP Universe. Writing Test Plan and test cases to check data before and after migration. Requirement gathering for Webi report developments and change requests. Foresee the Problems/Challenges (as part of Data-mart changes) and suggest solutions (in Reporting) and fix issues for any Pre/Post Go-Live. Implement change requests in Web intelligence and universe after each report migration. Report defects in QualityCenter and follow up with developers until the defects are fixed. Crystal Reports and Xcelsius Dashboard Developer2008 July 2010 Dec Client Name: Prestige Health, Beijing China/TATA Consultancy Services (TCS) Project Medical Insurance Claim System (MICS) Project : The Medical Insurance Claim System (MICS) is an application which is used by Third Party Administrator (TPA) to process Claims. At a high-level, the application allows creating different insurance products into the system, enrolling policy for members, process pre-authorization and claims for those policies. TPA receives claims and enrolment details from health insurance companies. TPA then captures these details into the MICS system. The Claim is then processed, based on the Product specification and the inherent business rules. This application contains modules namely Product Management, Enrolment, Empanelment, Claims Processing, Pre-authorization, Customer Care, Administration and Reports. Business planned to provide reports to insurance companies, which are sent to them based on the Standard Reporting Schedule: monthly, quarterly, annually. Around 40 different report data and dashboard design representation is needed. Reports and Xcelsius dashboard are implemented in both English and Chinese languages. 2 Weeks business trip to Beijing China to intake transition on Xcelsius Dashboard design overview. Successfully completed 40 Reports designs in both English and Chinese languages and as well as got them on time for the releases with change requests. Experience in writing free hand SQLs to develop reports by understanding the data model joins. Involved in all phases of migration from Crystal Enterprise 10 to XI R2. Documented the steps of installing and configuring the crystal report server 2008 (CMC and Info view). Requirement gathering, data analysis, Development, UAT, Test and Production support for modules like claims, Billings and Enrolments. Tested and implemented SMTP email and scheduling feature of Crystal report server 2008 using Central Management Console (CMC) and Info view applications. Xcelsius dashboard development with integration of flash file to MICS Java Web application and enhancements to it. Successfully completed dashboard of Claims and Enrolment modules of Medici application. Developed dashboard using flynet Query as web services to pull data from OLTP system to flash file. Created data model views to show Year to Date (YTD), Quarter to Date (QTD), Month to Date (MTD) and Week to Date (WTD) into visualizations of policy administration and claims data on real time showing premiums, commissions and claim amount. Experience in using Quality center for tracking data quality issues of both reports and application level. Developed views and materialized views using base tables and customized them to use it in the reports. Keywords: cprogramm quality analyst business intelligence sthree database information technology golang business works hewlett packard microsoft