Web Admin Resume Profile
OBJECTIVE
Object and detail-oriented Support and Systems Administrator with expertise in software lifecycle development. Troubleshoot and problem solve independently or collaboratively to clients satisfaction. Self-motivated to remain up-to-date on new technology consistently increasing and maintaining broad technical knowledge.
Technical Skills
Platforms | Windows XP / 98 / 2000 / Server 03 08 Linux AIX Solaris SCO HPUX SunOS |
Languages | C .NET VB.NET ASP.NET VB6 C C ESQL/C Java J2EE SQL T-SQL PL/SQL MDX SSIS DTS ETL HTML JavaScript shell-scripting Perl CSH KSH BASH |
RDBMS OLAP | Oracle 8-10g SQL-Server 7-2008 IBM DB2 Informix SE / Online Analysis Services 2000 2008 SAP BPC / Outlooksoft 4-7 |
Enterprise Reporting | SAP BPC Outlooksoft 4-7 Business Objects 5-12 Crystal Reports MSSQL Reporting Services SSRS |
Framework | .NET |
Application / Portal Servers | Tomcat WordPress |
Methodologies / Technologies | Iterative Agile Apache IIS |
Development / Version Control | Visual Studio SQL Mgmt Studio Visual Source Safe git CVS subversion |
Project Management Tacking Tools | Microsoft Project Eclipse HP PPM Remedy |
Professional Experience
Confidential
Volunteer Web Admin
Designed website using WordPress and setup hosting for non-profit startup dedicated to water rights health and sanitation in Africa. Volunteer for their annual Walk for Water fundraiser initiative.
Confidential
IT Analyst
- Provided necessary support to various assigned projects including on-call services debugging nightly processing batches and design / build / deploy tasks.
- Financial Planning and Accounting Data Warehouse. Supported Oracle warehouse building ETL interfaces and processing business logic thereby supporting reporting for financial analysts.
- SAP Business Planning and Consolidation 7.x. Provided enterprise application support for 5 production instances of this business analytics and reporting tool supporting 1000 users. Designed built tested and deployed packages automating user tasks ETL and business processes.
- Administered server troubleshooting issues with SQLServer 2008 and Analysis Services.
- Resolved desktop client installation problems with XP/Win7 and Office plugins using Windows support experience and utilized vendor support for application issue resolution.
- Coordinated system and performance testing for virtual instances for product upgrades and server consolidations.
Software Engineer
COG Enterprise Reporting Tool. Supported in-house enterprise-reporting tool built on C using DevExpress Infragistics 3rd-party tools creating built custom reports using XML-based report definition and SQL/Oracle stored procedures and Excel import/export functionality. Designed / maintained custom WinForms interfaces and reporting screens for entering reporting and approving trades budgets and forecasts.
Development.
- Built custom .NET tool for user-initiated or scheduled nightly restart of COM services to work-around memory leaks in BPC enterprise app significantly reducing server stability issues.
- Built Forecasting process in BPC for Business Analysts for forecasting power-consumption and customer turnover for mid-large energy customers.
- Upgraded multiple BPC instances from Outlooksoft 4 5 to 7.x through BPC server installation DTS package conversion to SSIS packages and system testing.
Windows 7 Migration.
- Coordinated and tested Citrix and VMware fallback environments for legacy applications. Piloted and rolled out client updates to over 200 enterprise users.
- Setup test environment and full system testing for upgrade writing system test-plans and production migration procedures.
- Performed full system testing and coordinated user testing working with network and server admin teams regarding security policies.
Confidential IT Analyst
Data Warehouse Architect
- Sales and Labor Data Warehouse. Designed database for PeopleSoft Financials and HR data extract from Oracle 9i into SQL Server 2000 warehouse.
- Reduced data optimization in warehouse and reporting from hours to seconds and increased work productivity by building data warehouse. Aggregated cash and sales and labor information from field locations PeopleSoft journal invoices vouchers and HR store manager information. Catered to voucher journal line invoice sales and labor store manager performance and bonus reporting.
- Build ETL jobs using DTS and T-SQL stored procedures importing Sales and HR data from PeopleSoft Financials and HR and retrieving extract files from UNIX systems into warehouse.
- Designed OLAP data cubes with Analysis Services and calculated members with MDX.
- Developed Perl and KSH ETL scheduled scripts for creating extract files for sales and labor data from Micros POS and Cash Sales database systems for retrieval by warehouse ETL jobs.
- Coordinated DBA activities including scheduling maintenance of data warehouse checking data integrity performance monitoring backups index tuning and query tuning.
- Utilized Business Object enterprise reporting tool for delivering reports.