Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with very strong data analysis skill with communication driven by data and facts.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Business Analyst Specialist
Accenture
10.2019 - Current
Worked with stakeholders and clients to model and document goal communicating transparently to meet 99% of deadlines.
Increased revenue of $10M through analysis of data surrounding workflow of legacy & tactical systems.
Reduced client cost by reducing technical debt and helping client become leaner in terms of business and IT process from architectural point of view to client solutioning based on data and facts.
Determined operational feasibility by defining problem, analyzing requirements, and assessing proposed solutions.
Proficient to streamline client’s operations, automate tasks, and improve processes in their finance, accounting, risk, and operations functions.
Worked on Actuarial & Non-Actuarial analyzing risk regarding universal life insurance, Variable life insurance, claims, death claims, Reinsurance, Scenarios.
Expertise in Data visualization, Data Analysis and unfolding root cause analysis.
Proficient in SAP BODS, Complex SQL Queries, Power BI, Python, SAP HANA, Sybase, Oracle,Unix,ETL Process and Methodology.
Using Python, SQL, and Excel developed File comparison Tool and Format Copybook DDL utilizes ~400 hours of labor each month.
·Responsible for driving Scrum meeting and leading team size of 16 members.
IT Analyst
Tata consultancy services
03.2014 - 10.2019
Worked with leading USA Healthcare clients.
Proficient in dissecting bit by bit business requirement, with great understanding of claim processing.
Claim processing with different status change, responses received.
Worked on CDW data warehouse using Informatica Tool and extracted required and eligible claims as data dump and loading in staging layer applying transformation rule to it as per business requirement and loading into Oracle DB tables.
Responsible for black box and white box testing. Worked on Migration of Data from CDW to staging to ODS layer. Validated correct data flow by usage of minus queries which involved complex transformation rules as per the mapping sheet.
Skills
SQL Proficiency
Technical Writing
Statistical Analysis
Change Management
User Acceptance Testing
Gap Analysis
Team Leadership
Business Process Improvement
SAP
Data Warehousing
Decision Making
Data Analysis
Certification
ISTQB-BCS Certified Tester Foundation Level Certification
SQL Professional Certification
Python Certified
AWS Developer Associate
Azure Fundamentals
SAP BODS
Google Cloud Platform Fundamentals
Automation & Process Improvement
File Comparison Utility-
This python utility compares two set of .csv/.xlsx/.txt delimiter-based column wise and create “FINAL_COMPARISON_REPORT.xlsx” giving the detailed analysis of comparison with aggregated column having differences highlighted with conditional formatting.
FormatCopybook and DDL creation utility -
This python utility is capable of cleaning up the unwanted comment section of Cobol .cpy file turning it into ingestible layout to SAP BODS .
Resource Finder Utility -
This python utility runs on daily frequency on candidate profile and identify new entry in same sheet.
SQL Automation-
Renovating business requirement to SQL queries and transforming it to SQL automation pack which not only helps in current release but even benefit in testing of regression functionality when automation pack consisting of multiple Jira's are run in each release.
Impact analysis on GUI-
GUI testing for feed file creation after complete validation of rule sets. As part of GUI Testing boundary value, blackbox,negative testing, functional, integration and overall software quality test is being performed.