• Collaborate on architecture of data warehouse creation for the data analytics team. That includes but is not limited to design of comprehensive solutions within the data analytics team, driving out risks, and building data analytics platforms.• Design and develop ground up solutions for data warehouse that extract, transform and load data from a variety of sources and destinations.• Assist on maintenance of existing web development that uses WEB Applications and web api with connection with data analytics platform.• Working in a AGILE environment, assisting on design and development of conceptual ideas for new and existing projects for development, enhancements and maintenance.• Daily working tools: SQL Server, SQL Profiler, DBeaver, SSIS, Visual Studio 2015 and 2019, RedGate, DevOps, Git, Kendo JQuery, Unit Test, MVC, WEB API, Active Directory, C#, CI/CD, DevOps among others.

Develop and implement projects as assigned. Provides Technical leadership during assigned development and maintenance efforts.Code complex processes using strong technical or application knowledge and database expertise, and performs system integration tasks.Hands on SSIS 2012 ETL design and development with deployment automation.Actively participating on integration of on-premise data warehouse to AWS cloud.Design and develop Unit Tests.Work as a collaborator in the enhancements of the organization System Development Life Cycle (SDLC) and also working as a collaborator in the Code Quality Team. Some of the work included design of Unit Test data driven model, design of a high level estimation tool based on PERT and Function Point Methods, creation of RACI, among others.Tools and utilities currently used on the team include AWS Services, C#, Python, ASP.NET, XML, Web API, Web Services, AWS, BI QuickSight, LDAP, Active Directory, ESB, SOAP UI, JavaScript, JQuery, Bootstrap, MVC, AngularJS, Chrome DevTools, DB2, PostgreSQL, PostgresCompare, DBeaver 7.01, SQL Server, SQL Profiler, Beyond Compare, InfoSphere, IIS, Aldon, TFS,CodeCommit, Git among other tools and technologies. Training:AGILE Bootcamp from Summit Tech Partner - June 2019.SECURITY INNOVATION Certified Courses - October, 2018:- Fundamentals of Secure Database Development- Creating Secure Code - .NET Framework Foundations- Creating Secure Ajax Code - ASP .NET Foundations- Node.js Threats and Vulnerabilities- Mitigation individual courses on Injection, Broken Authentication, Sensitive Data Exposure, XML External Entities, Broken Access Control, Security Misconfiguration, Cross Site Scripting, Insecure Deserialization, Known Vulnerabilities and Insuficient Logging and Monitoring.- Testing for CWE SANS top 25 Software Errors- Creating Secure ASP.NET MVC Applications- Creating Secure C# CodeDate of Completion: 10/19/2018https://appsec.securityinnovation.com/#/dashboard

Specialized in mission critical enterprise applications including:• Managed multiple projects of various sizes and complexities.• Designed and implemented systems that are integrated with three or more other systems.• Solid Experience in data transformation (ETL), conversions, enhancements, and tuning.• Extensive Database tuning and development.• It restructuring through the creation of change control, standards, policies, and procedures.• Assist junior developers in needed basis. Analysis, design, development, change control, enhancement and maintenance of over 20 financial web and windows systems that supports the wealth growth of GenSpring Family Offices. Creation and maintenance of IT coding standards, best-practices documents, policies and procedures.The systems were made with one or more of the following tools: Cloud CRM Sales Forces, SQL Server2005\2008\2014, Red Gate, Visual Studio 2005, 2010, 2014, SSIS, DTS, Scribe, Team Foundation Server (TFS), Silverlight 2 and 4, Revelation Dali Entity Framework, LINQ to Class, RIA Services, Data Entity framework, Web Services, WCF, Windows Services, SOA, ADO.Net framework, Unit Test, JQuery, Infragistic, Telerik, Aspose, JQuery, CSS, Bootstrap, AJAX, MVC among various other tools and utilities.For compliance reasons, more details on the integration, purpose, and logic of those systems are omitted from this description.

While in the transition from my previous job to a next one, I adventured on my own through my sole proprietorship company named ClearPoint Solutions. During that couple of years I assisted, managed and developed IT projects on contract basis. Some of them are listed below:• Designed and developed financial customizable dashboards. • Designed and developed the Retention Analysis Services (RAS) web system for a local mortgage group. The RAS acquires financial data such as properties, debts, mortgage, income, assets, and liabilities information and perform analysis of the collected data to output financial pie chart worksheets to be presented to banks. • Planned and prototyped the Compensation Structure Analysis (CSA) web system. The CSA is being envisioned as a Salary Structure Plan that will provide compensation information for the global commodities marketplace.• Designed and developed the CommodityCareers Affiliation Program (CCAP) to CommodityCareers LLC. CCAP provides real-time tracking and reporting features permitting complete transparency to the corporation affiliates and partners.• Designed and developed the Member Services area of CommodityCareers.com that includes the job aggregator utility, the writing tool and IQ Test Simulator tool. • Designed and developed a Search Engine that is hosted in the SparkSpread affiliate using.net 3.5, SQL 2005, AJAX, and Screen Scrapping. • As a member of the Technology Advisory Board of CommodityCareers advise and guide the corporation through its technology architecture and outcomes.

Lead the creation of 5 major financial web sites, dozens of intranet systems, and windows applications.Lead the integration of proprietary and in house systems Lead the creation of all CMax IT processes, policies, and procedures which regulates all phases of a project within the corporation.Lead all database tasks such as maintenance, back ups, tunning, integration and conversions in development, staging and production enviroments.Review all Project Envisioning documents issued by the business analysts, allocate appropriate resources to work on the project, lead the project scope and timeline, define and guide project team leader, review and approve design specifications, reinforce coding guidelines, follow up the project during quality assurance phase, inspect and approve deployment plan, anticipate and manage any issue that may happen during the project life cycle.First two years in CreditMax played the role of senior developer and architect developing the main web sites from ground up and implementing the foundation for the IT.

Comprehensive database development and management using SQL Server and light DB2. Worked on SKU central project with Java and IBM web sphere. SKU Central is a major Office Depot (OD) initiative that aimed to centralize all OD European vendors in a central DB including data from the acquisition of European companies from OD. The centralization of data supported the business goals for a better negotiation with vendors and OD providers in Europe. Also, developed projects in .Net and C#.

• Developed, Enhanced and maintained the Enterprise Intranet Web Data Warehouse Systems that were the core systems for the Accounting, Marketing, Merchandise, and Customer Service Departments. Those systems provided automated interactive Input/output for end users, and offered analytical views of data. • Developed the Ad hoc Visitor Sales System. It is an ad hoc system that matches click stream data and sales from the various corporation web sites. It allows the user to select the columns for output, and allows the user to filter the data from a large variety of parameters, sorting and grouping by.• Developed the Sales Flash and Daily Sales Systems. They allow various views of the daily, weekly, or monthly sales. Advanced features included automated response to pages and cell phones.• Created dozens of data warehouse intranet reports. Some of them are Images Click Report, Open Orders Report, Unsubscribe Report, Affiliates Sales Report, Inventory Report, Search Words Reports, and Shipping Reports etc. • Responsible of Database maintenance tasks such as Index tunning, DTS checks and verification, DB creation and maintenance.Recommendation:“Marcio is a hard worker with attention to detail and quality. I would have him work for me again if the opportunity presented itself.” April 28, 20092nd George Grous, Chief Technology Officer, Odimo Incorporatedmanaged Marcio at Odimo Inc.

• Lead the analysis, architecture, development, and deployment of the Master Schedule Web System that included architecture and technical specification, and the database model, creation, and conversion (Notes/Notrix to SQL Server). • Managed developers time and tasks, and lead the creation of all script prototypes prior to assigning them to designated programmers, and wrote code as well. Master Schedule is an Enterprise Web Decision Support Systems created to attend directors and managers needs. • Developed the integration between Vantive (PeopleSoft) DB and the TAM 2000 (asset system) DB using remote SQL Servers as target database servers. • Performed all DBA functions on Vantive (PeopleSoft) development /testing server and provided support and coaching for junior developers of Vantive when there were major difficulties to maintain the Vantive System. Vantive uses VB Script and SQL Server 6.5.

• Developed a print engine DLL that is used and reused by three different systems(SLIMS, ACRS, and CPMS) The print DLL generates reports and sub reports with flexible query capabilities. It uses undocumented Crystal Report DLL features and became a reporting tool with more features than Crystal Report. Lead and Coach junior developers in the usage of the mentioned DLL.• Lead the development of the Contractor Performance Management System (CPMS) to comply with FDIC revised Contractor Performance Evaluation criteria. Lead team meeting, follow up on project timeline, and lead the development of data conversion using SQL Server Bulk Copy (BCP), developed stored procedures, triggers, and rules. Lead the development of reports, Test Script/Test Plan, and implemented the system. • Developed the phase II and III for the Strategic Leasing and Insurance Management Systems (SLIMS) for the Federal Deposit Insurance Corporation (FDIC). SLIMS automated property, lease, insurance, and payment information in an integrated system that satisfies the reporting and tracking requirements of Leasing and Insurance Unit (LIU) of FDIC. SLIMS is a three tier architecture system developed in VB5 and SQL Server. • Participated on the analysis, architecture and deployment phase for ACRS system. ACRS provides an automated system to process and fulfill customer requests for any service provided by the Division of Administration Customer Service Branch of FDIC. • Developed an upgrade version of the Subsidiary Information Management System (SIMAN). Supported the transition of SIMAN from Banyan Vines to Windows NT network environment, developed project timeline, ERDs, Data Flow Diagrams (DFDs), and Data Dictionary.