Käyttäjän TheReportDoctor profiilikuva
@TheReportDoctor
Jäsen February, 2008 lähtien
0 suositusta

www.TheReportDoctor.com

Online-tilassa Offline-tilassa
Objective: Develop, enhance, and support high quality data systems with optimized code and tools. Skill Summary >> * Years: 25% of my responsibility for 3 years. * Level of Expertise (10 best): Data Integration = 9, APEX = 8 , VisualForce = 6 * Accomplishments: Developed and supported a sales integration project management system for opportunities using GANTT project methodologies. Developed the data integration between and Microsoft SQL Server. * Not Included: Security, Administration, and Chatter. >> Microsoft SQL Server * Years: 12 years * Level of Expertise (10 best): Stored Procedures = 9, ETL = 9, Query Optimization: = 9, and Data Modeling = 10 * Accomplishments: Processed 10's of millions of records in loads and logical processing, high on data quality, and built a ton of scripts for reporting. * Not Included: Security, administration, server configuration, or memory optimization. >> SSIS * Years: 4 years. * Level of Expertise (10 best): Package Development = 8, Package Deployment = 6 * Accomplishments: Create C# Script Task for non-conforming source files, and importing an EBCDIC source. * Not Included: Server memory management, or create data cubes. >> SSRS * Years: 5 years * Level of Expertise (10 best): Custom reports = 10, Cube reports = 8, Drill Down = 8, and Drill Through = 6 * Accomplishments: Created individual reports that used original source data from various applications. * Not Included: Customizing report behavior with C#.NET. >> Microsoft Access * Years: 18 years * Level of Expertise (10 best): VBA = 10+, Classes = 8, Tables = 10+, Queries = 10+, Reports = 10+, Macros = 10 +, ADP = 6 * Accomplishments: Settling 1 Billion dollars in Credit Card transaction daily, processing audit checks on 40 million mortgages a night, building budget and forecast models for a manufactures 1,000 products' Bill of Materials based on the impact of commodity trends, and created a commercial CRM sold to Bible Colleges across the United States. * Not Included: Using Microsoft Access on SharePoint. Ecolab (Data Audit and Correction), November 2012 - February 2013 * Integration: Created SSIS packages to integrate data from AS/400 EBCDIC, JDE, and SAP into MS-SQL Server. * Data: Debugged many SQL Stored Procedures used to report the details of cost and budgets for manufactured products by breaking down their bill of materials and analyzing the future impact of market commodities on those cost and budgets. * MS-Access: Developed the front-end to the budget system that calculated the commodity impact to the Bill of Materials for the annual budget. Hamline University (Data Analyst), August 2012 - current * Integration: Designed and developed Talend/Java scripts to clean and convert various vendor supplied data for importing into the school's CRM system. * MS-Access: Created a reporting tool that cross-tabbed the enrollment funnel with information from a cloud database. Onvoy Voice Services (Data Process Programmer), June 30, 2008 - July 2012 * Integration: Developed SSIS/ETL application including writing Script Tasks in C#. Evaluated solutions for interfacing SQL Server with , discovered, installed, and developed with DBAmp and tuned applications to minimize transactions between the server and cloud. * : Created a sales integration project management system for opportunities using APEX triggers and classes, and VisualForce. * Reports: Wrote many SSRS reports using creativity and complex languages like MDX. * Data: Developed solutions for processing and reporting on a million call records a day. Heavy work on data quality evaluation and process speed improvements. Work included the traditional SQL server and cloud database work with Salesforce.com. * Accomplishments: Took a 3 hour batch job down to under 10 minutes. Developed the model for linking legs of a call into one summary record. Customized with a project workflow solution for assigning and tracking project steps and teams. * MS-Access: Supported applications that tracked the telephone assets and 911 mapping for phones. RBC Dain Rauscher (SQL Engineer), October 15, 2007 - June 27, 2008 * Data: Developed a T-SQL Stored Procedure that ran in under 10 minutes that tracked House Holding History for 10 million customers. * Accomplishments: Created prefect logic in a Stored Procedure that ran in record time and opened opportunities for the data warehouse to track where the "money" came from in a historical dimension. E Group (Data Analyst), June 12, 2007 - October 12, 2007 * Reports: Write dynamic drill-down marketing reports in ASP and JavaScript. * Data: Developed online reporting solution with a drill-down dimension on incentive points and transactions for multiple customers across multiple contract agreements. * Accomplishments: Developed a sales booth data collection system that became the corporate-wide solution for 3M. Research and established the standards for the custom in-house email solution used by one of their larger popular customers for delivering over 3 million marketing messages a year. * MS-Access: Created a dynamic booth data collection tool for gathering new customer leads. This product was re-sold and became the standard for 3M and American Red Cross. CHS, Inc (Formally Cenex) (SQL/VB Developer), August 8, 2006 - May 15, 2007 * Crystal Reports: Updated existing Crystal Reports. * Data: In-house CRM online solution, electronic data collection system, and the sales results cube. * Accomplishments: Developed a dynamic MDX interface for tracking sales trend via an online interface. * MS-Access: Updated, converted, and enhanced all MS-Access applications in the company for stability. Adolfson & Peterson Construction (Data Analyst), July 19, 2006 - August 7, 2006 * Reports: Worked with SSRS to write SQL for reports across multiple vendor applications. * Data: Vendor based Project Management system and a vendor based accounting system. Developed the model and standards for reporting data across the two systems in a single report interface. * Accomplishments: Allowed the client to report instant data on a project's progress, cost, and outstanding estimates so they could manage their profit opportunities better. Wells Fargo Bank (Software Quality Assurance), June 20, 2005 - July 14, 2006 * Data: All banking records including ATM, Teller, Safety Deposit Boxes, Vault, Internet Interface, and Phone CTI system. * Accomplishments: Oversaw testing of new releases and pushed the system to handle and complete 7,000 transactions a minute. MindWare (Data Cleansing and Conversion), February 21, 2005 - June 17, 2005 * Data: Converted 1 million customer records from a flat non-relational database to a vendor relational system. * Accomplishments: Evaluated the vendor data structure and found erroneous assumptions. Worked with the vendor to update their structure. Converted the records including single name fields to First and Last names. The Lacek Group (Data Analyst), August 24, 2004 - March 4, 2005 * Data: Reported on the marketing trends of 5 million car rental a month. * Accomplishments: Wrote a VBScript batch job that downloaded the monthly feed, evaluated the data quality, reported errors or proceeded to load the records into the database. Wrote MS-SQL queries to statically evaluate marketing trends and A/B testing. * MS-Access: Created an ETL Job control dashboard for managing data movement, quality, and imports. Wells Fargo Home Mortgage (Software Quality Assurance), May 3, 2004 - June 11, 2004 * Data: In-house CRM system * Accomplishments: Did QA testing for a complicated CRM system that tracked potential business clients and their officers. The system also tracked the officers' career history. GMAC/RFC (Financial Data Analyst), October 17, 2003 - April 2, 2004 * MS-Access: Created a database to analyze Real Estate flip sales and margins. * Data: Created the report for analyzing Real Estate Marketing Data * Accomplishments: Wrote an open custom interface where the client could bring in various data sources from local and web locations into one database for financial analysis of industry trends and opportunities. Wells Fargo Home Mortgage (Data Auditor), September 23, 2002 - September 12, 2003 * MS-Access: Created a database as a front-end to Sybase for automatically auditing 40 Million mortgages a night. * Data: Reported on operational risks found in 40 Million Mortgage Records. * Accomplishments: Wrote a batch routine to process and evaluate 40 Million mortgage records from their Data Warehouse nightly in less than 1 hour. Wrote an interface that was used with Business Objects to report operational processes and KPI goal statuses. Ramsey County (Process Analyst), October 1, 2001 - March 31, 2002 * Data: The property records of Ramsey County. * Accomplishments: Write a web application that allowed customers to customize the data they wanted from the property records and then download 10 million records in less than 10 minutes. JJ Hill Library (Developer), August of 2001 * Data: Online business sources. * Accomplishments: Wrote an interface for a many-to-many structure to save the administrator from having to make duplicate entries across systems. Nextel Partners (SQL Developer), August 8, 2001 - December 31, 2001 * MS-Access: Enhanced and supported the sales commission database for Nextel salesmen and third-party salesmen. * Data: Reported on sales commission, orders, and workflow. * Accomplishments: Wrote processes for improving usability of the data systems and customized creative solutions. US Bank (Systems Analyst/Team Lead), May 15, 2000 - October 30, 2000 * MS-Access: Developed and supported applications to collect Credit Card transactions and settle them by posting transactions in Hogan (the ERP system) for USBank to the tune of $1 billion dollars a day. * Data: Settled 1 billion dollars in daily credit card transactions * Accomplishments: De-complied 38 applications, documented and enhanced them, enabled them to fine missing "pennies", and cut their daily losses from sloppy errors from $300,000 to under $30,000.
dollaria75 dollaria / tunti
0 arvostelua
0.0
  • N/ASuoritetut työtehtävät
  • N/ABudjetin mukaisesti
  • N/AAjallaan
  • N/AUudelleenpalkkaamisaste

Portfolio

Viimeaikaiset arvostelut

Ei arvosteluja.

Kokemus

Database Consultant

Nov 2012 - Feb 2013 (3 months)

o Integration: Created SSIS packages to integrate data from AS/400 EBCDIC, JDE, and SAP into MS-SQL Server. o Data: Debugged many SQL Stored Procedures used to report the details of cost and budgets for manufactured products by breaking down their bill of materials and analyzing the future impact of market commodities on those cost and budgets. o MS-Access: Developed the front-end to the budget system that calculated the commodity impact to the Bill of Materials for the annual budget.

Database Consultant

Aug 2012 - Feb 2013 (6 months)

o Integration: Created SSIS packages to integrate data from AS/400 EBCDIC, JDE, and SAP into MS-SQL Server. o Data: Debugged many SQL Stored Procedures used to report the details of cost and budgets for manufactured products by breaking down their bill of materials and analyzing the future impact of market commodities on those cost and budgets. o MS-Access: Developed the front-end to the budget system that calculated the commodity impact to the Bill of Materials for the annual budget.

Database Consultant

Jun 2008 - Jul 2012 (4 years)

o Integration: Developed SSIS/ETL application including writing Script Tasks in C#. Evaluated solutions for interfacing SQL Server with , discovered, installed, and developed with DBAmp and tuned applications to minimize transactions between the server and cloud. o : Created a sales integration project management system for opportunities using APEX triggers and classes, and VisualForce. o Reports: Wrote many SSRS reports using creativity and complex languages like MDX. o Data

Database Consultant

Jun 2007 - Oct 2007 (4 months)

o Reports: Write dynamic drill-down marketing reports in ASP and JavaScript. o Data: Developed online reporting solution with a drill-down dimension on incentive points and transactions for multiple customers across multiple contract agreements. o Accomplishments: Developed a sales booth data collection system that became the corporate-wide solution for 3M. Research and established the standards for the custom in-house email solution used by one of their larger popular customers for delivering over 3

Database Consultant

Aug 2006 - May 2007 (9 months)

o Crystal Reports: Updated existing Crystal Reports. o Data: In-house CRM online solution, electronic data collection system, and the sales results cube. o Accomplishments: Developed a dynamic MDX interface for tracking sales trend via an online interface. o MS-Access: Updated, converted, and enhanced all MS-Access applications in the company for stability.

Database Consultant

Jul 2006 - Aug 2006 (1 month)

o Reports: Worked with SSRS to write SQL for reports across multiple vendor applications. o Data: Vendor based Project Management system and a vendor based accounting system. Developed the model and standards for reporting data across the two systems in a single report interface. o Accomplishments: Allowed the client to report instant data on a project's progress, cost, and outstanding estimates so they could manage their profit opportunities better.

Database Consultant

Jun 2005 - Jul 2006 (1 year)

o Data: All banking records including ATM, Teller, Safety Deposit Boxes, Vault, Internet Interface, and Phone CTI system. o Accomplishments: Oversaw testing of new releases and pushed the system to handle and complete 7,000 transactions a minute.

Database Consultant

Feb 2005 - Jun 2005 (4 months)

o Data: Converted 1 million customer records from a flat non-relational database to a vendor relational system. o Accomplishments: Evaluated the vendor data structure and found erroneous assumptions. Worked with the vendor to update their structure. Converted the records including single name fields to First and Last names.

Database Consultant

Aug 2004 - Mar 2005 (7 months)

o Data: Reported on the marketing trends of 5 million car rental a month. o Accomplishments: Wrote a VBScript batch job that downloaded the monthly feed, evaluated the data quality, reported errors or proceeded to load the records into the database. Wrote MS-SQL queries to statically evaluate marketing trends and A/B testing. o MS-Access: Created an ETL Job control dashboard for managing data movement, quality, and imports.

Database Consultant

May 2004 - Jun 2004 (1 month)

o Data: In-house CRM system o Accomplishments: Did QA testing for a complicated CRM system that tracked potential business clients and their officers. The system also tracked the officers' career history.

Database Consultant

Oct 2003 - Apr 2004 (6 months)

o MS-Access: Created a database to analyze Real Estate flip sales and margins. o Data: Created the report for analyzing Real Estate Marketing Data o Accomplishments: Wrote an open custom interface where the client could bring in various data sources from local and web locations into one database for financial analysis of industry trends and opportunities.

Database Consultant

Sep 2002 - Sep 2003 (1 year)

o MS-Access: Created a database as a front-end to Sybase for automatically auditing 40 Million mortgages a night. o Data: Reported on operational risks found in 40 Million Mortgage Records. o Accomplishments: Wrote a batch routine to process and evaluate 40 Million mortgage records from their Data Warehouse nightly in less than 1 hour. Wrote an interface that was used with Business Objects to report operational processes and KPI goal statuses.

Database Consultant

Oct 2001 - Mar 2002 (5 months)

o Data: The property records of Ramsey County. o Accomplishments: Write a web application that allowed customers to customize the data they wanted from the property records and then download 10 million records in less than 10 minutes.

Database Consultant

Aug 2001 - Dec 2001 (4 months)

o MS-Access: Enhanced and supported the sales commission database for Nextel salesmen and third-party salesmen. o Data: Reported on sales commission, orders, and workflow. o Accomplishments: Wrote processes for improving usability of the data systems and customized creative solutions.

Database Consultant

Aug 2001 - Aug 2001 (1 month)

o Data: Online business sources. o Accomplishments: Wrote an interface for a many-to-many structure to save the administrator from having to make duplicate entries across systems.

Database Consultnat

May 1999 - Oct 2000 (1 year)

o MS-Access: Developed and supported applications to collect Credit Card transactions and settle them by posting transactions in Hogan (the ERP system) for USBank to the tune of $1 billion dollars a day. o Data: Settled 1 billion dollars in daily credit card transactions o Accomplishments: De-complied 38 applications, documented and enhanced them, enabled them to fine missing "pennies", and cut their daily losses from sloppy errors from $300,000 to under $30,000.

Varmennukset

  • Facebook yhdistetty
  • Suositeltu freelancer
  • Maksu varmennettu
  • Puhelinnumero varmennettu
  • Henkilöllisyys varmennettu
  • Sähköposti varmennettu

Selaa samanlaisia freelancereita