Summary
Overview
Work History
Education
Skills
Certification
Disclaimer
Awards
Project Duration
Languages
Timeline
Generic

Keena Jalakar

Chennai

Summary

Dynamic Senior Analyst Consultant with extensive experience at Wells Fargo, leveraging SAS and SQL for impactful data analysis and remediation efforts. Proven ability to enhance operational efficiency and compliance through innovative solutions and effective collaboration. Skilled in data integration and project management, driving successful outcomes in complex environments.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Senior Analyst Consultant

Wells Fargo
Chennai
12.2024 - Current
  • Supported customer remediation efforts across Credit Card, Home Lending, and Customer Bureau domains using SAS, Teradata, and Tableau.
  • Analyzed system errors to assess customer impact and identify affected populations.
  • Developed SAS and Teradata queries for data extraction and validation.
  • Resolved credit reporting discrepancies in accordance with FCRA compliance.
  • Created Tableau dashboards and summary reports for leadership and regulatory stakeholders.
  • Collaborated with risk, legal, and compliance teams to maintain audit-ready documentation.

Manager

Cognizant
Chennai
10.2023 - 12.2024
  • Identified populations eligible for Medicare plans and provided suitable enrollment suggestions.
  • Conducted requirements gathering and analysis to inform project direction.
  • Utilized SQL for data extraction, transformation, and loading processes.
  • Executed SAS coding and integration testing to ensure data accuracy.
  • Facilitated continuous cross-skilling and upskilling initiatives for self and team members.
  • Managed production code deployment activities with full accountability.
  • Scheduled jobs using Stonebranch software to streamline operations.

Manager

Cognizant
06.2022 - 10.2023
  • Revamped Medicare flow logic to enhance execution speed amid growing data complexity.
  • Implemented necessary changes in Teradata tables, views, ETL pipelines, and reports.
  • Executed new file-to-table load requirements for business validation purposes.
  • Completed all phases of project work, including design, build, testing, and implementation.
  • Identified project risks and opportunities, formulating appropriate response strategies.
  • Participated actively in project team meetings and communicated issues promptly.
  • Contributed to all SAS coding development activities to ensure project success.

Senior Associate

Cognizant
09.2021 - 05.2022
  • Converted all Wherescape procedures to SAS coding for enhanced flexibility during parallel runs.
  • Eliminated manual intervention for end-to-end VBP load through optimized scripts.
  • Developed scripts with dynamic parametrization to facilitate parallel and test runs.
  • Conducted daily calls with onsite leads to clarify requirements and provide status updates.
  • Defined, planned, tracked, and managed project deliverables effectively.
  • Maintained tracking checklists, tools, reports, and charts to meet project objectives.
  • Introduced new features in Wherescape for restart capability and automated mail triggers for notifications.
  • Enhanced parameter files to ensure dynamic database access for each source.

Lead Programmer Analyst

Wipro
09.2017 - 08.2021
  • Processed ad-hoc client requests by extracting and formatting relevant data for reporting.
  • Utilized ODS functionality in SAS to post reports on websites or email them directly.

Senior Analyst

Wipro
08.2013 - 08.2017
  • Loaded raw client data into system using DBLOAD and SAS for standardization.
  • Processed over 200,000 records in initial data load, followed by ongoing scheduled updates.
  • Planned and coordinated client relationship studies with effective communication skills.
  • Conducted statistical analyses on study data using appropriate methodologies.
  • Executed SAS programming, incorporating advanced data manipulation techniques and procedures.
  • Utilized JCL procs within DB2 systems for data loading and verified results through SQL queries.
  • Optimized SQL queries to enhance batch performance and user response times.
  • Provided technical and business guidance to team members.

Education

Bachelor Of Engineering - Computer Science

Maamallan Institute of Technology
Chennai
01.2013

HSC -

Anna Adarsh Matriculation Higher Secondary School
Chennai
01.2009

SSLC -

Anna Adarsh Matriculation Higher Secondary School
Chennai
01.2007

Skills

  • Windows and Unix systems
  • Mainframe computing
  • SAS Enterprise Guide
  • AWS cloud services
  • SQL and Teradata
  • BTEQ scripting
  • Data integration with Talend
  • PostgreSQL database management
  • File transfer with WinSCP and Putty

Certification

  • Base SAS, Base SAS certified, 05/01/16
  • Talend, Certificate (Data integration Basics/Advanced/Big Data Basics/Big Data Spark), 05/01/21
  • AWS Solution Architect, Certificate, 05/01/22

Disclaimer

I hereby affirm that the information provided above is true to the best of my knowledge.

Awards

  • Client appreciation and award for automating SAS jobs.
  • Star Performer of the Month Award for quick turn around.
  • On the spot Award for effective delivery of critical tasks.

Project Duration

The Project started in November 2022 and in scope till now.

Languages

Telugu
First Language
English
Advanced (C1)
C1
Tamil
Upper Intermediate (B2)
B2

Timeline

Senior Analyst Consultant

Wells Fargo
12.2024 - Current

Manager

Cognizant
10.2023 - 12.2024

Manager

Cognizant
06.2022 - 10.2023

Senior Associate

Cognizant
09.2021 - 05.2022

Lead Programmer Analyst

Wipro
09.2017 - 08.2021

Senior Analyst

Wipro
08.2013 - 08.2017

Bachelor Of Engineering - Computer Science

Maamallan Institute of Technology

HSC -

Anna Adarsh Matriculation Higher Secondary School

SSLC -

Anna Adarsh Matriculation Higher Secondary School
Keena Jalakar