SUMMARY:

SAS Consultant/Financial Analyst with 8 years of experience in designing projects, collaborating with project teams, interfacing with clients and business users and implementing technology to build successful solutions using SAS technologies in functional areas like financial, banking industries.

STRENGTHS:

• Certified Base SAS Developer/SAS Administration with over 8 years of experience in Analysis, design, development, reporting, testing and validating applications using SAS V9.
• Provided help-desk support, production support, Tech support, administration.
• Troubleshot SAS Applications issues in user environment and provided technical solutions to business user needs.
• Did software upgrades, patches, maintenance- performance monitoring and tuning of SAS environments.
• Extensive hands on experience on SAS BI on SAS 8, SAS 9.1.3, SAS 9.2, SAS 9.3 Administration including SAS connect, SAS internet server, SAS OLAP server, SAS Metadata server, SAS Object Spawner, SAS Management console
• Excellent installation, configuration experience of SAS9.3 in UNIX environment.
• Good experience in deploying SAS EBI software.
• Good experience in performing and tuning applications/ App servers.
• Experience in maintaining a large multi-platform SAS environment it includes SAS Business intelligence tools and SAS application tier.
• Worked with multi platform across multiple environments.
• Experience in killing jobs, cleaning up dead processes.
• Good experience in Active directory Authentication and PAM.
• Administered the SAS start-up and stop scripts and the status of the server services.
• Hands on experience working on SAS/Base, SAS/Stat, SAS/SQL, SAS/ODS, SAS/Macros, SAS/Graph, SAS/Access
• Extensive expertise in analyzing data and generating reports, summary tables, listings and graphs
• Experience working with databases ORACLE, DB2, Teradata, and MS Access and applications using these databases in SAS V9
• Experience on programming languages in UNIX SHELL.
• Excellent knowledge and work experience data manipulation, data cleaning, sorting, concatenating, stacking, interleaving, merging and combining SAS datasets using SAS/Base, SAS/ETL, SAS/Enterprise Guide and SQL
• Knowledge on JBoss Application Server for deploying the web applications
• Skilled in writing to automate SAS related tasks and conversion of SAS Datasets to various file types including HTML, Word, PDF, Excel, ASCII, and flat files as well as converting various file types to SAS Datasets
• Experience in importing/exporting data between library files and flat files using SAS Data and Proc steps
• Expertise using SAS/MACROS and proc's to access, extract, modify, merge, and analyze customer data and to generate statistical analysis reports
• Expertise in generating Graphs using SAS procedures Proc Gplot, and Proc Gchart
• Experience in Analysis, Design, Development, Testing and Implementation in all phases of SDLC
• Highly motivated with excellent organizational and interpersonal skills
• Possess strong ability to quickly adapt to new applications and platforms
• Good team member with string analytical and communication skills

Technical Skills

• Statistical Software : SAS 9.X Base SAS, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/GRAPH,
• SAS/ACCESS, SAS/ODS , SAS/Management Console, Enterprise Guide
• Software Packages : Microsoft Office Excel, MS Word, Visio, PowerPoint , Adobe Reader
• Databases : Oracle 9i/10g, MS Access
• Operating Systems : Windows 95/98/NT/2000/XP/7, UNIX Shell Scripting

Professional Experience

Confidential

SAS Administrator

Responsibilities:

• Install, setup, configure and maintain sever on UNIX Environment.
• Responsible for solving Tickets, fixing issues.
• Supported Onsite and Offshore developing Team
• Responsible for Backup and Recovery
• Adding and removing user's, created and assigns roles in SAS Management Console
• Monitor the Metadata server environment and worked with end user's.
• Updated the files on Grid environment
• Monitored the LSF on Grid environment
• Provided Customer support, production support
• Applied hotfixes, patches
• Scheduled jobs for SAS User's, installed SAS Server and client components whenever needed.
• Connect SAS systems to other systems such as SQL, Teradata, oracle and DB2.
• Provided on call support for production problem resolution.
• Create documentation for end users and internal Other SAS Admins .
• Watch through all the remedy tickets and troubleshoot user incidents.
• Responsible for daily server reboots.
• Upgraded SAS from one version to another.
• Developed new and changed existing SAS Programs using SAS Technologies
• Extensively used proc tabulate, proc summary, proc means, proc sql, and Macro's
• Worked within organizations, which focuses on marketing, target marketing, statistical analysis and reporting primarily using SAS
• Extracted data from different data sources and created SAS data sets for further analysis
• Prepared graphs and reports using the SAS Datasets for business analysis
• Design and Develop different report templates based on the user specifications
• Merging Data Sets and Manipulating Data Sets
• Extensively done SAS Macro Programming
• Automated daily, weekly and monthly reports using macros
• Gathered data, ensure accuracy, and developed reports for stakeholders and executives

Technologies: SAS 9.3Software, SAS/Management Console, Enterprise Guide4.3, OLAP Cubes, Oracle, Windows, CVS, Microsoft Office Excel, MS Access, MS Word, Visio , Adobe Reader

Confidential

SAS Administrator

• Implemented the Hot Fix Installations, User Issues, any other Maintenance issues
• SAS Server has to be constantly backed up has to be restored in case of server crash
• Hands on Skills on Management Console Important are - Server Manager, User Manager, Authentication, Customer Intelligence, Setting up Logging
• Setting up DB Connections from Management Console to Teradata
• Monitor all the tiers Metadata, Compute Web on unix.
• Deploying web applications in Web Sphere
• Promotion of Metadata such as libraries, metadata folders, information maps, campaigns, etc from one environment to another
• Played key role in data analysis and statistical reporting for TIAA-CREF claims
• Actively participated in the complete SDLC Life Cycle of development, from the requirement phase to testing phase
• Monitor storage growth and work with user areas to develop purge criteria. Coordinate with other IT groups on performance, storage issues, etc
• Monitoring of servers, databases and workstations to ensure availability and efficiency.
• Document operational processes and recovery procedures
• Maintain environment configuration information
• Administer user access and security on the system
• Maintain the User Inventory License Information
• Install, Configure and support SAS 9.2/3 environments including SAS Metadata Server on unix.

Technologies: SAS 9.3 Software, SAS/Management Console, Enterprise Guide4.2, OLAP Cubes, Oracle, Windows, CVS, Microsoft Office Excel, MS Access, MS Word, Visio , Adobe Reader

Confidential

SAS Administrator

• Extracting different reports related to Sales, Budget, cost and stocks
• Extracted data from various sources like Flat Files .xls, csv etc , Oracle into SAS
• Extensive experience with concatenating, interleaving and merging SAS datasets
• Used SAS macros to produce a flexible SAS code
• Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros
• Extensively used PROC SQL to get the data from the databases
• Conducted analysis and generated tables, listings and graphs using SAS
• Extracted data from Databases using SQL within SAS to be analyzed and exported to Excel and CSV for further analysis
• Install, setup, configure and maintain sever on UNIX Environment.
• Responsible for solving Tickets, fixing issues.
• Supported Onsite and Offshore developing Team.
• Responsible for Backup and Recovery.
• Adding and removing user's, created and assigns roles in SAS Management Console.
• Monitor the Metadata server environment and worked with end user's.
• Worked on LSF schedulers
• Monitored the Grid environment
• Provided Customer support, production support
• Applied hotfixes, patches.
• Scheduled jobs for SAS User's, installed SAS Server and client components whenever needed.
• Connect SAS systems to other systems such as SQL, Teradata, oracle and DB2.
• Provided on call support for production problem resolution.
• Create documentation for end users and internal Other SAS Admins .
• Watch through all the remedy tickets and troubleshoot user incidents.
• Responsible for daily server reboots.
• Upgraded SAS from one version to another.
• Worked closely with statisticians and Data managers in analyzing the data and implementing statistical methodologies using proc freq and proc means
• Provided programming support to produce analysis, reports, and graphs on on-going studies, reviewing program codes, and suggesting alternative efficient solutions
• Supported testing of the product in CIT, SIT, UAT PRE-PROD testing environments and efficiently resolve build, runtime interface issues that arise across different testing environments.
• Coordinated supervised the development activity of offshore. Review Plan documents and Test Results for each requirement.
• Created functional specification, Test Cases and Design Documents.
• Participated in code review and performance tuning of the program and assisted the team in improvising the performance
• Adhoc report programs are developed to let the users select the specified boundaries to create a report
• Produced safety and efficacy reports in RTF and HTML formats
• Used CVS as a Version Control/Defect Tracking tools
• Ability to work on multiple projects simultaneously and meets the deadlines as and when required

Technologies: SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/GRID, Oracle, Windows, CVS and SAS Enterprise Guide, Microsoft Office Excel, MS Access, MS Word, Visio , Adobe Reader,UNIX.

Confidential

SAS Consultant

Responsibilities:

• Developed new and changed existing SAS Programs using SAS Technologies
• Extensively used proc tabulate, proc summary, proc means, proc sql, and Macro's
• Worked within organizations, which focuses on marketing, target marketing, statistical analysis and reporting primarily using SAS
• Extracted data from different data sources and created SAS data sets for further analysis
• Prepared graphs and reports using the SAS Datasets for business analysis
• Design and Develop different report templates based on the user specifications
• Merging Data Sets and Manipulating Data Sets
• Extensively done SAS Macro Programming
• Automated daily, weekly and monthly reports using macros
• Gathered data, ensure accuracy, and developed reports for stakeholders and executives

Technologies: SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/GRAPH, SAS/ACCESS, SAS/ODS, UNIX, Oracle, Windows, Microsoft Office Excel, MS Access, MS Word, Visio , Adobe Reader

Confidential

SAS Financial Analyst

Responsibilities:

• Monitor and model company financial and operating performance
• Contribute to the timely analysis of investment opportunities, including the development of purchase/sale recommendations
• Develop relationships with portfolio managers and analysts/traders through both verbal and written communication
• Build and maintain relationships with analysts at investment banks, other research entities, rating agencies and issuers
• Installed/Renewed SAS licenses
• Used Proc SQL to pull the data from different data sources to create the SAS datasets
• Worked with millions of records 80-100million for analysis and reporting
• Developed new or modified SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs
• Extracted data from Oracle using Proc SQL Pass through facility and generated ad-hoc reports
• Responsible for developing new projects and supporting existing applications
• Extensively used sas macros to build a framework type of application
• Daily/weekly/monthly/Quarterly reports were produced
• Used Connect/Direct in extracting the Data from the Remote Box
• Worked in all phases of SDLC

Technologies: SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/GRAPH, SAS/ACCESS, SAS/ODS, UNIX, Oracle, Windows, Microsoft Office Excel, MS Access, MS Word, Visio , Adobe Reader

Confidential

SAS Financial Analyst

Responsibilities:

• Monitor and model company financial and operating performance.
• Contribute to the timely analysis of investment opportunities, including the development of purchase/sale recommendations.
• Produced reports on research results- Implemented spreadsheets and statistical software to analyze data.
• Developed new financial planning techniques.
• Forecasted marketing returns, marketing expenses and cross-company analytical method linkage.
• Measured company's overall marketing performance- Implemented effective and timely industry-competitive analysis
• Develop relationships with portfolio managers and analysts/traders through both verbal and written communication.
• Build and maintain relationships with analysts at investment banks, other research entities, rating agencies and issuers

Technologies: SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/GRAPH, SAS/ACCESS, SAS/ODS, UNIX, Oracle, Windows, Microsoft Office Excel, MS Access, MS Word, Visio , Adobe Reader