PROFESSIONAL SKILLS:

SAS PRODUCTS: SAS/Base /PC SAS SAS/Macro/Map Studio SAS/Access/visual Analytics SAS/SQL/Olap cube studio SAS/Graph/dashboard SAS/Connect/Grid Manager SAS/Integration Technologies Web Report Studio Enterprise Guide SAS/ETL Server SAS Management Console SAS Information Map Studio SAS DI Studio SAS IntrNET SAS BI/SAS Grid Manager

Confidential Ascential: QualityStage D Confidential Stage ProfileStage

Other Languages: Oracle, JavaScript JSP, Netezza, HTML, Sybase, DB2, Terad Confidential, Business Objects, SQL Server, Java, JSR 186/286 Programming, Java EE 6 (J2ee)

ETL: SSIS, SAS D Confidential Integration, Microsoft Reporting Services

D Confidential base: Oracle, Sybase, Netezza, Greenplum, DB2, Terad Confidential, MS SQL, Postgres, SAP

Security: LDAP/ Active Directory

Operating Systems: UNIX, Solaris/AIX, Mainframe, Windows, Linux

Version Control: Apache Subversion

Scheduler: M - Control Autosys, Trivoli, LSF and Cron

Cloudera: Hadoop and Impala, In-memory processing

Hortonworks: Hadoop, Map-R

Cloud integration: Amazon Web Services

Confidential: WebSphere Portal / Web Management.Content

Monitoring: Zabbix, Perf, Xymon

Management ITIL: Service, Incidents, Changes, Configuration items, JIRA, ServiceNow

Open Source Technologies: Postgres, JBOSS, NoSQL

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte NC

SAS Consultant

Responsibilities:

• Gather technical requirements, listen to business problems, ask probing questions, and develop the architecture model to meet the product/business needs.
• Develop, validate and maintain Logical d Confidential models and Physical d Confidential models.
• Analyzes needs and requirements of existing and proposed systems, and develops technical, structural, and infrastructure specifications.
• Working on Migration of UI Definitions, Properties, Workflows, Scripts for UDF and Case Configurations
• Working with ECM Metad Confidential
• ECM User Interface Definitions and Custom Page Builder and SAS Workflow Studio and Handling and Resolving Tickets in timely manner
• Facilitate and lead Portal design sessions with applications team members to identify desired functionality for d Confidential models and d Confidential base designs
• Designs, models, documents, and guides the logical and conceptual relationship of d Confidential and d Confidential base changes for the product.
• Build prototypes and Proofs-of-concept to illustrate the possible or validate as and when needed before feeding information to development teams.
• Work with development to implement architected solutions.
• Provide technical input to the product and technology roadmaps.
• Responsible for Architecture and Design of d Confidential infrastructure to support analytical and management applications, including d Confidential transport, security, analysis, reporting, and life-cycle management.
• Liaison between developers and business analysts in areas of expertise
• Design and construct reports and dashboards for end users
• Develop a plan listing the ongoing reporting and user interface maintenance needs
• Enforce d Confidential integrity and quality standards through process and governance Monitor and improve performance of the SAS BI applications
• Maintain SAS Metad Confidential

Confidential

SAS Administrator

Responsibilities:

• Developed, validated and maintained Logical d Confidential models and Physical d Confidential models
• Developed claim reports based on a set of person-level d Confidential files derived from MSIS d Confidential on Medicaid eligibility
• Develops KPI Model Design for Users
• Develops and tests new dashboards in Tableau
• Evaluated existing d Confidential models and physical d Confidential bases for variances and discrepancies
• Currently upgrading the current 5 node Grid AIX/Veritas cluster to AIX P8/GPFS servers and migrating to SAS 9.4m3 and LSF 9.
• This upgrade includes clustered metad Confidential, round-robin gsub servers and a middle-tier in a production environment and a 3 node cluster in the dev environment including fail-over metad Confidential and middle-tier. Installed SAS 9.4m4 on 5 linux servers.
• Used Erwin d Confidential modeling tools to develop LOGICAL d Confidential models and PHYSICAL d Confidential models
• Providing all support for the SAS EBI System on an AIX 7.0 LPAR server, Linux & Wintel environments, plus Windows clients.
• Also responsible for implementing a 3 node grid interfacing with a 10 node SAS Virtual Analytics cluster.
• Including: LSF Platform Suite, SAS Web Portal (JBoss & Websphere), SAS VA and SAS Enterprise Guide.
• Managed meta d Confidential for d Confidential models
• Integrating SAS with d Confidential warehouse environments running on a d Confidential base such as Microsoft SQL Server, PostgreSQL, Hadoop (Hortonworks or Cloudera) Amazon, Oracle, Terad Confidential, DB2,Sybase, Greenplum

Confidential NC

SAS System Administrator

Responsibilities:

• Diagnosed software problems and engineer work-arounds
• Developed claim reports based on a set of person-level d Confidential files derived from MSIS d Confidential on Medicaid eligibility
• Developed a series of reports related to pharmacy benefit use and reimbursement in Medicaid
• Installed and supported SAS Customer Intelligence platform, such as SAS Marketing Automation (SAS MA), SAS Marketing Optimization (SAS MO),
• Collaborated with the business to understand/influence business requirements
• Facilitate/lead/participate in identification of solution options and features
• Communicate solution options to business owners/stakeholders (e.g. architecture reviews)
• Configured SAS to work with MS SQL server, DB2, Terad Confidential, oracle, hadoop, netezza, Impala, sas Laser, oracle, JDBC, and ODBC
• SAS Grid and process load balancing, resource management
• Installed and configurated SAS Grid Environment and SAS Visual Analytic
• SAS Troubleshooting and Root Cause Analysis
• Scheduled sas jobs reports, sas automations, batch jobs using LSF, tivoli, and cron-tab
• Wrote Python, Perl, Shell, Powershell to automate system administration and installation

Confidential

SAS Administrator

Responsibilities:

• Configured and Installed SAS Foundation 9.3/9.4, SAS Metad Confidential BI Server 9.3/9.4, SAS Grid 9.4 and SAS Visual Analytics 6.3/6.4
• Installed and configured SAS Server environment including Metad Confidential and Mid-Tier Servers
• Implemented security and workspace administration in SAS Management Console
• Applied SAS Hotfixes, Maintenance Release, and License Renewal as required
• Created SAS Access Interface to Oracle, Terad Confidential, Hadoop, Impala, DB2, SQL Server, and other files systems connections in management console
• Installed and Configured SAS Clients: SAS Enterprise Guide, SAS Enterprise Miner, Base SAS, SAS Model Manager, Microsoft Add-in Client Installation.
• Metad Confidential configuration (create roles/Users/backups/libraries/D Confidential source)
• Installed and configured of SAS software and components including SAS solutions in production grade environments
• Administered Hadoop and Impala
• Configured and Installed Hadoop and Impala
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Practical understanding and hands on developing D Confidential modeling such as (Dimensional & Relational) Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Hands on in process improvement, normalization/de-normalization, d Confidential extraction, d Confidential cleansing, d Confidential manipulation.
• Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
• Created table views, Synonyms, Indexes, Joins and Partitioning.

Confidential, Charlotte NC

D Confidential Architect/SAS Administrator

Responsibilities:

• Metad Confidential configuration (create roles/Users/backups/libraries/D Confidential source)
• Developed, validated, published, maintained LOGICAL d Confidential models and PHYSICAL d Confidential models
• Evaluated existing d Confidential models and physical d Confidential bases for variances and discrepancies
• Managed meta d Confidential for d Confidential models
• Responsible for Monitoring, Logging, and Troubleshooting SAS Servers
• Mapped d Confidential from multiple sources (including Oracle, flat files, Excel), built and implemented the d Confidential flows and loading the d Confidential into a SAS Analytical/Reporting d Confidential mart.
• Created Stored Processes to provide the users of the Reporting D Confidential Mart easy access to the d Confidential .
• Gathered d Confidential requirements and designed and developed d Confidential marts and performed analytical and tested, and promoted DI jobs into SIT, UAT and prod environments.
• Installed, designed, developed and deployed DW applications using the SAS version 9 Intelligent Platform technology, architecture and resources in a Solaris 9 or 10 environment
• Designed complex logical and physical d Confidential models on an enterprise scale (star schema, snowflake, normalized)

Confidential

DOJ Department of Justice

Responsibilities:

• Installed, configured, and administered SAS Enterprise software
• Developed reports using SQL on claims d Confidential based on the Medicaid population, their characteristics, utilization, and payments.
• Developed a series of reports related to pharmacy benefit use and reimbursement in Medicaid
• Developed Medicaid Remittance Details report allows providers to view remittance information for their Medicaid claims.
• Secured the SAS configuration on each server Machine
• Checked status and operate servers
• Applied Hot Fixes/patches, new licenses to SAS environment, licensing upgrade and migration
• Monitored server activity and administered logging
• Established formal, regularly scheduled backup process
• Add users and manage access
• Established connectivity to d Confidential sources
• Set up metad Confidential folder structure
• Integration of SAS software with systems and other third-party software
• Provided pre- and post-implementation documentation
• Engineered application implementations based on requirements and sizing assessments
• Configured, managed, monitored and debugged mid-tier software such as Websphere
• Developing tools and software to manage SAS and third-party software
• Diagnosing, documenting, reporting, and resolving system problems
• Developed Reports
• Developed SAS EBI dashboards

Confidential, NewYork

SAS Administrator/ETL Developer

Responsibilities:

• Installed, and configured the SAS Enterprise BI Infrastructure
• Performed/Insured proper backups of metad Confidential and business d Confidential
• Monitored SAS Server resources and reporting usage(s)
• Applied Hot Fixes/patches, new licenses to SAS environment.
• Designed, implemented, and maintained security on SAS Metad Confidential and Linux for users
• Designed, implemented, and executed change control to SAS DI jobs, and SAS codes using subversion
• Responsible for the systems design, implementation, and maintenance of SAS solutions across an enterprise-wide cross-platform
• Extracted, transformed, and loaded d Confidential from SQL Server repositories to Terad Confidential

Confidential, Wilmington Delaware

D Confidential Architect/Modeler

Responsibilities:

• Configured, managed, monitored and debugged mid-tier software such as JBoss
• Migrated and tested program codes in IST,UAT and PROD Environments
• Converted program codes to Terad Confidential
• Created Terad Confidential volatile queries and tables

Confidential

D Confidential Architect/Modeler

Responsibilities:

• Developed SAS code and BI Dashboard for Health Care Industry.
• Combined Avaya call center and Inquiry d Confidential to create percentage values for performance guarantee and work force planning statistics.
• Developed stored process report calendar programming
• Created information maps and OLAP cubes for reports using d Confidential from d Confidential warehouse created reports using SAS report studio
• Deployed reports to SAS information delivery portal

Confidential

Lead SAS Development SAS/Administrator

Responsibilities:

• Administered in a multi-tiered topology SAS9 environment
• Used AIX infrastructure with GPFS and AMC storage.
• Developed pricing forecasts/models.
• Administered SAS EBI, High Performance Analytics, Enterprise Miner, D Confidential Management Server, SAS Scoring Accelerator for Terad Confidential, SAS Model Manager
• Created SAS application based on specification from clients and developed an export file system that accessed APPMETA tables (Clients, Accounts).
• Automated report to be sent via FTP. Created weekly and monthly reports.
• Define business requirements and specifications for clients involved in D Confidential link project.

Confidential,

SAS Senior EDI /SAS Administrator

Responsibilities:

• Administered the use of LSF Scheduler including Platform Flow Manager, Event files, and job dependencies using SAS management console.
• Built monthly SAS warehouse with SAS/D Confidential Integration Studio software for Credit Reporting.
• Interfaced with other support teams, customers, and vendors

Confidential

SAS Administrator

Responsibilities:

• Designed ETL objects mappings, using mapping operators, transforming d Confidential with d Confidential Stage using transformation operators
• Applied Hot Fixes/patches, new licenses to SAS environment .
• Interfaced with other support teams, customers, and vendors
• Installed, and configured the SAS Enterprise BI Infrastructure
• Configured, managed, monitored and debugged mid-tier software such as Tomcat
• Developed tools and software to manage SAS and third-party software
• Designed process flows, deployed and populated staging area objects and populated the DB2 Enterprise Model Warehouse.
• Developed, validated, published, maintained LOGICAL d Confidential models and PHYSICAL d Confidential models
• Evaluated existing d Confidential models and physical d Confidential bases for variances and discrepancies
• Used Erwin d Confidential modeling tools
• Designing of the d Confidential model to support the user requirements Wrote test cases, test scripts and execution plans to support UAT in d Confidential validation on the Confidential .
• Created metad Confidential for target d Confidential, Use Table loader Transformation
• Develop slowly changing Dimension, Create metad Confidential for source d Confidential