SUMMARY:

• Over twenty years in a senior level position with reporting responsibilities
• Over twenty years of systems development and implementation experience
• Over twenty years experience with data modeling tools such as Erwin Model Manager, oracle designer and Olap tools such as SAS Olap Studio.
• Over twenty years experience in extracting, transforming and loading source data into an operational data store and data Warehouse from multiple sources including DBMS and application system transaction files, third - party software packages and spreadsheet applications.
• Over twenty years SAS background (including installation, configuration, testing, debugging)
• Experience in security and workspace administration in SAS Management Console
• Experience with aligning the data model with presentation requirements (explicit and implied)
• Over sixteen experience in implementing reports in BI platforms (Business Objects, Oracle OBIE, SAS)
• Strong SQL and database skills (with Oracle V 10g, Oracle V 11g)
• Over two years with Oracle V l0g and Oracle V 11g
• Experience working with Base SAS, SAS Enterprise Guide, Enterprise Miner, and Enterprise Business Intelligence
• Over five years experience with Cognos, and OBIE
• Over eight years experience in small team management experience (4-20 resources)
• Over ten years experience with SAS Client Tools (Base SAS, Enterprise Guide, Information Map Studio, Data Integration Studio and OLAP Cube Studio)
• Over sixteen years experience Olap and advanced Olap (MDX)
• Development and deployment of Web Report Studio Reports, SAS Information Delivery Portal Content(portlets) and custom SAS Stored Process Web Applications through the SAS client (including tools such as EG, WRS, IDP and AMO)
• Over twenty years experience with Base SAS Programming(SAS Macro Language, SAS ODS, Proc Report, Proc Tabulate, and SAS Graph
• Over twelve experience working with UNIX
• Over three years experience working with CRON scripts, and Tivoli
• Over eight years experience working with LSF and LSF administration
• Experience with SAS 9, SAS 9.1.3, SAS 9.2
• Over five years experience with IBM Websphere, and Weblogic
• Experience with 9.2 Architecture
• Experience with SAS Grid technology, Base SAS, Enterprise Miner, Enterprise Guide, SPDS
• SAS V9.2 platform experience (Metadata management using Management Console; Base SAS Language Programming; Report Writing using a variety of Procedures and Tools including use of ODS, Enterprise Guide, Information Map Studio, and Web Report Studio; ETL and Data Mart design using DI Studio)
• Over eight years experience with SAS Web Tools (Web Report Studio, Information
• Experience with Microsoft Office Products
• Two years of SPDS (Scalable Performance Data Server ) experience
• Five years of Enterprise Miner experience
• Experience with SAS Design and Development
• Over sixteen years supporting SAS data sourcing (access Interface to Oracle, Sql Server, DB2 and Teradata) and reporting deliveries
• Over ten years with developing detailed technical documentation
• Over ten year s experience with SAS (SAS Administration, SAS Data Integration, SAS OLAP, SAS Information Delivery Portal, SAS Stored Processes)
• Over sixteen years experience in base SAS advanced programming
• Over sixteen years experience of data warehousing and ETL.
• Strong data modeling and SQL Query skills in logical and physical data modeling
• Over seven years experience with Ascential Data Stage, Ascential Profile Stage, Ascential Quality Stage, MS SISS( MS Integration Services) and their Administration.
• Over sixteen years Implementing SAS projects (Configuring hardware, environment integration, Data Integration, web reporting, and SAS Administration)
• Over sixteen in years experience in Oracle data warehouse and SAS data Warehouse.
• Over sixteen in years Application Design/Architecture, IT Architecture, Systems Architecture experience
• Expertise in the creation and usage of metadata
• Over sixteen years experience building and maintaining large scale reporting infrastructure
• Experience with SAS BI product set
• Over sixteen years technology architecture consulting and industry experience
• Ability to develop advance knowledge of SAS technology, architecture and resources
• Over sixteen years of experience in database Administration/software development
• Over sixteen years system administration experience
• Knowledge of software and applications development life cycle
• Demonstrated experience with creating and maintaining end to end data architectures including logical and physical data models
• Over fifteen years of experience in data Warehousing
• Excellent problem-solving, organizational, decision-making skills
• Excellent Understanding of advanced RDBMS and data modeling concepts
• Over ten years of web application development
• Ability to work independently as well as team oriented with excellent communication and collaboration skills.
• Experience with normalized and dimensional data modeling techniques as well as experience implementing OLAP concepts and data structures
• Over ten years of experience in Oracle, MS SQL Server, SQL application development and RDBMS
• Over sixteenyears experience of SAS Management Console, SAS/Intrnet, SAS/STAT and SAS/Graph
• Over ten years experience in Windows Administration
• Ten years experience in Unix Administration
• Hands-on technical experience using data warehouse, business intelligence and analytics products (SAS)
• Experience in identifying business analytical needs, and translating them into data warehousing, business intelligence solutions, and SAS Enterprise ETL
• Over ten years experience of data warehousing and ETL
• Over eight years experience with Dataflux data quality
• Experience seven experience in Java, Javascript, J2EE, JSPs, and DB2
• Experience in SAS Forecast, Enterprise Miner
• Experience in SAS analytic, Tomcat, Websphere, Weblogic, and JBoss
• Experience in building of Operational Data Stores (ODS), Data Marts, and Enterprise Data Warehouses.
• Experience in Data Analysis and Data Model Development (i.e. logical and physical models).
• Strong experience in Data Warehouse and data marts implementation.
• Experience in implementation of ODS, Staging, 3NF, Relational and Multi-Dimensional.

EXPERTISE AREA:

• Installation, Administration, and Support of the software in conjunction with SAS on MS Windows 2003-2007, AIX and Solaris 10
• Install, setup, configure and maintain servers on Solaris servers (unix)
• Create and maintain user profiles and groups consistent with security restrictions and performance considerations.
• Administer SAS BI tools on Solaris servers (unix)
• Migrate SAS codes from DEV to BT1, BT2, UAT, STRTEST, SIT (Integration) to Prod
• Administration of user access and security
• Scheduled monthly, weekly, yearly, daily and fiscal year sas jobs.
• Monitor storage growth and work with user areas to develop purge criteria. Coordinate with other IT groups on performance, storage issues. Coordinate with SAS "power users" to schedule production loads/jobs.
• Maintain environment configuration information.
• Installation of SAS software on client’s desktops
• Implementation of upgrades and patches to both Server and Workstations
• Monitoring of servers, databases and workstations to ensure availability and efficiency
• Documentation of SAS server applications, workstation application and security policies in force.
• Experience in SAS client applications installation (e.g., SAS Management Console, SAS Information Map Studio, SAS Enterprise Guide) and familiar with how plug-ins are configured
• Experience in SAS servers installation and configuration on data server (e.g., SAS Metadata Server, SAS Object Spawner, SAS Workspace Server, SAS Stored Process Server, SAS Connect

TECHNICAL SKILLS:

Databases: SQL Server 6,7, 2000-2005, Oracle 7, 8, 8i, 9i, 10g, 11g, DB2, Teradata, SAS Scalable Performance Server

Data Warehousing: Oracle, SAS ETL, DB2, SAS/Administrator data Warehouse, SAS Fair Banking, SAS Data Integration studio

Data Modeling tools: Visio, Erwin v5.1, Data Architect, Oracle Designer

BI Reporting Tools: Crystal reports, Business Objects, Cognos, SAS web report Studio, SAS BI Reports, SAS Enterprise Guide, SAS dashboard, SAS Information Maps Studio, Stored Processes, SAS MS office Integration

Data Analysis Tools: Ascential Qualitystage, Ascential Profile stage, SAS Data Quality, Dataflux, SAS Profile stage

Presentation tools: MS Visio, MS powerpoint

Scheduling tools:: LSF, SAS Grid, Tivoli, Cron

Microsoft products: Excel, Microsoft words

Languages and Applications: Java, J2EE, Unix, Linux, Perl, Netbean ide, SAS programming I/II/III, SAS/Statistical, SAS Proc SQL, Olap cube, SAS Proc sql, Base SAS, SQL, JSPs, Servlets, Javascript,Html, CSS, Visual Basic .net, Visual Studio .net

Web Applications: Tomcat 3x, 4.1, 5.1, Websphere, Weblogic, JBoss, sharepoint

Web Tools: SAS Information Delivery Portal ( tools and administration), SAS Web Report Studio, SAS Stored Processes, SAS/Intrnet

Security Application/Operating Systems: Active Directory, LDAP, Windows NT, XP, 2000,2003,2007, 2008 R2, Unix/AIX, Unix/Solaris 10, Linux

ETL: SISS (SQL Server - 2005 Integration Services), IBM Ascential Datastage, SAS Data integration v9.1.3-v9.2

BI Tools: SAS Business Intelligience v9, v9.1.3,9.2, Oracle Business Intelligience

SAS Analytic: Enterprise Miner v5.3, SAS/GRAPH, Olap cube Studio, SAS/STAT, SASS (SQL Server Analysis Services), OBIE

Version Controls: Subversion Repository, TortoiseSVN, CVS

PROFESSIONAL EXPERIENCE:

Confidential, Burlington, North Carolina

Lead SAS Development Analsyt / Engineer

Responsibilities:

• 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 Datalink project.
• Created and implemented custom remoted portlet for the datalink sas application system.

Confidential, Raleigh, North Carolina

SAS Administrator/Developer lead

• Administered the SAS9 software environment (dev, test and production), on a Solaris platform. Checked the status and operations of SAS servers and processes, including starting, stopping, and/or pausing the servers/processes used in the SAS system. Managed metadata repositories and performed and scheduled regular backups of the Metadata Server and physical files. Monitored, and troubleshoot SAS servers and processes, including error messages and using system logs or setting logging options as well as options within SAS Management Console (SMC).
• Troubleshoot SAS server issues, such as system access and password problems. Administered scheduling of jobs and reports, and used SAS Management Console to administer metadata. Added new libraries to the Metadata Server, and via the SAS Management Console, controlled user access to various parts of the SAS system, granting permissions to read, write, create or view reports and data within the system - ensured that Users see only the information that they are authorized to access.
• Created and configured libraries and permissions for Users and groups of Users, and assign logins. Designed, implemented, and maintained the security framework, including securing data at the library, dataset and column level and leveraging ACT’s and ACE’s as applicable (with access rights and privileges, user roles / groups).
• Created an authentication plan for securing the SAS platform resources, utilized alternative authentication providers such as LDAP. Performed system administration tasks such as monitoring CPU/RAM/Disk space utilization, port utilization and running processes on applicable OS.
• Troubleshoot SAS-related performance issues by working with customer’s systems administrators, network administrators, web application server administrators, database administrators and storage administrators. Assisted with problems pertaining to accessing the SAS server(s) or data.
• Monitored for availability and then installed updates to SAS software (patches / maintenance releases / hot fixes). Monitored SAS servers and spawners, and then optimized memory usage and tune servers for optimal performance. Created, modified, and maintained various folder structures within SAS Management Console.
• Configured relevant processes for load balancing and pooling. Applied utilization, configuration and promotion of development, test, and production environments. Worked with the Customer systems administrator to secure server resources and file systems to ensure SAS objects having a server component are secure via the operating system.Interfaced with the Customer Web Application Server Administrator when needed pertaining to SAS web applications.
• Assisted Customer users with SAS code from an administration perspective (e.g., helping issue OS level commands from within SAS programs). Provided knowledge transfer, mentoring and expert advice to Customer on the efficient administration of the SAS system. Kept records of and documented the entire SAS environment, including detailed records of problems that have occurred and the associated resolutions.
• Administered the use of LSF Scheduler including Platform Flow Manager, Event files, and job dependencies using SAS management console. Installed SAS licenses when needed. Created Pages, Portlets and added Content within the Information Delivery Portal.
• Performed server and ports troubleshooting activity when requested and modified SAS configuration files as needed. Monitored SAS EBI Platform and resolved systemic issues. Performed mid-level administration of Jboss such as performance tuning, configuration, troubleshooting using logs, deploying SAS web applications and applied patches when needed. Upgraded SAS 9.2 T2M2 to T2M3 on unix environment.
• Development of sas programs and scheduling sas programs through LSF scheduler and Tivoli scheduler. Installed ODBC, DB2 and SQL Server on a unix environment. Administered SAS BI tools such as Enterprise Guide, Data Integration, OLAP studio, stored process, Information Map, Add-in Microsoft office, Enterprise miner, Dashboard, Web report Studio, and Information Delivery Portal. Migrated sas codes from development to test environment and from test environment to Production.
• Provided user access and assign roles to SAS libraries. Implemented SAS Security architecture including use of access control templates and ACEs, explicit permissions, roles, SAS folder permissions, Solaris OS level permissions, SAS row level permissions, Portal permissions, Authentication Domains. Used SAS Management Console to perform administrative tasks. Monitored daily, weekly, ondemand, fiscal year jobs. Imported SAS tables db2, oracle, teradata from mainframe to sas environment on Solaris (unix).
• Managed sas access and security through Meta-Data server. Provided on-call support for sas production and development servers. Troubleshoot services that were not running and restarting the servers. Administered the sas start-up (sas.server) and stop scripts and the status of the servers.
• Connect SAS systems to other sytems such as oracle and db2. Perl script programs such as FTP and environment change. Administered subversion change control unix environment for sas codes. Performed scheduled restarts and refreshes of SAS servers on all tiers.
• Performed complete platform backups and Created users and groups for various SAS BI user interfaces/clientsDeveloped and deployed of Web Report Studio Reports, and custom SAS Stored Process Web Applications through the SAS client (including tools such as EG, WRS, IDP and AMO).

SAS Business Intelligence Specialist

Confidential, Raleigh, NC

• Task consisted of implementing and optimizing SAS products within existing infrastructures (Windows and AIX). Provided support on data quality components during the implementation of the solution architecture. Provided technical recommendations for optimized data access and retention for the data warehouse.
• Provided oversight support to the design, development and QA teams. Defined areas of improvement to optimize data flows. Designed, developed, and wrote complex and original software code, specifically focusing on reporting and Business Intelligence functions for the corporate business and analytic teams. Worked effectively with multiple operating systems and anticipated technical anomalies and enhancements for various environments; transferring and verifying reporting and interactive routines across multiple environments.
• Developed SAS OLAP reporting structures and complex dashboards using SAS portal and other dashboard technologies. Developed SAS stored procedures and interacting with SAS add-in technologies. Wrote and maintained design documents. Trained clients and users for developed systems. Reviewed, analyzed, designed, compiled, and evaluated complex data on standardization and protocols of methodology and equipment. Made recommendations to management and coordinated implementation of new equipment/methodologies.
• Ensured timely completion of projects and meeting deadlines of project. Instructed, directed and checked the work of other team members. Assisted less experience analysts in problem resolution. Designed, developed, implemented, and supported SAS Analytics applications .
• Utilized SAS Management Console for SAS Business Intelligence platform administration, including creating and maintaining user profiles, groups, roles and permissions for securing the environment.
• Installed, configured, maintained and troubleshoot SAS products including the Metadata Server, Stored Process Server, SAS Web/Mid tier components, Enterprise Business Intelligence Server, Enterprise Guide. Developed and implemented stored process programs and information maps.
• Used forecast studio, enterprise guide, enterprise miner and web studio to develop and design statistical analysis reports combine with graphs (regression analysis, variance analysis, hypothesis tests, multivariate, scales of measurement, and measures of variability reports). Published reports to SAS web.
• Developed crystal reporting and business objects reports (payment processing and claims reports) for HR. Assisted in developing DB2 data warehouse on AIX Unix system.

Confidential, Raleigh, North Carolina

Senior Database Specialist Lead

• Created users and groups for various SAS BI user interfaces/clients. Performed mid-level administration of Websphere and Tomcat such as performance tuning, configuration, troubleshooting using logs, deploying SAS web applications and applied patches when needed. Used SAS Management Console to perform administrative tasks. Within the Information Delivery Portal created Pages, Portlets and added Content. Performed server and ports troubleshooting activity when requested and modified SAS configuration files as needed.
• Responsible for planning and managing the implementation of a reporting infrastructure utilizing SAS Enterprise Business Intelligence Server. Performed scheduled restarts and refreshes of SAS servers on all tiers. Implemented SAS Security architecture including use of access control templates and ACEs, explicit permissions, roles, SAS folder permissions, Windows OS level permissions, SAS row level permissions, Portal permissions, Authentication DomainsInvolved with projects associated with meeting the reporting and business intelligence requirements of the project. Developed a work plan for Business Intelligence project and managed Business Intelligence team of thirteen staff.
• Managed the analysis development and deployment of Business Intelligence project and Report on Business Intelligence team status to the project manager. Ensured compliance with agreed upon service levels for the following activities: Change Management, Issue/Incident Management, Release Management, User Access Management, and Availability Management.
• Provided subject matter expertise related to the SAS product suite such as enterprise miner, SAS Integration Studio, Enterprise Guide, Olap suite, Management Console, SAS forecast studio, SAS/STAT, SAS web report SAS, Microsoft -Addin and SAS Access Interface.
• Responsible for deployment, installation, configuration, unix, windows, windows XP, infrastructure, architecture, systems integration, and systems administration. Designed, developed, and wrote complex and original software code, specifically focusing on reporting and Business Intelligence functions for the corporate system, risk, retail, financial, IT, commercial loan, and business groups. Responsible for providing integration and migration planning for all SAS projects and upgrades.
• Managed teams in the identification of business requirements, functional design, process design (including scenario design, flow mapping), prototyping, testing, training and defining support procedures. Provided support on data quality components during the implementation of the solution architecture.
• Executed change control and code promotion activities. Identified strategy for data acquisition and archival. Provided technical recommendations for optimized data access and retention for the data warehouse. Provided oversight support to the design, development and QA teams.
• Performed the capacity planning required to create and maintain the data warehouse and ensured consistency in data cleansing, data integrity, and data quality across all integrations with SAS data warehouse. Defined areas of improvement to optimize data flows. Worked effectively with multiple operating systems and anticipated technical anomalies and enhancements for various environments; transferring and verifying reporting and interactive routines across multiple environments.
• Worked with various business units to understand and translate business use cases and requirements into data models, analytics, and reports, and conducted demonstrations and present group recommendations to business and systems management.
• Developed SAS OLAP reporting structures and complex dashboards using SAS portal and other dashboard technologies. Developed SAS stored procedures and interacting with SAS add-in technologies. Wrote and maintained design documents. Created and maintained the data architecture within SAS to increase the robustness, performance, and scalability of RBC’s data warehouse. Trained clients and users for developed systems.
• Played a key role in the design, development, installation, operations, and enhancements of a web-based SAS Business Intelligence platform in a Microsoft O/S and Unix environments. Participated in the development and implementation of the SAS BI IT architecture and assisting the systems engineer in requirements analysis and management; responsible for the database design, development, and administration. Reviewed, analyzed, designed, compiled, and evaluated complex data on standardization and protocols of methodology and equipment. Made recommendations to management and coordinated implementation of new equipment/methodologies.
• Ensured timely completion of projects and meeting deadlines of project. Instructed, directed and checked the work of other team members. Assisted less experience analysts in problem resolution. Designed, developed, implemented, and supported SAS Analytics applications. Utilized SAS Management Console for SAS Business Intelligence platform administration, including creating and maintaining user profiles, groups, roles and permissions for securing the environment. Installed, configured, maintained and troubleshoot SAS products including the Metadata Server, Stored Process Server, SAS Web/Mid tier components, Enterprise Business Intelligence Server, Enterprise Guide.
• Developed and implemented stored process programs and information maps. Used forecast studio, enterprise guide, enterprise miner and web studio to develop and design statistical analysis reports combine with graphs (regression analysis, variance analysis, hypothesis tests, multivariate, scales of measurement, measures of variability reports). Published reports to SAS web. Developed crystal reporting and business objects reports. Assisted with Administration and transporting large SAS data sets using SPD.
• Developed logical and physical data models that capture current state/future state data elements and data flows using Erwin. Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions.
• Designed ETL objects mappings, using mapping operators, transforming data with data Stage using transformation operators. Designed process flows, deployed and populated staging area objects and populated the DB2 Enterprise Model Warehouse. Used Qualitystage to standardize data including managing and modifying rule based on business requirement.
• Designing of the data model to support the user requirements. Worked closely with analysts to understand business requirements, followed the analysis through detailed design and implementation in the underlying code. Developed unit testing and worked with the component acceptance testing teams to ensure successful release to production.
• Developed complex proc sql, macro, and data step programs. Model, design development and unit testing of the user requirements. Agreeing and Enforcing coding standards and quality control procedures. Acted as an internal consultant, advocate, mentor and change agent.
• Developed unit test construction, participated in integration testing, participated in user acceptance testing, performance analysis and deployment script development. Worked with IT and functional owners to understand the requirements and established a design, which meets the business needs and ETL Architecture guidelines.
• Support of the component and acceptance test phases investigating and resolving defects. Primary responsibility for ETL related activities; responsible for the balancing, tuning, and overall performance of the SAS Business Intelligence infrastructure; responsible for the administration and general technical management of the SAS Client-Server Environment MS Windows 2003 Servers Production & development environments.
• Participated in the production software deployments, upgrades, capacity planning, backup strategies, as well as software/hardware integration planning and will coordinate troubleshooting and make recommendations for configuration of the SAS application.

Confidential, Durham, NC

Data Warehousing Manager

• Managed teams in the identification of business requirements, functional design, process design (including scenario design, flow mapping), prototyping, testing, training and defining support procedures. Provided support on data quality components during the implementation of the solution architecture. Identified strategy for data acquisition and archival.
• Worked closely with the Data Architects and Data Integration Developers to translate the requirements into technical data specifications. Gathered, validated and documented data requirements down to the column level, in direct support of business requirements and priorities for specific data-driven and Data factory related projects.
• Assisted in the translation of business data requirements into conceptual, logical, and physical data models. Served as a liaison between the data Service Group, business group, and executive stakeholders.
• Created data maps to document data attributes to data sources and also data targets, including identification and documentation of data transformation algorithms. Identified and documented data standardizations to be performed, data enrichment operations, data validations, data security requirements, and data exception handling processes.
• Assisted in knowledge transfer to other technical staff members on business data processes.
• Provided technical recommendations for optimized data access and retention for the data warehouse. Provided oversight support to the design, development and QA teams. Defined areas of improvement to optimize data flows. Personnel engaged in development, integration and system design; reviews system development project requests; consults with users, staff, Administrators, and Managers, vendors and technicians to assess system needs and requirements; prepares activity and progress reports; assigns personnel to projects; Sets priorities; provides direction.
• Develop evaluation survey reports on faculty, staff and administrators. Develop, and build Help Desk System Application, Assessment application, faculty reports system using SAS, JAVA/J2EE, ORACLE, PL/SQL, Visual Basic, MS-Access, SAS ETL Studio, SAS Macro, ODS, SAS SQL, Business Object and Sun Solaris and HP/UX. Administrate MS SQL 2000 repository.
• Develop, build and manage the office’s university data system and enterprise data warehouse for use in institution-wide planning and reporting for the Office of Research Evaluation and Planning; identify and define information needs across the functions of the office as required for decision support, policy implementation, and external reporting; maintaining the metadata.
• Develop EPA Application System, Financial Application System and Salary Letter Signature Application System. Create a client/server environment using access database, SQL Server 6 and Novell server; upgraded Novell Operating System. Novell Administrator and Windows Administrator.