SUMMARY:

• Looking for SQL 2012 SSRS & SSIS work as a Business Intelligence Analyst.
• Designer of multi - user databases for business metrics reporting and corporate financial analysis.
• Software Expertise: Office Professional 2013, SQL Server 2000/2005/2008 R2/2012R2 (BIDS, SSRS, SSIS & SSAS) SharePoint 2010, Brio Designer and Crystal Reports 9 & Visual Studio (C# /VB.Net) TOAD for Oracle; PL/SQL Oracle 9x/11x; Network Automation Automate7 Professional
• Network Administration: MS NT& 2000/2003/2008 R2 Server, MS Exchange 2000 & Active Directory Services.

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Analyst

Responsibilities:

• Hired to pick up backlog on SSRS Reporting for Finance and Operational Business Reporting for Doctors and Nurses in the Anesthesia field. The reports provided communication between Confidential and it’s Partners covering Monthly/Quarterly Finance Close and Credentialing of Doctors/Nurse per each facility.
• SQL Server Integration Services (SSIS): Designed an SSIS process to compile data from Quality Anesthesia events that can be shared between partners for process improvement of the Web based collection system.

Confidential, Houston, TX

Sr. Data Analyst

Responsibilities:

• Primary role was to help develop a Data Warehouse/Data Mart for all Litigation Cases.
• This database would contain Contacts, Clients with cases and results during that process.
• Created SQL Stored procedures to pull from Case Manager Pro all detail information into the Data Warehouse/Data Mart.
• Secondary role was to help migrate from the 2 database systems to upgrade to Law Ruler, Case Manager Pro, iManage (Document Management System), & Microsoft Dynamics (Great Plains SQL) finance server.
• Evaluated each Test Migration and helped Development Team make adjustments on source to target.
• Modified the Case Manager Pro Template system to produce generic templates that increased outgoing client communications by 4 times previous production.
• The Data Warehouse/Data Mart was designed to provide the aggregate totals for Clients, Cases and Cycle Times which will help target system improvement and status of Litigation Cases.

Confidential, Houston, TX

SQL Server Report Developer

Responsibilities:

• Two were designed for Employee Time Evaluation and Bonus Reporting and two others were for Part Obsolescence and On Hand Parts.
• Modified and repaired 6 Vehicle Forms and Reports that entailed the Sales to Customers as well as monthly and quarterly Ad-valorem Tax reporting. Repaired an overlay Title Transfer report that quickly fills in State Title information.
• Re-deployed and re-tested over 30+ new revised production forms and reports.
• Modified current production report procedures when highlighted, to ensure efficient SQL design and best practices.

Confidential, Houston, Tx

SQL Server Report Developer

Responsibilities:

• Consolidated 132 uniquely separate Crystal reports into 37 SSRS by using the advanced SSRS features.
• This reduced reports inventory down to 45 and the IT maintenance drastically.
• Created and consolidated a 3-part Crystal Report Business Process into 1 single SSRS Report solution which allows the users one report venue to complete all Sales Related Tasks (Estimate/Quote/Acknowledgement).
• Created an SSRS Reports Development Standards document which simplifies the IT process for report development.
• Maintained and created VB.Net Snippets library for SSRS Expressions and T-SQL ensure reusable standardized coding techniques for the Development Group.
• Administered the SSRS Production Site as well the Test Site.
• Created Stored Procedures for specialized Executive reporting.
• Modified and maintained all Production Reports previously released.

Confidential, Austin, Texas

Senior Software Programmer and DBA

Responsibilities:

• SQL 2008R2 MSBI Migration from VB6 Applications to MSBI SQL DB Solution (SSRS 2008 R2 VB.Net 3.5)
• Reviewed and modified MSBI Data Mart Spares Manufacturing Division Web UI Project for Best Practices and Standards.
• Verified MSBI Metrics Migration upon Internal System Test and Migration Scripts completed (Phase I).
• Modified Beta 01 for User Acceptance Testing 1 st Pass (Critical/High/Minor) changes on Development Server.
• Created Disaster Preparedness Plan (with DBA owner) to revert to UI per the sustaining VB App 6 functions.
• This ensured both users and management received necessary reporting for Phase I Implementation.
• Used Code on Time for Web development (VB.Net 3.5) to create the UI for the MSBI Solutions.

Confidential, Houston, Texas

SQL Report Writer (SQL 2008/SSRS/VB.Net) Sr. Data Analyst

Responsibilities:

• Primary Tasks: Create and migrate SSRS reports to new SQL 2008R2 Server (migration from 2005/Crystal Reports).
• Formalized with the Project Manager and outline to deliver the reporting required for the Retail Department.
• Created new reports with internal/external clients and Marketing Department for new business analysis.
• Migrated only essential reports for Confidential Retail Department to meet new requirements of sub-retail divisions within the Confidential organizational structure.
• Analyzed and identified current reports to ensure outputs were within Business Requirements and within the Business Units Executive Requests.
• Created a formal Report Request Process that clarified the Business Analysis Reports (Targets and Goals).

Confidential, Coppell, TX

Sr. Data Analyst

Responsibilities:

• Hired per Statement of Work for Data Warehouse Architecture and Design; primarily for ETL Services and current technology implementation. (Oracle/Informatica)
• Completion of an MS Access DB for migrations from ESP Remedy System to BMC Software Remedy; successfully deployed the tool and completed 4 packages of currently scheduled customers.
• Created Product Governance Team(s) to ensure migrations and enablement were successful upon upload to new AOS Managed Operations Platform.
• Formalized Exception Processing Billing Requests using Oracle/Java program; redesigned new process for efficiency and accuracy.
• Output products were formalized in Visio Business Process Development and signed off on by Sr. Finance SAP.
• Back-filled unexpected loss of Senior Billing and Ordering Designer; worked with Sr. Developer & SAP Manager to ensure all Sys Test/UAT Test Validation Requirements were met or placed in arbitration for secondary release.

Confidential, Plano, TX

SQL Server Developer/Business Data Analyst

Responsibilities:

• design data model and prototype for SSRS and SSAS Executive Management Reporting.
• Developed and designed the SSIS packages and schedule for SQL Agent jobs in accordance with the data model and ETL design requirements.
• The Disposition Data Mart was designed to report and help facilitate delinquent loan issues and provide a path for the litigation teams to resolve loan related issues.
• This tool also provides exception reporting as it is related to quality data entry issues that have loans improperly coded and in the wrong status or loan type.
• My primary task on this project was to write all Stored Procedures that load the database as well as maintain and develop all DDL Script designs.
• Secondary tasks included the alignment to our Business Requirements Document, Data Mapping and High Level/Low design documents.
• I was promoted to DBA but maintained my position as Senior Data Analyst due to my knowledge and skills in SQL and Business Report writing.

Confidential, Round Rock, TX

SQL Developer/Report Writer/Business Data Analyst

Responsibilities:

• I was called in on an emergency backfill due to the loss of the Senior Programmer Analyst who had been maintaining 86 MS Access databases in various revisions from Access 97-2003, which provide all aspects of Manufacturing Reporting and Status.
• These databases consist of 44 application databases using VBA to run code and populate 42 backend databases.
• These databases are setup on 3 application PCs that use Task Scheduler to kick-off batches.
• They require intensive maintenance and review to ensure the entire Extract, Transform and Load (ETL) runs smoothly and reports and applications are available 24-7.
• Since I helped design the architecture for data pulls and code, I was asked to come back and maintain these databases and help design and implement an IT permanent, stable and scalable solution. The business analysis was focused on current and shipped production levels.

Confidential, Austin, TX

SQL Database Developer/Report Writer

Responsibilities:

• Developed a SQL 2008 database that collects performance metrics
• Developed the star schema database model and all SSIS & SSRS reporting tools for this system.
• Developed MS Access interface and excel output reports for all users. The SQL development required table-valued function and SQL procedures for fact tables and aggregates.
• I developed the use of an automated File Monitor tool which allows for automated processing of data by the user; via drag and drop on to a file server.
• Created SQL Agent Jobs and procedures to manually trigger batch files via Departmental Web User Interface (UI). Drafted the design of the UI.
• Output products and tools are designed to provide automated Operations Reporting Packages presented in PowerPoint to Executive Management.
• These analyses were focused on On-Time-Delivery; production and control by production line; volumes per manufacturing line.

Confidential, Austin, TX

Quality Data Analyst

Responsibilities:

• Reviewed medical records for billing and invoicing. Recommended design changes to programming team for enhancement to Confidential interface.
• Reviewed failed EDI 835 Medicare upload batches for enhancement to upload (ETL) process.
• This project reduced the failures for upload by 58%.