OUR CLIENTS
ATM Payment and Processing Infrastructure, California
• Successfully managed a project directly supporting 50 employees in the creation of a full time fault analysis data mart for ATM machines to allow for use, manipulation, and development of data.
• Evaluated high availability capabilities and created database solutions for Oracle and Microsoft servers.
• Worked with and supported the demand for data and information by business users, business analysts, and decision makers by drafting requirements for data requests and report requests.
• Developed data extracts, reports, dashboards and information spaces using SQL and reporting tools.
Gaming/Hospitality, New York/New Jersey
• Worked on all phases of gaming and hospitality data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Demonstrated expertise utilizing ETL tools, including SQL server integration services (SSIS), data transformation services (DTS), and data stage and ETL package design with RDBM systems like SQL servers, iSeries DB2
• Streamlined the operational processes to be more efficient and cost effective (i.e. reduced the costs of tape backups by 70%)
• Seamlessly encrypted databases as per gaming commission requirement
• Created multiple custom BI and audit custom reports
• Developed and designed “High Availability” strategy involving hardware/software clustering, partitioning, mirroring, and log shipping
• Supporting all DBA related responsibilities
Online Food Ordering Company, New York
• Played a vital role in implementing database analytical software.
• Applied expertise in guiding design, implementation of Reporting Automation
Global supplier in Solder products, New York
• Managed data to provide business intelligence solutions to guide company operations.
• Optimally configured data infrastructure to meet the manufacturing and business needs.
• Minimized potential downtown and loss of business by executing complex, critical database tasks.
• Upgraded and enhanced the data environment to leverage business intelligence to improve decision making throughout the organization.
• Performed database design to support analytics applications and business intelligence.
• Migrated and enhanced existing Congos Cubes to MS SSAS by creating a new MSSql Data Mart with Extract, Transform, and Load (ETL) processes to transform data for querying and analysis.
• Replaced an obsolete email application, using new database, VB script and Microsoft tools including SSRS at no additional licensing costs for proposed solution. This saved company over $250k in revenue.
• Achieved an 80% performance gain by redesigning the existing ETL’s.
• Created new ad-hoc and regular reports, and supported database installations, upgrades, patching, data analytics, security, and database optimization.
• Redesigned SharePoint Infrastructure to optimize performance.
• Seamlessly integrated SSRS and SharePoint.
• Multiple SharePoint applications were created in-house including many workflows. Company saved over $500k on Vendor App software and maintenance
Our Client Reviews
