SUMMARY:

• Expertise in SAS Base, Advanced SAS, SAS Visual Analytics (VA), SAS Enterprise Business Intelligence (EBI) Tools - SAS OLAP Cube Studio, SAS Information Map Studio, SAS BI Dashboards, SAS Web Report Studio and SAS Information Delivery Portal (IDP).
• Well versed on SAS Tools like SAS Base, Advanced SAS, EBI & Visual Analytics Tools on SAS versions 9.2, 9.3 & 9.4, over a period of 6 years in Health-Care, Insurance and Banking industries in USA.
• Certified SAS Professional in Base SAS and SAS Visual Analytics 7.3 Reporting and Design.
• Expertise Experience in Data Exploration, Report Designer, Report Viewer, Data Preparation, Custom Graph Builder, Theme Designer & Administration in SAS Visual Analytics.
• Experience in publishing reports to Business Users based on their permissions on data and in Row-Level-Security in SAS Visual Analytics.
• Experienced in SAS Enterprise Guide & SAS Studio in creating project flows which includes aspects of data access, manipulation, summarization and report generation to a various output formats and channels.
• 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.
• Experienced in creating SAS Information Maps for different types of prompts, filters, data elements and BI Row-Level Permissions\Security.
• Experienced in creating all types of dashboards with Interaction & Report Linking in SAS BI Dashboard.
• Experienced in creating static and dynamic reports in SAS Web Report Studio using SAS Tables, OLAP Cubes, Info Maps as a source originating from various data sources.
• Experienced 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, DB2, SQL Server, Greenplum etc.
• Hands on Experience in SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/ODS and SAS/SQL in UNIX\Linux and Windows environments.
• Proficient in developing and debugging SAS/MACROS to access, extract, modify, merge and analyse financial data other SAS application for data updates, data cleansing and reporting.
• Used Proc SQL Explicit and Implicit Pass-Through in teh process of Data Extraction.
• Experienced in creation of SAS Data Libraries, Database Data Libraries (MySQL, Oracle, Greenplum etc.) and Metadata folder structure.
• Perform data quality checks, data validations and Adhoc requests.
• Possess strong ability to quickly adapt to new applications and platforms.
• Good Team player with excellent analytical and problem-solving skills and a positive demeanour.

TECHNICAL SKILLS:

Operating Systems Workstation & Server: Windows XP/Vista/7 & 10 & WS 2008, Unix\Linux 6.8

Statistical Software: SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/ACCESS, SAS/CONNECT, SAS/ODS

SAS Platform: AMO, EG, Studio, OLAP Cube, InfoMap, WRS, Dashboard, IDP, VA & SMC

Languages: C & SQL/PLSQL

Databases: MySQL, Oracle, SQL Server, MS Access, Teradata, Greenplum etc

Office & Other Tools: MS Office -Excel, Word, Power Point

SAS Skills Client Applications: Base SAS, SAS Enterprise Guide, SAS OLAP Cube Studio, SAS Information Map Studio & SAS Admin Console (SMC)

Web Applications: SAS Studio, Visual Analytics, Web Report Studio, SAS BI Dashboard and IDP

PROFESSIONAL EXPERIENCE:

Confidential, Strongsville, Ohio

SAS VA Developer

Responsibilities:

• Involve in daily management of buildingSASdatasets andSASReports using BaseSAS and SAS VA.
• Collaboratively work with Risk Dept. asSASneeded to ensure dat business principles are being met.
• Responsible for teh coding, modification, and management of multipleSASjobs.
• Interact with Database Administrators (DBA), Windows Administrators, Storage Administrators, and with teh development organization.
• Interact frequently with various groups within teh Business.
• Modify existingSASprograms, macros and datasets to meet teh need of teh business.
• Provide periodic code review and enhancement.
• Provide day to day management and support of teh scheduledSASjobs.
• Generate technical support documentation forSASProcesses.
• Communicate with teh other development team members to get code ready as intended.
• DebugSASprograms and solid understanding of all phases of SDLC.
• Responsible for coding and debugging various programs built as part of development as well as modifying existing programs usingSASEnterprise Guide.
• Responsible for testing and coordinating migration of code to production.
• Developed all types of reports, KPIs and applied all types of Styles, Interactions and Filters in SAS VA.
• Created all Hierarchies, Custom Categories, Calculated Items, Aggregated Measures, and Data
• Created all Operators to build formulas and Report Linking and Controls in SAS VA.

Environment: SAS Base, SAS MACRO, SAS Stored Process, SAS Enterprise Guide7.1, SAS Visual Analytics 7.3.

Confidential, Columbia, MD

SAS BI Developer

Responsibilities:

• Interacted with Risk Managers and Analysts to define targeted customer segments.
• Used LIBNAME, PROC IMPORT and SQL PASSTHRU FACILITY to import data from Oracle database intoSASfiles.
• Manipulated and updated teh tables as per specifications.
• Performed data cleaning by analysing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC UNIVARIATE, and macros inSAS.
• Used regression techniques ANOVA, CORR, PROC MEANS and PROC FREQ to analyse data
• Prepared ad-hoc reports, documentingSASwork, and directingSASoutputs to RTF and HTML files throughSASODS facility
• Developed complexSASmacros to simplifySAScode and TEMPeffectively reduce coding time
• Involved in gathering, analysing and documenting business and technical requirements
• Worked on advance querying teh database usingSASEnterprise guide in calculating and computing columns, using filters, manipulated and prepare teh data for reporting and statistical summarization
• Involved in designing teh project and process flow diagrams usingSASEnterprise Guide
• Performed statistical analysis of financial and operational data
• Generated high quality reports in teh form of listing, HTML, RTF and PDF formats usingSASODS
• Performed data analysis, statistical analysis, generated reports, listings and graphs usingSAStools.
• Created Information Maps in various types of prompts and filters and implemented BI Row-Level Security in SAS Information Maps.
• Created all types of dashboards using SAS Table, Info Map and Stored Process as a source and KPIs (Gauges), Interactive Dashboards, Report Linking etc. in SAS BI Dashboard.
• Scheduled SAS OLAP Cubes Script files and SAS EG projects in Windows Task Scheduler.
• Generated, Scheduled and Maintained reports in SAS Web Report Studio using SAS Datasets, OLAP Cubes and Information Maps as sources.
• Extensively used prompts, filters, calculations, conditional variables, multiple queries for data extraction in reports using Report Designer.
• Implemented SAS Information Map BI Row-Level Permissions\Security
• Developed Web Portal Applications using SAS BI tools like SAS Stored Process, SAS Information Map Studio, SAS OLAP Cubes, SAS Web Report Studio, and SAS BI Dashboard.
• Published all Reports from Web Report Studio, BI Dashboard and Information Map into Information Delivery Portal.

Environment: SAS Base, SAS MACRO, SAS Stored Process, SAS BI, SAS Enterprise Guide, SAS Information Map Studio 4.3, SAS Web Report Studio 4.3. SAS Visual Analytics 7.1 (SAS 9.4)

Confidential, Boston, MA

SAS BI Developer

Responsibilities:

• Designed and developedSASdatasets from various sources like Excel datasheets, flat files and Oracle creating reports and files from existingSASdatasets.
• Worked on transforming data into OLAP cubes, web reports.
• Used PROC UNIVARIATE andSAS/STAT procedures for analysing teh data.
• WrittenSAScode to support teh development of an item and test analysis system
• UsedSASPROC SQL pass through facility to connect to tables and createdSASdatasets using various SQL joins such as left join, right join, inner join and full join.
• Good exposure onSASBusiness Intelligence Tools likeSASOLAP Cube Studio,SASInformation Map Studio,SASStored Process,SASWeb Applications.
• Worked as aSASAdmin in aSASinfrastructure dat usesSAS9.4
• Administering and supporting in all aspects ofSASSoftware in aSASPlatform Environment.
• MaintainedSASVisual Analytics Server. Interacting with different Support teams like UNIX Administration, Database Administration, Production Job Scheduling Team and others to meetSASDeveloper's access and connectivity requirements.
• Expertise in applyingSASprocedures like Proc Means, Proc Freq, Proc Sort, Proc Format, Proc Report, Proc Tabulate, Data NULL, Proc Print and their multiple options Proc Import, and Proc Export for importing and exporting data, Proc Contents and Proc Datasets to view teh contents of theSASlibraries.
• Extensively used merge, set, in Data steps to combine many data sets.
• Experience in creating all types of reports i.e. Tables, Graphs, KPI Reports, Controls, Containers and all types of Styles, Interactions, Display Rules, Filters, and Roles in SAS Visual Analytics.
• Experience in creating all Hierarchies, Custom Categories, Calculated Items, Aggregated Measures,
• New Data Source Filters, Controls, Parameters, Display Rules, Gauges and Report Linking in SAS Visual Analytics.

Environment: BaseSAS,SASMacros,SASEnterprise Guide, SAS EBI - OLAP Cube Studio, Information Map Studio,SASWeb Report Studio, Dashboard and IDP & SAS9.4 - (Visual Analytics 6.3).

Confidential

SAS Developer

Responsibilities:

• Good understanding inBase & Advanced SAS, SASEBI and Visual Analytics 6.3.
• Programming Experience withSASprocedures like PROC REPORT, PROC FREQ, PROC TABULATE, PROC MEANS, PROC SUMMARY, PROC PRINT, and PROC SQL.
• Extensive experience in working withBaseSAS(MACROS, Proc SQL, ODS),SAS/ACCESS, and SAS/GRAPH in UNIX and Windows.
• Expertise in using Teradata SQL assistant and SQL plus for writing queries to pull teh data from different tables.
• Excellent programming skills in SQL and understanding of data management principles, such as joining data sets, data aggregation and Sub setting using PROC SQL.
• Strong ability to manage and manipulate databases, program and generate reports according to user needs
• Thorough knowledge and experience of Microsoft Office tools like MS Access, MS word, MS PowerPoint, and MS Excel
• Good exposure onSASBusiness Intelligence Tools likeSASOLAP Cube Studio,SASInformation Map Studio,SASStored Process,SASWeb Applications.
• Strong experience in creating SAS Information Maps for different types of prompts, filters, data elements and BI Row-Level Permissions\Security.
• Strong Experience in creating static and dynamic reports in SAS Web Report Studio using SAS Tables, OLAP Cubes, Info Maps 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.
• Created complex and reusable Macros and extensively used existing macros and developedSAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Responsible for production updates (monthly, quarterly and semiannual) by processing client's eligibility and claims data from different carriers through teh ETL to Data warehouse.
• UtilizedSASPROC SQL Pass through facility for data extraction, location and retrieval from teh Oracle database
• Generated output files in text format, HTML & PDF format usingSASODS.
• Developed ad-hoc reports in production environment up on special request usingSASPROCEDURES like PROC PRINT, PROC FREQ, PROC UNIVARIATE, PROC SUMMARY, PROC REPORT and PROC MEANS.
• Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right, full) to validate and reconcile data.
• Developing repetitive loops for retrieving array variables for joining of datasets for ad-hoc reporting
• Create Edit Checks to verify teh accuracy of teh data.
• Independently perform data investigations. (Investigate code; utilize reporting environment, special requests, program /mods, etc.).
• Involved in writing code usingBaseSAS&SAS Macros to clean and validate data from oracle tables.
• SASEnterprise Guide was used to convert existingSASprograms toSASstored processes using dynamic prompts and produced packaging and streaming outputs as required.
• Extensively used company standard macros, generating graphs, listings, PDF and RTF files using variousBaseSASProcedures.
• Identify possible solutions for complex data issues/limitations, and work on Improvement of data quality.
• Identify risks and report impact to teams in a timely manner.
• Coordinate new data development which includes teh creation of new structure to meet business requirements or streamline existing processes to reduce overhead on teh existing warehouse with ETL Development team.

Environment: SASBASE 9.2, SAS MACROS,SAS Enterprise Guide 4.2,MS-Access & SQL.