Sas Bi Developer Resume Profile
NY
Summary:
- Over 8 years of extensive experience in SAS programming on different platforms - Windows and UNIX, also having worked in updating, data extraction, transformation and loading to data warehouse, data analysis, updating, testing and data validation.
- Experience in Data analysis and Reporting in health care, finance and marketing sectors. SAS experience includes detailed knowledge of statistical analysis of financial, marketing and health care data and in the production of reports and tables.
- Experience in SAS/BASE, SAS/MACRO, and SAS/ODS, SAS/SQL, SAS/STAT ,SAS/GRAPH, SAS/ACCESS, and SAS/CONNECT in UNIX and Windows environments.
- Developed new or modified existing SAS programs to load data from the source and create study specific datasets.
- Created reports in SAS and exported to Excel spreadsheets, created web reports using Web Report Studio.
- Strong ability to write SQL queries using PROC SQL.
- Experience in utilizing SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading and reporting. Involved in the data analysis, DB creation, applying database constraints and make ready to load onto database.
- Involved in coding and pulling data from various oracle tables using Unions and Joins.
- Customize the variables to user-defined formats using PROC FORMAT in printing reports.
- Experience in working with SAS ENTERPRISE GUIDE for reporting and analytical tasks.
- Expertise in using various SAS report generating procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT.
- Experience in performing ad hoc queries for various application and reports on a daily/weekly or monthly basis.
- Hands on experience working with SAS Enterprise Guide, Information Map Studio, Data Integration Studio and Web Report Studio.
- Extracting, transforming and loading data into data warehouse using SAS DI Studio for further analysis and reporting.
- Created complex web reports from SAS data and information maps using SAS WEB REPORT STUDIO.
- Performed data extraction, analysis and published results using SAS ENTERPRISE GUIDE.
- Experience in using SAS to read , write , import and export to another data file formats including delimited files , spreadsheet , Microsoft excel and access tables.
- Good understanding of software development life cycle concepts.
- Ability to adopt new technologies , and able to communicate and provide support to BI issues.
Technical Skills:
SAS Tools | SAS 9.1.3 SAS/BASE, SAS/Macros, SAS/STAT, SAS/Graph, SAS/SQL,SAS/ACCESS,SAS/ODS |
SAS BI Tools | Data integration studio, Web report studio, OLAP cube studio, Information Map Studio, Delivery Portal, SAS Management Console |
Databases | SQL SERVER 2008/2005, ORACLE 9i,10g. |
Operating Systems | Windows 95/98/2000, windows XP, UNIX, Mainframes |
Professional Experience:
Confidential
SAS BI Developer
- Responsible for the extraction, validation, summarizations insights related to such analytical projects from marketing database.
- Involved in assessing analytical projects to determine the required data elements to be utilized for desired end result.
- Worked with external database host vendor as needed to complete analytical projects.
- Assisted in the validation of data feeds for new marketing database vendor to meet required dates for going
- live in new database environment.
- Assisted in the evaluation of appropriate analytical tools to be incorporated for analytical purposes at marketing database host vendor.
- Collaborated with circulation, loyalty and email marketing teams to undertake customer analytical or testing projects.
- Assisted in helping to segment the customer file for more productive and effective circulation efforts.
- Involved in writing code using SAS/ Base SAS/Macros for creation of analysis datasets.
- Developed and executed SAS SQL queries for merging, concatenating and updating large volumes of data.
- Reviewing business requirements for standard reporting.
- Working on SAS business intelligence platform to drive the automation of standardized analytics.
- generating SAS EG stored process with static and dynamic prompts for product specific analyses
- Modifying existing codes for improvement in the performance.
- Advanced querying using SAS EG,Calculating computed columns,using filter, manipulate and prepare data for reporting, graphing, and summarization, statistical analysis, finally generating the data marton weekly basis.
- Importing SAS datasets, OLAP Cubes in SAS information Map Studio. Using instructions on how to access and combine relational data tables, calculating new data items, Created multiple pre-defined filters.
- Building quick reports from Web report studio using information maps, Create filters, graphs, and customize reports.
Environment:SAS 9.1.3, SAS/CONNECT, SAS Macros, SAS/ACCESS, Oracle 10g , Windows 7, MS Office, HTML, SAS Enterprise Guide , SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio , SAS Information Delivery Portal, SAS OLAP Cube Studio, SAS BI Dashboard, SAS Enterprise BI Server.
Confidential
SAS BI Developer
Responsibilities:
- Interacted with business users, business analysts and translated business requirements into technical specifications.
- Responsible for writing SAS programs using Base SAS and SAS/Macros to create SAS reports.
- Extensive study, design, development and testing were carried out in the Oracle Environment
- Extensively involved in getting data from oracle database using SQL pass- through.
- Customizing the Business Intelligence Dashboard according to the requirement.
- Using the Enterprise Guide Stored Processes, updating and developing macro programs code.
- Performed data cleansing to eliminating duplicate and inaccurate data.
- Developed and executed SAS SQL queries for merging, concatenating and updating large volumes of data.
- Generated high quality reports and listings in HTML, EXCEL and PDF formats using
- SAS/Enterprise Guide software was used for file and program management purposes.
- Creating various transformation procedures by using SAS 9.1, SAS Cube Studio, SAS Data Integration Studio, and SAS Enterprise guide.
- Involved in writing code using SAS/ Base SAS/Macros for creation of analysis datasets.
- Knowledge about the SAS Metadata Server and Data Warehousing development
- Complete understanding of SAS OLAP.
- Maintained OLAP cubes using SAS OLAP CUBE Studio to support reporting of information maps and Web
- Design of ETL process to meet the requirement of data demand.
- Created and maintained required Data marts and OLAP Cubes using SAS DI Studio and SAS OLAP Cube Studio to fulfill reporting requirements.
- Production Job Scheduling using SAS DI Studio.
- Worked on analyzing the code in Stored Processes and generating reports using WRS.
- Knowledge about the handling of SAS Open Metadata Architecture.
Environment: SAS/Base 9.1, SAS/EG 4.0, SAS Web Reporting Studio, SAS/Macro, SAS/Access, SAS/Connect, SAS/UNIX, SAS/ODS, SAS/Macros, ORACLE 9i, TOAD, SQL, MS Excel, Autosys..
Confidential
SAS BI Developer
Responsibilities:
- Extracting and converting data from one platform to another to be used for further analysis. From Oracle and Excel to SAS by using SAS SQL procedures and create SAS data sets.
- Developed new or modified SAS programs and used SQL Pass through facility and Libname methods to extract data from the Teradata DB and created study specific SAS datasets, which are used as source datasets for report generating programs. Extensively used various statistical Procedures like PROC FREQ, PROC MEANS to understand data quality, produce reports and handle the missing values
- Created SAS Datasets with the usage of SAS MACRO, Macro Variables, CALL SYMPUT.
- Created the customized reports based on total costs and sales based on different advertisements.
- Analyzed the data of advertised contents based on people response and created reports based on their demographic information.
- Generated customized reports using SAS/MACRO facility, PROC REPORT, PROC TABULATE and PROC SQL.
- Extensively performed Data Cleansing during the ETL's Extraction and Loading Phase by analyzing the raw data and creating complex reusable Macros
- Extensively used constraints for defining the data, modified the data and wrote queries and sub queries like non related and correlated queries in SQL for the data analysis.
- Created Macros and extensively used for the data analysis and producing the reports.
- Written Korn-shell FTP scripts to FTP files to the specific path in the UNIX environment and to backup SAS files from mainframe.
- Generated queries/reports and other activities like OLAP through the SAS OLAP Cube Studio, Forecasting and Analysis as requested.
Environment:Base SAS, SAS/ACCESS, SAS/CONNECT, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ODS, UNIX, Mainframes, SAS Enterprise Guide, SAS BI
Confidential
SAS Analyst
Responsibilities:
- Involved in the building of data marts from enterprise data sources spread across platforms of the SAS DI studio.
- Created metadata objects by creating the data sources, targets and data transformations using the source, target and process designer of the SAS DI Studio also known, SAS ETL Studio .
- Created Lookup, Fact and Dim tables and Identifying the mapping data into specific domains as per the data model using SAS Enterprise Guide by creating the DATA and PROC steps as process tasks
- Involved in the Administration of the user authentications, metadata repositories, job scheduling, stored processes, data cleansing.
- Experience in creating OLAP cubes for reporting of pre-summarized large datasets and decision support systems using SAS Data Integration Studio and publish the same for business users.
- Generated SAS datasets, tables, listings, graphs and reports from analysis datasets using SAS tools like BASE, Macros, GRAPH and STAT.
- Created reports and stored procedures using SAS BI tool.
- Developed the data warehouse system for credit/debit OLTP process.
- Worked on transaction data and CRM data in credit limit increase and in marketing.
- Extracted data from Oracle views using various SAS/Access methods including Libname statements and SQL Pass through facility.
- Used in file statement options to control processing when reading raw data files in SAS.
- Produced multi-dimensional reports and tables using procedures PROC/REPORT, PROC/TABULATE,PROC/SQL and DATA NULL .
- Developed utility macros for standard reports and validations.
- Involved in validating other programmers code.
- Developed SAS programs for quality checks.
- Created efficient SA program using SAS Macros and Validated the same to optimize the resource utilization and faster processing .Documented and maintained libraries and catalogues of SAS programs and
- Created and extracted Oracle tables from SAS and within Oracle by using PL/SQL using SAS/ACCESS and SAS/CONNECT
- Used IMPORT and EXPORT procedures for importing and exporting the data to MS/EXCEL files.
- Developed programs in SAS/Base and SAS/SQL pass-through facility which produce the efficiency and to perform complex joins using the Oracle databases
- Enhanced reports through the use of labels, SAS formats, User-defined formats, titles, footnotes and SAS system reporting options
- Generated HTML, RTF, PDF reports using ODS statements.
- Produced high quality graphs through SAS/GRAPH for analysis studies.
Environment:SAS 9.1.3, SAS/Macros, SAS DI Studio 3.4 4.2, SAS Enterprise Guide 3.4 4.2, SAS EBI, SAS Management Console 9.1, SAS OLAP Cube Studio, SAS Enterprise Miner 5.3, SAS Information Map Studio, SAS Web report Studio,SAS Add-in for Microsoft Office, SAS Information Delivery Portal
Confidential
SAS Programmer /Analyst
Responsibilities:
- Involved in development and testing of client specific SAS based software package for SAS dome
- Migration project.
- Acted as a Business Analyst and Gathering the requirements from users and documented.
- Designing of UNIX environment and migrating the users from Windows to UNIX and creating the folder
- structure in UNIX.
- Changing of SAS codes from Windows environment pointing SQL to TERADATA and migrate the codes to
- Creating the shell scripts in UNIX for creating the folder structure in UNIX and creating the .profile for the users.
- Worked on the Credit Bureau Simplification project for campaigning auto loans.
- Designing the tools needed for SAS Dome migration for the Capital One Auto Finance Data analysts.
- Installed and creating a Scheduling tool PCRONTAB on UNIX platform.
- Migrating of data from SQL Database to TERADATA containers to be used for analysis.
- Capability of resolving data quality issues during the migration of data from SQL Database to TERADATA
- Assisted users with SAS Dome migration questions and occasionally with general PC, system
- and database questions
- Generated HTML, RTF, PDF and text reports using ODS statements and performed data analysis using SAS Base, TERADATA 12. And Microsoft Excel
- Created automated FTP's, automated Email macros using SAS and UNIX to desktop for analysis.
- Helped various team members in setting up SAS Enterprise Guide environment.
- Worked on administration and configuration of SAS Web Report Studio and Information delivery portal to create new users and authorizations and configuring the mail servers for the same.
- Experience in handling multiple projects.
- Developed and executed quality control checks on the data loaded in Teradata databaseby comparing the Dep2 and Dep3 data models.
- Developed ,Tested and scheduled codes for automated periodic reporting using SAS Management
- Console and verified its flow using SAS flow manger
- Proficient in working different databases environment such as MS SQL server and Teradata
- Experience in handling large databases and merging tables with millions of rows and creating test cases.
- Excellent organizational, inter-personal and presentation skills along with an ability to work efficiently in both independent and team environment.
Environment:SAS 9.1.3, SAS EG 4.1 4.2,SAS Add-in Microsoft office, Windows SAS, SAS Management Console,
Confidential
SAS PROGRAMMER
Responsibilities:
- Interacted with business users, business analysts and translated business requirements into technical specifications.
- Responsible for writing SAS programs using Base SAS and SAS/Macros to create SAS reports.
- Extensive study, design, development and testing were carried out in Oracle environment.
- Extensively involved in getting data from Oracle database using SQL pass through.
- Involved in writing code using SAS/Base and SAS/Macros for creation of analysis datasets.
- Performed data cleaning to eliminate duplicate and inaccurate data.
- Developed and executed SAS SQL queries for merging, concatenating and updating large volumes of data.
- Generated high quality reports and listing HTML, EXCEL and PDF formats using SAS/ODS.
- Quality checking, validating and verifying accuracy of reports developed.
- Producing reports by employing various SAS procedures like Proc Print, ProcReport,Proc Summary, ProcFreq, ProcTabulate, ProcMeans and ProcSQL.
- Generated highly customized reports using Data Null , Put statements, Proc Report, Proc Tabulate and Proc print.
- Creating, maintain and running SAS jobs to support specific solicitation and loading of database tables for analysis.
- Utilized korn shell scripting to automate daily tasks such as monitoring, reporting, archiving and error handling.
Environment:SAS/Base 9.1, SAS/EG 4.0, SAS/Macros, SAS/Access, SAS/Connect, SAS/Unix, SAS/ODS, Oracle9i, TOAD, SQL, MS Excel, Autosys.