SUMMARY

• 8 years of robust professional work experience in Data Cleaning, Data Aggregation, Data Mining, Data Analysis, Application Development and Reporting with SAS.
• Worked with the management team and the client to understand the technical specs and requirement gathering and then presenting the reports.
• Hands on experience in using quantitative approach to solve analytical problems.
• Prepared technical specs for project. Designed logical flow of SAS programs to validate the requirements.
• Hands on experience with SAS/BASE, SAS/MACRO, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/CONNECT and SAS/ODS procedures.
• Experience in processing large datasets with billions of records for data transformation including data cleansing, data scrubbing, data profiling and applying business logic rules to incoming data.
• Experience in performing ad hoc queries and User Acceptance Tests (UAT) for various application and reports on a daily/weekly or monthly basis.
• Conducted statistical and logical analysis of large sets of transaction data, looking for patterns that can aid decision making using advanced SAS/STAT procedures including Multivariate Analysis, ANOVA, Decision Tree, Correlation and other statistical methods.
• Extensive experience transferring data across platforms (Mainframe, Unix, PC) based on the business and reporting needs.
• Vast experience in presentation using SAS, Excel, PivotTables, DDE for presenting the end results.
• Advanced SQL skills with ability to code complex queries to load, clean, format & store data.
• Clear understanding of data modeling principles like star and snow - flake schema, dimensional data model, 3nfetc
• Designed several ETL jobs using SAS DI Studio to port the ODS data into data marts with tasks involving configuring metadata libraries in SMC, developing transformation logic and staging the final data.
• Ability to code complex MDX code for OLAP cubes to have a tradeoff between storage space and performance.
• Extensive experience in Teradata tools & utilities like SQL Assistant, BTEQ, Fast Export & TPump for business analytics and reporting on massive Enterprise Data Warehouse.
• Strong skills in requirements gathering, analysis and ETL design, coding, debugging.
• Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
• A team player and self-starter possessing excellent analytical, problem solving, communication and Organizational skills.

TECHNICAL SKILLS

Operating SystemsWindows: SAS ToolsSAS 9.2, SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ACCESS, SAS/STAT, SAS/ODS, SAS/CONNECT, SAS/GRAPH, SAS/ENTERPRISE GUIDE, SAS OLAP CUBE STUDIO, SAS/ENTERPRISE MINER, SAS/INFORMATION DELIVERY PORTAL

Databases: Oracle 9X/8.x, MS SQL Server 2000/2005, Teradata 11/12, DB2, MS Access

Informix: GUI ToolsMS Office, MS Project, MS Visio ProgrammingC, C++, Java, SQL, VBA, VB 6.0, HTML, XML

Languages: Reporting toolsCrystal Report, MS SQL Server Reporting Services, Hyperion

PROFESSIONAL EXPERIENCE

Confidential

SAS Programmer

Roles & Responsibilities:

• Designing and coding new process software implementations in Alliance Marketing Dashboard (marketing analytics).
• Coordinate with the Client to develop and run daily, monthly and quarterly processes.
• Work with business to implement their reporting needs using BaseSAS,SASSQL, andSAS Macros.
• Develop custom reporting suite using advancedSASfeatures -SAS/Access, Data Integration Studio, Information Map Studio, Web report Studio.
• Working on data QC analysis, database architecture, metadata development and data profiling.
• Working on complex datasets to extract customized reports using PROC SQL, PROC SORT, PROC REPORT and PROC TABULATE based on the specifications from BRD.
• Extensively work on detecting, describing and verifying defect, bug tracking and modifying the existing database for the improvement of existing processes.
• Develop automated processes using UNIX/LINUX shell scripts to run jobs on schedules.
• Design and develop advanced Oracle skills to enhance reports to run efficiently.
• Assisted in investigating and applying newSASprogramming methods and techniques to enhance current systems by using variousSASmacros and standard programming procedures.
• Developed new or modifiedSASprograms and used SQL Pass Through and Libname methods to extract data from the Teradata DB and created study specificSASdatasets, which are used as source datasets for report generating programs.
• Used SQL Assistant to analyze and query from the Teradata DB.
• Support the development of advanced tools and scientific models, develop statistical reports to track, analyze, optimize and forecast revenues, yields and economic impact by customer group/product/country.
• UseSASreport generating procedures like PROC REPORT, PROC FORMAT, PROC GPLOT, PROC COMPARE, PROC EXPORT, PROC SQL, PROC SUMMARY, PROC IMPORT, PROC UNIVARIATE, and PROC TRANSPOSE.
• Proficiently useSASprocedures to extract data from different relations database management systems like Teradata, Oracle.
• Perform data cleansing widely during ETL extraction and loading phase by analyzing the raw data and create complex reusable macros.
• Perform data analysis, statistical analysis, generated reports, listings and graphs usingSAStools.

​​Environment:SASv9.3/9.4, Oracle 11g,SAS/BASE,SAS/STAT,SASBI, Teradata V13,SAS/GRAPH,SAS/MACROS,SAS/SQL,SAS/ACCESS,SAS/ODS, Oracle 9i, Windows XP, UNIX

Confidential, Richmond, VA

SAS Programmer

Roles & Responsibilities:

• Extensively used SAS on UNIX platform to develop custom business solutions
• Collaborate with business area to understand business needs, capture supporting requirements and resolve issues
• Developed and supported infrastructure to implement Statistical and Economic models
• Conduct walkthroughs of requirement artifacts and communicate effectively with business, development and testing teams during construction phase to ensure clear understanding of requirements
• Effectively used version control to coordinate the development across the various phases
• Used SAS to develop custom desktop solutions for the Stress Testing of the Commercial Loan portfolio of the bank
• Extensively used SAS macros, loops and other techniques to perform program and application automation
• Imported Data from relational database into SAS files per detailed specifications.
• Responsible for implementation of the various quantitative models in retail domain targeting delinquency, charge-offs
• Participated in datamart design and build using Oracle 11g, Toad, SQL Plus for the consolidation of the very large vendor data into the enterprise systems
• Extensively used SAS procedures such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY, TRANSPOSE and Data Null for producing ad-hoc and customized reports and external files
• Wrote SAS programs in UNIX platform
• Analyzed business requirements, transformed data, and mapped source data using the Teradata Financial Services Logical Data Model tool, from the source system to the Teradata Physical Data Model
• Involved in credit risk assessment model to calculate risk factor for individual clients based on hierarchy.
• Supported in house oracle datamart administration using configured environment variables, parameters, stored procedures, group profiles
• Extensively used SAS Grid architecture on UNIX/Linux to perform job and workflow scheduling
• Used SAS and system options to improve the performance of the existing sas programs
• Participated in the process of streamlining the data process underlining the program automation
• Used SAS program techniques to develop custom and enhances reports for customers using AMO, Olap Cubes, OBI
• Used parallel processing in SAS to aggregate programs to significantly reduce the execution time of the applications that fetch aggregated and partitioned data
• Performed rigorous query tuning and performance optimization for the applications that process the large transactional data

Environment: SAS ENTERPRISE GUIDE, SAS OLAP Cube Studio, SAS Information Map Studio, Add In, SAS/SQL, SAS/MACROS, SAS/BASE, Teradata, RCS, UNIX, RCS

Confidential

SAS Programmer

Roles & Responsibilities:

• Extensively used Proc OLAP to generate cubes for DQ and custom reporting
• Adeptly performed Data Management for the Business Unit: data profiling and cleansing of business unit's assets data usingSAS.
• Developed SQL queries to fetch data from schema of terabyte range
• Developed Cubes using formats replacing aplha to conserve disk space for input tables
• Used Excel and call execute routine inSASto generate Proc Olap code having ease of maintenance
• Served as a direct point of contact with the end user to understand the requirement and develop technical solutions to deliver in terms of quality, time and accuracy
• Produced reports in excel usingSASadd-in, Proc Report and ODS Tagsets
• Responsible for monthly surveillance reports tracking deals for Profit and Loss analysis usingSAS and Excel
• DevelopedSASstored procedures and views to provide BI analysis and insights
• Involved in developing and maintaining documentation of operational processes and data mappings
• Used Proc Metalib as well asSASSMC to configure/alter information of datasets/views/Tables.
• Developed several reports usingSASInformation Map studio to be presented in Excel as well as Web reports
• Extensively used Proc SQL andSASMacros for application automation
• Extensively usedSASDictionary tables and Proc Metadata to get real time information forSAS datasets
• Used Excel templates and VBA to generate custom reports from data inSAStables
• Extensively involved in mainframeSASfor analyzing very large datasets
• Involved in fine tuning the code to reduce the churn time and improve the efficiency
• Coded extremely complexSASData step and procs including the advanced techniques and the use of the available options to serve the ever evolving and dynamic business reporting needs
• Extensively used proc tabulate, proc rank, proc transpose in developing custom reports
• Involved in aggregating data residing on the vast network of distributed servers with all forms of data storage
• Exported largeSASdata sets (more than 300 variables) to MVS external files to be sent to external vendors usingSASandSAS/Macro
• Hands on experience in movingSASdata sets from Unix to PC environments using FTP
• Used Meta Engine as well as SQL Pass thru method to load the manipulated data from external tables intoSASdata sets

Environment: SASENTERPRISE GUIDE,SASOLAP Cube Studio,SASInformation Map Studio,SASWeb Reports Studio,SASAdd In,SAS/SQL,SAS/MACROS,SAS/BASE, SybaseIQ, VBA

Confidential

SASProgrammer

Roles & Responsibilities:

• Interacted with business users and business analysts and prepared technical specs.
• Extracted data from Oracle tables in UNIX. Extract huge volumes of data and uploaded into Oracle using SQL Loader
• CreatedSASdatasets using Import Wizard and Proc SQL. Created user defined formats using Proc Format and In formats and data set was sorted using Proc Sort.
• Extensively usedSASMacros, Proc Univariate, Proc Summary, Proc means, Automatic Variables and Proc options with LIST, OUT, MISSING options to perform various analysis.
• Interfaced withSAS/ACCESS to access, join, update, insert, and delete data from various tables.
• Statistical analysis includes calculation of one-way and multi-way frequencies and table analysis using Proc Freq.
• Perform queries and usedSAS/ODS to prepare reports using preexisting templates directingSAS output to RTF, PDF and HTML to publish reports for business users group and load them in UNIX server.
• Reports were created using Proc Tabulate, Proc Print, Proc Report and output the reports via ODS HTML to website and Proc Tabulate to create analysis tables.
• Performed documentation of theSASCode for the better understanding of the program.

Environment: SAS8.x, (BASE, MACROS, CONNECT, SQL, GRAPH, ACCESS),SAS/ODS, Oracle, MS Excel, UNIX and Windows NT