TECHNICAL SKILLS

Databases: Oracle 11g, SQL Server 2012, SybaseLanguages: SQL, T - SQL, PL/SQL, Groovy, Java, Javascript,

PerlOS: Mac Pro, Windows Server 2008, Linux, AIX, HP-UXTools: Pentaho Enterprise, Microsoft BI, Business Objects, Crystal Reports, Constant Contact (Email Marketing)

Personal Qualities: Thrives on teh independent challenge of setting and exceeding goals

PROFESSIONAL EXPERIENCE

Confidential,

Responsibilities:

• Develop Email Newsletters, providing content including images and links, to engage contacts

Confidential, Boston, MA,

Responsibilities:

• Analyze and drive reporting requirements, working closely with end users and other project team members.
• Perform hands-on design and development of web-based reporting and analysis using Pentaho Enterprise 5.3 and Oracle 11. Rebuild existing reports using Pentaho 6.1 CTools which provides much better visuals.
• Scripted in Groovy, Java, Javascript and Beanshell for multi-tenant environment in Pentaho
• Build and execute test cases working in an agile environment.
• Support and maintain existing reports.
• Create and deliver end-user and documentation and provide second-line support to power users who develop reports on behalf of their departmental colleagues.

Confidential, Westford, MA,

Responsibilities:

• Provide client support using Citrix Receiver applications, SyteLine, Omnify. Insite Ship.
• Adjust Crystal Reports as per new specifications, modify Store Procedures, create users, add new Parts, provide user and group analysis to be viewed in Excel.

Confidential, Watertown, MA,

Responsibilities:

• Create stored procedures for Warehouse development of Fact and Dimension tables for Business Intelligence providing specifications and design.
• Develop cubes in SQL Server Analytical Services (SSAS) for teh Call Center, Member Enrollments, Staffing Tool (member assessments) and Pharmacy Claims analytic.
• Develop and maintain automated processes, includes coding of batch files from SFTP site, uploading daily member information, and pharmacy claims, and restoring backup database to production.
• Convert comprehensive evaluations from JSON format to Individualized Care Plans (ICP) using ETL packages in SQL Server Integration Services (SSIS).
• Create reports in SQL Server Reporting Services for teh Pharmacy and Call Center groups.

Confidential, Boston, MA,

Responsibilities:

• Designed, implemented and tested new SQL procedures for Responsys Integration Product.
• Automated nightly composition of data from Production warehouse in SQL Server to be transported via STFP to new site in CSV format for upload.
• Downloaded data from same site for uploading back to Production.
• Implemented procedures for incremental uploads.
• Developed reports for Marketing in Business Objects providing email campaign information.

Confidential, Boston, MA,

Responsibilities:

• Created SQL and PL/SQL scripts for data migrations, procedures, functions, triggers and reports for accuracy and integrity as required for Development releases and internal Management requests.
• Constructed Schema data modeling architecture using Pentaho data modeling tool.
• Designed charts and graphs for visual analytics using Google API to reflect trending data at external site: pulsedata.experience.com to increase company sales.
• Coded scripts for all archiving storage of production data to be utilized for analytics in teh WAREHOUSE Database.
• Created and refreshed Warehouse ETL, OLAP cubes and dimensions used with OPENI and reporting for internal and external data analysis providing optimal performance and accuracy.
• Automated redundant database cleanup procedures and fixed any database related issues for Client Services.
• Issued production database periodically for use in Development, Quality Assurance and Staging environments.
• Performed as teh lead for migration of Production databases and Standbys from Oracle 10.2.0.3 to Oracle 11.2.0.3 (and 9.2.0.6 to 10.2.0.3) in order to minimize site down time.
• Created and maintained Real-Time Downstream Capture database and target for external Reporting in Oracle 10.
• Reconstructed large tables using materialized views, partition and sub partitioned tables using package DBMS redefinition with space management.
• Monitored, maintained and migrated data in various Production, MySQL and PostgreSQL databases.
• Performed as teh lead for test migration of Oracle Warehouse databases to MySQL and Oracle Production data to Enterprise DB.
• Developed automation scripts using Bash and Shell

Confidential, Lexington, MA,

Responsibilities:

• Monitored and maintained general health of warehouse environment databases.
• Established backup and recovery procedures using RMAN.
• Created and monitored a standby database using Data Guard and provided documentation to explain step-by-step procedures.
• Optimized teh database transaction rate by writing efficient SQL and PL/SQL statements working with Explain Plan.
• Implemented development programs for more efficient SQL statement execution creating partitioned indexes.
• Developed Web Interfaces in HTML, Perl CGI and JavaScript with simplicity for teh end users.

Confidential, Hanscom AFB, MA,

Responsibilities:

• Provided reports as requested using Crystal Report 9 using DB2 table data.
• Upgraded Windows 2000 server, installed user applications and provided trouble-shooting to resolve user issues.
• Created supplemental documentation for XP2 morning and afternoon schedule procedures.
• Provided weekend coverage and created procedures to support both off-hour system maintenance and user support.
• Created Excel spreadsheets to monitor user Internet usage.
• Performed periodic temporary work assignments as a DBA Administrator utilizing Oracle, Sybase and SQL Server.

Confidential

Responsibilities:

Database Administration,

• Performed Database Administration tasks (installation and configuration of Sybase, Oracle and SQL Server) for Oracle and Sybase on various UNIX platforms, Oracle and SQL Server on NT and WINDOWS platforms.
• Collaborated with Development/QA/Support Engineers to identify solutions to any database problems
• Performed Benchmarks and Performance Testing utilizing a 120G Oracle 8i database.

Quality Assurance Engineering,

• Designed and tested automated test structure for InConcert C/C++ Application Program Interface (API) binding across all supported hardware and compilers.
• Implemented and executed all automated API Bindings tests to run against current releases on all platforms.
• Initiated and created a new Test Plan for InConcert Java API bindings.
• Coordinated Test Plan design for new product implementations with teh Development team and provided Database and OS skills to teh Development and QA teams for resolution and testing.

Systems Administration,

• Configured and maintained teh enhancement of data integrity and performance for a distributed computing environment comprising of Sun’s, HP’s, Alpha’s, RS6000’s, PC’s on a TCP/IP net secured by a UNIX Gauntlet.
• Installed Firewall software and V-ONE VPN software for security and managed NIS, DNS, SMTP, and NNTP.
• Established backup and Disaster Recovery procedures and installed OS, C/C++, GCC compilers, Clear case, etc. on internal server and client workstations.
• Identified and corrected problems in system and application software and provided consulting support and assistance to teh user community.