• Hands-on, results-oriented IT professional with versatile, cross-platform experience and over 15 years of proven ability to successfully lead and manage software engineering processes through the full SDLC including concepts, requirements analysis, data/system analysis and design, code generation, testing, documentation, training, support and maintenance with diverse Industry knowledge Marketing, Financial, Healthcare, Telecom, Retail and Publishing . Areas of expertise encompass:
• Software Analysis/Development ETL Development - Team Leadership/Collaboration
• Global Client Relations - Project Management
• Systems Architecture - Database and Systems Analysis/Development/Administration

Technical Proficiencies

• Platforms: UNIX Solaris, HP-UX , Windows 95/98/NT/2000/XP/2003,2008 Server, Linux Red Hat Enterprise 4 , VM/CMS, OS/390 MVS , AS/400, Oracle, Teradata
• Languages: SQL, UNIX Shell Scripting, DB2 SQL, SAS, PHP, T-SQL, PL/SQL, Ruby, C, Basic, VB, VBScript, Adabas Natural, Cobol, HTML, Perl, JavaScript.
• Tools: SQL Server: SQL Server 7,2005,2008,2012 SSIS, DTS, SSMS, MS SQL Server Business Intelligence Dev Studio, MS Visual Studio 2005
• SAS: SAS 9.3 Management Console 9.2, EG 5.1, WRS, IMS 3.1, Procs, Macros, Graph, SQL, ODS, Access, Connect
• ETL: SAP Business Objects Data Services Designer 14.1, Data Services Management Console 14.1 PDI Pentaho Data Integration ETL 3.2 4.2, Kettle, Spoon, Microsoft SSIS, IBM IIB Integration Toolkit 9.0, eOne SmartConnect 20.13
• Open Source: MySQL 5.0.45, MySQL Workbench, MySQL Administrator, SQLyog 8.14, Apache Web Server 2.2, Apache Tomcat 5.5, Automize 7, FlySpray Project Tracker, JIRA
• Oracle: EBS 11i and r12, Oracle Database 10g 11g, TOAD, SQL Developer
• System: UNIX utilities vi, vim, crontab, ftp , DB2, PuTTY, Teradata SQL Assistant, ODBC, IMS, IDMS, CICS, Jes2, Jes3, TSO/ISPF, SAP BO Data Services Server Manager Repository Manager, IBM Integration Console 9.0, Websphere MQ Explorer
• Various: MicroStrategy, Dreamweaver, SharePoint, UltraEdit, UltraCompare, PVCS Dimensions, Visual Interdev, Visual Source Safe, Visio, Crystal Reports, Easytrieve, Ghost, Lotus Notes, WinSCP, Ariba, Microsoft Dynamics GP 2013, Microsoft Office Suite Word, Excel, PowerPoint, Access, Outlook , FrontPage.

Professional Experience

Confidential

Sr. ETL Developer,

• Developing and managing ETL processes for Rural/Metro Emergency Services utilizing SAP Business Objects Data Services Designer to track and report on Accounting, Finances and Human Resources. Typically pulling data from AS/400 or SQL Server 2005/2008/2012 and transforming that data for WEBI/Crystal reports use or csv/excel files for ftp or uploads into systems such as Ariba, GP, Advance Claim, Billing, Payroll, etc..
• Working with Business Objects Data Services and Microsoft SSIS and IBM IIB and eOne SmartConnect for ETL/Mapping processing. Administrator for BO ETL Tools and backend server management as well as the IBM integration toolset. Creating and maintaining nightly job processing pulling data for reporting purposes. Handling daily data issues across several corporate systems as well as process enhancements as well as process improvement to procedures already in place. Other tools used WinSCP for ftp, SSMS for database administration as well as table manipulation and verification. Use of Excel for input data as well as data verification.

Confidential

Sr. Data Specialist,

• Working with Bank of America on a project to convert data from an existing DB2 database structure to a new more robust DB2 database. Currently performing data analysis using SQL on Teradata SQL Assistant for DB2 queries plus SAS EG and DB2 scripts ran in UNIX to dig into current tables and map to appropriate tables in the new structure. This is all put together in log files for jobs ran in UNIX and spreadsheets to present for possible issues and defects. Other project work done such as handling business requirements and client needs as well as project documentation.
• Also worked on another project creating new views/tables for group needing centralized resource for data utilizing SAS, running jobs through EG. Other responsibilities include DB2 database and table maintenance. Tools used are Tectia Tectia Secure File Transfer for UNIX access and moving files. SAS, SAS macros on SAS EG. Notepad for SQL code manipulation as well as Teradata SQL Assistant. Microsoft Office used for email and spreadsheets.

Sr. Pentaho ETL Developer,

Converting Oracle 11i packages into PDI ETL solutions. As the company converts from Oracle E-Business Suite ERB 11i to r12 as well as database versions 10g to 11g, we are developing PDI ETL transformations and jobs from Oracle 11i procedures and functions to make daily ETL processing cleaner and easy to follow. Utilizing Oracles database development tool, SQL Developer, to read packages, procedures, functions, views and tables so we can map code and tables used to create the Pentaho jobs and transformations to replace them. Involves mapping tables and fields from ERB 11i to r12 using both SQL Developer and the online Oracle eTRM to lookup the database schemas. Using Pentaho PDI Enterprise Edition 4.2.1 and Spoon for new ETL development. Current system reading encrypted files from several vendors in various formats .xls, .csv, .txt on Linux SFTP server, decrypting and then processing files through Oracle. Reverse processing for outgoing files to vendors. New PDI solution reading files from SFTP server, decrypting through PGP, ETL processing and load to new Oracle database for ERB use. Filezilla used to read and transfer files. Project documentation done in JIRA.

Confidential

Sr. BI Analyst/Developer,

• Senior level developer working with the BI SAS team to provide executive level and external reporting for the Protection Plan program. Pulling data from Teradata among other sources into SAS, for ETL processing and analysis, to design and construct SAS datamarts and reports utilizing SAS code, SQL and Procs to email internal executives as well as external partners. Also creating SAS jobs, utilizing tools such as Proc SQL, to construct files to send out to clients as well as load into Teradata. Performing development using SAS EG4 and Base SAS, using WinMerge for code comparisons, Proc Compare for dataset comparisons, and WinSCP to manipulate data files in UNIX. Using Flow Manager, along with SAS Management Console and crontab to schedule daily and weekly processing. PuTTY used to access the 4 SAS severs, all running on HP UX UNIX. Teradata SQL Assistant used to manipulate data in Teradata.
• Project analysis completed by research on plan data to estimate timeframe needed to complete data conversions.

Confidential

Sr. Database Analyst/Administrator ETL Developer,

• Senior level Database Analyst/Developer/Admin for SQL Server 2005 and MySQL environment working in Staples call center performing project work, data and processing analysis by interacting with necessary business groups, then designing and developing ETL and database setup for needed projects. Implementing enterprise wide reporting with database analysis MySQL and SQL Server using SQL and T-SQL on the backend and ETL processing utilizing both Pentaho Kettle spoon and SSIS for creation and maintenance of data warehouse in the middle layer pulling data from sources such as Oracle, SQL Server, MySQL, AS/400.
• Project work done to provide project outline, completion estimates, datawarehouse and datamart structure for new reports as well as consolidating existing company wide reporting from varying sources into one central reporting repository front end MicroStrategy PHP . In charge of all MySQL and SQL Server database administration tasks including security, granting and revoking user access, backups, designing, creating and maintaining tables, views, indexes, stored procedures using DDL and DML. Systems administrator for Windows Server 2003 running WAMP environment and also Linux running LAMP environment user access, scheduling, passwords, etc. . Scheduling jobs using Automize, SQL Server Agent and crontab.
• Sole point of contact for all ETL administration, creation and maintenance using Pentaho and SSIS.
• Setup data integrity checks across all levels of processing to test for data anomalies.
• Creation of heap in-memory tables used for faster processing.

Senior BI Analyst/Developer, Confidential

• Senior BI Analyst working with the consumer team giving insight to current and future trends of the e-commerce section of Healthgrades.com through data analysis and reporting. Wrote metric reports through SSRS for regular distribution as well as analyzed current reporting for not only data anomalies but report errors as well. Using SQL Server Management Studio for running TSQL to create quick adhocs and test current data. Helping to create standards within the consumer and BI groups. Attending scrum meetings and following Agile methods for software processes.
• Current and future data and trend analysis completed for 2009 budget estimates.
• Reported and fixed data anomalies found on several product and revenue reports giving false information to executive management.

Confidential

Senior SAS Analyst,

• Senior Analyst working with Rapid Development Team at Kaiser Permanente. Redesigning database, SAS code and scripts to take advantage of new SAS BI platform. This included assessing current system design, restructuring SQL Server database and replacing SAS code to best utilize ETL processing Using SAS macros and formats. Research queries performed on Teradata, Clarity, SQL Server Oracle using SQL in Teradata SQL Assist and SQL Server Management Studio. Also performing maintenance on mainframe processing. Working with PC SAS using EG 4 and SAS for Windows with database connections through ODBC , SQL Server, DB2, Teradata, TSO JCL.
• Converted existing production SAS code for new SAS SQL Server database design and future ETL process in short amount of time.
• Assisted in architecture of new SQL Server database.

Confidential

Lead Developer/Systems Architect,

• Lead developer for Designing Implementing new consumer database reporting system for the Consumer Modeling Analytics team using an Oracle back end of newly summarized data tables connecting to a web based SAS reporting system to replace existing Oracle SQL driven reports. Toad used for Oracle table management along with DML DDL coding. SAS tools used for coding and management of system are Management Console, Enterprise Guide, Web Reporting System Information Map Studio. Managed assisted in the installation of SAS including getting the system up and running as well as setting up the Oracle Connection along with administering the SAS system. In charge of setting up new UNIX environment running SAS. Provided documentation report updates using Microsoft Sharepoint.
• Directed Installation of SAS 9.1.3 in Win 2K3 UNIX plus maintaining the SAS operating environment.
• Took over 3 individuals monthly reporting and cut processing time by over 50 in rewrite of SQL.
• Managed lead team of contractors in process of engineering new consumer reporting system.

Confidential

DB Manager/Sr. Data Analyst,

• Working independently off-site providing data analysis and developing programs using SAS and associated tools Macros, SQL, ODS to perform data mining for purpose of creating lists, managing lists, complete high profile predictive modeling projects and update internal web interface. Maintained large Consumer Dynamics database and data dictionary on Linux platform across several servers. Use of VIM and UltraEdit for creating and maintaining SAS code and UNIX scripts, SQL for Oracle. Performed administration duties for version 8 SAS on Unix and assisted in upgrade to version 9, also performed UNIX administration.
• Use of HTML, JS, Perl with SAS to create web based reporting system table update capability
• Created repeatable processes for centralizing data from various sources and include preliminary statistical variables for high profile projects with clients such as PetSmart, Armstrong DuPont.
• Managed Consumer Database, including architecture maintenance, positioned at Acxiom.

Confidential

Consultant/Sr. Data Analyst,

• Performed data analysis, SAS development and maintenance across multiple platforms UNIX, MVS using JCL to create datasets, reports and graphs for internal use by econometricians. Created data files for use by external foreign overseas groups for ad campaigns. Generated documentation for SAS programs.
• Converted, repaired and joined foreign data across several platforms Windows, UNIX Mainframe
• Designed and developed two different Microsoft Access database programs for internal use.

Confidential

Lead Software Engineer,

• Designed, developed and delivered complex solutions utilizing advanced SAS skills Macros, SQL, ODS, Intrnet to create a data warehouse, status and waterfall reports online across several UNIX servers utilizing shell scripting, ftp, VIM and crontab utilities. Data pulled from sources such as Oracle and AS/400. Attended daily meetings for updated requirements. Ran adhoc reports as needed along with creating documentation. Used PVCS for version control and PL/SQL for Oracle access.
• Lead engineer creating online reporting system for high profile PUC Regulatory project which spanned across all 14 operating states for Qwest.
• Analyzed requirements, gathered data, wrote code to create data warehouse state specific datamarts, unit tested and documented processes for PUC project.

Confidential

Software Engineer/DBA,

• Maintained and wrote new code for stand alone system using Visual Basic accessing Oracle, Access and SQL Server databases. Tools such as Visual Interdev, FrontPage, HTML and VBScript used for maintaining and manipulating information on web and database servers.Backups done on local machine with Ghost Software. Visio used for project diagrams. Visual Source Safe used for version control.
• Performed DBA duties on SQL Server including database management and design using SQL Server 7.0 Enterprise Manager for scheduling jobs, creating stored procedures, tables and views and DTS packages. SQL Server Query Analyzer used with stored sql queries for accessing tables and views.

Confidential

Lead SAS Developer,

• Responsible for all phases of SAS development from requirements gathering to implementation. Includes new development and adhoc reporting. Use of SAS SQL for database queries plus creating views and tables for programs. Added logic to perform new requirements, unit testing on SAS.
• Managed all SAS development for team of 3 developers, including scheduling assignments and attending weekly management status meetings.
• Revamped entire HR reporting system from data gathering to final output reports in Excel after recognizing problems with existing reports and code for initial variable creation.

Confidential - Systems Analyst/Adabas Developer,

Confidential - Special Projects Lead,