Balaji Kolusu
Marketing Data Analyst • New Jersey, USA • k*************@gmail.com • 908****112 • drivetube.ai/•••••
Professional Summary
Business Analyst with 4+ years of experience delivering marketing analytics, BI dashboards, and data-driven product and pricing recommendations for banking and e-commerce. Strong SQL, Python, Power BI/Tableau and cloud ETL experience (AWS, GCP) to build reliable pipelines, predictive models, and executive reporting that improve campaign performance and reduce reporting effort.
Technical Skills
Programming Languages: VBA,Python,R
Databases: MySQL,PostgreSQL,Oracle,Snowflake,MongoDB,SQL
Cloud and DevOps: AWS S3,AWS Glue,AWS Redshift,AWS Lambda,AWS Athena,Google BigQuery,Azure
Data and Analytics: Power BI,Tableau,Excel,Pivot Tables,XLOOKUP,Power Query,Exploratory Data Analysis,Hypothesis Testing,Regression Analysis,A,B Testing,Cohort Analysis,Funnel Analysis,Financial Modeling,Pricing Strategy Modeling,Credit Risk Analysis,PySpark,Apache Hive,ETL,ELT Pipelines,Data Transformation,Data Wrangling,Apache Airflow,dbt,Data Governance,Data Quality,HIPAA,SOX,GDPR,KPI Development,Business Requirements Analysis,Data Storytelling
Tools and Methodologies: SSIS,SAS,Alteryx,JIRA,Confluence,Git,GitHub,Trello
Work Experience
Citigroup
New Jersey, USA
Marketing Data Analyst
Sep 2024 – Present
Worked in banking/financial services supporting retail banking and credit-card marketing analytics, campaign measurement, and product/pricing analysis.
Tech Stack: SQL, Python, Power BI, AWS Glue, AWS Lambda, AWS Redshift, AWS Athena, Apache Airflow, Generative AI
- Analyzed 15+ million transaction and engagement records using SQL and Python to identify high-value customer segments and campaign lift; insights drove targeting changes that increased campaign conversion by 18%.
- Designed and deployed 20+ Power BI dashboards tracking acquisition, retention, CLV, and campaign ROI; standardized reporting reduced report preparation time by 60% and improved executive decision velocity.
- Built customer segmentation and pricing models for retail banking products using statistical analysis and cohort methods in Python and SQL, improving campaign response rates by 22%.
- Prepared, cleansed, and indexed CRM, campaign, and product datasets using AWS Glue and SQL to enforce data quality rules and ensure compliance with internal banking policies for marketing use.
- Automated ETL pipelines to integrate CRM, web analytics and transaction data using AWS Glue, Lambda and Airflow, reducing manual reporting effort by 70% and enabling near-real-time campaign analytics.
- Automated creation of campaign performance reports and executive slide decks using Generative AI templates combined with Power BI exports and Python scripting, accelerating report delivery and cutting manual documentation time.
Deloitte
India / USA
Data Analyst
Aug 2020 – Aug 2023
Worked at a global professional services firm delivering data integration, analytics and dashboarding for retail and e-commerce clients to support pricing, promotions and digital experience workstreams.
Tech Stack: Python, Google BigQuery, Tableau, SQL, VBA, Power Query, A, B Testing, Anomaly Detection
- Integrated multi-channel datasets (e-commerce, POS, mobile app) using Python and BigQuery to create unified customer and transaction views used for strategic reporting and analytics.
- Performed customer 360 profiling and SQL-based record linkage that improved insight accuracy by 35% and supported tailored marketing and personalization recommendations.
- Developed real-time Tableau dashboards for executive reporting and operational teams; dashboards informed product and go-to-market strategies for retail clients.
- Conducted price elasticity and promotional impact analysis using statistical techniques to optimize pricing and promotion strategies across online and brick-and-mortar channels.
- Executed A/B testing frameworks and marketing analytics to evaluate campaign effectiveness; synthesized test results into prioritized recommendations for client go-to-market teams.
- Implemented anomaly detection and analyzed semi-structured data (JSON, clickstream) to identify fraud signals and UX issues; automated Excel reporting using VBA and Power Query, reducing manual effort by 40%.
Education
New Jersey Institute of Technology
Master of Science, Data Science • USA • Sep 2023 – Dec 2024
Vignan Institute of Information Technology
Bachelors, Mechanical Engineering • India • May 2018 – May 2022
Powered by Drivetube · Create your own profile at drivetube.ai
Explore Drivetube
- Drivetube Profile — your free digital resume — at drivetube.ai/in/your-name: one true standard resume with a Hiring Snapshot (visa status, expected salary, notice period, work preference, relocation), an ATS-ready PDF download and a single shareable link. Free forever; interview requests come from verified employers and your contact details stay masked until you accept. Documentation.
- Free Job Board — verified openings crawled ATS-by-ATS from 100,000+ real company career pages across 35 ATS platforms. Shows the true posting date from the source ATS — not when a listing was indexed — and deletes every general listing 3 days after it was actually posted. No ghost jobs, no ad-sponsored listings, no staffing reposts, no account needed. Documentation.
- Job Hunt Program — managed job hunting, a one-time purchase from $199.99. JobScout matches verified roles to your real experience band, Blend AI writes a uniquely tailored resume and cover letter for every application, and the Autofill extension fills the form — or Let Us Apply submits it for you. Documentation.
- Resume Writing Services — human-written, ATS-optimised resumes by senior career writers, from ₹499.99 / $25.99. Available in every country, written to the destination country's own standard — a US resume, UK CV, German Lebenslauf and Indian resume are genuinely different documents. A paid service, separate from the free Drivetube Profile. Documentation.
- Community Membership — from $4.99/month (₹1,999/year in India). Unlocks the gated job-board filters — visa sponsorship, security clearance, workplace and application time — plus Job-Scout AI matching, Resume Report AI, Interview AI prep sheets, Recruiter Outreach AI sent from your own Gmail, Apply or Skip triage, a daily market feed and a $10,000+ library including 23 ATS-validated resume templates. Documentation.
- Drivetube Hire — for employers — hiring with no job postings and no applications. Paste your real job description and AI matches it against candidates' true standard resumes, returning ranked candidates with a match %, matched and missing skills and written reasoning. Free tier included; employers pay, candidates never do. Documentation.
Full product documentation — every product explained, with feature-by-feature comparisons against the job boards, AI apply tools, resume services and hiring platforms people actually use.
The job board covers the United States, India, United Kingdom, Canada, Europe and Australia, and Resume Writing Services are available in every country.