SUMMARY:

• Over 15 years of experience in Administration & Development of Data Analysis Tools, Development and Quality Assurance of Client Server, Analytical applications.
• Total of 07+ Years SAS IT Experience using SAS, SAS Macros, SAS EBI, Oracle, SQL Server, ETL Concepts, and UNIX.
• Experience working as SAS Administrator for 5+ Years.
• Expertise in Project Management cycle, Functional testing & Integration /System testing, Documentation, Test plans and Test scripts.
• Experience working on SAS Servers environments Maintenance, Metadata Backups, Creation of Libraries, Groups, Hot fix Installations, & Production Support of SAS Jobs, experience working on SAS Grid & Supported SAS Platform.
• Worked closely on SAS User Issues.
• Expertise in applying SAS procedures like Proc Means, Proc Freq, Proc Sort, Proc Format, Proc Report, Proc Tabulate, Data NULL, Proc Print and their multiple options Proc Import, and Proc Export for importing and exporting data, Proc Contents and Proc Datasets to view the contents of the SAS libraries.
• Extensively used merge, set, in Data steps to combine many data sets.
• Experience in working in Windows & UNIX environment, able to read & write Korn shell scripts.
• Worked on SAS datasets using the ETL concepts to increase the overall performance.
• Exposure with the concepts of OLAP, Stored Procedures.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAStools - SAS/Base, SAS/Macros, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access.
• Developed SAS macros for data cleaning, reporting and to support routing processing. Analyzed and interpreted numerical data from various sources organized and summarized data for analysis.
• Proficient in identifying business rules, functional capabilities, business events, relating business rules to the process model and developing an event model.
• Proven Development, Administration and QA skills by establishing attainable goals, expectations and timelines.
• My experience and versatility make me a key member of implementation team.
• Good exposure with Hadoop technologies like Pig, Hive, Yarn, Oozie, HBase.
• Knowledge of FDIC regulation and Dodd-Frank Stress test.

TECHNICAL SKILLS:

Operating Systems: Windows, MS-Dos, UNIX (Linux)

Databases: Oracle 11.x, SQL Server 2008, SQL Server 2012, DB2 10.1

Languages: SQL, SAS 9.x

GroupWare: Lotus Notes 8.5

Tools: Base SAS, SAS Grid Manager 9.4, SAS Management Console 9.4,SAS IT Resource Management 3.2, SAS Management Console 9.2, SASWeb Portal and SAS Gallery Manager, QlikView 11.x, Cognos 10.x

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, IL

SAS Administrator

Responsibilities:

• Design, develop and manage/support SAS IT Resource Management data marts on LINUX 64-BIT environment from Relational Databases, Weblogs, WebServices, BMC Tools (Best1, Patrol, QPasa ), and HP Diagnostics
• Experience in
• Experience with analytical manipulation and interpretation of large SAS data sets.
• Responsible for testing, publishing reports and providing access to end users.
• Build and maintain complex statistical SAS routines using macros.
• Performed various Admin Activities such as Metadata Backup/Restore, SAS Servers Refresh, and Hot fix/patch installations.
• Created hot fix report using HFADD Tool and installed required hot fix on Linux Server.
• Create detailed documentation outlining report criteria.
• Added users, created groups, metadata libraries & metadata permissions are set using the groups.
• Maintain data integrity and ongoing quality control of reports.
• Ensure that reports support the overall scope of HP Service Management strategies.
• Respond and track status of customer issues, coordinate appropriate response and provide follow up for the duration of an incident/problem ticket life cycle.
• Basic knowledge of VMware virtualization technologies, data model and API.
• Programming / Scripting Experience with Perl and Shell (Bourne/Korn).
• Expert level Database knowledge of SQL Server, IBM DB2 and Oracle
• Experience with Task Automation using Control-M and Platform LSF.
• Basic Tomcat and JBoss experience.
• Strong skills with Active Directory, LDAP, Kerberos Authentication, Windows Server 2008/2012, and BMC® Performance Assurance.
• Knowledge of Pluggable Authentication Modules (PAM).
• Used in SAS Enterprise Miner to create predictive and descriptive models on large volumes of data across different sources using SEMMA
• Programming / Scripting experience in QlikView and Splunk.

Environment: SAS 9.4, SAS Grid Manager 9.4, SAS Management Console 9.4, SAS 9.2, SAS IT Resource Management 3.2, SAS Management Console 9.2, SAS Enterprise Guide 5.3, SQL Server 2008/2014, Oracle 11.2, DB2, QlikView, Linux/Unix & Windows, LSF and VMware

SAS Administrator

Responsibilities:

• Added new users to SAS Management Console, Created new groups, etc in SMC.
• Responsible for the SAS Services running on the Box - Metadata Server, Base SAS, Object Spawner.
• Added new users on the Management Console for them to access the Metadata.
• Monitored the Disk Usage on the SAS Server & sent out reports regularly - Biweekly on the Usage by File Size, User Wise & Disk wise.
• Created Libraries for the Databases & Imported the Warehouse tables that is being used using the Management Console. The tables can be accessed using SAS Enterprise Guide.
• SAS License Renewal, Supporting Operating System Patches, are coordinated by me between users & System Administrators.
• Worked closely on performance issues with users and helped them resolve the access issues, performance issues.
• Created different Security roles using ACT's & applied to the groups at each project level to handle effectively the roles.
• All the SAS codes are built using macros & auto macro call facility. A parameter file & centralized library for formats are maintained as coding standards across all tracks.
• Point of contact to work with SAS Tech Support from the team.

Environment: SAS v9.2, SAS Multi-Tier Servers, SAS Enterprise Guide, SAS Management Console, Metadata Server, SAS/SQL, SAS/MACROS, SAS/ETL, SAS/BASE, SAS/Access to Teradata, UNIX, PUTTY

Programmer Analyst

Responsibilities:

• Analyzed the user requirements by interacting with Users, Developers and Business Analysts.
• Involved in the analysis of use cases and Business Volume Metrics to assist in the validation of business-technical requirements.
• Supported production issues/questions from Customer Connections & Department Services regarding CIMS applications.
• Involved in analyzing business requirements and preparing Test plan using the Company Standards.
• Generating weekly status reports to the team manager & attend weekly status meeting with Team members, Team managers, Business analysts & Technical team.
• Developed and analyzed scripts for Automated Regression Testing Suite.
• Performed load testing of CIMS application on Simulated Production server at the time of release of the application.
• Performed load testing of CIMS application using Web Services and Java Framework (RMI).
• Developed and analyzed scripts for Rational Tool Suite products.
• Developed and analyzed scripts for Automated Regression Testing.
• Developed and analyzed scripts for IBM Rational - Rational Functional Tester.
• Performed final testing on Production server at the time of release of the application.

Environment: DB2, J2EE, SilkPerformer 2007, Rational Functional Tester, Rational Tool Suite & Windows XP, SQL Server 2000, Test Director 8.0, IBM Rational, SilkTest 7.1, SilkPerformer7.2, Rational Tool Suite & Windows NT

Programmer Analyst

Responsibilities:

• Developed new SQR for financial modules.
• Upgraded/Customized SQRs of HRMS from 8.0 to 8.8.
• Developed new change control version project for financial module.
• Customized application pages, PeopleCode and Application Engine programs using PeopleTools.
• Resolved salary tracking reporting issues.
• Supported payroll and time and labor production issues.
• Worked with voucher build Application Engine program to build vouchers from purchase orders and payable contracts.
• Reviewed and applied patches.
• Developed new run control pages for customized SQRs.

Environment: HRMS 8.8/8.0, Financials, SQL 8.0, Win SQL 4.0, PeopleTools 8.17/8.44

Programmer Analyst

Responsibilities:

• Involved in designing and setup of HRMS, Time and Labor and Payroll modules.
• Created recruitment form letters and training schedules using SQR and Crystal reports.
• New panels created for employee training needs.
• SQR is created to upload employee data from legacy system.
• Involved in setting up Time and Labor business process and integration with HRMS and Base Benefits.
• Existing SQRs customized based on user requirements.

Environment: HRMS 7.5(Payroll, Benefits, Time and Labor), SQR, DB2 z/OS, PL/SQL

Software Engineer

Responsibilities:

• Responsible for Analysis, Design, Development, Testing and Debugging.
• Extensively used SQL and PL/SQL in packages, triggers, functions, procedures.
• Designed and developed reports using Crystal Reports, which include cross tab, summary reports from tables and stored procedure.
• Involved in converting the existing MS Access application, which requires mapping of existing data into new tables, and also converting the existing data to accommodate business requirements.
• Developed and tested a menu driven package consisting of Forms and Reports for the maintenance of reference tables, utilizing event driven programming and object oriented programming techniques.
• Written several database functions and procedures. Used triggers at form and report level to define constraints and complex business rules. Migrated data from MS Access to Oracle.

Environment: Oracle 7.5, SQL, PL/SQL, Forms, Shell Script, MS Access, Crystal Reports, Windows NT