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 10 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 10 months

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

SAS Developer/Data Engineer

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

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

Python Developer

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

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

SAS Programmer Analyst

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

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

Application Developer

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

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

ETL Tester

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

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

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?