SUMMARY:

• 10+ years of strong experience as a SAS platform Admin/Grid/VA Analyst in SAS EBI environment, Cloudera (CDH4, CDH5) andR administration
• Hands on experience in installation, configuration, supporting and managing Hadoop Clusters using Cloudera distribution. Cluster capacity planning, performance tuning, cluster Monitoring, Troubleshooting
• Supported R environment: Microsoft R Server (formerly Revolution Analytics), RStudio, RHadoop
• Data Analysis, Reporting, Data Warehousing/migration and Data Management applications
• Strong knowledge of multiple operating systems, including aspects such as memory management, file system architecture, CPU utilization
• Experience in developing performance metrics and monitoring complex system environments
• Understand capacity planning, project current and future number of users where possible
• Developed systems design document with the involvement of system and network architects
• Hands on experience in analyzing Log files for Hadoop and ecosystem services, finding root cause
• Commissioning, Decommissioning, Balancing Nodes and tuning for optimal performance of the cluster
• Familiar with cloud environments - Amazon Web Services (AWS), EC2, S3 etc
• Definition of roles for SAS ADMIN team members, task assignment, planning
• Connect SAS to third-party tools such as Oracle, SQL Server, SYBASE, and DB2, Teradata
• Supported a large number of business users and SAS Developers.Helped users collaborate
• Extensive understanding of JDBC (Java Database Connectivity), IOM (Integrated Object Model), ODBC connectivity, SAS/ACCESS, SAS Grid and SAS Integration technologies
• Performed installation and configuration, system performance improvement, system accessibility, and complete processing, configured security and roles to provide appropriate access to confidential data
• Well versed with all phases of Software Development Lifecycle, Systems Methodologies
• Successfully handled responsibilities for extracting internal/external data, data cleansing, Manipulation, validation, developing statistical models, analysis and report generation
• Worked on migration, upgrades SAS 8.2, SAS 9.1.3 to SAS 9.4 version.
• Extensive programming experience with Proc SQL, Proc Report, Proc Tabulate, Proc Transpose, Proc Plot, Proc Chart, Proc Datasets, Proc Format, Proc Print, SAS/STAT Procedures
• Expert in using PROC SQL, DATA, MERGE, SORT to generate adhoc and customized reports
• Used OLAP Cube Studio to create reports from SAS Financial Management. Formulas in SAS FM
• Used AQUA data Studio, TOAD DB2 for instant query runs for Oracle and DB2 databases
• Used SVN software to version control of programs and templates

TECHNICAL SKILLS:

SAS Tools: Base SAS 8.2, SAS 9.1.3, SAS 9.2 EBI,SAS Graph, SAS STAT, SAS ODS, SAS MACROS, SAS/SQL, SAS/GRAPH, SAS/FSP, SAS/AF, SAS/SHARE, SAS/CONNECT, SAS/EIS, SAS/SHARE*NET, SAS Financial Management (FM), SAS Activity Business Management (ABM), SAS JMP, SAS/IntrNet, MDDB Server common products, SAS Integration Technologies, SAS Business Intelligence, SAS OLAP Cube Studio, SAS Management Console, SAS DI Studio, SAS WEB Report Studio, SAS Information Map Studio, Enterprise Miner, SAS/ACCESS Interface to ODBC, SAS/ACCESS Interface to OLE DB and Hadoop, SAS Enterprise Guide (EG) 4.0, SAS/ETL, SAS LASR, WS FTP, WRQ Reflexion, AQUA Data Studio 8.0, TOAD DB2, Tortois SVN, ULTRA Edit

SAS Procedures: Tabulate Report, Print, Printto, Contents, Means, Freq, Univariate, Summary, SQL, Datasets, Copy, Chart, Sort, Transpose, Registry and Format.

Database: Oracle, MS Access, Teradata, SQL Server, FoxPro, DB2, Netezza, Hadoop,Sybase

Languages: C, C++,.Net, C#, VB.NET, VB, VBA, SQL, PL/SQL, COBOL, PL1, JAVA, J2EE, SAP R/3 ABAP, Fortran, HTML, XML, PERL, JCL

Others: R, DeployR, RHadoop, Cloudera Hadoop, Microsoft R Server, DeployR, MS Office 2003, MS Excel, MS Word, MS Power Point (PP), Lotus Notes, Crystal Reports, Java Script, VB Script, PERL Script, VB, VBA, AS/400, Cognos, SAP Business Objects XI(BOXI)

Operating System: Windows 2000/NT/XP, UNIX, Linux, Mac OS, Z/OS, MVS (Mainframe), MVS/TSO, ISPF

PROFESSIONAL EXPERIENCE:

Confidential,Chicago, IL

SAS GRID,Cloudera and R Administrator

• Installed and Configured SAS GRID(9.4) servers and VA Federation server, Hadoop and LASR environment
• Administrator for Cloudera Hadoop cluster - installation, configuration and monitoring the Hadoop Cluster
• Installed and Configured Microsoft R Server on Linux Hadoop Environment
• Created users, Groups and permissions for Microsoft R environment
• Configured parallel distribution on workloads for R environment
• Installed and Configured DeployR. Supported R Server security policies, which include user authentication and authorization
• As a SAS Admin and architect, involved in Design, implementation, supportof platform security via SAS Metadata, Red Hat Enterprise Linux
• Performed SAS and Linux platform capacity planning and management
• Configured SAS Grid Failover server for High availability feature of SAS GRID
• Configured and internal and external users of SAS, LDAP, Active Directory
• Understanding of the capabilities of the SAS analytical procedures
• Developed Server and job scripts with Unix shell scripting and SAS Macro facility
• SAS hot fixes maintenance using SASHFADD
• Monitored and configures SAS schedulers and LSF jobs. Monitored and start/stop services of SAS and SAS VA servers. Created SAS documentation for everyday runbook about daily activities and alerts of the servers and application and their logs
• Monitored multiple hadoop cluster environments using Ganglia and Nagios. Monitored workload, job performance and capacity planning using Cloudera Manager
• Loading log data directly into HDFS using Flume
• Created and supported Tableau Sites, users, groups. Creating libraries and database connections
• Ability to multi-task and address complex support issues in a mixed technology environment
• Development of process automation
• Supported cloud migration project: Dev and test environments migrated to Amazon web Services (AWS)
• Ticketing system: BCBSA Service Now application tickets of Tasks, Requests and incidents of SAS, Tableau, Cognos, SAS VA and Business Objects
• As Backup support member of the Analytical Sandbox environment I supported and configured Cognos and Business Objects servers, databases, users, applications and performance of daily activities
• As a part of the application management I worked with firewall team for designing SAS and Tableau architecture

Environment: SAS EBI GRID(9.4) Management Console, SAS Environment manager. SAS Web Administrative Console, SAS Federation Server, SAS LASR, IPSWITCH MFT and MOVEit, WINSCP, SAS Visual Analytics, Base SAS V9.4, Enterprise Guide (EG) 5.1, SAS Integrated technologies, SAS Metadata Server, SAS/SHARE, SAS/CONNECT, SAS/ACCESS Interface to ODBC, Hadoop, Oracle, SQL Server,DB2, Cloudera Hadoop, Microsoft R server, AWS (EC2, S3, EBS), Tableau, Cognos, SAP BOXI, UNIX, Korn shell

Confidential,Louisville, KY

SAS and Cloudera Hadoop Administrator

• Installation and configuration of the SAS Grid environment with 5 nodes
• Configured different applications like SAS Enterprise Guide, SAS Management Console(SMC), SAS Environment manager, SAS Grid manager
• Monitoring systems and services, architecture design and implementation of hadoop, configuration management, backup, and disaster recovery systems and procedures
• Importing and exporting data into HDFS using Sqoop
• Experienced in defining job flows with Oozie
• Managed and reviewed Hadoop Log files as a part of administration for troubleshooting purposes. Communicate and escalate issues appropriately. Work with developers to troubleshoot job failures. Documented common issues and recovery processes for future reference
• Followed standard Back up policies to ensure high availability of cluster
• Supported and configured Tableau administration
• Configured and monitored SAS Meta data server backup
• SAS Servers: start and stop services using shell scripts.Managed SAS Logs configuration
• Configured Object Spawner, Logical data step batch server, Logical workspace server, Logical store process server
• Configured SAS failover Grid master node and node servers. Configured Grid Jobs Priorities
• Configured and supported approximately 70 Tableau users and 4 Tableau Sites.
• Configured users from internal and LDAP servers. Configured Groups and Roles
• Managed and Activities of servers and application monitoring
• Supported production, development and testing environments.
• Supported job scheduling in Autosys and LSF schedulers.
• Downloaded, installed and configured SAS hotfixes using SASHFADD.

Environment: SAS Management Console, SAS Environment manager. SAS Web Administrative Console, Base SAS V9.4, Enterprise Guide (EG) 5.1, SAS Integrated technologies, SAS Metadata Server, SAS/SHARE, SAS/CONNECT, SAS/EIS, SAS/ACCESS Interface to ODBC, Teradata, JAVA, J2EE, UNIX, Korn shell

Confidential

SAS Analyst Lending and forecasting

• SAS 9.4 configuration and administration
• Created Forecast models for personal loans and credit risk related reports for Personal loan MIS and personal loan collections and recovery
• Automated Forecast models on Forecast server to eliminate manual steps in the jobs
• Collected data from different stake holders for different forecast models
• Developed predictive models in risk analysis using SAS Enterprise MinerCredit risk analysis using proc summary, proc freq, proc reg, proc mean, proc ANOVA, proc SQL, proc univariate, proc forecast, Proc ARIMA, proc time-series and discriminate analysis
• Created daily HTML reports using ODS SAS
• Wrote batch scripts using FTP and PSFTP (Secured FTP) to download the data and CSV files from UNIX to Windows.Wrote Korn and shell scripts to submit the series of Jobs on UNIX and for transfer the data, reports and SAS programs from one location to another location
• Improved accuracy and relevance of credit card clients planning process reports and budgets reports supporting decision making processes for upper management
• Supported all the activities to create Forecast modelling and predictive models using SAS Forecast studio and SAS Enterprise Miner. Improved financial performance by reducing losses, improving capital management and building a risk aware process
• Supported cloud migration project: Dev and test environments migrated to Amazon web Services (AWS)
• Process improvement: Reduced production migration effort from three man weeks to two-man days
• Automated Risk division reporting process using SPSS, SAS, C++ and MS Excel for data loads from Teradata, DB2 and Oracle. Risk department:Compiled sales production and market penetration data for executive management. Data included employee activity, client coverage and territory alignment analysis.

Environment: Base SAS V9.4, Enterprise Guide (EG) 5.1, SAS Macros, SAS/STAT, SAS Integrated technologies, SAS Metadata Server, SAS/GRAPH, SAS/FSP, SAS/AF, SAS/SHARE, SAS/CONNECT, SAS/EIS, SAS/ACCESS Interface to ODBC, Teradata,SPSS, AWS (EC2, S3, EBS),JAVA, J2EE, WEBLOGIC SERVER, SQL, PL/SQL, UNIX, Korn shell, Visio, MS WORD, MS Excel, MS Power Point (PP), MS Visual Studio, XML, SQL, STORED PROCEDURES.

Confidential,Optum Insight

Sr. Software Engineer(SAS Admin, Cloudera Hadoop Admin and Production support)

• Experience/Working in SAS administration, Hadoop Admin, infrastructure support, large-scale business process support and SAS user support of 600+ business analysts and SAS/Hadoop developers.
• SAS Implementation and configuration of SAS 9.2,9.3,9.4 Enterprise BI Version and SAS 9.1.3 BI Version, SAS EDI, Management Console, Enterprise Guide, OLAP Cube Studio. Web Report Studio, Information Map Studio
• Responsible for Cluster maintenance, commissioning and decommissioning Data nodes, Cluster Monitoring, Troubleshooting, Manage and review data backups, Manage & review Hadoop log files
• Installed and configured Flume, Hive, Pig, Sqoop and Oozie on the hadoop cluster
• Installing and configuring Kerberos for the authentication of users
• Managing and tracking SAS products inventory and license updates for SAS servers and end user desktops
• Securing the SAS configuration and Checking the Status and Operation of SAS Servers.
• Monitoring, Logging, and Troubleshooting SAS Servers.SAS Disaster and recovery
• Administering Users, administering the Enterprise SAS environment. Manage daily production SAS server problems, ensuring effective and timely resolution and communications to the customer
• Experience in building SAS Metadata Server and setting up Metadata Repository
• Understand the security models (both for SAS and the organization),Securing and Moving Metadata.Roles to control Access to application functionality, manage roles in SAS Management console
• Supported SAS Grid workload management RTM - queues configuration, graph and alerts
• Supported SAS Grid LSF reconfigure the cluster with Isadmin and badmin
• Supported SAS Grid LSF by managing users and usergroups
• Supported SAS Grid cross cluster usage mapping. For SAS Grid integrated and analyzed large volumes of data
• Supported SAS Grid Manager Features: Multi-user and parallelized work load balancing, Distributed scheduling, high availability and scalability, prioritize & job schedule jobs using rules based queues, identify, allocate and Manage resources, setup SAS Grid to detect grid failures and recovers automatically, Automatic restart of jobs from last successful check point
• Divide a complex process flow into a set of smaller flows that are joined together and executed in a particular sequence using SAS LSF tool on SAS GRID environment.
• Supported all ETL SAS datasets from CCDI(Oracle), GALAXY (DB2, UNET and Cosmos), ARO GOPHER etc
• Supported Data Mining Queries (DMQs) for all business analysts for Peer and Galaxy databases. Developed DMQs templates Static, AutoThreshold, DMQ final reports, Run Algos templates
• Supported Clinical data requests
• Configured Workspace server
• Experience with the RDBMS (Teradata, Oracle, DB2, etc.), MVS systems
• Modifying the SAS metadata step batch server.Used the SAS Metadata Server to store configuration information for SAS Integration Technologies and other SAS products
• Testing support for SAS products during deployment, upgrade and any changes to SAS products and/or during other enterprise activities. Used SAS Management Console as a central interface to administer configuration and security information for SAS Integration Technologies and other SAS products
• Support daily job scheduling, jobs monitoring using SAS Management Console, SAS Grid Manager,and the Flow Manager in the Platform LSF Process Manager under UNIX Server environment
• Migrating from SAS 9.1 Bi Version to SAS 9.2 Enterprise BI version
• Providing support to internal customers like Client Care, Sales, Analytics of future business, SAP BW data support for ETL and analytics on data
• As SAS Admin, maintained SAS users matrix template and created SAS automated template
• Areas of assistance include PC SAS, UNIX-based SAS, SAS EG and SAS EBI 9.1, 9.2, 9.3,9.4
• Supporting Peer analysis, Medicare and Retirement (M& R), E & I, C &S, Medica and AARP users like RETRO, R&V(Referral and Validation), GCA(Government CA) Environments
• Developed and Supported for all Peer analysis ETL datasets like Facets commercial, Facets Secure Horizons, Nice, AARP, UHMR Cosmos, UHCS Cosmos, Health net, Neighborhood Health Partners(NHP).
• Supported Cognos NQ support for Healthnet Client.
• Created MS VISIO templates for applications of data flow and logic
• Created UNIX Korn Shell scripts to schedule and automate the jobs.Developed for SAS admin user related programs and automated template as SAS admin and programing support.
• Set up servers and libraries for remote data (multi-tier environments) for ETL jobs of SAS DI 4.2
• Management of SAS licensing (PC SAS and server-based SAS).
• Support and development for SAS scheduled production and self-service job development, deployment, operations, support, and maintenance.
• Testing and validation of SAS tools and applications in desktop and server environments. Support for UNIX-based SAS servers related to user access, server performance, server resource management, and troubleshooting.
• Deployed jobs for scheduling.SAS stored process that can be accessed by a Web service client for which ETL jobs are created by SAS Data Integrations studio 4.2.Managed the Status of Jobs and Transformations in DI Studio
• Development and management of key metrics related to SAS support
• Configured and supported Oracle, Teradata, DB2, NETEZZA, SQL Server and MS Access databases with SAS
• Supporting PC SAS, SAS EBI (Web Report studio, Information Map studio, DI Studio, OLAP Cube Studio)and UNIX servers related tickets using HP Service Manager Incident management, Problem Management, Configuration Management and Change Management.
• Production process scheduling using TWS, Tivoli (IBM) and Autosys and monitoring in UNIX environment.
• SAS application development (i.e., building, deploying, and maintaining SAS applications for data extraction and reporting), across multiple operational platforms (e.g., PC, UNIX server, mainframe). Base SAS coding experience, SAS EBI and Enterprise Guide experience.

Environment: SAS EBI (Enterprise Business Intelligence) 9.1.3, 9.2, 9.3, 9.4, SAS GRID server and Nodes management, Enterprise Guide (EG 4.1, 4.3), SAS OLAP Cube Studio, SAS Management Console,SAS Web Report Studio, Enterprise Miner, SAS JMP, Windows 2003 Enterprise Edition, UNIX (AIX 5L), Korn Shell, OS390, SAS\Access, SAS/SQL, SAS/AF, SAS/ETL, SAS/ETS, SAS/FSP SAS/Intranet, SAS Data Integration Studio 4.2, 3.4, SAS/Graph, SQL, Oracle, Teradata, DB2, NETEZZA, SQL Server and MS Access databases, SQL Server, MS Excel, MS Excel Macros, SQL, SAS\STATS

Confidential,Canada

SAS Platform Administrator

• SASImplementation and configuration of SAS 9.2 Enterprise BI Version and SAS 9.1.3 BI Version, SAS Data Integration Studio, Management Console, Enterprise Guide, OLAP Cube Studio. Web Report Studio, Information Map Studio
• Support in daily job scheduling, jobs monitoring using SAS® Management Console, the Flow Manager in the Platform LSF Process Manager under UNIX Server environment.
• Migrating from SAS 9.1 Bi Version to SAS 9.2 Enterprise BI version. Version upgrades of both server and client components
• Routine application of SAS Hotfixes and service packs, operating system patches
• Verify that the correct setinit or SAS installation data (SID) license file is readily available.
• Document the installation and configuration process in an Installation document. Maintain the installation document so that as components are added and versions change the procedures are updated
• Update the SAS configuration file to make the best use of the hardware resources
• Used new security features for user registration, authentication, and authorization (access control). Created roles, users. Groups, authorization and permissions as SAS admin
• Used load balancing for workspace servers and Spawners, as well as stored process servers and spawners
• Used the SAS Web Infrastructure Platform to create Web applications that use portal technology
• Configured SAS tools Data Integration Studio, OLAP Cube studio, SAS Enterprise Guide 4.2
• Have an investigative mind to be able to troubleshoot issues as they arise
• Data warehousing ETL jobs and Data Marts from SAP BW, Oracle, Sybase, Teradata, DB2 and OLAP cubes development with Star Schema methodology with Fact tables and dimension tables using Data Integration Studio(DI) and OLAP Cube Studio
• Used SAS Management Console as a central interface to administer configuration and security information for SAS Integration Technologies and other SAS products, monitoring; memory and process inspection, file system resource inspection
• Ensure compliance with the SAS license agreements
• Metadata Import and Export for SAS Data Integration Studio 4.2
• Using SAS Metadata Bridge to import Common Warehouse Meta model (CWM) into SAS Data
• Data Conversions and data migration SAS 8.2 mainframe versions to Windows Pc SAS 9.1.3
• Historical, regular, and Adhoc reports development from old versions to new environment with SAS BI, and Cognos BI. Working on migration SAS 9.1.3 to SAS 9.2 version to all current, new reports and queries
• Used DI Studio for ETL jobs for databases SQL Server, ESSBase, SAP BW, Oracle and Teradata and other CSV and text files

Environment: SAS 9.2 Enterprise Business intelligence(EBI), SAS 9.1.3 BI suite, Enterprise Guide, Enterprise Miner, Data integration Studio(DI) 4.2, OLAP Cube studio 9.1, Cognos BI, Information Map studio, Management Console, SAS\Access, SAS/SQL, SAS/AF, SAS/ETL, WEB Focus, Oracle, SQL Server, Teradata, SAP BW, DB2, Windows, UNIX, Mainframe, AS/400, WEB Focus, MS Excel, MS Excel Macros, SQL.

Confidential,North Haven, CT

SAS BIAdmin Consultant

• Support the annual Anthem Confidential production process for assigned measures/processes (jobs)
• Ensure that source codes are updated & complete, accurate and timely based on ERISA Form 5500 Schedule A and Schedule C reports requirements, updates, audit requirements and data sources
• Identify barriers such as data quality issues and incomplete data, and investigate, document and implement actions to meet goals
• Used SAS Business Intelligence tools, Data Integration Studio(DI), Information Map Studio, Web Report Studio, Enterprise Guide and Management console to develop ERISA Form 5500 Schedule A and Schedule C reports
• Participate/coordinate in workgroup meetings across functional areas to identify improvement opportunities that will lead to better results or improved efficiencies
• Perform as the subject matter expert for assigned measures and processes, defining expectations with systems partners and supporting systems development, including specification and code walk-through and acceptance testing
• Participate in the annual audit process by supporting the business team with documentation, analysis findings, and perform as systems expert to ensure a successful audit
• Operating systems environments are UNIX, Mainframe and Windows
• Lead/support data-centric initiatives both within the department and in support of other matrix partners.
• Provided support of user requests for assistance or ADHOC reporting using Cognos, as required
• SAS Implementation and configuration of SAS 9.1.3 Enterprise BI Version,, Management Console, Enterprise Guide, OLAP Cube Studio. Web Report Studio, Information Map Studio, SAS Data Integration Studio
• Configured, implemented and tested in SAS environment SAS Business Intelligence tools Data Integration Studio (DI), Information Map Studio, Web Report Studio, Enterprise Guide and Management console
• Configured new types of IOM servers (SAS Metadata Servers, SAS Stored Process Servers, and SAS OLAP Servers) in addition to SAS Workspace Servers.
• Capacity planning to address growth in items likes storage, memory, CPU utilization.
• Develop service level agreements with the OS, database and network administrators and their departments for the SAS system, web and source data servers.
• Periodically review and test disaster recovery procedures.
• Identify barriers such as data quality issues and incomplete data, and investigate, document and implement actions to meet goals
• Data Flux dfPower Studio Verify, validate and improve the overall accuracy of data; Parse data into components to identify individual data elements
• Lead/support data-centric initiatives both within the department and in support of other matrix partners.

Environment: SAS BI (Business Intelligence) 9.1.3, SAS 9.2, Enterprise Guide (EG 4.1), SAS OLAP Cube Studio, SAS Management Console,SAS Web Report Studio, Enterprise Miner, SAS JMP, Windows 2003 Enterprise Edition, UNIX (AIX 5L), Korn Shell, OS390, SAS\Access, SAS/SQL, SAS/AF, SAS/ETL, SAS/ETS, SAS/FSP SAS/Intranet, SAS DI Studio, SAS/Graph, SQL, JAVA, PL/SQL, Teradata, Mainframe, AS400, SQL Server, MS Excel, MS Excel Macros, SQL, SAS\STATS

Confidential,Pittsburg, PA

Sr. SAS Financial Intelligence (FM/ABM)/BI (OLAP/DI) Consultant

• Designed on Object Oriented principles and Developed the product using Java/J2EE technologies on SDLC and Agile Methodology
• Developed Logical Data Model (LDM), Physical Data Model in Oracle Database design for SAS ABM modeling
• Key advisor to operational units
• Provided forecasting and planning assistance to management and used the Planning and Budgeting (P&B) solution, to align strategic objectives with performance measures
• Managed, automated and standardized the process of consolidating financial information
• Worked on SAS Management Console, SAS Data Integration (DI) Studio, SAS OLAP Cube Studio and Enterprise Guide (EG), Cognos
• Worked on SAS Financial Management interfacing with SAS Financial Management Studio, Excel (SAS Financial Management Add-in for Microsoft Office) and SAS Information Delivery Portal
• Configured the SAS Information Delivery Portal by adding and editing portlets and adding alerts. Added links to reports, Web pages and folders
• In Data Warehouse Environment:
• Extract and Transform from source data into Staging Area
• Data Quality and Data Validation
• Transform into dimensional model
• From SAS Detail Data Store (DDS) I created Conformed Data Mart (CDM) and Product Data Mart (PDM).
• From Conformed Data Mart (CDM) I created SAS FM Data Mart
• Moved Data into the Solutions Data Mart
• Using SAS FM I worked on Dimensions, Cycles, Rates, Models and Forms.Used Forms for reading/writing of budgeting or financial reporting data into the SAS Financial Management database
• Cycles used for unique combination of dimensional data and time granularity.Used dimension types Organization (INTORG, TRADER), Account, Time, Analysis, Currency, Source, Rate Type, in SAS FM
• Created Combined Weekly/Quarterly Report from Weekly Data Model and Quarterly Data Model
• Created cell data access (CDA) reports through SAS Financial Management
• Creating imported from the SAS Detail Data Store (DDS) to the Solutions Data Mart (SDM) as fact records
• Generated OLAP Reports in SAS Financial Management and SAS Activity Based Management
• Created periods and scenarios, dimensions, modules and account
• Defined drivers that measure the consumption of expenses and activities
• Calculated costs and displayed the results.Defined and link external unit costs to accounts
• OLAP Cube studio used create multistage Cubes in SAS FM and SAS ABM models
• Loaded users, user groups and user-member associations
• Loaded reference tables and reference table jobs

Environment: SAS BI (Business Intelligence), SAS Financial Management (FM), SAS Activity Based Management (ABM), Enterprise Guide (EG 4.0), SAS OLAP Cube Studio, SAS Management Console, Enterprise Miner, SAS Forecast Server, Windows 2003 Enterprise Edition, UNIX (AIX 5L), Korn Shell, OS390, AS400, Main frame, SAS\Access, SAS/SQL, SAS/AF, SAS/ETL, SAS/ETS, SAS/FSP SAS/Intranet, SAS DI Studio, SAS/Graph, SQL, JAVA, PL/SQL, Oracle 10G, SQL Server, MS Excel, MS Excel Macros, VB, VBA, SQL, SAS\STATS

Confidential,Phoenix, AZ

Sr. SAS/Data Mart ETL Consultant

• Converted SAS 8.2, Mainframe Application to SAS Business Intelligence Project using SAS Web Report Studio, SAS/AF, SAS/FSP, SAS OLAP Cube Studio, SPSS and JAVA
• Involved in Implementation and coding of front end screens using Java, JSP
• Produced multiple PL/SQL ETL, Enterprise Data Integration packages from Data Warehouses on Solaris platform
• Designed Parts and Tools Data Warehouse Dimensional Model utilizing OWB 10g.Created OWB Repository with OWB Repository Assistant, Source Metadata definition, Staging Area metadata definition and Target definition
• Designed ETL objects mappings, using mapping operators, transforming data with OWB using transformation operators.Data is converted using SAS ETL process from last 22 years historical data mart - it has millions records in databases, DB2, VSAM
• Developed business intelligence applications and SAS predictive model using SAS DI Studio and Enterprise Miner
• Created OLAP Cubes using SAS OLAP Cube Studio.
• Used Business objects, Designer to create adhoc reporting
• Using SAS/Intranet, Created Content and migration of content to Intranet environment
• Supported the running of Mainframe batch jobs and interfacing with various users and/or project team members during code development and testing
• Used SAS stat models for tax data analysis like cluster analysis and regression model building etc.
• Converted data from mainframe VSAM files to flat files using SAS, JCL on mainframe environment. VSAM and SQL Server files are converted to Flat files and later converted Oracle Tables
• Used Microsoft Visual Studio to write SQL queries to access the SQL Server and MS Access

Environment: SAS BI (Business Intelligence), Enterprise Guide (EG 4.0), E-Miner SAS OLAP Cube Studio, Text Miner, SAS Management Console, Windows 2003 Enterprise Edition, UNIX (AIX 5L), Korn Shell, OS390, IBM Mainframe, MVS/TSO, AS400, ISPF, JCL, PL1, SAS\Access, SAS/SQL, SAS/AF, SAS/ETL, SAS/ETS, SAS/FSP SAS/Intranet, SAS DI Studio, SAS Forecast Server, SAS/Graph, Business Objects, Designer,SQL, PL/SQL, Crystal Reports,Cognos, Oracle 10G, SQL Server, Microsoft Visual Studio,.net, JAVA, C#, VB, MS Access, MS Excel, MS Excel Macros, VB, VBA, SQL, SAS\STATS

Confidential,Elk Grove Village, IL

Sr. SAS Stat and Data Analyst Architect Consultant

• Using SAS Financial Management interfacing with SAS Financial Management Studio, I handled acquisition, authorization, dashboard, partner summary and various Graphs and summary reports for credit card risk related reports in production using SAS
• Using SAS FM created, edited manual adjustments make sure that the display context was correct
• Used OLAP Cube Studio to create reports from SAS Financial Management and Stat procedures, regression model (logistic and linear) building, (Summary, CHAID, CART, Mean, Freq,), cluster analysis, Excel, VB, VBA, C++, Mainframe, UNIX (Korn and C) shell scripts
• Created data marts, predictive model, OLAP Cubes and reports for Business intelligence reporting in SAS using SAS ETL Studio, SAS DI Studio and Enterprise Miner, Cognos and SAS Financial Management Studio
• From SAS jobs, developed CSV files and reported offshore progress to management with the use of Excel Templates, Excel macros, Pivot tables and functions, as well ascreating daily, monthly, quarterly, Yearly reports activity onsite through the creation of a SQLServer, Teradata and MS Access databases
• Credit risk analysis using proc summary, proc freq, proc reg, proc mean, proc ANOVA, proc SQL, proc univariate, proc forecast, proc time-series and discriminate analysis and so on.
• Created daily HTML reports using ODS SAS.Wrote batch scripts for FTP using FTP and PSFTP (Secured FTP) to download the data and CSV files from UNIX to Windows
• Created reports for credit card financial transaction oriented and the high level financial management systems
• Improved accuracy and relevance of credit card clients planning process reports. Served as liaison between sales, compensation and accounting organizations to ensure consistency in metrics and reporting standards
• Automated Risk division reporting process using SPSS, SAS, C++ and MS Excel
• Provided analysis, design and development efforts in the migration of Oracle 11.0.3 to 11.5.10 RAC
• Wrote Kornand shell scripts to submit the series of Jobs on UNIX and for transfer the data, reports and SAS programs from one location to another location.
• Developed a visual report writer in VB, VBA as an MS Excel add-in module.
• Developed an MS Access add-in module in VB, VBA to optimize Oracle SQL development from within MS Access

Environment: SAS Business Intelligence, SAS Financial Management (FM), SAS OLAP Cube studio, SAS Management Console, Enterprise Guide (EG 4.0), Enterprise Miner, Text Miner, C++, Sun Solaris, Windows 2000, UNIX, Korn Shell OS390, IBM Mainframe, JCL, AS400/DB2 PL1, SAS DI Studio, SAS\Access, SAS/SQL, SPSS, SQL, PL/SQL, VB, Business Objects 6.5, Oracle, JAVA, MS Access, MS Excel, MS Excel Macros, MS Visual Studio, VB, VBA, SQL, SAS/FSP, SAS\STATS, SAS/Intranet, SAS/AF, SAS/Graph

Confidential, Appleton WI

SAS Consultant

• SAS 9.1.3 Business Intelligence Configuration
• Extracted data from DB2, Teradata and SYBASE data mart using SAS SQL procedures and created SAS data sets
• Worked for Demand Planning research analysis with SAS Financial Management (FM)
• Used SAS OLAP Cube report Studio to create OLAP Cubes from SAS Financial Management (FM)
• Extensively used Base SAS for data scrubbing and cleaning
• On-demand consolidation for enhanced what-if scenario modeling of TFL.Tracked, stored and audited every financial control and processes of TFL financial data
• Assessed ongoing performance by monitoring departments activities and financial performance
• In Budgeting and Planning, performedDriver-based, top-down and bottom-up budgeting
• Used to develop regression and survival model for financial planning decisions
• Reviewed dimension members and hierarchies in SAS Financial Management application.Worked on Dimension work space, Model work space, Rate work space, Form work space, cycle work space in SAS FM
• Created partitioned datasets and generation datasets on mainframe
• Used SAS/STAT Procedures such as Proc Freq, Proc Means, Proc Summary, Proc Univariate for Analysis
• Automated excel reports using VB, VBA by using SAS, SQL Server and MS Access databases
• Used Proc Import and Export procedures for importing data from different file formats and exporting data to different formats
• Participated in designing, coding, testing, debugging and documenting Business Objects and VB
• Wrote JCL, PL1 programs to communicate with the MVS (TSO, ISPF) operating system
• Worked with SAS on IBM UNIX AIX 5L and Korn shell platform. Wrote Shell Scripts for automation of the SAS jobs
• Extensively used SAS/ETL, Web Report Studio, and Enterprise Miner
• Created SAS datasets in local SAS directory from raw data files

Environment: SAS 9.1.3, SAS Business Intelligence, SAS Financial Management (FM), Enterprise Guide (EG) 3.0, MVS (OS 390), UNIX (AIX 5L), Korn Shell, Mainframe, COBOL, AS400, PERL, PL1, SAS\Access, Window NT, MVS (TSO, ISPF, PLATINUM), SAS OLAP CUBE Studio, SAS/ETL, E-Miner, SAS Intranet, SAS Web Report Studio, SAS DI Studio, SAS/AF, VB, Oracle, VSAM, Lotus, Lotus Notes, DB2, SQL Server, Business Objects, MS Access, JAVA, Teradata, SQL, PL/SQL, JCL, SAS\STATS, SAS/FSP and PeopleSoft.