SUMMARY

• I am a technically skilled and knowledgeable certified MS Access Developer wif advanced SQL Server skills, T - SQL skills and database administration experience, including creating functions, stored procedures, triggers, advanced query writing and optimization.
• I have extensive experience creating, reviewing, and understanding reports.
• I understand scrum and have worked in an agile environment.
• Wif an eye for detail, I apply analysis and design techniques to address business needs in order to produce data extracts, data feeds, and reports that enable users to access and analyze data in teh data warehouse and report applications.

TECHNICAL SKILLS

• T-SQL
• SSMS
• SSRS
• SSIS
• SAP
• XML
• XPath
• XSLT
• VBA
• MS Office 2016
• MS SQL Server 2008 R2-2017
• MS SQL Reporting
• DB2
• AS400
• Visual Studio
• SharePoint 2010
• Tableau
• DB2
• Oracle
• ACCESS
• Database Design
• Crystal Reports
• SQL Server
• Database Services
• EXCEL
• Business Process Management
• IBM Data Studio
• SQL Reporting Services
• Power B

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Reporting Developer

Responsibilities:

• Responsible for ongoing enhancements and maintenance of operations reporting and metrics
• Works wif department leads in teh assessment, validation, and recommendation of best reporting solutions for business requirements
• Works closely wif department leads in other areas to determine needs and format/design of requested data, to meet user needs, whether clearly specified or only implied
• Develops report applications and makes modifications to existing applications based on previously prepared specifications
• Participates in teh research and recommendation of new tools, techniques, and methods as they apply
• Create, update and maintain any necessary requirements and technical documentation
• Ability to estimate time for report stages and prioritize work to achieve designated tasks
• Creation and maintenance of key metric reports, daily, weekly, monthly
• Measure process adherence wif detail reports
• Identify, document and apply business rules to data sets and reports in order to create data integrity across teh divisions
• Identify operational concerns and present fix recommendations

Confidential

Lead SQL Report Developer/Database Implementation Analyst

Responsibilities:

• Lead end-to-end business intelligence (BI) implementation projects
• Prepared high level architecture design for SSRS reporting solutions
• Lead teh development, documentation, and support of standardized and customizes reports using SSRS and Tableau
• Scoped client requirements
• Worked wif end uses to perform requirements gathering and converted it into technical documentation
• Demonstrated outstanding communication skills to translate reporting requests to accurately meet teh actual information and deadline needs of users
• Lead client engagement in developing plans and strategies for data management processes and IT programs for clients
• Provided hands-on assistance in data modeling and technical implementation
• Lead and mentor other IT consultants wif teh team and across units
• Supported business development and ensure high levels of client satisfaction during delivery
• Provided best practice advice to customers and team members
• Evaluated clients’ existing business processes to create specifications for teh configuration of teh reporting system
• Implemented and integrate interfaces to third-party systems using XSLT, XML, and SQL technologies
• Created rules and data transfer mappings using XPath and XSLT

Confidential

System Consultant (Access Developer)

Responsibilities:

• Maintained existing Access database applications
• Added new functionality to existing database programming using VBA
• Created new tools to support both internal and extremal process needs
• Led internal testing efforts and created end-user documentation and training

Confidential

Systems Software Specialist

Responsibilities:

• Provided top-level technical direction in designing, coding, testing, debugging, and documenting teh most complex systems software and databases
• Developed five new Microsoft Access database applications
• Prepared flowcharts, block diagrams, machine instructions, and documentation on teh more complex systems software
• Installed and maintained systems software packages
• Solved software problems and corrected problems wif temporary and permanent fixes
• Trained users in teh operations of new and existing systems software
• Recommend standards and procedures concerning software implementation or utilization

Confidential

SQL Database Developer

Responsibilities:

• Managed and developed SQL queries, built reports using SSRS, managed databases wif multiple data sources, developed web applications, and troubleshot various issues wif existing reports
• Used various enterprise BI tools including Micro-Strategy, Microsoft SSRS, Microsoft SSIS, Microsoft SSAS, or other applicable tools
• Provided BI analysis and functional expertise for business requests, defects/enhancements, and projects in an agile environment
• Worked directly wif teh business customers to understand and interpret requirements, and create technical specifications from those requirements
• Tuned existing and created new Microsoft SQL Server T-SQL stored procedures and functions
• Worked wif other team members to support production databases
• Documented recommended enhancements and discuss wif other team members
• Worked wif development staff to create SQL Server database objects to support new development objectives
• Built and maintained SQL scripts
• Built and maintained complex SQL queries for data analysis and data extract
• Designed, Developed, Delivered, and Supported applications using Business Intelligence tools including Micro-Strategy, Microsoft BI Stack (SSIS/SSRS), or other BI tools utilized by teh Sales BI team
• Created and Modified ETL packages
• Implemented Stored Procedures to audit Call Data for teh Enterprise Call Data Report
• Developed and Implemented SharePoint Site for Support Desk Trainers evaluations and feedback
• Developed Email Triggers using SQL Server Database Mail Services
• Developed Dashboards using SSRS and Tableau

Confidential

Data Coordinator II

Responsibilities:

• Collected, manipulated and analyzed data in order to prepare reports, in teh form of visualizations such as graphs, charts and dashboards, detailing teh significant results gathered
• Manipulated, cleansed and processed data using SSMS, Access, and Excel
• Audited and monitored all data for accuracy
• Extracted and loaded data to Federal Regulatory Agencies
• Created data reports
• Trained end-users
• Office Manager for teh Director of Consumer Services
• Managed Budget and Accounting using SAP and SRM, ERP systems
• Managed Data Helpdesk and troubleshot, corrected and/or overrode data issues
• Implemented protocol and procedures to significantly reduce data entry errors
• Created training programs to educate staff on business rules to reduce data errors
• Created dashboards and reporting solutions to optimize decision making by senior managers