Summary:

• Base SAS and has around 7 years of extensive experience as SAS programmer, SAS Analyst in Marketing, Technology Industries and Banking for data analysis, coding and implementation in Windows and UNIX environments.
• Knowledge with Business Intelligence SAS developing dashboards, web reports and queries to SAS OLAP cubes and publishing private and public documents on SAS store procedures.
• Wide experience with SAS Support with users and administrators.
• Hands on experience SAS Management Console administration and development on SAS OLAP cube studio, SAS INFOMAP studio, SAS Microsoft Office Add In, SAS Enterprise Miner.
• Part of the team on the migration and implementation for upgrading SAS platform.
• Extensive experience in Statistical Analysis, Reporting involving Analysis, design, development, testing and validating the applications.
• Experience in handling complex processes using SAS/BASE, SAS/MACROS, SAS /SQL, SAS/GRAPH, SAS/STAT, SAS/ODS, SAS/ACCESS, SAS/CONNECT.
• Proficient in Importing or extracting data using Import techniques to create SAS datasets from various sources like Relational databases by connecting SAS System to database systems, such as Microsoft SQL ,Oracle, DB2, Excel, flat files , and Exporting data to generate dynamic reports in HTML, RTF, XML, Excel, and PDF formats by using SAS/ODS .
• Knowledge of collecting client's requirements and accessing datasets from the client's data warehouse using Base SAS.
• Programming experience with procedures like PROC DATASETS, PROC PRINT, PROC APPEND, PROC GPLOT, PROC GCHART, PROC COMPARE, PROC IMPORT, PROC EXPORT, PROC FORMAT, and PROC COPY.
• Hands on experience in data management like Merging, concatenating, interleaving SAS datasets using MERGE and SET statements in DATA step and using PROC SQL.
• Creating new SAS Programs using SAS MACRO to improve ease and speed of modifications as well as consistency of results.
• Expertise in using SAS report generating procedures like PROC REPORT, PROC SQL, PROC TABULATE, PROC TRANSPOSE, PROC SUMMARY and Optimized performance using Data Validation and Cleaning on Costumer data using statistical procedures like PROC FREQ, PROC MEANS, and PROC UNIVARIATE.
• Knowledge of using SAS 9.2/Enterprise Guide in Data Analysis, understanding of RDBMS Oracle 8/8i/9i, 10g, 11g, MSSQL, DB2 , PLSQL, Microsoft Excel, PowerPoint. Programming in C UNIX.
• Possess strong ability to quickly adapt to new applications and platforms. Experience in interacting with clients, multiple user groups and managing development teams.
• Experience in supporting multiple projects under deadlines often with competing priorities and complexities by applying critical thinking, problem solving, and decision making skills to optimize solutions.

Technical Skills:

Professional Experience:

Confidential

Business Intelligence/Architect

Responsibilities:

• Collaborate as Business Intelligence expert on SAS with Credit Cards and Laundry Money projects
• Collected requirements from project managers and prepare designs for new applications on Business Intelligence platforms.
• Attended project team meetings, interacted with Project Managers, Data Managers and Analyst.
• Involved in generating best practices and improvements on scheduled process.
• Involved in Extensive coding in base SAS including Dashboards, Executive Reports, ETL process, Data Cleaning, Data Quality, analysis Datasets, Tables, Listing and Graphs, and SAS performance.
• Importing data from different file formats and creating datasets to get desired output using Import procedure.
• Extracted data from Oracle database using SQL Pass through facility.
• Sorting the data and deleting duplicates by using procedures like PROC SORT in order to produce quality results
• Creating SAS code to clean the invalid data using SAS Macros and SQL procedure.
• Sorting, printing and summarizing the datasets to modify and combining SAS datasets using sort procedure, set and merge concepts.
• Developed SAS programs to format the data for understanding and used various validation techniques such as proc summary, proc means, and other data step techniques.
• Developed SAS Customized Reports using REPORT, TABULATE procedures and DATA NULL .
• Development for SAS OLAP Cubes with SAS Base and SAS OLAP Cube Studio.
• Development for SAS WebReportStudio reports and dashboards.
• Development for SAS store procedures and reports.
• Management with SAS Management Console groups security and schemas.
• Implementation from SAS Enterprise Miner projects on scheduled process.
• Developed daily input report, monthly reports using PROC SUMMARY, PROC TABULATE and PROC ANOVA and generated tables and listings using various procedures like PROC MEANS, PROC FREQ, PROC TRANSPOSE, PROC REPORT, PROC UNIVARIATE, and generated graphs using PROC GCHART and PROC GPLOT.
• Generated the reports in desired output format HTML, PDF and RTF format files for decision making using SAS ODS OUTPUT DELIVERY SYSTEM
• Listings and Reports were created by patient, Treatment group using Proc Report

Environment: Oracle 10g 11g , DB2, SAS 9X, SAS/BASE, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/MACRO, SAS/ACCESS, SAS/ODS, UNIX AIX , MS Access, Excel.

Confidential

ETL Developer

Responsibilities:

• Developing and testing a series of mappings process loading tables.
• Design mapplets and scheduled process on Informatica.
• Importing data from Oracle to Oracle.
• Working with SAP form PowerCenter.
• Shell scripting for auditing process

Environment: AIX, Windows, Oracle, Informatica PowerCenter

Confidential

SAS Programmer

Responsibilities:

• Collaborate as Business Intelligence expert on SAS platform consolidation project
• Design and administration for global shared platform and migration plan.
• Attended project team meetings, interacted with Project Managers, Data Managers and Analyst.
• Involved in generating best practices and improvements on scheduled process.
• Involved in Extensive coding in base SAS ETL process, Data Cleaning, Data Quality, analysis Datasets, Tables, Listing and Graphs, and SAS performance.
• Importing data from different file formats and creating datasets to get desired output using Import procedure.
• Extracted data from Oracle database using SQL Pass through facility.
• Sorting the data and deleting duplicates by using procedures like PROC SORT in order to produce quality results
• Creating SAS code to clean the invalid data using SAS Macros and SQL procedure.
• Sorting, printing and summarizing the datasets to modify and combining SAS datasets using sort procedure, set and merge concepts.
• Developed SAS programs to format the data for understanding and used various validation techniques such as proc summary, proc means, and other data step techniques.
• Developed SAS Customized Reports using REPORT, TABULATE procedures and DATA NULL .
• Development for SAS OLAP Cubes with SAS Base and SAS OLAP Cube Studio.
• Development for SAS WebReportStudio reports and dashboards.
• Development for SAS store procedures and reports.
• Management with SAS Management Console groups security and schemas.
• Implementation from SAS Enterprise Miner projects on scheduled process.
• Developed daily input report, monthly reports using PROC SUMMARY, PROC TABULATE and PROC ANOVA and generated tables and listings using various procedures like PROC MEANS, PROC FREQ, PROC TRANSPOSE, PROC REPORT, PROC UNIVARIATE, and generated graphs using PROC GCHART and PROC GPLOT.
• Generated the reports in desired output format HTML, PDF and RTF format files for decision making using SAS ODS OUTPUT DELIVERY SYSTEM
• Listings and Reports were created by patient, Treatment group using Proc Report

Environment: Oracle 10g 11g, SAS 9X, SAS/BASE, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/MACRO, SAS/ACCESS, SAS/ODS, UNIX HP-UX , OpenVMS, MS Access, Excel.

Confidential

Marketing Intelligence Analyst

Responsibilities:

• Involved in creation of Analytical Dataset, Data mining process and customer travel behavior.
• Automation on sharing partners on marketing campaigns like transmissions and encrypting.
• Analytical Dataset for marketing campaigns performance.
• Executive reports and Dashboards on SAS for finance and analytical areas.
• Document and Analyze results and set up reports containing respective conclusions, ideas and general guidance
• Creating and generation of SAS Reports for Project Team Lead review

Environment: SAS9.1.3,SAS/BASE, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/ACCESS, Microsoft Office Applications, Windows 2000, Windows NT, UNIX.