Srividya Vedula
Summary
Result-oriented Business Analyst working at JP Morgan & Chase, specializing in Card Acquisitions Reporting within Card Data and Analytics. Proficient in SAS Programming, Macros, and skilled in producing reports using various SAS Functions and Procedures. Adept at data extraction from databases like Teradata and Oracle, with a strong focus on data manipulation for customized reports.
Overview
7
7
years of professional experience
Work History
Business Analyst (Card Acquisitions Reporting)
JP Morgan & Chase
Wilmington, DE
06.2019 - Current
- Proficiently utilized SAS programming, including SAS/BASE, SAS/SQL, and SAS/MACROS, for data extraction, manipulation, and report generation.
- Demonstrated expertise in developing complex SQL queries to create and manage large datasets from Teradata and Oracle, specializing in data cleansing, scrubbing, and profiling.
- Effectively collaborate with business partners and stakeholders, ensuring timely updates to the reports aligned with business requirements.
- Actively engaged in current SAS reports migration to Alteryx platform.
- Experience in using Essbase for card acquisition data retrieval using excel plugin for weekly report generation.
- Produced precise BAU (Business as Usual) weekly and monthly reports, ensuring accuracy for comprehensive analysis.
- Executed daily data pulls, incorporating thorough data validation to support seamless team operations
- Played a pivotal role in updating existing code for routine reports on a daily, weekly, and monthly basis, ensuring continuous relevance.
- Utilized technologies like Microsoft Excel, BMC Control-M, Putty, SAS Studio, WINSCP, and Microsoft Access for efficient workflow and report generation.
SAS Analyst
Sama Systems Inc
PA
10.2016 - 06.2019
- Gathered and analyzed new reporting requirements from business end users, determined resolution plan and design specifications
- Generated programs to create SAS data sets/ import external data to generate SAS data sets, data cleansing
- Actively resolved the production issues as when they emerged
- Exported the SAS datasets and generate the desired output files with the desired delimiters
- Extracted, aggregated, normalized, and analyzed large data sets using SAS
- Worked on Secure CRT and used UNIX commands to determine the file permissions and file creation details
- Generated the SQL update and delete queries to update/modify the DB2 tables
- Used the cron jobs to periodically update the desired tables.
Education
Bachelors of Technology in Electrical and Electronics Engineering -
Chaitanya Engineering College (affiliated to Jawaharlal Nehru Technological University)
01.2009
Skills
- SAS: SAS/BASE, SAS/SQL, SAS/MACROS, SAS/EG, SAS STUDIO
- Data Extraction: Proficient in extracting data from Teradata, Essbase and Oracle databases
- Data Manipulation: Skilled in SAS Data steps and PROC steps for crafting customized reports
- File Formats: Expertise in producing Excel, CSV, and Text formatted files
- Coding and Debugging: Strong skills in coding, editing, and debugging in SAS/BASE and SAS/MACRO
- Report Maintenance: Updated existing code for daily, weekly, and monthly reports, ensuring error-free production of BAU reports
- Data Management: Managed daily data pulls, including rigorous data validation processes
- Stakeholder Collaboration: Effective collaboration with business partners for timely report updates
- Technology Utilization: Leveraged Microsoft Excel, BMC Control-M, Putty, SAS Studio, WINSCP, and Microsoft Access for streamlined workflow
- SAS Studio / Enterprise Guide
- Putty
- WINSCP
- Microsoft Access
- Microsoft Excel
- Alteryx
- BMC Control-M (Automate Scheduler)
Timeline
Business Analyst (Card Acquisitions Reporting)
JP Morgan & Chase
06.2019 - Current
SAS Analyst
Sama Systems Inc
10.2016 - 06.2019
Bachelors of Technology in Electrical and Electronics Engineering -
Chaitanya Engineering College (affiliated to Jawaharlal Nehru Technological University)
Similar Profiles
Lisa Olivia GrenviczLisa Olivia Grenvicz
Private Client Banker at JP Morgan Chase & Company (Chase Bank)Private Client Banker at JP Morgan Chase & Company (Chase Bank)
Miranda GuerreroMiranda Guerrero
Associate Banker Market Expansion at Jp Morgan Chase ChaseAssociate Banker Market Expansion at Jp Morgan Chase Chase
Swati DoraSwati Dora
Senior Fraud Specialist at JP Morgan & ChaseSenior Fraud Specialist at JP Morgan & Chase