Business Intelligence Software Development

YELENA RADOVICH 443-***-****• *********@*****.***

PROFESSIONAL SUMMARY

I am an innovative IT professional with over 20 years of experience in software development, data analytics, data Integration, business intelligence, and reporting. I am proficient in PL/SQL, T-SQL, Visual Basic, Crystal reports, Tableau reports, and SSIS packages and skilled at using a variety of business applications. My analytical abilities are strong, and I have excellent problem-solving and communication skills, allowing me to lead and mentor others to achieve results.

TECHNICAL SKILLS

Visual Basic 3, 4, 5, 6

Microsoft Windows

Btrieve

Paradigm

Oracle & PL/SQL

Rapid SQL, Toad

MS SQL Server & T SQL

MS Access, Project & Excel

COM/DCOM

NewLook

Novell Netware

ActiveX Objects

C-Tree,

Crystal Reports

IBM Host On-Demand

Sun Script

eGate

Sybase

Healthcare Facets system SQL PLUS SSIS packages

SSIS reports Tableau AWS (Edge server)

PROFESSIONAL EXPERIENCE

Application Developer

January 2019 – present

Denver Health Denver, CO

oDevelop advanced scripts, stored procedures, and queries using T SQL.

oDeveloped and maintained SSIS packages (Member ID card, EOB (explanation of benefit), MVS (verification letter of services) including Medicare, Medicaid, and Commercial LOB.

oDeveloped SSIS reports

oDeveloped Tableau reports

oTransferring files, and creating reports using edge server.

Senior Developer Team Lead

September 2009-November 2018

Beacon Health Options, Inc. Linthicum Heights, MD

oResponsible for validating implementation reports for Maryland’s Mental Health Association (MHA) including those related to mental health and substance use

oPerform data import and cleanup for final validation relating to MHA report compliance including claims, encounters, authorizations, members, and providers' data

oBuild, restructure, and normalize data warehouse tables, translate data between various industry-standard formats, and analyze raw data from various sources/systems for validation

oDevelop stored procedures, processes, and functions for Oracle packages and export data from Oracle database to Crystal Reports

oDevelop advanced scripts, and queries using PL SQL, and T SQL.

oDevelop reports using Toad, Microsoft Excel, and Crystal reports based on customer requests and create technical specifications and reporting scripts for report conversions

oEnhance staff accomplishments and competencies by planning the delivery of solutions, answering technical and procedural questions for the team, teaching improved processes, and mentoring colleagues

oServe as the Business Analyst supporting clients cross-functional project teams for complex product launches and projects with Company-wide impact.

oTake full ownership of the Implementation project from Initiation to close; Accountable for ensuring the ultimate success of the project.

oDefine and prioritize requirements and work with the engineering teams to build them.

oIdentify, assign, and track all tasks that are required for the successful completion of the project.

oDevelop and deliver executive-level updates and briefings for senior leadership teams and groups.

Sr.Programmer/Analyst

April 2004 -September 2009

APS Healthcare Silver Spring, MD

oWas responsible for performance tuning and maintenance of interfaces that extracted data from various claims systems including Facets and Iris

oSupported commercial and public clients for reports and extracts in Puerto Rico and was involved with Facets daily claims extraction for a major client

oDeveloped and provided support for full cycle applications written in VB 6.0 and reports in Crystal Reports with embedded SQL stored procedures as well as transferred data to clients in EDI format

oHelped users to run their reports when they wanted with various parameters, taking the burden off the reporting department to run/schedule reports with various parameters.

Senior Programmer/Analyst

October 1999-January 2004

Magellan Behavioral Health Systems Columbia, MD

Developed an application to validate membership data and load it into the clinical decision support system and an application that automatically sent and received files using the FTP protocol

Created enhanced error handling and transaction processing algorithms that enabled applications to recover from a variety of external errors including the failure of the client's computer

Responsible for performance tuning and maintenance of interfaces that extract data directly from various claims systems as well as converting interfaces from Visual Basic 3 to Visual Basic 6

Built an application that automatically loads files, and tests and compares data in several different databases as well as an application that splits extremely large text files into smaller files

Created interface that extracted claims data from an Oracle claims data warehouse and customized AS/400 screens using IBM Screen Customizer for IBM Host Integration and NewLook software

Customized Dexterity transaction-based business accounting applications for a distributor’s company written in San Script to communicate with C-Tree, Btrieve, and SQL Server 6.5 databases

Maintained and enhanced the database front-end application for a medical claims database used to bill insurance companies using data submitted by medical providers as text files

Performed data import and cleanup, restructured and normalized database tables, translated data between, maintained integrity, and used SQL and text manipulation functions extensively

Wrote applications to do direct data manipulation and maintenance using Visual Basic 5 and RDO against Oracle and SQL Server databases

EDUCATION & CERTIFICATIONS

oSeeBeyond e*Gate 4.1.2 Basic implementer’s, 4.1.2 to 4.4(eBI401), 4.5 Advanced(eBI102), Database Connections(eBI201), and exchange(e*BI203), Magellan Health, Columbia, MD

oMS – Pedagogy, Gnessin State Musical College, Moscow, Russia

Contact this candidate