SUMMARY:

• 7+ Years of IT Experience in SAS Programming and Development with diversified client Banking, Healthcare, retail etc.,
• Very good understanding of SAS programming for extracting data from flat files, Excel spreadsheets and external RDBMS (ORACLE) tables using LIBNAME and SQL Pass - Through facility. Expert level SAS Advanced programming experience in various environments like PC/SAS, UNIX and Mainframes.
• Strong experience in SAS/Base, SAS/Graph, SAS/Stat, SAS/Connect, SAS/Access, SAS/ODS, SAS/SQL, SAS/Macro, SAS/EG, SAS/Share, SAS Enterprise BI Server
• Expertise in Marketing Strategy development, financial models, DSS Decision Support Systems and documentation, Risk Analysis Factor Analysis and Forecasting.
• Experience in the BI Suite in SAS including SAS Enterprise guide, SAS Web Report Studio, SAS Data Integration Studio and Information Map Studio.
• Proficient with relational database concepts such as SQL, MS Access and reporting using SAS.
• Having knowledge of data warehousing, tables and structure.
• Having extensive domain knowledge and experience in the diversified fields of Banking, Healthcare, financial service Sectors.
• Created RTF, PDF, and HTML listings, tables and Reports using SAS/ODS.
• Sound knowledge of linear programming, probability, statistics, design of experiments, quality assurance and optimization techniques.
• Strong analytical, communication and organizational skills with the ability to analyze business practices and define and document optimal procedures or practices.
• Strong experience with databases like Oracle, MS SQL Server, Teradata, DB2 and MS Access.
• Extensively used SAS procedures such as freq, report, tabulate, sort, print, transpose, summary and means for producing customized reports and external files.
• Experience in data manipulation and data cleansing by using procedures such as Proc datasets, Proc sort, Proc transpose etc.
• Working on handling clients Key Enhancement Work Requests by following SDLC process.
• Documenting data in the appropriate way by following quality standards for future use and reference.
• Achieving customer satisfaction by ensuring service quality norms and build the company image by exceeding customer expectations.
• Worked with multiple teams like data analysis team, risk analysis team, marketing team to understand the data relationships.
• Highly motivated, organized with strong analytical and communication skills in establishing effective task priorities as a team player with result oriented Confidential itude.

TECHNICAL SKILLS:

SAS Tools: SAS/BASE, SAS/SQL, SAS v8.x/9.x, SAS/MACRO, SAS/EG, SAS/STAT, SAS/ODS, SAS/GRAPH, SAS/ACCESS, SAS/CONNECT.

Databases: Oracle 8i, 9i, 10g, MS SQL Server (2000, 2008), DB2, Teradata, MS Access

Operating Systems: UNIX, Windows 95/98/XP/Vista/Win 7, MAC OS, DOS.

Web Technologies: SQL, PL-SQL, C#, Core Java, HTML, XML.

Documentation Tools: MS Office (Excel, Word, Power Point, Access and Visio)

Other Tools: UltraEdit and FILEMASTER for DB2, Teradata SQL Assistant, TOAD9.5, CoreFTP, Putty

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

r. SAS Programmer/BI Analyst

Responsibilities:

• Used SQL and PROC SQL to work with ORACLE and DB2. Performed ETL on Oracle and DB2 data bases to extract and prepare data for analysis and reporting.

• Extracting, validating and manipulating the data as per user requirements by using SAS Base and Macros.
• Setting up SAS datasets by Extracting Data from Excel tables into SAS datasets using PROC IMPORT and Data steps.
• Used SAS Web Report Studio and EG to automate the reporting systems to generate daily and monthly reports for advanced premiums, delinquency reports, default report, adjustments etc.
• Involved in standardizing reporting procedures for graphical and tabular reports.
• Used SAS/EG for data pull, target creation and creation of new variables (Transaction data library) from raw datasets. Utilized SAS macros, Stored Processes and Information Maps to generate complex reports in Web report studio.
• Performed Data Cleansing widely during the ETL's Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros.
• Constructed SAS programs on UNIX platform to clean the data according to the specifications
• Generated Information Maps using Information Map Studio and created Ad-Hoc reports on need basis using SAS Web Report Studio.
• Wrote Output Delivery System SAS Procedures to publish reports as HTML pages to the Web.
• Involved in developing a SAS code for Acquisition models, X-Sell and Up-Sell marketing models, segmentation and targeting and camp Confidential n optimization.
• Analyzed various data formats using SAS Enterprise Guide & Generated Web Based Reports using SAS Web Report Studio.
• Validating and profiling the variables using SAS Base / Macros using proc freq, proc means, proc format and proc univariate.
• Automated report generation in the Windows environment for the efficiency during Production and in the Production Environment.
• Created batch and interactive applications utilizing SAS/Base, SAS/SQL, and SAS/Macros.
• Consolidated reports and alerts are generated daily using SAS.

Environment: SAS/SQL, SAS/Connect, SAS/Access, SAS/Base, SAS/ODS, Enterprise Guide (EG 7.1), SAS Web Report Studio, Oracle, Teradata, DB2, UNIX, Windows 2003, Oracle10g, MS Access, Excel.

Confidential, Des Moines, IA

Senior SAS Developer Responsibilities:

• Created macro program to create Macro variables to pull data from oracle and SQL server for monthly daily data extracting.

• Reviewed the Business Requirement Documents and the Functional Specification.
• Provided support on SAS EBI platform, portal and dashboards
• Imported all Reports from web report studio, Stored Process, BI Dashboard and Information Map to Information Delivery Portal.
• Generated SAS EG stored processes for product-specific analyses
• Extracted raw data from an Oracle database and used SAS/Access to read it and run statistical analysis using SAS/Stat.
• Constructed SAS programs on UNIX platform to clean the data according to the specifications.
• Involved in designing the project and process flow diagrams using SAS Enterprise Guide
• Design, coding, testing, debugging, and documentation of multiple treatment and payment SAS programs for charge-off card data.
• Conduct data mining and statistical analysis to improve existing strategies.
• Extensively used PROC MEANS, PROC FREQ, PROC SORT, PROC PRINT and PROC PLOT procedures to extract and prepare integrated data, performed analysis on it.
• Created reports using Proc Report, Proc Tabulate, ODS statements and Proc Template to generate output formats in HTML Excel and RTF.
• Generated SAS customized reports using the DATA NULL and Proc Report techniques.
• Used SAS Proc SQL pass through facility to connect to Oracle tables and created SAS datasets using various SQL joins such as left join, right join, inner join and full join.
• Used SAS Macros and SAS SQL to query data and to obtain results which were generally stored as delimited text.
• Worked for Analytics team to update the regular reports and providing solutions for the ad-hoc requests.
• Developed numerous ad-hoc SAS programs to create summaries and listings.
• Created SAS Macros and SAS Graphics. Customize the existing programs using macros as per the statistician’s requirements
• Possess strong ability to quickly adapt to new applications and platforms.

Environment: SAS/SQL, SAS/ODS, SAS 9.3, SAS/Base, SAS/BI, SAS/Graph, SAS/Stat, Teradata, DB2, Oracle 10g/11g, Access, Informatica 9.1, Crystal Reports, Unix, HP ALM, SAS Enterprise Guide, Excel.

Confidential, Minneapolis, MN

SAS Programmer/Analyst Responsibilities:

• Worked with the analysis teams and the risk management teams and supported them by providing variables based on their requirements.

• Developed SAS BI Dashboards which are used to monitor key performance indicators.
• Made transaction data broadly accessible to program teams and worked towards implementing the targeted business strategies.
• Created reports using SAS Enterprise Guide for summarizing portfolio experience, including information about the current business environment, portfolio trends, expected portfolio losses and the forecast assumptions.
• Developed New SAS programs to generate new reports in HTML, RTF and txt format.
• Facilitated the automation process for the Delinquency Report -This report was required to run on a monthly basis and was required to show 13 months of data.
• Automated many standard and ad hoc reports generation and also involved in creating New Scorecards and Reporting the changing values.
• Created Customized reports and Stored processes in Enterprise Guide for the users.
• Used SAS ODS, SAS Graph, and procedures Proc Tabulate, proc means to create ad hoc reports and graphs as per the requirements of the users.
• Developed statistical reports with Charts, Bar Charts, Box plots, Line plots using PROC GPLOT, PROC GCHART and PROC GBARLINE.
• Used Proc Template to produce customized report in spreadsheet with footnotes, titles, and pages numbers, eliminating user's work to customize the report.
• Created monthly, quarterly, and annual performance reports for senior management using SAS/EG and PC SAS.
• Extensive use of Proc freq, Proc Report, and Proc Tabulate for reporting purposes.
• Participation in strategic initiatives, which includes leading, organizing, and facilitating initiatives and/or meeting from a risk perspective.

Environment: SASv9.1.3, SAS/BASE, SAS/GRAPH, SAS/SQL, SAS/MACROS, SAS/EG, Oracle, SQL Server, AS/ACCESS, Excel.

Confidential, Plano, TX

SAS Programmer/ Analyst

Responsibilities:

• Created customized reports to help client provide in understanding risk and accordingly perform better customer selection and customer satisfaction.

• Developed and created SAS Macros to access and analyze data.
• Created new and modified SAS programs by analyzing the data and created study specific datasets which are used as source datasets for report generating programs.
• Created permanent form Confidential ed SAS data sets and developed reports using Proc Report, Proc Tabulate and used Data Null for analysis.
• Wrote programs in SAS to generate reports, created RTF, HTML listings, tables and reports using SAS/ODS for Ad-Hoc report generation.
• Proficiently used SAS procedures like PROC SQL to extract data from different relational database management systems and used SQL Assistant to analyze and query from the Teradata DB.
• Produced reports and complex data analyses using SAS, including SAS/stats, extracted data from Oracle files using SAS/Views, SAS Proc SQL and SQL.
• Involved in various file correction in test and production IMSDB, DB2 environment.
• Used SAS Proc SQL to extract data from different relational database management (Teradata) systems, used SQL Assistant to analyze and query from the Teradata database.
• Developed SQL Pass through Queries to fetch complex data from different tables from remote databases.
• Developed various backend SAS application programs, such as Proc import, export, Functions, Triggers, Procedures and Packages using SAS and SQL language for the top management for decision making.
• Created reports in Excel spreadsheets which are capable of performing automatic calculations.
• Developed routine SAS macros to create tables, graphs and listings.

Environment:: SAS/Macros, SAS/SQL, SAS/ETL, SAS/Graph, SAS/ODS, SAS/Stat, SAS/Base, SAS/Macros, SAS/Connect, Oracle, Unix, DB2AS/Enterprise Guide, CICS, Unix and Teradata, MS Access, Windows, SQL Server, MS office