Professional Summary
Highly motivated professional with extensive experience installation, maintaining, and implementing the SAS 9 Enterprise Business Intelligence platform. Managed systems administration, data integration, data warehouse architecture, and ETL process development. Developed different methods to present and analyze business critical information through BI dashboards and web-based reporting. Supported and mentored end users to facilitate the growth of business intelligence. Performed various SAS server and client tier installations in both Windows and UNIX environments for different solutions. Worked with many functional areas within multiple companies to develop effective reporting and analytical solutions. Strong educational background in Industrial & Systems Engineering from NC State, Six Sigma Black Belt certification, and SAS BI Content Developer Certification. Able to solve non-routine problems and make data driven decisions to optimize business processes. Able to organize thoughts into hierarchies and form abstract ideas. Strong technical background across multiple operating system environments with understanding of relational databases, data warehousing, MIS, Base SAS, OLAP, dashboards and data visualization techniques. Strong analytical skills with the ability to see the big picture and assess possible stakeholders. Able to provide statistical and quantitative analysis to make data-driven decisions. Passionate about productivity, quality, strong leadership, and intelligent decisions.
Specialties
- SAS Business Intelligence and Data Warehousing Solutions
- Certified SAS BI Content Developer
- Certified Six Sigma Black Belt
- North Carolina EIT Licensing
Industries
Consultant
Zencos Consulting LLC, Cary, NC
May 2011 - Present
Develop Business Intelligence applications using SAS BI. Develop Data Warehousing applications using DataFlux Data Management Studio. Develop reporting applications using OLAP cubes, dynamic web-based dashboards, and web-based reporting. Develop custom Dashboards with SAS Information Delivery Portal leveraging SAS stored processes, SAS Web Report Studio, and SAS Information Maps. Gather technical requirements, build system designs, and manage resources to implement the design. Improve performance of OLAP cubes through the use of aggregation table design. Develop calculated members to support complex reporting needs through use of MDX statements. Assist with SAS GRID deployment and migration. Perform various SAS server and client tier installations in both Windows and UNIX environments for different solutions.
SAS BI Developer
Genworth Financial, Raleigh, NC
March 2010 - May 2011
Implemented reports off high data volumes using sound design principals to ensure optimal performance. Adopted and communicated new concepts, ideas, best practices and provided technology assistance. Ensured consistency in data cleansing, data integrity, and data quality across all integrations within the data warehouse. Worked with various business units to understand and translate business use cases and requirements into data models, analytics, reports and scenario models. Provided leadership, guidance and mentoring on SAS Enterprise BI Server issues and technologies. Conducted demonstrations and presented group recommendations to business & systems management. Maintained awareness of technological advancements and made recommendations where appropriate.
Business Intelligence Analyst
Connexion Technologies, Cary, NC
May 2008 - March 2010
Developed dashboard indicators, OLAP cubes, web-based reporting, and analytical tools using the SAS Business Intelligence platform. Developed ETL jobs to load statistical data marts to provide end users with self-service reporting capabilities. Defined processes from end to end to understand major drivers of quality. Identified stakeholders, boundaries, goals, and key areas for improvement using process engineering background as well as Six Sigma methodology. Interacted with key business leaders to fulfill business and functional requirements using multiple key information systems. Gained extensive experience using the SAS Enterprise BI platform from end to end (systems administration, data modeling, application development, analyst, end user support). Worked directly with CEO and CFO to facilitate the acquisition of over $100 million in funding from different sources through different reports and analysis.
Process Engineering Manager
Connexion Technologies, Cary, NC
December 2006 - May 2008
Incorporated lean six sigma principles to improve overall customer responsiveness and reliability. Started as a Process Engineer then promoted to a management position as the company grew and data models became more complex. Prepared Operational, Executive, and CEO level reports through the use cross functional interns. Facilitated weekly root cause analysis discussions through accountable parties and drove corrective actions to improve. Interfaced with the Network Operations Center, Call Center, and Field Operations to ensure initiative success by establishing appropriate accountability. Established key performance indicators, measured and analyzed through weekly reporting, then drove actions to improve through key stakeholders.
Publications
2011 SAS Global Forum
Education & Training
North Carolina State University
North Carolina Board of Examiners
- North Carolina EIT Licensure: Certificate # A-22566 (December 2006)
Aveta Business Solutions
SAS Training
- DataFlux Data Management Studio Basic & Advanced Training (May 26, 2011)
- SAS Macro Language 2: Developing Macro Applications (March 4, 2011)
- SAS BI Content Developer Certification (May 2010)
- Working with Slowly Changing Dimensions (September 16, 2009)
- Using SAS Web Report Studio for Thin-Client Reporting (August 27, 2009)
- SAS BI Dashboard: Developing and Using Dashboards (June 12, 2009)
- SAS Programming 1: Essentials (March 13, 2009)
- Querying and Reporting with Enterprise Guide (February 19, 2009)
- SAS 9 Data Integration Fast Track (February 6, 2009)
- Overview of Business Intelligence and Data Integration (November 18, 2008)
SAS Workshops
- Data Mining (August 20, 2009)
- Data Integration (August 19, 2009)
- Business Visualization (August 19, 2009)
- Business Intelligence (August 18, 2009)
Other Training
Personal Acheivements
- Mastery of Piano (15 years)
- Treasurer of Ridgecroft Homeowners Association (October 2007 - August 2009)
- Runner up in Senior Design Project (December 2006)
- Black Belt in Tae Kwon Do (March 1998)