• Oversaw the entire expense reporting and data loading process via SFTP, SSIS, T-SQL, MS Access (VBA).• Implemented data migration tools between many systems via SSIS, sql and various other tools.• Prepared financial statements and assisted with the month-end close every month using customized Job Costing analysis in SSRS.• Converted many older MS Access projects to SQL Server 2008 R2.• Full development life cycle of data reporting projects in many different systems. Some such systems include LexisNexis Interaction, CCH Practice Management, Microsoft CRM and Concur.• Administered for the entire company the Concur expense system.• Supports CCH Practice Management Time Entry billing system and Interaction.

• Provided customized application of database development tools and methods to meet client business and project needs. . (embedded/dynamic SQL and T-SQL)• Supported and developed optimized T-SQL for huge quantities of call data. • Worked closely with client team to determine the preferred solutions and assist in the accomplishment of designated objectives to include routing and reporting design, configuration, scripting and testing/validation . (embedded/dynamic sql, SQL and T-SQL)• ETL exposure via SSIS.• Ensured successful execution of client’s Enterprise Reporting Program by providing the following support: * Validated call data statistics using Cisco, Avaya, and Aspect switches. * Assisted in implementing standard business processes company wide. * Created customized tools and DB tables. * Helped to implement daily import and export of large collections of data.

• Designed and Supported Cognos Cubes via TM1• TM1 System support design and implementation. Designing Sarbanes Oxley compliant documentation.• Created active forms/reports, cubes and turbo integrator procedures for various clients such as Dun & Bradstreet, PPD, Endo Pharmaceuticals.• Hands on Client Support and troubleshooting.• Earned Certified TM1 Analyst status.