At Magna Data, we give a Voice to your DataWe help organizations to achieve a Data-driven culture leveraging cutting edge technology, in Data, Analytics & AI.-Data Management & Strategy-Business Intelligence (BI)-Advanced Data Analytics (AI, ML)-Cloud ArchitectureImprove your business by making better and faster decisions, discovering new opportunities, identifying weaknesses, and more. Contact us now!

501c3 Charity www.data-geeks.orgOrganize and support events providing free forum for education and networking to the community.Run monthly events and one of the biggest annual Data Platform conferences in the South Florida area with over 1K registrations ( https://sfssug.org/sql-saturday )In charge of the overall organization, purchasing, logistics, fundraising, marketing, social media.

Do you need help putting together your Events from Scratch?Let me help!I have extensive experience organizing all type of tech-related events both in person and virtual, including:Large ConferencesCorporate TrainingsBootcampsWorkshopsSeminarsLunch & LearnsAs an Event Producer and Organizer, I have vast experience and knowledge in all aspects required for a high quality successful event: Finding Public Speakers, Creating Panels for Discussion, Bringing Funds from Sponsorships and Creating long-lasting relationships, Audience Outreach, Community Engagement, Collateral Marketing Material and Merchandise, logistics such as Event Coordination, Food Catering, and more.

Data Analytics Solutions - Business IntelligenceOnsite/RemoteIdentifying sources, gathering requirements, data warehouse architecture design and scripts, ETL, data cleansing, data management, regular expressions, complex queries, views, stored procedures and data vizualizations.Quality assessment to ensure data integrity.Technologies: T-SQL, SQL Server 2014, Visual Studio 2015, TFS, SSIS, SSRS, SSMS, Tableau, Power BI.

E-discovery: acquiring, processing and analyzing Unstructured and Structured data from computers, mobile devices and databases, using tools such as Encase, FTK, TD1, Linux scripts, Intella, Relativity, LexisNexis Law, Xry, Oxygen, among others. Evidence handling and preservation. Chain of custody.Due diligence on companies and persons.Data Analytics (Forensic and Classic) and Journal Entries tests for companies (including Fortune 500) from several industries such as Gas&Oil, Banks, Retail, Healthcare, Tourism, among others. The data analysis included: searching for anomalies, patterns, trends, internal control failures in order to identify risks and fraud opportunities. Examples of data analyzed are: financial transactions (journal entries, general ledger), procure-to-pay (purchase orders, invoices, accounts payable, payments), payroll, vendor schema, expenses.ETL: Receiving/extracting the data from different sources, data cleansing, data loading into SQL Server. Performing verification tests to confirm the integrity and consistency of the loaded data. Query development for each task.Data visualizations based on the client needs. Reports to show findings and significant information found during the analysis.Technologies: SQL, complex T-SQL, Ms SQL Server, SSMS, ACL, SAP, Oracle, Spotfire, Tableau.

ETL and Analysis of databases from different sources. Technologies: SQL, Ms Fox, MySQL, Oracle, PL/SQL. Data Mining and Text Mining.CrimeMap creation using CrimeStat and ArcGIS. This Map showed the concentration of criminal activities by city helping the development of security strategies and efficiently deployment of police force resources to combat crime.Crime investigation and criminal pattern detection, with the help of CrimeMaps and data analysis Reports for the precincts showing the results of the analysis. This was performed weekly, bi-weekly or monthly, depending on the requirement.Meetings with chiefs of precincts to update and discuss the criminal behaviors, and gather new requirements for the analysis.Designed the database for the new in-house software version SEP, which manages the police reports. I have made the design foreseeing future datamining. Developed the SQL scripts utilized to perform the migration from the old to the new database design.