SUMMARY:

I am a senior level IT professional specializing in database development, analysis, and design , looking for a company where I may jump right in utilizing my existing skillset while facing new challenges to grow myself as well as the company.

COMPUTER SKILLS:

• Microsoft Office: Access, Excel, Word, PowerPoint, Visual Basic for Applications VBA , macros, charts, advanced equations/formatting, graphics, reports, forms, queries, utilize VBA to retrieve data from SQL Server, Access, and Oracle to be utilized in Excel spreadsheets.
• Microsoft Windows 9x, XP, NT, Server NT/2000/2003 , 2000, Vista, 7 : Installation, maintenance, backups, troubleshooting, administration, networking, upgrades, desktop support, DHCP, Active Directory AD
• Miscellaneous: Oracle, SQL Server 2000/2005/2008 R2, HTML, XSL/XSLT, XML, CSS, Javascript, ADO, ASP, ASP.NET, MVC, SQL, t-SQL, SSIS, SSRS, DTS, ETL, ODBC, Adobe Acrobat, VB.NET, DB2, MySQL

WORK EXPERIENCE:

Confidential

ETL Developer Contractor

• Check production and QA DataStage batches and jobs, as well as daily emails, to produce a daily summary report.
• Troubleshoot/fix issues DataStage QA failed batches and jobs.
• Created stored procedure to populate prior policy IDs for existing database.
• Created stored procedure to populate future policy IDs for existing database using a recursive algorithm to find related policy numbers.
• Manually fix data discrepancies in data warehouse caused by errors generated by the main program used by underwriters and agents Salesforce .
• Convert DataStage jobs to SSIS packages and/or stored procedures in preparation for migrating all DataStage jobs to SQL Server SSIS packages or jobs.

Confidential

Application System Engineer 4 Contractor

• Analyze existing SSIS and SSRS packages to modify reporting application built during previous contract.
• Analyze and modify existing stored procedures, functions, and queries in order to integrate them into previously built reporting application utilizing SSIS and SQL Server Management Studio.
• Change ETL process from importing flat files as source for previously built application utilizing SSIS, Stored Procedures, and Functions to read data from existing Reporting Server SQL Server databases .
• Build on-call administration website utilizing ASP.NET, VB.NET, and ADO in Visual Studio to replace the current manual process which will save, collectively, hundreds of man hours per month.
• Build and enhance applications utilizing Microsoft Excel and VBA.
• Create new reports utilizing SSRS to help managers be more efficient at their jobs.

Confidential

Computer Specialist Contractor

• Test functionality of Microsoft Retail Management System on Windows 7.
• Coordinated, and helped, roll out Windows 7 computers to PERA Club.
• Troubleshoot custom integration package in SQL Server stored procedures .
• Gather requirements for Microsoft Dynamics GP 2010 Service Pack 4 and perform testing.

Confidential

Report Analyst Contractor

• Analyze legacy systems and create report/system specification documentation.
• Create reoccurring and ad hoc reports from mainframe and SQL Server data utilizing MS Access.
• Design, and build, central repository database to track all report requests as well as all project data relating to converting legacy systems to new platform to comply with the Affordable Care Act ACA regulations.

Confidential

Application System Engineer 4 Contractor

• Analyze and document existing MS Access application in preparation for migration to SQL Server.
• Design and build SQL Server database for existing application migration.
• Build ETL process to import flat files as source for new application utilizing SSIS, Stored Procedures, and Functions.
• Design and build new report utilizing SSRS and Stored Procedures.

Confidential

Reporting Analyst Contractor

• Analyze and map existing SQL Server databases and stored procedures to document and clean up processes.
• Interface with report users to determine requirements for new and existing reports.
• Develop reports utilizing SSIS, SSRS and SQL Server.
• Mentor new hire and ensure that she was trained properly.
• Create documentation for the databases, stored procedures, and daily processes.
• Analyze data being loaded into all databases to ensure data is correct.

Confidential

Senior Programmer

• Convert old POS system to QuickBooks includes converting item numbers to use UPC barcodes .
• Design/develop new work order tracking system for computer, game console, and electronics repairs utilizing HTML, JavaScript, ASP, and Microsoft Access.
• Design/develop new website with shopping cart utilizing ZenCart.

Confidential

Web Developer / Programmer / IT Contractor

• Design and program new web site utilizing ASP.NET MVC, HTML, SQL Server, VB.NET, and JavaScript.
• Evaluate and recommend new IP phone solution for nationwide offices.
• Evaluate and recommend new network infrastructure for nationwide offices new ISP, network hardware, servers, etc. .

Confidential

Clinical Application Administrator

• System administrator for web based Velos eResearch clinical trials application.
• Project Manager for building forms and reports for new clinical trials.
• Migrated the pre-existing MS Access database for the Research Institute to eResearch all data, replicated/updated data entry forms, built custom reports utilizing XML, XSL, SQL, MS Access .
• Build custom eResearch forms requested from clinical trials researchers and administrators.
• Created custom reports and forms in eResearch using Oracle SQL, XSL, XML, and Javascript.
• Created training evaluation questionnaire utilizing MS Access, HTML, Javascript, and ASP.
• Help to maintain Oracle database for Velos eResearch using stored procedures, SQL, PL/SQL.

Confidential

Database Analyst II

• Built MS Access application to keep track of Batch file and Audit projects with GUI, access restrictions, reporting features, and maintenance utilities.
• Built application utilized by multiple groups to easily look up records sent to publishers for research.
• Automated manual process to pull batch file phone book information from a SQL Server database to send to telephone book publishers utilizing SSIS, MS Excel, and VBA.
• Perform audits to ensure that batch file contents sent to publishers were included in the publication proofs utilizing SQL Server, Excel and VBA.
• Automated processes to load data to SQL Server database for easy extraction for batch files and audits
• Build utilities SQL Server, SSIS, Excel, VBA, etc. as need to assist in creating presentations for upper level management.
• Proactively worked to change data feeds from cable partners to be sent in a uniform format to be more easily loaded into the SQL Server database that I designed, created, and maintained.

Business Analyst II

• Subject Matter Expert for ACD call data , staffing, payments, and promise-to-pay data.
• Responsible for development of data architecture, logical and physical data modeling stored in a SQL Server database designed for reporting group.
• Organized and automated extract, transform, and load ETL of all daily data feeds from vendor locations utilizing MS Excel, VBA, SQL Server and DTS.
• Created forecasting model to project directionally correct Hotline trending.
• Identify reporting anomalies and perform detailed analysis of raw data and report findings.
• Develop reports to support business critical executive level requests. Automated report creation process utilizing MS Excel, VBA, SQL Server and DTS.
• During a hectic period in the company, I proactively assumed responsibility for daily reporting decisions and provided direction for a junior teammate's projects. This helped to off-load much responsibility from my manager and allow him more time to concentrate on helping to stabilize the company.
• Established leadership role by becoming expert for majority of ETL processes, data sources, and reporting creation and delivery applications. I am the go-to person for troubleshooting, maintenance, changes, and creation of high-visibility processes and reports utilizing SQL Server, Oracle, Excel, and VBA.
• Automated manually intensive processes utilizing SQL Server, SQL, DTS packages, Excel, and VBA eliminating the need to hire new personnel as well as improving timeliness and accuracy of reports.

Reporting Analyst II

• Identify reporting anomalies and perform detailed analysis of raw data to provide explanations.
• Automate report production processes to be more efficient and accurate with less work involved utilizing MS Excel, VBA, MS Access, SQL, and Oracle database.
• Provide detailed explanations and training to report users.
• Develop reports to support business critical executive level requests. Automated report creation utilizing MS Excel, VBA, MS Access, SQL, and Oracle database.
• While the Executive Reporting group was growing, I developed extraordinary working relationships with inter- and intra-departmental personnel to ensure source data is timely and accurate.

Confidential

Telecommunications Specialist

• Administer Lucent Definity Generic 2.2 PBX, ACD, and CMS
• Organize PBX programming information for easy access when maintenance or changes were needed.
• Built Help Desk Trouble Ticket database to track IT staff response time and outstanding issues.
• Utilize call data to perform cost analysis of advanced features of toll-free numbers
• Analyze caller patterns to assist in mapping out and planning more efficient call paths for incoming calls
• Provide and help analyze call completion data to build more accurate profiles for optimized staffing
• Administer Intuity Audix system for Overland Park and Lawrence facilities
• Assist Networking team in installation of software and maintenance of computer/network equipment
• Analyze and remediate Year 2000 compliance issues of telephone, computer, and network equipment
• Changed the perception set by predecessors that IT was difficult to work with.
• Helped to develop proposal to upgrade the phone system with skill based routing. When this was implemented, employee and customer satisfaction improved while turnover was dramatically decreased.
• We were able to accomplish some tasks that our predecessors said were impossible.
• Service Level Technician
• Manage real-time allocation of personnel to provide efficient service to customers
• Perform database searches/additions/maintenance
• Maintain, generate, and distribute reports of call center operational status
• Work with Call Management System CMS terminals
• Took the initiative to reorganize the layout of the two workstations to be more efficient and set up identically in order to make changing workstations seamless.