Kurt Nichols
9527 Brook Green [Send email to request phone number] 79-5024
San Antonio, Texas 78250
[Send email using form at bottom]
Business Intelligence Analyst
Career Objective
Opportunity in Information Technologies (IT) to utilize my project leadership
skills, client/server, object-oriented design and development expertise within a
dynamic growth oriented organization.
Qualifications Summary
Experience with fourteen operating systems ranging from IBM mainframes to
Client/Server:
100 base T Fast Ethernet MS Windows 95 SCO Unix/Xenix
Cable Modem/DSL MS Windows 98 Novell Netware
MS NT 4.0 Macintosh OS 1.0 thru 7.0
IBM AIX MS NT 4.0 Server
MS Windows 2000 and XP MS DOS 1.0 thru 7.0
MS Windows me LAN/WAN (TCPIP)
Performed database administration (DBA), database development and project
management for twenty-five years for both hierarchical and relational databases.
Responsible for both physical and logical design and analysis performed for
hundreds of small and large database projects. 8 years of Project Management
experience.
Database Experience:
15 years Lotus 1-2-3 (Macros) 15 yrs Excel (Pivot Table, Macros, SQL) 15 year
Outlook (Forms & Macros)
10 years MS Access/xp2007/20003/2000/97/95/2 (VBA, DAO, ADO, COM, ODBC, SQL) 10
years Q & A database
9 years Visual Basic 6.0/5.0 (SQL, COM, ODBC) 5 years SQL Server 6.5/7.0/2000
(T-SQL, Stored Procedures, Triggers)
5.5 years dBase III/dBase IV (SQL) 6 months Teradata SQL/Queryman 4 Years of
ERWin
4 years Oracle 7.3/8.0/9i 10g (PL-SQL, Stored Procedures, Triggers) 3 years
OLAP, ROLAP, OLTP
Programming Experience:
6 Years of Visual Basic 5 Years of Visual Studio.net 3 Years of Visual Source
Safe
5 Years of SSRS 2000/2005 3 Years eCommerce Content Management
3 Years of Crystal Reports 7.0 / 8.0/9.0/10.0g/11 xi 1 Year of Team Foundation
Server
3 Years of Business Objects 3 Years of Microsoft Project
Web Development Tools:
9 years VB Script 3.5 years HTML 2.0/3.0.4.0 3 years FTP Server 2 years
FrontPage 98
1 year FrontPage 2000 5 years ASP 1 year InterDev 6.0 1.5 Java Script
DHTML/XML
4 Years of ASP.Net 6 months JavaScript AJAX 6 months Flash 5.0/MX
Software Applications and Developmental Tools:
MS Project 98/2000 /2005 MS SourceSafe Crystal Reports 6.0/ 7.0 /
8.0/9.0/10.0/11 xi
MS Visio 5.0 / Visio 2000 Visual Studio 2000 Business Objects
UML Visual Studio 2003 SSRS 200/2005
Waterfall Quick Books MS SharePoint Portal
Iterative Full SDLC MS Visual Source Safe
Lean, Agile Scrum MS Visual Studio 2000/2003
MS Visual Studio (.NET, 6.0) CA UniCenter / AMO MS Publisher
MS SAPI CA UniCenter / AHD PageMaker
MS MAPI FolioView Ventura
CRM ERWin Speed Ferret 4.0
Rational Rose Robohelp Norton Utilities
ACT III, IV, 2000 PC Anywhere Remedy
Dragon Systems ERP Visio
Harvard Total Project CRM
Personal Information:
Published and authored 1,001 Things For Kids On The Internet
Published and authored 2,008 Cool Things For Kids and Teens On The Internet
AT&T -Telecomm Project Leader/Developer/DBA/Business Analyst
January 2008 – July 2008 Hands On Software Design/Development/Training
Crystal Reports, Business Objects, SQL 2005 Business Analyst
San Antonio, Texas
On this 6 month assignment, I utilized SQL Sever TeraData Cubes for data on one
of the world’s largest databases. I Used TerraData SQL Assistant 7.0 to write
very complex SQL Statements to include Inner Joins, Outer Joins, Full Joins,
Stored Procedures and Triggers on very, very large tables. There are over 10,000
tables. Utilized SQL Statements to Generate Lists based on very complex customer
data. Used SQL Server 2005 to validate SQL Queries, created AdHoc Reports for
the Southeast Marketing Group, I programmed SQL using DML, DDL in SQL Statements.
Optimized SQL code, and created ERWin diagrams as needed. I also programmed the
DataMart and updated tables as needed on the EDW – Enterprise Data Warehouse. I
used Visio to implement Workflow diagrams. I also used a SharePoint Portal to
obtain my projects and publish information on these projects. I also interfaced
with different business units to obtain project requirements.
USAA Insurance, San Antonio, Texas Project
Leader/Developer/Administrator/DBA
July 2007 – December 2007 Hands On Software
Design/Development/Training
Business Objects XI Release 2 Administrator Technical Writing/Business
Analyst
SSRS 2005, Crystal Reports
On this 6 month assignment, I utilized Crystal Reports to publish reports on
time from requests sent via email. I granted access to publish the report via
Active Directory. I also added, changed users’ rights and deleted users where
necessary. I accessed the Data Mart and Data Warehouse to insure the integrity
of the data structure for reports and created AdHoc Reports as needed. I also
installed Oracle 10g on 10 computers that were used to extract data for Crystal
Reports. I rewrote sections of the Process Maintenance Handbook for the BI
Infrastructure team. I developed over 200 MS Access 2007 tables, created forms
and reports to help the bank comply with the Credit Card input tables. I used
Team Foundation server to keep track of changes. I also created reports in SSRS
using OLAP. I also helped design the beginning of a Microsoft SharePoint Portal
by sharing my expertise with the team to start a SharePoint portal. I used Visio
to implement Workflow diagrams. I also used a SharePoint Portal to obtain my
projects and publish information on these projects. I also interfaced with
different business units to obtain project requirements. I also utilized Scrum
and Agile methodologies to meet Change Management request time.
Chesapeake Energy Project Leader/Developer/Administrator/DBA/Business
Analyst
February 2007 – May 2007 Hands On Software
Design/Development/Training
MS-SQL Developer/SSRS 2005 Developer
On this 3 month project, I created pivot tables in Excel 2007 that saved the
Shipping Supervisor hours of manually copying, cutting and pasting data that
related to the total quantity of oil available to ship in Chesapeake’s containers
thus saving their frustrated driving teams hours of waiting without being paid.
I installed Oracle 10g on 25 workstations that were needed for some oil rig data
for reports. I also provided AdHoc reports in Excel VBA, SSRS 2005, performed
optimization on SQL code where needed and utilized ERWin diagrams. I also helped
with 2005 SSIS, DTS and ETL packages. Microsoft Visual Source Safe and Microsoft
SharePoint were used to keep track of changes to the code and documentation. I
utilized Excel VBA Pivot Table macro programming (only 3 percent of all Excel
users know how to program pivot tables). I interacted with supervisors and IT
managers to give status updates on these projects. I used Team Foundation server
and Visual Source Safe. I also performed requirements gathering. I managed a
team of 5 people on this project to complete and deliver the project on time and
on budget. I also connected to OLAP databases in SSRS reports. Scrum and Agile
methods were utilized on this project. I was flown from Dallas to Oklahoma City
weekly so I could have time at home on the weekends. I also worked remotely from
Dallas as needed. I also helped with eCommerce Content Management system on
their website.
NationStar Mortgage Project Leader/Developer/Administrator/DBA
December 2006 – February 2007 Hands On Software
Design/Development/Training
MS-SQL Developer/SSRS 2000, SSRS 2005 Developer
On this 3 months project, I kept ASP reports running over companywide Intranet
for over 2,000 users, programmed SQL Server 2000 Reporting Services using
Microsoft Visual Studio 2003 , used Microsoft C# and ASP.Net C#, OOPS,
JavaScript, and ASP Classic. I also uploaded SQL Server 2000 Reporting Services
RDL files to SQL Server 2000, created 2005 SQL Server Integration Services (SSIS)
packages, used Microsoft Visual Source Safe to check in and check out projects,
used Microsoft Share Point to keep documentation up to date regarding projects.
I always interacted with Business Analysts and Project Managers to give status
updates and recommend changes and performed requirements gathering with end users
as a Business Analyst. Interacted in weekly meetings with IT Manager to give
status updates on projects, utilized documentation prepared by Business Analyst
to complete projects, used DTS and ETL and SSIS as needed, also used PL SQL,
Toad. I installed Oracle 10g on 35 workstations for the REO department. I used
Team Foundation server to keep track of changes. I used Visio to implement
Workflow diagrams. I interacted almost daily with other Business Analysts and
interfaced directly with other business users to make sure the projects were
being completed and on time and on budget. I also used Business Analytics to
prioritize reports, resulted in NationStar keeping up to date with Federal
mandated reports that needed to be addressed within 72 hours (HMDA).
PROFESSIONAL FULLTIME EXPERIENCE
Northwest Educational Center Project
Leader/Developer/Administrator/DBA
January 2006 – December 2006 Hands On Software
Design/Development/Training
MS-SQL Developer/SSRS 2005 Developer Business Analyst
On this fulltime job, I Kept ASP reports running over companywide Intranet for
over 2000 users. I personally solved every help desk ticket resulting in perfect
completion of all tickets. Programmed SQL Server 2000 Reporting Services using
Microsoft Visual Studio 2003, created and dropped tables, and optimized SQL code.
Used Microsoft C#, ASP.Net C#, OOPS, some Java and XML, I also uploaded SQL
Server 2000 Reporting Services RDL files to SQL Server 2000, created 2005 SQL
Server Integration Services (SSIS) packages. I used Microsoft Visual Source Safe
to check in and check out projects. I utilized Full Software Development
Lifecycle (SDLC) implementation achieved. Created SQL 2000 stored procedures and
triggers, created SQL 2000 cubes. I used SQL Sever 2000 Analysis Services, DTS,
ETL, SQL queries, SQL 2000 SSRS and some PL SQL and Toad, performed requirements
gathering with end users as a Business Analyst, tested all software and made
Quality Assurance and Control test through manual testing. I kept track of
prospect new student with a eCommerce Content Management system. I installed
Oracle 10g on 10 workstations for classroom use. I interacted almost daily with
other Business Analysts and interfaced directly with other business users to make
sure the projects were being completed and on time and on budge.I used Microsoft
Project timeline utilization for tracking the entire project from start to
finish. created reports using Crystal Reports 9 using imported data sources. I
worked remotely from home full time. Used Web Analytics to determine how
potential students responded to website. Project Manager. Managed 6 people on
this project in person and remotely.
Sigma Mortgage Group Project Leader/Developer/Administrator/DBA
NorStar Mortgage, Hands On Software Design/Development/Training
Mortgage Strategies Group Mortgage Loan Officer
July 2002 – December 2005 MS-SQL Developer/SSRS
2000, 2005 Developer
I prepared Mortgage Loan Applications (1003’s) using Calyx Point, took all
necessary information from the client and gathered paperwork needed and processed
my own loans. I programmed databases to keep track of clients as needed and to
determine which lead companies were best to use. I also performed requirements
gathering with end users as a Business Analyst. I used Microsoft .Net 2003 and
Microsoft .NET 2005
Sector 7 Project Leader/Developer/Administrator/DBA
January 2002 – June 2002 Hands On Software Design/Development/Training/Business
Analyst
MS-SQL Developer, Access and Excel VBA Developer
Created website utilizing ASP and Microsoft .Net technologies, developed n-tier
components in Visual Basic 6.0 and SQL 7.0 web enabled database, tested all
software and made Quality Assurance and Control test through manual testing. I
created website utilizing ASP and Microsoft .Net technologies. I used Microsoft
Project to track the project. I created reports using Crystal Reports 9 using
imported data sources. Created SQL 2000 stored procedures and triggers, Created
SQL 2000 cubes. I also created SQL Tables, and optimized the SQL Code on
queries. SQL Sever 2000 Analysis Services, Used SQL queries to pass data, SSRS
2000 and some PL SQL, Toad. Project Manager. Managed 10 people on this project,
delivered on time and on budget.
Entergy
June 2001 – December 2001 Project
Leader/Developer/Administrator/DBA
MS-SQL Developer, Hands On Software Design/Development/Training
Access and Excel VBA Developer Business Analyst
Automated spreadsheets for Energy Analysts showing customer meter usage and
other detailed information. Created tables in Access 97 and Access 2000
containing all vital information needed to produce long term and short term
forecast. Tested all software and made Quality Assurance and Control test
through manual testing. I performed requirements gathering with end users as a
Business Analyst. Created SQL 2000 stored procedures and triggers, SQL 2000
cubes, SSRS 2000 and some PL SQL, Toad. SQL Sever 2000 Analysis Services. Used
SQL queries to pass data, create and delete tables, and optimize SQL code.
Rational Software Project Leader/Developer/Administrator/DBA
January 2001 – May 2001 Hands On Software
Design/Development/Training
MS-SQL Developer, Access and Excel VBA Developer Business Analyst
I was responsible for creating reports on Web Site Metrics. Determine how much
time users spent on specific pages and where they were entered the website from
and where they left to. I also created reports in Professional Quest reporting
system which is very similar to Crystal Reports, produced web site metrics
report. I used the Full Software Development Lifecycle (SDLC) implementation
achieved. SQL Sever 2000 Analysis Services, used SQL queries to pass data. I
created and dropped tables, and optimized SQL Code. I also converted Oracle
PL/SQL to SQL. I used SQL Reporting Services 2000, TSQL, stored procedures,
triggers, cubes. I also utilized Web Analytics to develop scorecards on Rational
University different schools throughout the US. Developed scorecards to report
activity based on student response. This resulted in more students spending the
time needed to fill out applications on the Internet. Monitored user activities
on website, to determine how much time each user spent and where they went after
viewing that page to help determine how to keep their attention. I worked
closely with eCommerce Content Management system team.
Lucent Technology Project Leader/Developer/Administrator/DBA
June 2000 – December 2000 Hands On Software Design/Development/Training
MS-SQL Developer, Access and Excel VBA Developer Business Analyst
I programmed Bill of Materials for job costing, to help sales reps make quick
informed decisions while on sales calls, I also converted over 200 MS Access
databases to MS Excel spreadsheets. I programmed macros as needed. I wrote
detailed procedures for solutions for users, used MS Visual Basic 6.0, used Excel
VBA ADO. I also tested all software and made Quality Assurance and Control test
through manual testing.
Unocal Project Leader/Developer/Administrator/DBA
July 1998 – July 1999 Hands On Software Design/Development/Training
MS-SQL Developer, Access and Excel VBA Developer Business
Analyst
Excel VBA Programmer Business Systems Analyst/Quality Assurance Analyst, I also
performed an audit of all Lotus 123 spreadsheets that needed to be converted.
Converted 8 years of Lotus 123 Spreadsheets to Excel VBA in one year during Y2K
compliance and testing. I developed SQL 7.0 to extract information for some of
the spreadsheets that the accountants needed. These spreadsheets were uploaded to
an Oracle database using an FTP client to determine the allocation of oil lease
expenditures for the Spirit Energy Revenue Accounting group. Helped with Project
Management to assure critical tasks were met on time for Y2K. Insured macros ran
on spreadsheets containing financial data for oil leases including, general
ledger, accounts payable, accounts receivable. I programmed SQL, TSQL to access
data and converted Oracle tables to SQL using PL/SQL and Toad. I created Job
Costing for the State of Texas Crude Oil Tax Forms templates in Excel that
balanced Spirit Energy’s Tax Payouts to the penny on a $51,000,000 monthly
report. Tested all software and made Quality Assurance and Control test through
manual testing. Placed software on Y2K compliant servers and tested to make sure
the dates would stay in place.
Please email or call for my full resume. |
