Arunkumar Pachunoori

Contact no. 301-***-****

Email:ad1coz@r.postjobfree.com

SAS Certified SAS®9.4

Synopsis

** ***** ** ** ********** including over 15 years of Progressive experience as SAS BI ADMINISTRATOR in real time analysis, design, development, testing, and implementation of various SAS applications in Insurance, Pharmaceutical, Finance, Healthcare, and Marketing.

Profound knowledge and strong experience in Base SAS/SAS 9.1.3,SAS 9.2,SAS9.3,SAS9.4 SAS/MACRO, SAS/ODS, SAS/GRAPH, SAS/SQL, SAS/STAT, SAS SHARE, SAS/IntrNet and SAS/Connect, SAS Enterprise Guide, SAS Enterprise BI Server, SAS Metadata server,SAS Workspace Server,SAS Stored Process Server,SAS OLAP Server, ObjectSpawner, Connect Server, APServer, SAS Remote Services, SAS Management console, SAS Grid Manager,Tomcat/ Apache, IBM Web Sphere MQ(AIX),SAS Xythos,SPDS, ServiceNow, CA7 Scheduling, GPFS file system, IBM Spectrum Scale

Thorough knowledge of Oracle 8i, MS-Access, SQL Server 2000, DB2, SQL and Teradata

Extensive experience in preparation of tables, listings, and graphs.

Proficient in writing UNIX Shell Scripts (Korn, Bourne).

Excellent skills in web technologies like ASP, Java Script, XML and HTML, SAS Enterprise Guide 4.1 & 4.2,5.1 SAS Grid Computing, SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio 3.1 & 4.2, SAS Information Delivery Portal, SAS OLAP CUBE Studio 9.1 & 9.2, SAS Web OLAP Viewer for Java, SAS 9.3 applications & SAS 9.4 Visual Analytics

Involved in all four phases (experimental design, selection of appropriate statistical methodology, data analysis, summarization, and reporting) of Clinical Trials of IND and NDA applications for FDA submission for approval of new drugs.

Good experience in IBM Mainframes: MVS/JCL, TSO/ISPF, COBOL, CICS, GPFS file system, IBM Spectrum Scale

Good experience in RDBMS development including SQL, PL/SQL programs and stored procedures.

Excellent interpersonal, analytical, problem solving and communication skills with ability to interact with individuals at all levels.

Ability to work efficiently both as individual and as part of a team

SAS Administration trained and certified Client through SAS vendor (SAS Grid Administration, SAS Web report Studio,SAS Stored Process Web Application, SAS Information Delivery portal,SAS Web Report Studio, SAS Information Map Studio,SAS OLAP Cube Studio, SAS Web OLAP Viewer for Java), SAS Enterprise Session Monitor (ESM)

Educational Credentials

Bachelor’s degree in Electrical & Electronics Engineering, Nagarjuna University, India.

Professional skills

Operating Systems: Windows 95/98/00/NT, MVS, UNIX, Linux RHEL 4, Microsoft(R) Windows(R) Server 2003

SAS Skills: Base SAS, SAS/MACRO, SAS/Connect, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/IntrNet, SAS/ODS, SAS/Access, SAS Enterprise Guide 4.0,5.1 SAS Grid Computing, SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio 3.1, SAS Information Delivery Portal, SAS OLAP CUBE Studio 9.1, SAS Web OLAP Viewer for Java, SAS/AF, SAS/SCL, Enterprise Miner, SAS ETL Studio, SAS DI, SAS VIYA, SAS BI ADMINISTRATOR, AWS, Azure, SAS AWS Cloud instance

Databases: Oracle 8i, Oracle 10g, MS Access, MS Excel, MS SQL Server, DB2, Teradata, Sybase, SQL Server 2005, MS SQL Server Management Studio Express

Programming Languages: C, C#, Java, COBOL, PL/SQL, VB, VB.NET, R

Mainframe Tools: MVS/JCL, TSO/ISPF, CICS, MVS utilities.

ETL Tools: SAS ETL Studio, SAS DI, Informatica

Web Technologies: HTML, XML, JavaScript, JSP, Cognos, ASP.NET, R-Studio, Shiny

SAS Procedures: Print, Transpose, Contents, Means, Chart, Plot, Tabulate, Univariate, Summary, Sort, Reg, SQL, Copy, Freq, Forms, Proc Upload, Proc Download, Formats.

Scripting: Korn, Bourne, PERL, and JavaScript.

Reporting Tools: Cognos Report net 8.0, SAS Web Report Studio, SAS Information Delivery Portal, Cognos Powerplay and Impromptu

Career Highlights

Client: eBay Inc. June 2014–March 2023

Title: SAS BI Administrator Administrator & Architecture

Responsibilities:

Build SAS 9.3/SAS 9.4 Server setup Client’s installation & SAS server configuration on Unix Solaris server

SAS 9.4 Grid Administration & SAS Grid Computing Architecture responsibilities, client server and multi-platform across multiple environments

Install, Setup SAS 9.4 Grid Server Clients and Server configuration on C3 Cloud Linux servers .

Install the Platform Suite for SAS Version 7.1, Platform RTM for SAS and configure the Platform LSF, Platform process Manager, Platform MPI and Grid Management services on SASGrid Application server

Setup NFS (Network File System) on C3 Cloud Red Hat Linux servers and file mount shared directory between all the machines in the SAS 9.4 Grid Servers.

As a team lead SAS Administrator involved in architecture performance tuning, disaster recovery, failover, cluster support, user management and storage volumes support on Servers.

Manage huge multiple Grid environments on Linux platform .

Monitor the SAS Server services, OMA Backup’s, cleanup temps, User’s storage space allocation and worked with end user’s requests.

Adding New users to SAS Linux servers, Create Users Groups, Roles, Access control template creation and controlling SAS user group security permissions

Create SAS Oracle, SAS SQL libraries on SAS Management console register data into Oracle, SQL SAS libraries and grant the users to access SAS data thru SAS Enterprise guide application

Unix Solaris & Linux scripting experience, adding LDAP UNIX user’s accounts, groups, sudo group-id, change users’ groups on Unix/Linux servers.

Deploy patches on SAS Linux servers, hot fix deployment on SAS Servers.

SAS servers license renewal, Users SAS Clients renewal deployment, Setinit license cycle and be able to update the Setinit to avoid a lock out

Build setup SAS Metadata server, mid-tier, compute server configuration experience

Adding New SAS Application server to existing SAS 9.3/9.4 Server Configuration environment.

Configured load balance setup SAS Application servers on SAS Management console plugins.

Experience in maintaining a large multi-platform SAS environment it includes SAS Business intelligence tools and SAS application tier.

Good experience in SAS 9.4 Grid data migration from different data centers .

Troubleshoot SAS Users SAS applications issues and provided technical solutions to business user needs. Support Mid-tier JBoss - SAS portal issues, SAS Server configuration issues, SAS servers’ performance issues and follow up SAS Users issues and open ticket with SAS Support, Weekend, and afterhours SAS Production jobs Support issues

Good SAS programming and SAS BI Advance tools applications experience in SAS Management console, SAS PC-SAS, SAS Enterprise guide, SAS E-miner, SAS Portals (SAS Stored process web application, SAS Information Delivery portal), SAS Visual Analytics, SAS Information Map studio, SAS Web report studio, SAS DI Studio and ACCESS to Teradata, Hadoop, Oracle, SQL Server

Involved SAS Migration from non-Grid server to SAS 9.4 Grid environment.

Build POC SAS Viya install and configure the server.

Good experience Azure and Kubernetes on SAS Viya Administration big data platform.

Build R/RStudio/Shiny Server installation and configuration.

Support R Server, R-Studio application Users issues and install R-Packages

Working with Audit Board integrated tool to manage company's audit, compliance, and risk management program.

Involved in infrastructure planning design capacity planning and performance tuning.

Experience Linux Shell Scripting Administration and monitoring tools to tunes the SAS Viya optimal performance.

Analyze and resolve SAS Users problems and servers hardware/software applications issues.

Detects, diagnoses, and reports related problems on the SAS servers.

SOX Audit team to manage the controls compliance with overall IT policies.

Setup and configure the R-Studio/shiny server high availability load balancer on ubuntu.

R-Studio/Shiny application 2FA enabled and login authenticate through Unix credentials.

Good experience in project management handling business team members project completion at client.

ServiceNow used for create Incident, Problem, Change, Releases, Configuration Management, Service Requests, and process automation of tasks.

Organize weekly team meeting update project delas with Director and Managers various business units.

Responsible for the technical delivery and managing coordination SAS Environment POC.

Involved in project plan, milestones and deals with different business teams work with client.

Support more than 600 Users on R/R-Studio Pro/Shiny Pro/R-Studio connect application.

More than 7500 R packages are available in the Rstudio environment application.

Support types of Data source access, MySQL, MSSQL, Hadoop, Teradata, Hermes

Monitor number Cron R jobs 10 to 300 process and Shiny dashboard reports 400 jobs.

Build the SAS Enterprise Session Monitor (ESM) for monitor SAS Users jobs .

Support on call tableau administration and MicroStrategy administration.

Deploy migrate R Servers and SAS Servers to cloud environment.

Environment: SAS 9.1.3, SAS 9.2,SAS9.3,SAS 9.4,SAS Management Console 9.1&9.2&9.3& SAS9.4, SAS Enterprise Guide 4.0 & 4.3,5.1 SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio 3.1 & 4.2, SAS Information Delivery Portal, SAS OLAP CUBE Studio 9.1 & 9.2, SAS Web OLAP Viewer For Java, SAS Enterprise BI Server, Teradata, Oracle 8i, SQL, HTML, XML, JavaScript, SAS Enterprise Miner 5.3, SAS Forecast Studio, Linux RHEL 4, Microsoft(R) Windows(R) Server 2003, Enterprise Edition,SAS Data Integration Studio 3.4 & 4.2, Metadata Server, ObjectSpawner, Connect Server, APServer, OLAPServer, IBM Web Sphere Application Server(MQ(AIX)), SAS Remote Services, SAS Xythos, SAS OpRisk VaR 4.1, SAS Studio,SAS Grid manager 9.3/ 9.4, Platform LSF,Platform process Manager,Platform MPI,Grid Management services, SAS Grid Application server, Platform RTM for SAS,SAS 9.4 Visual Analytics, Hadoop, C3 Cloud Computing Concepts,,Tableau administration, MicroStrategy administration, ServiceNow, AWS, Azure, SAS AWS Cloud instance, Azure

Client: Union Bank of California, CA Jan’2009 to May’2014

Title: SAS BI Administrator

Responsibilities:

Strong experience in SAS BI Administration Linux servers and windows 2003 server configuration Settings for SAS Application servers (Logical workspace server, Logical stored process server, Logical OLAP Server, Logical SAS/Connect Server, Object Spawner, Connect Spawner).

Build the New SAS 9.3 Server environment SAS Development /Test Servers Configuration and SAS 9.3 products deployment on Chandler Linux servers

Setup SAS 9.3 - Metadata Server client installation, SAS 9.3 - Metadata Server Configuration

SAS 9.3 - SAS Application Server installation, SAS 9.3 - SAS Application Server Configuration, SAS 9.3- Middle tier Server client installation and SAS 9. 3- Middle tier Server configuration on current client server environment.

Configure the port number and root paths for SASDev Development Application server support files OMRConfig.xml, sasv9.cfg, SAS.sh, Metadata Server.sh, Object Spawner.sh, OLAPServer.sh, ConnectServer.sh, sasconnect.sh

Using SAS Management console user manager plug-in to Adding new users, Groups, ACT’s (access control templates) assign users to Group, assign ACTs to Users, apply the ACTs to application server and manage the Authorization permissions for users and Groups.

Support Migration on SAS 9.1 to SAS 9.2 and SAS 9.2 to SAS 9.3 Linux SAS Server environments.

Daily follow up monitoring checking status of production server, development servers (Metadata Server, Object Spawner, Connect Server, APServer, OLAPServer) whether the services are running or not, if any problem with servers fix the server problems and restart the servers.

Backing Up and Restoring the SAS Metadata Server, using the %OMABAKUP Macro to Perform Backups and Restores from Linux development server, Linux production server and windows 2003 Production server.

Users to support manage repositories from SAS Enterprise Guide Explorer, assign correct machine name, port number, user, password for connection Foundation of SAS Application servers and support for connecting metadata profiles thru using various SAS User’s applications (SAS Data Integration Studio, SAS OLAP Cube Studio, SAS Information Map Studio) and other web Portals (SAS Stored Process Web Application, SAS Web report Studio, SAS Information Delivery Portal, SAS OLAP View for JAVA).

Write Linux wrapper script and testing Wrapper script on sas development server for automatically start, stop (metadata server, ObjectSpawner, Connect Server, APServer, OLAPServer) check the server services are running from development server.

Users to Support SAS Software Installation, applied licensed SID file for renew the expired SAS software components from development and production servers, applying new release hot fixes for SAS software components and SAS Users applications.

Exchange of data between Spectrum Scale clusters via object storage in the cloud

Provides administration services Spectrum Scale GUI, Performance Monitoring .

Spectrum Scale monitoring all of our storage in current environment.

Support User requests SAS Oracle, SQL libraries access thru SAS Enterprise guide application and configures the SAS Oracle, SQl servers & Libraries on SAS SMC and import the SAS Oracle, SQL data into SAS Oracle, SAS SQl Libraries.

IBM General Parallel File System (IBM GPFS) is a file system used to distribute and manage data across multiple servers.

GPFS allows you to share data between separate clusters within a location or across a WAN. Using GPFS file systems can improve system performance in a number of ways.

Daily follow-up with user log files monitoring, better maintenance of server enhancement

Checking server’s services status monitoring, development Linux server, Production Linux server and windows 2003 production server being backed up daily.

Using SAS management console to support user’s requests, using server manager plug-in to create various type servers (ODBC Server, OLEDB Server, ORACLE Server, Teradata Server), database schemas, Data Library Manager plug-in create sas data base libraries and import users request sas datasets from one server to users request locations.

Environment: SAS 9.1.3, SAS 9.2,SAS9.3,SAS 9.4,SAS Management Console 9.1&9.2&9.3& SAS9.4, SAS Enterprise Guide 4.0 & 4.3,5.1 SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio 3.1 & 4.2, SAS Information Delivery Portal, SAS OLAP CUBE Studio 9.1 & 9.2, SAS Web OLAP Viewer For Java, SAS Enterprise BI Server, Teradata, Oracle 8i, SQL, HTML, XML, JavaScript, SAS Enterprise Miner 5.3, SAS Forecast Studio, Linux RHEL 4, Microsoft(R) Windows(R) Server 2003, Enterprise Edition,SAS Data Integration Studio 3.4 & 4.2, Metadata Server, ObjectSpawner, Connect Server, APServer, OLAPServer, IBM Web Sphere Application Server(MQ(AIX)), SAS Remote Services, SAS Xythos, SAS OpRisk VaR 4.1, SAS grid manager 9.2/ 9.3, SAS 9.4 Visual Analytics, GPFS file system, IBM Spectrum Scale

Client: IBM (GENERAL MOTORS), MI July’2008 to Dec’2008

Role: SAS BI Administrator

Responsibilities:

Daily follow up monitoring checking status of production, development servers (metadata server, ObjectSpawner Connect Server, APServer, OLAPServer) services and log files & SAS users Groups Linux server space

Daily monitoring of user object spawner log files and all servers log files.

Creating New users, Groups and Acts Using the SAS Management console and User administration - access privileges for users and groups on servers

Support the SAS software installation - applying SID files to renew the license of the SAS application components from the product vendor.

Scripts for automating the startup and stop of the various servers.

Configuring and providing support for the metadata profile using SAS management console

Creating new Application Server from SAS Management console, configure the SAS workspace server, SAS stored process server, OLAP server, SAS/Connect server and run the services from SAS Linux development/production servers

Supporting user queries on using SAS DI tool for importing data into user space.

Remotely support with Users to show the using SAS Management console to create Oracle server, schema, Oracle Library and import SAS datasets from Oracle server to Oracle library.

Worked with the deployment of SAS Products and client solutions to be carried on with different versions of SAS.

Identify and troubleshoot issues with SAS Server including installation and configuration issues.

Environment: SAS 9.1.3, SAS Macros, Teradata, Oracle 8i, SQL, HTML, XML, JavaScript, SAS Management Console, SAS Enterprise Guide 4.0, SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio 3.1, SAS Information Delivery Portal, SAS OLAP CUBE Studio 9.1, SAS Web OLAP Viewer for Java, SAS Enterprise BI Server, Enterprise Miner, SAS Forecast Studio, IBM Web Sphere MQ(AIX), SAS/SPDS,

Client: DELL, Inc., Austin, TX. Sept’2007 to June’2008

Title: SAS BI Administrator

Responsibilities:

Strong experience with SAS BI Environment in workspace server, metadata server, defining new libraries and assigning permissions using SAS Management Console.

Using SAS Management Console create metadata profile connect metadata server and worked on various Plug-INS.

Configuration of SAS Application Server, Workspace server, Stored Process Server, Object Spawner and SAS Connect Server.

Create Groups, Users and set Permissions. (ReadMetadata, CheckInMetadata, Create, Administer, Write Metadata, Read, Write, Delete).

Creation of Access Control Templates and assign the privileges to various Users and Groups.

Configuration of ObjectSpawner.bat file, assign root paths to InstallObjectSpawner.bat, RemoveObjectSpawner.bat, StartObjectSpawner.bat file and run .bat files from command prompt.

Set the Stored Process Server and Workspace Server launch Commands.

Checking ObjectSpawner Trouble shooting log files.

Start SAS Services and Object Spawner from Computer Management.

Local Security policy User Rights Assigning.

Support of operating system, software, and patches.

Installation and support of SAS application software, patches, and SAS hot fixes.

Executing Daily ETL jobs for ETL monitoring,

Create Server, Schema, Library, and Import Tables.

Data allegro testing to find the performance of Data Allegro ODBC integrated with SAS. Also find out performance between Data Allegro and Teradata.

Involved in Data preparation, Data mining, summarization, exploration, multi-variate analysis Data sampling, Data partitioning, Merge, append tools, Univariate statistics and plots, bivariate statistics and plots, Batch, and interactive plots.

Production support and responsibility to interact with customers directly under the guidance of the manager.

Using SAS Enterprise Guide build advanced querying, calculating computed columns, using filter, sorting, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generates summarization SAS datasets.

Imported summarization SAS datasets from SAS Management Console to SAS Information Map Studio.

Using Information Map Studio to build information maps structures

View Information maps from Web Report Studio or Information delivery portal.

Using SAS Stored Process Web application to build Selection Screens and Dash Boards.

Olap Cube Studio to build Pivot tables.

Environment: SAS 9.1.3,SAS Macros, Teradata,Oracle 8i, SQL, HTML,XML,JavaScript,SAS Management Console, SAS Enterprise Guide 4.0, SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio 3.1, SAS Information Delivery Portal, SAS OLAP CUBE Studio 9.1, SAS Web OLAP Viewer For Java, SAS Enterprise BI Server, Enterprise Miner, SAS Forecast Studio, IBM Web Sphere MQ(AIX),SAS/SPDS, IBM/TSO/ISPF,MVS, JCL,SAS/ODS,SAS DI Studio, Cognos Reportnet 8.0,Cognos PowerPlay and Impromptu

Client: Highmark (Blue Cross Blue Shield), Sept’2006 to Aug’2007

Pittsburgh, PA

Title: SAS BI Administrator & SAS BI Application Developer (Team Lead)

Incumbent will assist Informatics staff in the conversion of the DXCG History data. This will include capturing addition data elements from High mark Corporate Data Warehouse and formatting data in the defined format on the mainframe. Once loaded on the mainframe the EDW staff will load the data to the Member Reporting Repository. The current structure of the Informatics history in SAS version 8 and version 9 datasets. The additional data elements are housed on the EDW tables on the Teradata Enterprise Data Warehouse. The incumbent will be required to use both versions of SAS and SQL to access the teradata tables. Transfer the reformatted data to our Production mainframe through FTP commands.

Responsibilities:

As a Team Lead handle all aspects of the configuration, development, and implementation of the clients SAS EBI environment.

Strong interpersonal and leadership skills including mentoring of project team members.

Using Html, JavaScript, and SAS Stored Process Web Application to design front end Web pages and build various Dynamic data access and Static Reports.

Involved in work with individuals of different backgrounds, abilities, and temperaments in a team-based development environment.

Involved in translate solution design into technical specification and modular program code, Strong Skills in SAS, and SQL program languages, Tuning and improving query performance.

Strong experience in using proc sql method to pull data from different data bases like Oracle, sql, Teradata.

Solid foundation in use of SAS macro, SAS/Connect, SAS/Access, SQL, Oracle, Teradata relational table structures and FTP interfaces between platforms and the UNIX environment.

Experience in converting programs from one version of SAS to another version

(Process of moving from SAS Version 8 to SAS Version 9).

Production support and provide solutions to end users.

Experiences using SAS Version 9 (especially the Business Intelligence Platform tools) SAS Enterprise Guide 4.0, SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio 3.1, SAS Information Delivery Portal, SAS OLAP CUBE Studio 9.1, SAS Web OLAP Viewer for Java, SAS Enterprise BI Server, Tomcat/ Apache.

Ability to mentor or transfer skills to others.

Environment: Base SAS, SAS 9.1.3, SAS Macros, Oracle 10g, SQL, HTML, JavaScript, Teradata, SAS Enterprise Guide 4.0, SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio 3.1, SAS Information Delivery Portal, SAS OLAP CUBE Studio 9.1, SAS Web OLAP Viewer for Java, SAS Enterprise BI Server, Tomcat/ Apache, IBM/TSO/ISPF JCL, SAS/AF, SAS/SCL, SAS/ODS,SAS DI Studio, COBOL

DB2

Client: Upromise Inc, Needham, MA March’2006 to Aug’2006

Title: SAS BI Administrator & SAS BI Application Programmer (Team Lead)

Upromise was created to help families save for college. By joining forces with some of America's leading companies, Upromise allows families to get back a percentage of their everyday spending into their Upromise accounts.

Upromise has built a simple way to help families learn more about their savings options, open investment accounts, and jumpstart their savings. The mission of Upromise is to make college more affordable for American families.

Migration Project:

This project is basically Migration Project, I migrated all reports from Hyperion Brio to SAS BI Applications using (SAS Enterprise Guide, SAS Information Map Studio, SAS Web Report Studio, SAS OLAP CUBE Studio, SAS Stored Processes Web Application, SAS Information Delivery Portal).

Responsibilities:

Reviewing business requirements for standard reporting

Using SAS Business Intelligence (BI) to drive the automation of standardized analytics

Generating SAS EG stored processes for product-specific analyses

Participating in the development of outcomes and process measures

Identifying opportunities to productize standard reports

Advanced Querying using SAS Enterprise Guide, calculating computed columns, using filter, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generates SAS datasets.

Imported SAS datasets from SAS Management Console to SAS Information Map Studio.

Using Information Map Studio Stores instructions on how to access and combine relational

Data tables, calculating new data items, created multiple pre-defined filters.

Build Quick Reports from Web Report Studio using Information maps, create filters, graphs, and customize reports.

Using SAS Stored Process Created Selection Screens and Dash Boards.

Builds Pivot tables from SAS Olap Cube Studio

Using application frames, SAS component language to build interfaces for end user applications perform activities such as data entry, data processing, and data analysis/reporting

All Reports Imported from web report studio, Stored Process, and Information Map to Information Delivery Portal.

Environment: SAS 9.1.3, Hyperion Brio, SAS/Connect, SAS Macros, SAS/Access, Oracle 8i, SQL, Sun Solaris, Windows NT, MS Office, HTML, XML, Teradata, SAS Enterprise Guide 4.0, SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio 3.1, SAS Information Delivery Portal, SAS OLAP CUBE Studio 9.1, SAS Web OLAP Viewer for Java, SAS Enterprise BI Server, SAS/AF, SAS/SCL, IBM/TSO/ISPF, MVS, JCL, SAS/ODS,

Cognos Reportnet 8.0, Cognos PowerPlay and Impromptu. COBOL, DB2

Client: BANK OF AMERICA, Providence, RI Sept’2005 to Feb’2006

Title: SAS programmer

CRU project

CRU is a database application that is currently hosted on a Teradata database. CRU gets data from several source systems. For some systems, the data is delivered to us on a UNIX platform. For other source systems, we need to pull the data (source databases are ORACLE, DB2, SYBASE, and SQL SERVER).

We currently use SAS as an ETL tool to massage the data into a format that can be loaded into Teradata.

Responsibilities:

Strong experience in various databases oracle, teradata and db2

Involved in documentation and power point representation

Production support and solving trouble shooting issues

Debugging and testing applications in development area

Using data mappings to create ETL flows within SAS to load that data into a new data warehouse.

ALL transformations performed on the data during the ETL process

Reverse engineering of the SAS code and determine business rules.

Field level analysis and field mapping.

Involved in query the Teradata database.

Environment: Base SAS, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ODS, SAS/IntrNet, SAS SHARE, SAS/Connect, SAS Macros, SAS/Access, Oracle 8i, SQL, (IBM AIX V5.2) and CVS and UNIX, Sun Solaris, Windows NT, MS Office, HTML, Teradata, SAS Data Integration Studio, SAS Enterprise Guide, SAS ETL Studio, SAS DI, Informatica, IBM/TSO/ISPF, MVS, JCL, COBOL, DB2

Client: GEICO, Chevy Chase, MD Sept’ 2004- Aug’2005

Migration Data Warehouse

Title: SAS Programmer

GEICO has a Legacy Data Warehouse(LDW) that is approximately 10 years old, LDW holds Claims, Actuarial, Marketing, Telecom, and Policy data, GEICO data wear house hardware is upgraded from Sun Solaris to IBM AIX with P650 RISC Servers and database up gradation from Informix to DB2 which is base for EDW (Enterprise data wear house).The GEICO Warehouse team is seeking to migrate the LDW data to the Migration Data Warehouse environment with minimal re-engineering of data structures and functionality. The only modifications that will be made are those that are required by the operating parameters of the new AIX/DB2 environment. GEICO is replacing the LDW using Portions of the data and functionality in the LDW are being re-engineered and moved to a new Enterprise Data Warehouse. The EDW provides significant improvements in functionality and data quality over the LDW. The remaining data and functionality will be moved to an interim Migration Data Warehouse (MDW). The Migration Data Warehouse Project uses non-standard hardware (Solaris servers and Informix) and external support services for the current LDW system. The Migration Project will use internal resources around GEICO standard equipment for the EDW environment (IBM AIX servers and DB2 databases).

Responsibilities:

Involved in migration of data from Informix on SunOS 5.8 to DB2 on AIX 5.3 and validation of mainframe jobs, UNIX jobs, SAS Reports, History data, other scripts, and programs from the Legacy Data Warehouse (LDW)

Involved in modify Legacy Data Warehouse SAS jobs to run on the MDW platform and execute SQL against the DB2.

Using Korn shell scripts execute SAS jobs that move data from Informix to SAS MDDBs or SAS datasets.

Responsible for migrating the korn shell scripts, which will perform the Extraction Translation and Loading of data.

Responsible for establishing the connection to data base in the new environment, optimizing the shell scripts according to the EDW requirement.

Rewriting the SQL quires with the new table structure.

Generate Multi-dimensional data databases (MDDBs) within SAS OLAP Server

Create flat file SAS datasets, generate reports that are posted on DirectNet where they are accessible by users SAS jobs are categorized as Production.

Production jobs are built by placing as SAS procedure within a Korn shell script that is then excuted via JCL and through CA-7 scheduler.

SAS jobs are typically written within SAS using Pass-Through SQL that is

Contact this candidate