Paul Dailey Email & Phone Number

Johnston, Iowa, United States

West Des Moines, Iowa

• SSIS ETL Development - corporate finance (Microsoft Dynamics AX), corporate sales, HR, and customer technical support data• Data Modeling• SSRS ad hoc report development for HR compliance requirementsCreate T-SQL stored procedures with SSMS• Build logical and physical data models to support data needed to meet business requirements• Identify and extract data from multiple disparate systems of record, transform and load into data warehouse and load to our data analytics platform, ThoughtSpot• Build security for customized access for internal end users and our clients in ThoughtSpot• Create SQL jobs for scheduled data loads to analytics platform• Salesforce/Fusion report development with Conga Conductor for risk management, control, and mitigation reports

West Des Moines, Ia

As a Developer Consultant, I assisted clients in solving complex business and process challenges related to technology. I have developed front end user interfaces, created APIs, supported middleware, and have developed and revised database stored procedures.

Des Moines, Iowa Area

• Oracle 11g database analysis, ETL development, and support of CORE mortgage loan origination• Develop and update SQL scripts with SQL Developer• Tailor environment specific property files• Utilize Tortoise SVN for version control• Develop and configure JSON security files tailoring users access to CORE• Create application reference data in XML• Coordinate build and deployment activities• Validate OLTP and OLAP builds during UAT, SIT, and QA environment deployments• Create PL/SQL pipeline migration scripts• Troubleshoot and resolve Oracle and proprietary database errors during environment deployments• Create builds and deploy release tags to staging, stabilization, testing, and development environments

Johnston, Ia

• Full stack .NET development of an external client web application (SeedGrower)• Developed and tested application as part of an Agile/SCRUM team and utilized paired programming principals• Developed mulitple components of application including commodities pricing, current and historical marketing data based on user, and current/planned field chemical applications• Created UI in AngularJS framework utilizing Typescript and ES6 standards• Front end responsive design with Angular Material, Flexbox, and SASS• Created APIs in C#• Utilized RESTful Web Services for communication between client and server• Developed stored procedures in SQL• Created unit tests in Jasmine framework• Developed and refactored Angular modules, directives, services, controllers, and factories• Refactored Typescript authentication library and existing session service to created login, logout, and authentication for application• Built and deployed code shelvesets with TFS and through Octopus Deploy to staging, testing, and development environments• Corrected application bugs discovered during regression testing• Conducted manual testing and resolved styling/layout issues on iOS and Android mobile devices

Des Moines, Iowa Area

Des Moines, Iowa Area

Des Moines, Iowa Area

Scottsdale, Az

Chandler, Az

Bs, Marketing

Web Development Certification