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, DB2, MS SQL Server, SQL, PL/SQL, IBM Cognos etc.). Strong communication skills across all levels of users. Created reports in an FDA regulated environment.

TECHNICAL SKILLS:

Databases: Oracle, MS SQL Server, DB2, IDMS

Languages: PL/SQL, SQL, SQL Server, UNIX Scripting

Tools: /Utilities: SQL Server Management Studio, IBM Cognos Query and Report Studio, TOAD, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, IL

IT-Data Analytics / SQL Developer

Responsibilities:

• Responsible for exploratory data analysis and insights to help plan, measure, and optimize business data needs.
• Responsible for primary research to provide insights to help develop and support business solutions.
• Utilizes SQL Server database querying with SQL Server Mgmt Studio, data manipulation and statistical analysis at different stages of data extracts to provide critical business support.
• Evaluate ongoing analytics needs from stakeholders and provide customized data sets.

Confidential, IL

IT-Data Analytics / SQL Developer

Responsibilities:

• Analyze pharmacy claims history data, data elements and applicable data integrity with due diligence for new client group imports from health insurance carriers/providers, and/or managed care/benefit management.
• Import extracts, map / convert, load / match iteration of claims history records with eligibility to get the better match rate for Implementation Project Manager to smoothen move to production profile.
• Develop, unit test and implement SQL Queries using iNavigator at different stages of data loads.
• Document progress of stages of loads on SharePoint and MS OneNote.
• Interact with various stakeholders include customer implementation teams, vendors etc.

Confidential, IL

PL/SQL Developer / Cognos Report Writer

Responsibilities:

• 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.
• 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.

Confidential - Northbrook, IL

Sr. Programmer Analyst

Responsibilities:

• 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.

Confidential

Sr. Programmer Analyst

Responsibilities:

• 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.