In My Own Words
My objective is to enter into a position where I can utilize my skills in ... MS SQL (Complex Stored Procedures and creation of Views and Tables), Crystal Reports (v8.5 to XI), Business Objects Enterprise, Axapta, Clarity and Global Knowledge On Demand (Knowledge Accelerator, CAPA)
Work Experience
SQL Programmer / Report Developer (Consultant)
Wagner Consulting, LLC2008 – Present
Provide clients with support in the design and development of high level complex SQL Queries and reports. Currently focusing on working primarily with MS SQL based databases. Utilizing query and reporting tools such as SSMS (2005/2008/2012), Crystal Reports and SSRS. Strong emphasis on report design by creating complex SQL Stored Procedures as the data source for Crystal Reports/SSRS. Work closely with other IT groups and outside users in order to best support their report needs.
Development Tools: T-SQL (Stored Procedures, Views, Tables), Crystal Reports, SSRS, Global Knowledge On Demand and PL/SQL
Systems: SAP Business One, ViewPoint V6 Construction, Facets, Dynamics AX 3.0, PlanView, Clarity and VSS
Industries: Healthcare, Construction, Entertainment, Action Sports, Footwear & Apparel, Manufacturing, Government, Finance and Environmental.
SQL Programmer / Report Developer (Consultant)
Wagner Consulting, LLC2008 – Present
Provide clients with support in the design and development of high level complex SQL Queries and reports. Currently focusing on working primarily with MS SQL based databases. Utilizing query and reporting tools such as SSMS (2005/2008/2012), Crystal Reports and SSRS. Strong emphasis on report design by creating complex SQL Stored Procedures as the data source for Crystal Reports/SSRS. Work closely with other IT groups and outside users in order to best support their report needs.
Development Tools: T-SQL (Stored Procedures, Views, Tables), Crystal Reports, SSRS, Global Knowledge On Demand and PL/SQL
Systems: SAP Business One, ViewPoint V6 Construction, Facets, Dynamics AX 3.0, PlanView, Clarity and VSS
Industries: Healthcare, Construction, Entertainment, Action Sports, Footwear & Apparel, Manufacturing, Government, Finance and Environmental.
Report Developer III
Sole Technology2005 – 2008
Interface with users in the design and development of the enterprise reporting structure utilizing Crystal Reports XI/Business Objects Enterprise XI and SQL Stored Procedures against Dynamics AX3.0. Strong emphasis on complex SQL Stored Procedures, Creation of Tables, Views and DTS packages. Capture requirements, design, create, and complete requests for reports and information. Analyze reporting requests, author report logic, and create report presentation.
Define a test process and normative metrics to validate data consistency and report integrity. Insure reports and on-line analysis address critical information needs and requirements effectively and on a timely basis.
Prioritize multiple report and data research requests based on customer objectives. Identify opportunities to consolidate disparate data stores onto a common platform.
Work closely with application developers to integrate existing and new reports into a reporting portal. Setup/Maintain Business Objects Enterprise Server.
Report Developer III
Sole Technology2005 – 2008
Interface with users in the design and development of the enterprise reporting structure utilizing Crystal Reports XI/Business Objects Enterprise XI and SQL Stored Procedures against Dynamics AX3.0. Strong emphasis on complex SQL Stored Procedures, Creation of Tables, Views and DTS packages. Capture requirements, design, create, and complete requests for reports and information. Analyze reporting requests, author report logic, and create report presentation.
Define a test process and normative metrics to validate data consistency and report integrity. Insure reports and on-line analysis address critical information needs and requirements effectively and on a timely basis.
Prioritize multiple report and data research requests based on customer objectives. Identify opportunities to consolidate disparate data stores onto a common platform.
Work closely with application developers to integrate existing and new reports into a reporting portal. Setup/Maintain Business Objects Enterprise Server.
Report Developer II
Quantum2000 – 2005
Analyze current processes and assist with the implementation of new or revised process solutions and related system requirements. Document and analyze user needs, program functions and solutions to business problems. Report development (Crystal Reports/Business Objects).
Provide continuity and accuracy in reporting by validating and testing data, identifying missing/erroneous data, inconsistencies between data sourced as well as validating accuracy/ consistency with stated business rules.
Prepare and maintain Sales and Marketing report requirements – ad hoc reporting needs utilizing TOAD (PL/SQL) and Query Analyzer (SQL)
Support data collection, mapping and processes. Experience in relational databases (Oracle, Access, Clarify)
Report Developer II
Quantum2000 – 2005
Analyze current processes and assist with the implementation of new or revised process solutions and related system requirements. Document and analyze user needs, program functions and solutions to business problems. Report development (Crystal Reports/Business Objects).
Provide continuity and accuracy in reporting by validating and testing data, identifying missing/erroneous data, inconsistencies between data sourced as well as validating accuracy/ consistency with stated business rules.
Prepare and maintain Sales and Marketing report requirements – ad hoc reporting needs utilizing TOAD (PL/SQL) and Query Analyzer (SQL)
Support data collection, mapping and processes. Experience in relational databases (Oracle, Access, Clarify)
MS Access Developer
IED1998 – 1999
Create and maintain MS Access database and Report Design
MS Access Developer
IED1998 – 1999
Create and maintain MS Access database and Report Design
Customer Service Manager
Office Depot1993 – 1998
General Management of the Customer Service Department managing 15+ employees
Customer Service Manager
Office Depot1993 – 1998
General Management of the Customer Service Department managing 15+ employees
Education
Fullerton College
1990 – 1994
Fullerton College
1990 – 1994
Certificiate
New Horizons2003 – 2004
Certificiate
Certificiate
New Horizons2003 – 2004
Certificiate
Orange Coast College
2001 – 2002
Orange Coast College
2001 – 2002