Software Development Business Intelligence

OBJECTIVE

Experienced information technology professional in search of a position that allows me to apply my management and technical skills to achieve corporate goals, develop improved processes for managing IT requests and accomplish projects in a more efficient way

SUMMARY OF EXPERIENCE

Over 27+ years of IT experience in analysis, design, development, testing & implementation

Bringing forth expertise in managing all aspects of the software development life cycle

Proficient in building superior analytical, reporting tools and dashboards using data visualization

Strong data manipulation skills and experience with data warehouse ETL tools and processes

Robust working knowledge in Oracle/SQL constructing packages, tables, functions & procedures

Strong problem solving skills with ability to research, evaluate issue and provide optimal solutions

Excellent communication, organizational skills, quick learner, capability to adapt and learn new applications

PROFESSIONAL EXPERIENCE

Sr.Programmer Analyst-Dominion Energy/Mountain West Pipeline/Williams March 2022 – April 2023

As a regulated natural gas distribution company. As part of our Pipeline Infrastructure of the company main line/sub branch lines/various service lines, gas meter, valves & other control devices.

Responsibilities:

Production Support SCADA (Supervisory control and data acquisition) & Pipe viewer Apex application.

Created design, development, and implementation Cathodic protection (CP) testing and corrosion surveys manager current inspection survey status count in dashboard base on each inspection group and keep track of the individual CP counts for historically and reporting. And also sending alert notifications weekly.

Migrated Apex DOT/WIS/SNL application for Dev/Test/Production into Azure cloud.

Maintained/Enhanced pipe viewer PL/SQL packages has been to audit every changes has made 24/7 in SCADA system to maintain status of history changes and notify.

Converted & enhanced the legacy various Apex page into new latest apex applications Oracle Forms

Environment: Oracle 12c, Toad, UNIX, Windows Server, JavaScript, Apex, Oracle forms, Oracle/Crystal Reports

IT Analyst II - State of Utah-Department of Health-DTS, SLC, UT Oct 2019 – Mar 2021

Medicaid Manage Care System (MMCS) includes member benefits & eligibility, claims adjudication, claims billing & payment, claims adjustment and process, claims selection, and capitations.

Responsibilities:

Involved in design, development, and implementation of client’s incarceration status to identify and keep track of the individual status while sending alert notifications daily

Maintained history data to validate and report the client status for a specific time frame

Worked in eradicating duplicates and data correction scripts to update flag, cleanse data in MMCS product

Created various Apex applications for ease of Business to replace legacy Oracle Forms

Created new tables to keep track of clients Emergency Only Program (EOP) dialysis process

Created/Modified PL/SQL packages to maintain client incarceration status, update history, and notify changes

Enhanced PL/SQL package in ELT/BLT Portal tools to exhibit client eligibility in EOP Dialysis program

Maintain batch process status to debug issues, enhance performance, and send alert notifications

Environment: Toad, UNIX, Windows Server, JavaScript, Oracle 12cApex/Forms/Reports, Cognos Reports

Sr. Software Engineer - Sphera Solutions Inc, SLC, UT May 2012 – May 2019

HMMS is a Hazardous Material Management System used by US Army, Navy, and NASA sites. HMMS provides automated tracking of hazardous materials to the level of individual containers on all operations and improves the efficiency of waste management programs and provides the ability to create various reports for Regulatory and Government reporting.

Responsibilities:

Created scripts using COPY command for bulk load data from S3 to Snowflake staging table

Proficient in design, development, and testing of GECO interface and explicitly wrote PL/SQL package to parse bit value of exception codes into multiple descriptions to eliminate an exception detail table

Enhanced multiple existing Oracle Reports meeting business requirements using an XML conversion

Worked in migration of multiple traditional model HMMS system into a single database using VPD (Virtual Private Data) for US Navy depot

Modified and enhanced HMMS application PL/SQL packages using JavaScript to include new features

Enhanced some functionalities in Tier-II reports to provide Chemical Property for HMMS

Developed and tune SQL queries utilized for BI reporting in Jaspersoft

Involved in Microsoft Azure implementation for HMMS and HMIR

Worked in data cleansing and remove duplicates for HMIR and HWD data migration

Created physical domains in Jaspersoft for ad-hoc view queries

Environment: Azure, Oracle 12c, Toad, UNIX, Windows Server, Red Hat Linux, JavaScript, Jaspersoft, Jenkins, and Oracle Reports

Sr. Developer - CVS Caremark, (Rx America LLC), SLC, UT June 2007 – May 2012

CVS Caremark is an industry-leading PBM, clinical and health management program.

Responsibilities:

Developed X12N-835 vendor payment process in Hyperion SQR to generate files in NCPDP 4010 format for individual chain/NABP by validating reject code

Generated various Hyperion Reports for X12N-835, DMR, Transition letters and PA (Prior Authorization) letters per CMS requirements to notify beneficiaries using Hyperion SQR

Created procedure/functions to calculate the dollar amounts and display on various segments at claim level using Business Objects

Redesigned, developed, and implemented the Model Part D transition letters required by CMS (Center for Medicare & Medicaid Services)

Implemented standard unique health identifier, NPI (National Provider Identifier) in Medicare Projects and applied the business logic in all existing SQR reports

Environment: Oracle 10g, PL/SQL, Toad, UNIX, Windows server, Informatica 8.x, Hyperion reports, R&R, ERES, Business Objects, Brio, and SQR

Functional/Technical Consultant

Countrywide Financial, Calabasas, CA Feb 2005 – Oct 2005

United Nations Development Program, NY/Radian Group Inc, PA Jan 2002 – Jan 2005

Lab Safety Supply, WI May 2000 – Nov 2001

Sanco Trans (P) Limited Chennai, Absolute Software House &Taurus Computers LTD Jun 1992 – Mar 2000

TECHNICAL SKILLS

Cloud Technology : AWS S3, Snowflake, DataBrick, Azure

BI & Report Tools : Hyperion, Oracle Discoverer, Business Objects, Crystal, Power BI, Jaspersoft, Oracle Report

Builder, Cognos, OBIEE, Tableau

Web Technologies : Web Logic, Apache, Oracle Application Server

ETL : Jaspersoft & Informatics Power Center 8.x

ERP & CRM : PeopleSoft Financials & Distribution (7 – 8.8), Onyx 5

Prog. Language : PL/SQL, JavaScript, SQR, HTML, C, C++, Unix shell script, Cobol, Clipper, Python

DBMS & RDBMS : Oracle APEX, Oracle 12c, MS-SQL Server/Access, Sybase 10, Teradata

EDUCATION

Master of Computer Application(MCA) from Bharathidasan University, Trichy, India

Post Graduate Diploma in RDBMS-Sybase & Power Builder 4.0 from SSI, Chennai, India

Post Graduate Diploma in Systems Development (PGDSD) from Brilliant Computer Center, India

Diploma in UNIX & C from BITECH, Chennai, India

Bachelor of Commerce (B.com) from University of Madras, Chennai, India

Contact this candidate