PROFILE:

• Have been granted Secret Eligibile by DoD CAF as of 11/1/2013.
• Extensive experience in the Information Systems profession with expertise working with various computing environments.
• Very skilled working with healthcare data from both the provider and insurer perspective.
• Highly motivated professional who is a self starter requiring minimum supervision.
• Ability to work closely with both business clients and technical staff to ensure project team success.
• Capable of and willing to identify application issues and see them to resolution.
• Skilled at working with extremely large databases to provide maximum throughput while maintaining data integrity including data modeling and security.

Confidential

Senior Business Information Analyst

• Updated SAAS application code and reports for the Department of Defense. Work was delivered on time and as requested.
• Development tools included Winbatch, Stonefield Queries, Oracle, PL/SQL, Windows 7 Server
• Followed federal, DoD and group guidelines and protocols when submitting documenting, testing, and securing work assignments.

Confidential

• Daily activity includes generating financial commercial reports from complex VBA applications.
• Interface with Oracle, DB2 applications using MS Access and Excel
• On course to promote work to a Data Warehouse/Data/Mart environment

Software Engineer

• Using large enterprise MS SQl Server databases to create views, stored procedures and Crystal Reports.
• Routine activity included working with medical and IT staff to provide quality reporting solutions, on-call support and technical assistance.
• Play a key role in system testing and product upgrades.

Senior Business Information Analyst

• Interacted with very large enterprise Teradata and department MS SQl Server databases.
• Routine activity included querying, porting, scripting and analyzing data for the Wellpoint Business Marketing Division.
• Toolsets employed include, but not limited to, SSIS, MS Visual Studio, Teradata SQL Assistant and Microsoft SQL Server Management Studio.
• Flexibility given with respect to project delivery packages.

Programmer/Analyst

• Prepared Department of Conservation and Natural Resources Wells Database upgrade .
• DCNR upgrade performed in in M.S. SQL Server environment.
• Responsible for PA Department of Health Cancer Registry
• Built Contract Management Database to record payer rates and and other negotiated detail
• Developed PERL scripts to manage data migration, HL7 and ICD9 coding efforts.
• Developed and/or supervised Crystal Reports to serve both the financial and clinical divisions of DCA
• Was responsible for all data porting and security planning during HII/TIME conversion.
• Supervised database reporting, data security and vendor interface of HII/TIME application.
• Data supplied by hospitals and labs whereas software was supplied federally and developed in-house
• Included maintaining MS SQL Server databases, .Net web applications and user support
• Teamed with middle and senior management in setting company technical direction and goals
• Database hosts include MS SQL Server, Progress and MS Access

Programmer/Analyst

• Lead Programmer/Analyst for IS intranet web site.
• Became very proficient with Interwoven TeamSite web content management toolset
• Incorporated skills such as Javascript, PERL, HTML and XML and Unix in site development
• ISG Central required taxonomy development and usability studies
• ISG Central reconstruction project in process to rework TeamSite technology with IBM WCM portal technology Database Project / Product Inventory
• Modeled, maintained and supported Oracle databases which were used to support IS project planning and manage IS product inventory
• Built applications using Oracle APEX web development tool
• Project construction included heavy hands-on HTML, Javascript, SQL and PL/SQL
• These applications required constant interface with Oracle DBA, data security and IS management.
• Many management reports from the Oracle database were built using tools such as Cognos
• Web applications were accessed via enterprise intranet site

Business/Programmer Analyst

• Constructed query tools for end users which computerized order research
• Combined data stored in DB2, Oracle and Access databases
• End user products included Crystal Reports, Cognos Reports and XML extracts
• Incorporated skills such as VB, SQL and PL/SQL

Conversion

• Programmer/Analyst on team which assisted pharmaceutical industry with HIPAA conversion
• Converted various large data stores to meet HIPAA compliance
• Modified client COBOL and C applications meet HIPAA compliance.
• Work experience in insurance, healthcare, pharmaceutical, utility, communications and consulting industries
• Work was done in both TSO/MVS and Unix environments
• Establish and administer enterprise Focus User Group
• Install, maintain and manage DB2, VSAM, Oracle interfaces along with data security to FOCUS
• Additional technologies include MQ Series, CICS, DB2, QMF and VSAM Install, maintained and train users with use of Informationbuilders FOCUS
• Extensive healthcare background includes hands-on with ICD9, HL7 and EDI coding with various toolsets and scenarios.
• Prepared project design specifications, test plans and project documentation for numerous projects
• Author newsletters, training material and presentations for in house employees and professional organizations

TECHNICAL SKILLS:

• Operating Systems: MVS, JCL, TSO, Unix, DEC/VAX, Windows NT, OS, MS DOS, MS Windows, Linux
• Hardware: IBM 370, DEC PDP11, Prime, Sun Solaris, Personal Computers
• Programming/Scripting Languages: .NET, Visual Basic, VBA, Cobol, C , T-SQL, Winbatch, Basic, SAS, Fortran, CICS, Java, PL/SQL, Perl, JavaScript, Unix Scripting, HTML, Interwoven TeamSite
• Database Products and Tools: DB2, MS Access, SSIS, SSRS, FOCUS, Teradata, SQL Server, Oracle, SQL, GQL, MySQL, Stonefield Queries, Crystal Reports, QMF, VSAM, Cognos
• Miscellaneous: Net Fusion Objects, HTML, MQ Series, MVS Utilities, Networking, Web Services, MS Office, Navision, Oracle APEX, XML, RSS, X12, Joomla

TeamSite Interwoven 2006