SUMMARY:

• Expertise in SAS BASE, SAS Enterprise Guide (EG), SAS Studio, Visual Analytics (VA), Enterprise Business Intelligence (EBI) Tools (AMO (Office Analytics) ), SAS OLAP Cube Studio, SAS Information Map Studio, SAS BI Dashboards, SAS Web Report Studio and SAS Information Delivery Portal in SAS v9.2 to 9.4.
• Over the period of 8 years as a SAS Professional Experience in Data analysis, Database marketing, Customer profiling, SAS Programming, Statistical Analysis and modeling, Credit scoring, RFM analysis, Text Mining, Pattern Recognition and Web Analytics on UNIX/LINUX/Solaris and WINDOWS platforms.
• Expertise in creating all types of reports, Hierarchy Reports, Report Linking, Pop - up Report, Controls, Publish Reports, Row-Level-Security etc. in SAS Visual Analytics.
• Expertise in Theme Designer, Data Preparation, Custom Graph Builder & Administration in SAS Visual Analytics.
• Expertise on how to create Forecasting reports for predictive analysis, Sankey Diagram, Decision Tree, Heat Map for customer relation, Geo Maps etc and how to convert the exploration into report in Data Exploration in SAS Visual Analytics.
• Expertise on Exploration & Prediction with SAS Visual Statistics and Model Responses in SAS Visual Statistics.
• Experienced in the Construction of the ETL Process Performed in SAS Data Integration Studio - Extracting data from flat files and Greenplum, Transforming it according to the Business Requirements and loading the data back into Greenplum.
• Experienced in SAS Management Console (SMC) in Data Library Manager, Schedule Manger, User Manager for setting up users, groups, access permissions, metadata access, database connections, registering stored processes etc.
• Extensive knowledge in data management by using SAS DATA step statements including Set, Merge, Formats, Informants and procedures like Append, Sort, Transpose etc.
• Experienced in extracting, transforming and loading source data into the SAS environment from multiple sources including major DBMS, third-party software and spreadsheet applications.
• Experienced in SAS Enterprise Guide in creating stored processes using the dynamic prompts containing either packaging or streaming output. Expertise in creating project flows which includes aspects of data access, manipulation, summarization and report generation to a various output formats and channels.
• Strong experience in creating SAS Information Maps for different types of prompts, filters, data elements and BI Row-Level Permissions\Security.
• Experienced in creating dimensions and hierarchy levels, drill-through, aggregations, member-level metrics etc. in SAS OLAP Cube Studio for slicing and dicing of information.
• Strong Experience in creating all types of dashboards with Interaction & Report Linking in SAS BI Dashboard.
• Strong Experience in creating static and dynamic reports in SAS Web Report Studio using SAS Tables, OLAP Cubes, InfoMaps as a source originating from various data sources.
• Strong Experience in creating Portal Pages and Portlets, setting permissions for accessing Business Users in SAS Information Delivery Portal.
• Experienced in (3rd Party Databases) SAS/Access Interface to MySQL, Oracle, Teradata, Netezza, DB2, Sybase, Impala, SQL Server, Hadoop, Greenplum etc & SAS In-Database Technologies for Hadoop.
• Expert hands on knowledge of SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/ODS, and / SAS/SQL in UNIX, and Windows environments.
• Proficient in developing and debugging SAS/MACROS to access, extract, modify, merge, and analyze financial data other SAS application for data updates, data cleansing, and reporting.
• Working experience in SAS Access, SAS Connect, SAS/AF, SAS/ETL, PROC Reports, SAS ENTERPRISE in Windows and UNIX environments
• Created HTML, RTF and PDF reports using SAS output delivery system ODS (SAS/ODS).
• Responsible for data extraction from several databases & flat files.
• Extensive experience in RDBMS like Oracle, SQL Server, Teradata, Db2, MS Access.
• Used Proc SQL Explicit and Implicit Pass-Through in the process of Data Extraction.
• Experienced in SAS SPDS, SAS Schedule Manager and SAS Visual Analytics LASR Server management.
• Experienced in creation of SAS Data Libraries, Database Data Libraries (MySQL, Oracle, Greenplum etc.) and metadata folder structure.

TECHNICAL SKILLS:

Operating System: Windows XP, 7, 8, Windows Server 2003, 2008, 2008 R2, 2012 and UNIX (Sun Solaris) and Red Hat Linux.

Office & Other Tools: Experienced in MS Office (Excel, Word & PowerPoint) & Photoshop etc.

RDBMS: MySQL, Oracle, Greenplum, Teradata, Hadoop & MS Access.

Client Applications: Base SAS, SAS Enterprise Guide, SAS Data Integration Studio SAS Information Map Studio, SAS OLAP Cube Studio.

Web Ap SAS APPLICATIONS: SAS Visual Analytics (VA), SAS Web Report Studio (WRS), SAS BI Dashboard, SAS Information Delivery Portal (IDP) and Strategy Management (STM)

Other Applications: SAS Management Console (SMC), SAS Deployment Manager.

PROFESSIONAL EXPERIENCE:

Confidential, Eden Prerie, MN

SAS VA Reporting Developer

Responsibilities:

• Performed SAS programming using techniques as SAS Base, SAS Macro, data manipulation techniques, and statistical procedures (e.g., Proc Means, Proc Freq, Proc Report).
• Used SAS PROC SQL Pass through Facility and SAS/CONNECT to work with Oracle database.
• Analysis huge data sets that have observations in few millions.
• Developed all types of reports, KPIs and applied all types of Styles, Interactions and Filters in SAS Visual Analytics.
• Created all Hierarchies, Custom Categories, Calculated Items, Aggregated Measures, Data Source Filters and created all Operators to build formulas and Report Linking and Controls in SAS Visual Analytics.
• Interacted with client in terms of project requirement, enhancements & debugging on production reports issues and Interact with business users and gathering requirements to create reports in SAS Visual Analytics.

Environment: SAS/BASE (V9.4,), SAS/STAT, SAS/MACRO, SAS/ACCESS, SAS/ODS, SAS/QC, SQL, EXCEL.

Confidential, Jacksonville, Florida

SAS (VA & EBI) Reporting Developer

Responsibilities:

• Meetings with business users to understand the business requirements, disparate data sources.
• Participation in business review meetings to gather requirements to design\generate reports and graphs.
• Build and publish dashboards to analyze different service and products lines of the client.
• Working closely with the project development team and End-User community in coordinating with the bug fixes.
• Involved in promoting SAS/Access Interfaces to Oracle and SQL Servers
• Responsible for all the SAS End-User community on daily basis and serve their day- to-day functional and technical needs on SAS Enterprise Server platform
• Meet with the Business/Technical/SAS Developers- Users and Business Analysts and understand their data sources and establish/build connectivity layers using SAS Management Console and grant appropriate permissions at group level for Users to be able to connect both external and internal connections to SAS.
• Responsible for all the End-User community on daily basis and serve their day-to-day functional and technical needs on SAS Enterprise Server platform

Environment: SAS/BASE (V9.4, V9.3, V8.2), SAS/STAT, SAS, SAS/MACRO, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/ETS, SAS/QC, SAS/Connect, UNIX, SQL, MS Access, EXCEL, Windows XP/Teradata, Tableau.

Confidential, New York

SAS DeveloperLab & System Admin Support

Responsibilities:

• Design, development and unit-testing of SAS and Oracle PL/SQL program code, functions and scripts to efficiently extract, merge and manipulate large volumes of data.
• Research, analyze and calculate quality indicator measures related to financial topics.
• Perform client needs analysis and assessment, collaborate with clients and business analysts to identify and clarify program, business and functional requirements.
• Perform integrity analysis to identify data quality and integrity issues, as well as random sampling; benchmarking and trading of data.
• Develops and maintains system documentation, run-books and production metrics reporting.
• Resolving client issues, change management, documentation, installs/upgrades of SAS, coordinate outages with the customers, coordinate patching with server team and perform restarts.
• Managing SAS environments.
• Troubleshoot and resolve application or infrastructure issues. Detailed knowledge of multiple systems, as well as an in-depth understanding of the functionality for these systems.
• Gather and clarify business and technical requirements with data requestors.
• Provide technical and analytic input to analytic team.
• Develop Adhoc reports and perform data analytics.
• Managing SAS Risk products.

Environment: SAS 9.4, SAS Enterprise Guide 5, PL/SQL, Oracle, UNIX, UNIX shell scripting, Hummingbird Exceed. - Ju ne 2006

Confidential

SAS BI Developer

Responsabilités:

• Gathered and Understood the Business Requirement to create reports to display deficit and surplus information.
• Created different types of prompts, filters, data elements in SAS Information Maps.
• Built different types of cubes and created dimensions and hierarchies, drill-through, aggregations for slicing and dicing of information in SAS OLAP Cube Studio.
• Created different types of dashboards using SAS Table and InfoMap as a source in SAS BI Dashboard.
• Created static and dynamic reports in SAS Web Report Studio using OLAP Cubes, InfoMaps as a source.
• Created Portal Pages and Portlets, setup permissions for accessing Business Users in SAS Information Delivery Portal.

Confidential

SAS Analyst

Responsibilities:

• Understanding the Business and its Requirements
• Setting up SAS datasets by extracting data from different source systems into SAS datasets
• Consolidating data from Data quality assessment of consolidated data
• Merging and summarizing data using Proc SQL, Proc Format, and Proc Append in data step
• Extracting data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Coding SAS programs with the use of Base SAS and SAS/Macros.
• Reporting relevant data to the client with the help of SAS.

Confidential

SAS Developer

Responsibilities:

• Designed and developed Extract, Transform, Load (ETL) processes using Base SAS to populate Reporting Data Marts.
• Created dashboards in SAS BI Dashboard and Generated reports in SAS Web Report Studio using OLAP Cubes as source.
• Developed the OLAP Cubes in various dimensions and hierarchies, drill-through, aggregations etc. in SAS OLAP Cube Studio.
• Distributed the generated reports at different levels of data accessibility by choosing different Portal pages of Portlets in SAS Information Delivery Portal.
• Creating statistical summary report of safety section
• Validating analysis datasets
• Involved in data validation using Base SAS for scrubbing of the data
• Played key role in generating and delivering listing reports.

Confidential

SAS Developer

Responsibilities:

• Worked with huge datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT, PROC MEANS, and PROC TABULATE for creating a list of targeted customers.
• Worked closely with the business analysts to sift out the nest campaign strategy amongst possible alternatives.
• Responsibilities also included preparing with respect to demographics, and other given parameters, and updating the current database.
• Responsible for developing SAS MACROS and SAS GRAPH for creating tables, graphs and listings.
• The extracted datasets were synchronized with the SAS OLAP server which enabled multidimensional data storage to provide instantaneous access to summarized data so that the business analysts can make timely decisions based on knowledge rather then gut feelings. This also frees IT from constantly creating reports and data summaries since the data is summarized along business lines.
• Simultaneously involved in development of a module for identifying various risk factors and achieving high response rates for target-specific offers. These efforts were directed towards reduction in marketing costs which turned out to be extremely successful.