Technical Lead Resume
Maryland Heights, MO
SUMMARY:
- Data Analyst Reporting Analyst Software Developer Not a DBA
- Analytical and problem - solving skills
- Creative thinker with a vision
- Technical background with knowledge of software development
- Data Analysis of SQL Server data, PL/ SQL, DB2, MS Access Data and Excel spreadsheets/ CSV files as data sources.
- Tools used for Analysis include SSMS (T-SQL), MS Access queries, and Excel Functions to produce Dashboards in Excel. Also familiar with Alteryx, and TOAD.
- Solutions oriented, focused Information.
- Programmer analyst with expertise in MS Access and Relational Database programming and analysis.
- Strong Customer support and communication.
- Adept in relational database management systems, application design and development, technical support documentation, reporting and data analysis.
- Skilled client server application programmer and business systems/reporting analyst who specializes in requirements gathering, data modeling and Relational Database Management System design and development.
- Consistently supports end users in developing solutions and improving production and process flow.
- Disciplined in data integrity, process efficiency and solution development.
- Well versed in application design and development and design and development of Relational DB's including data modeling, stored procedures and constraints.
CORE COMPETENCIES:
Applications: SSRS, SSIS, MS Office Suite, Visio, TOAD, Erwin
Reporting: MS Access (all versions), Cognos Reports-Impromptu v 7.4, Excel Spreadsheet Automation & Excel Pivot Tables, Crystal Reports Ver.7.0
Languages: VB.Net, Visual Basic 6.0, VBA-MS Access, VBA-Excel(VLookUP, Index-Match, SumIFs, Offset, SubTotal, etc.), T-SQL, DTS/ ETL, ODBC, OLEDB, ADO, MS Access SQL, T-SQL SQL Server
Databases: MS Access (All versions), SQL Server 2012, SQL Server 2014
Operating Systems: Windows 7, Windows 8, Windows 10
PROFESSIONAL HISTORY:
Confidential, Maryland Heights, MO
Technical Lead
Responsibilities:
- Gathered and managed requirements.
- Provide Data Analysis of Oracle data comprised of, “Multi Dwelling Units” type information, which is exported to Excel files for further data analysis and manipulation.
- Implemented PL/SQL queries and ICOMS - IBM-DB2 SQL development for ad-hoc reporting.
- Provide up-to-date information for Multi Dwelling Unit properties at various locations throughout the USA for the Marketing and Sales Departments.
- Designed and developed, Excel Spreadsheet reports.
- Designed and developed S Access-VBA applications to enable highest level of quality control.
- MS Access development included various types of queries, and multiple search engines to provide analysis for outlier searches, and editing of data providing corrections or changes to support data requirements.
Confidential
Database Analyst-T-SQL
Responsibilities:
- Using SQL Server 2014, provide data analysis and development for the Department of Anesthesiology.
- Tasks include development of complex T-SQL queries/ Stored Procedures to capture medical information that is submitted for Medical Research.
- Perform Data Analysis using T-SQL SQL Server 2014. .
Confidential, ST Louis, MO
Database Developer-T-SQL Developer
Responsibilities:
- Using SQL Server 2014, maintain existing Stored Procedures, Queries.
- Provide required changes/ modifications to Transact SQL queries, implement new queries.
- Update/ maintain Reports via SSRS; update or modify report Data Sources (Server/ Database, Tables).
- Build new Data Structures, update Data Map documentation and Technical Support documentation.
Confidential, O’ Fallon, MO
Data Analyst-RDMS Programmer/ Analyst
Responsibilities:
- Perform Data Analysis using T-SQL for SQL Server 2012, and analysis using MS Access SQL.
- Performed Data Analysis, query design and development using Alteryx.
- Conducted and facilitated meetings with Management and End Users.
- Gathered and managed Requirements for Application Development and development of Excel Dashboards.
- Designed and Developed MS Access Database applications in version 2013.
- Perform Logical and Physical Data Modeling, designed and developed SQL Server - Relational Database structures to capture information related to Air Emergency Medical Services Flight Operations data to perform data analysis, and to provide reports and Excel Dashboard type reporting.
- Maintain multiple existing MS Access applications. Design and develop new MS Access applications and Relational Database models.
- Support SharePoint user access. Configure and support Data Entry MS Access application-SQL Server Database I designed and developed to capture and track monthly meetings conducted by Confidential Helicopter bases.
- T-SQL Development of SQL Queries, Stored Procedure Development and modifications.
- Provided Customer support daily. Providing training, and trouble-shooting to end users.
- Designed and developed several types of reports to include Excel spreadsheets, MS Access reports, and Power Point presentations.
- Created several types of SQL Server queries, views and stored procedures to capture and manage both Structured and Unstructured data. .
- Design and develop several Excel dashboards including VBA macros/ source code to automate daily updates of Dash-boards with linked tables or Excel spreadsheets.
Confidential, Saint Louis, MO
Relational Database Programmer/Contractor
Responsibilities:
- Gather and manage requirements.
- Perform Data Analysis using MS Access SQL.
- Perform data modeling, design and development of a primary relational database framework to capture information related to large, commercial electrical construction projects nationwide.
- Create MS Access ver. 2013 application-front end to include various types of data entry screens, which include linked databases.
- Design and developed import procedures via Excel spreadsheet data, CSV and SQL queries.
- Implement security measures to validate data entry.
- Implement automatic calculations based on data entry or derived data.
- Designed and developed several types of reports to include graphical representation of projections compared to actual data.
- Perform data analysis, data mapping, SSIS, Data Transformation Services type processing.
- Provide mentoring/ support to end users throughout the System Development Life Cycle.
Environment: Windows 7, Office 365, Microsoft Access 2013, SQL Server, SSIS, DTS
Confidential, St. Louis, MO
Contractor
Responsibilities:
- Provided enhancements to existing Microsoft Access relational database management systems.
- Perform Data Analysis using using MS Access SQL.
- Modified or replaced existing screen designs to implement enhancements and to improve on performance.
- Performed Query analysis and implemented new queries or modified existing queries to improve on performance and provided additional data.
- Developed and implemented search engine options to retrieve new types of data.
- Implemented new reports using Microsoft Access.
- Implemented migration of existing Microsoft Access database applications including both front end and back end databases from earlier versions of Access to Microsoft Office 10.
Environment: Windows XP Pro, Windows 7, Office 2007, Office 2010, MS Access 2007, MS Access 2010
Confidential, Beaverton, OR
Sr. Data Analyst/Consultant
Responsibilities:
- Implemented advanced Excel analysis and data mapping.
- Perform Data Analysis using T-SQL for SQL Server 2000, and analysis using MS Access SQL.
- Identified current data sources for metrics measurement.
- Created new Country metrics.
- Documented process for each of the metrics identified.
- Created Excel program to track Country metrics showing overall score for each Country.
- Data Model of new MS Access Relational Database Application.
- ETL of data inserted into Excel Indexes, and implemented updates/modifications.
Environment: Excel 2007, MS Access 2007
Confidential, Portland, OR
Sr. Programmer Analyst/Consultant
Responsibilities:
- Created new reports, functionality.
- Perform Data Analysis using MS Access SQL
- Provided updates/ enhancements to MS Access applications enabling new search and retrieval processing.
- Provided ETL importing and exporting Excel data.
Environment: Access 2007
Confidential, Hillsboro, OR
Analyst/Consultant/Contractor
Responsibilities:
- Perform Data Analysis using MS Access SQL.
- Conducted business model- analysis, performed maintenance/ updates of existing MS Access application improving original design.
- ETL, MS Access SQL Queries, VBA Procedures/ Functions.
Environment: Access 2007, SSIS, SQL
Confidential, Portland, OR
Business Analyst/Report Developer/Consultant
Responsibilities:
- Performed requirements gathering.
- Perform Data Analysis using VBA-Excel, SQL Server data analysis using Cognos reporting.
- Created transmission finance reports to show Megawatt Hours and related costs using Excel.
- Created Cognos Reports using Impromptu.
- Utilized Toad to analyze Transmission Schedules via PL-SQL queries.
- Reporting & Data Analysis: Cognos-Impromptu, MS Excel l Pivot table reports, detail drill down reports and summary reports.
- Application modifications/ enhancements: Visual Studio, VB.NET and Visual Basic 6
- Provided Reports published to PacifiCorp's Intranet Site
- Extracted data from Oracle Databases.
- Data analysis to determine transmission variations in hourly electricity production and path of energy delivery.
- Created and implemented comprehensive Invoices containing summary reports and data available from several sources to show transmission information for all pertinent customer accounts and cost sheet data.
Environment: Cognos Reports Impromptu, Excel Pivot tables, VBA, HTML, Visual Studio, VB.NET, Visual Basic 6, Access 2003, Oracle, SQL
Confidential, Portland, OR
Senior BSA/Report Analyst/Consultant/Contractor
Responsibilities:
- Gathered requirements and supported business rules in support of EPMO Project Management reporting and Governance department.
- Perform Data Analysis using MS Access SQL, Queries accessing Oracle data, and using VBA-Excel data.
- Generated Microsoft Project Data and Clarity Data results comprising estimated project hours compared to actual hours. Performed queries in the Oracle 9i database to obtain Clarity Time Reporting of Actuals data.
- Created Excel 2003 templates and updated and formatted data output from Access 2003.
- Implemented reporting from Access 2003 modules executing several functions/sub routines to create output to Excel 2003 template files.
- Designed and developed a new database application that interfaced with Lotus Notes via a special tool called Visual Workbench which was used to export Lotus Notes data imported into the Access application. The Access 2003 interfaces were comprised of Data Entry screens and extensive complex reporting.
Environment: Visual Basic 6, Excel 2003, VBA, MS Project, Clarity, Visual Workbench, Lotus Notes, SQL, Access 2003, Oracle 9i, Win XP Pro 2003
Confidential, Portland, OR
Business Systems Analyst/Report Developer/Consultant
Responsibilities:
- Gathered and managed requirements and created and generated reports based on System Development Life Cycle process.
- Designed, developed and implemented new Accounting system to track Sales and Purchases of Recycled Metals. System provided both the New York office and Portland office the ability to capture and store the sales and purchase data in a relational database model. Reporting provided users the ability to have the same data seen in a report output to an Excel 2003 spreadsheet with automated formatting.
Environment: Windows XP Pro 2003; Access, Excel 2003, Word 2003, Visio 2003
Confidential, Beaverton, OR
Sr. Programmer Analyst/Business Systems Analyst Report Developer/Contractor
Responsibilities:
- Gathered and managed requirements, created and generated reports and conducted System Development Life Cycle process.
- Designed, developed and implemented new Sales Order system for Exeter Brand, a Confidential subsidiary (Visual Basic 6, VBA, SQL Server 2000). The Sales Order System automated the process of constructing sales orders from Wal-Mart purchase orders provided to Exeter in Microsoft Word, RTF file format. Proposed system parsed and extracted pertinent data contained in Wal-Mart purchase order document (Word RTF file) required to complete construction of an Exeter sales order.
- Perform Data Analysis using MS Access SQL, T-SQL queries using SQL Server 2000.
- Supported data extraction that used stored procedures and ADO technology invoked from an Access 2003 frontend interface. The Sales Order System was a fully automated Sales Order constructor-application comprising a parsing engine built using Visual Basic 6, VBA, ADO and ODBC with a SQL Server 2000 backend-database.
- Executed process to automate uploading of all available purchase order documents using a file sniffer routine to locate available purchase order files. Executed parsing procedures to extract proprietary data from the purchase order and persisted the data to a SQL Server 2000 database. The stored data was maintained in a normalized relational database model.
Environment: Visual Basic 6, Converse supported server, DTS, SQL Server 2000, Access 2003, ODBC, ADO, VBA, Excel 2003
Senior Analyst/Sr. Programmer Analyst/Business Systems Analyst Report Developer
Confidential
Responsibilities:
- Gathered and managed requirements, created and generated reports and conducted System Development Life Cycle process.
- Designed, developed and implemented new Sales Order system for Exeter Brand, a Confidential subsidiary (Visual Basic 6, VBA, SQL Server 2000).
- Supported data extraction using stored procedures and ADO technology invoked from an Access 2003 frontend interface.
- The Sales Order System was a fully automated Sales Order constructor-application comprising a parsing engine built using Visual Basic 6, VBA, ADO, and ODBC with a SQL Server 2000 backend-database.
- Executed process to automate the uploading of all available purchase order documents using a file sniffer routine to locate available purchase order files. Executed parsing procedures to extract proprietary data from the purchase order and persisted the data to a SQL Server 2000 database.
Environment: Visual Basic 6, Converse supported server, DTS, SQL Server 2000, Access 2003, ODBC, ADO, VBA, Excel 2003
Senior Analyst
Confidential
Responsibilities:
- Designed, developed and implemented a relational database management system to track sales, and purchases of Logo Golf Balls. The Vendor Work Order interface captured product orders and output in XML format viewable in an IE Web browser.
Environment: /Database application: Windows XP; XML, Microsoft Access 2003
Confidential, Portland, OR
Senior Developer/Consultant
Responsibilities:
- Gathered and managed requirements in prioritizing and modularizing all components of proposed system
- Designed, coded and implemented all functions, interfaces and test/ deployment of builds throughout life of project.
- Performed data modeling to construct physical and logical models. Used SQL to provide applicable data manipulation and data extraction/migration.
- Constructed turn-key interface to perform: manipulation of raw data, error logging and error reporting and executed statistical calculations to create summary data. Conducted QA testing of each new build, conducted user testing and deployed final build into production.
Environment: Windows XP Professional, Microsoft Access 2002