MuraliKumar S

Having 12+ years of experience in SAS in Analysis, Design and Development in the areas of banking, Insurance, healthcare, Comcast & Retail domains. Working on SAS/Base, Advance SAS/ MACRO, SAS/Access, SAS DI studio, Web Report Studio, Stored process, SAS EG, SAS Management Console, UNIX. Experience in BI tools such as SAS-VA, Tableau, SAP BO, Web Report Studio, BI Dashboard. Hands-on experience in Business Requirements Gathering, creating High level & Low-level design documentation. Strong SAS programming background for creating, maintaining existing code, ad-hoc reporting and supporting the reporting functions. Possess strong ability to quickly adapt to new applications and platforms. Excellent ability in problem solving, data analysis, complex reports generation. Expertise in doing the peer reviews for the work requests managed by the team and guiding them with the better approaches possible.

Seeking challenging assignments in data analytics and AML in an exciting organization where my leadership, strategic planning, and project management skills will contribute towards the growth and success of the organization.

• Awarded "Shining Star", for performing exceptionally well in data testing project, which involved Regression testing
• Awarded "performer of month "for migration of reports from Access to SAS in Aetna-2018

Mashreq bank, 02/2024, present, Sr consultant (SAS AML for Pak), Contract with value soft working in Mashreq bank, Windows SAS AML 7.1, SAS 9.4 Enterprise and BI Server., SAS, SAS DI, SAS AML 7.1, Python, data bricks, oracle, Teradata, DB2, AML is a governance system for Anti Money Laundering and this system is used to generate the ALM feed files for all the financial activities that happened at source applications. AML system had dependency on multiple source systems and multiple technical tools with complex architecture of application which was causing the stale data and delay in process of APM feed files. As part of AML Write the AML architecture is re-designed and integrated with individual source system to process the APM feed files., Analyzed the business requirements and translated them into technical specifications., Participated in effort estimation and delivery planning., Developed and enhanced various SAS AML scenarios as per the business requirements., Made necessary changes to SAS AML core model to get additional data from Banking systems., Worked closely with compliance officers and risk management teams to develop AML strategies and enhance existing models., Preparation/Documentations of SDD and Writing unit and integration tests cases., Created efficient SAS DI flows to extract and transform high-volume data from the Oracle database and flat files., Developed various ETL jobs to extract, cleanse, transform, integrate and load data into Data Marts., Delivered detailed gap analysis with field level mapping and logic., Deployment of SAS DI jobs and scheduling the deployed jobs by using SMC, Designed and deployed code deployment and release management process. Thryve digital health llp, 09/2022, 02/2024, Sr consultant (SAS to python conversion), Thryve digital health llp US, Windows and SAS 9.4 Enterprise BI Server., SAS, SAS DI, Python, data bricks, oracle, Teradata, DB2, The nature of this project is to convert existing SAS projects to python environment to support development and enhancement of business for all product e.g.: HEDIS and AIP, The SAS ETL Remediation team analyzes the existing SAS programs to capture the functional and technical possibilities for converting SAS to phyton., Understand and determine the target technology for the internal and external data source transformation from a physical server to Google Cloud., Analyse and finalize the relevant access and environment required for the SAS to Python migration., Create a regression document to point out cataloging attributes and concepts following the SAS to Python migration., Testing an individual model of an application in isolation to confirm that the code is doing things right and additionally identifying for optimization., Ensuring different models are working fine when combining as a group., Mock data generation unit testing remediation applying data validation framework., Ensuring results match existing sources (SAS and converted results), Automate the workflow integration of job sequencing and scheduling in a development environment., Create a deployment document for the lower environment and run it for a couple of weeks to ensure no impact on runtime or results., Document all the technical and functional steps followed during migration and share best practices for key topics., Finally, get approval from the client side to move the migrated Python programs to production., Responsible for the transfer of technical knowledge to facilitate implementation of the business solution provided. Wipro, 09/2022, 12/2022, HRO Lead Programmer Analyst, Alight, Windows and Mainframe, SAS, JIRA, Execute requirements in mainframe as per requirement and validate result., The results are uploaded to tool for client access., The report contains employee-related information for US region., Explaining requirements to team for completing task, Automating reports required for stake holders to reduce manual intervention., Document all SAS programs developed and write other documentation as needed. Identify and share best practices for key topics., Responsible for transfer of technical knowledge to facilitate implementation of the business solution provided. Société general, 07/2019, 09/2022, Lead SAS AML Analysist, Société general US, Windows and SAS 9.4 Enterprise BI Server., SAS BI and SAS DI, SAS AML, WinSCP, Putty, Tableau, TWS, Teradata, JIRA, AML is a governance system for Anti Money Laundering and this system is used to generate the ALM feed files for all the financial activities that happened at source applications. AML system had dependency on multiple source systems and multiple technical tools with complex architecture of application which was causing the stale data and delay in process of APM feed files. As part of AML Write the AML architecture is re-designed and integrated with individual source system to process the APM feed files., Running monthly AGP process to trigger Fraud transaction based on different AML Scenario, Working as Lead for requirement gathering, design & developing code to fulfil the requirement., Extract data from relational databases and perform complex data manipulations. and generating report based on frequency (to identify fraud transition), Extensively worked on design and develop of SAS programs for data scrubbing and schedule job in AutoSys future monthly execution., Automating reports required for stake holders to reduce manual intervention., Document all SAS programs developed and write other documentation as needed. Identify and share best practices for key topics., Responsible for transfer of technical knowledge to facilitate implementation of the business solution provided. Cognizant Technology Solution, 03/2016, 07/2019, SAS DI ETL optimization, Walt Disney US, Windows and SAS 9.4 Enterprise BI Server., SAS BI and SAS DI, WinSCP, Putty, Tableau, TWS, Teradata base, working in model building, forecasting future trend and BI Reporting, Creating DI Jobs using Various Transformations in SAS DI Studio and loading data to target location., Used predicative analytics methods to forecast Disney resort booking., Responsible for analyzing and validating existing models as per requirement and documenting of final changes., Evaluated and optimized existing processes and designed technical documentation., Extensively worked on SAS stored processes and SAS EG & Tableau to create various Reports to show the trend. Cognizant Technology Solution, 03/2016, 07/2019, SAS Reporting, Aetna, Windows and SAS 9.4 Enterprise BI Server., SAS BI and SAS DI, Winscp, Putty, Tableau, TWS, Teradata base, Directly working with businesspeople to create BI Reporting and report Migration. The source files received from various source systems like salesforce, HEDIS, Appeals etc. The Reports are delivered tableau or SAP BI web reporting., Responsible for analyzing, Requirement Gathering, Implementation, designing and developing/automating & supporting strategies, Enhancement., Migrated access database report to SAS environment., During migration majorly concentrated on analyzing code and business logic implementation., Writing Shell Scripts for automating manual activities, Responsible for Quality assurance testing, Quality assurance support, System integration testing, Unit testing, reviewing and delivering quality documentation after each delivery., Act as Point of contact (POC) and Worked with Functional Team in Onshore/Offshore to clarify requirements and translate the requirements into technical specifications. Cognizant Technology Solution, 03/2016, 07/2019, GFRL (Group functional reporting layer), KBC Bank (Belgium), Windows Unix and SAS 9.4 Enterprise BI Server., SAS BI and SAS DI, WinSCP, Putty, TWS, Tableau, DB2, KBC is a largest bank and insurance company in Belgium. The aim of this project is to create a warehouse for daily and monthly reports at group level and few reports for regulatory purposes. Get extract from source on daily basis in CSV format then read it into SAS intermediate tables. Finally load it into target using fact and dimensional modeling. On top of that, creating daily and monthly reports., Arrange meetings with business to collect business requirements and batch related issues., Understand the current processes to identify functional and technical feasibility to deliver this project., Discuss with onsite Design, Technical Review team then prepare System Requirements and Technical Specification documents., Coordinate with source team and arrange the FTP job, it copies the files from source location to our server., Write LINUX/UNIX Scripts to copy, move, delete or archive the source files and UNZIP required files for further processing., Creating and scheduling jobs for data extraction part, applying data transformations and validation check while loading SAS data sets and SAS views., Generating target tables from source tables by using transformations like External file reader, Extract, User written, SCD TYPE 2 Loader, do loops, Table loader, Format creation, Sort, SQL joins, Append and Splitter in SAS/DI studio., Create packages and coordinate with infrastructure team for package migration., Participate in pre and post implementation activity. Cognizant Technology Solution, 03/2016, 07/2019, Suspicious order monitoring, CVS Healthcare, Windows Unix and SAS 9.4, SAS BI and SAS DI, WinSCP, Putty, TWS, Oracle and Teradata, This involves monitoring the suspicious drug purchased by the customer or drug sold by the stores from the distribution center and outside vendors. So, we need to send out files to distribution centers regarding the purchase details of each drug from all drug stores. In order to perform the above activities on a huge population, batch jobs that run on operating systems were made use along with SAS programs for generating file to share with client., Responsible for offshore development and deliverables including coding, test plans, Regression analysis and weekend support for manual jobs running testing the code., Creating SAS Programs to pull the data from the DB2., Created and maintained SAS Data sets that are extracted from an Oracle Database., Support new implementation and Post deployment of Jobs., supporting the team for technical issues Coding and Testing, Coordinating with the onsite for new development and deliverables., Documenting new changes and getting sign off from client side. WNS Global Services, 05/2012, 03/2016, Analyst, AVIVA Life, Uk, Research & Analytics, Windows Unix and SAS 9.4, Mainframe, SAS BI and SAS DI, Putty MS Access and Excel, Tableau, VBA, Creating a centralized data mart for life insurance Business by extracting the data from flat files and formatting the data as per the business rule and storing the data in the centralized Data Mart using SAS and automating the existing process flow, Conducting in-depth analysis for wide variety of life insurance products Bonds, Protection, Pensions, Annuities etc., by processing millions of data elements from various data systems., These Analysis provide the latest persistency information. Which are being used by, finance reporting, product designing, CMI, pricing and Actuaries’?, Analyzing Projects for future improvements and process redesigns, developing various data models for Measuring and Monitoring the Business metrics for the top management in making business discussions (Generalized linear regression models, Logistic regression models etc.), Identify trends affecting the business, and articulate implications to upper management., Efficient and capable of gathering data through complex Data Warehouse queries and prepare various ad-hoc requests and presenting accurate information to the client specific format (SAS, Excel, MS Power point, DCS and glean output) Sutherland Global service, 02/2011, 05/2012, Analyst, Direct path, FTP, Team Member, Windows Unix and SAS 9.2, SAS, MS Access and Excel, PPT, Preparing MIS reports using Business Intelligence Tools (SAS, MS excel and MS access)., Generating and analyzing the employees Calls handled, AHT, CSAT, Calls flow, Calls Disconnected, Shrinkage, Team wise Performance, Manager Wise performance, analysis etc., Daily, Weekly and Monthly Dashboard Scheduling, preparing analysis reports., Handling the various Ad-hoc queries from program satisfying client and manager’s need in the priority basis and sending appropriate correspondence to all applicants in a timely manner., Primarily using SAS, Excel and Minitab, monitoring and analyzing the monthly performance and profitability of both Agent’s and Team vise IBM, 02/2010, 02/2011, Analyst, IBM, Team Member, Windows Unix and SAS 9.2, MS Access and Excel, PPT, PeopleSoft, Driving compliance within TAU for South Zone., Driving team projects, coordinating with stake holders on closing hiring numbers, Documenting discrepancies and process adherence., Creating monthly and weekly hiring reports., Maintaining Hiring Cost for the different LOBs within IBM, focused on streamlining & improving., Manage the MIS for Recruitment &Training analyses numbers, which helps the leadership team in decision making, Communicate and co-ordinate with immediate and senior leadership and deliver reports based on the requirements on a daily, Weekly, Monthly and Quarterly Basis across south zone of IBM GPS.