We provide IT Staff Augmentation Services!

Sas Consultant And Developer Resume

5.00/5 (Submit Your Rating)

SUMMARY:

Over 10 years of experience in application software analysis, design, development, testing, maintenance, support and implementation. Worked with systems for Telecommunication and Pharmaceutical Industries. Well versed with UNIX, BI/SAS (9.1.3), PC/SAS, SAS/BASE, SAS/ODS, SAS/AF, SCL, FRAME, SAS/Macros, SAS Libraries, SAS/EIS, SAS/OLAP, SAS/Spawner, AppDevStudio, S - PLUS, SIGMA/STAT, SAS/ETL, SAS/QC, SAS/ETS, SPM, SSRS, COGNOS, INFORMATICA, ACTUATE, SAS ABM, SAS/GLM, SAS/MIXED, SAS/Intranet/Enterprise-Guide/Miner, SPDS, MDDB, SAS/Adminitrator, REXX, C, C++, JAVA, ASP, JSP, Websphere, Visual Basic, PL/I, COBOL, RPG II, Teradata, ORACLE, SQL/SQR, PL/SQL, IMS, DB2 UDB, IDMS, MVS, JCL, CLIST, CICS, VSAM concepts and SOX.

TECHNICAL SKILLS:

Operating Systems: HP UX, SOLARIS UNIX, DEC UNIX, MS-DOS, WINDOWS98/2000, MVS

Statistical Software: Base SAS, SAS/SPDS, SAS/ETL, SAS/MACRO, SAS/EG, SAS/STAT, SAS/GRAPH, SAS/FSP/AF, SAS/ACCESS, SAS/ODS, SAS/Connect, SAS/IML, SAS/Enterprise Miner, COGNOS 7series/8.3/8.4

Programming Languages: SAS, PL/SQL, Pro*C, C/C++, Korn shell, AWK, SED, VB & Java

Web Technologies: Java Applets, HTML, Xml, Java Script, Java, Java Servlets/Jdbc, Java Web Server2.0, Apache Server and Weblogic 6.0

RDBMS: SQL, Server, ORACLE8i/7.0/6.0, Versant 5.0, MS Access, Teradata, VOB (version object base) & DB2 UDB

Application Software: MS Office (Word, Excel, Power Point, Access), Microsoft Visual Studio 6.0, MATLAB

GUI/CS Tools: Clear case (Rationalization tool), X-Motif, Siebel (CRM Tool), SAS/SPM, CA7

Debugger Tools: DATA STEP DEBUGGER, Workshop5.0, DBX, Ladebug 4.0-62 on Digital.

Testing Tools: TET (Testing Environment Tool kit), Autotest script, Win Runner

PROFESSIONAL EXPERIENCE:

Confidential

SAS Consultant and Developer

Responsibilities:

  • Created User accounts and manages Metadata servers using SAS Management Console
  • Created various profiles using SAS Management Console
  • Worked in SAS 9 Intelligence Platform (BI) (SAS Business Intelligence Suite with ETL, Reporting and Analytics with central SAS Metadata Server, SAS Workspace Server, SAS Stored Process Server, SAS OLAP Server, SAS Data Quality Server, SAS Web Infrastructure Kit, and SAS Integration Technologies, SAS Scalable Performance Data Engine and Server(SPDE and SPDS), SAS Metadata LIBNAME Engine, SAS Open metadata Architecture)
  • Supporting number of SAS applications in Production area
  • Promoted SAS applications code from different environments using SAS ETL 4.3 Studio
  • Created many reports using SAS Management Console, SAS Enterprise Guide, OLAP Cube Studio, Web Report Studio & Information Map Studio
  • Developed Quarterly reports for one of the department
  • Involved in loading monthly business data using SAS applications
  • Created Business users ids, groups and roles on various servers using SAS Management Console
  • Created various ADHOC queries using PROC SQL and SAS Macros
  • Resolved different SAS application issues and provided guidance to the SAS users in related to code
  • Wrote numerous SAS programs and resolved program related issues

Technical Environment: SAS/BI 9.1.3, SAS Macro, SAS SPDS, UNIX AIX machines, SecureCRT tool, Heat System, Lotus Notes and Microsoft Excel

Confidential

SAS & COGNOS Administrator

Responsibilities:

  • Supported various SAS applications in Production area
  • Promoted SAS applications code from various environments using SMC and ETL Studio
  • Created many reports using SAS Data Integration studio, SAS Management Console, SAS Enterprise Guide, OLAP Cube Studio, Web Report Studio & Information Map Studio
  • Involved in creating OLAP Cubes using dimensions, details and fact tables
  • Created various ADHOC queries using PROC SQL and SAS Macros
  • Resolved different SAS application issues and provided assistance to the users SAS code
  • Wrote numerous SAS programs and resolved program related issues
  • Created User accounts and manages Metadata servers using SAS Management Console
  • Created various profiles using SAS Management Console
  • Worked in SAS 9 Intelligence Platform (BI) (SAS Business Intelligence Suite with ETL, Reporting and Analytics with central SAS Metadata Server, SAS Workspace Server, SAS Stored Process Server, SAS OLAP Server, SAS Data Quality Server, SAS Web Infrastructure Kit, and SAS Integration Technologies, SAS Scalable Performance Data Engine and Server(SPDE and SPDS), SAS Metadata LIBNAME Engine, SAS Open metadata Architecture)

Technical Environment: SAS/BI 9.1.3, SAS Macro, Sun Solaris, HP 64 bit, TECTIA tool, Tidal, AUTOSYS and Microsoft Excel

Confidential

SAS & COGNOS Administrator

Responsibilities:

  • Supported various Confidential COGNOS Internal Projects and given full support for COGNOS users
  • Possessing thorough knowledge of COGNOS architecture according to IBM and Confidential standard
  • Hands on experience on all COGNOS products on both UNIX and Windows
  • Promoted regularly COGNOS/8.4 Applications from DEV to UAT, and UAT to PROD
  • Regularly build COGNOS Cubes manually and promoted NEWSBOXES using Deployment Manager
  • Regularly handle COGNOS and Applications user’s related issues across all environments with in time
  • Regularly checking COGNOS Servers stats in related to performance/memory and space issues
  • Provided guidance to developers in related to COGNOS applications development
  • Involved in development of COGNOS reports using Report Studio/Query Studio and Analysis Studio
  • Created various COGNOS metadata model using Framework Manager
  • Supported scheduling tools Tidal and AUTOSYS for jobs scheduled extensively
  • Involved in Data Warehousing and ETL using Informatica Power Center 8.6.
  • Created many jobs in AUTOSYS for DEV, UAT and PROD

Technical Environment: COGNOS 7series/8.3/8.4, Sun Solaris, HP 64 bit, SSH TECTIA tool, HP open view product, Tidal and AUTOSYS & Microsoft Excel

Confidential

SAS & COGNOS Administrator

Responsibilities:

  • Supported Confidential ACTUATE Internal Projects with giving full support
  • Have been thru ACTUATE architecture according to IBM and Confidential standard
  • Hands on experience on all ACTUATE products on both UNIX and Windows
  • Promoted when required ACTUATE Applications from DEV to UAT, and UAT to PROD
  • Have been update ACTUATE promotion files when required

Technical Environment: ACTUATE, Sun Solaris, HP 64 bit, SSH TECTIA tool, HP open view product, Tidal and AUTOSYS & Microsoft Excel

Confidential

SAS Developer

Responsibilities:

  • Conversion of SAS datasets from version v8 to v9
  • Reading the raw data and converting into SAS v9 datasets
  • Wrote various SAS programs and resolved program related issues
  • Involved in Dashboards, ETL, OLAP analysis
  • Writing shell scripts to automate the batch jobs
  • Performing UAT testing on the datasets access level
  • Testing read/write/execute access on the datasets
  • Checking with the users if they have any issues while UAT & PROD testing

Technical Environment: SAS 9.1.3, SAS Macro, Sun Solaris, Hp 64 bit, Putty tool and Microsoft Excel

Confidential, SAN Bruno, CA

SAS Developer/Tester

Responsibilities:

  • Involved in review functional and technical design specifications and data modeling
  • Involved in gathering & documenting requirements with following business people
  • Developed various FSEDIT Screens for users to input data
  • Wrote various Edit checking SCL routines to take users input data
  • Created customized user friendly menus on AF application
  • Developed various frames to select data for input to application
  • Developed SCL programs to customized help Screens
  • Wrote various SAS and SQL Queries to extract data from tables
  • Wrote SAS data steps to extract data and perform analysis with using base SAS
  • Created cubes and process queries against cubes
  • Compiled and Executed SAS AF application programs
  • Created and Run various SAS programs to set up the paths to the application
  • Queried various tables using Interactive SAS Environment to understand the relations
  • Prepared and Created Unit Test Cases Script to Test SPPOT application
  • Created Test Cases Data preparation for Unit and System Test
  • Wrote Unix shell Scripts to automate the batch jobs
  • Currently working on Unix platform - Sun OS & AIX.
  • Used Reflection and Putty tool to access Unix and launch Interactive SAS
  • Prepared Sizing and Packing Simulation Model in Excel

Technical Environment: SAS 9.1.3/8.2, SAS/ODS, SAS/Macro, SAS/AF, Oracle Database, PL/SQL, SQLPLUS, Sun Solaris 5.8, AIX 5, Reflection, Putty tool, Windows 2000, Microsoft Excel, OS/390.

Confidential, Herndon, VA

SAS Developer/Analyst

Responsibilities:

  • Involved in gathering & documenting requirements with following business people
  • Produced various reports for the Re-Statement Auditing Team Using Base SAS 9.1.3
  • Produces various Ad-hocs reports using SAS and Oracle Database
  • Extracted tables from Oracle and created SAS Datasets by using Libname and Pass Through SQL Facility with compliance to SOX rules and regulations
  • Generated various table dumps for Auditing Department
  • Generated various customized reports with respect to business requirements using Proc Report, Proc Tabulate, Proc Summary, Proc Means and Proc Template.
  • Perform ETL work using SAS programs and ETL tools
  • Used SAS Macro’s to produce re-usable and dynamic code to generate various reports
  • Involved in creating SAS OLAP Cubes using SAS OLAP Server
  • Processed various queries against the OLAP cubes
  • Applied cost allocation to the right activities using SAS ABM tool
  • Build static and ad-hoc reports using SAS ABM tool
  • Involved in writing Unix shell Scripts to automate the batch jobs
  • Used ODS HTML to transfer the data from SAS Datasets into Excel spreadsheets.
  • Involved in using various Stats like Proc Freq/Summary/means/tabulate for Analysis
  • Tested various queries on Oracle database with SQL PLUS
  • Involved in review/writing functional and technical design specifications
  • Involved in using Clear Quest Tool to track Project defect/Enhancements
  • Currently working on Unix platform - Sun OS & AIX.
  • Involved in Extraction, Transformation and Loading using Informatica Power Center
  • Involved in helping Business Users on Business Objects InfoView to generate the reports they need.

Technical Environment: SAS 9.1.3, SAS/ODS, SAS/Macro, Oracle/Sybase Database, PL/SQL, SQLPLUS, Sun Solaris 5.8, AIX 5, ClearCase, ClearQuest, AutoSys, Windows 2000, Microsoft Excel, BO/InfoView XI Release2

Confidential, Mclean, VA

SAS Developer/Analyst

Responsibilities:

  • Developed various reports for Corporate Tax Dept of Confidential in accordance to the code standards with following code review at the end
  • Developed Report tax mdar nonwsc update describe Appending both matched records and unmatched records after deleting the matched records from sybase table after reading input data from LAN
  • Developed Reports 41 compare strip io amort, 42 compare strip io gain loss for all 12 months of the year by creating separate text files for each month output and the files will be moved to LAN at the end
  • Developed Report 43 interest income 4 strip io and generated output for each id and making accumulated on one text file
  • Developed report roll forward Rpt2 Supplement 103 to run successfully to produce LAN reports with respect to monthly, quarterly and yearly
  • Developed Cusip Report diff monthly cusip and generated output in 3 separate csv files
  • Wrote ETL jobs to automate using SAS programs and ETL tools like EG/Cognos
  • Involved in review/writing functional and technical design specifications
  • Involved in Infrastructure issues with compliance to meet SOX rules and regulations
  • Involved in creating OLAP cubes to access the pre-summarized data for Business users
  • Applied cost allocation to the right activities using SAS ABM tool
  • We make decisions on accurate information using SAS ABM tool
  • Created predictive analysis on corporate data using SAS Enterprise miner
  • Involved in analyzing various SAS processes to fix the data errors
  • Involved in fixing various Monthly reports in Production Support for Corporate Tax
  • Involved in fixing Ad-hoc reports in Production Support
  • Involved in installation of SAS System on Unix Server
  • Developed SAS SQLStatements from Unix Shl Sql Script
  • Wrote various SAS macros to clean-up the unused datasets
  • Created various Shl & Jil Scripts, Run books for AutoSys Jobs
  • Extensively Involved in ClearCase and ClearQuest

Confidential

SAS & COGNOS Administrator

Responsibilities:

  • Involved in Amortization Project and extensively worked on Fee- reversal subsystem
  • Involved in Confidential Metadata/data profiling
  • Involved in Confidential Security Work
  • Involved in Confidential Deployment process with SOX Compliance
  • Developing and resolving errors Confidential Reports
  • Involved in setting spaces to SAS Log/Output/Data on Unix Server
  • Handling Business Users Calls to fix their problems
  • Working as Clearcase Integrator for Confidential projects
  • Handling Confidential Mail box and Vantive box
  • Involved in Developing Confidential Web pages using HTML and Javascript
  • Html pages are developed using ods html and Proc Template to easy access for business users.
  • Involved in SAS ETL processes to load data into database
  • I converted into permanent sas dataset using Proc import after making readable format.
  • Wrote various SQL queries to run against DB2 and Sybase Databases
  • Generated the SAS output in various formats Excel, Pdf, Rtf and Html.
  • Customized Gplot reports including Javascript code with SRC and headtext tag.
  • Wrote Unix Scripts to back up the logs into different directory

Technical Environment: SAS 8.2, SAS/ODS, SAS/Intrnet, SPM, SQL Server, DB2 UDB, Sybase Database, PL/SQL, Sun Solaris, AIX, ClearCase, ClearQuest, AutoSys, Windows Xp, Microsoft Excel, Mainframe OS/390

Confidential, Minneapolis, MN

SAS Developer

Responsibilities:

  • I plot Bubble graphs with respect to Sales and Gross margin for each departments.
  • Plotted Each Graph considering Top 20 Vendors with reference lines to sales and margin.
  • Reference lines are plotted to X-axis and Y-axis based on median values using href and yref options on bubble plot.
  • Plotted Bubble plots for each class of different departments and created various buttons on each dept with respect to each class and referring each class plot by clicking respected button
  • I produced records under each graph by Quadrant wise with respect to median values.
  • Above Gif graphs are plotted using ods html and Proc Template to easy access business users
  • I got Raw-data in excel format from division Electronics.
  • Involved in accessing data from Teradata database
  • I converted into permanent SAS dataset using Proc import after making readable format.
  • I coded to separate required fields using indexc, scan, substr, tranwrd and then sorted.
  • I applied logic to check repeated occurrence of vendors with various changes in their names as sub-branches comes, then I converted to respected vendors name.
  • Sorted vendor wise and applied calculations to get various stat fields after group calculations performed with applying means and sum functions.
  • Similarly as above to class wise in for each departments. And produced various reports respectively.
  • Customized Gplot reports including Javascript code with SRC and headtext tag.
  • Created reports after accessing data from database using SQR Tool
  • SPM used to Integrate, distribute and analyze enterprise wide information.
  • Plot and Analyzes various graphs using SAS Enterprise Guide.

Technical Environment: SAS 8.2, SAS/ODS, SPM 2.0, SQL Server, Oracle8I, PL/SQL, Sun Solaris, Windows Xp, Microsoft Excel

Confidential, Swiftwater, PA

SAS Developer

Responsibilities:

  • Developed SAS programs to validate and replicate Excel applications using Base SAS, SAS/STAT, SQL SAS/Macro's and SAS/AF products on Windows and Unix platform using SAS 8.2. And Involved in analyzing clinical trials data.
  • Involved in validating, testing and developing around 8 excel applications using Base/SAS, SAS/Macro’s, SAS/ODS with Template and SAS/AF for front-end application for user input with successful completion of Probit Analysis.
  • Involved in creating tables/listings/Graph on PK/PD data for phase-1 trial.
  • Developed MNT excel applications and SAS programs to validate them successfully.
  • Developed MNG Analysis application, using base/SAS, SAS/macro’s, SAS/SQL and ODS template.
  • Developed “ Residual Ammonium Sulphate ” excel application and replicated to SAS application using base/SAS, SAS/macro’s, SQL and ODS.
  • Performed various Statistics work to resolve and developed all above SAS applications using PROC PROBIT/REG/GLM/UNIVARIATE/CORR/FREQ/ANOVA/MEANS.
  • Performed Linear Regression/P-value analysis to better fit data model.
  • Involved in SAS/admin to setup spaces for the various groups
  • Analyzes various format data using SAS Enterprise Guide and SQR Tool.
  • Wrote VBA macros for excel applications.
  • Involved in collecting clinical trial data from different users.
  • Involved in generating reports on phases 1, 3 & 4 of clinical trials.
  • Involved in review/writing in IQ/OQ/PQ protocols.
  • Involved in review/writing sops and functional specifications.
  • Strong Knowledge of CDISC, SDTM and ODM.
  • Involved in creating ISS and ISE reports in compliance to FDA formats.
  • Involved in document source code and complete application design with using Documentum software.
  • Involved in design CRF part 11 to get electronic sign from users.
  • Involved in computer validations.

Technical Environment: SAS 8.2, SAS/AF, SAS/ODS, DB2, Oracle8I, PL/SQL, Linux, Windows-2000/NT, Shell-Scripts and Documentum4.1.i, Excel, VBA, Microsoft Visio, SQR tool

Confidential, Bridgewater, NJ

SAS Developer

Responsibilities:

  • Generated Statistical reports on company sales information using PROC/STAT.
  • Created Statistical reports using different statistics option with PROC MEAN.
  • Created tables showing the distribution of categorical data values using PROC FREQ.
  • Developed new SAS Macros and maintained existing macros.
  • Perform System Maintenance/ enhancement for contract administration system.
  • Ad-hoc Reporting, analysis and assist user community with their analysis requirements.
  • Developed Stored Procedures for populating data into various Applications as per Business rules.
  • Involved in writing various Perl scripts.
  • Extracted SAS based reports and exported them into excel sheets as per the customer requests.
  • Wrote Unix Korn Shell scripts to automate batch report generating programs.
  • Involved in generating various reports using Brio Report tool.
  • Extracted raw data from an Oracle database and used BASE SAS to manipulate it into data sets in Unix environment.

Technical Environment: Oracle8i, Sun Solaris, HP (10.2, 11.0), C, C++, COBOL and AS/400, JCL.

We'd love your feedback!