Summary

• Software professional over 7+ years of experience in SQL/SAS programming with an ability to transform the needs of business users into technical requirements.
• Proficient in databases like Oracle, MS Access and MS SQL Server.
• Good Experience in Base SAS, SAS/SQL, SAS/Macros, SAS/ODS, SAS/Stat.
• Good at creating Tables and Views as per the business and design requirements.
• Experience in writing and debugging Stored Procedures and Triggers and user defined functions to facilitate efficient data manipulation and data consistency.
• Experience in Importing/Exporting Data from various data sources like Excel, Oracle and Flat file.
• Excellent knowledge and work experience data manipulation, data cleaning, sorting, concatenating, stacking, interleaving, merging and combining SAS datasets using SAS/Base, SAS/Enterprise Guide and SQL
• Skilled in writing to automate SAS related tasks and conversion of SAS Datasets to various file types (including HTML, Word, PDF, Excel, ASCII, and flat files) as well as converting various file types to SAS Datasets
• Experience in importing/exporting data between library files and flat files using SAS Data and Proc steps
• Expertise using SAS/MACROS and proc’s to access, extract, modify, merge, and analyze customer data and to generate statistical analysis reports
• Expertise in generating Graphs using SAS procedures Proc Gplot, and Proc Gchart
• Good Experience in joins, indexes, constraints of database objects
• Good understanding ofRDBMS, Normalization, OLAP and OLTP.
• Expertise in loading, cleaning and validating data.
• Experience in writing and executing test cases, bug reporting and manual testing.
• Worked on agile methodology as well as traditional testing methodology (STLC).

Technical Skills

Computer System: Windows XP/ 2000 / NT, UNIX

Speciality Software: Base SAS, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/Access

MS Technologies: Visual Studio 2008, Visual Basic 6.0

Databases: SQL Server 2008/2005, MS Access, Oracle 10g

Other Tools: Bugzilla, Mantis, MS Visio, MS Project, HP QTP, MS Office Suite.

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

SAS Programmer

Responsibilities:

• Used SAS v9.2 UNIX environment and Programming in SAS base and Macros Performed cluster analysis to identify critical factors for Software designing.
• Interacted with assigned business analysts to perform work outlined.
• Created database objects like tables, views, stored procedures, functions, joins, indexes and triggers in T - SQL based upon the functional specifications.
• Reviewed the existing stored procedures and improved efficiency by critically evaluating the code and optimized.
• Developed complex T-SQL Queries and SQL Scripts for efficient data load based on complex Business rules.
• Accessed multiple databases using SAS and provided ongoing reporting that supported information-based decision making.
• Documented and delivered Functional Specification Document to the project team.
• Used SAS procedures such asReport, Tabulate, Freq, Means, Summaryand Transposefor producing customized reports.
• DevelopedSASprograms to extract, transform, clean and manage large data files.
• Validated existing Data Model and identify opportunities for removing redundancies.
• Worked with SAS/ODS, HTML to produce dynamic web interfaces from SAS programs

Technologies:

• Base SAS, SAS/Graph, SAS/Macros, SAS/SQL, SAS/STAT
• SAS/Access, SAS/Connect, SAS enterprise Guide.
• MS SQL Server,MS Visio, MS Project, MS Office

Confidential, Providence, RI

SAS Developer

Responsibilities:

• Involved in updating and retrieving data from Data Warehouse and generating analysis reports using SAS/BASE, SAS/MACRO, and PROC REPORT.
• Extracted of data from ORACLE and other flats files into SAS Data Sets using SAS/Access, SAS/Connect, Proc SQL, and SAS Import Utilities. Designed and created the SAS Data Sets from Excel Spreadsheets and also from different kinds of flat files for data manipulation purposes.
• Extensively used SAS/Macro facility to create macros for statistical analysis, results reporting and data extraction.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools such as SAS/Base, SAS/Macros, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access.
• SAS Data Integration studio for ETL and generation of master datasets from various databases, as well as loading into different complex databases like Oracle, Teradata
• Used SAS Enterprise Guide to create various reports, Analyzed the data from various source, Created different charts.
• Used SQL*Loader Facility to load the SAS data sets and other flat files to Oracle Database.
• SQL and SAS Code Tuning for increased performance. Reviewed and Streamlined old SAS code to eliminate errors and improve functionality.
• Created Star Schema tables from Relational Schema tables using Data Integration Studio and created OLAP Cubes using Futrix, a SAS based, intuitive and interactive reporting and analytical OLAP tool.
• Used SAS IDP for Developing portal pages and portlets and SAS BI Dash boards.
• Used SAS Integration Studio to extract the data from different sources by applying filters, transformations and load data into data marts/Data warehouse.
• Developed macros to validate the pre-existing model to be used on any data set for future use, using PROC MEANS, PROC MODE, and PROC UNIVARIATE, etc.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT, and PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts.
• Created required financial reports using analysis output and export them to other environments or the web using various SAS method like create delimited, text files, ODBC, CEDA, CPORT, ODS having formats such as HTML, RTF, or XML.
• Regular interaction with the financial analysts for the presentation. Performed in-depth quantitative data analysis. Coded SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.

Technologies

• Unix, Windows NT, MVS,
• SQL, PL/SQL, TERADATA, Oracle, PL/SQL, SQL*Loader, DB2
• SAS Data Integration Studio, SAS Enterprise Guide, SAS Web report Studio, Base SAS9.2, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, SAS Information Map Studio.
• UNIX SHELL SCRIPT
• Micro Strategy, ETL

Confidential, CA

SAS BI Developer

Responsibilities:

• Using SAS Enterprise Guidebuild advanced querying, calculating computed columns, using filter, sorting, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generates summarization SAS datasets.
• Imported summarization SAS datasets from SAS Management Console to SAS Information Map Studio.
• Using Information Map Studio to build information maps structures
• View Information maps from Web Report Studio or Information delivery portal.
• Using SAS Stored Process Web application to build Selection Screens and Dash Boards.
• Olap Cube Studio to build Olap cubes.
• Strong experience in using proc Sql method to pull data from different data bases like Oracle, Sql, and Teradata.
• Solid foundation in use of SAS macro, SAS/Connect, SAS/Access, SQL,Oracle,Teradata relational table structures and FTP interfaces between platforms and the UNIX environment.
• Experience in converting programs from one version of SAS to another version(Process of moving from SAS Version 8 to SAS Version 9).
• Experiences using SAS Version 9 (especially the Business Intelligence Platform tools) SAS Enterprise Guide 4.0,SAS StoredProcesses Web Application,SAS Web Report Studio,SAS Information Map Studio 3.1, SASInformation Delivery Portal, SAS OLAP CUBE Studio 9.1, SAS Web OLAP Viewer For Java,SAS Enterprise BI Server,Tomcat/ Apache.
• Ability to mentor or transfer skills to others.
• Reviewing business requirements for standard reporting
• Using SAS Business Intelligence (BI) to drive the automation of standardized analytics
• Generating SAS EG stored processes for product-specific analyses
• Participating in the development of outcomes and process measures
• Identifying opportunities to productize standard reports
• Advanced Querying using SAS Enterprise Guide, calculating computed columns, using filter,manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generates SAS datasets.
• Imported SAS datasets from SAS Management Console to SAS Information Map Studio.
• Using Information Map Studio Stores instructions on how to access and combine relational
• Data tables, calculating new data items, created multiple pre-defined filters.
• Build Quick Reports from Web Report Studio using Information maps, create filters, graphs, and customize reports.
• Using SAS Stored Process Created Selection Screens and Dash Boards.
• Builds Pivot tables from SAS Olap Cube Studio
• All Reports Imported from web report studio, Stored Process and Information Map to Information Delivery Portal.

Technologies:

• SAS 9.1.3, SAS 9.2,,SAS Enterprise Guide 4.0 & 4.2, SAS StoredProcesses Web Application,SAS Web Report Studio,SAS Information Map Studio 3.1 & 4.2, SASInformation Delivery Portal,SAS OLAP CUBE Studio 9.1 & 9.2,Teradata, Oracle 8i, SQL,Linux RHEL 4, SAS Data Integration Studio 4.3, Windows XP/NT Sybase, Teradata, DB2, PL/SQL and UNIX.

Confidential, Durham, NC

Responsibilities:

• Created SAS datasets from Oracle database with random sampling technique and created Oracle tables from SAS datasets by using SAS Macros.
• Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset merging techniques of SAS/BASE.
• Analyzed data using various statistical procedures like PROC SUMMARY, PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA.
• Used SAS macro facility to create macros for statistical analysis, reporting results and data extraction.
• Proposed a set of action plans to mitigate the risks identified with the sourcing decision.
• Generated HTML, Listing, Excel and RTF reports for presenting findings of various statistical data using procedures like PROC REPORT, PROC FREQ and also SAS ODS.

Technologies:

• SAS/BASE, SAS/ACCESS, SAS/GRAPH, SAS/MACRO, SAS/ODS, SAS/SQL, SAS/STAT,
• SQL, ORACLE