PROFESSIONAL SUMMARY:

• SAS Institute certified programmer with 10+ years of experience working in SAS Developer, SAS, Business Intelligence & Data Warehousing (BIDW) and related suite of tools.
• Experience includes BI applications, Data quality management, Data extraction, Data manipulation, Data validation and Data & Visual analytics.
• Has worked on stored processes, SAS Data Integration Studio to build the Warehouse, SAS Web Report Studio, SAS Enterprise Guide, SAS OLAP Cube Studio, SAS Information Map Studio, SAS Information Delivery Portal and SAS Add - In for Microsoft Office with back-end database such as Oracle, MS-Access, SQL Server, and DB2.
• Comprehensive skills in working with Base SAS, SAS/Macro in UNIX and Windows environments. Proficient in creating SAS reports using Tableau.
• Proficient in writing queries and stored procedures in SQL
• Extensive knowledge in data management like Merging, concatenating, interleaving of SAS datasets.
• Proficient in producing reports employing various SAS procedures, like Proc Print, Proc Report, Proc Summary, Proc Freq, Proc Tabulate, Proc Means, Proc Univariate, Proc Transpose, Proc SQL, etc.
• Generated output files in RTF, HTML, and PDF format using SAS ODS.
• Experience in performing data mining and statistical analysis using T-test, ANOVA, and Logistic regression in SAS.
• Experience with statistical modeling, multi-variate statistics and logistic regression. Experience using SAS VA for generating dashboards/ reports for state and federal reporting
• Experience using SAS Financial Management to create reports. Experience generating reports for state and federal reporting. Proficient in creating reports using Business objects, Crystal reports and SAS.
• Excellent skills in diagnosing and avoiding errors, understanding and enhancing output to furnish reports.
• Exceptional problem-solving skills with excellent communication skills, detail oriented, organized, enthusiastic to work in a fast paced and team-oriented environment.

TECHNICAL SKILLS:

SAS Tools: SAS 8/9/9.2/9.3, SAS/BASE, SAS/MACRO, SAS/SQL, ODS, SAS/GRAPH, SAS/STAT, SAS/ACCESS, SAS/Connect, SAS Enterprise Guide, SAS Data Integration Studio, SAS OLAP Cube Studio, SAS Web Report Studio, SAS Information Map Studio, and SAS Information Delivery Portal, SAS Financial Management, SAS Add-In for Microsoft Office.

Data base: MS SQL Server, DB2, MS ACESS 2007/2010, Oracle 9i/10g/11g, Teradata (BTEQ, FASTLOAD, TPT etc.)

Office Tools: MS Excel, MS Word, MS PowerPoint, MS Access

Programming: Pure SQL, PL/SQL, T SQL, UNIX Shell Scripting for Automation

Scripting: Korn, Bourne, and PERL scripting

Operating System: Windows 98, 2000, NT, XP, UNIX.

Object Oriented Programming: Python

Reporting: Excel, Minitab, Sigma plot, SAS Visual Analytics, Tableau, Power BI

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, DE

Sr. SAS Programmer

Responsibilities:

• Designing, developing, deploying, and maintaining analytic applications and data structures needed for modelling and forecasting
• Automating model execution, standardizing inputs and outputs to improve process
• Creating technical and user documentation
• Develop and maintain comprehensive controls to ensure processes are executing as designed
• Utilize SAS, SQL, UNIX, Oracle and MS Office analysis tools to complete analysis requirements
• Ad-Hoc Reporting
• Interact with technology to support deployment consistent with control requirements
• Develop SAS programs and shell scripts to generate reports on ad-hoc basis
• Document the application details for risk governance and regulatory purpose. Work on testing the scripts for database migration
• Work with the business team to gather the requirements
• Work on resolving the production issues for various applications. Work on testing the scripts for server migration

Environment: SAS Base 9.1, 9.2, 9.3, SAS/Macro, SAS/STAT, SAS/Connect, SAS/Access, SAS/EG, MS-Excel, Oracle 10g/11g, IBM AIX, Web Application, SAS/Perl Scripting, SAS Web Report Studio, SAS Information Map Studio, SAS Information Delivery Portal, SAS Enterprise BI Server, SAS Data Integration Studio

Confidential

Sr. SAS Programmer

Responsibilities:

• Conduct queries/analysis for state and federal reporting. Develop and maintain a dashboard utilizing Visual Analytics
• Utilize SAS Financial Management software to create reports that will be used for daily bank reconciliation.
• Function as a niche technical SME
• Interact with executive level business users or technical experts. Convey technical and functional concepts for SAS
• Provides guidance to state staff on the use of SAS
• Identifies improvements to project standards to achieve high quality services/ products. Identify best practices and standards for the use of the product
• Use SAS Data Miner, SAS Enterprise Miner, and SAS Bridge for ESRI software. Generate reports for state and federal reporting

Environment: SAS Base 9.0, 9.1, 9.2, 9.3, 9.4, SAS/Macro, SAS/STAT, SAS/Connect, SAS/Access, SAS/EG, MS-Excel, Oracle 10g/11g, Web Application, SAS/Perl Scripting, SAS Data Integration Studio, SAS Information Delivery portalSAS Information Map Studio, SAS Enterprise BI Server, SAS Web Report Studio, SAS Visual Analytics, SAS Financial Management.

Confidential, Jersey City, NJ

Sr. SAS Programmer

Responsibilities:

• Develop, implement and support code in a SAS, Oracle, UNIX environment .
• Work on developing SAS procedures to fully automate the execution, monitoring and issue reporting for all production processes
• Develop / modify the SAS code based on the requirement from the modeling team. Address the identified issues in application security and fix them using SAS/SQL/UNIX as required
• Participate in design reviews and provide input to design recommendations. In corporate security requirements into design
• Analyze business requirements with business analysts and outline proposed system solutions
• Provide input to information/data flow, and understand and comply with Project Life Cycle Methodology in all planning steps
• Translate technical requirements into programmed application modules, document the detailed application specifications, and develop/enhance software application modules.
• Work on implementing procedures to ensure that all UAT and production code migration comply with established procedures
• Promote adherence to and follow the organization's standard project life cycle to ensure delivery of high-quality software solutions
• Adhere to IT Control Policies throughout design, development and testing and in corporate Corporate Architectural standards into application design specifications.

Environment: SAS Base 9.2, 9.3, 9.4, SAS/Macro, SAS/STAT, SAS/Connect, SAS/Access, SAS/EG, MS-Excel, Oracle 10g/11g, Web Application, SAS/Perl Scripting, SAS Data Integration Studio, SAS Information Delivery Portal, SAS Information Map Studio, SAS Enterprise BI Server, SAS Web Report Studio.

Confidential, Cleveland, OH

Sr. SAS Developer

Responsibilities:

• Extracted and analyzed data from the database using SAS/Access, SAS/SQL Procedures and created SAS datasets.
• Extensively created stored processes using SAS Enterprise Guide.
• Performed coding, testing, debugging, documentation, and installation tasks for on-line and batch processes reports in accordance with client specific internal procedures and standards. Wrote and modified SAS code in windows environment
• Created and delivered reports via SAS Web Report Studio, Stored process Web Applications and Information Delivery Portal.
• Developed, tested, debugged stored processes using SAS/EG
• Used data cleaning techniques such as Proc Freq, Proc Print, null, Proc Means, Proc Tabulate, Proc Univariate, Proc SQL, Proc Sort Nodupkey, Proc Character, invalid, and discrete data character values.
• Used Microsoft Add-In for delivering reports in word and excel
• Conducted Ad Hoc analysis to support business strategy. Developed SAS programs based on the draft spec document
• Modified existing SAS programs and created new programs using SAS macro variables to improve ease and speed of modification as well as consistency of results.
• Extracted data from warehouse using SQL procedure and created SAS data sets. Used SAS Data Integration Studio to perform several extractions and transformation SAS datasets.

Environment: SAS Base 9.1, 9.2, 9.3, SAS/Macro, SAS/STAT, SAS/Connect, SAS/Access, SAS/EG, MS-Excel, Oracle 10g/11g, IBM AIX, Web Application, SAS/Perl Scripting, SAS Web Report Studio, SAS Information Map Studio, SAS Information Delivery Portal, SAS Enterprise BI Server, SAS Data Integration Studio

Confidential, Charlotte, NC

Sr. SAS programmer / Analyst

Responsibilities:

• Extracting financial data from the database using SAS/Access, SAS SQL, SAS/Connect, Procedure and create SAS permanent data sets in SAS library.
• Creating SAS Views from tables in Database using SAS/Access and analyze data.
• Retrieved the financial data from flat files received from the vendors, convert them into SAS readable format. Make the SAS data sets, analyze data as per given requirement.
• Benchmarked the effectiveness of AML data. Identified the potentials for performance improvement.
• Write the SAS code and run those data sets to produce necessary financial reports by using SAS/STAT Procedures such as PROC Freq, PROC Tabulate, Proc Univariate, and PROC ANOVA.
• Writing Meta data for important data set before archive into SAS metadata server
• Created required financial reports using analysis output and export them to other environments or the web using various SAS method like create delimited, text files, ODBC, CEDA, CPORT, ODS having formats such as HTML, RTF, or XML.
• Regular interaction with the financial analysts for the presentation. Performed in-depth quantitative data analysis. Extensively used procedures like PROC SQL, PROC PRINT, and PROC SORT etc.
• Coded SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs. Experience in Advanced SQL to extract data from various databases like Oracle.
• Involved in developing UNIX Korn Shell wrappers to run various dependency graphs.
• Documented business requirements for necessary customizations to the new application and reviewed the customized components with the business and developer team.
• Created and delivered reports and presentations with key findings and recommendations.
• Experience in Transferring and converting data from one platform to another to be used for further analysis. (From Oracle and Excel to SAS both export and import of data)

Environment: Base SAS 9.1,9.2, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, PC SAS, SAS/Perl Scripting, Oracle 9i, MS Excel, MS Access

Confidential, NYC, NY

SAS Programmer/ Analyst

Responsibilities:

• Responsible for Business analysis and requirements gathering. Attending Client calls for Business understanding and Clarifications.
• Gathered valuable knowledge about the working of stock market, index concepts.
• Extracted raw data from an Oracle database and used SAS/Access to read it and run statistical analysis using SAS/STAT.
• Developed SAS programs to extract, validate and transform data from different data sources using SAS procedures PROC Format, Proc Means, Proc Freq and Proc Univariate
• Design of ETL process to meet the requirement of data demand. Writing Meta data for important data set before archive into SAS metadata server.
• Used data cleaning techniques such as Proc freq, Proc Print, null, proc means, proc tabulate, Proc Univariate, Proc SQL, nodupkey, invalid, and discrete data character values.
• Review and modify SAS Programs, created customized ad-hoc reports, process data for publishing business reports; automate and distribute designed business reports on schedule in various format.
• Extensively used PROC SQL for highly advanced matching and merging between large datasets.
• Worked with SQLPLUS, and PL/SQL extensively to solve database problems to make database effective and efficient tuning purpose. In PL/SQL Implement of DML, Implicit and Explicit Cursors, function, conditional logic, creating and ODBC connection.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Creation of reports like Residential and Business Customers reports, Service charge validation Reports, Monthly paper bill Reports.
• Creation of reports like Reports by Period, Demographic reports and Comparative Reports.
• Created and modified the Crystal Reports for various financial groups using the Universe as a main data provider.
• Created custom reports like Gross Margin, Account Query, Aging, Balance Sheet, Income Statement, Bad Debt and Payment Reports in response to user needs. Some of these reports are extremely complicated and retrieve data from multiple data sources
• Interfaced programs with Oracle databases to provide accurate reporting, archiving, and error handling.
• Scheduled and managed jobs with AutoSys job management system to ensure job streams flowed smoothly.

Environment: Base SAS 9, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, SAS/ETL, UNIX SAS, PC SAS, Business objects 6.5.1, Oracle 9i, DB2, PL/SQL, MS Excel, MS Access.

Confidential

SAS Programmer

Responsibilities:

• Worked with building the backup and Restore technique for ETL of SAS provided the disaster recovery and High Availability technique for any Production failures.
• Enhance and improving existing process and production.
• Performed Data Extraction, Transformation, and Loading (ETL) from Data sources like Multiple Relational Databases like Oracle, SQL Server, Teradata and MS Access.
• Developed Teradata scripts for data analysis, reporting, table compressions, container space management.
• Developed mappings to format and move the data from Teradata staging area to intermediate tables using Teradata loader utility MLOAD.
• Developed UNIX Shell scripts to implement transformations and load the data from intermediate Teradata tables to Teradata target tables.
• Re-designed and upsized an Access database application to VB6/SQL Server.
• Implemented new production including creating safeguards for batch processing and updating new batch for custom data etc.
• Build flat file and data clean up by using SAS as requested. Improving and updating intranet for Risk Management.
• Manually running re-pricing model by cycle, also writing back-up code if problem occur.
• Job routine scheduled by coding UNIX KORN shell script and edit CRON tab.

Environment: Base SAS, SAS Macros, SAS/Connect, SAS/Access, SAS DDE, SAS ODS, SAS/GRAPH, Oracle 9i, SAS V9.3, SAS Enterprise Guide, Enterprise Miner, Excel, Oracle, Teradata, Windows XP, AIX UNIX