Principal Architect

• Jun 2023 - Present

Enterprise Architect

• Nov 2021 - May 2023

Associate Data Architect

• Oct 2018 - Nov 2021

Senior Associate - Big Data Senior Developer/Lead

• Aug 2015 - Oct 2018

Client – GenentechGenentech utilizes gSonar project/application to integrate Claims (submission, remittance), Sales, Calls, Affiliation, Shipment and Payer data (Plans, Formulary, Policy and Lives) from various sources and provide insights across all Genentech and Competitor products to support Marketing Science, Industry Analytics, Competitive Intelligence and Business Analytics groups. gSonar Vertical 1 – was focused on Claims (submission, remittance), Sales, Calls, Affiliation, Shipment data and project was implemented in 3 Phases. Patient Journey was derived from claims data using complex analytical rules and all sources were integrated on gSonar platform.gSonar Vertical 2 (Payer Analytics) – To further enhance Genentech’s payer analytical capabilities, payer data form DRG and Zitter was integrated in gSonar. Analysis like Payer Mix, Payer Lives, Payer Policy Insights, Payer Market Share, Share Shift Analysis, Product Utilization at Payer Level and Payer Rejection and Enforcement are feasible through BI front end.Technologies: Spark, Python, Sqoop, Hive, Informatica BDM, Oracle, BitBucket, Jira , Informatica Power Center and SMV FrameworkTasks:• Designed architecture and model of Payer Analytics project.• Coordinated with Business for Requirements Clarification or Questions.• Managed project during entire life cycle, from inception to deployment in production and post deployment support. • Implemented complex business rules for payer analytics use cases using PySpark.• Designed coding standards for Development Team.• Recommended and setup Pycharm for PySpark development and configured remote interpreter, remote deployment and bitbucket. • Setup JIRA and defined process for entire team, including Development and QA. Trained Development team on the coding standards and process.Led and guided offshore team to deliver project per plan• Conducted various training session on python, spark and SMV framework for business users. Show less

Associate - Project Lead / Senior ETL Developer

• Apr 2013 - Aug 2015

Client - Bayer HealthcareRole - Project Lead / Senior ETL Developer• Worked as Operations Lead for Neurology and Hematology Business Units and Project lead for change requests for all 4 Business units.• SME & Technical support POC for Client & Offshore team.• Coordinated with Business Users for requirement gathering for Change request & Enhancements.• Reviewed Data Model, Technical Design Documents, Test Cases and DQ dashboards.• Guided team of 9 offshore members.• Answered all Adhoc queries by Clients/Users.• Managed interaction with Client’s third party vendors and Marketing Science and BI Group.• Implemented Adjustment tool in Neurology Business Unit. Show less

Associate - Onsite Lead

• Oct 2010 - Apr 2013

Client - NovartisRole - Onsite Lead• Supported Business intelligence Competency Centre applications (Report Central , Travel & Expenses and Direct Access)• Implemented various projects like new source integration (Audit Remediation project), Database upgrade (Report Central 10g to 11g), Reports and DW migration projects (Commercial Reports migration, UK ETL Migration).• Gathered requirements, estimated for new changes/projects, executed all phases of project cycle, designed the data model, conducted meetings with Onsite & Offshore Managers and Clients on the status of the project and wrote SOW for projects• Trained project and team members (30) for Remedy and Subversion tool Show less

Programmer Analyst

• Oct 2007 - 2010

Client - Novartis Role - Developer • Active involvement in the implementation of new Data warehouse which included all SDLC stages. • Assisted business users in UAT testing and creation of test summary reports • Performed Defect management activities along with project documentation • Responsible for maintaining and operating Ethics and compliance DW. • Managed operational and user enquiries in the Test track Pro. • Prepared of Details Design document and IQ documents. • Developed Informatica mappings and PL/SQL procedures and UNIX scripts as per the requirements • Coordinated with onsite team to formulate the test strategy and test plan. • Prepared and executed unit test cases and system test cases also prepared test summary report. Show less