We provide IT Staff Augmentation Services!

Financial Data Architect Resume

Alpharetta, GA

SUMMARY:

  • 25 years of experience in Information Technology.
  • 20 years of experience in Data Management.
  • 20 years of experience in Data Analysis.
  • 20 years of experience in BI / Decision Support and Reports Development.
  • 10+ years of experience in Report Decomposition.
  • 20 years of experience with SQL Server.
  • 20 years of experience with SQL Queries.
  • 25 years of experience with MS Excel.
  • 25 years of experience with MS Office.
  • Excellent communication and interpersonal skills.
  • Specializing in immediate response solutions to critical issues with SQL Server databases and reports.
  • Results - oriented SQL Server Developer / BI Analyst. Experienced in all phases of SDLC on small to large scale software development projects in Financial, Industrial Construction, Manufacturing, Pulp and Paper, Healthcare, Telecommunications, Fleet Management, Staffing, Public Safety and affiliated State Agencies.
  • Consistently delivered Reporting System additions and upgrades on time and under budget for Confidential ’s premier
  • Analyzed, re-designed, standardized and updated the functional usability and appearance of a Clinical Assessment Reporting System for the Confidential, ahead of schedule.
  • Over a 5-week time frame, performed an in-depth analysis of a leading Management Consulting firm’s CRM (Salesforce) interface with client’s Consultant Time and Billing System, which had been consistently failing due to data migration issues. Modified the data extraction process and updated the reporting system.
  • Prepared and presented an operations business re-engineering plan for Alexander Proudfoot’s Financial Management Team.
  • Co-partnered in the ETL - Data Transformation of more than 1,100 JD Edwards DB2 Accounting System reporting query results set into a SQL Server 2008 data mart during a 14-month period for Lease Plan USA.
  • Significantly enhanced the performance measurement process utilized by Confidential.
  • Successfully developed a high-profile Marketing logistics data reporting system that correlated market saturation data with latitudinal and longitudinal coordinates for presentation via a topographical mapping system.
  • This logistics presentation system provided critical predictive marketing information essential to a high-level business acquisition decision for Confidential .
  • Co-author of DICOM diagnostic image quality standard for electronically transmitted Fetal Echocardiographic images.
  • This project led to the first successful inter-continental high density diagnostic image transmission trials over common telephony links.
  • Seamlessly merged an existing in-house Business Objects based CRM system with Siebel’s MS SQL Server 2008 CRM product while maintaining regional operations integrity and functionality of the existing system for Confidential .
  • Microsoft Dynamics GP Implementation and Support Consultant.
  • Youngest Division Manager in the history of Continental Can Company. Selected as CCC Harvard MBA candidate.

TECHNICAL SKILLS:

SQL Server, Data Analysis, Database Administration, Confidential -SQL, SSMS, SSRS, SSIS, SSAS, BIDS, Visual Studio IDE, ETL

BMP/DTS, Oracle 8.0 PL/SQL, MS Office, Visio, C#, Great Plains, NET, MS Publisher, VB.net VBA Scripting, QA TestingMS Project Management, Microsoft SharePoint, Microsoft Excel & Word, Microsoft PowerPoint, ASP and ASP.net, Skype, JD Edwards, DB2, Crystal Reports, VSS, Subversion, SOAP, XML, HTML4 & 5, OLAP Data Modeling, WinForms UI, Agile / Scrum, MS Access (SME)

E/R diagramming, Systems, Application / User documentation tools. Workflow and Dataflow Analysis.

EXPERIENCE:

Confidential, Alpharetta, GA

Financial Data Architect

Responsibilities:

  • Provided on going SSRS \ Reports Owner development and Server Admin. Provided SQL db support for MS Dynamics GP 2008, 2015, 2016.
  • Developed an external Access 2016 Provider Time Sheet processing system for LT Accounting Team.
  • Developed a C# based Invoice viewing/printing applet for use by Recruiting Sales Team.
  • Configured and deployed a Public SSRS Reporting web page for use by non-Accounting staff.

Confidential, Atlanta, GA

SRA Contract Reports Developer and LIMS Support

Responsibilities:

  • Provided on going Reports system support to all Labs Confidential the Confidential utilizing Crystal Reports 2011 for Lab Test Results Reports.
  • Provided day to day operations communications archival and document management via SharePoint and VM ware infrastructure.

Confidential, Alpharetta, GA

Contract Microsoft BI Developer

Responsibilities:

  • Converted 550 + of 1,100 IBM i-series DB2 SQL queries and reports to SSRS data source queries and SSRS reports, provided support and mentoring to national BI reporting team in transitioning to SSRS and SQL Server 2008 from Crystal Reports 2011 and Business Objects Enterprise for all sectors of business enterprise.

Confidential, Alpharetta, GA

Contract SQL Server Developer

Responsibilities:

  • Upgraded MS SQL Server 2000 Stored Procedures and Reports in Incident Tracking Reporting System to SQL Server 2005.
  • Modified Agile environment.

Confidential, Atlanta, GA

Contract SQL Server / Crystal Reports Developer

Responsibilities:

  • Converted Oracle 9i based Crystal Reports Financial Statements Reporting System to SQL Server 2008 SSRS for national mortgage lending institution.

Confidential, Alpharetta, GA

SQL Server / Crystal Reports Developer

Responsibilities:

  • Developed SQL Views, Stored Procedures and baseline Crystal Reports for initial product release.
  • Included a framework for Key Performance Indicator aggregation in Excel for Xcelsius dashboard generation.
  • Developed key reports and report templates in Crystal Reports, SQL Server 2008 and Xcelsius Presenter.

Confidential, Atlanta, GA

SQL Server / Crystal Reports Developer

Responsibilities:

  • Developed a SQL View which consolidated all tables in a Key Performance Indicators database into a singular table view which eliminated a complicated and time consuming Microsoft Excel based reporting process.
  • Developed key reports and report templates in Crystal Reports. According to the Director of Performance Management, this process improvement significantly enhanced the performance measurement process worldwide.
  • Additional software included Microsoft Excel, Microsoft Access and Microsoft Word.

Confidential, Alpharetta, GA

Senior Software Engineer

Responsibilities:

  • Maintained and or developed 300+ Windows and Web based Time and Labor Management System reports.
  • Also, performed reporting via Crystal Reports 8.5; these reports were derived from MS SQL Server and Sybase stored procedures utilizing a C++ API and VB.NET back end.
  • PHP was used as the primary web development language.
  • Modified Agile environment.

Confidential, Atlanta, GA

Contract BI Reporting Analyst / Developer

Responsibilities:

  • Provided administrative and maintenance services on several distinct Management Report web sites including: Purchasing, Budgeting, Human Resources / Organization Structure Management Systems. These Reporting web sites were based on SQL Server Reporting via Crystal Reports 11.
  • Data sources included Access 2007 databases, Oracle 9i, Informix and SQL Server databases.
  • In addition, data sources were regularly consolidated into Excel 2007 pivot tables via ODBC for further analysis and summarization.
  • ETL via SSIS, BI via SSAS, Scripts, Stored Procedures and Views via Confidential -SQL.

Confidential, Atlanta, GA

Contract BI Analyst / Reports Developer

Responsibilities:

  • Developed or updated Management and Operations Reports for Oracle 9i based Service Management System - Remedy.
  • This effort was part of an upgrade of Remedy 6.0 using Crystal Reports 10.
  • Interviewed end users and key stakeholders to ascertain needs.
  • Prepared design specifications and user acceptance testing criteria.
  • Provided and end user training and documentation materials.

Confidential, Atlanta, GA

Systems Analyst / Reports Developer

Responsibilities:

  • Upgraded Executive Management Dashboard Reporting System to include dynamic runtime parameter selection lists via ASP generated SQL queries rendered as XML data sources.
  • All Reports were web deployed using SharePoint and Crystal Reports 10 against SQL Server 2000 OLTP database, Scripts, Stored Procedures and Views developed via SMS.
  • Provided Systems Analyst services in reviewing and evaluating outside vendor submissions for new Ad Hoc Reporting system software tools.

Confidential, Duluth, GA

Contract Systems Analyst / SQL Server Developer

Responsibilities:

  • Standardized, created and/or upgraded 160+ Clinical Assessment System reports derived from MS Confidential -SQL stored procedures.
  • These reports were part of a Clinical Information System that is the backbone for Call Center and Walk in Center Clinical Assessment processing for the entire Public Healthcare system of Great Britain. Crystal Reports 10.
  • Acted as stateside Business Analyst in developing state-of-the-art web based Clinical Service Provider Directory and Clinical Knowledge Base Content Management System.

Confidential, Atlanta, GA

BI Analyst and System Administrator

Responsibilities:

  • Provided Report user support and Learning Management System report development for a mature version 8.5 Crystal Reports Server and Developer environment; this environment covered in excess of 1,000 active users throughout the southeast.
  • The majority of the reports were deployed on a version 8.5 Crystal Enterprise Web based Scheduler / Server accessing an Oracle 8i database. Daily tasks included all Security and Reports Server Administration, modifying and executing ad hoc reports, rewriting of stored procedures and updating parameters and deploying reports onto the Crystal eportfolio enterprise web site. Functioned as Confidential internal Project Analyst and Liaison with external vendor in deployment of new Business Objects LMS Reporting System.
  • Translated existing stored procedures and assisted outside developers with database ETL. Refined numerous Complex Reports (various features used include multiple groupings, drilldowns, parameter fields, formulas and retrieving data from more than one database) using Crystal Reports. Tuned numerous complex Stored Procedures for faster execution.
  • Actively participated in setting the standards for Docent LMS Based reports, gathering data and converting them to Business Objects.
  • Provided guidance / assistance to Reporting System Users. Created Ad Hoc reports based on various parameterized Time Date, Job Grade, Course criteria.

Confidential, Atlanta, GA

Visual Basic Systems Analyst / Developer

Responsibilities:

  • Developed a Cell Site Tower Management System using Access 2002. This system was used to assist in the management of roaming access for 140,000 cellular transmission towers throughout the United States.
  • Interviewed stakeholders and developed specification documents for Cell Site Tower Management System.
  • Developed testing and implementation plans.
  • Prepared end user documentation.
  • Successfully implemented Cell Site System ahead of original plan scheduled.
  • Successfully salvaged a WAN based system for monitor and tracking engineering testing, implementation and network operations for worldwide Inter Carrier Voice and Data transmission.

Hire Now