SUMMARY9 years of IT experience.

• 1 years of Experience as Sr. SAS Administrator in Horizon Blue Cross Blue Shield New Jersey
• 3 years of Experience as Technical Specialist/SAS admin in Walt Disney World
• 3 years of experience as Sr. Programmer Analyst/SAS admin in Virginia Department of Education
• 1 year of experience as Software Engineer in Accenture
• 1year of experience as Software Engineer in Satyam Computer Services

TECHNICAL SUMMARY

• 7 Years SAS 9.1EBI platformadministrations OLAP cube, Information Map Studio, AMO,
• LSF scheduler, EG, Management Console, Information Portals, Web report Studio, SAS Forecast
• Server and Enterprise miner ,Oracle, UNIX-AIX, DB2
• 3 Years Teradata. SAS 9.1.3 EBI tools OLAP cube, Information Map Studio, AMO, LSF scheduler, EG,
• Management Console, Information Portals, Web report Studio, SAS Forecast server and
• Enterprise miner ,, Java Frameworks, JSP, JDBC, Struts, Servlets, XML, JavaScript, JSF.
• 2 Year SAS 9.2/9.3EBI platform Administrations Enterprise Guide 4.3/5.1, Management console 9.2,
• AMO 4.3, LSF scheduler, 6.1, Data integration studio ETL , Dashboard Portals, Web report Studio, Enterprise miner and stored process server

CAREER PROFILE

Confidential

SAS 9.3 EBI Upgrade SAS 9.2 Support

The objective of the project is to upgrade the current SAS 9.2 EBI platform to SAS 9.3 EBI Platform and support the Business users.

Roles Responsibility:

• Manage the users roles and responsibility in the Management console-User management
• Installed the SAS software in the user's machine and configure their profiles.
• Installed and supported Analytical platform, Enterprise miner in the Web tier
• Created User group and roles in the management console.
• Deployed and scheduled the SAS jobs in the LSF scheduler and monitor the batch jobs.
• Configured SAS portals to share the reports with in a group of users.
• Installed and Managed the SAS PC file server in the windows environment
• Implement hot fix and other day-to-day SAS BI administration tasks
• Created UNIX script to monitor SAS servers memory and process and send alerts when it reach 90 threshold
• Installed Application Performance Monitoring APM in our Environment for usage monitoring.
• Used X-windows for the installation of SAS on servers.
• Worked with UNIX administrators to upgrade AIX 5.3 to 6.1
• Worked with Business users to optimize their programs and jobs.
• Followed the best practice guideline to improve the performance of SAS server.
• Implemented a single sign-on for the SAS users to allow Active directory Authentication.
• Configured PAM to allow multiple authentication for SAS users
• Configured samba- Winbind with PAM for Active directory Authentication.
• Install SAS Web applications and supported in the Websphere 6.1 and Websphere 7
• Manage the UNIX AIX server memory and process monitoring.
• Configure SAS data libraries and registered Meta-data for tables.
• Configured database connection to databases like DB2, Oracle, SQl server, Sybase and Teradata.
• Created Authentication Domain for the Database servers.
• Fine-tuned the SQL queries for optimum performance for users.
• Re-installed and supported all SAS client tools in the Windows 7 environment during windows 7 migration from Windows XP.
• Provide 24x7 support

Environment: Windows XP, Windows 7, UNIX-AIX 5.3/AIX 6.1, SAS 9.2/SAS 9.3 EBI tools OLAP cube, Information Map Studio, AMO, LSF scheduler, Enterprise guide 4.3/5.1, Management Console, Data Integration Studio, Personal Login manager, Enterprise miner, Work flow Manager, Dashboard, Web report Studio and Stored process , Exceed , Flow manager. Websphere 6.1 and 7

Confidential

SAS 9.2 EBI Upgrade Support

The objective of the project is to upgrade the current SAS 9.1.3 EBI platform to SAS 9.2 EBI Platform. We need upgrade the Forecast and Enterprise Miner in the Analytics Platform. Also, we need support the end users for their issues and requirements.

Roles Responsibility:

• Installation, upgrade, migration and configuration of SAS EBI and their related components
• Such as SAS metadata, libraries, Web portals, OLAP cubes and SAS/AMO
• Maintenance, technical support and troubleshooting of SAS EBI environments.
• Perform performance tuning and capacity management
• Implement hot fix and other day-to-day SAS BI administration tasks
• Work with IT and business users to resolve support and technical issues
• Provide support to the business community.
• Contribute to coordination and planning of SAS BI related activities
• Write Unix Shell script for batch processing and other hot-fixes.
• Maintain the SAS performance in the UNIX-AIX servers.
• Provide 24x7 support

Environment: Windows XP, UNIX-AIX, SAS 9.1 EBI tools OLAP cube, Information Map Studio, AMO, LSF scheduler, EG, Management Console, Information Portals, Web report Studio, SAS Forecast server and Enterprise miner , SAS 9.2 EBI tools OLAP cube, Information Map Studio, AMO, LSF scheduler, EG, Management Console, Information Portals, Web report Studio, SAS Forecast server and Enterprise miner

• Basic Merchandise Placement Analysis Tool BMPAT
• The primary objective of Basic Merchandise Placement BMP is to optimize the placement of items within store locations to maximize revenue. Basic Merchandise Placement consists of several modules including normalization and network optimization, with user interfaces, and reporting
• Food and Beverage Revenue Management FBRMS
• The Food Beverage Revenue Management System F B RMS project will deliver an application to support revenue management of Disney's table service restaurants the project team has core team members from WDW Information Technology, Revenue Management Decision Science and Support, and Food Beverage Revenue Management. This is custom build Application integrating Java and SAS.

Roles Responsibility

• Created high level design, technical design documents,
• Build the Application in RAD IDE
• Wrote Junit test for unit test, Integration test and functional test.
• Created Ant script for build and deployment.
• Deployed the application in Development and QA environment using WAS console.
• Extracted data from Teradata, oracle SQL server to SAS.
• Cleanse the data for the SAS data modeling.
• Export the data to different format
• Generated Report in various formats.
• Created stored process and MACROs in SAS.
• Created jobs in DI studio for ETL process.
• Created Custom transformations in SAS-DI studio.
• Extensively used EG for writing SAS codes and administration purposes.
• Created UNIX scripts to run the SAS batch jobs.
• Ran the SAS batch jobs in UNIX andscheduled routine jobs in LSF scheduler and Maestro.

Environment: Windows XP, UNIX-AIX, SAS 9.1 EBI tools, SAS 9.2 EBI tools, RAD, Clear case, Junit, Websphere 6.1,Websphere 7.0.

Confidential

Data submission Automation.

The Crash Incident Tracking System

• Any crashes or incidents involving school buses, pupils, and personnel who ride school or activity buses shall be sent to Department of Education by superintendent or designee at least once a month.
• Pupil Transportation
• School divisions who provide transportation to students must complete the annual transportation report in order to receive transportation funding through Basic Aid.
• ESL Data Reporting System
• Language Instruction for Limited English Proficient LEP and Immigrant Students requires school divisions to report annually the number or percentage of LEP students making progress in learning English as well as the number or percentage of LEP students attaining full English proficiency.
• Gifted Data Submission System
• About student membership, teachers, and services provided to identify gifted students, grades K-12
• Common Core of Data CCD data Submission.
• The Common Core of Data CCD is the Department of Education's primary database on public elementary and secondary education in the United States. CCD is a comprehensive, annual, national statistical database of all public elementary and secondary schools and school districts, which contains data that are designed to be comparable across all states.
• Discipline Crime Violencereporting system.
• The DCV Report consists of data submitted on incidents of discipline, crime, and violence for the 365-day period starting with the first day of the previous school year. All incidents occurring on school grounds 365 days a year, 24 hours a day, and 7 days a week must be reported.

Roles Responsibilities

• Installation, configuration of SAS 9.1.3 EBI and their related components.
• Apply hot fix and maintain day to day maintenance.
• Prepared new Datasets from raw data files using INFILE and PROC IMPORT.
• Used Dynamic Data Exchange DDE feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
• Maintenance of large data sets More than million records , combining data from various sources in various formats to create SAS data and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements.
• Created complex and reusable MACROS and extensively used existing MACROS and developed SAS Programs for Data Cleaning, Validation, Analysis
• Generation reports in various output format using SAS/ODS.
• Extracting data from ORACLE database using SAS/ACCESS, SAS/SQL procedures and created data sets for Analysis using SAS/STAT procedures.
• Created materialized view for reporting in oracle database using TOAD.
• Prepared graphs and Report using the modified data for business analysis with various functionalities like drill down, roll-up using SAS/GRAPH and SAS/IntrNet.
• Generate Web-based reports using SAS/ODS and SAS/IntrNet.
• Run the SAS jobs in the UNIX environment.
• Skills in all aspects of the SDLC including contact with business teams on application issues
• Developed Internet Web Application using J2EE architecture, worked extensively on STRUTS framework to design the user interfaces, used JSP tag libraries to define custom tags and JDBC for database connectivity.
• Designed and developed a reporting framework using iText and Jfree to generate PDF, CSV, HTML and Excel reports.
• Designed Jfree reports in Pentaho.
• Used CoreFTP to FTP the oracle reports to OC4J.
• Involved in writing complex SQL and stored procedures and triggers for ORACLE database using TOAD.
• Involved in Unit testing, Integration testing and actively involved in Enhancements, Bug tracking with Test Director, Bug fixes in beta release of this application.
• Used CVS tool for version controlling
• Used JDeveloper 10.1, Eclipse 2.1 IDE to develop the applications

Environment: Windows XP, UNIX, SAS 9.1, Oracle 10g, Oracle Application Server 10.1.3.1, Java, JSP, Servlets, Struts 1.2.4, AJAX, JDBC, DHTML, CSS, JavaScript, AJAX, XML, iText, SQL, TOAD 8.6, PL/SQL.

Confidential

FDB receives billing data to calculate and report the earnings. Earnings are calculated based on current month billing plus the previous month's accruals. An estimate of unbilled toll data based on the previous month's history is also included.

Responsibilities: Requirements Analysis, Requirements Specification Documentation, Design coding, Functional Testing, Documentation Review, Implementation Support

Environment: MVS OS/390, Windows 2K, SAS/BASE, SAS/MACRO, SAS/STAT, SAS/ACCESS, SAS/CONNECT, COBOL, JCL, VSAM, Xpeditor, QMF, File Aid, Panvalet, Comparex, DB2.

Confidential

Providing the support, Data management, Operating TCCC in Live Environment, Tracking the problems through Vantiveu and clarify, live implementation of Release. Various reports are generated and updated, which are helpful for business purposes and management. Ensuring successful completion of criticalproblems.

Environment: MVS OS/390, Windows 2K, COBOL, JCL, VSAM, Easytrieve, CA7, Vantive, File Aid, Endevor, DB2, FOCUS.

Responsibilities:

Analysis, Support and minor enhancement