SUMMARY

• 11+ years of consulting experience in SAS v 9.x/8.x/6.x and administration on Windows and UNIX platform in both Batch and Interactive mode.
• Extensive experience in SAS Administration,, Design of Windows SAS Servers, SAS Deployment Installation, Configuration and Server/Data Migration on robust Windows SAS Systems and Trouble - shooting of Server issues.
• Experience with Data Extraction, Transformation, and Loading (ETL) from disparate Data sources like Multiple Relational Databases like Oracle, SQL Server, and MS Access.
• Experience in SAS/EG, SAS/BI, SAS/ETS, SAS/ETL, SAS/OLAP, SAS/BASE, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS/ODS in Windows and UNIX environments
• Created and maintained an integrated environment using SAS Management Console across Multiple Platforms and also performed installation of SAS 9.1.3BISuite.
• Acquainted with the use of SAS Metadata Server, SAS Enterprise Business Intelligence, User security, OLAP and BI server Administration/Maintenance
• Experience in supporting data warehousing, migration, synchronization and federation initiatives using SAS Enterprise Data Integration Server.
• Used Web Report Studio for organizing and searching of reports.
• Acquainted with the source management tools and the deployment tools in increasing the proficiency and reducing the cost and time.
• Proficiency in writing scalable, maintainable, supportable, and well-documented code.
• Hands-on experience with generating reports, tables, listings, and graphs using various procedures like proc SQL, proc means, proc univariate, proc freq, proc datasets, proc format, proc compare, proc append, and proc connect.
• Successfully handled responsibilities for extracting internal/external data, data cleaning, and validation, developing statistical models, analysis, and report generation.
• Good analytical skills pertaining understanding a business domain coupled with excellent teamwork and communication skills.
• Excellent problem solving skills for delivering useful and compact solutions. Always keen and eager to face up to challenges by means of innovative ideas.

TECHNICAL SKILLS

Software: SAS/EG, SAS/BI, SAS/ETS, SAS/ETL, SAS/OLAP, Base SAS, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/Connect, SAS/SQL

Languages: SQL, PL/SQL, HTML

Databases: SQL Server, Oracle 8i, MS Access98/2000

Tools: MS Excel, MS Word, MS PowerPoint, MS Access

Packages: MS FrontPage, MS XML Editor

Operating systems: Windows 9x/NT/XP, UNIX,MVS TSO

SAS Procedures: Print, Transpose, Contents, Means, Chart, Plot, Tabulate, Univariate, Summary, Sort, Reg, SQL, Format with picture, Copy, freq, forms, upload, download, Printto, Datasets, Format

PROFESSIONAL EXPERIENCE

Confidential, Lambertville, NJ

Clinical SAS Programmer

Responsibilities:

• Provided support in the statistical programming for the generation and validation of summary tables and listings on clinical trial studies
• Responsible for the generation of key analysis datasets and extraction of the SAS datasets.
• Handled large transactional data bases in UNIX environment and performed SAS operations and generated reports after pulling data from the data source (VSAM).
• Provided support in the review and modifications of statistical analysis plan.
• Provided SAS technical support for statisticians and SAS programmers.
• Designed, coded, tested and debugged SAS programs to generate listings, Tables.
• Generated SAS macros as part of the standard programs and validation
• Developed SAS applications for data extracting and data transformation from multiple platforms.

Environment: SAS 8.1, Base SAS, SAS Macros, SAS STAT, SAS Access, and UNIX.

Confidential, Bridgeport, CT

SAS Administrator/Analyst

Responsibilities:

• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools such as SAS/Base, SAS/Macros, SAS/Graph, SAS/SQL, Teradata, SAS/Connect and SAS/Access
• Consulted with customer and systems personnel to determine type of information to be processed.
• Prepared charts, tables, and diagrams to assist in analyzing problems, utilizing various business and mathematical techniques.
• Installed both PC and UNIX versions of S-Plus and interactions between the two platforms.
• Planned projects, estimated project requirements, communicated well with customers at a level they understand and developed in-depth understanding of business areas where existing or modernized programs could provide solutions.
• Converted FOCUS queries into SAS language as a Pricing Analyst under the guidance of the concerned focus expert.
• Have got experience in Data Mining to translate goals such as profit and margin share targets.
• Generated all the Safety Tables & Plots for the whole Analysis.
• Provided maintenance support for online programs; technical documentation (program specification changes, test plan, test case preparation, test results).
• Managed deliverables against aggressive timelines.
• Responsible for installing activities to generate “Warranty Expense per Machine Report”, across Product Lines, using SAS, DATA NULL, SAS Macros, and SAS Procedures (FREQ, MEANS, SUMMARY) from multiple source files totaling 20 million observations.
• Provided GUI with SAS Enterprise Guide interface for the data access and the data manipulation associated with SAS mechanism.
• Modified DOS/VSE JCL procedures.

Environment: Base SAS 9.1.3,SAS Macros, SAS Integrated technologies, SAS GRAPH, SAS STAT, Windows NT, Sun Solaris UNIX, SHELL Scripts, Oracle Server, Windows 2000, SQL Server, Visio, Excel.

Confidential, Wilmington, DE

SAS Administrator

Responsibilities:

• Installed and configured SAS / related modules (Enterprise guide, PC SAS, Enterprise Miner, Risk Dimension and other modules), on all platforms. Performed necessary IT, UAT, IQ/OQ tests and validation to make sure systems are installed properly and compliant.
• Created new user accounts, monitored system quota usage, and other daily operations, i.e., Backup and restore system, files on scheduled times, perform version upgrade.
• Managed licenses, maintained software patch levels, tested & applied hot fixes.
• Actively monitored software usage on all platforms, keeping them at optimal level for user querying.
• Installed SAS Enterprise BI server to handle large volumes of business intelligence data.
• Supported projects with SASBI components throughout their lifecycle and also worked with Business/IT Stakeholders to design & maintain SAS BI solutions including, data acquisition, and data modeling.
• Acquainted with the installation and maintaining Metadata Server.
• Performed ETL tasks in extracting the data from databases using SAS procedures like SAS/SQL, SAS/Access and creation of datasets.
• Extensively ran SQL SAS against DB2 mainframes as part of the conversion from FOCUS to SAS and executed SAS jobs by batch processing pulling millions of records from the mainframe.
• Developed and enhanced all SAS programs for Business Intelligence (BI) Team in OLAP database environment.
• Experienced in budget cycle seeding, rolling forecasts and maintaining the workflow control using SAS Financial Management Data tier.
• Used SAS DDF (Demand-Driven Forecasting) to utilize Model repository with predefined models and also Event Modeling Console.
• Combined automation, analytics and workflow, using SAS DDF and generated unbiased and accurate consensus forecast on a relatively large-scale basis.
• Provided statistical programming support for Data Mangers and Statisticians, using SAS Base and Macro facilities, involving Data transformation (sort, merge) utilities, computational procedures, options, functions and formats, used within Macros, PROC steps, DATA steps and ODS statements.
• Data Gathering- Extracted data from various data sources (primarily OneSource) w/minimal impact to source system and developed Data Marts/Warehouse within SAS as needed.
• Scheduled and informed user communities of downtime, upgrade, maintenance, to achieve best performance and minimum interruptions to production.
• Provided support to resolve user account lockup, quota limit and directory access control issues.
• Trained users with installation of SAS enterprise guide.
• Administered SAS Server, SAS Enterprise Guide, and SAS Enterprise Miner, SAS/Connect, SAS/ETS, SAS/IML, and other components.

Environment: SAS metadata server, SAS Management Console, Base SAS 9.1.3, SAS Macros.

Confidential, Columbia, MO

SAS Administrator

Responsibilities:

• Installed and configured SAS / related modules (Enterprise guide, PC SAS, Enterprise Miner, Risk Dimension and other modules), on all platforms.
• Extensively used applications such as SQL Query Analyzer and TOAD to browse through database views and perform testing of datasets.
• Created new user accounts, monitored system quota usage, and other daily operations, i.e., Backup and restore system, files on scheduled times, perform version upgrade.
• Providing SAS admin support, managed SAS tools like SAS BI, SAS Enterprise Guide, SAS Forecast Studio.
• Performed automated statistical model selection and optimization using SAS DDF (Demand-Driven Forecasting).
• Also enhanced accuracy with comprehensive gap analysis and reporting using SAS DDF.
• Extensively involved in SAS Installation, Configuration and Security.
• Designed and created SAS Reports and utilized SAS Web Report Services.
• Managed licenses, maintained software patch levels, tested& applied hot fixes.
• Actively monitored software usage on all platforms, keeping them at optimal level for user querying.
• Moved data sets across platforms from Mainframes to UNIX and Vice Versa along with Shell Scripting in UNIX.
• Overall system infrastructure which is a key to success in this position was developed.
• Scheduled and informed user communities of downtime, upgrade, maintenance, to achieve best performance and minimum interruptions to production.
• Acted as Second tier technical support to resolve any SAS related issues in agreed time frame.
• This involved software, hardware and setup diagnostics, troubleshooting, problem solving and resolution.
• Provided product know-how / training to users on new features & functionality of various SAS products.
• Trained users with installation of SAS enterprise guide.
• Administered SAS Server, SAS Enterprise Guide, and SAS Enterprise Miner, SAS/Connect, SAS/ETL, SAS/IML, and other components.
• Installed the SASEnterprise BI on UNIX platforms on multi server.
• Managed the SAS BI environment and provided support to resolve user account lockup, quota limit, and file and directory access control issues.

Environment: SAS 8.X/9.x, SAS/Access, SAS/PC, SAS/Connect, SA/ETL, SAS/Macro, SAS/ODS, SAS/Stat, SAS/Graph, SAS/SQL, Mainframes, People Soft, DB2, Oracle, HP UNIX, PL/SQL

Confidential, Elkridge, MD

SAS BI Architect

Responsibilities:

• Designed and developed new software programs, using the SAS BI suite, to demonstrate the use of SAS.
• Involved in configuration, development and design using the SAS enterprise BI suite of tools.
• Used SAS BI to deliver existing analytical content to the desk top and was responsible for updating the product configuration, developing ETL processes where necessary.
• Designed and implemented OLAP cubes, metadata repositories and web presentation screens using the SAS BI tool set.
• Programming - Participated in Implementation, Design, development and unit-testing of products utilizing the SAS Enterprise BI toolset, including all of the subordinate server products such as BI Server, Table Server, Metadata Server.
• Extensive experience in using the SAS BI toolset to deliver analytics to the desktop.
• Built OLAP cubes in SAS OLAP Cube Studio and in coordination with SAS Information Map Studio, created information maps of the data available from the data sources which are SAS datasets.
• Interfaced the maps and cubes in the SAS Web Report Studio and designed a drill-up, drill-down, roll-up and drill-through mechanisms of the data as in Management reports and built a hierarchy in the cubes with Carrier, Region, State and TIN Count parameters related to the PQRI (Physician Quality Reporting Initiative)Claims.
• Designed web reports in Web Report Studio of the BI suite to determine the eligibility of the claims by Physicians based on the measures data and incentive verification.
• Analyzed the desktop applications like SAS Enterprise Guide to convert the data onto an Excel Sheet and facilitated easy access to users and third parties to realize the full business analytic power of SAS.
• Developed, designed and delivered a web presentation using SAS Information Delivery Portal to optimize interaction, interfacing among users to arrive at the data faster with the aid of BI Dashboards (also a part of SAS Enterprise Suite of tools).
• Coordinated all BI components (Management Console, Information Map Studio, Web Report Studio, Portal (Info Delivery portal) and OLAP Cube studio on an equal basis and also developed reports in Desktop applications like SAS EG and Add-in for Microsoft office for number crunching purposes.
• Delivered a high utility quotient on SAS BI applications and assigned role-based access and authentications in Management Console which is also termed BI manager.
• Provided security and access to metadata server to the developers to implement BI applications using Data Libraries, Map service manager to create Geographic interactive maps and educated users on the business value of SAS BI to the overall functionality of the organization.
• Provided adequate data masking while demonstrating to the business users for security and integrity.
• Provided permissions and privileges to developers and SAS users to access the maps and stored processes in the Information Delivery Portal for better understanding of data flow graphically.
• Replicated physical data from spread sheets and Excel sheets onto a Geographic map to enhance dynamic data manipulation and extraction.
• Enhanced business capabilities and utilities of the organization by interpolating functional and analytical content in the Information Delivery Portal.
• Also provided greater autonomy to technical as well as business users within the organization regarding data navigation.
• Provided prototype for CMS to adequately optimize the utilities and advantages of SAS BI to realize the Claim and Eligibility using PQRI and also generated source code for BI purposes.

Environment: Base SAS 9.2,Windows,SAS/CONNECT,SAS/PC,UNIX,SAS Management Console, SAS EBI server, Solaris 64,SAS Enterprise Guide, SAS/SHARE, Add-in for Microsoft, JVM, Apache Tomcat, BEA Weblogic server, Web Report Studio 4.2,OLAP Cube Studio 4.2,Information Map Studio 4.2,Information Delivery Portal 4.2,SPARC

Confidential, New York, NY

SAS Administrator

Responsibilities:

• Serves as a dedicated admin for SAS server environment
• Point of contact for issues occurring with the SAS application or the servers running SAS.
• Escalation point with SAS, coordinates and ensures resolution of open issues
• Collaborates with IBM support and Data Management on issue resolution
• Managed disk space/usage and recommends optimum storage options
• Actively monitored space usage, cleaned up application drives and alerted users exceeding quota limit on a server
• Erased unused, aged files on all servers by consulting with the user community as part of space optimization
• Freed up more than 12 TBdisk space on all production servers by identifying legacy folders and files in the server and relocating them to the Archive Repository.
• Installed and configured three SAS 9.2 licences on Windows 2003 servers for MSG
• Verified, tested, validated and signed off on the SAS functionality and server readiness post-installation on all three servers.
• Managed license, updated software patches, tested and applied hot fixes.
• Identified SAS modules least utilized by the group according to the usage Frequency,
• Criticality and the impact of the Product.
• Collaborated with SAS to have such modules relinquished and licences canceled and identified cost avoidance of ~ $ 500,000 in overall license renewal costs for 2011.
• Provided product know-how / training to users on new features & functionality of various SAS products.
• Redesigned the server architecture to optimize the components required in the infrastructure.
• Solution provided was the optimized one to reduce required server licenses which showed a savings of $2 million as a bottom-line.
• Successfully implemented two server upgrades and LUN migrations by coordinating with IBM and users to test, verify and validate the SAS environment post migration.
• Actively maintained a catalog of issue tickets, incidents, résolution and the corresponding root causes concerning all three SAS servers.
• Updated and furnished the System Documentation consisting of all essential System parameters such as hardware configuration, memory, disk volume and products available on all three production SAS servers at MSG.
• Point of contact for addition of new users to the SAS environnent
• Reviewed SAS system usage and recommended changes as needed
• Ongoing performance tuning and troubleshooting of the servers
• Coordinated with IBM and Intel on all on-going SAS/Server issues regarding immediate resolution, impact mitigation and root causes of the incidents.
• Communicated, consulted and announced to users from all groups at USCO on critical issues such as server migration, upgrades, monthly windows patching, maintenance and MPLS upgrade for improved network performance.
• In coordination with Server Host, IBM and associated support groups, every year Confidential performs a Disaster Recovery Exercise on a simulated SAS/Server environment including several applications, to perform Risk Assessment &implement Risk Mitigation/Management techniques to be prepared in event of an actual disaster. .
• Successfully oversaw efforts leading up to and execution of Confidential 's Disaster Recovery exercises for last three years.
• Technical expertise and professional experience in the MSG SAS space was pivotal in being able to restore Confidential 's critical SAS environment.
• The input and actions was captured by IBM teams and then reflected in Confidential 's DR plan to exercise in the next DR test or in event of a real disaster.
• Troubleshot and mitigated subsequent performance issues that might impact productivity.Eg: Key: Key stroke lag and indefinite server hanging due to sluggish network.

Confidential

Sr. R&D Data Analyst /SAS Programmer

Responsibilities:

• Provided constant support for graphics produced using S- Plus GUI menu.
• Assisted with both PC and UNIX versions of S-Plus and interactions between the two platforms.
• Debugged and analyzed the interface between S-Plus and SAS, including running S-Plus graphics from within a validated study reporting environment.
• Involved in the creation of user testing documentation.
• Performed necessary IT, UAT, IQ/OQ tests and validation to make sure systems are installed properly and compliant.
• Facilitated new drug & device release process from IND submission to FDA approval as part of Drug development process, which includes Clinical Trials (Phases I-III), preparation of IND, NDA, safety reviews, adverse event report reviews, risk factor, integrated safety and efficacy summary (ISS & ISE) for FDA submission.
• Validated, documented and tested component programs in an efficient manner for inclusion in integrated reports.
• Participated in educating other internal support staff.
• Extracted data from DB2 database and People soft for comparison in SAS.
• Identified and defined the data requirements necessary to support application.
• Involved in mapping the applications, ensuring data quality, data organization, metadata, and data profiling.
• Interacted with System Integration & User Acceptance Testers to resolve validation issues.
• Documented the design and generated informative reports used during knowledge transfer.

Environment: SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/MACRO, SAS/ODS, SAS/SQL, HTML, S-Plus (Enterprise Developer Version 7.0.6 and UNIX (Solaris Version 8), Autosys, DB2, People soft, Oracle, TOAD, DB2 Command center, Rational Clear Case and Clear Quest.