Experience

Computer Technology Associates
• Information Technology & Services
• 1 - 100 Employee
• Database/ Report Developer

  • Jan 2016 - Present


CMI

• United States
• Non-profit Organizations
• 1 - 100 Employee

• ETL Developer/ Report Writer

  • Dec 2013 - Dec 2015

  - Integration Services: The company ETL developer. All packages created in SQL Server 2012 Integration Services. - SSRS Report writer: Set up of new environment to run SSRS reports in SharePoint. - AMS Report Writer: Script writer for all reports pulled on the AMS system called MemberSuite/ ACGI. Accomplishments Include: Interviewed all departments to ensure all reporting needs were met for transition after data migration to the new system. - Created Entity Relationship Diagrams for new data marts - Business Objects/ Crystal Report Developer - DDL/DML Script writer Show less



Staples

• United States
• Retail Office Equipment
• 700 & Above Employee

• SR Database Analyst/ DBA

  • Apr 2012 - Dec 2013

  - Integration Services: Key leader in developing and maintaining ETL packages. Used SQL Server Integrated Services & Pentaho Kettle. Accomplishments include: Performance enhancements on problematic jobs. Increase performances by 80%. Lead on production issues. - SQL: Go to person for any SQL help from junior Data Analysts. Plan, design, and implement application database code objects, such as stored procedures and views for SQL Server/ MySQL. Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction. -DBA: MS SQL Server database administration, including configure Scheduled Tasks for regular ETL jobs, Stored Procedures data cleansing scripts, create and modify tables, stored procedures, various clustered and non-clustered and indexes. Show less



FIS-LPS

• Information Technology & Services
• 1 - 100 Employee

• Reporting Analyst

  • Feb 2009 - Apr 2012

  - Integration Services: Created various ETL (Extract, Transfer, Load) packages for the data warehouse and reporting tables. Data transfers included sources from various platforms (SQL Server 2008 (through VPN), Oracle Applications, text files, SharePoint and wsdl files) - Reporting Services: Created various reports using Visual Studio Report Services builder. Reports were also created using data connections from the data warehouse into Excel documents. Also created various databases in Access for adhoc reporting. Used email integration (Outlook) to communicate with Access to automate report and send to distributions using VBA. Used Excel with ODBC data connections into Access and SQL Server 2005/ 2008. Finalized Excel adhoc reports by using functions (VLookup, iserror, datediff) - TFS: Used Team Foundation Server for new ticket/ bug task management and as a versioning tool. - Project Lead: Served as a project lead for gathering business requirements from the Accounting/ Finance department and translated them into functional/ physical designs. Identified key fields across platforms for the Accounting/ Finance cube and reports. - Database Development/ Admin: Was key to creating new database structures. Creating ERD's and implemented the approved structure. Data transfers into the new databases were completed using ETL. Performed monthly snapshots and granted permissions. Show less



Coastal Carolina University

• United States
• Higher Education
• 700 & Above Employee

• Applications Analyst

  • Nov 2007 - Feb 2009

  - Web Applications: Analyzed, developed and enhanced custom web application for the Judicial System of Coastal Carolina University. Developed and maintained the online housing application for Residence Life and ensured successful payment was received by the State Payment System. Once the data was entered by the students, it was stored in MySQL backend (phpMyAdmin). Once received in MySQL, the data was then imported into Access database. All Web Applications was created using PHP, JavaScript, CSS and HTML. - Database Enhancement: Performed database tuning to enhance performance of the judicial system. This was accomplished by normalizing the database and then conducting query optimization testing for best performance. This improved the search tool. - Excel/Access Database: Created a new database (Access) for a new residence hall. The database was used to store room assignments and student profile information. Once the data was established, I customized queries in Access to help report the room assignments. Used the Data Connection relationship between Excel and Access to create Pivot Tables and Reports for one click away real time viewing. - IT Support: Was IT Support for the Housing department. This involved new computer/ peripheral set-ups, new computer purchasing, new smart room set-up, new mobile device set-ups, new software installations and OS restores/ upgrades. - Development Method: The Agile method (iterative development) was used on the development of all projects. This allowed the business receive frequent updates and provide frequent feedback. Show less



Washington Mutual

• United States
• Insurance

• Business Data Analyst II

  • Dec 2006 - Nov 2007

  Analyzed and evaluated existing and proposed process solutions and systems to devise and modify procedures to process data and solve problems. Assisted the Warehouse Analyst create data marts. Analyzed user requirements and design/implemented new or revised process solutions and related system requirements. Created various reports and graphs to illustrate trending and status of benchmarks tracked within the financial Capital Markets division. Use the SQL Analyzer in Business Objects to create new adhoc reports. Further analyzed reports to automate on a weekly, bi-weekly and monthly basis. Complied with business rules to design new/ existing financial production reports. Facilitated system testing for new data elements as well as regression testing for the new Business Objects system release. Show less