Hi, I’m Chandrashekhar 👋
IT professional with 8+ years across e‑commerce, ad tech, and retail. I partner with business & engineering across the SDLC to translate complex problems into clear requirements, robust data flows, and measurable outcomes.
📍 New York Metropolitan Area, USA
📞 424-371-3193
✉️ ckoralli27@gmail.com
What I bring
End‑to‑end SDLC coverage: discovery → delivery → UAT → adoption.
Strong data chops: mapping, PL/SQL, ETL validation, KPI instrumentation.
Outcome focus: KPIs, risk/impact analysis, change management.
Tooling: Jira/Confluence, Tableau, Python automation, REST/SOAP.
Experience
Lead Business Analyst – R&D/Regulatory Compliance
Estée Lauder Companies • Nov 2022 – Present
Drove end‑to‑end requirements (functional/non‑functional), prototypes, wireframes, and FRDs across regulatory initiatives.
Introduced Python automation to accelerate data processing for Tableau KPIs (~20× faster) and published mobile‑ready dashboards.
Led data mapping and integrity checks across systems; partnered with devs/DBAs to resolve workflow and mapping defects.
Orchestrated UAT (plans, test cases, RTM); coordinated pre/post‑deploy regression, smoke, and SIT support.
Jira SQL PL/SQL Tableau Python ETL UAT
Business Systems Analyst – C2M/Regulatory
Randstad (Client: Estée Lauder) • Mar 2018 – Nov 2022
Gathered & documented requirements on Veeva platforms; ran data mapping/validation and supported ETL quality gates.
Built BI dashboards and lightweight data pipelines for regulatory reporting and performance tracking.
Facilitated GAP analysis and UX artifacts (wireframes, prototypes) for new features and enhancements.
Veeva SQL ETL BI
Senior Business Systems Analyst
Justdial (Mumbai, India) • Jun 2010 – Dec 2015
Led change‑management to enhance product workflow, contributing to ~33% growth in relevant product development.
Transitioned PPC project across providers/tech; launched across 11 locations, managing cross‑functional delivery.
Built KPIs dashboards, performed impact analysis, and delivered data modeling/migrations with Erwin.
Google Analytics Erwin PPC Change Mgmt
Selected Projects
ELC Materials Science KPIs
Tableau dashboards for regulatory KPIs with Python‑automated data prep (20× throughput). Mobile‑ready rollout to business users.
Python Tableau SQL
View
Regulatory Data Integration
Source‑to‑target mapping and ETL validation across Veeva platforms; created RTM and defect‑tracking workflows in Jira.
Veeva ETL Jira
View
Skills
Core
Business Analysis Requirements Elicitation Process Mapping (AS‑IS/TO‑BE) GxP/Regulatory UAT & RTM Jira/Confluence
Technical
SQL (Oracle/MySQL) PL/SQL ETL/Data Mapping APIs (REST/SOAP) Python (automation) Tableau/BI
Education
Campbellsville University
M.S., Information Technology Management
UCLA
Certificate, Social Media & Web Analytics
Built with HTML • Tailwind (CDN)
© Chandrashekhar Koralli