SUMEET VIVEK BHARAMBE

Orchestrated deployment of SAS jobs and flows on servers using Flow Manager, streamlining automation processes.

Developed SAS jobs and workflows with SAS Enterprise Guide, SAS DI, SAS SMC, and Flow Manager to enhance operational efficiency.

Identified and resolved production errors by analyzing logs via WinSCP, minimizing downtime.

Conducted thorough log analyses to identify root causes, implementing solutions to improve system stability.

Diagnosed job failures to reduce resolution time and enhance system reliability.

Analyzed business requirements, providing data-driven insights for informed decision-making.

Analyzed inbound and outbound interface requirements provided by business users.

Spearheaded data management initiatives utilizing SAS programming and SAS Enterprise Guide.

Defined provisions for HM and CM in HRO workbench, establishing job stream IDs and Job Proc definitions.

Generated JCL code using job stream IDs with the JCL generator.

Developed and migrated SAS code to BlueZone for generating control, bypass, and error reports.

Utilized SAS-SQL to extract data from TBA (DB) for report generation.

Employed SAS to process EFT input files, creating EFT GDG output files in BlueZone.

• Transformed data using Informatica (ETL) and SecureFX (Unix) to create info maps and target files.

Developed SAS DI jobs for efficient data loading from flat files to target tables.

Executed DDS load process in three phases: Staging, CSA, and final DDS load.

Loaded data into DDS tables utilizing multiple transformations for optimal results.

Designed control tables, pre-jobs, and post-jobs to streamline processes.

Managed production support activities, server space allocation, and related issues.

Oversaw Support Mailbox operations, including user access management and issue resolution.

Proactively monitored and enhanced availability and performance of production environments across all layers.

Ensured logging of all issues in ServiceNow for effective tracking and resolution.

Analyzed data from SAS datasets using SAS Enterprise Guide to enhance reporting accuracy.

Generated comprehensive reports through SQL-based SAS procedures and utilized SAS-SQL for customer data sorting.

Developed SAS macros to streamline programming processes and improve efficiency.

Created Turnaround Time dashboards for applications, including Vendor Invoice Management and RFC.

Applied parameterized sorting logic across various sectional areas to optimize data retrieval.

Implemented display rule logic to visualize Achieved and Missed counts for each application.

Established performance-linked sections for detailed data analysis tailored to business users.

Contributed to project intern role at Techdata Solutions, specializing in SAS development for banking automation.

Created SAS datasets utilizing banking sample data for analysis.

Employed Proc Import, Proc Sort, Proc Append, and dataset merging to achieve desired outputs.

Developed comprehensive reports using Proc Report to fulfill reporting specifications.

Conducted statistical analysis on banking sample data with Proc Freq and Proc Means.

Implemented SQL Joins across multiple datasets to meet defined project requirements.

• Interpreted requirements and technical specifications to inform testing processes.
• Developed test scenarios and cases for functional, regression, and UAT testing.
• Tracked and reported defects using Mantis for prompt resolution.