Home

Rajamohan - SAS Developer/Programmer

[email protected]

Location: St Louis, Missouri, USA

Relocation: YES

Visa: H1B

Rajamohan [email protected] Phone: (561) 830-6644 Summary: Highly skilled analytics professional with over 11+ years of experience in the analytics field and credit risk management, specializing in the multinational Banking and Clinical industry. Highly motivated and eager to learn new things, looking for an opportunity to give the best out of me so I can foster myself with the organization. Avid rational curiosity and the ability to mine unseen gems located within large sets of data. Able to leverage a mathematics and applied statistics with visualization for exploration of data. Good understanding of trial related documents such as Protocol, SAP, aCRF, and Specifications for SDTM & ADAM. Creation of ADAM Datasets by using specification and generation of tables and listings on safety and Efficacy. Worked in close collaboration with Statisticians in analyzing the Clinical Trial Data, generated reports, TLFs using SAS in accordance with the Statistical Analysis Plan (SAP). Experience in developing SDTM domains and ADaM datasets using Specification and SDTMIG. Highly skilled in SAS/BASE, SAS/EG, SAS/BI, SAS/Viya (SAS Visual Analytics), SAS EBI , Alteryx, Python, Microsoft Power BI, Tableau, Teradata, DB2, Big Data , Snowflake ,SQL Server and Oracle. Proficient in utilizing various SAS components, including SAS/Base, SAS/MACROS, SAS/ADVANCED, SAS/Enterprise Guide (EG), SAS/ACCESS, SAS/STAT, SAS/GRAPHS, SAS/ODS, SAS/DDE, SAS/CONNECT and Proc SQL. Monitor and identify suspicious activities in collections and recoveries using SAS Fraud Management to ensure early detection of fraud. Strong Knowledge in the SAS Business Intelligence (SAS BI) platform, including SAS Enterprise Guide (SAS EG), DI Studio, Stored Process, Information Map Studio, OLAP Studio, Web Report Studio, and Management Console. Seasoned in operating across UNIX, Mainframes, and Windows environments, with a demonstrated ability to seamlessly adapt to any operating system or environment. Proficient in utilizing various skills, including machine learning AI / ML, deep learning, data quality and validation, data engineering, data cleansing, data wrangling, data profiling and integration, data mapping, exploratory data analysis and reporting, data reconciling, data matching and data transformations. Proficient in statistical forecasting, SQL, Databricks, Tableau, WinSCP, Putty, UNIX, QlikView, Power BI, PowerPoint, AS400, Business Objects, Excel (Macros/VBA), data lake (warehouse), Agile and ETL Process. Utilize JIRA for task management and progress tracking, integrated with GitHub for code management and automated updates, to streamline regular reporting. Utilize project management skills to plan and execute projects, leveraging strong analytical and problem-solving skills to ensure timely delivery and address issues. Technical Skills: SAS Skills: Proficient in SAS/BASE, SAS/GRAPH, SAS/MACRO, SAS/SQL, SAS/ODS, SAS/STAT, SAS/EG, SAS administration and SAS Studio, SAS OLAP Server and SAS EBI . SQL Skills: Experienced in MSSQL, PROC SQL, MySQL, SQL joins, stored procedures, complex SQL queries, subqueries, RDBMS, SQL Data Definition Language (DDL), and SQL Data Manipulation Language (DML). Business Intelligence (BI) Tools: Proficient in Power BI Desktop, SAS Viya, Cognos, and Tableau for business intelligence and data visualization. Operating Systems: Proficient in Windows, Linux, Mainframe, and Citrix Systems. Databases: Experienced with Teradata, Oracle, DB2 , COBOL, Big data, Snowflake and Microsoft SQL Server databases. Other Tools: Proficient in SAS, SQL, MS Office, JIRA, GitHub, Python, Jenkins, Control-M/Autosys , Hadoop, Impala, Hive, Spark, and R and Visual Studio for various analytical and Regulatory reporting requirement tasks. Software Development Life Cycle (SDLC): Experienced in all phases of SDLC including Waterfall and Agile Models. Certifications SAS BASE certified professional from SAS Institute Inc. Education Details: B.E from Anna University, India 2011 Experience: Working as Software Engineer in Cenit Hub Inc from May2024- Till date. Worked as Lead SAS Developer in HSBC Bank from Jan 2013 Apr 2024 Project Immunology Clinical Trial Study USA , Remote Statistical Programmer-II May2024 Till Date Proficient in understanding of Study Protocol, Design document, SAP (Statistical Analysis Plan), and CRF (Case report Form). Involved in developing and validation of SDTM and ADaMs as per specification. Responsible to generate TLFs (Efficacy, Safety and Demographic). Responsible to Create and review Define.xml for ADaM. Involved to review the specifications as per client specific DES templates. Manipulating the character and numeric data by using SAS Functions. Created Summary Reports using Proc Report. Worked closely with the Statisticians, Clinical programming team to provide SAS programming in analyzing Clinical Trial Data. Addressing the comments provided by the Statisticians/Programming managers / Validators on Reviews and makes sure all the issues are addressed and ready to go. Coordinating with the team lead and the senior statistician Generating output files in the form of listing, DOC, RTF. Creating Macros for repeated programming. Environment: SDTM Programming, CRF review, ADaM Programming, SAS/BASE, SAS/SQL, SAS/Arrays, SAS/ODS, SAS/ACCESS, SAS/GRAPH, SAS/STATS, SAS/EG. Project - Collections and Recoveries Analytics -HSBC Bangalore, India Lead Data Analyst Jan 2021 Apr 2024 Write SQL/SAS queries to extract data from different sources such as Teradata/Oracle/ BigQuery using SQL Passthrough, Libname Facility, Proc Import, and other data access methods as per business requirement ( BRD ) . Gather business requirements and analyze user interactions with SAS to develop optimized Python solutions that enhance processes and user experience . Monitor and identify suspicious activities in collections and recoveries using SAS Fraud Management to ensure early detection of fraud. Analyze data and generate reports to evaluate and improve collections and recovery strategies. Develop and implement fraud risk management strategies and scoring models to enhance recovery operations and reduce bad debt.Developed a pre-delinquency strategy to identify customers who are highly likely to become delinquent soon. Developed the DAR & PQR Reporting project, which offers a comprehensive overview of operational metrics and delinquency for all products by analyzing data from the previous month. This includes insights on delinquency trends, movement rates, and volume, empowering collections strategy managers to evaluate past performance. In instances of abnormalities or deviations from expected trends, the project aids in identifying and investigating the underlying reasons. Responsible for leading loss forecasting initiatives for UK collections, including developing models, analyzing trends, and providing insights to support strategic decision-making. Implemented on a contact strategy that utilizes multiple contact channels to deliver the right message to the right customer at the right time, enhancing operational efficiency and effectiveness. Implemented Dialer Analytics devised various challenger and champion strategies to achieve efficiency of dialer channel. Some of the strategies are best time to dial analysis, PTP Analysis. Utilizing forecasting methodologies, developed a framework for forecasting the required capacity to ensure optimal utilization of resources through Capacity Planning. Conducted segmentation analysis utilizing both descriptive analytics and segmentation analysis techniques to identify potential risk drivers, thereby enabling proactive risk mitigation measures, as well as identifying opportunities for portfolio growth. I have utilized SAS Viya, Power BI and Tableau for data visualization and analysis, improving insights and reporting. Consolidated data from various internal and external sources to establish a centralized data mart, streamlining access for analytics teams and facilitating comprehensive analysis. Worked on regulatory reporting requirements for the European Banking Authority (EBA). Environment: SAS/BASE, SAS/Access, SAS/Macros, SAS/STAT, SAS/ODS SAS/GPAH, SAS/EG, SAS/STAT, SAS/Admin, Tableau, SAS Viya, Power BI, Advanced SAS , Python, SAS Fraud Management, SAS Grid Manager on Linux/Unix, AWS Cloud , PROC SQL Project - Model Management for Secured Loss Mitigation -HSBC Bank Bangalore, India Senior data Analyst, Analytics Jul 2019 Dec 2020 Developed multiple Collections contact strategies for Credit Cards, Personal Loans for USA region. Developed and maintained mainframe-based applications, leveraging JCL for efficient job scheduling, resource allocation, and managing batch processes for large-scale data processing. Responsible for monitoring, analyzing and providing an in-depth analysis of the trends for all collections KPI s for USA, Canada region and present it to the business partners and senior managers in monthly risk forums. Responsible for monitoring all the existing collection strategies performance for different products. Optimized JCL jobs for better performance on mainframe systems, resolving job failures, and implementing error handling procedures to ensure smooth data processing and reporting. Created Keep/Place/Sell Recovery strategy and recovery strategy monitoring dashboard. Enhanced monthly Foreclosure/REO dashboards and provide monthly walkthrough to senior managers. Responsible for all the FAPII (Foreclosure Avoidance Program) modifications activities to mitigate the losses. Handled quarterly PD (Probability of Default) model monitoring to measure the model strength and stability. Handled the complete data preparation part of CCAR (Comprehensive Capital Analysis and Review) payment shock model which is used to evaluate the modification payment. shock part in default rates. Environment: Mainframe, JCL,SAS/BASE, SAS/Access, SAS/Macros, SAS/STAT, SAS/GPAH, SAS/EG, SAS/STAT, Tableau, SAS VIYA, MS Office & PROC SQL. Project - Contact Management Analytics for USA Collections Bangalore, India SAS Developer, Analytics Jan 2018 - Jun 2019 Analyze customer contact data to identify trends, Planning and Demand Forecasting ,patterns, and opportunities for optimization. Design and develop SAS programs for data extraction, transformation, and reporting on mainframe systems, ensuring efficient handling of large datasets for business analysis. Use JCL (Job Control Language) to schedule, execute, and monitor SAS jobs on mainframe environments, ensuring optimal resource usage and performance. Responsible for compiling data and generating inbound, outbound, and AHT reports. Contributing towards tracking the Abandon rate, penetration rates, RPC, NORPC, PTP on daily weekly basis and guide the OPS team if any discrepancy by analyzing the data. Monitor and optimize collections dialer performance parameters, such as abandonment rates, and right-party contacts (RPCs). Contributing towards tracking the Abandon rate, penetration rates, RPC, NORPC, PTP on daily weekly basis and guide the OPS team if any discrepancy by analyzing the data. Overall responsibility for the performance and efficiency of the call center. Defines key performance indicators (KPIs) and targets for inbound, outbound, and AHT reports. Implemented contact management & best time to call strategies to optimize dialer calling based on collection metrics. Identified outliers and skill gaps in analysts, recommending targeted training to balance increased call volumes, particularly during high In-bound calls for Payment holiday post-Covid. Create SAS datasets and data structures optimized for collections dialer reporting needs. Implement data cleansing and validation processes to ensure data accuracy and integrity. Develop and maintain regular and ad-hoc reports to support business decision-making. Environment: SAS/BASE, Mainframe, SAS/Access, SAS/Macros, SAS/STAT, SAS/ODS SAS/GPAH, SAS/EG, SAS/STAT, SAS/Studio, Tableau, SAS Viya, Power BI, Advanced SAS & PROC SQL. Project - Back Office Optimization Project Bangalore, India SAS Data Analyst, Analytics Oct 2015 Dec 2017 Analyze back-office processes and workflows to identify areas for optimization. To consolidate data retrieval and circumvent the need for extracting data from multiple database sources, the approach involves directly extracting data from the Teradata hub system using SAS tools. Integrated various SAS reports into a single comprehensive report. This consolidated report facilitated the access grant process for new employees; including business drive access, SharePoint access, intranet access, and other necessary permissions. Additionally, the back office team exclusively retrieved data from the back office tool, ensuring streamlined access and data management. The Back Office Optimization Project led to significant improvements: Enhanced productivity, accuracy, and timeliness, resulting in heightened customer satisfaction. Rapid identification of improvement opportunities facilitated streamlined and lean processes. Implementation of bias-less scientific and risk-based sampling techniques resulted in improved quality. Efficient and accurate tracking of employee productivity and peer comparisons. Elimination of individual volume tracking log sheets. Implementation of transactional quality evaluation and feedback with agent acknowledgment. Monitoring of performance variability and identification of behavioral risks. Structuring data to suit all reporting needs, ensuring data security. Complete automation of all operational reports. Environment: SAS/BASE, SAS/Access, SAS/Macros, SAS/STAT, SAS/GPAH, SAS/EG, SAS/STAT, MS Office, SQL Server, SAS OLAP Server and SAS EBI ,Teradata & PROC SQL. Project DPA, Insolvency & Zero MI Project Kolkata, India SAS Programmer, Data & Information Management Jan 2013 Sep2015 Developed and automated SAS-based operational reports to eliminate the need for manual intervention, ensuring adherence to critical SLAs. Addressing warehouse table dependencies and time-consuming older processes, I built several collections data marts and automated 77 individual SAS codes, resulting in a more effective and efficient execution process. Rationalized numerous reports, effectively reducing the workload equivalent to 2 full-time employees (FTEs). Key actions included eliminating unnecessary reports, consolidating similar reports, creating single processes for related tasks, automating email notifications using SAS, generating reports without manual intervention, automating intranet versions, and running time-consuming codes in batch mode through the BI team to create daily databases. Migrated various MI reports for different portfolios across all brands. Designed visual analytics featuring charts, pivots, and tables, resulting in highly interactive dashboards. Expertise in SAS automation, code optimization, and dashboard enhancements. Ensured seamless operation and reliability of SAS production automated jobs (Control-M) by employing various debugging techniques to identify and resolve issues efficiently. Experienced in generating various ad-hoc reports for analyses by collaborating with onshore teams and independently handling requests. Automated existing Excel files using SAS, focusing on code optimization and dashboard enhancements. Created a dashboard by coordinating with the risk analytics team to gather data. Optimized existing SAS codes and created dashboard/MIS reports at the portfolio level. Provided SAS training to team members and at the organizational level. Implemented DPA Pause and Resume functionality to ensure compliance with data protection regulations. Perform remediation analysis to identify and address policy issues and customer impacts. Executed UAT on SAS code to validate functionality and ensure compliance with user requirements. Environment: SAS/BASE, SAS/Access, SAS/Macros, SAS/STAT, SAS/GPAH, SAS/EG, SAS/STAT, SAS/Studio, SAS/DDE, SAS OLAP Server and SAS EBI, MS Office, SQL Server, Teradata & PROC SQL. Awards and Achievements Received Emerging Leader Award for delivering promise to regulators in 2020. Received Multiple Leading Light & Team Star for outstanding service delivery. Received You Save You Earn Award for rationalization & automation project in 2015. Keywords: artificial intelligence machine learning business intelligence active directory rlang information technology golang microsoft Michigan