Mohd Anas Email and Phone Number
Having 5+ year of Experience in SAS and SQL Analysis and Development particularly in the areas of HR Payroll and Outsourcing.Delivered US Benefits administration solution pertaining to Defined Benefits(DB), Defined Contribution(DC) and Health Management(HM).Worked for extracting, manipulating, summarizing, analyzing and presenting data using SAS procedures. Experienced in debugging SAS code to get the required result using SAS EG.Experienced in SAS/SQL for extraction and transformation of data using Z/OS (Mainframe) and DB2 techniques to load data.I have experience in converting client requirement into technical specifications by writing SAS programs and SQL Queries to match the specifications.Extensively used SAS procedure and function to manipulate existing data and to create derived variable. Experienced in Robotics using UI Path to automate some part of the process and reducing manual efforts in achieving quality delivery of product.Performed Unit testing based on different test cases through various inbuilt tools and generate required document design. Spearheaded design, build, implementation and optimization of BI solution including ETL, Data warehouse and Reporting.In case of Job failure Analysis of the data received from multiple interface and Job fixing.Follows Software Development Life Cycle to do Analysis, Configuration and Unit Testing.
Exl
View- Website:
- exlservice.com
- Employees:
- 20487
-
Assistant ManagerExl Oct 2024 - Present--> Developed SAS codes using various function and Implemented Macros on SAS EG as per client requirement.--> Automated the Excel process in SAS for Monthly, Quarterly and Yearly reporting.--> Optimized existing code to improve performance and accuracy.--> Perform data analysis to identify trends, patterns and insight. Implemented SAS code for predictive and data driven decision support. --> Create reports and visualization to communicate finding to stakeholders.--> Performed various Joins in SQL for debugging and analyzing the data.Client : Presbyterian -
Business AnalystExl Apr 2022 - Sep 2024-->Understand key aspects of Client business and perform extract, transform, load and data analysis from client data.--> Converted existing SAS code from fetching the data from table to Data Mart and created the Entity Relationship diagram for betterment of writing the code.--> Performed various testing of the code to get the expected data to meet the client requirement and created the documentation of the code.--> Identify the areas of enhancement and automated the production in SAS which reduced model output delivery time.--> Perform Quarterly monitoring to track the model performance and identify the root cause in case of model performance breaches the threshold. -
Senior Batch SpecialistWipro Dec 2020 - Apr 2022-->Worked on Healthcare Analytics closely with onshore and offshore teams.-->Developed SAS codes on mainframe platform as per client requirement.--> Created queries to update the the existing table under Data Manipulation Language. -->Worked on HRIS model for a Healthcare client to enable easy, quick yet high quality HR data changes communication between clients and Batch Team.-->Configured of HR Reformatter using SAS code to read the file and creates transactions to load to the database after performing certain levels of analysis.-->Implemented the logic involved behind data loading, client reporting and data manipulation using SAS codes and SQL queries.--> Debugged the error in existing codes and provided root cause analysis and code fix resolution.--> Participated in client meeting as a technical expert and also developed SAS codes for complex requirement.-->Managed a large number of projects, worked closely with teams leads to appropriately prioritize projects.--> Worked form start to end on Annual Enrollment on various clients.Client : American Express & Transform Corporation -
Associate AnalystWipro Dec 2019 - Nov 2020-->Restarted the Batch Job failure analysis of the data received from multiple interface.-->Created Jobs for different process flows and Ad-hoc Query for reporting requirements.--> Analyzed existing SAS/SQL codes to identify opportunities for Improvement and make it more efficient.--> Extensively used Proc SQL to perform Queries, Join tables, merge data from mainframe database(DB2).-->Designed test plans and follows back tracking technique to existing code to upgrade to new platform.-->Automated some process to reduce the manual effort.--> Participated in Annual Enrollment for the best delivers. -
Associate Analyst TraineeWipro Limited May 2019 - Nov 2019--> Executed Batch Jobs by submitting the SAS codes using JCL on mainframe(TSO-ISPF) platforms.--> Scheduled Batch Jobs using Control-M with the help of share point to execute SAS codes on different frequencies.--> Used ADX(application of ETL) to automate Queries.--> Created documentation on MS -Excel to fulfill the client requirements. -
Back End Developer InternClick Labs Jan 2019 - Apr 2019--> Worked on Node JS for the implementation of APIs and used MySQL for development of the Project.--> Used Postman for building APIs and created Socket for building the chat room.
Mohd Anas Skills
Mohd Anas Education Details
-
Master Of Computer Applications - Mca -
Bachelor Of Computer Application - Bca -
Stella Maris Convent Sec School Sultanpur
Frequently Asked Questions about Mohd Anas
What company does Mohd Anas work for?
Mohd Anas works for Exl
What is Mohd Anas's role at the current company?
Mohd Anas's current role is Business Analyst at EXL || Ex- Wipro || SAS || SQL || Healthcare Analytics || 5+ Years Industry Experience.
What schools did Mohd Anas attend?
Mohd Anas attended Integral University, Lucknow, Uttar Pradesh, Integral University, Lucknow, Uttar Pradesh, Stella Maris Convent Sec School Sultanpur.
What skills is Mohd Anas known for?
Mohd Anas has skills like My Sql, Sas Programming, Ibm Db2, Ibm Mainframe, Aws, Javascript, Node.js, Mongodb, Job Control Language, Databases, Html, C (Programming Language.
Who are Mohd Anas's colleagues?
Mohd Anas's colleagues are Siddharth Rai, Robin Thomas Ponnuraj, David Macgrayne, Nirali Singh, Bhupesh Nijhawan, Ambrithraj Sebastian, Mohammad Akbar.
Not the Mohd Anas you were looking for?
-
1gmail.com
-
3artechinfo.com, gmail.com, compunnel.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial