Professional Summary

• SAS Certified Advanced Programmer with 8 years of IT experience including 6 years of experience in Statistical Analysis, Reporting, and BI Data Warehousing.
• Experience in all phases of Software development Life-Cycle SDLC including Gathering requirements, writing test cases, conducting testing, Data quality evaluations and verifying results peer-review .
• UNIX operating system expertise, Data warehousing expertise and experience with querying large RDBMS tables Data Mining . experience with data models including both relational and dimensional models.
• Experience with Descriptive statistics, Advanced statistical modeling and HASH object processing.
• Strong T-SQL, ANSI SQL experience in tuning code using techniques like Temporary tables and Indexes.
• Produced data in various output formats including HTML, RTF, PDF and PS using SAS ODS..
• Transpose or normalize tables to simplify processing and reduce complexity of ETL.
• Used SAS DIRECT I/O for large datasets to achieve higher read-write speeds on SAS Dataset processing.
• Technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management experience. Produced Tables, Listings and Graphs TLG for the analyzed data.
• Performance tuning with techniques like INCLUDE shared code, MACRO Subroutines, Stored Process, parallel processing and USER Written Function using PROC FCMP.
• Strong SAS/ACCESS experience to import data from various databases like MS-SQL Server, ORACLE, NETEZZA tables into SAS using IMPLICIT and EXPLICIT pass-through facilities.
• using SAS/BASE, SAS/MACROS, SAS /SQL, SAS/GRAPH, SAS/STAT, SAS/ODS, SAS/ACCESS,SAS Enterprise Guide, SAS Information Map Studio, SAS DI Studio, SAS OLAP Cube Studio, SAS Web Report Studio.
• Experience in handling complex processes for Extraction, Transformation, Loading ETL and Data Analysis.
• Domain knowledge of Credit, Retail, Direct-Marketing, Insurance, Financial, Mortgage, Telecom and Banking industries.
• Experience in updating and creating documentation of code, guidelines, and high level systems documentation.
• Mentored other team members by knowledge transfers, conducting one-on-one training in SAS, SQL and UNIX.
• Exceptionally well organized. Ability to quickly adapt to new applications and platforms.
• Strong work ethics, positive attitude, analytical and communication skills.

Technical Skills:

Professional Experience:

Confidential

Sr. SAS BI Developer

Responsibilities Activities:

• Worked on setting up the BI 9.2 Platform and creating user access to the SAS system and repositories for various departments
• Implemented the recently released Enterprise Guide custom filter functionality in EG 4.3 for automation of Reports. Based on my feedback, SAS created usage notes 42032 and 42043
• Created KPI dashboards using custom add-in tasks in SAS Enterprise Guide 4.3
• Upgrading and testing SAS Enterprise Guide, web report studio, Information Map studio and SAS MS-Add in from 4.2 to 4.3
• Built a template for the loan lists and Summary reports to be used across the company.
• Created custom styles for use in enterprise guide using the EG CSS style sheets.
• Used various Tagset options in SAS ODS Mark up engine Excel XP, MS office, MSoffice2k to deliver the Formatted EG reports as XML /HTML sheets that could be opened with Excel directly.
• Created Custom Stored Compiled Macro's to help Analysts export 'formatted' datasets to MS excel.
• Fine tuned the WRS settings to provide printing to PDF capability.
• Created the SERVICER DATA DICTIONARY that had the names, sources, type of data and descriptions of the SAM Servicer Analytics Mart fields.
• Automated the SAS EG reports by building recurring date filters in Information Map's and Enterprise Guide.
• Implemented a solution to import custom Banners for the reports to be used with SAS Web report studio.
• Trained Analysts with the new reports and helped then with their questions on using SAS EG, WRS etc..
• Participated in resolving the issue with the SAS EG 4.3 and SAS MS OFFICE ADD-IN upgrade.

Environment: SAS 9.2 BI platform, SAS 9.2 M3 , EG 4.2,4.3, SAS Web Report Studio WRS 4.3, SAS Information Map Studio 4.2 IMS , SAS MS-Add in 4.3, SAS 9.2 Stored Process Server, SAS/STAT, SAS/BASE, SAS/MACRO, SAS/GRAPH, SAS/ACCESS, SAS-QC, MS-SQL Server 2005/2008, Business Objects XI 3.1

Confidential

Sr. SAS BI Data Warehouse Analyst

Responsibilities Activities:

• Worked on Issues related to SAS 9.1.3 to SAS 9.2 Migration along with testing of existing production jobs and Ad-hoc queries in the new environment.
• Collected the Requirements for SAS Dev Environment and laid the road map for development environment.

Confidential

SQL Server

• Testing of Production Jobs and End user Ad-hoc Queries on Netezza and MS FastTrack Data Warehouse Accelerators along with Concurrency Load tests.
• Designed the Behavioural Score Job BS12 Re-Engineering Document, and worked with BI Data warehouse Architect to help in modelling and re engineering of the Behavioural Score Job.
• Tuned the Behavioural Score Job to decrease the insert times from SAS to SQL Server from 20 minutes to 2 minutes to load 3 million records.
• Re-Architectured the New Customer Acquisition NCA SAS Job Pulls approximately 250 million records
• Identified the BULKUNLOAD failure and Delimiter error from SAS against Netezza and worked with SAS on resolving the issue. SAS Released a Hot fix for SAS ACCESS 9.2 M3 to Netezza software to fix the error on receipt of ticket opened by me.
• Worked on Mapping the New Integrated Data warehouse IDW Fields to existing fields in the current Databases.
• Developed a CUSTOM SAS Program to track Risk Group variations among Customers on a Monthly Basis for the last 'N' campaigns Value of N given as input to the Script .