SUMMARY

• 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.

TECHNICAL 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.

PROFESSIONAL EXPERIENCE

Confidential, Tennessee

Programmer Analyst

Responsibilities:

• 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.

Confidential

SAS Programmer

Responsibilities:

• 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.

Confidential

SAS Programmer

Responsibilities:

• 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.

Confidential

SQL Developer

Responsibilities:

• 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.