Newsletter Developer, Resume
Boston, Ma
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
Newsletter Developer,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.