Mordechai Kilstein's Email Addresses & Phone Numbers

📖 Summary

Site Reliability Engineer @ Citadel Make things go fast Greater Chicago AreaDatabase Consultant @ Citadel Make things go fast From May 2019 to January 2020 (9 months) Greater Chicago AreaCorporal (E4) - EERS 1142 @ United States Marine Corps Electronics repair, engine repair, provide perimeter security, worked under tight deadlines in imperfect conditions and climates, adapt and overcome, shoot at things From November 1997 to October 2005 (8 years) Dallas/Fort Worth AreaPresident / Principal Consultant @ Intellect Service Consulting Company • Delivering custom, intelligent, efficient solutions to withstand the test of time• Providing clients with consulting needs for short to mid-range projects• Training and mentoring consultants Plano, TXDatabase Architect, BI @ XPO Logistics, Inc. • Designing and developing T-SQL objects for Last Mile• Testing and extending tSQLt framework for T-SQL unit testing• Creating unit tests for validating the stored procedures From November 2017 to November 2019 (2 years 1 month) Greater Chicago AreaVP Database Administration and Business Intelligence @ Fay Servicing, LLC • Overseeing DBA and BI teams• Organizing the resources to tackle the growth challenges• Removing roadblocks and enabling developers in succeeding• Sharing the SQL/ETL knowledge From May 2017 to November 2017 (7 months) Greater Chicago AreaSQL Server Consultant @ Potbelly Sandwich Works • Leading SharePoint and Microsoft SQL 2016 migration project• Leading Microsoft Great Plains 2016R2 migration project• Optimizing large databases and the Enterprise Data Warehouse From December 2016 to April 2017 (5 months) Greater Chicago AreaConsultant @ MBI Solutions (Atayo Group) • Guiding and assisting other developers and QA analysts in accomplishing their goals• Interfacing with QA and other Development Leads to triage, resolve, and assign defects• Optimizing ETL and Unit Tests to synchronize the requirements via custom code generator • Developing IBM Netezza ETL scripts for transforming staged data into pre-data warehouse structures• Guiding and supporting on-shore and off-shore QA teams From April 2016 to December 2016 (9 months) San Francisco Bay Area (remote)Sr. Consultant, Microsoft Practice @ PSC Group, LLC • Architected SQL Azure to on premise SQL framework for synchronizing schema and delta data loads• Architected, designed, and developed data mart rapid development framework• Key player in consolidation and migration of SQL 2000/05/08 servers into SQL 2012 High Availability cluster• Migrated databases and DTS/SSIS packages from SQL 2000/05/08 to 2012. Significantly improved performance, error handling, and reduced maintenance costs• Developed Microsoft Outlook 2007/2010 plug-in in VB.net to interact with SQL Server and Microsoft Exchange Web Services to process and file large attachments into a mainframe system• Developed and optimized custom dashboards in SSRS 2008, created custom dashboard scaling functionality, and staging database to support future data mart/data warehouse• Redesigned several SharePoint 2010 webparts • Architected and developed C# security framework integration SSRS and SharePoint to implement security and improve usability for dashboards and reports• Developed data conversion routines and procedures for migration in SQL 2005/2008• Enhanced and updated VB.net WinForms and objects to streamline data integration, created universal methods for parsing/filling data classes and persisting them in SQL Server• Redesigned and optimized .NET and SQL Server ETL processes for execution time reduction from 16 hours down to 30 minutes• Developed a multidimensional ETL tool in C# to populate highly robust MongoDB collections From February 2011 to April 2016 (5 years 3 months) Greater Chicago AreaSr. BI Developer / Consultant @ Echo Global Logistics • Designed ETL processes for loading acquisition data using SSIS and SQL Server• Improved and extended Financial Data Mart architecture• Designed a search engine in ASP.Net for the SSRS reporting solution used by external clients• Created C# utility to monitor SQL Server utilization and log long-running queries for further analysis From October 2010 to February 2011 (5 months) Greater Chicago AreaLead Architect / Consultant @ ReportingGuru • Lead new client engagements, client-communication, and SOWs creation• Architected and developed data marts and ETL processes• Traveled to various universities and other locations to provide T-SQL and BIRT training to analysts• Designed and updated reports for clients in educational, banking, manufacturing, and other services industries in Crystal Reports 8.5 – 2012, BIRT 2.1 – 4.2, and SSRS 2005 – 2008• Created custom BIRT Viewer implementations and report optimization for PostgreSQL and Oracle From September 2009 to October 2010 (1 year 2 months) BI Developer / Consultant (remote) @ Saxon Mortgage • Provided Microsoft SQL Server 2005 and Microsoft SQL Server Reporting Services 2005 guidance to the BI developers• Developed SSRS reports and advanced SQL to provide intelligent view of the client's data From October 2009 to August 2010 (11 months) Dallas/Fort Worth AreaLead Software Engineer @ BrandFolium Corporation • Guided product development discussions, market entry strategy, and growth strategy• Developed and supported a custom website in Java 1.6, MySQL 5.4, and AJAX that included robust analytics to track the searches and gameplay• Architected a visual search engine with autocomplete to engage users• Developed a full AJAX social media brand badge that interacted with Facebook and Twitter From March 2009 to September 2009 (7 months) Mountain View, CaliforniaLead Architect, Business Intelligence @ MLS Data Management Solutions • Designed and extended SQL Server Analysis Services OLAP cubes• Created reporting solution for a large marketing agency implementing MDX queries and SSRS• Architected advanced staging and storing processes for the raw data to drive the Data Warehouse From December 2008 to February 2009 (3 months) Dallas/Fort Worth AreaLead Developer / Consultant @ American Home Mortgage Servicing, Inc (AHMSI) • Developed a new external website for customers to receive loan information and make payments via Western Union• Implemented Microsoft Office SharePoint Server 2007 for intranet replacement for the organization• Maintained an existing Microsoft Office SharePoint Server 2003 implementation in order to transfer the contents to 2007 From February 2008 to November 2008 (10 months) Dallas/Fort Worth AreaAVP Business Analytics @ Saxon Mortgage Services, Inc. - Morgan Stanley company • Assembled a team of highly dependable reporting analysts for producing the executive management investors, and external rating agencies (Moody’s and S&P) reports, analysis, and risk management• Designed and lead the implementation of SharePoint 2007 for the Business Analytics• Mentored IT personnel in administrative and migration processes for servers• Directed projects to document and standardize report data sources and calculations, business rules across the enterprise, and automate and streamline reporting process• Mentored junior and senior analysts in T-SQL, MS Access, and MS Excel• Facilitated negotiations between business units and IT to create consistency and agreement for definitions, formulas, and standards From June 2007 to January 2008 (8 months) Dallas/Fort Worth AreaSharepoint Consultant @ Artis Consulting • Designed custom workflows for United Healthcare Student Resources in Microsoft Office SharePoint Sever 2007• Performed analysis and created documentation for upgrading Microsoft SharePoint Portal 2003 to Microsoft Office SharePoint Server 2007 for MetroPCS utilizing in-place and database migration paths• Performed analysis, documentation, and some development of the MetroPCS marketing calendar web part From May 2007 to June 2007 (2 months) Dallas/Fort Worth AreaSr. Web/Application Developer @ EMC Mortgage (Bear Stearns Co) • Created and improved web applications in for tracking loans, data entry, and portfolio pricing• Designed financial, analytical, and exception reports• Mentored junior and senior developers and business analysts in best practices for Java, .NET 2.0, PL/SQL, T-SQL, and Crystal Reports 10 From March 2006 to May 2007 (1 year 3 months) Dallas/Fort Worth AreaSr. Web Developer @ (Centex Home Equity Company) Nationstar Mortgage • Created applications for loan originations, loan servicing, finance, accounting/treasury, infrastructure, and security departments in .NET, ASP, VB 6, PHP, MDX, SQL Reporting Services, T-SQL, loan tracking, revenue analysis, and borrower credit-worthiness• Guided junior developers, senior developers, and DBAs in development and database maintenance• Interviewed junior and senior web and database developers for application and web development From March 2000 to March 2006 (6 years 1 month) Dallas/Fort Worth AreaWeb Developer @ Innovative Web Creations • Developed an e-commerce website for Babbages, Inc. (GameStop, Inc.)• Translated VB 3 to VB 6 POS application• Developed distributed VB 6 application for order tracking and printing for Merlin, Inc. From August 1999 to February 2000 (7 months) Dallas/Fort Worth AreaWeb / Applications Developer @ InSoft / Ambient Software, Inc. • Developed ActiveX component for content management• Designed a new scheduling website for DART.org in Perl• Created a web-based content management application From May 1996 to August 1999 (3 years 4 months) Dallas/Fort Worth Area