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

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship