SUMMARY:

Experienced ETL and Data Warehouse Developer Specializing in Informatica and SQL development. Proven ability in the development of complex SQL queries and in the designing, implementing and testing ETL transformations. Enhancing business reporting via improved data Warehousing and advanced reporting tools using Tableau and SSRS. Using Agile Methodology and creating documentation for processes.

TECHNICAL SKILLS:

SQL: PL/SQL ~ T - SQL

ETL Tools: Informatica PowerCenter 9/10.1 ~ SSIS ~ IDQ ~ Tableau

Report Writing: SSRS ~ Crystal Reports ~ Meditech Report Designer

Healthcare Systems: Facets, Meditech 5.64/6.0/6.15

Programming: Python ~ PowerShell ~ VB.NET ~ VBScript ~ JavaScript

Integration Engine: Rhapsody ~ Corepoint ~ Summit

Forms Building: Windows Forms ~ Transform Designer (Bottomline Technologies)

PROFESSIONAL EXPERIENCE:

Confidential, Sacramento, CA

Data Warehouse Developer

Responsibilities:

• Expertise in Informatica power center.
• Design, develop, and deploy ETL solutions to meet business requirements using Data Analysis, Dimension Modeling, and using Informatica.
• Conduct ETL performance tuning, trouble shooting, support and capacity estimation.
• Optimizing existing Informatica Processes.
• Implementing best practices and troubleshooting.
• Documenting new and existing processes.
• Building Workflow Audits and Controls processes.
• Conduct thorough testing of ETL code changes to ensure quality of data produced.
• Developing Stored Procedures, Functions, Views and Triggers, Indexes and Complex queries using PL/SQL & TSQL
• Developing data analyzing tools and views to return statistics to help business in decisions.
• Communicate with stakeholders and coordinate between the data team and business.
• Querying Facets Database and working closely with Business to provide Membership, Eligibility, Medical, Pharmacy, Lab and Provider Data.
• Experienced with Agile (Kanban) methodology with a strong record of excellent teamwork.
• Perform other duties and special projects as assigned.

Confidential, Porterville, CA

Programmer Analyst

Responsibilities:

• Leading the application team to configure applications and scheduling activities by coordinating with specialists and vendors.
• Analyzing, Designing, Developing, Testing, and Implementing HL7 interfaces using Rhapsody
• Performing data mapping, data translations and data transforming
• Meeting Meaningful Use requirements by developing Interfaces using SOAP based Web Services
• Ensuring system integrity, compatibility and standardization
• Providing Application support and training in Meditech 5.67
• Performing Database Administrator duties
• Developing stored procedures, functions, Views and Triggers, Complex queries using PL/SQL & TSQL
• Drawing on Experience in all aspects of analytics/data warehousing solutions (Database issues, Data modeling, Data mapping, ETL Development, metadata management, data migration and reporting solutions)
• Design, develop, and deploy ETL solutions to meet business requirements using Data Analysis, Dimension Modeling, and using Informatica.
• Conduct ETL performance tuning, optimizing, trouble shooting, support and capacity estimation.
• Designing/Writing/Publishing reports using SSRS
• Maintaining Vendors' Existing Crystal Reports and developing as necessarily needed
• Scheduling Reports using SSIS
• Developing VB.NET solutions.
• Developing VBScript Apps to automate data Extraction/Loading/Uploading processes
• Automating SFTP Processes using different tools (WinSCP/FileZilla).
• Building Reports for KRONOS Application

Confidential, Frederick, MD

Interface Analyst

Responsibilities:

• Leading the application team to configure applications and scheduling activities by coordinating with specialists and vendors.
• Analyzing, Designing, Developing, Testing, and Implementing HL7 interfaces using Corepoint
• Performing data mapping, data translations and data transforming
• Ensuring system integrity, compatibility and standardization
• Providing Application support and training in Meditech 6.1
• Developing forms for using Transform and Windows Forms
• Developing stored procedures, functions, Views and Triggers, Complex queries using TSQL
• Designing/Writing/Publishing reports using SSRS and Report Designer
• Scheduling Reports using SSIS
• Automating SFTP Processes using different tools (WinSCP/Corepoint Engine).
• Providing after-hours support.

Confidential, Cincinnati, OH

Integration Developer

Responsibilities:

• Analyzing, Designing, Developing, Testing, and Implementing new HL7 interfaces.
• Generating Reports from XSLFast software.
• Develop Business Cases, ad-hoc queries, and reporting from a variety of resources and specific to department or organizational needs.
• Design, develop, and deploy ETL solutions to meet business requirements using Informatica.
• Conduct ETL performance tuning, trouble shooting, support and capacity estimation.
• Consult with new and existing clients to determine interface requirements.
• Coordinates with project managers, business analysts, and subject matter experts to gather requirements for application.
• Developed Relational Database using Oracle 11g.
• Perform other custom work projects as necessary.
• Train Clients remotely and at client sites.

Confidential, Cincinnati, OH

Crystal Reports Consultant

Responsibilities:

• Utilize tables, views, stored procedures and user defined functions to extract data from Oracle databases.
• Create and maintain data exports using Crystal XI.
• Create formatted reports using Crystal XI.
• Develop Crystal Reports with sub-reports, parameters, summarizing data, on-demand sub-reports and drill-down.