| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Current Location: St Louis Park, MinnesotaUS Citizen - Willing to work remotely.Summary:Business Intelligence Developer (ETL, SSIS, and SQL) with recent healthcare experience on healthcare benefits, Claims processing with United Healthcare2 years working with Claims processing at United Healthcare15+ years in development of ETL Processes, data mapping and other documentation required for ETL development.15+ years writing, simple to complex SQL code in both PL SQL and T-SQL and performing data analysis in SQL9+ years of SSIS Packages development, writing and reporting through SSRSOver 20 years' experience writing, simple to complex SQL code in SQL Server, Teradata, and OracleSkilled in data analysis, analytics, data mining, data models, process improvement, automation, and research.Worked on creating complex SSIS packages, creating jobs, Alerts, and scheduling SSIS Packages using SQL Agent, migrating the data from different legacy systems to SQL using SSISExperienced in migrating Data from Excel, Flat file, Oracle to MS SQL Server using SQL Server Integration Services (SSIS) and experience in Creating, Configuring and Fine-tuning ETL workflows in SSIS15+ years in writing stored procedures in SQL Server and OracleHave proven success achieving cost savings and enhancing system functionalityStrong Project Management skills with experience managing multiple projects through full lifecycle, from requirements gathering to final implementation and end user trainingDemonstrated ability to collaborate effectively with individuals at all levels and in all functional areasHistory of identifying and solving tough business and technical problemsExperience evaluating, optimizing, and rewriting code to speed up proceduresExperience working with HadoopExperience in both Visual Studio and BOExperience pulling data quickly for ad hoc reportingTechnical Skills:Category: SQL Server, Oracle, Teradata, SAP, Access, Hadoop, Informix 4GL, Linux, WindowsVisual Studio, SQL Management Studio, SSIS, SSRS, SSIS Task Factory, SAP, R-Script, Crystal Reports, BTEQ, PLSQL, Oracle Packages, VB Script, Hive, PeopleSoft, Toad, SQL Assistant, SQL Plus, Excel, PowerShell, Tortoise, GIT, PuTTY, WinSCP, Unix, Shell Script, Informix 4GL, Microsoft Office, JavaScript, HTML, Business Objects ACE, Business Objects Merge Purge, Business Objects Match Consolidate, FTP, PGPEducation:Computer Science, University of Minnesota, Duluth, Minnesota, USHigh School Diploma, Roosevelt High School, Minneapolis, MN in 1982Experience:PORTICO Minneapolis, MN April 2023 to Dec 2023Senior Programming AnalystUsing R-Script and SSIS/T-SQL, Supported and enhanced healthcare and benefits payroll processingSupported and enhanced healthcare and benefits payroll processingWorked using T- SQL to assist in SAP post migration analysis.Using T-SQL, assisted with the SAP data updates and data validation.Working with SSIS/ T-SQL and SQL Server Agent to convert and automate current R-Script processes, including ETL processesCollaborated with technical team to convert and automate current R-Script processes, including ETL processes, using SQL Server Integration Services (SSIS) Catalogs and SQL Server Agent.Developed SSIS Packages and Stored Procedures using T-SQL to load/transform/cleanse data from SQL Server, Oracle and Excel Files to Facts and Dimension Tables in the Data Warehouse.Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services(SSIS) and T-SQLCreated Visual Studio packages that encompassed SQL Server store procedures, file conversion and file extractionPreferred One / United Healthcare Minneapolis, MN Aug 2021 to April 2023Senior ETL AnalystSupported and enhanced healthcare claims processingCreated Visual Studio packages that encompassed SQL Server store procedures, file conversion and file extractionMigrated Data Excel, Flat file, Oracle to MS SQL Server using SQL Server Integration Services (SSIS) and experience in Creating, Configuring and Fine-tuning ETL workflows in SSIS using T-SQLCollaborated with technical team to automate processes, including ETL processes, using SQL Server Integration Services Catalogs (SSIS) and T-SQL and SQL Server Agent.Developed SSIS Packages and Stored Procedures to load/transform/cleanse data from SQL Server, Oracle and Excel Files to Facts and Dimension Tables in the Data Warehouse.Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services(SSIS) and T-SQLUpdate existing and wrote new Crystal reportsUsing T-SQL to extract data for Excel.Wells Fargo Minneapolis, MN July 2020 to May 2021Senior Database AnalystSupported and enhanced data processing activitiesValidated, rewrote, and fine-tuned existing Teradata queriesCollaborated with technical team to automate ETL processes using PowerShell, Visual Basic, Excel and BTEQ scriptsWrote several queries to extract data for Tableau reportingTarget Minneapolis, MN Sep 2019 to May 2020Supported businesss needs, with regards to CCPA (California Customer Privacy Act) project to extract customers personal identifiable information (PII) from multiple systems throughout the organizationMet with multiple teams throughout the company to determine if the data they owned will be necessary to be included in the CCPA reportingValidated, rewrote, and fine-tuned the queries written by the engineers to extract the PII data from a Hadoop platformExperience using Domo and TableauWrote several queries to extract the PII dataCapella University Minneapolis, MN Oct 2014 to July 2019Business Intelligence AnalystSupported both businesss needs with regards to learner enrollment, faculty workload and faculty participation and HRs needs with regards to employment and management by extracting information for ad hoc reporting and automation using simple to complex SQL, PLSQL, Power BI, SSIS and SSRS reportingMet with business to analyze and understand their processes to help make processes more efficient with better reporting or automationSupported business and HRs needs by analyzing and extracting information from multiple servers and databases (Oracle and SQL Server) using simple to complex SQL; this information is presented quickly using SSRS reports and subscriptions to allow the flexibility of manual extracts or automated scheduled emails and filesRust Consulting Minneapolis, MN July 2013 Sept 2014Liaison between business, analysts, and ITTook the information and requests from businessPresented businesss requests with the technical knowledge, allowing the analyst to write accurate and complete specifications for IT to perform their tasks accuratelySupported businesss needs by analyzing and extracting information from multiple servers and databases using simple to complex SQL; this information presented quickly and accurately, either summarized or down to the detail of the customers, allowed business to make better and cost-effective decisions going forwardKey support for other analysts and their work streamsProvided experience and equipping them with the knowledge of how to look at the data and make better decisions when presenting to business or ITBest Buy Mobile Richfield, MN July 2011 to July 2013Senior AnalystSupported businesss needs with regards to sales, inventory, traffic, fraud, and labor by extracting requested information for ad hoc and online reporting using simple to complex SQLInterfaced with vendors to set up ETL processes including VB Script for file manipulation, PGP encryption, SFTP file transfers and database loadsConsulted with business to help determine the best way to extract and present the data being requestedIQ Marketing (American Family Insurance) Minneapolis, MN Jan 1996 to Sep 2010Senior Developer- ETL and SQL DevelopmentExtracted and analyzed data to assist in data profiling for optimum response in future marketing campaignsExtracted data using PL/SQL or straight SQL for requested data extracts or ad hoc reportingCreated dynamic JavaScript reports that access the Oracle database for clients online reportingCreated and consulted with others to present data using Crystal Reports and data extracted from the Oracle database using embedded SQLCreated materialized views for fast uploading of complex online multilevel reportingInterfaced with multiple vendors to manage client data for standardization and consistencyWorked the full lifecycle of projects working with management, sales, outside vendors, clients, and IT to determine the best and most efficient action to process and present the dataDesigned databases, process flow and data flow for new and existing clients using DDL scripts and Oracle SQL LoaderUsing PL/SQL, Shell scripting and a merge/purge tool, developed and maintained automated ETL processes which included data definitions, data mapping and flow diagrams to convert, cleanse, and standardize multiple sets of data files with different formats and efficiency resulting in a uniform set of clean data to be loaded into the databaseUsing PL/SQL, developed a package that will assign and track prospective customers, received from various sources to be mailed, called, or emailed on behalf of participating insurance agents, producing up to $100,000 per quarterCollaborated with sales and account management to provide time and cost estimates resulting in project producing yearly revenue, anywhere from $500 to $500,000Created triggers to populate history tables to report on the activity over the lifecycle of a marketing campaignAnalyzed data to report on and project response rates, sales, and ROIDeveloped a tool using Oracle PL/SQL for an insurance company to process 12,000,000 prospects for a direct mail/email campaign; removed duplicate names, removed names previously used over the span of 3 months and attributed the names to 3000 agents using business rules defined by the clientSuccessful beta run resulted in $700,000 in revenue over a 2-year span -- $500,000 during the first yearDeveloped a PL/SQL package to load and update the enrollment status of participating insurance agents in multiple direct marketing campaignsCreated and maintained PL/SQL scripts to store data into a data warehouse for archival storage and reportingLead consultant on the data migration and database development converting Informix Database to Oracle resulting in the move from an in-house server to an offsite DBA firm, Oracle On-DemandPartnered with account management to provide technical expertise to respond to clients requests and concernsLittle Mountain Software Monticello, MN Jan 1993 to Jan 1996ConsultantCreated solutions using an Informix 4Gl platformDesigned the database and developed invoicing and accounts receivable system for resale to third parties in vertical marketsDesigned and programmed an invoicing and product inventory system for a national mail order companyDesigned and programmed a residential/commercial property management systemProduced a technical manual that included step-by-step instructions for the user to manage the data using a front-end toolFor Proex Photo, analyzed hundreds of lines of Informix 4GL code that had not been documented and documenting itUpdated documentation allowed the programmers to pinpoint the part of the code more easily in questionReprogrammed Appointment tracking system |
