We provide IT Staff Augmentation Services!

Newsletter Developer, Resume

2.00/5 (Submit Your Rating)

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
BI Report Developer,

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.
SQL Database Support,

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.
SQL Database Developer,

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.
SQL Database Support,

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.
Database Administrator/Development Support,

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
Oracle Database Administrator

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.
Database Specialist,

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.
IT Support,

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.

We'd love your feedback!