Sumit Rai

• Led technical workshops, sharing expertise with colleagues to improve overall team capabilities.
• Collaborated with cross-functional teams to deliver high-quality projects within tight deadlines and delivered Migration, ECB Projects.
• Responsible for all administering changes in SAS HBFR environment and ensuring data integrity, regulatory compliance and user level security using SAS Administrative skills.
• Played a key role in project or initiative, e.g., data migration, system upgrade, automated SAS tasks , utilizing SAS to validate data, automate reports and alerts , contributing to successful project delivery, improved system performance and handing team management.
• Involved and implemented from SAS 9.4 m4 to 9.4 m8 in place upgrade activity.
• Planning for merging SAS environments to meet business goals and also manage hardware re-sizing of current SAS environment.
• Managing SAS Prod, UAT and Development Environments.
• Handling SAS batches and User queries based on business gb/gf’s.
• Managing INC’s and request and maintaining business SLA.
• Creating and managing change orders to smooth deployment’s and Controls under security policies.
• Coordinating and handing new business demands and preparing business domain documents.
• Assisting business for Adhoc and Code enhancement work.
• Managing and handing European Central Bank (ECB) Network Segmentation project to enhancing RE-IP approach with SAS Application.
• Maintaining KBA (knowledge based Article) for new user base and provide training session for domain information.
• Worked on SAS Viya 4 deployment.

• Evaluate and recommend new tools and methodologies to assist with client management and perform upgrades of the SAS environment when necessary
• Provide all levels of technical and application support; incident management (Level 1, 2 and 3); address user, application and data issues.
• Monitor usage logs to assist in performance tuning of the systems and servers like Prod, Dev and UAT.
• Create business campaign’s and ensure alignment to overall SDLC and business Management processes
• Performs platform capacity planning and management in CI workflow.
• Execute change management processes surrounding new releases of SAS functionality.
• SAS Grid functionality - load balancing, resource management, setup of queues, prioritization, manage jobs and thresholds.
• Maintain and monitoring SAS environment and Automate Admin related works.
• Enhance and updating user codes and deploy to SAS environments also perform Ad hoc request.
• Submitting the Google Big query in order to fetch data from SAS to GCP therefore creating SAS Campaign’s.
• Develop cross-sale and up-sale campaign’s and acknowledge report as per business requests.
• Analyze Python & SQL codes and convert this to SAS programming.

• Responsible for all Administration related tasks for Fedex ground Business users (user creation, group creation, library creation, managing security and permissions etc.).
• Stopping/starting the respective listeners/servers based on Maintenance activities.
• Involved in Migration activity processing non grid to Grid environment .
• SAS Viya installation and configure for all the environment (Prod, Dev, UAT).
• Support Production, Test & Development SAS platforms and creating SAS Users, Groups & Database Libraries on SMC.
• Preparing data and report for adhoc requirement .
• Interacting with SAS vendor on various issues raised over the trouble ticket to resolve server and end users issues.
• Automated admin related task or activity by writing scripts.
• Managing and administrating Prod, Test and Uat servers.
• Preparing Adhoc reports based on business user requirement.
• Worked on SAS Code/Job enhancement on prod environment.
• Working on user programming related issue’s based on user Epdsm tickets.
• Maintaining the Ticket SLA and business priority tasks.
• Maintaining and enhancing SAS DI jobs as per business requirement.
• Involved in SAS Viya 3.5 migration work.

• Managing SAS EBS and SAS Marketing environments.
• Providing solution based on priority tickets.
• Involve in SAS upgrade activity.
• Interacting with SAS business teams on various issues raised over the trouble ticket to resolve server and end users issues.
• Maintaining and managing daily, weekly and monthly SAS jobs flows.

Project# 1:

Campaign Solution - Rogers Communication

• SAS CI and SAS EG application help business to create campaigns design by business users and generate reports that would be consumed by Business team.
• SAS CMT team responsible for campaign operation and testing and support provide to the business their systems application and information in a timely manner. The intended for this process would be for that need to support the CMT SAS jobs and flows.
• Scheduling the deployed various Campaigns & RTDM jobs/flows using SAS MANAGEMENT CONSOLE through schedule manager and monitoring using LSF.

Project #2

EWS (Early Warning System) - Bank of Maharashtra

• Managing SAS Server administration & various tools like SAS EG, SAS CI, SAS Viya and SAS VA work with the help of using SAS Management Console & SAS Environment manager.
• Responsible for all SMC Administration related tasks (user creation, group creation, library creation, managing security and permissions etc.).
• Stopping/starting the respective listeners/servers based on Maintenance activities.
• Updating patches, applying hot fixes & renewing the License on SAS servers and Client machines.
• SAS Viya installation and configure for all the environment (Prod, Dev, UAT, DR).
• Support Production, Test & Development SAS platforms and creating SAS Users, Groups & Database Libraries on SMC.
• Maintain SAS environment builds & capacity planning for additional server resource and involved in hardware sizing activity for SAS servers as per current business requirement.
• Interacting with SAS vendor on various issues raised over the trouble ticket to resolve server and end users issues.
• Perform DC to DR data sync up for all the BOM environments.
• Automated admin related task or activity by writing scripts.
• Support development team for Automation solutions and performance tuning of job flows and executing the SAS VI Alert Generation Process based on customer requirements.
• Servers monitoring and their performance tuning and Scheduling cron Jobs, SAS Visual Investigator and SAS DI flows and reviewing cron and application logs.
• Performed Hardware sizing activity as required new scenario and optimal performance.
• Performed SAS 9.4 to SAS Viya connection and established SAS 9.4 to VTA connectivity in order to perform new development and reporting.
• Developed MIS reports for business user under SAS Viya environment.

Project# 2:

SAS INTERNAL POC Project

Duration: 6 month

Environment : SAS Viya visual studio,SAS Visual Text Analytics, SAS Viya Explore and Visualize, Unix, AWS Cloud Platform.

Database : Oracle.

Role : SAS ADMIN/Dev

Roles and Responsibilities:

• Project aim is creating tool such as Intelligent search.
• This is an internal POC to use Visual Text Analytics and aim to build a tool to search through internal document collections.
• The document collections can contain location of help documentation , issue logs and related resolution documents.
• The tools should points the users (based on input query ) to closely matching documents based on search criteria.
• Creating SAS dashboard to validate key performance data items.

Project# 3:

SAS - Alteryx Migration

Duration: 2 month

Environment : AWS, SAS 9.4, Alteryx designer studio, Unix

• Project aim is migrating SAS flows to alteryx workflows.
• Cleared the Designer Core certificate of version 2020.
• SAS BOD was involved as Technical point of contact for the Alteryx workflows migration activity.
• This migration activity is considered as “lift and shift” from on-premise solution to AWS cloud.
• SAS BOD team has define the test strategy to validate the current state of Alteryx application and compare with the AWS cloud system and to ensure that all the Alteryx components are functioning the same way.
• SAS BOD will plan for the seamless migration of Alteryx workflows to the AWS cloud server.
• Installed and configured of alteryx solution on aws platform.
• Settting up workflows and created new macro code for data loading.
• Preparing Documents for findings, issues and fixes. These document would become a very good source for the entire migration, updated the document as and when a new issue comes up.
• Setup source and target environment by passing target consumer keys and secrets.
• Tested all the scheduled Alteryx workflows for failure and changed property according to business needs.

• Supervised day-to-day operations to meet performance, quality and service expectations.
• Involve in SAS upgrade 9.4 M2 to 9.4 M5.
• User and Group creation for new employees and assigning role to the users.
• Involved in the Construction of the ETL Process- Extracting data from flat files and database using SAS DI and Transforming it according to the Business Requirements and loading the data back into Maser data tables.
• Scheduling and Re-Scheduling the Jobs in SMC.
• Creating and Assigning Libraries to different users and giving permission based on user role.
• Looking on Space usage periodically on the Server's and terminating the Jobs if the usage exceeds.
• Ticket handling (INC's and RITM's) and resolving the users request and closing of the Issues.
• Resolving SAS-Add Inn Issues with users.
• Creating and deleting User directories in Unix environment.
• Resolving SAS EG connectivity issues and other database connectivity issues.
• Sending monthly reports to manager and stack holders.
• Monitor space usage and job flow.
• Author all the documents related to admin activities.
• Used SAS management console o Schedule various jobs.
• Publish the forms and reports as per business timeline using SAS FM.
• Create job in SAS DI, deploy and Schedule job using SAS management console (SMC).
• Created process flow and work document.
• Created UNIX scripts as per process requirements and in order to automate the work flows.

• Reviewed and ensured analysis data and programming code to meet regulatory and company standard.
• Responsible for providing SAS programming and analysis support for business user across multiple locations.
• Cross-validated programs with others compared outputs and proofread the coding.
• Adept in SAS 9.3 installation, upgrade, and other SAS 9.3 Administration related activities on Windows and UNIX based environment.
• Scheduling the deployed jobs using SAS MANAGEMENT CONSOLE through schedule manager and monitoring using LSF.
• Managing & providing technical guidance/support to the project team.
• Responsible for providing Weekly and Monthly SAS reports to business.
• Managing SAS Server administration & various tools like SAS EG, SAS E-Miner work With the help of using SAS Management Console & SAS Environment manager.
• Research and recommend innovative and where possible automated approaches for administration efficiency.
• Managing and administering all SAS users and group accounts, roles, permissions & Support end users with access and connectivity related issues.
• Creation of Base and external source libraries with concerned (Oracle, SQL) servers.
• Manage system security and permissions.
• Provided additional adhoc reports to business user.
• Monitoring Server (UNIX) space and memory for better performance.
• Involved in the process of planning for installation of SAS 9.4 upgrade.
• Monitor the tickets and troubleshoot/Resolve user incidents.
• Reports Development, Changes to reports & bug fixes.
• Enhancement of jobs for Business users as per request.
• Involved and coordinated with different teams for Solaris OS Kernel Upgrading by applying patches on all the SAS Production and Test Environment and performed necessary testing for SAS.
• Involved in some Internal Project's and worked from Administration side.
• Worked with the team and believed in team work. Helped, provided necessary inputs and managed till everything goes fine during working hours and OOH's.
• Renewing SAS Licenses on corresponding Linux boxes.
• Resolving the server related issues.
• Created metadata for Source and target tables and Libraries.
• Monitoring & managing SAS Grid Environment.
• Resolving user issues based on priority raised through service now.
• Responsible for clearly documenting all work, managing health care business domain assignments to meet timelines, and producing high quality deliverable.
• Ensured that production SAS datasets were available, complete and correct for production of scheduled reports, dashboards and ad hoc reporting;

• Design and develop innovative products by offering segmented products to segmented base
• Monitor competition offers and create superior propositions
• Pre Launch financial analysis of products, assessing post Launch impact of new products
• Development and Management of Products & Services
• Planning and Revenue Projections.
• Drive revenue and subscribers usage. Revenue Tracking & analysis of existing products - tariffs & schemes.
• Revenue Enhancement to targeted subscribers through various activities.
• Prepaid Revenue Analysis of existing subscribers through in various analysis, trends, Tertiary Transactions, Customer segmentation based on Revenue Earning Customers trend.
• Programs on increasing customer loyalty and churn reduction.
• Grace prevention module to retain customer in active state.
• Prepared revenue model For Usage and Revenue Team to help them Increase Revenue on specific Segment of Customer base.
• Constructed Churn & Grace Predictive Model to Retain Customer’s before Churn.
• Developed the Program for finding Zero RC and Zero Usage Subscribers.
• Consultation with Usage and revenue team to suggest the suitable Product to zero Usage and Zero RC users to start them make outgoing calls and make recharges.
• Dashboards on primary, secondary and Tertiary with Distribution Channel.
• Pushing sales team to increase primary and flashing the dashboards on tertiary.
• Monitoring the usage enhancement of new analytical tools like COGNOS and SAS in day to day analysis and working closely with SAS & BI team for reconciliation of data, reports and also give new business requirement for making development in BI tools.
• Continuously monitor the existing base for its usage / revenue contribution (ideally existing customer definition is 90+ days AON)
• Ensure net worth of the existing base is retained. Develop and implement retention models to retain existing base.
• Develop New Segment as per market requirement – ULVC/LVC/GVC/HVC/UHVC –Smart phone User/Duel Sim users/Data users/SMS Users..etc
• Preventive measures to avoid revenue churn. Analyses customer usage, recharge behaviour and design predictive churn models to timely arrest the outflow of customers.
• Evolve revenue enhancement programs / products / initiatives with clear measures through SAS.
• Installation & Configuration of respective SAS Clients/Tools on user's Desktops.
• Responsible for all SMC Administration related tasks (user creation, group creation, library creation, managing security and permissions etc)
• Support Production, Test & Development SAS platforms.

• SAS Administrative work as involve in servers maintains.
• Understanding the business rules completely and implemented data transformation Methodologies.
• Creation and manage information map.
• Creation of Campaign Definition, Communication Definition, Export Definition and Business Context in SMC.
• Creation of Seeding list in SMC.
• Providing access to business context according to user needs.
• Creating campaigns using different nodes (Select, Multi Select, Limit, Communication, Cell, Split, And, Or, Export etc…) available in SAS CI and scheduling campaigns.
• Implement campaign diagram and schedule on flow to scheduler.
• Involved in end to end testing of CI campaign flow.
• Expertise in implementation and Administration of SAS Marketing Automation Solution.
• Expertise in trouble shooting of SAS Marketing Automation server issues and SAS CI client issues.
• Developed SAS Info maps used for Campaign Management and setup custom properties at Info map, Folder and Data item level.
• Updating metadata of info map in SMC.
• Scheduling Campaigns though scheduling server.

• Served as an escalation point for challenging technical inquiries, demonstrating expertise in product knowledge and problem-solving abilities.
• Conducted root cause analysis of technical issues, implementing preventive measures for future occurrences.
• Involved in understanding Business Process and coordinating with developer to get specific requirements.
• Handling various issues from multiple business team and Stakeholders and provide resolution based on SLA.
• Involved in preparing the complete design.
• Connected to ORACLE database and extracted relevant data (using Libname or Pass-through facility).
• Used Base SAS and PL/SQL for extracting data from different sources like Oracle database, flat files, transforming and finally loading into the target data warehouse.
• Used SAS procedures like PROC SQL, PROC MERGE, PROC SORT.
• Experience in generalizing code using SAS MACROS and creating incremental jobs.
• Used error and exception handling code.
• Used Enterprise Guide (EG) and SAS DI query builder to run queries against table.
• Scheduled all DI & EG jobs as per requirement using LSF.
• SAS Servers maintains and apply patches and hotfixes.