We provide IT Staff Augmentation Services!

Database Developer / Technical Lead Cognos Development Resume

TECHNICAL SKILLS

Languages: Java, J2EE/EJB, JSP, JavaScript, ASP, VBScript, HTML, XML, XSLT, CSS, SQL, Transact SQL, Visual Basic 5 and 6, bash, python, groovy

Database: Sybase ASE 11 & 12, Microsoft SQL 7 Server, MySql, DB2 10, Postgres, RDS

Platforms: Windows, Unix, Linux

Tools: Cognos Framework Manager, Cognos Query Studio, Cognos Report Studio, Cognos Connection, Cognos Administration, Cognos Configuration, Jenkins, Amazon AWS, Eclipse, vi, ER Studio, Erwin, Visio, SVN, Git, Putty, Pageant, DataStage Director, db2advis, Ansible, DataStage

PROFESSIONAL EXPERIENCE

Confidential

Database developer / Technical Lead Cognos Development

Responsibilities:

  • Maintained and supported the Cognos frameworks including designing, importing and exporting.
  • Maintained and supported Cognos application.
  • Designed and supported Cognos reports.
  • Gathered requirements for enhancements
  • Managed team of developers to drive resolution of reports cases and troubleshoot defects from all parts of the workflow, including replication, ETL, framework, reports, scheduling, permissions, and automated processes.
  • Supported the application database by performing qa builds, hotfixes and production releases primarily in DB2 and some Postgres
  • Designed an automated build processes similar to Liquibase, using ansible, git, and shell scripting via Jenkins for database releases. Maintained and supported this functionality.
  • Helped to migrate system to Amazon AWS
  • Designed scripts for importing/exporting Cognos packages via the command line
  • Supported Datastage ETL
  • Supported DB2 Replication
  • Analyzed other BI tools such as Tableau, Snowflake, and Power BI as a potential alternative to Cognos

Confidential

Database developer / Technical Lead Cognos Development

Responsibilities:

  • Redesigned the Cognos framework from scratch to improve report accuracy and performance.
  • Part of a team that re - modeled the Cognos datamart.
  • Developed application code to connect from the main application dashboard via links to Cognos packages and reports via SSO as well as the application code to support future addition of links via a configuration console.
  • Maintained and supported the Cognos frameworks, including designing, importing and exporting.
  • Maintained and supported Cognos application.
  • Designed and supported Cognos reports.
  • Managed team of developers to drive resolution of reports cases and troubleshoot defects from all parts of the workflow, including replication, ETL, framework, reports, scheduling, permissions, and automated processes.
  • Supported the application database by performing qa builds, hotfixes and production releases primarily in DB2.
  • Assisted in upgrading Cognos from 8.4 to 10.2.
  • Maintained and upgraded authentication provider java code for Cognos via the SDK
  • Maintained and upgraded java code to build folders in Cognos via the SDK
  • Supported Datastage ETL
  • Supported DB2 Replication

Confidential

Java Developer

Responsibilities:

  • Resolved defects and tier 3 level support cases
  • Led Crystal Reports team. Reviewed requirements documents and code. Was responsible for installing/releasing reports.
  • Developed new application functionality in java.
  • Provided troubleshooting for Cognos database development. Implemented framework changes. Created and maintained Cognos reports.
  • Maintained authentication provider java code for Cognos via the SDK
  • Maintained java code to build folders in Cognos via the SDK

Confidential

Java Developer

Responsibilities:

  • Primarily responsible for a vast transactional mortgage trading system
  • Managed and maintained multiple applications throughout their entire life cycle - from design through implementation, including database development, coding and QA.
  • Mentored and trained new team members in the business and technical aspects of the system
  • Extended functionality to add new products and business logic
  • Added new applications to meet the emerging needs of the trading desk, such as an expenses tracking system with overnight feeds to external reserve handling systems
  • Continued to support and test all aspects of the system
  • Worked with end users to meet their needs

Confidential

Java developer

Responsibilities:

  • Worked with a small team (5 developers) to design, develop and maintain components in a complex trading system that tracks mortgage-backed assets
  • Developed whole applications: JSP/struts front end, EJB middle tier and Sybase backend
  • Integrated internal tracking system with mainframe trading system through TIBCO middleware
  • Redesigned database to improve both OLTP and OLAP performance
  • Scripted port of several million records into redesigned database
  • Migrated legacy Visual Basic applications to Java
  • Supported both the business and technical aspects of the system

Hire Now