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
Chennai01.2013
HSC -
Anna Adarsh Matriculation Higher Secondary School
Chennai01.2009
SSLC -
Anna Adarsh Matriculation Higher Secondary School
Chennai01.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
Similar Profiles
PATRICIA M. SCHERERPATRICIA M. SCHERER
Regional Bank Private Banker II at Wells Fargo Bank / Wells Fargo AdvisorsRegional Bank Private Banker II at Wells Fargo Bank / Wells Fargo Advisors
Andrew S. HollenbachAndrew S. Hollenbach
Collateral Valuation Analysis at Wells Fargo Home Mortgage and Wells Fargo Bank NACollateral Valuation Analysis at Wells Fargo Home Mortgage and Wells Fargo Bank NA
Laxmikanth ChittampallyLaxmikanth Chittampally
Senior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells FargoSenior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells Fargo
Mayank OberoiMayank Oberoi
Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)
Ranjitha KolanginathanRanjitha Kolanginathan
Lead Consultant at Virtusa Consulting ServicesLead Consultant at Virtusa Consulting Services