SUMMARY

• An accomplished, senior - level IT professional with 13+ years of experience in business intelligence development with an emphasis in SQL Server Management Studio, SQL Server Integration Services, and SQL Server Reporting Services.
• Skilled in business requirements gathering, GAP analysis, data modeling, development, implementations, and documentation across a diverse spectrum of industries. Leverages strong communication and self-motivation to deliver projects on time. Keen insight into utilizing data analytics to solve complex business problems.

SKILLS

• SQL Server 2005 - 2016
• BI Reporting
• Data Visualization
• Microsoft TFS and GIT
• SQL Server Integration Services Power BI
• Code Reviews
• SQL Server Reporting Services
• Microsoft Dynamic CRM
• Salesforce Agile Principles Analytical Problem -Solving
• SQL Server Analysis Services
• Visual Studio 2003 - 2017
• Jira
• SharePoint
• MS Office Suite

PROFESSIONAL EXPERIENCE

Confidential, Chandler, AZ

SENIOR ANALYTICAL CONSULTANT

Responsibilities:

• Accountable for collaborating with business analysts and stakeholders to build complex calculations to identify bank losses or gains over the life of investments based on documented cash flow, income, and expenses.
• Partnered to validate that all tools were updated in compliance with company and federal guidelines.
• Built and stabilized the BI reporting and analytical tools to analyze future costs and identify underperforming assets by combining income statements, benefit statements, and financial snapshots in collaboration with business analysts and stakeholders.
• Planned the development lifecycle, including the transition from a waterfall methodology to an agile practice.
• Built new SSIS packages to consolidate data from multiple third-party applications for reporting purposes.
• Successfully built a report that streamlined the investment impairments process designed to put on the year-end ledger.
• Recognized for streamlining and consolidating the process for completing the annual audited report, reducing the time from weeks to minutes.
• Improved the organization of sprints after identifying a missing requirement during a release sprint and collaborating to ensure it was captured and that all other stories were developed and tested.

Confidential, Phoenix, AZ

DATABASE DEVELOPER

Responsibilities:

• Designed logical and physical data models and prepared and presented statistical information for internal and external use.
• Assisted the accounting department with monthly and yearly tax reporting by developing reports and cleaning load processes.
• Built new SSIS packages that consumed flat files from our vendors and enabled billing customers for their specific usage.
• Redesigned the import process to reduce the development time for importing new files from several months to several days.
• Successfully reduced duplicated and missed fees during the billing process by rewriting key portions.
• Decreased the development time from three months to three days after rewriting the configuration tables that held consistent data for each customer whenever new customers were added, which had previously been a manual process.
• Improved the time needed for the accounting team to locate and update daily re-projections whenever necessary by rewriting the report using proper indexes and no sub-selects to alleviate multiple reads for the same data.

Confidential, Phoenix, AZ

BI DEVELOPER

Responsibilities:

• Charged with developing, deploying, and maintaining BI interfaces, including query tools, data visualization, interactive dashboards, ad-hoc reporting, and data modeling tools.
• Developed multiple SSIS packages to consolidate data from 60 databases and flat file locations into a single data warehouse.
• Partnered with business analysts and business stakeholders to map legacy and existing data schemas for import into the data warehouse.
• Conducted code reviews to ensure new code worked in the most effective manner and the way the developer expected without introducing bugs into the new code.
• Effectively resolved an issue that required a reload of all claim data into the data warehouse yet was unable due to the large size by rewriting the claim logic enabling a load of 500K records at one time. This reduced the amount of needed space and subsequently took only 8 hours to load.

Confidential, Phoenix, AZ

BI DEVELOPER/DATABASE ADMINISTRATOR

Responsibilities:

• Built database systems for availability and quality based on roles and designed and implemented databases in accordance with end-user needs.
• Assisted the accounting department in completing month-end closings by identifying issues with the data and ensuring all monthly revenue and cash was accounted for.
• Worked closely with new team members to educate them on the reporting process, including the department's development rules.
• Successfully increased the completion rate from 73% to 83% and reduced the nightly processing time from 15 hours to 8 hours after implementing transactional replication with most databases. Also reduced the number of processes from 8 per night to 2 per night.
• Conducted root cause analysis and identified an older system wasn’t reloading data correctly. Freed up over 600Gb of space on the server eliminating the need to get a new database server by rewriting the load procedure to merge the data correctly and removed the duplicate data.

Confidential, Scottsdale, AZ

SQL SERVER REPORT DEVELOPER | DATA ANALYST

Responsibilities:

• Optimize SQL Server queries to better retrieve data upon requests and develop solutions to mitigate inefficient systems.
• Performed backups and restoration of SQL Server databases, changed recovery models, performed database shrinking and scrambling for transfer across FTP.
• Installed SQL Server 2005, 2008, and 2008 R2 on development machines and customer sites for production and test environments.
• Mapped legacy systems and existing data schemas for import into the database with new customers.
• Created SSRS SMDL files for customers to enable them to build their own custom reports.