SAS Analyst/Developer

Dev Kumar Owings Mills, MD 919-***-****

Sr. SAS Analyst / Developer Email **.***.***@*****.***

Summary:

Over 6+ years of experience working in SAS Business Intelligence (BI) platform with Enterprise Guide, Stored Process, Information Map Studio, Microsoft Add-In, Dashboards, OLAP Cubes and Web Report Studio

Proficient in SAS v6.12/v8.2/9.1.3/9.2/9.3/9.4, SAS/Base, SAS/Macros, SAS/Connect, SAS/SQL and SAS/ODS

Experience includes using Procedures, Graph, Macros, Data step, SQL, and Data Mining, extracting internal/external data including cleaning and validation, use of formats and in formats

Strong experience in SAS/Base, SAS/Graph, SAS/Stat, SAS/Connect, SAS/Access, SAS/ODS, SAS/SQL, SAS/Macros, SAS/Enterprise Guide, SAS/Share, SAS Enterprise BI Server, and SAS Management Console

Experience in the BI Suite in SAS including SAS Enterprise guide, SAS OLAP Cube Studio, SAS Web Report Studio, SAS Data Integration (DI) Studio and Information Map Studio

Experience in developing SAS codes using SAS Enterprise Guide and SQL queries in SAS for creating stored processes using the dynamic prompts containing both packaging and streaming output, and prepared reports using ODS

Good command in importing and exporting complex internal data to and from Microsoft Excel and Microsoft Access using Proc Import and Proc Export

Hands on experience working Databases like Oracle, SQL Server, Teradata

Experience with database manipulation (ETL) and SQL programming and reporting

Ability to work efficiently in both independent and team environments, worked with Project Managers, Team Members / Associates, Statisticians, and Business Analysts

Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format

Exposure on every step of entire software development life cycle (SDLC) including data collection, query, modifying and analysis, coding statistical models, summarizing the findings, and presenting the results

Experience in using SAS Data steps such as Array, Merge, and Set, etc

SAS Analyst and Programmer in Banking, Financial Risk Management, Direct marketing, Basel, ALM, Credit services and Retail Industries

Have working knowledge about Informatica Sever tools –Informatica Repository Manager and Informatica Server Manager

Have experience in developing Marketing campaigns for customer acquisitions that involved liaising with third party Data Providers, setting up internal IT systems and Campaign data analytics

SAS developer with expertise in design and development of Extract, Transform and Load processes for Data Integration (DI) Studio projects to build data marts

Experience with SAS management Console for scheduling daily and monthly job runs for creating reports

Extensively used SAS procedures such as freq, report, tabulate, sort, print, transpose, summary and means for producing customized reports and external files

Experience in data manipulation procedures such as formats/informats, merge, proc data sets, proc sort, proc transpose and proc rank

Strong Problem Analysis & Resolution skills and ability to work in Multi-Platform Environments like Windows and Unix

Excellent written and verbal communication skills, resourceful, able to find solutions when faced with challenges

Technical Skills:

SAS Tools: Base SAS 9.4/9.3/9.2/9.1.3/8.2/8.1/6 (mainframe), SAS/Stat, SAS/Macros, SAS/SQL, SAS/ODS, SAS/Graph, SAS/Enterprise Guide, SAS/Enterprise Miner, and SAS Business Intelligence (BI) platform.

Reporting Tools: Base SAS versions 9/8/6, SAS Enterprise Guide, SAS Graph, MS-Excel, SAS BI Platform, SAS OLAP Cube Studio, SAS Web Report Studio and MS-PowerPoint.

RDBMS: SAS SQL, SAS Enterprise, SAS BI Platform, MS-Access, Microsoft SQL Server, MySQL

Languages: SAS, C, C++, SQL, HTML.

Operating System: Windows 95/98/XP/Vista/Win 7/8, Unix, MAC OS, and DOS.

Batch Server: Unix, Putty, SSH, and SAS scripting.

Certification:

Certified Base SAS programmer for SAS 9 SAFe 4 Certified Practitioner

Education:

Bachelors in Engineering from Anna University

Professional Experience:

ManTech, Owings Mills, MD Jan’2017 –Present

Sr. SAS Developer/Analyst

Responsibilities:

Responsible for creating monthly and weekly reports by extracting input data from Socrata

Prepared new datasets and modifying existing datasets using Set, Merge, Sort, Update, Formats, Functions etc.

Extensively used various Base SAS procedures like Proc SQL, Proc Summary, Proc Format, Proc Print, Proc sort etc. for reporting purposes.

Updating SAS Report contents by changing SAS code and customizing the existing Macros according to the need and requirement, testing and debugging the Macros and creating more complex and reusable Macros.

Exporting SAS Reports to the Excel Sheet by using ODS/Tagsets/Excel XP to get the output in multi sheets for monthly and weekly reports.

SAS Enterprise Guide was used to convert existing SAS program to SAS stored process using dynamic prompts that can be easily used by end users using SAS Add-in for Microsoft Office and other SAS BI clients from SAS Web application, Web report studio.

Responsible for Information Map Data Refresh and Maintaining Information Map to ensure it is functioning properly.

Updating, adding and monitoring new MBI column to SAS EBI Information Map as per New Medicare Card project changes.

Responsible for review of mapping document and data development

Responsible for interacting with business analysts and gathering requirements from clients as and when needed

Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format

Responsible to track the issues with the mapping document and make changes accordingly to the code

Environment: SAS 9.4/9.3, SAS/Connect, SAS Macros, SAS/Access, Oracle 11g, Windows 7, MS Office, HTML, SAS/ Enterprise Guide, SAS/Stored Processes, Teradata, Web Application, Information Map Studio, Microsoft Add-In, Dashboards, OLAP Cubes and Web Report Studio.

Bangkok Bank, New York, NY Apr’2015 – Dec’2016

Sr. SAS Developer/Analyst

Responsibilities:

Responsible to create/maintain Base SAS programs and perform Base SAS Coding, Macro development and creation of stored process.

Responsible for data extraction, data cleaning and data transformation according to the requirement.

Extensively used various Base SAS procedures like Proc SQL, Proc Summary, Proc Format, Proc Print, Proc sort etc. for reporting purposes.

Created new tables and manipulated data by using various joins and merges and then appended the data (Proc append) from the existing source tables containing millions of records

Prepared charts from SAS datasets using Graph tab from SAS EG and Providing support to the team by advanced querying using SAS Enterprise Guide.

Exported SAS Report outputs to the Excel Sheet and in multi Sheets by using ODS/Tagsets/Excel XP.

Customizing the existing Macros according to the need and requirement, testing and debugging the Macros and creating more complex and reusable Macros

Preparation and maintenance of documentation for all the task related to SAS coding.

Developed and used ksh scripts to schedule SAS Job, Documenting the process, and data validation

Experience in developing SAS BI Reports including SAS Visual Analytics Reports.

Responsible for creation of new reports and enhancements to the existing reports in SAS Visual Analytics.

Worked on SAS LASR Server to upload the data to memory and produce reports in SAS Visual Analytics

Environment: SAS 9.4/9.3, SAS/Connect, SAS Macros, SAS/Access, Oracle 11g, Windows 7, MS Office, HTML, SAS/ Enterprise Guide, SAS/Stored Processes Web Application, SQL, Unix and Teradata.

AAA Insurance, Walnut Creek, CA Oct’2013- Mar ‘2015

SAS Developer

Responsibilities:

Responsible for UAT Support, Support/created programs to get data from Oracle and Created SAS datasets.

Extracted raw data from an Oracle database and used SAS/Access to read it and run statistical analysis using SAS/Stat

Helped in SIT testing by creating new required programs and Created Profiling reports.

Worked closely with the migration team and identified the optimization opportunities and came up with solutions for the same.

Wrote a program and shell script for the Autosys Job.

Performed advanced querying using SAS Enterprise Guide, calculating computed columns, using filter, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generating SAS datasets

Review and modify SAS Programs, created customized ad-hoc reports, process data for publishing business reports; automate and distribute designed business reports on schedule in various format

Importing all Reports from web report studio, Stored Process, BI Dashboard and Information Map to Information Delivery Portal

Wrote macros, developed concise SAS scripting and used SQL to concatenate and join datasets from different database management systems using indexes and loops

Exported SAS Reports to the Excel Sheet by using ODS/Tagsets/Excel XP to get the output in multisheets.

Developed and used scripts to schedule SAS Jobs

Customizing the existing Macros according to the need and requirement, testing and debugging the Macros and creating more complex and reusable Macros

Environment: SAS 9.4, SAS/Connect, SAS/Macros, SAS/Access, Oracle, Windows 7, MS Office, HTML, SAS Enterprise Guide, SAS Enterprise Miner, SAS Stored Processes Web Application, SAS/SQL, Informatica and SAS ETL

Bank of America, Jersey City, NJ May’2011-Sep’2013

SAS Developer

Responsibilities:

Extracted raw data from an Oracle database and used SAS/ACCESS to read it and run statistical analysis using SAS/STAT.

Worked with SAS and Proc SQL to extract marketing demographics from a Teradata data warehouse for model testing, segmentation, scoring, and list management purposes.

Performed advanced querying using SAS Enterprise Guide, calculating computed columns, using filter, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generating SAS datasets.

Developed, modified and generated Monthly Business Review (MBR) reports and Quarterly Business Review (QBR) reports summarizing business activity using Proc Univariate, Proc Copy, Proc Transpose, Proc Report, Proc Tabulate and Proc Summary.

Used SAS Data Integration Studio to develop various job processes for ETL (Extract, transform and load) Informatica data warehouse database.

Created new financial tables and manipulated customer data by using various joins and merges and then appended the data (Proc append) from the existing source tables containing millions of records.

Review and modify SAS Programs, created customized ad-hoc reports, process data for publishing business reports; automate and distribute designed business reports on schedule in various format.

Worked on generating ad hoc reports, tables and graphs for presentations and data modeling using SAS Web Report Studio.

Importing all Reports from web report studio, Stored Process, BI Dashboard and Information Map to Information Delivery Portal.

Developed loss prediction model using Enterprise miner modeling solutions and SAS procedures.

Involved in design & testing of ETL code, interface integration & database structures to build data marts

Created and delivered reports and presentations with key findings and recommendations.

Provided technical support on SAS programming related to data manipulation and analysis.

Wrote macros, developed concise SAS scripting and used SQL to concatenate and join datasets from different database management systems using indexes and loops

Exported SAS Reports to the Excel Sheet by using ODS/Tagsets/ExcelXP to get the output in multisheets.

Developed and used scripts to schedule SAS Jobs.

Environment: SAS 9.3, SAS Base, SAS Macros, SAS/Connect, SAS/Access, Oracle 11g, Windows 7, MS Office, HTML, SAS Enterprise Guide, SAS Data Integration Studio, SAS Stored Processes, SAS/SQL, SAS/ETL, Informatica and Teradata.

Contact this candidate