We provide IT Staff Augmentation Services!

Sas Specialist Resume

4.00/5 (Submit Your Rating)

SUMMARY:

  • An all rounded BI specialist with skills in ETL and report development on various combinations of development platforms.
  • Brings experience in banking and real estate industry along with in depth technical skills relating to data warehouse implementation, BI development as well as ETL development and deployment.
  • Valuable experience in SAS Credit Risk and Scoring solution will also bring value to clients.
  • Excellent learning ability as required in the fast paced world of business intelligence, with focus on achieving the best results on any given project or tasks.
  • Flexible with matching SAS enterprise tools with reporting requirements.
  • Experienced with most tools related to reporting solutions e.g. Stored Procedures, Information maps, Shared prompts etc.
  • Combination of the tools above that can have an enterprise wide reach.
  • For instance a stored process can be written in a way that can be run by much of the enterprise via a web browser.
  • The information map can be designed in a way that will minimize effort of repeatedly matching, merging and looking for data in multiple places, saving precious human resource.
  • Dashboards could be designed to alert stakeholders of internal boundary breaches.
  • Presented on how DI Studio can be used as a documentation tool for reporting, and even be used by reporting personnel to create reports or part of their report.
  • A brief and basic presentation was given to Sydney’s SAS user group, the presentation can be found here:
  • Advanced skills in SAS Base/Macro scripting
  • Experience using DI Studio to create ETL jobs (from defining source/target database machines and libraries in metadata to utilizing them in individual ETL jobs).
  • Flexible to use Base SAS or Oracle base utilities such as Toad to analyse data in Oracle database.
  • Involved in prototyping where data was temporarily extracted from Oracle database to SAS tables for analysis to be done on the data. Data was analalysed using Base SAS in Enterprise Guide for defects and relationship integrity among other things, thereafter processes created in prototyping process is used as base in ETL design.
  • Personally troubleshoot some minor Oracle problems (such as mistakes in TNSNAMES.ORA file and Oracle log archiving problems) that affect SAS jobs.
  • Familiar with common problems with SAS - Oracle interface (such as instance where job aborted in SAS but still stuck in Oracle machine).
  • Recently involved in project where SAS 9 was used to create data warehouse which source and target data is using Oracle database.
  • Co designed high level ETL process for a SAS end to end cube project.
  • Wrote ETL at staging to end transformation level producing final dimensional and fact tables with a team of developers.
  • Enhanced design with the use of error tables to catch mismatching dimensions.
  • Had prior experience in developing ETL processes by hand (scripting) and deploying to production environment in UNIX and mainframe.
  • Combined SAS scripting with UNIX shell scripting before deploying to servers.
  • Some things that are not done with SAS are done with shell scripts (such as OpenSSH file transfers, file system cleanups etc.)
  • Scheduled DI Studio scripts with schedulers like JS scheduler.
  • In cases where SAS schedulers are not available but in it’s place, something like Control-M, SAS scripts are enveloped in UNIX shell scripts. Most of these scripts developed have logging capabilities.
  • Maximized server performance by strategically placing target tables and working storage tables.
  • Have experience restoring SAS server processes in UNIX in case technical support isn’t around.
  • Familiar with file transfer protocols like FTP, OpenSSH and some other less well known.
  • Systems that I’ve worked with include AIX, Linux and Solaris.
  • Rolled out updated versions of scoring models.
  • Rolled out new variables / ETL for new models via ABT.
  • Traced root causes of symptoms in output tables from input ETLs to output from models coupled with solution.
  • Occasionally gone through risk engine codes in investigations to determine symptoms of Probability of Default behaviour.
  • Help troubleshoot and understand problems with risk engine job failure.
  • Where ETL processes are developed by myself, I have always prepared test cases and documentation for each of the process involved.
  • Have experience with many documentation and development guidelines including CMMI.
  • Had many experiences to a degree that I am able to recognize what kind of test is appropriate in certain situations and the realistic expectations.
  • Ensured every case is passed before proceeding to the next stage.
  • Prepared well documented templates to users for them to record their findings and results.
  • Worked with users to generate appropriate tests.
  • Support queries from users on the fly.
  • Worked with users between test cycles on any defects they have found and document them appropriately.
  • Ensure user satisfaction before sign-off.

SKILL SUMMARY:

Programming

Base and macro SAS, SAS ODS, SAS Enterprise Guide, Web Report Studio, SAS DI Studio 4.2

COBOL

EZtrieve

Hyperion Brioquery

Tibco BusinessWorks Designer

Reporting /Analytics

SAS Information Maps

SAS Stored Processes

SAS Enterprise Miner

SAS Credit Scoring Solution

SAS Risk Management System Solution

Database

Oracle 9i - 11i

IBM DB2

MySQL

Hyperion Essbase

Operating platforms

AIX

Solaris

Linux

Windows

Change management and scheduling

Control - M (MVS)

JS Scheduler

SAS Management Console

Endeavor

Office

Microsoft Word, Excel (including macro), Access, Powerpoint

Data modeling

Erwin Data Modeller

OS scripting

DOS batch

OS-390/z-OS JCL

Shell scripting

EMPLOYMENT HISTORY:

Confidential

SAS Specialist

Responsibilities:

  • Invest and speculate in real estate market
  • Invest and speculate in worldwide equities and derivative markets
  • Education to be a professional trader

Confidential

SAS Specialist

Responsibilities:

  • Revisit physical prep and training
  • Enforce mental preparation for competition
  • Making finals alongside country’s top drivers
  • Complete final showdown in Sepang international circuit

Confidential

SAS Specialist

Responsibilities:

  • Physical and mental preparation for virtual racing competition by Confidential

SAS Specialist

Confidential

Responsibilities:

  • Consulting day to day Decision Management team’s SAS development activities. Members specialties include analytics, campaigns and data management
  • Enhance Enterprise Guide programs that generates data marts or ad hoc data
  • Review test cases and results for major 2 year project that streamlines and enhances experience for the company and customers
  • Train tester on technologies, communication and management procedures
  • Provide advice on SAS technical aspects (e.g. server throughput)

Senior SAS Analyst

Confidential

Responsibilities:

  • Execute SAS reports in a timely manner
  • Enhance reports for efficiency and usability
  • Technically interpret SAS codes of existing complex reports for management understanding.
  • Provide basic SAS consultation to IT and others who need SAS expertise.
  • Provide limited consultation for SAS Risk systems in capital finance.
  • Microsoft Business Intelligence R&D
  • Oracle Data Integrator R&D
  • Oracle Business Intelligence R&D
  • Statistics course
  • Self development
  • Travels and motorsports
  • Entrepreneurship opportunities research for a ready product in Australia.
  • Soft skills improvement in time, relationship and resource management.
  • Self improvement studies.

SAS Specialist

Confidential

Responsibilities:

  • Review data warehouse project schedule and tasks
  • Review deliverables of data warehouse project
  • Setup ETL development standards
  • Setup temporary development metadata machine for team
  • Develop specialized SAS transformations to be used across multiple ETL jobs
  • Setup web reports and cubes deliverables
  • Prepar initial ETL jobs.
  • Mentor Oracle developers on SAS usage.

Research and Development

Confidential

Responsibilities:

  • Research and enhance key personal growth areas

Risk Analyst

Confidential

Responsibilities:

  • Automate manual reports via Web Report Studio, Information maps and Stored processes.
  • Rollout new credit scoring models.
  • Develop and rollout ETL for new credit scoring models.
  • Troubleshoot defects detected by modelers stemming from ETL, models or input data.
  • Investigate and troubleshoot output of SAS credit scoring platform.
  • Help investigate outcomes of SAS RMS engine.
  • Investigate outcome in SAS Scoring solution.
  • Consultant to users on usage of SAS Base, Macro and Enterprise Guide.
  • Guide users on process and procedures around report and minor development.
  • Assist in adding new approach in SAS Risk Engine.
  • Automated existing manual reports using combination of stored processes, information maps and web reporting studio.
  • Provide solutions to users’ problems on SAS Base, Macro as well as Enterprise Guide practices in a short amount of time.
  • Rolled out new versions of models (and their associated components) written by internal modelers.
  • Investigated results of risk engine from Detailed Data Storage, credit scoring platform to risk engine.

IT Specialist

Confidential

Responsibilities:

  • Develop and maintain SAS DI and Base SAS ETL processes for risk and new systems.
  • Work with business departments on requirements for new reporting tables.
  • Help with environment setup when required (e.g. Development / Integration).
  • Demonstrate cube capabilities to business users.
  • Led a team of developers to develop new risk assessment integration system with Tibco Businessworks.
  • Manage resources for above mentioned risk assessment system.
  • Help in tech leading decisions for the above mentioned risk assessment system.
  • Worked with Cubes and Information maps in a project to deliver final data warehouse view.

Data warehouse consultant

Confidential

Responsibilities:

  • Analyse and create technical specifications for a high profile project based on functional specifications done by project management.
  • Supervise a small team in the development of data warehouse solution for the mentioned project.
  • Train the team in implementation of the solution (SAS, UNIX).
  • Provide expert input in SAS and other technical areas based on previous experience in the company.
  • Trained the team of junior developers with satisfactory results in very short period of time.
  • Analysed and structured functional requirements for preparation of technical specifications.
  • Delivered data mart project through to UAT stage before tenure ended.

Entrepreneur

Confidential

Responsibilities:

  • Build a new VR visualisation solution that has various applications in architecture, construction and engineering.
  • Market solution to various consumer groups and target for a profit in a planned time frame.
  • Increase network of people to broaden marketability and look for a win win situation.
  • Product has been developed in the budgeted time.
  • Knowledge of running a business increased significantly.
  • People skills increased.
  • Network of people increased.
  • Knowledge of 3d industry increased.

SAS consultant

Confidential

Responsibilities:

  • Consult in areas of data warehousing in a major project that overhauls the current housing information system.
  • Participate in analysis of requirements gathered by fellow SAS consultants of planned data warehouse.
  • Improve SAS server administration processes and server performance.
  • Provide consultation to ETL developers and reporting developers on problems faced and best practices in SAS development.
  • Designed and implemented complex property counting rules which is later integrated in conventional ETL. This implementation gave significant insights to property transactions e.g. how much of a property category has been transacted given a specific time period.
  • Prototyped an extract and cleansing on Enterprise Guide to build temporary marts to further analyze data quality and integrity. This has saved development time by further identifying cleansing and transforms rules to build the final warehouse.
  • Coordinated operation where SAS consultants migrate metadata from a server to a few others with different architectures, resulting in time savings from transporting metadata using other methods. The operation involved usage of Management Console and web services reconfiguration.
  • Planned and implemented metadata and SAS backup using combination of SAS and UNIX shell programming that proved to be very useful when inevitably some ETL jobs were corrupted or changed unintentionally.
  • Analyzed and improved server performance significantly by optimizing SAS storage locations effectively. We learnt that using SAN storage as a SAS working storage is not good for performance.
  • Solved numerous technical problems faced by developers (ETL, Web Report Studio) by recommending a better coding approach. As a result, processes run much faster and more trouble free.
  • Reorganized user and group into their respective hierarchies in Management Console. This prevented unexpected and unintended changes by other unauthorized users from happening.
  • Help solve problems with Oracle log archiving that temporarily halted the database.
  • Designed and tested program on Enterprise Guide and Web Report Studio that generates reference tables maintained by users. This way, whenever users wanted to keep the reference tables up to date, all they need to do is update parameters for this Enterprise Guide job and run it. This saves a lot of time and trouble on users’ end.

Analyst programmer

Confidential

Responsibilities:

  • Develop and implement enhancements and new solutions on the existing data warehouse system running on SAS 8.2, UNIX and Mainframe.
  • Gather requirements from business users, document them appropriately in current industry standards and implement on to the existing data warehouse.
  • Design program specifications based on requirement gathered from business users to come out with the best implementation on the current platforms.
  • Develop codes using appropriate languages and environment that suit the enhancements/solution in question. This can be SAS codes, UNIX shell scripts or even COBOL programs depending on the requirement and the program specifications.
  • Perform system integration and user testing to project owner’s satisfaction.
  • Roll out solution on change management platform which includes Endeavor and schedule production jobs on the required time intervals with Control-M.
  • Provide user support on projects that have been rolled out for the first month.
  • Participate in on call duty of software maintenance for the data warehouse as well as any OS or server resource related matters that needs to be attended.
  • Provide assistance on any user queries or problems on any areas of the data warehouse.
  • Integrated multiple source systems as well as platforms in projects using combination of base SAS and job processing scripts on each platform e.g. JCL, Shell script etc. This enabled marketing or business analyst to see all sorts of trends and relationships e.g. credit card spending vs. savings rates.
  • Helped bank improve productivity of sales personnel by automating SAS codes that transforms data from branches across the world into aggregated data that Hyperion Essbase understands, that will generate information cubes which maps out sales performance by country, branch staff, managers etc.
  • Ensured the credit cards data mart data was accurate by implementing a process that reconciles balances from data mart and the bank's general ledger. This complex process involves implementing aggregation rules from the source system on the individual marts. Hence, this ensures data in the warehouse exactly mirrors data from the general ledger.
  • Reduced production running time and problem occurrence by 50 % for a country by implementing preventive measures (such as allocating enough space in database, making SAS codes more efficient, analysing and enhancing program flows and performing file system checks to ensure there is enough space).
  • Identified numerous problems with source system by analyzing data from it, hence helping source party to improve data quality which in turn enhances accuracy of reporting. Problems detected included duplicates, special foreign language characters that is identical with delimiter and basic things like non empty fields.
  • Loaded credit scoring data into a data mart using SAS in Mainframe and UNIX. This enabled the bank to do analysis on performance of the credit scoring process, and the accuracy of the existing scoring system.
  • Loaded 5 years data into credit data mart which is aged with SAS coding. This enabled users to analyze among others, credit risks of consumers by the bulk in analyzing the history and reliability of the credit scoring.
  • Setup a secure file transfer facility on the data warehouse servers. This enabled files to be transferred in an encrypted and safe manner.
  • Trained programmers on the usage of the secure file transfer facility in everyday development and day to day use. Following the training, the department’s usage of the facility was flawless.

We'd love your feedback!