SUMMARY

• Extensive Experience as SAS Programmer/Analyst in development, implementation and testing of applications in financial sector.
• Strong skills in SQL, Data Warehouse, Data Exploration/Extraction, Data Validation, Reporting and Excel.
• Expertise in SQL Procedures, Functions, Database Packages, Views and Triggers.
• Experience in trouble shooting techniques, tuning the SQL statements, Query Optimization and Dynamic SQL.
• Experience developing SAS procedures, macros, merges, data steps for data cleaning, Data Acquisition to Data Modification and reporting.
• Extensive Experience in creating/maintaining SAS, consulting and Analytical skills.
• Strong experience in Macro programming with DB2, SAS/BASE, SAS/MACRO, SAS/CONNECT, SAS/ODS, SAS/GRAPH, SAS/SQL, SAS/STAT, SAS/ACCESS in WINDOWS, ORACLE and Teradata databases and UNIX environments.
• Experienced in Base and Advanced SAS programming procedures like PROC SQL, PROC REPORT, PROC ACCESS, PROC GPLOT, PROC GCHART, PROC FORMAT, PROC TABULATE, PROC APPEND, PROC TRANSPOSE.
• Hands on experience in SAS programming for extracting data from flat files, Excel spreadsheets and external RDBMS tables using LIBNAME and SQL PASSTHRU facility.
• Extensive experience in preparation of reports, tables, listings and graphs in HTML, PDF and RTF formats using Output Delivery System.
• Solid Experience in generating reports with browser interfaces like SAS WebReport Studio, windows client SAS Enterprise Guide and built reports using SAS Add - In for Microsoft Office.
• Extensive Experience with the Software Development Life-Cycle, requirements, design and implementation.
• Experience in MS Excel, PowerPoint and Other MS Office Suite.
• Expert Level on Access, Excel, VBA and SQL, SAS with regards to Data Management and processes automation/standardization.
• Good experience in using Teradata Sql Assistant, Sql Developer.
• Experience in loading flat files to Teradata by writing fast load scripts.
• Banking,AML/Regulatory Compliance, Performance Analytics, Reporting, Capital Markets, Debit Card,Credit Card, Deposits, Funds Transfer, Client Information Systems, General Ledger, Fixed Assets, Bank Mergers and Conversions, Consumer Lending, Mortgage, Default, Risk Analytics.
• Good statistical noledge of descriptive models including various sorts of mixed models and predictive solution models including linear, multiple regression models.
• Highly motivated individual with excellent organizational and interpersonal skills.
• Can quickly adapt to new applications and platforms.

TECHNICAL SKILLS

Databases: SQL server, Teradata, Oracle, MS Access

Programming Languages: SQL, PL/SQL, T-SQL, SAS 9.1/9.2/9.3/9.4, SAS Macro

SAS BI Tools: SAS Enterprise Guide, SAS Data Integration Studio, SAS Management Console, SAS Information Map Studio, SAS Customer Intelligence Studio

SAS Procedures: Print, Means, Univariate, Correlation, Regression, SQL, Report, Freq, Sort, Tabulate, Format, Import, Export, Transpose, Compare, Gplot and Gchart

Advanced SAS: Macros, Reports, Array Processing, Hash Objects, Pointers, Display Manager

Operating Systems: MS Windows, Unix,DOS

Desktop: Excel, Word, Visio, Publisher, Outlook, SharePoint, Info path

PROFESSIONAL EXPERIENCE

Confidential, VA

SAS Developer/Data Analyst

Responsibilities:

• Generated high quality reports in the form of listing, HTML, RTF and PDF formats using SAS ODS.
• Developed customized add in programs using capabilities of SAS Enterprise Guide.
• Creating & analyzing Business Requirements Documents (BRD) and preparing Functional Requirement Documents (FRD) and Technical Documents.
• Performed statistical analysis and data management on study data by utilizing appropriate statistical methods using SAS and SAS tools.
• Create Data Dictionary and migrate the data when shifting to new version of SAS.
• Results are performed using SAS programming and using techniques such as SAS Macro language, advanced data manipulation, and statistical procedures (e.g., PROC FREQ, PROC REPORT).
• Used various procedures such as Proc Tabulate, Proc Means and Proc Report to generate tables, listings, graphs and reports.
• Provide SAS Programming support and technical assistance in the accurate development and intermediate steps required.
• Present statistical results using the appropriate graphs, charts, tables and written reports.
• Extracted, performed validation and generated SAS data sets from Teradata; applied SQL Pass through Facility.
• Tested and debugged existing MACROS.
• Develop new macros for report generation using SAS/Macros as per the customer’s requirements.
• Used FTP to download SAS Formatted Data into EXCEL AND CSV format.
• Retrieving Millions of Records Using different Procedures.
• Used PROC compare to compare the data before and after editing
• Developed various SAS reports for Survey project and involved in code reviews for all the developed reports.
• Performing Unit and Integration testing, validation and sanity checks on the deliverables.
• Make the results actionable for Marketing, Campaign Planning, Strategic Planning, Finance and Sales organizations.
• Integrate results of the Marketing Mix Analysis, Price Elasticity and other advanced analyses into business planning process.
• Assist in the creation of quantitative and qualitative primary research and present the findings.
• Ability to dig into raw data to find and evaluate actionable insights that will halp the organization.

Environment: SAS 9.1.3/9.2, BASE/SAS,SAS Enterprise Guide, SAS/MACRO, SAS BI, SAS/SQL, SAS/CONNECT, SAS/ACCESS, SAS/ODS, Oracle 11g, Teradata, UNIX and Windows XP.

Confidential

Data Analyst

Responsibilities:

• Developed SAS programs using Proc Tabulate, SAS Base and SAS/Stat that enabled users to generate reports on Daily/Weekly/Monthly/Quarterly/Annual reports.
• Worked alot on data pulling from various files.
• Generated ad-hoc reports for company’s audit and inspection requirements.
• Data was extracted from databases and also flat files.
• Preprocessed training data and performed advanced modeling on testing dataset.
• Evaluated the model performance using decision trees and confusion matrices.
• Created SAS data mining and scoring data sets form source tables by programming in BASE SAS.
• Report Generation and Documentation with respect to evaluation of model performance and TEMPeffectively communicating the results to higher management
• Developed and maintained multivariate statistical models used to predict customer behavior and to profile customer potential.
• Calculated possible risk and premiums for individual organizations.
• Customized existing SAS programs and created new programs using SAS/Macros to improve the consistency of the results.
• Compiled statistics and created detailed reports and graphs for management and customer review using SAS/Graph, SAS/Macro and SAS/Report.
• Correlating and presenting weekly or monthly data to senior management.

Environment: SAS/Base, SAS/Macro,Teradata,SAS/Graph, SAS/SQL, Oracle, PL/SQL, UNIX, MS-Excel and HTML.