A result-oriented data programmer in SAS with over 5 years of experience in Mainframe & Window Environments along with Basic Tableau and Excel.
Skilled in BASE/SAS, SAS/SQL, SAS/MACROS, SAS/ACCESS, SAS/ODS, and SAS EG, along with leading cross-functional teams, fostering collaboration and achieving quality outcomes while managing risk and escalation effectively
Experienced in preparing reusable components and SAS Macros for automation of the application
Recognized for spearheading anomaly detection initiatives, conducting detailed root cause analyses, and crafting high-level business reports, handling Production Support and Ad- hoc Requests.
Experienced in Mainframe Z/OS environment with JCL and DB2.
Domain experience in Energy Markets(USA) & Pension & Payroll
Demonstrated expertise in data extraction, data cleaning, data visualization, data analysis, and automation to optimize processes and drive efficiency
Skilled in providing data-driven, action-oriented solutions to challenging business problems.
Proactively build strong relationships with internal and external stakeholders, ensuring effective communication and alignment of project goals
Overview
8
8
years of professional experience
Work History
Analyst Programmer
Wipro Hr Services Pvt. Ltd
05.2022 - Current
Led 3 client engagements, managed production support, and ensured smooth operations and timely issue resolution as per SLAs
Streamlined reporting processes, improving efficiency and accuracy.
Scheduled maintenance and cleanup jobs, ensuring system reliability
Developed complex, reusable SAS macros
Curated large datasets by combining information from diverse sources using SAS techniques (e.g., set & merge, joins, SAS-Procs, etc)
Updated and maintained SAS code, optimizing performance and reliability.
Synthesized analytical findings into impactful insights.
Presented insights through visualizations, including BasicTableau dashboards
Documented processes for clarity and consistency.
Working Environment: Mainframe & Windows(SAS EG, Excel, IBM DB2, Tableau).
Senior Analyst
Global Logic
11.2018 - 05.2022
Working on BASE and ADVANCED SAS .
Successfully imported data from various sources (e.g., CSV, Excel) using Proc Import
Proficiently performed data joins, unions, and merges using SAS.
Experience in Reporting ,Data Management ,customer segmentation & analysis of complex data using DATA- step Programming, SAS Procedures, SAS Functions and SAS/Macros.
Knowledge of SAS STAT procedures like PROC FREQ, PROC MEANS, PROC SUMMARY, PROC TRANSPOSE.
Knowledge of SAS procedures for creating Graphs and Charts like Proc Gchart, Proc SGPlot , Proc Plot ,Proc Gplot,
Leveraged first. variable and last.variable techniques to identify the first and last occurrences within sorted data.
Improved efficiency by automating repetitive tasks using SAS
Enhanced decision-making by presenting actionable insights to stakeholders.
Analyst
Global Logic
05.2017 - 11.2018
Timely delivery different projects at the highest possible quality standard.
Provides daily status update, complete work assigned on time, takes intiative and provides timely reports as per standard work.
Manage internal tracking spreadsheets and database to deliver monthly statistics related to rating quality.
Associate
Wipro Ltd
11.2016 - 04.2017
Provided end to end Customer Service
Responded to Inbound telephone calls from USA & Canada.
Adhere to established procedure & guidelines while providing quality customer service in order to meet & exceed department standards.
Education
Bachelor of Technology - Electronics & Communications Engineering
SHUATS
Prayagraj, India
04.2001 -
Intermediate -
Central Academy
Indira Nagar Lucknow
04.2001 -
Skills
SAS EG
PROC SQL
Mainframe
Sas Macros
IBM -DB2
Tableau
Excel spreadsheets
Jira, confluence,sharepoint
Hro Maestro, ATE
Timeline
Analyst Programmer
Wipro Hr Services Pvt. Ltd
05.2022 - Current
Senior Analyst
Global Logic
11.2018 - 05.2022
Analyst
Global Logic
05.2017 - 11.2018
Associate
Wipro Ltd
11.2016 - 04.2017
Bachelor of Technology - Electronics & Communications Engineering