Sas Administrator And Developer Resume
Rockville Windsor Mill, MD
SUMMARY:
- Chad is a Senior Consultant with over fifteen years of I.T. experience in telecommunications, financial regulations, healthcare and government.
- He has used several software packages to perform data analytics and machine learning and provide statistical models, detailed reports and presentations to the client.
- He is creative and dedicated to providing information that serves the business. He is adept at building trust between the different departments within a company, using great interpersonal and listening skills.
- With a keen awareness of cross - cultural issues, he has advised on complex issues to upper management in both domestic and outsourced settings.
- As a team player, he appreciates opportunities to mentor junior team members.
TECHNICAL SKILLS:
Operating Systems: UNIX (Solaris/IRIX/HP-UX/AIX), Fedora Linux, Windows 8
Programming Languages: SAS Macro, Perl, Python, PL/SQL, Java, T-SQL, R, Prolog Knowledge
Management Tools: Microsoft SharePoint 2010, Lotus Connections, Google Apps, FICO Blaze Advisor
Reporting Tools: SAS, Crystal Reports, IBM Cognos, Business Objects, SPSS, Oracle BI Publisher, Microsoft SSRS
Databases and Tools: Oracle, Teradata, GreenPlum, SQL Server, DB2, TOAD, SQL*Plus, SQL Query Analyzer
Desktop Software: Microsoft Office 2010 (Word, Excel, PowerPoint, Access), Windows Live Communicator, Trillian, gTalk, Open Office
Industries and Verticals: Commodity & Financial Markets, Telecommunications, Healthcare, Education, Federal Government, Regulation
Spoken Languages: Portuguese (Fluent), Spanish (Fluent), French (Reading), Italian (Listening)
PROFESSIONAL EXPERIENCE:
Confidential - Rockville/Windsor Mill, MD
SAS Administrato r and Developer
Responsibilities:
- Installed and configured SAS server and client software, ranging from JBoss application servers and web server technologies installed on Unix/Linux and Windows to end-user applications for data analysis and programming environment GUI;
- Monitored and assisted in debugging database connections via SQL database queries and other programs written in base SAS programming language;
- Verified dashboards as developed in Tableau against various end-user requirements;
- Assisted in design and verification of data warehouse in Teradata
Technologies: SAS Enterprise Guide, Oracle 11g databases and Teradata, Microsoft Office, SAS 9.4 Intelligence Platform, Tableau 9.3
Confidential - Lanham, MD
Middleware SME
Responsibilities:
- Installed and configured SAS and FICO Blaze Advisor software on client and server machines, as well as integrating with Greenplum databases in Windows and Linux;
- Monitored and assisted in debugging JBOSS application servers, for deploying and maintaining rules in FICO Blaze Advisor, as well as grid processors for SAS;
- Programmed SAS macros and shell scripts to assist predictive model development team
Technologies: IBM Rational tool suite - for change and package repository management, Pivotal Greenplum database, Microsoft Office 2010, SAS 9.3M2, FICO Blaze Advisor, JBOSS EAP 5.1, Red Hat Linux 6.3
Confidential - Washington, DC
Interactive Data Support
Responsibilities:
- Investigated prototype use of jRules, Drools and FICO Blaze Advisor for rules-based comparison of data
- Programmed T-SQL stored procedures and queries to analyze EDGAR submissions, i.e. filings of financial statements submitted quarterly and annually
- Created Perl scripts and SAS macro packages to transfer data from SQL Server databases to analyze and compare XBRL-written financial statements with data from online vendors
Technologies: Microsoft SQL Server 2008, Fujitsu X-Wand, SAS 9.2, Microsoft Office 2010, Perl 6, Python 3, Java 6, R and T-SQL programming languages
Confidential - Baltimore, MD
Sr. BIM Consultant
Responsibilities:
- Generated graphs, charts and pivot tables to compare demographics and other information about prospects, as part of statistical modeling for global financial firm
- Created reports and queries, customized features, including ETL processes, and implemented security layer in reporting platform for e-learning
- Prepared test cases for both manual and automated testing of digital audiobooks in Excel and HP QTP, using multiple Web browsers, i.e. Chrome, Opera, Firefox, IE, Safari
Technologies: Microsoft Excel 2007, Business Objects XI R3, Microsoft SQL Server 2008, JIRA ticket tracking system, Confluence wiki development application, HP QTP & Load Runner, Oracle 10g, Plateau learning management system
Confidential - Ashburn, VA
Data Mining Consultant
Responsibilities:
- Created reports and queries using data warehouse cubes to make recommendations as to customer segmentation scenarios for small and/or medium-sized businesses
- Scored prospective leads with "propensity to buy" using predictive models
- Tuned ETL processes using SAS with Informatica
Technologies: Microsoft SQL Server 2008 SSRS/SSAS/SSIS, Teradata 12 and Oracle 10g databases, SAS 9.13, Microsoft Office 2007, Informatica Power Center, Verizon Goldmine
Confidential - Columbia, MD
BI and Reporting
Responsibilities:
- Maintained and updated “Corameters”, to generate reports on billing and sales data using SAS macros, DTS 2000 packages and SharePoint document repositories
- Created reports in SSRS 2005 for use within the Financial Hardship application
- Saved US$1000’s by restructuring SAS licensing contract to remove unused components
Technologies: SAS v8.2 macros and packages, Microsoft Office 2003, SharePoint, SQL Server 2000 DTS packages and SSRS 2005, Oracle 10g with PL/SQL & MySQL databases, Active Perl, Cognos Power Play, FICO Blaze Advisor
Confidential, Crystal City, VA
Data Mining Specialist
Responsibilities:
- Provided Java and XML training related to BI Publisher, in OBIEE
- Created stored procedures to work on data in databases on different virtual machines
- Created prototype reporting capabilities via XML programming and stored procedures in Oracle PL/SQL to be used at the US Department of Agriculture
Technologies: Oracle 11g OBIEE/BI Publisher and PL/SQL, VmWare
Confidential - Rockville, MD
Knowledge Discovery Specialist
Responsibilities:
- Provided alert detection and analytics to managers in Market Regulation department through Advanced Detection System, pattern-matching software developed by Mantas
- Received NASD President's Award for work on the proposed regulatory structure for a joint venture between the London Futures Exchange and the NASDAQ Stock Market
- Created and updated SQL Reports in Cognos Impromptu for varied reporting needs
- Created and updated several Excel spreadsheets using SAS macros and SQL queries, as well as VBA macros, to report on fraud scenarios encountered in financial markets
- Loaded broker firm order data into tables in Oracle using ETL process and SQL queries
- Created programs using PERL to analyze and visualize data in Excel spreadsheets
Technologies: Oracle 8i/9i databases, Active Perl, Microsoft Office 2000, SAS macros and packages, MANTAS pattern-matching, TOAD, SQL*Plus, ASP.Net