Sql Server .Net Sales Business Developer Data
Resume:
Troy L. Rockwell
Madison, WI *****
****.********@********.***
Summary
Highly motivated Business Intelligence Professional with experience, using SQL Server 2005 and
Microsoft Technologies. Experience manipulating various data sources to support Senior
Management decisions. Demonstrated leadership abilities and team work skills as well as the ability
to accomplish tasks under minimal direction and supervision.
Certifications
Microsoft Certified Professional - C# .NET
Microsoft Certified Application Developer - C# .NET
WebSphere 3.0
TECHNICAL SKILLS
Microsoft Technologies:
SQL Server 2005 Integration Services, SQL Server 2005 Analysis Services, SQL Server 2005
Reporting Services, Microsoft Office SharePoint Server 2007, Microsoft Visio, C#.NET, VB.NET,
ASP.NET, ADO.NET, XML/Web Services, HTML, (Transact)T-SQL
Databases:
MS SQL Server 2005
Software:
Visual Studio .NET 2005, SQL Server Business Intelligence Development Studio, Visual Studio
SetFocus, LLC Madison, WI 3/09 - 5/09
Business Intelligence Master’s Program
• Implemented a Labor Analysis Business Intelligence solution for a simulated national
construction company.
• Existing data from diverse data sources were consolidated into a uniform SQL Server 2005
database. SQL Server Integration Services was used to define imports of the data, build
scheduling packages, to define integration flow, log data error exceptions and orphaned data
and to define Database Maintenance Plans and send emails.
• Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis
Services representing aggregations in several different ways - hierarchically and using custom
groupings that the company will use to analyze performance. Created several MDX queries
according to business requirements.
• Developed several detail and summary reports including line and pie charts, trend analysis
reports and sub-reports according to business requirements using SQL Server Reporting
Services.
• Implemented business intelligence dashboards using MOSS 2007 Report Center and Excel
Services producing different summary results based on user view and role membership.
• Created score cards with executive summary dashboards using MS Office Performance Point
Server 2007 Dashboard Designer that display performance monitoring measures for sales,
sales trends, and book return rates for a simulated book publisher deriving data from a SQL
Server 2005 OLAP data source and deployed them to SharePoint sites . The dashboards also
contain drill-down capabilities to view book sales by book category and customer, through
summary reports and sales trend charts.
• Created score cards with advanced set of dashboards using MS Office Performance Point
Server 2007 Dashboard Designer that feature executive summary measures for revenue,
overhead costs, material purchases, labor and profitability trends for a simulated construction
company extracting data from a SQL Server 2005 OLAP data source and deployed them to
SharePoint sites. The dashboards also contain pages to view performance by employee, by
region, and by quarter enabling end-users to make filter selections.
Experience
Exacta Corp. Madison, WI 11/08 – 1/09
Sr. IT Consultant
• Key contributor for a premier IT consulting company to create database objects, stored
procedures, views, data access objects, and business reports.
• Converted Crystal Reports to Dynamic PDF.
• Created and updated web pages using VB.NET in VS2005.
• Created stored procedures to return results for reports.
Communication Logistics Inc. Stevens Point, WI 1/08 – 6/08
Sr. IT Consultant
• Analyzed Database System to determine the most efficient way to access the inventory, sales
and product data.
• Designed Business Object Model.
• Created Custom Reporting System utilizing C#, ASP.NET, AJAX and VS2003.
• Built database objects, stored procedures, views, data access objects and AJAX enabled
reports.
• Created stored procedures to insert data and return data for reports.
Compuware Appleton, WI 10/07 – 1/08
Sr. IT Consultant
• Developed web pages for an insurance company using VB.NET VS2005.
• Modified HTML and web front end for insurance agency application pages.
• Modified VB.NET Application to access BOM information from T-SQL database and calculate
costs of products.
• Utilized ADO.NET, T-SQL, and SQL Server 2000.
IBS Neenah, WI 7/07 – 9/07
Sr. IT Consultant
Trained employees in AJAX and VB.NET. Researched and investigated problems with 3rd party
•
software, then trained developers appropriate fixes.
• Worked with T-SQL, and SQL 2005.
Jackson Hewitt Sarasota, FL 12/06 – 3/07
Business Intelligence Consultant
• Created Win Forms application to gather information and display data, utilizing C#.NET and
VB.NET.
• Analyzed and validated OLAP Data Cube data and processes.
• Developed weekly and daily SQL 2005 Processes to perform validation of Cubes.
• Pulled data from SQL 2005 using MDX and T-SQL to compare results to validate queries.
MTS-Medical Technologies Saint Petersburg, FL 8/06 – 11/06
Application Development Consultant
• Added new enhancements to the system based on requests from the design staff and the
medical technicians supporting the project.
• Gathered user input for application specifications. Created the user interface, middleware and
database structure to complete the design.
• VB.NET programming using Win Forms, an Oracle Database and an Inventory Locker.
• Created stored procedures to insert data, retrieve data, for convenience and security.
Veredus Saint Petersburg, FL 4/06 – 7/06
Sr. Developer/Consultant
• Tasked with bringing a problem website online that had been under development for two
years by a team of five programmers, graphic artists and online content writers.
• Built site on a SQL Server 2000 database, using T-SQL, with over a hundred tables and
several hundred stored procedures and thousands of files, both HTML and ASP.
• Repaired pages that did not work, fixed queries that returned bad data and in some cases
created new pages with the corresponding tables and stored procedures.
• Created new tables and methods of updating tables and reading data using stored
procedures.
• Gathered user specifications and created the user interface, middle ware and database
structure.
• Worked with the customer to create the application from the user requirements.
CONTACT911 Clearwater, FL 2/06 – 4/06
Sr. Developer/Consultant
• Core contributor to bring the corporate Contact 911 site online. This website was written in
ASP.NET with VB.NET and SQL Server. Site was structured as three web sites, the Consumer
Site, the Corporate Site, and the Enterprise Site.
• Collected user specifications for functionality and created the user interface, middle ware and
database structure to complete the design. Work required knowledge and experience using
SQL Server and ADO.NET, with stored procedures.
• Delivered corporate website project ahead of schedule was awarded the task of working on
Enterprise site.
• Completed massive redesigns with major enhancements to account for larger user lists,
management of those lists and user permissions.
• Added numerous pages to the site to manage the groups and the permissions for these
groups of users.
• Created T-SQL stored procedures and triggers to maintain database integrity.
National Flood Services Kalispell, MT 8/05 - 2/06
Application Development Consultant
• Effectively developed applications in C# .NET, modified and supported traditional ASP and
ASP.NET applications on an insurance website.
• Gathered customer specifications and created the user interface, middleware and database
structure to complete the design.
• Used VS 2003, and ASP/ASP.NET, SQL Server 2000, and connected to an AS400 for the
database.
• Varied with tasks as mundane as applying validation controls to pre-existing ASP.NET pages
written in VB.NET and as exciting as redesigning systems for speed. One such system was
the mailing system.
• Determined system issues, applied appropriate fixes. Processing time went from 11 hours
down to 15 minutes, and the system was ready in about 6 weeks.
• Create T-SQL stored procedures to abstract database from application, and avoid dynamic
SQL.
JP Morgan Chase Tampa, FL 05/01 - 8/05
Sr. Technical Officer
• Hands-on team member on numerous systems, including a UNIX based project loading
customer information files into an Oracle system on a monthly basis.
• Used VB, DTS, and Oracle PL/SQL and UNIX scripts to transfer the file and automate the
process.
• Developed applications, worked on legacy systems using VB 3.0 - VB 6.0, VB.NET, C#.NET,
ASP.NET, MSAccess, ASP, XML, SQL Server, UNIX, Java, Oracle, and XP.
• Designed and supported a system for two years that was created in VB 6.0 with a SQL 2000
backend. Program monitored the flow of over a trillion dollars a day coming through our
systems to the Federal Reserve.
• Added a new link between over a dozen mainframe and mini systems by simply adding a row
into the database. This would then show that information on the screen in a graphical form.
• Introduced to .NET technology and used VB.NET and C #.NET on several prototype designs.
• Oversaw VB application that controlled information transfer between two mainframe systems
via terminal emulator programs.
• Developed a Java based bank name search program where all client banks were listed in a
SQL database using T-SQL that could be accessed via the web. The program was accessed
through a private portal and listed the specific banks depending on search criteria entered by
the user.
• Created stored procedures and views to retrieve data and insert data into database.
IMR Global Clearwater, FL 9/99 - 12/00
Software Engineer / Consultant
• Developed applications using VB 6.0 with T-SQL, DCOM, XML. Trained new programmers on
the team in technical environment.
• Developed mutli-tiered applications for clients and had to work on client sites for weeks at a
time.
• Created User Interfaces for ASP web pages and desktop applications.
• Created stored procedures and maintained access methods to database for security.
EDUCATION
University of Phoenix
Master’s Degree - Information Systems
Bachelor’s of Science - Information Technology
Contact this candidate