SUMMARY

• Certified SAS Professional with strong experience in Healthcare, Government, Energy and Financial industries for over 10 years on wide range of programming languages, software products and business intelligence.
• More than 10 years of Experience on SAS Products (Base SAS, SAS/STAT, SAS/GRAPH, SAS/IML, SAS ODS, SAS/ACCESS, SAS/CONNECT, SAS/RD)
• More than 7 years of SAS EBI Experience (Enterprise Guide, Data Integration Studio, Enterprise Miner, Management Console, Integration Technologies, OLAP Cube Studio, Information Map Studio, Web Report Studio, BI Dashboard, Risk Dimensions, and Information Delivery Portal)
• More than 3 years of SAS Visual Analytics Suite and Environment Manager experience including distributed and non - distributed environments)
• Deployed and maintained SAS Environments on AIX and Windows Server platforms
• Financial valuation methodologies and simulation analysis techniques
• Experience on UNIX environment including Shell Scripting and Scheduling Jobs
• Expertise on SAS/ACCESS to work with Relational DBMS DB2, Oracle, SQL-Server, Teradata, and Sybase using LIBNAME, SQL Pass Through facility, and with Hadoop ecosystems
• Superior skills in using SAS DATA Step, SAS Procedures, and SAS Macros to work with the data more efficiently
• Advanced skills on efficient coding, data processing, and implementing business rules
• Good business knowledge of Finance, Government, Energy and Healthcare domains and high problem solving skills

TECHNICAL SKILLS

Programming Languages: SAS, SQL, Matlab, R, Futrix, Shell Script,, JavaScript, JSP, HTML, XML, VBScript, C#, C, C++, Java, COBOL

Data Sources: DB2, Teradata, Sybase, Oracle, SQL Server, MongoDB, MS Access, Hadoop, Vertica

Operating Systems: Windows, UNIX/Linux, Mainframe

Software Packages: MS Office, IBM ClearQuest/ClearCase, IBM Lotus Notes, Redmine, WinSCP, Putty, JBoss, WebLogic, Windows IIS, Tomcat, mobaXterm, WinSQL, Notepad++, Teradata SQL Assistant, Oracle SQL Developer, Stash/git, ZEMA

PROFESSIONAL EXPERIENCE

Confidential, Juno Beach, FL

SAS Risk and BI Consultant

Responsibilities:

• Implementing SAS as Analytical platform by deploying multi-tier SAS Architecture
• Configuring SAS Server on AIX/Redhat Linux and maintaining the environment to support SAS Risk Dimensions and BI Suite (Legacy and VA)
• Developing Risk Dimensions environments and productionizing the processes
• Design simulation and statistical models in SAS Risk Dimensions and integrate them in system
• Conduct the historical simulation analysis to forecast the business metrics
• Using SAS Datastep, SQL DML, UNIX Shell commands to prepare the data for analysis
• Using SAS BI Suite to support the information delivery needs that includes, SAS Base programming, Enterprise Guide, Information Maps, OLAP Cubes, Web Report Studio, BI Dashboard, publishing the results in Information Delivery Portal
• Administering Visual Analytics data loading, content development and advanced configurations to integrate into Enterprise IT infrastructure
• SAS High Performance procedures hprisk, hplogistic, and hpreg implemented in distributed computing environment
• Integrate the data preparation, modeling, and report generation in SAS using macros, arrays, hashtables, IML and ODS facilities

Environment: SAS Foundation 9.3/9.4, Enterprise Guide 5.1/7.1, Risk Dimensions 5.5/6.5, SAS EBI/VA, Matlab, R, Oracle, DB2, SQL Server, Oracle SQL Developer, Windows 7, Windows Server and AIX.

Confidential, NYC, NY

Data Systems Analyst

Responsibilities:

• UseSASto deploy PD model, LGD model and EAD model on various lines of business and calculate corresponding risk-weighted asset amount
• Developed production code for Financial Runs for Prime, Subprime, OA and HELOC portfolios that create theSASdatasets that are being used for further analysis and modeling purpose.
• Accessed multiple databases usingSASand provided ongoing reporting that supported information-based decision making and periodic CCAR submissions
• Developed data explorations using Visual Analytics in studying model performance and back testing efforts
• Involved in meetings and projects with business users, project managers & developers to automate, upgrade or expand applications that accomplish business operations and goals
• Documented and tested programs that were widely used for various data reporting tasks

Environment: SAS Foundation 9.3/9.4, Enterprise Guide, Enterprise Miner, Visual Analytics, Oracle, DB2, SQL Server, Teradata, Teradata SQL Assistant, Windows 7, Windows Server and AIX.

Confidential, Chattanooga, TN

SAS/SQL Consultant II

Responsibilities:

• Redesigned inefficient process to efficient and quick process using SAS MP Connect
• Periodical training to team members on SAS tricks
• Provided technical insight to senior management and worked towards building infrastructure
• Created a Data Mart on Teradata with the data elements of team
• Automating SAS processes to streamline the business needs
• Migrated data from DB2 to Teradata
• Proof of Concept on DB2 BLU data source and performance evaluation with SAS
• Supported predictive modelers on technical aspects and data preparation
• Dashboard development using Futrix, Visual Analytics, and IBI (Information Builders)

Environment: SAS Foundation 9.3/9.4, Enterprise Guide, Enterprise Miner, Visual Analytics, Oracle, DB2, SQL Server, Teradata, Teradata SQL Assistant, Futrix, IBI, Windows XP, Windows Server, Mainframe and AIX.

Confidential, Albany, NY

SAS Admin/EBI Consultant

Responsibilities:

• Worked on developing HTML pages and wrapping SAS Stored Process in web pages to publish Health data in NYDOH website
• Reconfigured SAS environment using management console and edited the configuration files on Solaris
• Worked on OLAP cube studio and built, tuned the cubes to fit the performance and drill down capabilities
• Worked on SAS BI dashboard to develop the data models, rages, indicators and dashboard
• Worked on developing stored process, information maps and developed reports using web report studio
• Worked on deploying SAS reports/dashboards in information delivery portal
• In-memory data visualizations using Visual Analytics including the data loading
• Parsed HL7 data with Rhapsody application and integrated some of the functionality with SAS jobs for automation
• Used SAS Data Integration studio to developed ETL jobs on data to stage in relational environment tables

Environment: SAS Foundation 9.2/9.3/9.4, Enterprise Guide, DI Studio, SAS EBI- BI Dashboard, WRS, IDP, OLAP Cube Studio, IMS, Visual Analytics, Oracle, Hadoop, HTML, JavaScript, Windows 7 VM, Solaris, Windows Server.

Confidential, Chattanooga, TN

SAS Programmer

Responsibilities:

• Worked on several SAS programs, including emailing and automating Survey reports
• Extensive shell scripting to do FTP, SCP process, interacting SAS program with other programs synchronously and automating jobs
• Worked closely with Users on fixing the data errors and improving logic on data extractions for Vendor tools
• Installed and Maintained Vendor tools on Windows and AIX servers
• Re-mapped the data needs and reporting structure to company transition on MC Source Tool
• Efficiently extracted data from multiple databases using pass-through and libname facilities for processing and reporting
• Lead on technical aspects of Futrix tool to all departments in the company
• ESP scheduling on Mainframe in production process
• Worked on Symmetry grouper
• Maintained SAS environment including the User, Data, and Server Management
• Worked on Data Integration Studio to develop ETL jobs and integrated with Symmetry Grouper System

Environment: SAS Foundation 9.2/9.3, Enterprise Guide, DI Studio, Management Console, Oracle, DB2, SQL Server, Teradata, Windows XP, Windows Server, Mainframe and AIX.

Confidential, Pittsburgh, PA

SAS Consultant

Responsibilities:

• Developed SAS production jobs to do ETL process for Normalization
• Data transfer from Oracle and SQL Server to DB2 and Teradata using SAS/ACCESS (Libname and SQL Pass Through facility)
• Involved in developing data model requirements of the project
• Statistical Analysis of CIM data
• Assisted with multiple team projects on mortgage data analysis
• Extensive work on SAS EBI products to meet the Business needs of users
• Worked on integrating DW data with SAS Enterprise Risk Management products in Risk assessment
• Generated many ad-hoc reports to the internal requests using SAS and SQL (DDL and DML)
• Developed standard SAS Macros for the group of production programs.
• Migrated data from traditional databases to multi-dimensional databases.
• Used SAS ODS extensively to customize the production reports.

Environment: SAS Foundation 9.1/9.2, Enterprise Guide, SAS EBI, SAS ERM, WRQ Reflections, Oracle, DB2, SQL Server, Teradata, Windows XP and HP-UX.

Confidential, Chicago, IL

SAS Developer

Responsibilities:

• Extensive data analysis and data manipulation using Data step, SAS Procedures, and SQL.
• Supported regular ad hoc reports user requests.
• Data validation by checking data distribution and by comparison to a standard data.
• Regular SAS Access usage to transfer the data.
• Re-mapped the existing SAS jobs in production to new data sources.
• Developed SAS programs for daily reports to the users.
• Table joins and data aggregation to the requirements using SAS and SQL.
• Generated, Compared and updated the reports.
• Worked on huge data transformations using DI Studio for analysis needs.
• Developed SAS Stored Process and published them on Web Report Studio.
• Thorough understanding of mortgage lending lifecycle and data.

Environment: SAS Foundation 9.1, DI Studio, WRS, Oracle, SQL Server, MS Access, Windows XP, Windows Server.

Confidential, Pittsburgh, PA

SAS Programmer

Responsibilities:

• Data migration from Flat files to the databases.
• Worked closely with Datastage/DI people for ETL work and Metadata development.
• Used SAS DI studio to integrate Datastage jobs in automating ETL processes.
• Created SAS Web Report Studio reports on need basis and published on SAS IDP.
• Worked as a SME (Subject Matter Expert) for data format requirements.
• Documented methodology, data reports, and model results, and communicated with project team/manager to share knowledge.
• Processed big queries and data manipulation on large tables using Pass Thru SQL facility.
• Developed Unix Shell Scripts (Korn Shell) for automation of SAS jobs.

Environment: SAS Foundation 9.1, SAS Enterprise Guide, WRS, IDP DB2, Oracle, Sybase, SQL Server, UNIX, Mainframe, and Windows XP.

Confidential, Waco, Texas

SAS Programmer

Responsibilities:

• Performed extensive SAS programming required in UNIX environment.
• Coded an automation process to create Customer mailing list for Direct Mailing and Telemarketing.
• Worked on Ad-hoc requests by users regularly.
• Worked extensively to check the data integrity, data verification and validation.
• Involved in the risk and loss analysis.
• Responsible for configuring the ODBC drivers (Oracle, DB2 databases) for SAS.

Environment: SAS Foundation 9.1, Oracle, DB2, UNIX, Windows XP.