SUMMARY

Senior Level Professional in I.T. Technical Services utilizing diversified experience, problem solving and tough - minded skills to help an organization maintain leading-edge technology.

TECHNICAL SKILLS

Languages: ASP.NET, BTEQ, CURL, HTML, JAVA, PERL, R, Shell scripting, SAS7, SQL/PLSQL, SharePoint, VB.NET, XML

Databases: Oracle, SQL Server, Teradata, Netezza

Platforms: Alfresco, Alteryx, APEX, CCIM, Crystal Report Design XI, Eclipse, Fastload, MS Exchange administrator, Microsoft user administrator, PL/SQL Developer, PeopleSoft 8.9, SABA version 5.X, Sharepoint, SSAS, SSIS, SSRS, Tableau, Toad, UNIX

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Analyst

Responsibilities:

• Maintain all aspects of Pathology department data needs
• Develop and maintain daily, weekly and monthly reporting views and ADHOC data processes and reports utilizing SSIS and SSRS
• Thorough knowledge of the Clarity database for the EPIC product for both resolute and beaker modules
• Develop and maintain a faculty presentation data layer for 120 plus faculty
• Develop and maintain overdue reports database for over 800 specimen types with overdue periods of 2, 5,10 and 12 days
• Maintain both public and internal pathology websites along with 25 lab websites

Confidential

Senior Data Engineer

Responsibilities:

• Developed presentation layer for BI team for Reliability management to review delay statistics, Heavy Maintenance statistics, None routine statistics, log page statistics, hours and cycles, power-plant, Corrosion checks
• Develop adhoc and automated reporting using Teradata, Alteryx
• Lead work streams with business for gathering requirements for datasets and reporting layer architecture
• Stood up Alteryx server and provided steps to user groups how to install and set up Alteryx Designer
• Create automated Alteryx workflows to pull data from several locations to generate one dataset
• Create ETL (Alteryx) processes to update validated datasets including push notifications
• Create applications utilizing Alteryx for data discovery and give users ability to query reliability datasets

Confidential

Senior Data Analyst

Responsibilities:

• Developed architecture and reporting for management to be used for coaching and patient retention
• Lead and developed ETL process for sending calling date third party calling application and to load Sharepoint, this included creating new table structure to accommodate additional data
• Develop adhoc and automated reporting using PL/SQL, T-SQL and APEX
• Lead report gathering for report request and assign to team members
• Develop Data sets for Tableau report development
• Review peers reports for quality before sent to requester or change management to move into production

Confidential

Unit Mgr analytics & Reporting

Responsibilities:

• Lead Database architecture that reduced manual intervention for report requests
• Review and resolve data redundancy which reduced downstream issues
• Develop and review of SQL procedures used for Tableau and Cognos development
• Review external client report requirements and lead development of the reports
• Develop data sets for Tableau report development
• Develop and submit Medicaid mandated state reports.
• Monthly, Quarterly and Annually

Confidential

Senior Database Developer

Responsibilities:

• Optimization of PL/SQL and SQL scripts that reduced run time of daily reports
• Write shell scripts to automate generation of reports and post to SharePoint
• Architect for Oracle database used by APEX application which removed manual intervention
• Lead Code review of peer PL/SQL and SQL scripts
• Train peers and other team members to insure Oracle and company best practices
• Lead project to analyze and move data into enterprise data warehouse(EDW) from Oracle to Teradata

Confidential

Senior Database Consultant

Responsibilities:

• Develop, integrate and support SABA online learning and development system.
• Duties include DA, DBA, front end development and report writing using JAVA web services, PL/SQL and Crystal reports
• Develop and support PL/SQL procedures for daily HR feeds that load the SABA system
• Develop and support of PL/SQL procedures to load current learning details from DB to the SABA system
• Write low level design specification for custom reports and data extracts from business requirements
• Setup and monitor of QA DB for report testing/development in a high compliance environment
• Vendor management of 3rd party vendor as it related to current projects

Confidential

Senior Engineer 2

Responsibilities:

• Develop, integrate and support SABA online learning and development system through several life cycles from end to end Duties include DA, DBA, front end development and report writing
• Develop, integrate and support of online FedEx locator using Hibernate and Struts framework
• Develop, integrate and support of online merit system, which eliminated the need for paper and allowed Managers to give over 19,000 employees accurate compensation in a two-week window
• Create, update and tune SQL tables, views and procedures as needed
• Collect requirements, develop and maintain custom reports using various technologies
• Setup and maintain team SharePoint sites for new and current groups and project sites
• Create custom SharePoint work flows for document approvals
• Create and maintain SharePoint security utilizing Active Directory parameters
• Desktop and server support both Dell hardware and Microsoft product suites
• Troubleshoot VB.NET and ASP.NET code
• Administration of Oracle Financials 11.0.3
• Maintain networking between Seattle and Dallas servers with VPN and CITRIX client applications

Confidential

Systems Integrator - Software Engineer IV

Responsibilities:

• Developed and supported adjustments, payments, customers and automated schedules
• Developed and supported API’s to automate the order entry process using
• Developed and supported automated treatment process for collections
• Developed a strategy/functionality for 3rd party print vendor and online billing system to provide accurate invoices
• Created presentable collection letter from XML to be used as a backup for the print vendor

Confidential

Network Administrator

Responsibilities:

• Supported and monitored daily functions of 500 plus desktop computers, and 15 Dell enterprise and 2 SUN ULTRA 80 servers
• Novell Netware5, Win 9X, Win NT/2000 and MS Exchange administration
• Responsible for inventory management of computers, servers, hardware and software licenses

Senior Traffic Analyst

Confidential

Responsibilities:

• Develop custom reports using SQL on AS400 and PL/SQL
• Debug and maintain Java and Perl scripts
• Automated reports that are sent to affiliates
• Restored tape volumes to recover raw call detail
• Test and provided production support on UNIX platform for reciprocal and Carrier access billing
• Set up filters and special processes to correct raw call detail
• Generated custom Brio Query reports from Oracle database
• Trained new employees on the day-to-day duties and process of a traffic analyst
• Wrote business requirements to bring more control and less cost to the company

Database Specialist

Confidential

Responsibilities:

• Resolved out-of-sync issues between the Arbor Billing System and WEB Order Entry
• Responsibilities included geo-code processing, Access queries, and spreadsheet analysis
• Researched termination data to improve efficiency and accuracy of the termination process
• Corrected Family Mailbox pricing and conducted data entry
• Resolved raw record errors and resubmitted for payment processing