Nathan Neely Email & Phone Number

Saint Paul, MN, US

Shoreview

Alexandria, Minnesota

• Converted/recreated 2005 packages to 2012 as parameterized packages in Visual Studio and deployed to DEV and QA environments for testing using the Team Explorer plugin
• Created SQL jobs that used environment variables in SSMS to run the new 2012 packages
• Reworked existing code as new SPROCs to deliver reports
• Tasked with converting an old Access application to SQL Server backend by utilizing Integration Services
• Used Red Gate’s SQL Compare and SQL Data Compare to ensure table structures and data content was synced between environments

St Louis Park

• Primary responsibility was to create reports in the dev environment based on the Business Requirements Document (BRD) and Data Dictionary, test the result sets for accurate data and create deployment and rollback.
• Reports were developed using Views, Stored Procedures and Functions as necessary in SQL Server Management Studio (SSMS)
• Because there was little to no data in the dev environment it was necessary to generate test data in order to reliably test the reports.
• Created business objects based on the BRD and data dictionary for more manageable and reusable code using Views
• Communicated with the business via emails and short ad hoc meetings when the defined requirements were unclear.
• Participated in daily SCRUM meetings and sprint planning meetings

Greater Minneapolis-St. Paul Area

• Created standard and dynamic T-SQL scripts to carry out data integration and ETL tasks
• Used specification documents to load confidential client data to staging environment
• Using the export feature in SSMS, I created Excel and basic tab delimited reports
• Assisted Business Analyst in updating and creating specification documents

St Louis Park

• Accomplishments
• Performed ETL functions using SSIS to extract and transform data from flat files, Excel spreadsheets, Oracle and SQL server data sources and Active Directory
• Tasked with leading a major move to a managed servicesenvironment which includes moving IIS, database and file serverresources for the department’s tools. Although leading this project Iwill be carrying out the tasks.
• Manage several databases within the department’s environment whichincludes creating and maintaining database objects, managing accessto the database objects, creating and managing SSIS packages usingBusiness.
• Developed a.NET web application using DevExpress and a MS SQLbackend to manage changes in the first call resolution knowledge data.
• Created several ‘On-Demand’.NET web based reports usingDevExpress and a MS SQL backend to free up several hours of weeklyand monthly manual effort

• Assisted in creating a solution to eradicate a virus outbreak onworkstations where the physical location was unknown
• Assisted in streamlining day-to-day processes such as the re-image process, by creating much needed forms

• Assisted with major BlackBerry rollout project including installation, configuration and support
• Assisted in supporting a re-rollout of Net Documents

• Accomplishments
• Gathered, tracked and implemented data which was used to develop and streamline processes both at corporate and retail levels
• Facilitated and fostered strategic relationships internally and externallybetween Software & Hardware Engineers, Departmental Project Leads,Onsite Technicians, Subcontracted Companies and Executives

Associates, Computer Electronics

High School Diploma

Activities and Societies: Track & Field