TECHNICAL SKILLS:

Databases: Microsoft SQL Server 2005/2008 R2/2012, Postgres SQL(pgAdmin III) and Microsoft Access.

Business Intelligence/Reports Tools: Tableau(7.0, 9.0, 10.0), Microsoft Excel, Crystal Reports, SSRS, SSIS.

ETL: SQL Server Integration Services, Talend Open Studio for Data Integration

Confidential (Backup and Restore) Reporting Tools: EMC DPA (Data Protection Advisor) 5.8.5 and 6.2.1

Source Control: TFS, RedGate SQL Source Control, Tortoise GIT and SVN, Visual Studio

PROFESSIONAL EXPERIENCE:

Confidential

Senior BI Engineer

Responsibilities:

• Assisted in the conversion of manually run Excel BI reports to fully automated Tableau reports using current data structure and visualization principals.
• Created a process utilizing tabcmd to dynamically allow for event driven Tableau extract updates.
• Setup SSRS, SSIS and SSMS GIT repositories and trained BI team members in proper utilization of source control tools (Visual Studio and RedGate SQL Source Control).
• Initiated efforts to minimize unnecessary duplication of code by implementing QA, code documentation, and report development standards.

Confidential

SSMS - Confidential Senior System Engineer

Responsibilities:

• Responsible for developing and maintaining SSMS- Confidential applications and reporting for Confidential (Backup and Restore) offerings and engineers.
• Member of the engineering team responsible for developing a migration plan to move from DPA 5.8.5 to DPA 6.2.1. This included migrating reports from SSRS 2005 to SSRS 2012 and migrating from MS SQL Server 2008 to Postgres 9.4 database.
• Used a standard development process to create solutions based on business and technical requirements.

Confidential

Senior SQL Developer/BI Developer

Responsibilities:

• Gathered requirements based on business needs and developed SSAS cubes and SSRS reports as needed.

Confidential

Senior SQL Developer

Responsibilities:

• Manage customer loyalty database creating SSIS packages and SQL jobs to perform daily ETL.
• Utilized advanced TSQL knowledge to create adhoc queries, stored procedures, triggers, table constraints, and indexing solutions/query analysis, which optimized overall performance.
• Work closely with development team to design and implement SQL Server databases and integrations for business applications.
• Perform requirements gathering and analysis working closely with business owners and team members.
• Perform problem resolution and root cause analysis along with recommending and implementing preventative techniques.
• Ensure overall health, reliability, performance, availability and capacity of databases.

Confidential

SQL Developer/Report Analyst

Responsibilities:

• Design and develop ETL processes utilizing SSIS.
• Author and troubleshoot SQL code for commission and accounting processes (stored procedures, functions, triggers, views, indexes, etc.)
• Develop reports using TSQL and SSRS 2008, Crystal Reports, Tableau and Excel (VBA/Pivot)
• Lead efforts to promote self-service BI reporting utilizing Tableau.
• Provide solutions to business users and C-level management by gathering requirements, developing requested processes or reports, testing new processes and applications, training business users, and deploying to production.
• Perform common scheduled database maintenance including backups/restores, archiving, and monitoring data transfers.
• Work closely with Confidential Inc. to integrate J6 commission software with reporting data mart.

Confidential

Data Analyst/SQL Developer

Responsibilities:

• Created and maintain SSIS Packages to automate efficient and accurate data manipulation and transfers.
• Created, optimized and maintained TSQL stored procedures and functions.
• Liaison between business unit and C-level mangement and integral in the business analysis and requirements gathering process.

Confidential

SQL Developer/Director of Field Operations

Responsibilities:

• Responsible for overseeing field operations team which provided administrative and data analysis support to over 80 sales teams.
• Developed and maintained leads, commission and employee databases utilizing MS Access and MS SQL.
• Managed payroll issues, invoicing, reported sales, revenue recovery, team performance reports, new market launches, and other operational responsibilities.
• Responsible for lost revenue analysis that resulted in $1.5 million in recovered revenue.

Confidential

Transfer Agent Specialist

Responsibilities:

• Responsible for processing trade orders received from shareholders.
• Performed several tasks related to maintaining a high degree of quality to ensure that the Transfer Agency is meeting its regulatory responsibilities with the Confidential .
• Facilitate the processing of shareholder trade orders and maintenance request received through the National Security Clearing Corporation ( Confidential ) trading system.

Confidential

Executive Assistant

Responsibilities:

• Responsible for assisting the Vice President of Operations with various administrative projects.
• Implemented training classes for employees studying for Series 7 exam.
• Arranged all personal/business travel and maintained expense reports.

Confidential

Aviation Maintenance Administrator

Responsibilities:

• Verified accuracy of asset history record, documented and corrected discrepancies in asset history reporting.
• Projected asset installation and removal based on operating time and prescribed upkeep interval.
• Developed tracking system and Excel database for manufacturer asset modification and updated on scheduled basis.