SUMMARY:

• Senior Data Analyst and Statistical Analyst with 6+ years of experience in SAS development and testing in financial, Banking, Insurance & mortgage industries.
• Statistical Business Analyst using SAS 9.
• Knowledge on Data analysis, Data validation, and Data quality checks.
• Certified Base Programmer for SAS9.
• Experience in developing SAS Macros from scratch and developed application for automation, data updates and reporting.
• Expert hands - on knowledge of SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/SQL and SAS/OR.
• Successfully increased portability of existing SAS programs and created new programs using SASmacro variables to improve efficiency and consistency of result.
• Particularly adept in identifying in extracting data from Teradata, Hadoop and oracle using SAS.
• Result oriented, committed and hard working with a quest to learn new technologies and undertake challenging tasks.
• Enthusiastic to develop new skills in a dynamic environment.
• Capable of utilizing data management techniques like Merging, concatenating, interleaving of SASdatasets using MERGE and SET statements in DATA step.
• Extensive programming experience with SAS datasets and procedures such as PROC FORMAT, PROC TABULATE, PROC REPORT, PROC TRANSPOSE, PROC PRINT, and SAS/STAT procedures such as PROC CORR, PROC REG, PROC GLM, PROC ANOVA, PROC FREQ, PROC MEANS, and PROC UNIVARIATE.
• Working knowledge of Tableau, SQL and Python.
• Expertise in designing and creating various analytical reports and Dashboards.
• Extensive knowledge in creating solution driven Reports and Dashboards in Tableau Desktop using different Chart types like Line Charts, Area Charts, Bar Charts, Crosstab, Scatter Plots, Geographic Map, Pie Charts and Slope Charts, Donut Charts, Tree Maps and Heat Maps.
• Expertise in creating Table Calculations, Aggregates, Hierarchies, Filters, Quick filters, Parameters, Trend lines, Calculated measures, Sets, Groups, Formatting, Actions, LODs.
• Performed PROC SQL joins and worked with PROC SQL set operators to combine tables.
• Experience in using various MS office tools for analyzing, arranging and presenting data.
• Responsible for accessing and managing data and for performing complex queries and analysis.
• Producing data in various output formats including HTML, RTF, PDF, MS-EXCEL using ODS (output Delivery System).
• Working experience in coding using SQL Procedures/Functions.
• Rewrite SAS codes to fine-tune and automate various SAS processes.
• Good analytic skills pertaining understanding a business domain coupled with excellent teamwork and strong communication skills.
• Worked on data quality rules and ensured the proper implementation of data quality during the creation and modification of data, according to Enterprise Data and Analytics data quality standards, guidelines, metrics and quality-expectations.
• Ensured accuracy, completeness, integrity, consistency, uniqueness, and timeliness of data.
• Executed Enterprise Data and Analytics data quality tests/assessments and data cleansing activities.
• Knowledge of frequency and duplicate analysis, cross dataset dependencies, redundancy analysis, data extraction techniques and applications.

TECHNICAL SKILLS:

ETL tool: SAS, Matlab

Database: Hadoop, Teradata

Reporting/Analysis: SAS/BASE, SAS/ENTERPRISE GUIDE, SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/CONNECT and SAS/ODS

Languages: SAS, SQL, C++, Perl, unix Shell scripting

Other Tools: Jira, tableau, PUTTY, XMING, Microsoft Office Suite (Advance Excel, Word, PowerPoint, Access and Outlook)

PROFESSIONAL EXPERIENCE:

SAS Programmer

Confidential, Virginia Beach, VA

Responsibilities:

• Ensured that I/O capabilities with the principal Oracle database function properly; and Interacting with the Mainframe
• Wrote SAS Code
• Wrote SQL Code
• Used Unix and shell scripting.
• Worked with SQL Developer and the Oracle(11g) Database
• Formulated a system for seamlessly integrating all of the components together
• Assisted with development and implementation of a test plan for the migrated system; and provided additional technical maintenance and ad hoc support as needed.
• Assisted in SAS Systems Upgrade to Eguide Enterprise Configuration.
• Developed requirements and enterprise architecture for EIA metadata, Eguide and EBI under SASversion 9.1/9.2.
• Assisted staff in converting legacy SAS mainframe code to SAS Eguide.
• Trained staff in EBI analytical techniques and information delivery approaches and methodologies.
• Designed and deployed software engineering practices, as requested, to maintain SAS code configuration and data quality.
• Created Enterprise Guide projects and stored procedures in SAS, seamlessly integrating the operations of the different modules.
• Used SAS Web Report Studio, Information map Studio, SAS Intranet and other SAS BI (Business Intelligence) objects.
• Extensive use of the metadata repository, SAS macros, and Enterprise Guide.
• Completed Courses at the SAS institute, Rockville MD, on SAS EG and other BI modules.

SAS Programmer

Confidential, Allentown, PA

Responsibilities:

• Extracted data from Oracle databases using SAS/ACCESS and LIBNAME
• Gathered program requirements and translated those business needs into technical requirements
• Created new datasets to the requirement using various SAS procedures like set, merge, sort and various other SAS functions
• Used SAS/Macros to generate daily reports
• Generated customized reports using REPORT, TABULATE, SUMMARY and SQL procedures
• Formatted HTML, PDF, CSV and RTF reports using SAS ODS
• Used SAS/Macros to develop reusable programs that are conveniently used to create tables and reports
• Extensively used SAS functions like SCAN, TRIM, SUBSTR, CATX, COMPARE to manipulate the values and functions like call symput, call execute, %include, %let, to create macro variables to support various analysis efforts
• Extensively worked on data extraction, data cleansing and data validation techniques.
• Used statistical procedures like PROC MEAN, FREQ and UNIVARIATE to better understand the data, and figure out the outliers
• Imported/converted various formats like Excel and CSV files into SAS data sets for data analysis.

Environment: SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/CONNECT, SAS/GRAPH, SAS/SQL, SAS/ODS, Oracle 9i, PL/SQL, MS Excel, UNIX Shell Scripting dispatch new data to respective directories.

SAS Programmer

Confidential, Baltimore, MD

Responsibilities:

• Worked with the business team and analysis teams to understand the criteria for Business Marketing campaigns
• Applied Machine Learning techniques for customer insight, target marketing, channel execution, and risk management using SAS and python
• Used SAS Customer Intelligence Studio to design and execute target marketing and customer retention campaigns
• Work with the analysis team to build regression models, for correlation analysis and predicting the target variables.
• Write complex SQL and SAS Macros scripts to automate the process to read data from huge excel files, database and generate reports
• Scheduled and automated jobs on LINUX environment
• Customize the existing Macros to maintain the program efficiency and automate the SAS programs.
• Extensively worked on data extraction, validation, cleansing and integration techniques (ETL)

Environment: SAS/BASE, SAS EG, SAS/MACROS, SAS/ACCESS, SAS/STAT, SAS/SQL, SAS/ODS, Oracle, LINUX, SAS Customer Intelligence Studio, SAS Information Map Studio, Python