Experience

Volvo Car USA

• United States
• Motor Vehicle Manufacturing
• 300 - 400 Employee

• Senior Technical Analyst

  • Sep 2021 - Present

  ****This project is to oversee multiple systems and API Integrations. *Coordinated and consulted with business in gathering requirements and translating requirements into technical specifications. *Managed DI project timeline, development, and production roll out. *Database analysis, performance troubleshooting and solution optimization implementation. *Manage and maintains system process flow to ensure daily optimal performance. *Created designs and performed demos of system… Show more ****This project is to oversee multiple systems and API Integrations. *Coordinated and consulted with business in gathering requirements and translating requirements into technical specifications. *Managed DI project timeline, development, and production roll out. *Database analysis, performance troubleshooting and solution optimization implementation. *Manage and maintains system process flow to ensure daily optimal performance. *Created designs and performed demos of system process flow and Integrations *Coordinated with various development teams and responsible for analysis and design of Data Integration functionalities. *Responsible for delivering data integration functionalities within system projects. Show less



Spantech Software

• Software Development
• 1 - 100 Employee

• Senior Technical Consultant

  • Aug 2018 - Present



Sony Music Entertainment

• United States
• Musicians
• 700 & Above Employee

• Senior Business Analyst/Database Developer

  • Aug 2018 - Sep 2021

  **** This project is to support the Copyright Royalities System at Sony Music **** *Consulted with users and stakeholders to determine requirements and specifications. *Created and designed stored procedures for a new process to replace an existing one. The new process runs 200% faster than the previous process. * Created a process with multiple stored procedures and tables to add a new Label to the current copyright environment. * Interacted with business and developers to… Show more **** This project is to support the Copyright Royalities System at Sony Music **** *Consulted with users and stakeholders to determine requirements and specifications. *Created and designed stored procedures for a new process to replace an existing one. The new process runs 200% faster than the previous process. * Created a process with multiple stored procedures and tables to add a new Label to the current copyright environment. * Interacted with business and developers to implement various features to the application. * Created test cases to create SOX compliance documents. * Implemented a process to gain the ability to import Excel data more efficiently into the database using VBA. * Supported technical inquiries from business partners. Show less



Spantech Software

• Software Development
• 1 - 100 Employee

• Technical Consultant

  • Mar 2006 - Aug 2015



Costume Gallery

• Senior Business Analyst/ Senior Database Developer- ERP Data Conversion

  • Aug 2014 - Jan 2015

  **** This project was initiated by a corporate decision to move away from the current ERP system (AS400) and convert to another ERP System (A2000) *Consult with business to understand legacy system process to create solution for system migration. * Built complex SSIS packages and SQL Server 2008 R2 database to convert master and transactional data from AS400 to A2000. *Business Analysis for mapping information to maintain data integrity * Consulted, created, implemented solutions… Show more **** This project was initiated by a corporate decision to move away from the current ERP system (AS400) and convert to another ERP System (A2000) *Consult with business to understand legacy system process to create solution for system migration. * Built complex SSIS packages and SQL Server 2008 R2 database to convert master and transactional data from AS400 to A2000. *Business Analysis for mapping information to maintain data integrity * Consulted, created, implemented solutions for issue such as storing products differently because of system limitations. * Created Adhoc reports to show data integrity. Show less



Bookspan, LLC

• United States
• Entertainment Providers
• 1 - 100 Employee

• IT Developer

  • Jun 2013 - Jan 2015

  New York, New York **** Developed a Royalty System using C#.NET,SQL2008 R2, and SSIS. This allowed users to calculate royalties and create reports to send to Studios. **** *Business Analysis of the daily process to create a system that developed and satisfied all requirements. *Managed project timeline, development and production roll out. *Created and Designed screens using C#.NET *Designed and Developed SQL database including stored procedures, tables and scheduled jobs. *Created and maintained… Show more **** Developed a Royalty System using C#.NET,SQL2008 R2, and SSIS. This allowed users to calculate royalties and create reports to send to Studios. **** *Business Analysis of the daily process to create a system that developed and satisfied all requirements. *Managed project timeline, development and production roll out. *Created and Designed screens using C#.NET *Designed and Developed SQL database including stored procedures, tables and scheduled jobs. *Created and maintained SSIS packages for data from SAP. * Designed, created, and maintained SQL Server 2008 R2 Database to load sales, calculate royalties, and create reports to send out to Studios. *Design front end functionality to update and maintain price books. Show less



Panasonic North America

• United States
• Appliances, Electrical, and Electronics Manufacturing
• 700 & Above Employee

• Cognos/Database Programmer

  • Aug 2012 - Mar 2013

  **** This project was to rapidly build and deploy a working prototype to show greater visibility to futre sales opportunities based on historical data. **** *Design logical and physical modeling of data warehouse, data marts and cubes. *Design and deploy Cognos Framework metadata layer. * Design and deploy reports using Cognos Workspace Advance and Report Studio *Installed and configured Cognos 10.2 on the cloud *Provided training to the Sales team and supported their efforts… Show more **** This project was to rapidly build and deploy a working prototype to show greater visibility to futre sales opportunities based on historical data. **** *Design logical and physical modeling of data warehouse, data marts and cubes. *Design and deploy Cognos Framework metadata layer. * Design and deploy reports using Cognos Workspace Advance and Report Studio *Installed and configured Cognos 10.2 on the cloud *Provided training to the Sales team and supported their efforts to develop their own reports using Cognos Workspace Advance. * Designed, implemented and deployed cubes using Cognos Framework Manger and Cognos Powercubes * Created bat job for cubes to be refreshed automatically Show less



Horizon Group USA

• United States
• Manufacturing
• 100 - 200 Employee

• IT Consultant

  • Nov 2010 - Aug 2012

  ERP Data Conversion Nov 11 - Jun 12 * Performed Data Conversion for Horizon's new division to incorporate into the current Apprise ERP system using complex ETL tools and processes. *Project required use of my Business Analysis skill set to understand complex business processes and business data structure. * Project included conversion of Customers, Suppliers, AR, AP and Products. Systems Developer/Programmer for Products Worksheet Mar 11 - Aug 12 * Designed, implemented… Show more ERP Data Conversion Nov 11 - Jun 12 * Performed Data Conversion for Horizon's new division to incorporate into the current Apprise ERP system using complex ETL tools and processes. *Project required use of my Business Analysis skill set to understand complex business processes and business data structure. * Project included conversion of Customers, Suppliers, AR, AP and Products. Systems Developer/Programmer for Products Worksheet Mar 11 - Aug 12 * Designed, implemented and deployed enhancements using VB.net, VBA, SQL Server, and SSIS. * Managed project timeline, development, and production roll out. * Provided training and support to the marketing and product teams * Production Support on all issues Data Warehouse Developer Mar 11 - Aug 12 * Design logical and physical modeling of Data warehouse, data marts and cubes * Technical Analysis of source data * Design and deploy ETL process * Production Support on data flow process ERP Data Conversion Nov 10 - Mar 11 * Worked directly with business to understand current implementation of current system Macola. * Collaborated with ERP consultant to gain understanding of new system and procedures * Designed and implemented the data extraction and transformation processes using SSIS and SQL Server 2008 R2. * Designed and implemented AHOC reports using standard SQL Server to ensure data integrity for business to sign off on. *Item master contained over six thousand items *Transactions numbered in the millions. Show less



Sony Music Entertainment

• United States
• Musicians
• 700 & Above Employee

• IT Consultant

  • Mar 2006 - Aug 2010

  Oracle Developer for Digital Rights Administration Jan 09-Aug 10 * Designed new routines using UNIX scripts and Oracle * Performed Business Analysis and worked directly with numerous users * Implemented enhanced reports using PL/SQL * Communicated with business users using JIRA to track issues Oracle Developer for Content Management System April 07 - Dec 08 * Designed, implemented and maintained ETL process using UNIX scripts and Oracle. * Designed and implemented a… Show more Oracle Developer for Digital Rights Administration Jan 09-Aug 10 * Designed new routines using UNIX scripts and Oracle * Performed Business Analysis and worked directly with numerous users * Implemented enhanced reports using PL/SQL * Communicated with business users using JIRA to track issues Oracle Developer for Content Management System April 07 - Dec 08 * Designed, implemented and maintained ETL process using UNIX scripts and Oracle. * Designed and implemented a new ETL process from Oracle to Prostgres. Primavera Project Management System Admin March 06 - April 07 * Developed and implementation project plan which included milestones, data validation models, and role and task assignments. * Created reports for weekly status meeting to the steering committee. * Trained all end-users * Created Unix scripts on production support work flow * Created technical and user documentation * Rolled out to multiple departments Show less



Law Office

• Law Practice
• 700 & Above Employee

• Real Estate, Wills and Estate Administration Legal Secretary

  • Jul 1998 - Aug 2005

  * Managed and organize all documentation through real estate closing and post-closing phases with lending institution, including money deposits; check writing and client check balancing of accounts valued up to $1 million * Prepared legal documents for real estate closings, divorces, and corporations * Scheduled all appointments and meetings * Opened new client files and maintained alpha-numerical filing system * Drafted wills, powers of attorney, miscellaneous legal correspondence… Show more * Managed and organize all documentation through real estate closing and post-closing phases with lending institution, including money deposits; check writing and client check balancing of accounts valued up to $1 million * Prepared legal documents for real estate closings, divorces, and corporations * Scheduled all appointments and meetings * Opened new client files and maintained alpha-numerical filing system * Drafted wills, powers of attorney, miscellaneous legal correspondence and complaints *Created a new file system to locate files in a fast and efficient manner, and can dispose files after the legal time has expired efficiently. Show less