SAS Expert

Enrich client-side experience as well as enhance overall functionality and performance by developing software solutions in co-ordination with multi-faceted design teams. Drive data extraction, evaluation, as well as retrieval and indexing by identifying, designing, and deploying scalable applications. Deliver insight on computer programming to project team members by serving as subject matter expert. Correct faults or improve performance by maintaining current application, while designing and delivering new applications. Leveraged Automic Automation to develop and schedule SAS DI Studio ETL Jobs.

• Rectified coding errors and optimised overall performance by amending prevailing SAS Macros.
• Evaluated historization process for new SAS data warehouse and setting the guidelines for new data warehouse.

Captured more information about risk management objectives and performance measures by creating scorecards for risk management in the field of construction loans. Co-ordinated entire facets involved in development of SAS Base Code, SAS Macros, and automated SAS reports. Gathered all technical information needed to access the data by developing data sources and reports with SAP Business Objects WebI. Drove data trends assessment and forecasts/data evaluation by creating Tableau reports for different stakeholders.

• Decreased licensing costs by swapping proprietary SAS scheduling Tool with standard software Automic.

Drove cleansing and validation of information through data Integration by effective utilisation of SAS Base, SAS Macro, SAS Data Integration Studio. Tracked performance, identified trends, analysed data, and aligned performance to overall goals by deploying new reporting system by leveraging Microsoft SQL Server, MS SSIS, SSAS, SSRS.

• Pitched and implemented Microsoft SQL Server based reporting solution for local bank.
• Reduced operating costs and improved functionality by revamping, modularising, and updating old code bases to modern development standards.