Lohn Solutions

1. Changed Mail server for all SQL2005 servers and script that creates it2. Data pull for auditors from JDE- Streamlined process and optimized- Went from taking 4 hours to 15 minutes3. Template created to direct users to our ticketing system4. Teleforms issue – SQL updates with data moved around and mapped [...]

A holiday and my first sick day in a few years made this week go fast. Here’s this week’s weekly challenges:1. SalesForce.com Data Loader update moved to production – things went smooth as we worked the kinks out in QA as the environment is designed2. Year End Data Change Requests – [...]

Here’s this week’s challenges:1. Merry Christmas! It was a great Christmas for me!2. Skied Breckenridge3. Year End Data Corrections- Planning for what is coming- Getting a bunch in before year end close4. Data Loader Changes for SalesForce.com changes in QA- SQL2005 SSIS Packages updates and new packages- [...]

Here’s this week’s Weekly Challenges

1. Year end data correction planning- New processes in JDE for 2008 require clean up for new year2. New Cube in Cognos QA environment3. Nimbus fast track – working on creating some dashboards for the BI environment4. Cognos Security Groups Definitions- Working on creating documentation [...]

Well, I sold my house and moved, so the Weekly Challenges have been on hold. Here’s some of the missed highlights since 11/02 highlights…

1. Passed Microsoft SQL Server 2005 Implementation & Maintenance Exam2. Onbase Upgrade – moved database to new server3. Altered custom web app to point to new server4. [...]

1. Centerfield Technology Homerun package Training- Used tools in production for troubleshooting AS400 and Cognos locks- Similar to MSSQL management software I’m used to

2. Tracing Cognos servers during month end processing for troubleshooting AS400 and Cognos locks- Every hour on the hour ran traces- Traces locked up servers twice as it uses lots of memory

3. [...]

Here’s this week’s weekly challenges…1. Custom Web App #1 Rolled out2. Cognos Changes – realignment – historic data realigned and promoted – new model with tightened security and changes for realignment – testing client on Oracle hosted site – changed process that triggers [...]

Here’s this week’s weekly challenges…

1. Audit data pulls – Had to export entire table for auditors – Came up with function for Julian date2. New Cognos group – New group of developers getting started with Cognos – Going against hosted oracle servers3. Cognos [...]

Here’s this week’s weekly challenges…

1. Audited on Cognos again, this time by an external Auditor on: – Server security – Change process

2. Custom web app – Security issues were actually database security issues (service account didn’t have rights to execute new login procedure) – DNS got updated, so now there is a user [...]