We provide IT Staff Augmentation Services!

Software Engineer Resume

NJ

Summary

Highly motivated self-starter and quick study with more than 9 years Database and BI experience in both SQL Server and Oracle Environments, T-SQL and PL/SQL Development, Data Warehouse/BI Development, Actuate Server Administration, and Actuate Report Development.

Computer Skill Set

PL/SQL, T-SQL, Microsoft SQL Server 7-2008, SSRS, SSIS, SSAS, Oracle 8i-10g, Access, Unix, Linux, Windows 9x – 7, TOAD, SQL Navigator, SQL Plus, SilkTest, Talend, AccuRev, Hudson, Cruise Control, XML, C#, Java, HTML, VSS

Actuate Skill Set

iServer, ERD Pro, Active Portal, Management Console, Page-Level Security, Actuate Basic, Bursting Reports, Crosstab Reports, Charts/Graphs, Configuration Files, Actuate Libraries, Information Object Designer

Work Experience

Confidential

Software Engineer

  • Workforce Central Datamart Development
  • Worked on an Agile team tasked with development of enhancements for the Workforce Central Datamart including real-time processing, multi-source/tenant, and multi-language capabilities. This development effort encompassed enhancements to databse structure, ETL procedures, wrapper scripts, configuration tools, cubes, and reporting. All database procedures were modified for both Oracle and SQL Server versions of the Datamart.
  • Re-factored the core Time-Summary ETL process that feeds reporting tables and SSAS cubes. This provided a solid baseline for future development and testing scenarios.
  • Healthcare Datamart Development
  • Worked on an Agile development team tasked with the development and high level support of the Workforce Central Healthcare Datamart. The development of the Healthcare offering included coding for the requested healthcare metrics including Labor-Cost Management and Workforce Productivity.
  • Miscellaneous Contributions
  • Modified our internally developed datamart configuration tool (.NET) to accommodate new multi-source/tenant features in the datamart.
  • Migrated our development Cruise Control Build jobs to a New server using Hudson.
  • Created a dynamically configurable Smoke-Test Environment utilizing a custom SilkTest job to automate nightly and ad-hoc development builds and notifications.

Confidential

Database/Report Developer

  • Database Administration/Development
  • Primary SQL Server Administrator responsible for creating new databases, users and other database objects and all production, QA, development and UT database environments.
  • Responsible for database backups/recovery, monitoring of database resources, security, development and scheduling of other database jobs in addition to the support of SQL Server database related issues.
  • Develop DTS and PL/SQL Packages for data migration and extractions. Develop stored procedures for report development and other ETL processing.
  • Perform on-call pager duty in support of MS SQL Server and Oracle database production environments.

Report Development

  • Gather business technical requirements and developed reporting design and layout.
  • Develop/Test reports (including transactional, analytical, billing, and monitoring) for internal and external customers using T-SQL, PL/SQL, Actuate ERD Pro, and other tools.
  • Troubleshooting reporting issues within the production Actuate/SQL Server/Oracle environments.

Report/Actuate Administration

  • Administer Actuate iServer, Implement report executables, security roles, security access, report scheduling, email notification through iServer, SQL Server or an Oracle database.
  • Work with UI group to integrate our products user interface with iServer via SOAP/API/Java.
  • Performed migration and implementation of new reportingversions(ActuateiServer/Active Portal 6 through 8sp1 fix 10).
  • Mary SQL Server Administrator responsible for creating new databases, users and other database objects and all production, QA, development and UAT database environments.
  • Responsible for database backups/recovery, monitoring of database resources, security, development and scheduling of other database jobs in addition to the support of SQL Server database related issues.
  • Develop DTS and PL/SQL Packages for data migration and extractions. Develop stored procedures for report development and other ETL processing.
  • Perform on-call pager duty in support of MS SQL Server and Oracle database production environments.

Report Development

  • Gather business technical requirements and developed reporting design and layout.
  • Develop/Test reports (including transactional, analytical, billing, and monitoring) for internal and external customers using T-SQL, PL/SQL, Actuate ERD Pro, and other tools.
  • Troubleshooting reporting issues within the production Actuate/SQL Server/Oracle environments.

Report/Actuate Administration

  • Administer Actuate iServer, Implement report executables, security roles, security access, report scheduling, email notification through iServer, SQL Server or an Oracle database.
  • Work with UI group to integrate our products user interface with iServer via SOAP/API/Java.
  • Performed migration and implementation of new reporting versions (Actuate iServer/Active Portal 6 through 8sp1 fix 10)

Confidential

Information Security Specialist

  • Responsible for performing regular systems security access audits.
  • Responsible for the coordination of material for Federal regulatory, internal, and customer audits.
  • Maintained documentation of banks IT policies and procedures.

Hire Now