SUMMARY:

• Senior Data Analyst and Statistical Analyst with 6+ years of experience inSASdevelopment and testing in financial, Banking, Insurance & mortgage industries.
• Statistical Business Analyst usingSAS9.
• Knowledge on Data analysis, Data validation, and Data quality checks.
• Certified BaseProgrammerfor SAS9.
• Experience in developingSASMacros from scratch and developed application for automation, data updates and reporting.
• Expert hands - on knowledge ofSAS/BASE,SAS/MACRO,SAS/STAT,SAS/GRAPH,SAS/ACCESS,SAS/ODS,SAS/SQL andSAS/OR.
• Successfully increased portability of existingSASprograms and created new programs usingSASmacro 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 ofSASdatasets using MERGE and SET statements in DATA step.
• Extensive programming experience withSASdatasets and procedures such as PROC FORMAT, PROC TABULATE, PROC REPORT, PROC TRANSPOSE, PROC PRINT, andSAS/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.
• RewriteSAScodes to fine-tune and automate variousSASprocesses.
• 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.

EXPERIENCED SKILLS:

ETL tool: SAS, Matlab

Database: Hadoop, Teradata

Reporting/Analysis: SAS/BASE, SAS/ENTERPRISE GUIDE, SAS/MACROS, SAS/SQLSAS/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)

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
• WroteSASCode
• 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 inSASSystems Upgrade to Eguide Enterprise Configuration.
• Developed requirements and enterprise architecture for EIA metadata, Eguide and EBI underSASversion 9.1/9.2.
• Assisted staff in converting legacySASmainframe code toSASEguide.
• Trained staff in EBI analytical techniques and information delivery approaches and methodologies.
• Designed and deployed software engineering practices, as requested, to maintainSAScode configuration and data quality.
• Created Enterprise Guide projects and stored procedures inSAS, seamlessly integrating the operations of the different modules.
• UsedSASWeb Report Studio, Information map Studio,SASIntranet and otherSASBI (Business Intelligence) objects.
• Extensive use of the metadata repository,SASmacros, and Enterprise Guide.
• Completed Courses at theSASinstitute, Rockville MD, onSASEG and other BI modules.

SAS Programmer

Confidential, Allentown, PA

Responsibilities:

• Extracted data from Oracle databases usingSAS/ACCESS and LIBNAME
• Gathered program requirements and translated those business needs into technical requirements
• Created new datasets to the requirement using variousSASprocedures like set, merge, sort and various otherSASfunctions
• UsedSAS/Macros to generate daily reports
• Generated customized reports using REPORT, TABULATE, SUMMARY and SQL procedures
• Formatted HTML, PDF, CSV and RTF reports usingSASODS
• UsedSAS/Macros to develop reusable programs that are conveniently used to create tables and reports
• Extensively usedSASfunctions 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 intoSASdata 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 usingSASand python
• UsedSASCustomer 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 andSASMacros 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 theSASprograms.
• Extensively worked on data extraction, validation, cleansing and integration techniques (ETL)

Environment: SAS/BASE,SASEG,SAS/MACROS,SAS/ACCESS,SAS/STAT,SAS/SQL,SAS/ODS, Oracle, LINUX,SASCustomer Intelligence Studio,SASInformation Map Studio, Python