Cognos Report writer / SQL, PL/SQL for Oracle

SUMMARY

An analytical, detail-oriented, and results driven professional with extensive experience using SDLC on different applications, development, end-to-end system testing and customer support. Areas of expertise include testing, development, execution, automation, system administration, debugging, trouble shooting and technical support in a variety of technologies (Oracle, SQL, PL/SQL, IBM Cognos etc.). Strong communication skills across all levels of users. Created reports in an FDA regulated environment.

Six Sigma White Belt certified.

US Citizen.

TECHNICAL

Databases: Oracle, DB2, IDMS

Languages: PL/SQL, SQL, COBOL II, JCL, UNIX Scripting, Micro Focus COBOL

Tools/Utilities: TOAD, PL/SQL Developer, Oraload, SQL*Plus, IBM Cognos Query and Report Studio,

Autosys, Data Mirror, VI Editor, FTP, Oracle Forms, MS VISIO, TSO, ISPF, JCL,

File-Aid and Sync Sort

PROFESSIONAL EXPERIENCE

BAXTER HEALTHCARE CORPORATION, IL

Quality Data Analyst as a Consultant Sept. 2010 - December 2015

Implementation of complex updates for the highly visible and detail oriented Closure Verification Processes. Analyze, update and implement queries and processes proactively using SQL, PL/SQL, COGNOS Report Studio and Query Studio.

Interacted and supported Onshore and Offshore resources on Oracle Data Warehouse and COGNOS Team.

Develop various reports to clearly measure and communicate complaint trending data.

In-depth usage of various functionalities of IBM Cognos Tools.

Utilize Oracle Data Warehouse for extraction, analysis and formatting of complaint data into charts and Pivots.

Participate and provide technical input across meetings.

Undertake and interact with cross functional and various users on the projects.

Proactively streamlined reports and processes to reduce processing time.

Sr. Programmer Analyst April 2006 - August 2010

Performed requirement gathering, analysis, coding, testing and implementation of various projects/tasks for data extracts and updates following SDLC processes using SQL queries and PL/SQL packages, procedures, functions, triggers, dynamic sql, oraload and utl_file on Oracle Data Warehouse/UNIX platform. The projects included federal and commercial sales data for government, Territory Budget Group Sales Summary load, GL detail transactions trigger, BPS Velocity reporting project, Ad-hoc requests.

Provided 24/7 support within SLA and enhancements to maintain up-time, for Medical Products Oracle Data Warehouse production systems on UNIX platform. Involved debugging, fixing, implementing updates to complex PL/SQL packages, procedures and functions.

Prepared and tested SQL scripts during Oracle upgrade.

Reduced overall cycle-time and manual processing of the complex Hyperion extract process for the corporate Finance group.

Frequent interaction with external vendors (Market Initiatives Inc., Tpsnet Inc., Hibicc Inc., McKesson Corp., etc.) to inquire about data issues, streamline process changes and stabilize FTP issues.

Primary SME for administration and end-user support of functional and technical activities for validated PVCS Application.

Planned migration of a validated PVCS system residing on Round Lake server to Boulder at IBM. Prepared communication plan, designed test plan, test cases and documented Change Control process.

Participated in project planning, analysis, coding, system testing and implementation of Transfusion Therapy’s Blackhawk project involving spinning off the blood transfusion business to Fenwal Inc.

U.S. CELLULAR - Itasca, IL February 2006 – April 2006

IT Consultant

Analyzed, coded, tested and debugged Unix based Micro Focus COBOL programs using embedded sql for Agents Billing and Commission system

CAP – COLLEGE OF AMERICAN PATHOLOGISTS - Northfield, IL May 2005 – December 2005

IT Consultant

Requirements analyzed, created test cases/plan, coded, tested, debugged and implemented project. Performed using UNIX and Net Express 3.1for Micro Focus COBOL programs with embedded sql.

UNDERWRITER LABORATORIES - Northbrook, IL February 2003 – March 2005

Sr. Programmer Analyst

Improved runtime of batch and online processing by gathering and analyzing business requirements for the purging of data in the legacy system leading to enhanced system performance.

Developed Ad-hoc batch COBOL and PL/SQL reports.

Analyzed, designed and developed invoicing interfaces to load 11i Oracle Order Management Module staging tables.

Participated in loading PeopleSoft AR open items to Oracle AR during the conversion from PeopleSoft to Oracle Financials.

GALILEO INTERNATIONAL / CENDANT CORP. - Rosemont, IL May 1989 – December 2002

(Formerly Apollo Travel Services and Covia Partnership)

Sr. Programmer Analyst

Responsible for development, implementation and support of the batch and online system applications for the extract of travel agency transactions..

Designed and developed annual purge process for Invoice Billing System in Oracle

Participated in migration of batch processes for Sales Support and Invoice Management System from UNIX server in Rosemont to the new server in Denver.

Reduced inefficiencies and controlled error-processing by documenting and automating entire manual processes handed over by prior programmers for Invoice management system.

Provided support of the Sales Support and Invoice Management System Helpline.

Supported and enhanced Oracle based interface programs between Sales Support system to Dart system of IBM.

Programmer Analyst Position at June 1985 – April 1989

G.E. CAPITAL AUTO LEASE, Barrington, IL and

UNITED AIRLINES, Elk Grove Village, IL

PROFESSIONAL DEVELOPEMENT

PL/SQL Programming Units

COGNOS Reporting

cGxP Regulated Training

Introduction to Data Stage Basics

Introduction to Oracle Financials

UNIX Scripting (HP-UX)

Six Sigma White Belt

ITIL Methodology

EDUCATION

B.A in Business Management, Northeastern Illinois University, Chicago, IL

B.S in Computer Science, Northeastern Illinois University, Chicago, IL

B.S. in Accounting and Auditing, Bombay University, India

Contact this candidate