SUMMARY

• SAS Application Designer with over eight years’ experience and strong knowledge transfer skills to EBI Portal/Portlet and Stored Process/ODS/SQL and SAS/Macro skills with excellent communication, throughout - leadership and teaching skills.
• Excellent understanding of the interrelation of EBI components and when to use one over the other and be able to provide guidance, technical expertise and mentoring within the Customer user community in the proper use of these SAS components.
• Extensive experience using SAS EBI tools such as SAS DI Studio, SAS OLAP Cube Studio, SAS Information Map Studio, SAS Enterprise Guide and SAS Web Report Studio in industries such as Federal Government, Insurance, Banking and Pharmaceutical.
• Over eight years of extensive experience in SAS Enterprise Business Intelligence (EBI) tools as a Sr. SAS Programmer/Analyst involved in Market Risk Analysis, Financial Analysis and Data Analysis.
• Experience in design and development of SAS programs to analyze and generate Files, Tables, Listings and Graphs.
• Extensive knowledge in Data Integration and working with SAS development using GCF (Government Risk and Compliance) and LSF (Load Sharing Facility) with different clients.
• Used SAS ETL to create reports from relational database or multi-dimensional cubes.
• Knowledge in Data Warehousing and Business Intelligence concepts and design principles. Experience in RDBMS development using SQL, PL/SQL language.
• Proficient in using Import and Export procedure to handle data in raw data files from SQL, ORACLE, DB2, TERADATA and SYBASE database management system.
• Strong understanding in various Economic/Econometric and Statistical concepts such as ANOVA, Correlation, Regression Analysis including Multiple Regression, Logistic Regression and Multivariate Analysis.
• Expertise in Risk Analysis, Marketing Strategy Development, Financial Models, DSS (Decision Support Systems), Time Series Analysis, Predictive Analysis and Forecasting.
• Experience in Base SAS, SAS Macros and SAS ODS.
• Expert in using PROC SQL, PROC Report, PROC Summary, PROC Access, PROC Means, PROC TRANSPOSE, PROC Tabulate, PROC GPLOT, PROC GChart, PROC Datasets, PROC Format, PROC Import and PROC Export.
• Lead the coding/development effort and maintain existing SAS programs and make modifications.
• Experience in registering SAS Libraries and tables in SAS metadata.
• Expert level understanding of SAS Enterprise Guide to develop new and or update SAS applications and programs.
• Experience with SAS Management Console to create and maintain SAS metadata, users, groups, Access Control Templates, Roles Interface.
• Hands on Experience for SAS supplied hotfixes and maintenance packs to maintain SAS EBI environment.
• Proven expertise in development of complex programming algorithms to extract or manipulate data to support performance measurement, risk and modeling analysis.
• Experience with scheduling with LSF Platform Suite built into SAS.

TECHNICAL SKILLS

Statistical Software & Tools: SAS Enterprise Guide, SAS Enterprise Miner, SAS Web Report Studio, SAS Data Integration Studio, SAS OLAP Cube and SAS Information Map Studio.

Databases: MS SQL Server 2012, MS Access, ORACLE.

Programming Languages: SAS Base, SAS Macros, SAS SQL, MS Visual Basic.

OS Software: Windows 10/8.1/7 and Windows Server 2012 R2.

Software Packages: MS Office 2013/2016, Advanced Excel, MS Exchange, MS Project and MS Visio.

PROFESSIONAL EXPERIENCE

Lead Consultant SAS

Confidential, Saint Paul, MN

Responsibilities:

• Involved in Business Analysis and Systems Planning.
• Migration of data from test files and DB2 to SAS data sets.
• Created complex and reusable Macros and extensively used macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Played a major role in quick generation of Ad-hoc Business Analysis Reports and resolving data issues upon request.
• For data analysis and BI Reporting application development used Base SAS and SAS Macro programming.
• Developed SAS programs using SAS/BASE, SAS/SQL, SAS/STAT and SAS/MACROS for statistical analysis and data display.
• Used ODS statements and PROC TEMPLATE to create reports in various style format.
• Used SAS extensively to create Ad-hoc reports and created graphs by using SAS/GRAPH.

Environment: SAS v9.4, SAS/BASE, SAS/SQL, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ODS, HTML, DB2, MS-Excel and UNIX.

Sr. SAS BI Consultant

Confidential, Fort Collins, CO

Responsibilities:

• Assist Agency with evaluating and teaching how best to use Portal and Portlets, Web Report Studio, Information Map Studio, OLAP Cube Studio, use of SAS Stored Processes, SAS Enterprise Guide, SAS /ACCESS to SQL.
• Lead the development phase to analysis Agencies BI requests and translating them into actionable reports from acquiring relevant data, modifying data to build reports.
• Created 100+ SAS Reports using SAS Web Report Studio and SAS EBI Web tools.
• Published completed Reports in SAS Information Delivery Portal as a Portal Administrator.
• Developed and recommend strategies and specifications for (technical) data solutions based on the analysis of the business goals, objectives, needs and existing data systems infrastructure.
• Work with a team of SAS Developers, business analyst, DBAs, system administrators to architect data model, design and implement database as well as utilize SAS DI Studio solutions for ETL.
• Work with Federal staff to set up the security model for access SAS Report tools.
• Analyzed complex business problems to be solved with data extraction, data profiling, ETL, data analysis and coding programming.
• Supported the review of design documents to ensure the business team understands the technical solution.
• Utilized SAS Enterprise Guide and its functionality to create flows that includes aspects of data access, manipulation, summarization and report generation to a variety of output formats and channels.
• Utilized SAS Information Map Studio to map physical data to business elements as an example of creating various types of prompts, filters, data elements.
• Created various OLAP Cubes using functionality of OLAP Cube studio with features like various dimension and hierarchies, drill-trough, performance tuning, aggregations etc.
• Utilized SAS Stored Process for the creation of customized web output that includes the ability to parse CSV or delimited flat files using SAS DATA step, advanced Macros and put statements to the ODS web out destination.
• Developed SAS BI Dashboard supporting mission of the Agency and Divisional projects.
• Created and published SAS BI Dashboards using available functionality that includes define data sources, ranges, KPIs and the Dashboard Indicators.
• Worked with Federal staff to develop dashboards and reports integration with the SAS BI portal using IBM WebSphere.
• Participated in design discussions and provide technical recommendation.
• Performed regular backups of the Metadata Server and physical files.
• Used SAS Management Console to monitor logging and or troubleshooting SAS Servers and processes, including error messages and administered the scheduling of jobs and reports.
• Utilize SAS Management Console to control user access to various parts of the SAS system, granting permissions to read, write, create or view reports and data within the system to ensure that Users can see only the information that they are authorized to access.

Environment: SAS v9.3, SAS Enterprise Guide, SAS BI Tools as SAS DI Studio, SAS OLAP Cube Studio, SAS Web Report Studio, SAS Information Map Studio, SAS Management Console, SAS Base, SAS/SQL, SAS/MACROS, SAS/STAT, MS SQL Server 2012, MS Access and MS-Excel.

Confidential, Grosse Point, MI

Responsibilities:

• Performed maintenance of personal computers and peripheral equipment, identifying problems and providing appropriate solutions.
• Installed software and configured Desktop and Laptop computers for customer.
• Performed PC related troubleshooting using helpdesk phone call and on-site as field technician.
• Deliver excellent customer service for PC and other office equipment’s.
• Perform basic and advanced technical system diagnostics for customer’s PC.

SAS Programmer

Confidential

Responsibilities:

• Created database conversion programs for clinical studies according to the Data Management Plan (DMP), tracked each receipt of non-CRF data, assisted in the process of locking & freezing databases, sent interim, frozen and final databases to client.
• Responsible for data collection, management and manipulation of clinical trials database for Phase 1 clinical trials.
• Created and modified SAS macro based program codes.
• Created Summary Reports and Tabular Reports using Proc Report and Proc Tabulate.
• Performed validation, including testing SAS code for Phase 1 clinical trials.