SUMMARY

• Have 12+ years of experience in SAS software development, Implementation, Administration, maintenance and support as a SAS/BASE & Macros Programmer, SAS Data Integration Developer 4.2 SAS BI Developer, SAS Visual Analytics and several BASE/SAS Products and SAS BI Administration, SAS CI Studio ( SAS Customer Intelligence), SAS/OLAP Cube studio, SAS BI Reporting applications with profound experience in Financial, Banking Retail and Life Sciences, Healthcare organizations.
• Administer SAS EBI, SAS Visual Analytics, SAS Dataflux, SAS Customer Intelligence, SAS on AWS.
• Extensive programming experience with proc SQL, proc report, proc freq, proc tabulate, proc transpose, proc plot, proc chart, proc datasets, proc format, proc compare, proc append, proc import, proc export, proc explode, proc print, proc transpose, proc print, proc report, retain, date manipulations, informats, formats and SAS/STAT procedures.
• Working Experience SAS on Unix, Linux, Mainframes, Windows Environment and SAS/GRID Platforms.
• Troubleshooting of SAS Servers, libraries and security schemes.
• Installation, setup and configuration of SAS 9.4.
• Experience in using SMC to create user and assign Access controls, create groups /roles.
• Administer and maintain SAS/GRID Platform.
• Manage and monitor Queues on SAS/GRID and monitor with SAS RTM.
• Configuration and maintenance of Users, Groups and Roles in SAS Metadata using SAS/SMC.
• Install sas hotfixes client side and server side
• Install SAS on AWS Cloud on (EMR)EC2 Linux, SAS Studio.
• SAS Access to Hadoop.
• Install and Configure on SAS Metadata Server, Middle Tier, App tier in separate machines.
• Backup and restore of SAS Metadata using backup utilities and promotion and replication..
• Detailed knowledge of how SAS Metadata security works
• Experience in SAS Grid Platform.
• Install Security Patches (Hotfixes)safely in Testing and Prod environments.
• Worked with SAS VA Laser Server.
• Working with SPD Server. Support to connect to SAS SPD from Microstrategy
• Identify the system problems and analyze the problems and solve the issues immediately.
• Connectivity of the Applications and resolve issues for business users.
• Scheduling Jobs and Monitoring and resolving the issues of jobs in lsf/ Flow manager.
• Monitor CPU statistics of jobs run in Unix server.
• SAS Metadata Backup, Content Backup, SAS Deployment backup, Content Server backup.
• Metadata content Backup with command line scripts
• Add new App Server to Load balancing Cluster.
• Utilizing SAS Environment Manager Application.
• Safely remove App Server from Load balancing Cluster.
• Monitor server utilization and memory utilization.
• Capacity Planning and Report diagrams for Capacity Planning document.
• Installing Hotfixes, renewal of SAS Licenses.
• Users and group Permissions.
• Security with folder level and Operating system level.
• Create and apply Access control Templates.
• Experience with Web sphere Provided Security and authentication for several business users for SAS BI applications.
• Creating Reports using SAS/Web Report Studio and Post reports in Portal for accessing Business users and give permissions for them as per priority.
• Strong BASE/SAS Programming experience.
• Creating Stored process and creating prompts using Stored process and execute in SAS BI Applications.
• Experience in data cleaning techniques and transformations in SAS/Data Integration studio.
• Good working knowledge in SQL
• Create cubes using SAS OLAP/Cube studio.
• Create Information Maps using SAS Information Map Studio.
• Create Reports using SAS Web Report Studio
• Post the reports in SAS Portal
• Creating Cubes, Rebuilding cubes, Edit structure of cubes.
• Dashboards creating using SAS/BI Dashboard.
• Proficiency in SAS/Base, and SAS Stat with basic understanding of SAS Macros, and SAS/Graph.
• SAS Macros programming.
• Creating and Administering Campaigns using SAS CI Studio.
• Able to work on UNIX, Shell scripting, SQL, MYSQL Admin, SQL Server, Talend, Microstrategy.

TECHNICAL SKILLS

• Unix
• Shell scripting
• SQL
• MYSQL
• Business Objects
• Oracle TOAD
• Talend
• Microstrategy

PROFESSIONAL EXPERIENCE

Sr. SAS EBI Platform Administrator

Confidential, Washington D.C.

Responsibilities:

• Install, configure and support SAS BI 9.4 Platform Multi tier environment.
• Add and remove new Application Server to Load balancing Cluster
• Capacity planning using Performance monitor
• Develop programs and generate automate reports.
• Creating and executing Stored process and post to SAS Web applications.
• Apply hotfixes
• Configure Greenplum Driver and setup to database.
• Server monitoring for over uses of resource.
• Checking Load balancing from Load balancing clusters.
• Monitoring SAS Servers.
• Create and register Libraries.
• Day to day activities.

Confidential

SAS marketing automation Developer and Administrator

Responsibilities:

• Install and configure SAS CI Solution in SAS BI Platform.
• Understand business problems and provide solutions to optimize marketing processes
• Strong understanding of marketing concepts, including multi - channel marketing.
• Create Source, target metadata using SAS DI.
• Migrating SAS Campaigns from Dev to UAT and Prod.
• Scheduling Campaigns from LSF.
• Create Stored process.
• Create Jobs and load target tables using SAS DI Studio.
• Design, build, test, and execute Campaign flowcharts to support your marketing tasks
• Access your marketing data SAS Customer Intelligence Studio via table mappings and catalogs
• Create offers and use them in your Campaigns
• Understand the response tracking features.
• Schedule DI Jobs as per schedule.
• Monitor Jobs using lsf.
• View the standard analytical reports
• Schedule campaigns and monitor using platform process manager.
• Create offer attributes and offer templates.

Confidential, Reston, VA

SAS EBI Administrator

Responsibilities:

• Make sure that all servers and applications are up and running.
• Connectivity of databases.
• Cataloging of databases.
• Mount/Unmount of file systems.
• Metadata Migration.
• User Management.
• Identifying Firewall issues.
• Working of Putty, Interactive and pc sas and All SAS BI Applications.
• Migration and Installation 9.2/9.4.
• Setup and installation of new applications, Visual analytics.
• Install SAS on AWS Cloud on (EMR)EC2 Linux, SAS Studio.
• SAS Access to Hadoop interface
• Supported to Deploy the infrastructe for SAS Grid on AWS.
• Working with Stored process and Base SAS Programming.
• Work on Unix SAS.
• Metadata management of SAS Visual Analytics, SAS Dataflux, SAS EBI.
• Create Reports.
• Extract data from different sources
• Create Cubes and Information Maps
• Creating Jobs
• Create Reports and post in Portal.
• Primary responsibility is the development and execution of SAS/SQL code to define customer populations to be targeted in Single Family and Multifamily..
• Research data elements to be used for targeting using database metadata.
• Communicate with business contacts as necessary to help explain results.
• Establish strong business partnerships with other members of project teams.
• Suggests process improvements and assists in updates of department’s documentation as needed.

Confidential, Kansas City, MO

GUA Metadata Management and Reporting Analyst

Responsibilities:

• Setup all SAS BI applications.
• Setup User Management
• Connectivity issues.
• Installation of SAS Clients.
• Register SAS/Share tables.
• Design Dashboards of Bar charts and Dynamic Gauges.
• Create users and provide access all reports and dashboards to users
• Meta data security.
• Installation of SAS Applications.
• User permissions as per requirements.
• Created SQL Queries using Confidential to load the data.
• Registered SAS files from views created by Confidential to give performance.
• Created Reports using SAS/BASE programming techniques using SAS/EG.
• Load the data using SAS/Data Integration Studio.
• Create Process flows from SAS DI.
• Deploy and Scheduled Jobs using DI & SMC.
• Application development including Analysis, Design, Testing and Implementation of key Customer Reporting Applications.
• DevelopedSASprograms to extract, transform, clean and manage large data files
• Validated existing Data Model and identify opportunities for removing redundancies
• Analyzed system performance of existing process and improve performance
• Develop scripts, software programs and stored procedures
• Create Cubes and Drill down reports using WRS.
• SAS data sets to Flat Files, Excel spreadsheets. Unit testing with different possible conditions
• Converted SAS Reports into HTML and other formats using SAS/ODS.
• Wrote shell script programs to run SAS jobs in UNIX, and then scheduling the scripts using Cron tab, at specific day and time.
• Used Toad Data Analysts to connect to Oracle DB2 for data analysis
• Analyzed financial data and capital market’s data using SAS/EG and produce an analytical sas dataset and used sas datasets as an input to Web Report Studio and Information Map Studio and created Web Reports and Information Maps
• Involved in debugging SAS programs using various SAS debugging techniques and extensively used Macros debugging options (Symbolgen, Mprint, Mlogic, Mfile)
• Implementation for Business Problems and Enhancements and recommending solutions.
• Strong System Optimization Techniques for New and Existing Applications
• Coordinate project team activities to meet objectives within prescribed deadlines

Confidential, Phoenix, AZ

SAS Developer and Admin

Responsibilities:

• Getting data from data source to create SAS Dataset and Creating Web reports
• Installing client applications and Administration for users.
• Extract Statistical data from transactional data source with statistical procedures
• Created process flows using SAS DI Studio and scheduled the jobs.
• Manage content in SAS Information Delivery Portal
• Scheduling and enhancement of SAS jobs in production
• Create Summary Detail Reports, Parameterized and Drill down Reports in SAS, Create analytical and statistical reports used by Policy System,

Confidential, Phoenix, AZ

Responsibilities:

• Extracting large data from Oracle to SAS data sets by extensive use of PROC SQL
• Extracting tables from Teradata using SQL and also converting flat files to SAS datasets
• Created SAS datasets in local SAS directory.
• Coding to convert different geographical values into numeric values for use in the program and to implement different transformation techniques.
• Introduced new variables with the existing variables based on business logics of Sprint
• Writing macros to develop a concise code.
• Depending on the report to be generated specific dates or specific locations records are only extracted.
• Merging the datasets to provide the users with the data in the required form
• These merged datasets are transformed and loaded into SPDS using SAS/ETL
• Interacting with other team members and lead to discuss the required developments to be made in coding to improve the functionality and effectiveness.
• Generated analysis reports, graphs using SAS/Reports and SAS/ODS to produce RTF and HTML report.
• Maintained the entire project and its contents using SAS/Enterprise guide and SAS/ETL.
• Responsible for the maintenance of the multi-dimensional database using SAS ware house administrator

SAS Administrator

Confidential

Responsibilities:

• Monitor the Daily Jobs.
• Participate in setup &Install and configure
• Create Jobs Using DI Studio.
• Schedule Jobs using SMC
• Execute Monthly Jobs
• Resolve the issues if portal doesn't access
• Installation, administration, maintenance and support of SAS Enterprise BI Applications.
• Administrative Activities.
• Raise Tickets and solve the Problems in IMR, CMR's of Amex Processess.