James Montgomery Email & Phone Number

Ashtabula, Oh, Us

Mentor, Ohio

Erie, Pennsylvania

• Used MS SQL and Oracle SQL to create data extract requests for Business Analyst requirements.• Assisted with data remediation project in preparation for primary business application data conversion.• Created Excel extracts to assist with output analysis.

Cleveland, Ohio

• Developed data cubes, views and stored procedures for high-end applications and business analytics.• Used SSMS, SSRS and other SQL tools to create data extract request, ad-hoc and recurring custom reports.• Developed custom and proprietary processes.• Maintained and modified legacy reports used daily by hundreds of internal users.

Wickliffe, Ohio

• Developed stored procedures to detect and correct data anomalies to ensure data quality.• Created a variety of internal reports and alerts using SQL, Stored Procedures and various Reporting Tools.• Designed procedure to reconstruct missing data points resulting in increased client billing.• Worked with application users to correct client data and reports based on specific reported issues.

Cleveland, Ohio

• Provided technical support for end users utilizing SQL queries and searching log files to analyze and troubleshoot user problems in the Elite billing and financial database.• Created custom SQL scripts to insert and update financial data points.• Maintained user access and all other data setups in the Elite billing and financial database. Modified standard and Whitehill billing reports.• Used MS Report Builder 3.0 to create custom internal reports.

Cleveland/Akron, Ohio Area

• Extracted, translated, cleansed, converted, merged and validated (ETL) large RDBMS databases using SQL2000/2005/2008(DTS, SSIS and T-SQL), Access, and Excel while maintaining data integrity. Comprehensive understanding of SQL Indexes, database schemas and normalized database concepts.• Customized tables, views, and reports (especially financial) in Windows and WEB based real estate accounting software package. Used proprietary report writing tool similar to Crystal Reports.• Used advanced SQL queries to troubleshoot client problems and correct corrupt or incorrect data points.• Provided high level technical support to end users for troubleshooting IT and accounting problems.• Collaborated with clients to determine project scope, gather and document requirements, communicate throughout the project development to manage customer expectations, resolve issues, and provide project status.

Cleveland/Akron, Ohio Area

• Trained clients on-site and remotely in operation of health care accounting software.• Assisted users by resolving issues and providing technical support.• Assisted programmers by testing and debugging new software releases.

Certificate, Business Intelligence And Data Warehousing

Designing Dimensional Models, Designing ETL Processes for Data Warehouses Text Used: Kimball, Ralph, Margy Ross, Warren Thornthwaite, Joy.

Bba, Accounting

Work Towards Bachelor'S In Accounting