DB2 SQL/Brio Developer/Analyst Resume

SUMMARY

Extensive IT experience as an applications developer/analyst (primarily z/os) including all phases of the SDLC for batch and online database applications using both mainframe and PC based tools.
Experience includes 2 years as a z/os applications DB2 Database Administrator as well as developing and maintaining client/server applications.
Possess strong analytical, technical, debugging, organizational and written communication skills. Received numerous service awards and high performance ratings.
Provided DB2, SQL and BRIO IT support for IBM’s Latin America (LA) Business Partner Sales Reporting
Performed extensive data source research on numerous LA billing systems
Redesigned and consolidated 50 Brio reports into 10
Enhanced all Brios based on new business requirements including performance improvements
Analyzed all Brios for common functionality and designed the technical solution
ransferred into IBM’s DBA Solution Center in support of a major healthcare account.
Key member of the V8 upgrade team: Built new V8 testing environment, created/executed detailed test script for V8 CM, NFM and V7 fallback testing as well as assisting in actual CM and NFM upgrades for several sub - systems.
Created the accounts first SQL Stored procedures. All work completed wif no formal SP training.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

DB2 SQL/Brio Developer/Analyst

Responsibilities:

Provided DB2, SQL and BRIO IT support for IBM’s Latin America (LA) Business Partner Sales Reporting
Performed extensive data source research on numerous LA billing systems
Redesigned and consolidated 50 Brio reports into 10
Enhanced all Brios based on new business requirements including performance improvements
Provided support for phase 2 automation (translation of Brios to SQL):
Analyzed all Brios for common functionality and designed the technical solution
Designed new DB2 tables to store various billing systems data in 1 central repository
Designed and developed complex SQL
Developed numerous export (z/os) and import scripts (linux)
Performed extensive unit, regression and volume testing
Provided user/UAT support
Provided ongoing development and maintenance of SQL and Brio reporting
Received 3Q Service Excellence award (2011)
Efforts resulted in vast improvements in data quality

Confidential

Brio Developer

Responsibilities:

Development and maintenance of Hyperion Intelligence Explorer (8.3) reports including dashboard and Javascripting in support of IBM’s internal Business Partner Sales Metrics account.

Confidential

z/OS Applications DBA

Responsibilities:

Transferred into IBM’s DBA Solution Center in support of a major healthcare account.
Key member of the V8 upgrade team: Built new V8 testing environment, created/executed detailed test script for V8 CM, NFM and V7 fallback testing as well as assisting in actual CM and NFM upgrades for several sub-systems.
Created the accounts first SQL Stored procedures. All work completed wif no formal SP training.
Provided environment support: Space allocation alters, reorgs, enhanced DBA written jobs thru the use of REXX and non-DB2 utilities to halp identify operational problems.
Built a new test environment to support a major client project.
Worked on various assignments dat included the creation of new db2 utility jobs, DB2 object create and maintenance, batch QMF, developer support, and writing of technical procedures for the DBA team.
Modified 300+ copy and reorg utility jobs to adhere to new standards for the account.
Assisted the AIX DBA part-time for several months: Wrote several technical design documents, created import, export, runstats and FTP scripts and built DDL for several new tables.
Provided production support on rotating basis
Received several awards (from team members and the application owner).

Confidential

Programmer/Analyst

Responsibilities:

Development, maintenance and support of DB2 queries, reports and processes for IBM’s Worldwide Financial Reporting Data Warehouse (FCW).
Development of new system (DB2/AIX) to sunset FCW using IBM’s ETL tool, Websphere DataStage. All work completed wif no formal DataStage training.
Produced monthly and adhoc reports using QMF, SQL, BRIO and EXCEL.
Tuned queries and streamlined several monthly processes/reports.
Provided DB2/QMF/SQL support for team members and end users.
Developed and maintained reports used by managers to evaluate the performance of sales representatives.
Created procedure documents for key processes under my responsibility.
Received several awards (from team members and the application owner).

Confidential

Programmer/Analyst

Responsibilities:

Development, maintenance and production support of COBOL and DB2 applications for the Pathmark account.
Research and development of EDI NEX applications to receive DSD invoices and return acknowledgments and adjustments. Set up a test environment using DataInterchange (DI) and Information Exchange (IE). All work completed wif no formal EDI training.
Executed and coordinated EDI NEX testing wif DSD vendors.
Trained customer to setup vendors in production DI and IE environments.
Received several awards (from team members).

Confidential

Programmer/Analyst

Responsibilities:

Development, maintenance and support of COBOL, DB2, CICS and Visual Basic applications for the Confidential account (Retirement Plan System/RPS).
Performed various basic DBA functions: DB2 Utilities, Explains, Omegamon.
Responsible for test database loads, adhoc SQL and coordinating DB2 table changes wif the DBA.
Major contributor in all aspects of the project life cycle for RPS. Responsible for analyzing business requirements, occasional writing of business requirements, logical/physical design, developing specifications, coding, testing, debugging, preparation of test plans, documentation, installation requirements and user/production support.
Developed a new Visual Basic application to automate production of a Death Benefits Summary Letter. Application involved the integration of VB wif Word and Excel documents using macros. Application enabled users to produce a letter wifin 5 minutes. Manual production of the letter required 2-3 hours. All work completed wif no formal Word/Excel macro training
Responsible for coordinating major installations as well as being a main technical contact for the team.
Provided year-end/annual processing and weekly production support on a rotating basis.
Received several performance awards and an Confidential stock option award in recognition for significant contributions made to various projects.

Confidential

Programmer/Analyst

Responsibilities:

Application development for RPS using DB2, COBOL, CICS, PWB/XDB and ADW.
Application development, maintenance and production support for Prudential's accounting and investment processing/reporting system using COBOL, IDMS and ADSO.