Profile
Summary
2011 - Deployed Third Party Integration tool (Dell Boomi) to Streamline Account and Prospect Entry Between Sales (SFDC) and MSP (Connectwise) Software. Developed Dynamic Gross Margin and Resource Management Reporting to provide top-down reporting from a Global to individual engineer level; identifying areas of improvement across all regions.
2010 - Implemented and managing streamlined reporting solution using Microsoft SSRS 2008 to provide better insight into revenue, utilization, and client transparency.
2009 - 2010 - Designed and implemented Business Processes and configuration for Connectwise PSA Solution. Responsible for Data Migration and Process translation from the old CRM software as well as remapping and redesigning custom reports.
2007 to 2008 - Designed and deployed Crystal-Based Reporting across 6 regions. Increased insight into Employee Utilization and Client Transparency
2007 - Aided in the design and Implementation of PowerHelp CRM Software across 6 regions
Goals:
- Further development of Microsoft SSRS, SSAS, and SSIS skills
- Develop .NET applications for Reporting with custom system integrations
- Develop Knowledge of Microsoft SQL Azure for Cloud based Databases and Microsoft Pivot for Report Cataloging
- Do Better. Everyday.
Experience
- Dec 2011 - PresentProcess Development Engineer / Black Mountain Systems
- Apr 2010 - Dec 2011Senior Reporting Services Analyst / Eze Castle IntegrationDevelopment of reports providing BI to Management; Established best reporting practices, standard
presentation formats and report documentation across the organization; Minimized turnaround times on Gross
Margin and Resource Management reporting; Identified business data tracking needs and initiated needed system
changes and upgrades; Integrated HRIS System data into Data Warehouse for improved Resource Management
tracking; Deployed Third Party integration software to Streamline Account and Prospect entry from Salesforce.com to Connectwise - Jan 2010 - Apr 2010Reporting Services Analyst / Eze Castle IntegrationSupport for Connectwise PSA software; Designed, developed, implemented, and managed streamlined reporting
solution using Microsoft SSRS 2008 to provide better insight into revenue distribution, utilization, and transparency.
Major Duties and Responsibilities:
1. Report Writing and Automation
*Prepare efficient and user-friendly reports for the end user community.
*Support the design and development of end-user reporting tools and processes.
*Embrace the creation and maintenance of an enterprise reporting environment by establishing best reporting practices, standard presentation formats and report documentation.
*Employ a reporting structure that efficiently utilizes system resources and embraces automation tools that minimize turnaround times.
*Update existing reports to more current reporting standards.
*Define, manage and prioritize customer reporting needs.
2. Data Management, Extraction, and Manipulation
* Possess knowledge to master all organizational data structures and keep skills current for purposes of data extraction as new data evolves.
*Create complex queries to extract data from the company’s relational databases.
*Prepare extracted data for use in all organizational reporting and presentation tools.
*Identify business data tracking needs and initiate needed system changes and upgrades.
*Achieve ownership of reporting processes and audit procedures to ensure complete accuracy of data extraction.
3. Communication and Presentation of Findings
*Present new reports and processes to internal clients (both verbally and in writing).
*Conduct end-user and technical training on reporting tools as necessary - Sept 2008 - Jan 2010Software Analyst / Eze Castle Integration
- Sept 2007 - Sept 2008IT Operations Associate / Eze Castle IntegrationSupported Powerhelp MSP Software; Designed, developed, and deployed Crystal Reports XI Reporting from Backend Databases across 6 regions; Increased insight into employee utilization and client transparency
- Aug 2005 - Aug 2008Owner / Infinite T Consulting, LLC
- Aug 2005 - Feb 2008IT Administrator / Universal Wrecking Corp.
- May 2007 - Aug 2007Operations Intern / Eze Castle Integration
Education
-
2003 - 2008Stevens Institute of TechnologyB.S. in Business and TechnologyActivities: Beta Theta Pi, Stevens Paintball Team
Additional Information
Updates
Photos
Recent tracks
-
Late for Work (Pnuma Trio Remix) by STS92 months ago
-
2 months ago
-
2 months ago
-
2 months ago
-
2 months ago
-
2 months ago
-
2 months ago
-
2 months ago
-
The New Soma (Daedelus Remix) by STS92 months ago
-
2 months ago
Top artists
Top tracks
-
2 plays
-
2 plays
-
2 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
Bellwether by Lotus1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
1 plays
-
Regeneration by STS91 plays
-
1 plays
-
The New Soma by STS91 plays
-
Squishface by STS91 plays
-
1 plays
-
1 plays
-
1 plays
Posts
- Brian Weiner: 10:56 AM a black spiderman would be aweosme
- Taylor Fowler: 10:56 AM we need to make him our friend in real life
- Brian Weiner: 10:56 AM if they're gonna give me a black karate kid
- Taylor Fowler: 10:56 AM HAHAHA. exaclty
- Brian: id imagine you guys have ms 07
- Brian: office
- Me: pssh. i got 2010 son
- Brian: damn
- Brian: i just got served
- Me: hahaha
In honor of Mothers’ Day, a reprint of a piece I originally wrote for my mom’s birthday about six months ago.
(me and my mom, 1981)
My mom’s current (modest) salary, as a Junior College professor, is the most she’s made in her life, and living alone in San Francisco it still barely qualifies her for the middle class. Despite that, her home is filled to the gills with beautiful things, and her wardrobe is, too. Our home was always full of beautiful things, even when I was eight or nine, and she was working her way through graduate school as a single mother in her 40s.
Partly, it’s because she’s got taste, which she’s developed over many years. In large part, though, it’s because she’s a truly great shopper. She’s taught me a lot about how to get a lot for a little, and how never to want, even when you’re broke.
What I’ve learned from her can help you build a wardrobe, no matter what your income level is.
Here’s how you can shop like my mom:
Know what you need. My dad can only shop for one thing at a time. He can shop for a new Accord and find a good deal, but if he was on his way to buy lettuce and saw a mint ‘56 Chevy for sale for $1200, he wouldn’t be able to wrap his head around buying it. My mom always knows what she needs, and what she’s going to need… and, for that matter, what everyone close to her needs. I can tell her that my wife and I need some napkins, and two months later, a bag appears at my doorstep full of linen napkins from the 50s that my mom bought for a dollar. My mom keeps a running tally in her head of what she’s low on, what might need replacing, what holes have sprung up in her material world… and when the opportunity presents itself, she strikes.
Accept that you might not get it now. If you look at your purchasing decisions as a problem that needs an immediate solution, you’ll always end up at Target or Ikea. When you actually give some consideration to what really is a “must have it now” item (roof repairs) and what’s a “when it comes along item” (new sweater), you can buy from a position of strength.
Plan ahead. A reader emailed today asking about where he could get a good, affordable winter hat. It’s November right now, and winter hat prices are at their peak. If the reader had bought a hat in February, he could have shopped at Saks instead of H&M. It’s even OK to have a little surplus of things that won’t go bad — you can buy the big box of Bisquick, or and you can buy two classic cashmere toques when they’re marked down to $19.
Used is your friend. Remember that the biggest drop in value comes when you drive that new car off the lot. The time investment may be slightly greater, but the savings is huge when you buy used, and if you know how to buy things that aren’t “used up,” (either functionally, as in pilling sweaters, or aesthetically, as in out-of-style clothes), you will benefit. You want things that are worn in, not worn out.
Buy things for less than they’re worth. My mom is a hustler. When she sees a chance to buy low, she does - when you’ve got things of value you can always trade or sell them. Don’t confuse this with buying cheap things, or even things that are marked down. A high-school friend’s dad used to buy marked-down VHS movies at the Wherehouse. He had a house full of videos, and they were all cheap, but none of them were good enough to watch, to say nothing of being good enough to sell. I know when I buy an Oxxford suit at the thrift store that if I decide I don’t like it, I can always sell it for more than I bought it for.
Buy things that hold their value. Generally I’d say buy things that increase in value, as good art or furniture does, but with clothes, that’s tough. Fashions change, and clothes are easy to damage. Remember, though, that when you tear the tags off of that shirt from H&M, its value goes from $20 to $1 in an instant. The naval peacoat I bought at a garage sale in high school is still worth two or three times the $20 I paid for it.
Buy things that are repairable. Good shirts can have their collars and cuffs replaced. Good shoes can get new soles. Good luggage can have straps replaced. Whenever possible, buy things that can be fixed, rather than discarded.
Don’t confuse price and value. Quality correlates to price, but it certainly doesn’t correlate to price directly. There’s plenty of expensive crap out there, and there are plenty of big markdowns that aren’t very useful to you. It can be tough to resist that orange cashmere sweater marked from $490 to $49 - that’s 90% off. But how valuable is an orange cashmere sweater to you? Unless you’re in a community theater production of It’s The Great Pumpkin, Charlie Brown, it may be less than $49, no matter what the original price sticker says. Similarly, brand has gone from a shorthand for quality to a shorthand for, well, brand. A tag that says “Coach” used to mean the best in leather goods. Now it means you can afford to buy Coach branded leather goods. Or knockoffs thereof.
Put yourself in a position to win. My mom’s a creative shopper. She gets up early to go to estate sales. She has tons of saved searches on Ebay. She stops at garage sales. She puts herself in a position to find something amazing, and when it comes up, she’s ready to buy. Serendipity is the child of persistence.
Know what’s good. This one’s about skill. Skill’s about talent, in part. My mom has a great natural aesthetic sense. But it’s also about knowledge. She can evaluate whether the piece of pottery in front of her really is pre-Columbian, and she knows the names of the best leather goods makers in England. What’s great is that her knowledge and experience don’t just make her a walking reference book, they also make her guesses much better. Memorizing the best makers can help you spot pieces by those makers, but learning to spot quality means that you can be confident in your own assessments.
Don’t confuse quantity and quality. When you get an $1800 sportcoat for $300, you have not bought the right to buy five $300 sportcoats. You’re living within your budget, or you’re saving money for another day. You don’t want to end up with a house full of VHS copies of Prayer of the Rollerboys.
Move up the ladder. If you have something decent, don’t buy another piece of comparable quality. It’s redundant. Buy one that’s better. You don’t want more: you want better.
Buy amazing things. My mom looks at a lot of things in a given month. When she sees something - once or twice a year - that she truly loves, she buys it. Even if it’s expensive. Then she figures out how to pay for it. If something really speaks to you, it’s worth the money.
So… think about what your ideal wardrobe is. Learn about quality. Put yourself in a position to catch lightning in a bottle. Be patient. And make it happen.
- Brian Weiner: 10:30 AM well i told ward to do css. he was being stubborn about it but i convinced him if he wouldn't dive into ruby at least do something vaguely useful like css
- Taylor Fowler: 10:30 AM which is interesting since when we've talked about building websites, he's always so concerned about the design and look. which is what he'd be controlling if he was doing css
- Brian Weiner: 10:31 AM right. and he wanted to get better at photoshop, so same difference
- Taylor Fowler: 10:31 AM yep
- Brian Weiner: 10:31 AM and he likes blowing dudes so it works out for everyone
- Taylor Fowler: 10:31 AM good point
- Keisha Eremic: you belong in brooklyn
- G-Chat: yeah, it's becoming more and more apparent
- Keisha Eremic: hahahah
- Keisha Eremic: i'm not saying JC doesn't have cool things going on...like the same initials as Jesus Christ
- Keisha Eremic: but BK is in your blood
- G-Chat: But BK is the same initials as Burger King...and quite Frankly, i prefer the latter
Time to nerd out again…
<nerd>
Threw this bad boy together to generate 15 minute time increments per row, then join it up with time values based on whether or not they fell within the time-slot:
with interval as
(
select cast(‘00:00:00’ as datetime) TimeValue —start value
union all
select CASE WHEN TimeValue = ‘1900-1-1 23:45:00’ THEN DATEADD(n,14,TimeValue) ELSE DATEADD(n,15,TimeValue) END —increment w/ case statement to account for midnight
from interval
where DATEADD(n,14,TimeValue) <= ‘1900-1-1 23:59:59’ —termination value
)
select interval.TimeValue, {workdatabase}.*
from mycte FULL OUTER JOIN {workdatabase} ON CAST ({workdatabase}.Punch_Time as datetime) BETWEEN interval.TimeValue AND DATEADD(n,14,interval.TimeValue)
ORDER BY TimeValue
OPTION (MAXRECURSION 0)
</nerd>
- Brian Weiner: i don't think i can google funeral rape here
- Brian Weiner: which seems fascist
- G-Chat: hahahah good point
- G-Chat: however
- G-Chat: http://webcache.googleusercontent.com/search?q=cache:hs9GLEn31LgJ:www.lyricstime.com/funeral-rape-lyrics.html+funeral+rape&cd=4&hl=en&ct=clnk&gl=us
- G-Chat: that may work
- G-Chat: eh...still got rape in there
- Brian Weiner: did you witness him make it
- G-Chat: yes
- G-Chat: but i wasnt paying attention
- 09: 45
- G-Chat: he could've not used it, but we were out of mlk
- G-Chat: milk, not martin luther king junior
- G-Chat: although i guess we're out of him as well
- Drew Cottrell: i love that "going armed in terror of the public" is only a misdemeanor
- Drew Cottrell: Brian says Bennick could be charged daily
- G-Chat: hahaha
- Ryan Bennick: oh and u never threw in for lotus
- Ryan Bennick: the juice is running.
- G-Chat: lotus in PA?
- Ryan Bennick: yes
- G-Chat: ok's
- G-Chat: I'm gonna wirte this down
- Ryan Bennick: your bill: 5 monkeys, a 3 Russian escorts, and 12 vanilla ice cream cakes
- G-Chat: hahaha. fair enough.
(11:00:54 AM) Brian Weiner: http://www.ohdeedoh.com/ohdeedoh/outdoors/make-your-own-2x4-xylophone-instructables-112568
(11:01:20 AM) Brian Weiner: it’s kinda silly
(11:01:24 AM) Brian Weiner: but we could have a junkyard band
(11:01:26 AM) Brian Weiner: like fat albert
(11:01:28 AM) G-Chat: HAHAHA
I don’t like country music, but I don’t mean to denigrate those who do. And for those who like country music, denigrate means ‘put down’
BOB NEWHART
Excuse my nerdiness for a hot second here, but this was an awesome little SQL Query i wrote for work today.
<nerd>
Using it as a source of data for a parameter, i was able to produce different result sets based on what level of detail the user wanted to run the report on. So, with parameter @option being valued at either “C” or “R” this query generates the available dataset for another parameter:
SELECT Case WHEN @Option = ‘C’ THEN C.CRM WHEN @Option = ‘R’ THEN R.Description END as CRM
FROM (SELECT DISTINCT (First_Name + ’ ’ + Last_Name) as CRM FROM Member INNER JOIN Company_team on Company_team.Member_recId = Member.Member_Recid WHERE Company_Team.AcctMgr_Flag=1) as C CROSS JOIN (SELECT Owner_Level.Description FROM Owner_Level) as R
</ nerd>
Estimated amount that Ike Turner spent on cocaine during his lifetime, according to Turner: $11,000,000
- Brian Weiner: i was thinking the upstairs living room
- Brian Weiner: could be a library or some such
- Brian Weiner: like we can actually have some nice furniture
- Brian Weiner: cause mclovin will stay downstairs
- Brian Weiner: and we can smoke cigars up there
- Brian Weiner: and drink fine scotch
- G-Chat: yes
- G-Chat: iiinteresting
- G-Chat: i wouldnt have thought
- Brian Weiner: yah
- Brian Weiner: hunts people, that is
- G-Chat: of course
- Brian Weiner: that'd be a great hobby
- G-Chat: i bet you somewhere out in like Africa they have that shit
- Brian Weiner: well you can probably just kill people over there
- G-Chat: exactly
- G-Chat: but i wouldnt be surpised if there was some organized sport killing
- G-Chat: there's pretty much a complete lack of morality out there
- Brian Weiner: it's immoral to hunt people?
- G-Chat: to kill them. i think so
- Brian Weiner: agree to disagree
- G-Chat: only if you agree to repeat that after everything i say
- Brian Weiner: agree to disagree
- G-Chat: well now we've caught ourselves in a infinite loop of sorts...
- Brian Weiner: agree to disagree