SUMMARY

• Over 6+ years of experience in developing programs, statistical analysis and reporting in clinical and research, IT and healthcare environments using SAS Software.
• Experience and knowledge in using Base SAS, SAS Via 3.5, SAS Enterprise Guide, SAS Enterprise Miner, SAS stored process, SAS/MACROS, SAS/SQL SAS/ODS, SAS/GRAPH, SAS/STAT, SAS/ORACLE, SAS/CONNECT, SAS/ACCESS and SAS/SHARE. Deep knowledge in Data Warehousing concepts.
• Experience working, Installing & Configuring SAS EBI platforms, SAS via 3.5 with SAS 9.3 & 9.4.
• Experience and worked on SAS via Model studio, Visual text analytics and Forecast analysis.
• Experience in administering SAS Grid environment using SAS Management Console and SAS LSF.
• Worked closely with SAS Experts during SAS 9.4 installation and configuration.
• Worked on TERADATA and utility domains. Optimization of Queries in aTeradatadatabase environment.
• Firm understanding of Proc OLAP and Proc Info map to deliver solutions meeting complex business needs.
• Good understanding of the SAS Web tier and SAS Server Tier Architecture in GRID environment with excellent troubleshooting skills. Have Health Care Domain Knowledge.
• Hands on experience in performing client installations of various SAS products like SAS Enterprise Guide, SAS Enterprise Miner, SAS Add - in and SAS Model Manager on user’s machines.
• Experience in setting up connections to different Databases like oracle, SQL, DB2, HADOOP and NETEZZA according to users requirement. SPDS implementation. Retail ecommerce experience.
• SAS EG 8.1 (Enterprise Guide) with Knowledge of BO and Architecting SAS environments.
• Created Software Development Life Cycle (SDLC) document and excelled in the process of Change Management, Release management and Configuration processes.
• Strong knowledge on LINUX and SHELL SCRIPTING, Worked as BASE SAS programmer.
• Hands on experience using BI tools like SAS Data Integration Studio and SAS Marketing Operations Management. Strong knowledge on SAS HPA architecture.
• Strong knowledge of the operating systems that SAS is installed on like its memory management, file system Architecture, CPU utilization etc. Hands on Ad Hoc. Hands on Data Ware Housing.
• Converting existing reports programs to stored procedures And Converting existing BO reports to enterprise guide.
• Excellent communication and report writing skills, with the ability to effectively communicate results of analytics to diverse audience.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis MN

SAS Developer

Responsibilities:

• Hands on experience in SAS Enterprise Business Server Administration with a strong background in UNIX Systems Administration with on-call production support.
• Performing SAS product installations with SAS Deployment Manager on user’s machines and assisting users in connecting to the SAS Grid servers from the required SAS product for their activities.
• Performed depot subset for client side tools using SAS 9.4 Depot Sub setting Utility.
• Creating and removing the User IDs, user groups, and roles on the SAS Metadata and giving the library access by using SAS Management Console. deep knowledge on SAS LSF platform
• Provided day to day direction to the project team and regular project status to the customer.
• Modifying and mapping of existing program according to the requirement document and validate them after the completion.
• Design and develop routines, tools and using SAS EG/Base SAS to support ad hoc reports including automation in the SAS Web Report Studio.
• Using Data Transformation Services (DTS), an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources.
• Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs
• Involved in effective communication between the project team and the customer.
• Developed standard reports using Base SAS and macro language.
• Build the Logical and Physical data model for snowflake as per the changes required
• Worked on large SAS datasets to create reports. Also used Proc Import, Proc Freq and Proc SQL.
• Performed Cash flow process and identified the issues raised in them, also provided a summary of the issues.
• Used SAS Macros, PROC SQL to extract, sort match test accounts and ODS to HTML, PDF and RTF.
• Worked in Teradata environment and prepared datasets and libraries along with tables in it.
• Worked on LINUX and SHELL SCIPTING. Strong knowledge in Data Warehousing Concepts.
• Established DB connections like Oracle, SQL server and Netezza connections from the grid.
• Responsible for making the web based SAS services likeEnterprise Miner Web based and SAS Stored Process Web Application connectivity and ensuring it has no performance impact on the SAS Metadata Server.
• Experience in trouble shooting issues like file system unmounts, space outage issues, MEMSIZE issues, performance issues, service packs, checkouts after releases, hot fixes, monitor services regularly and perform service start, stop and status check when required and PAM and LDAP
• Creating EG projects from multiple SAS programs Building queries using EG Building Graphical reports using existing SAS programs Knowledge of EG console management Create reports using point and click
• Responsible for monitoring CPU usage, Disk usage, and system resources.
• Interacting with different Support teams like UNIX Administration, Database Administration, Production Job Scheduling Team, Middleware Team and others to meet SAS Developer’s access and connectivity requirements.
• Experience in interacting with SAS Technical support and opening tickets about issues when required.

Environment: BASE SAS 9.4, SAS Enterprise Guide 6.1, SAS Management Console 9.4, SAS Enterprise Miner 13, SAS Model Manager 12.3, SAS Add - in Microsoft office and SAS DI Studio in WINDOWS 7, XP AND RHEL 6.4.

Confidential

SAS Developer

Responsibilities:

• Collaborate with business unit counterparts to establish new account marketing goals and develop strategic and tactical plans to achieve them.
• Track and review campaign performance and generate recommendations based on learnings, established best practices and competitive landscape.
• Act as a subject-matter expert with business unit counterparts and on cross functional projects.
• Stay up-to-date on the latest marketing trends and bring innovation and new thinking to the group.
• Manage multiple initiatives to completion under concurrent, rigorous deadlines in a fast-paced dynamic environment.
• Coordinate and execute enhancements and tests with internal Chase teams and third party vendors.
• Maintain reporting on channel performance and individual test results.
• Deliver analytical/quantitative projects on default and credit risk issues impacting the portfolio.
• Developed the target Database table as per the requirement by writing the source qualifier Queries.
• Created Data Steps and PROC SQL to combine and aggregate data for accessing and manipulating database system. Wrote various queries using SAS/Base, SAS/SQL, and SAS/Macro for creating reports according to the Users requirement, extensively used Proc SQL to retrieve, update and report information on from sas dataset and other database products.
• Created Store Procedures, Functions and Views, modified existing SAS macros to assist with producing reports and deliverables.
• Created complex SQL queries using Inner, Left, Right, Outer, and cross Joins and transformed these queries into SAS code.
• Good experience in using Aggregates, Analytical functions like RANK, DENSE RANK, Sequence in the queries.
• Involved in Identifying, analyzing, and interpreting trends or patterns in complex data sets.
• Developed several on demand Excel reports/dashboard to higher management.
• Created crosstabs to display underlying data based on various graphs and charts created for further data analysis.
• Distributed reports using techniques like Presentations, PDF, and Reports to different user community.

Environment: SAS, SAS/BASE, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/ACCESS, SAS/SQL, Excel/Access, Windows - XP.

Confidential, Memphis, TN

SAS Developer

Responsibilities:

• Created Reports in SAS E.G. and SAS DI Studio using Proc Report, Proc Summary, proc means, Proc Print, Proc Tabulate. Developed enhanced multi-sheet Excel and PDF-based reports using SAS ODS (Excel, HTML, RTF, PDF), which are used to generate on Hyperion platform.
• Involved in analysis, development, testing, implementation, and provided technical support to business needs using SAS in Unix environment.
• Supported with Hyperion to SAS EG conversion Project. Specialized on SAS EG projects.
• Used SAS Enterprise Guide to create graphs, cascading prompts, and deploy stored processes.
• Converted more than 250 Hyperion reports to SAS Using SAS BI Tools.
• Attend meetings with end user to collect requirements.
• SAS data stores (SAS OLAP Cubes) required supporting business intelligence and reporting needs.
• Derived business intelligence solution ensuring accuracy, completeness and quality of the data in Global Sales operation systems.
• Exclusively worked on SAS Stored process to trigger query builder.
• Handled several data, Technical, formatting Issues in the process of migration.
• Create analyst-level dashboards and pivot tables using Prompts in SAS EG and Stored process.
• Develop SAS Metadata API that register and publish reports for SAS IDP and Web Report Studio
• Worked on scheduling jobs in SAS DI Studio. Performed daily weekly and monthly campaigns as per the deliverable schedules.
• Created dynamic Macro arrays by SQL and with data step programs. Used SAS Macros and SAS SQL queries to obtain results which were generally stored as delimited text.
• Used PROC SQL LIBNAME and PROC SQL Pass-through methods to access data on Oracle database.
• Worked on the Teradata queries as part of migration efforts.
• Thorough hands-on experience in using ODS to generate different files including RTF, MS Excels, PDFs and HTMLs.
• Raw data files in Excel and RTF formats in SAS for invariably short or unrelated data requested for a report was used to append or merge in SAS to obtain desired reports.
• Extensive knowledge and experience in Microsoft Office tools like MS Access, MS word, MS PowerPoint and MS Excel.
• Used SAS Web Report Studio (WRS) to manipulate reports.
• Importing all Reports from web report studio, Stored Process, BI Dashboard and Information Map to Information Delivery Portal.
• Expertise with several SAS dataset functions, SAS system options, Macros, Macro variables, stored process.
• Used SAS Proc SQL pass through facility to connect to Oracle tables and created SAS datasets using various SQL joins such as left join, right join, inner join and full join.

Environment: SAS 9.3 and SAS 9.4, SAS EG 7.1, SAS/Access, SAS/Base, SAS/Macro, SAS/Stat, SAS/Graph, SAS/SQL, SAS BI, SAS WRS, SAS IDP, SAS DI Studio, Oracle Teradata SQL Assistant 14.10, Oracle Hyperion Studio, Oracle Hyperion Web Client, MS Office, and Unix.