Strong ETL development with Pharma under Commercial & Sales Ops domain.
Expertise in writing and tuning complex SQL
Expertise in using partitioning, transformations, incremental caching in Informatica toolset.
Expert understanding of slowly changing dimensions (SCD's) in Informatica.
Expert understanding of join logic and query optimization in Informatica
Experience with stored procedures, Triggers, PL/SQL in Oracle.
Expert in writing efficient Analytic and windowing functions in Oracle.
Strong knowledge of processes & data related to Sales, Sales Operations, Marketing, Market Access etc. (e.g. Direct Sales, Self-Dispensing Pharmacy, Competitor Sales, Prescription, Shipment, Distribution Channel, CRM, Incentive Program, Physician Affiliations, Pricing decisions, Payer contracts, Speaker Program, etc.
Lead/participate in the IT development of Business Intelligence solutions to meet the needs of the Commercial Organization (Sales, Sales Operations, Market Access, Marketing)
ETL development with Pharma under Commercial & Sales Ops domain.
NK Technolabs LLC