Kalairaja Chockalingam

addb0k@r.postjobfree.com 210-***-****

www.linkedin.com/in/kalairaja-chockalingam/

Senior SAS & SQL Developer / Data Analyst

9+ years’ proven success leading SAS optimization and strategic Data solutions for high-growth organizations

Advanced SAS certified data analyst programmer with in-depth knowledge of developing 1400+ SAS and SQL reports procedures while being astute in automating over 250 manual procedures. Proven ability research methodologies, big data capture, curation, manipulation, data visualization, as well as risk analysis and mitigation. Furnish insights, analytics, and business intelligence used to advance opportunity identification, process reengineering, and corporate growth. Well versed at developing strategic solutions for fraud detection on new payment types and complex payment chains, thus saving enterprises multi-million-dollars.

Highlights of Expertise

SAS/SQL Programming & Development

Fraud Detection & AML Strategist

IT processes & Software Testing Lifecycle

Product & Campaign Analytics

Member Behavior & Personalization Analytics

Data Analysis & Modeling

Reporting & Data Visualization

Social Media Analytics Data

Data Mining & Conversion

Automation & Optimization

Technical Skills & Certifications

Languages

SAS Advanced, SAS Base, SAS Macros, SQL, VBA Scripts, R, Unix Scripts, Mainframe JCL, Easytreive

Reporting and Visualization Tools

SAS Enterprise Guide, SAS PC, SAS Web Report Studio Adobe SiteCatalyst, Tableau, Microsoft Excel and Pivots, SAS Visual Analytics

Data Modeling Tools

R Studio, SAS Miner, SPSS, Minitab, Anaconda

Control-M /Automation Tools

Control M Workload Automation, Control M Desktop Manager, Control M Enterprise Manager, Software Configuration Management (SCM), TSO/ISPF, Enterprise Output Solution (EOS), Autosys, Job Information Language (JIL), CRON

Other Tools/Skills

Teradata SQL Assistant, Oracle SQL Developer, Putty, Winscp, Actimize RCM, Beyond Compare, Squirrel SQL Client, Microsoft Sharepoint, Microsoft Office, Salesforce, Luminoso, Facebook Business Manager tool, Twitter Analytics, Social lithium intelligence tools, SDLC

Operating Systems

Linux, Unix, Windows Server 2003/2007/10, Mainframe z/OS

Certifications

SAS Base Programmer, SAS Advanced Programmer, Tableau

Career Experience

SENIOR SAS DEVELOPER, FRAUD DETECTION STRATEGIST 2018 to Present

Compunnel Software Group (Wells Fargo), Charlotte, NC

Project: Fraud detection & Optimization in Wholesale Internet Fraud Prevention

Developed SAS processes and procedures, and ensured compliance initiatives as well as manage data extraction, collection, data mining, mapping, preprocessing, and fraud alert analyzation while, utilizing SAS Enterprise Guide.

Designed UNIX/LINUX shell scripts & SAS & SQL programs for automation with error handling mechanisms and self-service tools/dashboards/Data visualization reports to assist executives in making critical business decisions.

Established fraud detection strategies on new payment types and complex payment chains like RTP, FIG, PM, CEO, Bill.com, Direct originations using Time of Day Fraud anomaly, high risk Beneficiary, On-Us name mismatch, First time beneficiary, Profile Matching, Keyword alerts, etc.

Direct SIT and UAT testing, automation and scheduling of jobs through Control-M or Unix CRON using Agile methodologies.

Constructed NDM Alert ingestion & enrichment ingestion to Actimize real-time fraud investigation tool.

Use Machine learning algorithms like PCA, logistic regression, Clustering, decision tree to predict the Anti-Money Laundering AML and Fraudulent Wire transaction.

Conducted data analysis to make business recommendations (cost-benefit, invest-divest, forecasting, impact analysis), created effective visual displays and dashboards of quantitative information and delivered presentations to multiple levels of stakeholders.

SENIOR SAS DEVELOPER, DATA ANALYST 2018

Xoriant Corporation (Citigroup Global Market), Elk Grove Village, Chicago, IL

Project: Portfolio Automation in Customer Data Intelligence and Credit Solutions

Designed SAS methods & strategies, re-engineering, Automation and optimization for fresh retail portfolios through CRON/Autosys.

Developed SAS modules for linking Citi Retail Banking's Cardholder transfer account, and generated a record system to produce a correlation between Account and a consistent Unique ID.

Performed testing on the Migration of SAS9.2 to SAS Grid and Grid Enhancement.

Migrated a single stream process to Cycle based Refresh for Citi’s major retail service portfolios.

SAS DEVELOPER, DATA SCIENCE ANALYST 2014 - 2018

Tata Consultancy Services, Inc. (USAA - United Services Automobile Association), San Antonio, TX

Project: Insights Delivery in ESM, EDAO, Affinity Members, Social Platforms

Proficiency and extensive experience in Enterprise Sales Funnel research, member profiling, new & lost member analysis, Affinity Member analysis, Only's anlaysis as well as Target Audience analysis for marketing.

Steered manipulation & transformation of data to information, data visualization & presentation of key metrics KPI to see beyond numbers & help inform, influence, support and execute business decisions.

Conducted numerous analyses including cost per impressions, site visits, app start, and app complete analysis through social campaigns for mortgage, credit card, auto insurance.

Identified the impacts of Email Opt-Outs to each Line of business while calculating the incremental losses to post penalties on those specific campaigns.

Analyzed Return of Investment (ROI) and Relative social engagement rate for Social Media Campaigns, Social Media Brand promotion and amplification analysis.

Developed Auto Churn POC Model, ROI model by using clustering, logistic regression, decision tree algorithms through R, Python and SAS.

Explored member's transactional data to analyze the primacy of checking products while providing recommendations for retaining them in primacy for longer durations.

Developed reports to research Enterprise growth and performance across various dimensions like Generation, Eligibility, Tenure, Community, SOR, Line of business, etc.

Extensive experience on 'Share of Wallet' approach, Customer Personalization, Customer 360 concepts to filter the consumer to target items including Electronic Will, Checking, Credit Card, Auto Insurance.

SAS DEVELOPER, MIGRATION & AUTOMATION SPECIALIST 2010 - 2014

Tata Consultancy Services, Inc. (USAA - United Services Automobile Association), Chennai, India

Project: UCH Control M and Enterprise Analytics

As highly analytical and technically astute SAS programmer, developed SAS reports for Member Insights, Sales & Marketing LOBs and created Business Intelligence reports and dashboards.

Migrated the legacy UDA's and SAS programs from Mainframe, MS Access to SAS process and scheduled them in an automated Control-M environment.

Proactive on creative ideas to reduce abends like introducing Start of Cycle jobs, scheduling tricks and adding error handling and exceptional handling mechanisms to SAS processes.

Spearheaded and mentored the team in Batch support, abend resolution and defect fix.

Remarkable efficiency in automation of complex manual SAS & SQL process to schedule in Control-M.

Career Accomplishments

Developed 1400+ SAS & SQL procedures and visualization reports.

Automated 250+ manual process and optimized to save 8000+ hours per year.

Developed and deployed 12 Fraud Detection strategies to save $35M.

11,000+ hours of experience in data analysis and data visualizations.

Profiled and analyzed more than 600 files of financial and member information.

Extensive experience on Rtrace analysis to retire unused SAS packages to save license cost.

Conducted series of SAS training sessions across the globe - Chennai, San Antonio, Charlotte.

Boosted success rate of prod jobs to 99% against 93%, by applying six sigma & ITIL methodologies.

Education

BACHELOR OF TECHNOLOGY WITH SPECIALIZATION IN ELECTRONICS AND COMMUNICATION 2006-2010

SASTRA University, Thanjavur, India

Contact this candidate