Mohammed Subhani

Mohammed Subhani

Senior Consultant
India

About Me

9+ years of Progressive IT experience in Development/Support
Excellent knowledge and hands-on experience in Base SAS, Advanced SAS, SAS Enterprise guide, Data Integration.
Created reusable MACROS and extensively used exi…

Experience

Sas Programmer

ARK INFOTECH Spectrum Pvt LTD
Dec 2022 - Present · 3 years 7 months

Performing ETL activities, connecting to RDBMS databases and generating SAS datasets.
Accessed and analyzed the data based on the requirement using SQL, SAS and MS Excel
Development and implementation of solutions to bank finance team regarding customer information and products.
Perform any post production changes or enhancements to the SAS programs like SAS reconciliation report or monthly batch runs.
Performing data analysis, data migration, data preparation, graphical presentation, Statistical analysis, reporting, validation and Documentation.

Senior Consultant

ARK InfoTech Spectrum Pvt. Ltd.
Dec 2022 - Present · 3 years 7 months

Accessed and analyzed the data based on the requirement using SQL, SAS and MS Excel
Development and implementation of solutions to bank finance team regarding customer information and products
Performed post production changes or enhancements to the SAS programs like SAS reconciliation report or monthly batch runs
Performed data analysis, data migration, data preparation, graphical presentation, statistical analysis, reporting, validation and documentation
Analyzed large data sets consisting of million records using PROC SQL, PROC SORT, PROC PRINT, PROC TABULATE procedures
Retrieved the original data and converted them into SAS readable format
Made the SAS data sets and analyzed data as per given requirement
Interactively met with the Actuarial teams for getting the required data to generate the reports as per business requirements
Developed and analyzed key performance indicators relevant to emerging business needs using PROC FREQ, PROC TABULATE, PROC MEAN, PROC UNIVARIATE, PROC GLM, PROC TTEST, PROC TRANPOSE, and DATA NULL
Generated listings and reports from SAS programs using MACROS, ODS and PROC TEMPLATE/REPORT/TABULATE and using Word, Excel and PowerPoint
Generated reports to communicate key findings and articulate strategic implications using PROC PRINT, PROC REPORT, PROC TABULATE, PROC MEAN, PROC GPLOT and PROC GCHART
Documented purpose and methods used in each SAS program

SAS Developer/Data Engineer

Danske Bank
Mar 2020 - Jan 2022 · 1 year 10 months

Accessed and analyzed the data based on the requirement using SQL, SAS and MS Excel
Development and implementation of solutions to bank finance team regarding customer information and products
Performed post production changes or enhancements to the SAS programs like SAS reconciliation report or monthly batch runs
Performed data analysis, data migration, data preparation, graphical presentation, statistical analysis, reporting, validation and documentation
Analyzed large data sets consisting of million records using PROC SQL, PROC SORT, PROC PRINT, PROC TABULATE procedures
Retrieved the original data and converted them into SAS readable format
Made the SAS data sets and analyzed data as per given requirement
Interactively met with the Actuarial teams for getting the required data to generate the reports as per business requirements
Developed and analyzed key performance indicators relevant to emerging business needs using PROC FREQ, PROC TABULATE, PROC MEAN, PROC UNIVARIATE, PROC GLM, PROC TTEST, PROC TRANPOSE, and DATA NULL
Generated listings and reports from SAS programs using MACROS, ODS and PROC TEMPLATE/REPORT/TABULATE and using Word, Excel and PowerPoint
Generated reports to communicate key findings and articulate strategic implications using PROC PRINT, PROC REPORT, PROC TABULATE, PROC MEAN, PROC GPLOT and PROC GCHART
Documented purpose and methods used in each SAS program

Python Developer

Danske Bank
Mar 2020 - Jan 2022 · 1 year 10 months

Accessed incident data and customer data on monthly, quarterly, and yearly basis to generate dashboard and insights as per requirement
Created insights on the spending of credit cards transaction
Enabled Google Maps API in the mobile app for suggestion regarding the transaction trend

SAS Programmer Analyst

Labcorp (previously Covance Development Services)
May 2019 - Mar 2020 · 10 months

Development and implementation of solutions to global technical service issues and concerns regarding EDC tools like Medidata RAVE, Oracle InForm and SAS programming
Maintained a comprehensive data base for subject information
Processed Machine and Program medical trails data
Central scheduling of these data
Kept an accurate database for each medical study

Application Developer

IBM ACCOUNT Canada
Feb 2015 - May 2019 · 4 years 3 months

Maintained a comprehensive data base for Customer and Sales information
Processed Machine and Program product orders
Central scheduling of these orders
Central control of returned machine
Kept an accurate inventory of Products

ETL Tester

IBM ACCOUNT Canada
Feb 2015 - May 2019 · 4 years 3 months

Understood the existing system and the flow of data
Prepared specifications to create new Data model by coordinating with Data Architect and DBA
Extensively involved in reviewing and analyzing the business and functional requirements
Prepared High Level and Low-Level Design specifications
Reviewed the ETL design, mapping documents, and provided suggestions
Prepared the review checklist and test case templates
Created test data, test scripts, performed testing and reviewed test results

Skills

Information Systems Management Statistical Analysis System (SAS) Structured Query Language (SQL) PySpark SAS/Graph SAS/SQL Relational Databases Data Reporting Base SAS Advanced SAS SAS Enterprise Guide Data Integration Macros Data Cleaning Data Manipulation Data Sorting Data Merging Data Migration Data Preparation Data Analysis Reporting Validation Documentation PROC SQL PROC SORT PROC PRINT PROC TABULATE PROC FREQ PROC MEAN PROC UNIVARIATE PROC GLM PROC TTEST PROC TRANPOSE PROC CONTENTS PROC REPORT PROC FORMAT PROC SUMMARY ODS PROC TEMPLATE PROC GPLOT PROC GCHART Python Data Wrangling EDA Data Visualization Matplotlib Seaborn SAS Visual Analytics QMF for Windows Microsoft Excel Tableau IBM Infosphere DataStage DB2 JCL PL1 Agile Waterfall
Report this Profile?