| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Software Developer Sql Server Maryland Heights, MO Data Analyst Sql Server St. Louis, MO Asp.Net Sql Server St. Louis, MO Sql Server Ms St. Louis, MO Stack Developer Sql Server Maryland Heights, MO Sql Server Business Intelligence Ballwin, MO Informatica Powercenter, IICS/IDMC, Teradata, MS SQL Servier, Cl Chesterfield, MO |
|
Click here or scroll down to respond to this candidateCandidate's Name
Creve Coeur, MO Street Address
e-mail: EMAIL AVAILABLEEmployment ExperienceFebruary 2021 - PresentSoftware Engineering Advisor contractor remote - Wellcare, Tampa, FL.Perform ETL related tasks to generate healthcare program reconciliation files from MongoDb source system. Create Talend jobs to extract data using desktop app and Talend Enterprise server. Establish requirements, modeled data and performed testing and validation. Analyze source source data using SQL Manangement Studio with MYSQL BI connector, as well as Studio3t. Preform API requests using REST and GraphQL. Load files to S3 storage, Provide data and support to integration team.June 2020 January 2021Software Engineering Advisor contractor Express-Scripts, St. Louis, MO.Performed ETL related tasks for Agile Kanban Tableau team. Migrated and validate SQL Server database from version 12.0.6372.1 to 14.0.3335.7. Wrote SQL server stored procedures to perform data extractions and loads. Created Talend jobs to execute REST calls to retrieve data from ServiceNow and Confluence, and load to SQL server. Maintained existing and create new Python processes to perform REST calls, executed SQL server stored procedures and performed bulk copies between servers using Powershell. Provided data support to team Tableau developers.April 2020 June 2020Contract at Bayer ended at the onset of a global pandemic. Spent gap time looking for a new position, brushing up on existing skills, and learning new ones.April 2019 March 2020Data Engineer contractor Bayer, St. Louis, MO.Mentored team members on ETL best practices using SQL and Alteryx. Gathered requirements and perform data analysis and profiling. Created Tableau dashboards per user requests and mentored other team members new to Tableau. Debugged existing Access processes and converted to Alteryx. Helped support and train teammates on new software.April 2018 March 2019ETL Developer contractor US Bank, St. Louis, MO.Converted Oracle DB to Netezza by rewriting existing database objects and ETL processes. Created new Informatica mappings. Wrote UNIX shell scripts, embedded SQL and stored procedures. Created job schedules using Appworx. Ported data from Netezza into Hadoop data lake using HDFS, Hive, Sqoop and JDBC. Gathered requirements, performance tuned existing and new processes.July 2014 April 2018Lead Software Engineer - Magellan Health, St. Louis, MO. Converted fromcontractor to full time November 2014New ETL development, testing, production fixes and debugging. Maintenance of existing ETL processes. Identify performance issues and solutions.Designed, developed, tested and implemented solution to extract data from MongoDb and load to Oracle Data Warehouse using shell scripting, the MongoDb shell facility and Oracle SQLLDR. Support and enhance MongoDb integration process.Support data warehouse operations, including production issues and automate manual tasks using shell scripting, Informatica, SQLPlus, and PL/SQL.Debugged SSIS package and C# code using Visual Studio and Visual C#. Powershell scripting.Mentor others on Operations standardized processes, Informatica and Snaplogic development, and MongoDb shell queries.Informatica 9.6.1, Oracle 12c, SQL Server, SSIS, Visual Studio, Linux shell scripting, C#, Oracle, Toad, MongoDB, NOSQL, JavaScript, SQL Server, Netezza, AginitySeptember 2013 May 2014ETL Developer Daugherty Business Solutions consulting for Reinsurance Group of AmericaETL development and support Informatica, Oracle.Informatica development Work with overseas clients to finalize and implement technical design specifications. Create, document and implement test plans. Duties include creating new processes, as well as adding enhancements to existing design templates. Implement Informatica web services consumer and http solutions to execute asp.net queries. Parse, transform and load the results of those queries. Perform data analysis as needed.Data Warehouse daytime admin support Informatica Powercenter administration. Cisco Tidal Enterprise Scheduler administration, including installation. Root cause analysis and resolution of data warehouse issues. Environment supported Powercenter 9.1, Tidal 6.1, Oracle 11g, Linux, MSSQL, Samba, and windows servers.Perform 24 hour on call duties on semi-monthly rotation. Determine root cause of production issues, propose and implement solutions.Informatica 9.1, Oracle 11g, Tidal Scheduler.April 2012 August 2013ETL Developer - Data Quality Stockell Consulting subcontracted to Monsanto, St. Louis, MO.Automation of existing Standard Operating Procedures. Functions performed include requirements gathering, data analysis, development, testing and implementation. Create processes and user interfaces incorporating newly developed Web Services / Informatica Developer / Powercenter / Data Quality infrastructure. Configuration of testing framework utilizing Maven, IntelliJ.Informatica 9.1, Unix/Linux, Oracle 11g, Web Services, SoapUI, WSDL, Maven, Subversion, IntelliJ.August 2011 April 2012ETL Developer/Programmer/Analyst - Signature Consultants - subcontracted to Wells Fargo Advisors, LLC, St. Louis, MO.Technical lead for automated file delivery and registration process Design and implement enhancements to data extraction and file delivery processes. DB2, Informatica, Unix (ksh) scripting, NDM and Autosys environment. Responsibilities include creating technical designs and production turnover documents, coordination data transmission between Wells Fargo internal and external clients, maintenance and enhancements of system process, including Unix shell scripts, DB2 SQL, and Informatica mappings and workflows. Debug production issues and identify process bottlenecks.November 2010 August 2011ETL Developer - Unisys Corp. - subcontracted to US Department of Agriculture, Rural Development Government Loan Program, St. Louis, MO.Converting Informix/DB2 Data Warehouse to Informatica/Oracle - Re-engineering existing SQL to Informatica ETL processes, development, testing and implementation - Sun/Solaris environment.October 2009 November 2010ETL Developer/Programmer/Analyst - Collabera Inc. - subcontracted to Wells Fargo Advisors, LLC, St. Louis, MO.Create and document new Unix/Informatica/DB2 ETL processes and enhancements. Tech lead for automated file delivery and registration process - Create utility script and test plan to compare performance and accuracy between existing version of SyncSort for Unix to each an upgraded version of SyncSort and DMExpress. Create ksh process calling NDM to pull directory listings from remote landing sites. Serve as mentor for the onboarding of ETL Tech Leads. Resolve production issues. DB2, Informatica, Unix (ksh) scripting, SyncSort and Autosys.March 2008 October 2009Sr. Software Consultant - Jacobson Staffing - subcontracted to Express Scripts, St. Louis, MO.Data Warehouse Developer New development and enhancements, designing, coding and testing. Assist in the engineering and design of new ETL processes. Interface with source system subject matter experts, project managers, data architects, as well as business users. Environment/Skills utilized -> AIX (ksh scripting), C, Perl, DB2, Informatica and Teradata. Personal: Ubuntu (debian) Linux, MySQL.January 2007 March 2008Data Warehouse Developer/Support Belcan Inc. www.belcan.com - subcontracted to Anheuser-Busch, Sunset Hills, MO.Data Warehouse EDW Support Problem identification, resolution, and enhancements relating to support group functions. Work is derived from 24x7 on-call paging system and user requests.Data Warehouse ETL Programmer - Designing, coding and testing data warehouse applications for Anheuser-Busch sales, inventory, production line and forecast data.Programming skills utilized: UNIX Korn shell scripting, support for Teradata, Oracle DLL, DML including Teradata CLI, fastload, and multiload and bteq scripting. Development / support for IBM Datastage Server, Enterprise Edition version 8.1. Monitor, update and add schedules to Tivoli Work Scheduler via client and composer scripts.Developed system using TWS, UNIX, Datastage and Teradata to capture and log to Teradata all Data Warehouse processes run via Tivoli Work Scheduler.March 2006 January 2007Data Warehouse Developer Ciber Inc. www.ciber.com - subcontracted to Wells Fargo Home Mortgage, Clayton, MO.Data Warehouse ETL Programmer - Designing, coding and testing applications for valuation and daily processing of bundled mortgage backed securities.Supporting production oriented development and testing environment including running and debugging real time UAT batch processes.Programming skills utilized: UNIX Korn shell scripting, DB2 DLL, DML including loader scripting, and IBM Datastage Enterprise Edition version 7.5 for parallel processing on IBM AIX 5.2 platform.November 2000 March 2006Senior Programmer Analyst US Bank, St. Louis, MO.Data Warehouse ETL Programmer - Designing, coding testing new applications for Banker Performance Incentive Rewards program. Developing applications utilizing Ascential Datastage Server and Parallel Extender on UNIX platform. Providing technical assistance to team members.Mainframe Programmer Designing, coding, testing new and existing interfaces for Data Warehouse. Participated in conversion process for Firstar Bank acquisition of Mercantile Bank, then US Bank merger with Firstar.Data interfaces include IBM UDB and Microsoft SQL Server. System interfaces include Performance Management, ATM, AFS/Commercial Revenue/Dealer Floor Plan, ALS, Credit /Debit Card, Direct Deposit, Fraud, and Trust .Programming skills utilized: IBM/MVS/TSO COBOL, JCL, VSAM, Easytrieve, UNIX, DB2, ORACLE PL/SQL, Ascential Datastage ETL and C++.1998 November 2000Senior Programmer - I-Structure, subsidiary of Level 3 Communications www.pksis.com - subcontracted to Pershing Technology Group, subsidiary of Donaldson, Lufkin & Jenrette, Florham Park, NJ.Responsible for all phases of project life cycle for Pershing's Individual Retirement Account tax reporting and notification system. Includes working hand and hand with business users in the creation and evaluation of requirements, testing, production implementation and follow-up. Primary job functions are coding and testing with MVS COBOL, JCL, CICS and Easytrieve,1996 1998Information Analyst - Electronic Data Systems - subcontracted to AT&T, New Brunswick, NJ.(includes period subcontracted to Electronic Data Systems from Chubb Programmer Resources 7/96 - 3/97)Development and production support on commercial billing systems.Coding in MVS COBOL, JCL, DB2.Testing with Expediter, SPUFI and Microfocus COBOL.Train team members on Expediter and AT&T concurrent development tool.Development and production support of the bill edit and format processes for residential billing systemTesting with Expediter, SPUFI, and Microfocus COBOL.Debugging and testing of new Microsoft Access based Employee Information DatabaseAssist in startup of Microsoft Access based concurrent development tool.1990 1995Prudential Reinsurance Co., Newark, New JerseyActuarial AnalystProject Leader - Reinsurance Reserving, supervising two Actuarial Assistants for the purpose of estimating company's unreportedoutstanding reinsurance liabilities. Projects include statistical analysesof claims data, the estimating of ultimate losses, interacting with underwriting, accounting, and claims personnel, and presenting resultsto senior management.Revising, streamlining and documenting APL computer programs for the Reserving and Valuation areas. Designing menus to make programs more user friendly.Preparing rate level comparisons and rate filings for submission to state insurance departments.1988 1990Clarendon National Insurance Co., New York, New YorkActuarial AssistantDesigned and updated spreadsheets for financial reinsurance contracts.Assisted in estimating claims, setting reserves, and the rating ofnon-standard auto lines using competitor analyses.1988 Continental Insurance Co., New York, New YorkPremium Adjuster - International DepartmentMaintained and updated an underwriting database1986 1987United Parcel Service, Maspeth, New YorkIndustrial EngineerScheduled tractor - trailer pickup and delivery operations, loweringweekly transportation costs per package by an average of 15%. Trained delivery and distribution personnel in safe work methods, conducted driver performance audits and supervised delivery operations.1984 1986Jamaica Water Supply Co., Lake Success, New YorkIndustrial EngineerDeveloped and installed a work measurement program for clerical units.Program was designed to keep track of productivity and determine optimal staffing levels.Education1996 Top Gun Training Program - Focus on MVS COBOL / Client ServerChubb Programmer Resources, Parsippany, NJCurriculum: MVS COBOL, JCL, TSO/ISPF, VSAM, Utilities, MS-DOS, MicroFocus COBOL/XDB, CICS/ESA, DB2/SQL, Novell LAN, Windows Environment/Word for Windows/Windows for Work Groups, C, C++, PowerBuilder, SYBASE, Object-Oriented Design and Data Analysis, Visual Basic1984 Polytechnic University; Brooklyn, NYM.S. Industrial Engineering1982St. John's University; Jamaica, NYB.S. Economics |
