SUMMARY

• 11 years of extensive IT experience in software industry including working on various products on wide range of configurations on different platforms.
• Worked on Advertising, Retail, Pharmacy, Mortgage, Banking and Finance domains.
• Expirence in Data analysis and Data modeling for huge databases
• Expertise in SAS 9.4/9.3/9.2/9.1/ with expirence in Base SAS, Macro SAS, SAS/ACCESS, SAS Enterprise Miner,SAS Visual Analytics, SAS Forecasting Server,Windows SAS, SAS/Intr, SAS Management Console,SAS Enterprise Guide, SQL processing, Futrix, SQL, Unix
• Expirencing in administering sas prducts Enterprise Miner, Forecasting server, Visual analytics server
• Experience in providing statistical support for clinical studies, includingdesign of studies,selection of appropriate statistical methodologies and tests,sample size and power calculations, randomization,statistical analyses, and interpretation of results
• Experience in building complex SAS Data sets using various computational techniques
• Experience in building complex Reports using different Procedures
• Worked on calculating basic statistics
• Handling complex data formats involving different RDBMS
• Expertise in building SQL queries for data retrival
• Expirence in Business Objects Xi R2/R3
• Building Universes and Reports in Business Objects
• Have experience working with databases Oracle, SQL Server 2000, IBM DB2 and MS - Access.
• Extensive experience of Application Study, Systems Analysis, Design, Development, end-user requirements, business data requirements.
• Solid analytical, problem-solving and excellent communication skills

TECHNICAL SKILLS

OLAP and Reporting Tools: SAS 9.2/9.1/8, MSAS, Futrix,IQ3, Businesss Objects, Webi & Desktop Intelligence

RDBMS: Oracle, MS SQL Server 2000, IBM DB2, MS Access.

Programming Languages: C, C++, JAVA, SQL

Other Tools and Utilities: Adobe Works, MS-Office Suite. Autosys, Control -m

Operating Systems: WIN XP/2000/NT, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Atlanta,GA

Sr SAS Engineer

Responsibilities:

• Installaton and configuration of various SAS Business Intelligence platform products including Enterprise Miner, Forecasting Server and Visual analytics in Linux environment on 3 tier architecture
• Planning and migration of SAS 9.2 on solaries to SAS 9.3 linux which involves migration of different products like SAS/Access, SAS Internet and Spi server setup
• Installing PC SAS on windows XP/7 machines and renewing of license, adding components like access to Natezza and other data bases
• Administring SAS servers across multiple platforms.Using SAS Management Console and SAS Environment manager to check the health of the system, administer server and enforce security on the systems
• Creating different authentication domains to provides access to third party databases and registering tables in the SAS meta by creating data libraries for various functional domains
• Worked on SAS LASR analytical server to upload the data to memory and administer the process
• User maintanance and authentication on different SAS products which involves resolving login and access issues. Setting up groups and SAS folders on Managemet console, providing access and enfore security
• Setting up Server back ups using the BRT tools on SAS9.4. And enabling email alerts
• Worked closely with SAS tech support team in solving problems with server configuration changes and performace improving
• Worked closely with Unix team to set up the environment for SAS on linxus X64 machines which includes setting up users, authenticating, scheduling jobs and resolving storage issues
• Resolving the production issues pertaing to daily jobs proscssing of weblogs to generate site statistics and Dealer reporting
• Worked in development of etl process to create various SAS datasets relating to dealer activity and generating reports using various SAS procedures
• Providing end user support by resolving the tickets raised for different issues on SAS systems
• Worked on unix commands for file manupilation, directory manupilation, changing environment settings, process control, system security etc.
• Created ksh scripts to perform various operation on files
• Conducted end user training for basic and advanced reporting skills

Environment: SAS 9.4/9.39.2, MSAS, SAS Enterprise Miner, Forcasting server,Visual analytics,SAS Intr,SAs/Access,Management Console, Enterprise Guide, Unix, Oracle, SQL

Confidential, Atlanta GA

Sr.SAS Analyst/ Developer

Responsibilities:

• Provided SAS Programming and analysis support for phase III clinical trials
• Co-worked with Statisticians as a primary SAS programmer to analyze initial data sets and create tables, listings and figures (TLFs) for clinical trials.
• Created tables, graph to generate clinical study reports for the collected requirement from the statisticians referring to the Statistical Analysis Plan (SAP).
• Developing the SAS programs for listings & tables for data review & presentation including adhoc reports, CRTs as per CDISC
• Extracted data from ORACLE database and involved in cleaning the data (data cleansing) using various edit check techniques.
• Used procedures like PROC TRANSPOSE, PROC SORT, etc in Data transformation and Manipulation processes.
• Extensively used Proc SQL, Proc Transpose, Proc Format, Proc Means, Proc Univariate, Proc Freq, Proc Printto and Proc Compare for checking the assumptions and conducting Statistical Analysis.
• SQL Processing using both SAS/ACCESS Libname statement and Pass-Through facility
• Produced Ad hoc reports of various kinds like Listings, Tables, and Figures (TLGs/TLFs) using Proc Report, Proc Tabulate, Data Null technique, Proc Gplot etc.
• Developing the Macros at various instances for automating listings and graphing of clinical data for analysis
• Used SAS ODS to report outputs in different formats like RTF, PDF, and HTML
• Validated analysis data sets and SAS outputs with other programmers’ outputs and mockups in SAP using PROC COMPARE, PROC CONTENTS, and PROC FREQ. Created formats for the coded data and used PROC SQL for data validation.
• SAS macros were successfully used to create new programs and modified existing SAS programs to make them portable as well as for consistency of results.
• Documented, summarized and recorded data as per standard operating procedures (SOPs) and FDA regulations.
• Majorly worked with the data management team and was involved in handling documentation and submission processes

Environment: SAS 9.2/9.1/8, MSAS, Futrix, IQ3, Enterprise Guide, Web Report Studio, Business Objects Xi, Deski/Web Inteligence, Unix, Oracle 10g, SQL, Autosys

Confidential, Deerfield, IL

Sr. SAS programmer

Responsibilities:

• Building permanent SAS Data sets involving different forms of data.
• Used different SAS techniques including subsetting, conditions, formatting etc
• Worked on various SAS procedures to achieve the required functionality
• Support and Maintainance of SAS applications in Production Environment .
• Resolving critical Production tickets before SLA breach.
• Handling error and performance issues.
• Combining Data sets vertically and horizontally to to get the required functionality
• Used various system options and data set options to get the required format and functionality
• Created permanent reusable Formats using Value, Picture statements which can be used in different programs
• Implementing complex logic using SAS Macros
• Connected to remote Unix box to download datasets using SAS Connect
• Created complex SAS reports involving summary tabulations using different Procedure
• Created Autocall libraries to place all the user defined macros and build autocall macros by specifying the required system options
• Build stored compiled macros to be stored in catalog by specifying the required system options
• Modifying SAS datasets and Tracking the changes made to datasets using Audit trails
• Imposing General Integrity and referential Integrity constraints on datasets
• Used Enterprise guide to organize the data, tasks, and results involved in performing a statistical analysis, through the creation and maintenance of projects
• Used different sql features including sub queries, correlated subqueries, inline views etc.
• Worked on unix commands for file manupilation, directory manupilation, changing environment settings, process control, system security etc.
• Created ksh scripts to perform various operation on files
• Conducted end user training for basic and advanced reporting skills
• Creation of Universe Objects as per the Users requirements
• Migrated Universes and Objects from BO 5.1 to BO Xi versions using Import wizard
• Converting BO Xi Deski Reports to Webi reports using RCT
• Created complex Deski and Webi reports involving different features.

Environment: SAS 9.2/9.1/8, MSAS, Futrix, IQ3, Business Objects Xi, Deski/Web Inteligence, Unix, Oracle 10g, SQL, Control -m

Confidential, Irving, TX

SAS Programmer

Responsibilities:

• Gathering User requirements and designing technical and functional specifications.
• Analysing the risks involved in loans by pattern matching
• Development and testing of complex Reports
• Implementing complex logic using SAS Macros
• Resolving Scope resolution issues pertaining to Macro variables
• Used Macro Quoting functions to mask Macro variables
• Handled errors resolution using various Macro System Options
• Created AutoCall and Stored Compiled reuse macros libraries
• Used efficient Sort strategies depending on the available resources
• Creating Random Samples from large datasets to reduce processing time while testing
• Used Array’s for processing groups of data
• Used Hash objects as lookup tables to match data
• Worked on various SAS procedures to achieve the required functionality
• Combining Data sets vertically and horizontally to to get the required functionality
• Used various system options and data set options to get the required format and functionality
• Created permanent reusable Formats using Value, Picture statements which can be used in different programs
• Handled Memory usage and Data storage issues
• Conducted end user training for basic and advanced reporting skills.
• Building up of complex SAS Data Cubes for multidimensional analysis
• Creating functional domains above the cubes using Futrix tool.
• Support and Maintainance Of SAS applications in production environment
• Handling various errors and resolving support tickets efficiently
• Used different sql features including sub queries, correlated subqueries, inline views etc.
• Worked on unix commands for file manupilation, directory manupilation, changing environment settings, process control, system security etc.
• Created ksh scripts to perform various operation on files
• Setting up of reports in IQ3 as per the user requirements

Environment: SAS 9.1/8, MSAS, Futrix, Unix, Oracle 10g, SQL.

Confidential

Programmer

Responsibilities:

• Gathering User requirements and designing technical and functional specifications
• Development of OWB mappings to transfer Data from Souce system to Target system applying the required Business logic
• Development of API’s components using PL/SQL
• Monitoring and Handling production issues using Control-M
• Tuning sql queries

Environment: Oracle Warehouse Builder (OWB), PL/SQL,SQL