Tableau
Rajan Adhikari
San Antonio,TX
Summary
Accomplished Manager with 11 plus years of progressive experience within Information Systems Management, Data quality and Reporting Domains Over 7 years of experience working with data management and analytical platforms within the pharmaceutical and health care industry. Thrives in competitive markets with unsurpassed drive, passion and commitment to exceeding expectations in customer satisfaction, revenue and cost controls. Innovative and goal-oriented Management professional committed to Data Analytics.
Overview
11
11
years of professional experience
6
6
years of post-secondary education
3
3
Languages
Work History
Manager
Astellas Pharma
Northbrook, IL
04.2022 - Current
- Leading cross-functional workstream to support business needs or resolution of complex problems under direct supervision of project lead, as assigned
- Managing and triaging requests for new reports/visualizations and change requests, as assigned, and execute any testing plans needed for system/tool improvement and/or implementation
- Collaborating and negotiating with stakeholders, including project teams, functions, and governance, to ensure implementation and use of streamlined "suite" of reports for decision-making.
Associate Manager
Astellas Pharma
Northbrook, IL
05.2020 - 03.2022
- Led POC efforts in association with ZS Associates for CRQA team on Site Audit Natural Language Processing (NLP)
- Participated in design, implementation, and maintenance of key performance indicators across organization, delivering regular reports according to schedule
- Managed day-to-day reporting needs, implement decisions made and participate in discussions
- Created conceptual prototypes and mock-ups of reports and analytics prior to implementation based on business needs
- Created and reported on performance reporting through relevant metrics in line with industry standards/best practices and Astellas objectives, as assigned
- Generated unique reports for stakeholders as needed
- Collaborating and negotiating with stakeholders, including project teams, functions, and governance, to ensure implementation and use of streamlined "suite" of reports for decision-making.
Lead BI Data Quality Analyst (Contractor)
Astellas Pharma
Northbrook, IL
12.2018 - 05.2020
- Successfully implemented ARE3.0 project, responsible for data quality testing of integration of new and deprecation of old data sources
- Responsible to coordinate, monitor and ensure data integrity in data warehoused and BI reports
- Reviewed, tracked, and resolved identified data quality exceptions within source systems within defined time frame to ensured consistent review and resolution
- Provided analytical and quality control support to data management and reporting teams
- Led and developed multiple analytical QC tools in MS Excel and Qlik platforms
- Served as SME for multiple data quality improvement and automation projects
- Trained and supervised new QA resources on quality standards, SOPs, and business rules
- Developed QlikView test objects, Ad-hoc analyses, SQL queries to ensure data accuracy in reporting platforms
- Performed data profiling and data validation on the Master Data Management process.
Lead QA Tester (Contractor)
Blue Cross Blue Shields Association
Chicago, IL
06.2018 - 11.2018
- Led the 4 resources and ensuring all the acceptance criteria were meet for defined User Stories
- Created Test Strategy and Test Plan for the delivery of the quality build on time
- Coordinated with SA and the Development team (Dev) for the new changes applied
- Participated in the deployment guide (DG) review to understand the overall impact of the changes in the build
- Prioritized the tasks as per the business requirement
- Coordinated with the delivery manager for the overall status of the testing
Sr. Quality Assurance Tester (Contractor)
Astellas Pharmaceuticals
Northbrook, IL
05.2016 - 05.2018
- Developed test plans and test strategies based on URS and FRS
- Developed and executed test scripts, traceability matrix, and anomaly forms
- Closely worked with compliance team and project management teams to deliver necessary testing documentation as per the SDLC processes
- Assisted Project Managers on QA resource planning and Test planning
- Performed back-end ETL testing and data comparison tests utilizing complex SQL queries
- Maintained a log of defect issues to analyze root causes and suggested potential solutions
- Closely worked with cross-functional teams, project management teams and analytical teams for successful and timely delivery of projects and SDLC milestones
Sr. QA Analyst (Contractor)
Wells Fargo
San Antonio, TX
07.2015 - 01.2016
- Responsible for handling quality assurance and test environment problems and issues in Assets Preservation Management Projects
- Served as a coordinator for all testing activities with offshore and onshore team from India in different projects
- Developed and Executed Selenium automation scripts using Selenium WebDriver, Selenium IDE in Java
- Implemented different automation frameworks like Page Objects Model and TestNG Automation framework in Assets Preservation Management modules
- Conducted daily defect call with co-ordination with IFT team, UAT team, Development and management and prepared meeting minute and communicated to participants
Software QA Tester
Radiant Infotech Pvt. Ltd
02.2010 - 10.2014
- Coordinated with onshore and offshore testing team
- Created and maintained RTM to ensure that all requirements are traceable from top to bottom based on test plan
- Closely went through and worked on all the stages of SDLC cycle and designed and executed Functional, Integration, Regression, System test scripts
Education
Master of Science - Data Science
Elmhurst University
Elmhurst, IL 08.2019 - 07.2021
Bachelor of Science - Data Analytics
Rasmussen University
Romeoville, IL 09.2017 - 01.2019
Bachelor of Science - Microbiology
Tribhuvan University
Kathmandu, Nepal 12.2003 - 05.2006
Skills
Project Management
Machine learning
Data Mining
Analytical and Critical Thinking
Cultural Awareness
Problem-Solving
Predictive modeling
Data Mapping
Automated testing
Python
Database Management
Teamwork and Collaboration
Software
Qlik
PowerBI
Jupyter Notebook
MS SQL Server
Netezza
Amazon Redshift
Oracle12c
Jira
ALM
Python
R
SAS
Java
Dataiku
RapidMiner
Timeline
Manager
Astellas Pharma
04.2022 - Current
Associate Manager
Astellas Pharma
05.2020 - 03.2022
Master of Science - Data Science
Elmhurst University
08.2019 - 07.2021
Lead BI Data Quality Analyst (Contractor)
Astellas Pharma
12.2018 - 05.2020
Lead QA Tester (Contractor)
Blue Cross Blue Shields Association
06.2018 - 11.2018
Bachelor of Science - Data Analytics
Rasmussen University
09.2017 - 01.2019
Sr. Quality Assurance Tester (Contractor)
Astellas Pharmaceuticals
05.2016 - 05.2018
Sr. QA Analyst (Contractor)
Wells Fargo
07.2015 - 01.2016
Software QA Tester
Radiant Infotech Pvt. Ltd
02.2010 - 10.2014
Bachelor of Science - Microbiology
Tribhuvan University
12.2003 - 05.2006