We provide IT Staff Augmentation Services!

Programmer Analyst Resume

4.00/5 (Submit Your Rating)



  • Over 7 years of Professional experience in IT industry in various technical fields like SAS Programming, PL/SQL, SQL, UNIX, Shell scripting technologies.
  • Expert hand on noledge of SAS/BASE, SAS/SQL, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/ETS and SAS/ODS, SAS Enterprise Miner, SAS Enterprise Guide.
  • Exceptional ability in problem solving, data analysis, complex reports generation with macro and data transfer between different environments.
  • Expert in concatenating, interleaving, merging and appending SAS datasets.
  • Extensive programming experience with SAS datasets and procedures such as proc format, proc tabulate, proc report, proc transpose, proc print, proc SQL and SAS/STAT procedures such as proc Corr, Proc Reg, Proc Glm, Proc Anova, proc freq, proc Means, proc univariate etc.
  • Experienced in producing RTF, PDF, HTML and MS Excel formatted files using SAS ODS facility
  • Experienced in writing UNIX shell scripting and hands on experience with scheduling of shell scripts using Control - M.
  • Experience in developing SAS Macros and application for data updates, data cleansing and reporting.
  • Successfully increased portability of existing SAS programs and created new programs using SAS macro variables to improve efficiency and consistency of result.
  • Through experience in data extraction and sorting from various databases like Oracle, DB2 and MS Access using PL/SQL and SQL.
  • Familiar with designing and coding Stored Procedures, Triggers, Cursors and Functions using PL/SQL.
  • Extracted data from Heterogeneous source systems like Oracle, Teradata, SQL Server and flat files.
  • Developed PL/SQL Procedures, Functions and Packages and used SQL Loader and PL/SQL ETL Table functions to load data into the database.
  • Tuned Report performance by exploiting the Oracle’s new built-in functions and rewriting SQL statements.
  • Strong command over Structured Query Language (SQL). Expertise in Windows operating Result oriented, committed and hard working with a quest to learn new technologies and undertake challenging tasks.
  • Proven ability to implement technology based solutions for business problems.
  • TEMPEffective in cross-functional and global environments to manage multiple tasks and assignments concurrently with TEMPeffective communication skills.


SAS Tools: SAS 9.2/9.3/9.4, Base SAS, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ACCESS, SAS/ETS, SAS/ODS, SAS Enterprise Guide, SAS Enterprise Miner.

SAS Procedures: Print, Transpose, Contents, Means, Chart, Plot, Tabulate, Univariate, Summary, Sort, SQL, Copy, Reg, Freq, Forms, Upload, Download, Formats.

Operating System: Windows, MS - DOS, UNIX, LINUX.

Language: Java, SQL, XML, HTML, Java Script, Shell Scripting.

Database: MS SQL Server, MySQL, PL/SQL, Teradata, Oracle 12c/11g.

Software Package: MS (Excel, Word, PowerPoint, Access), Developer 2000.


Confidential, Tennessee

Programmer Analyst


  • Gathering project requirements and specifications from the business.
  • Worked closely with Business Users and Analysts while converting functional requirements into Technical Specifications.
  • Developed Teradata queries to retrieve customer information and to check the Eligibility status of the Confidential accounts retrieved from the ODM tool.
  • Develops and maintains applications and databases required for the Integration process.
  • Request the Extraction file (TNT extract) from business and clean the data. If any required fields are missing from the extraction file, inform to the business.
  • Use the existing excel macro to review the eligible accounts to check if they are still matching with respect to their customer at location and other attributes.
  • Performed Data analysis usingSASTools -SAS/Base,SAS/Macros andSAS/SQL.
  • Developed and executed SAS SQL queries for merging, concatenating and updating large volumes of data.
  • Retrieved the customer data from the Teradata database into SAS environment using SAS/Access, SQL Pass- through facility.
  • Develop programs for extensive statistical analysis of data using SAS procedures.
  • Actively involved in creating Test Plans based on the requirements submitted by the Business analysts.
  • Used SAS Macros and SAS SQL to query data and to obtain results which were generally stored as delimited text.
  • Review the final Link vs New Accounts by conducting the 5-point check.
  • Send the final list file (Link vs New Accounts) to the account manager along with the test case details.

Environment: SAS 9.4, SAS/BASE, SAS/MACROS, SAS/SQL, PL/SQL, SQL, Teradata, MS Excel, Shell Scripting, UNIX, Windows.


SAS Programmer


  • Actively involved in design and implementation of application software using primarily SAS system and analyzed existing application software and recommended improvements.
  • Created macro program to create Macro variables to pull data from oracle and SQL server for monthly daily data extracting.
  • Designed flowcharts indicating the input data sets and the techniques that would be used (sorting, merging, etc.) to get the desired output.
  • Develop programs for extensive statistical analysis of data using SAS procedures.
  • Creating HTML, PDF & RTF reports using SAS ODS.
  • Cleaning of data using SAS Procedures like PROC FREQ for Categorical Variables and PROC UNIVARIATE for Continuous Variables.
  • Processed data collection to ensure proper quality of data
  • Maintained data collection to ensure proper quality of data.
  • Developed stored procedures, triggers and functions with PL/SQL forOracledatabase
  • Extensively involved in the development of backend Logics or data access logic usingOracleDB.
  • Developed SAS macros for data cleaning, reporting and to support routing processing.
  • Present numerical information in various formats. Created SAS Customized report using the Data null technique.
  • Merging, Indexing, appending and sorting the data sets using various SAS procedures and other SAS tools.
  • Developed and executed SAS SQL queries for merging, concatenating and updating large volumes of data.
  • Worked with the specified marketing teams to clearly identify the selection criteria needed for each list.
  • Involved in validation of analysis datasets, tables and listings using Proc compare and code walk-through.
  • Generated graphs using SAS/GRAPH and the SAS Graphics Editor. Used Proc Report to generate reports.
  • Developed macros to generate customized report using DATA NULL and PROC REPORT, TABULATE AND SUMMARY.
  • Created SAS/Views from Oracle database tables.
  • Created tables, triggers, stored procedures, SQL queries, joins, integrity, constraints and views for multiple databases,Oracle.
  • Analyzed and interpreted numerical data from various sources organized and summarized data for analysis.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/Graph, Oracle, PL/SQL, SQL, UNIX, Shell Scripting and Windows.


SAS Programmer


  • Created analysis datasets, assesses quality of data analysis programs, and develops automated analysis tools where appropriate.
  • Assessed the quality of analysis data and performs cross-study analyses.
  • Used internal macros to automate statistical table, figure, and listing production.
  • Worked on multiple studies at the same time.
  • Reviewed draft and final production runs for project to ensure quality and consistency
  • Maintained complete and auditable documentation of all programming activities.
  • Oracleis used as the persistence layer, configured and optimally indexed for searches.
  • Developed stored procedures, triggers and functions with PL/SQL forOracledatabase
  • Extensively involved in the development of backend Logics or data access logic usingOracleDB.
  • Followed good programming practices.
  • Participated with and in cases leading process and technical improvement initiatives.
  • Performed general duties as required to support company objectives.
  • Created SAS/Views from Oracle database tables.
  • Created dynamic Macro arrays by SQL and with data step programs.

Environment: SAS/Base, SAS/Macro, SAS/SQL, SAS/Stat, SAS/Graph, SAS/Access, SAS/ODS, MS Office, MS Access, MS-Excel, Oracle.


SQL Developer


  • Analyzing the Business and System requirements.
  • Understanding the application and Identification of Functionalities.
  • Installed and configured SQL Server.
  • Designed and developed the databases.
  • Created a logical design of the central relational database using Erwin.
  • Expertise in the forward engineering of the logical models to generate the physical tables using Erwin.
  • Configured the DTS packages to run in periodic intervals.
  • Developing and maintaining the application and data.
  • Extensively worked with DTS for Data Migration from source systems.
  • Wrote stored procedures and triggers extensively and working very closely with developers, business analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems.
  • Created and maintained the data dictionaries, maintained some parameters to provide faster query performance using SQL.
  • Created tables, views, triggers, stored procedures and indexes.
  • Created integrity rules and defaults.
  • Created ftp connections, database connections for the sources and targets.
  • Maintained security and data integrity of the database.
  • Creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.

Environment: Windows, UNIX, SQL Loader, SQL, PL/SQL, Unix Shell scripting.

We'd love your feedback!