Image of Mordechai Kilstein

Mordechai Kilstein

Site Reliability Engineer

BI/ETL/Data/SQL Ninja

Greater Chicago Area

Section title

Mordechai Kilstein's Email Addresses & Phone Numbers

Mordechai Kilstein's Work Experience

Citadel

Site Reliability Engineer

Greater Chicago Area

Citadel

Database Consultant

May 2019 to January 2020

Greater Chicago Area

United States Marine Corps

Corporal (E4) - EERS 1142

November 1997 to October 2005

Dallas/Fort Worth Area

Mordechai Kilstein's Education

American InterContinental University

BA, Business

2005 to 2006

Richardson High School

Graduated, Mathematics / Computer Science

1995 to 1998

Mordechai Kilstein's Professional Skills Radar Chart

Based on our findings, Mordechai Kilstein is ...

Innovative
Firm
Reflective

What's on Mordechai Kilstein's mind?

Based on our findings, Mordechai Kilstein is ...

52% Left Brained
48% Right Brained

Mordechai Kilstein's Estimated Salary Range

About Mordechai Kilstein's Current Company

Citadel

Make things go fast

Frequently Asked Questions about Mordechai Kilstein

What company does Mordechai Kilstein work for?

Mordechai Kilstein works for Citadel


What is Mordechai Kilstein's role at Citadel?

Mordechai Kilstein is Site Reliability Engineer


What is Mordechai Kilstein's personal email address?

Mordechai Kilstein's personal email addresses are v****[email protected], and m****[email protected]


What is Mordechai Kilstein's business email address?

Mordechai Kilstein's business email addresses are not available


What is Mordechai Kilstein's Phone Number?

Mordechai Kilstein's phone (**) *** *** 272


What industry does Mordechai Kilstein work in?

Mordechai Kilstein works in the Logistics and Supply Chain industry.


About Mordechai Kilstein

📖 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


Mordechai Kilstein’s Personal Email Address, Business Email, and Phone Number

are curated by ContactOut on this page.

10x your recruitment & sales conversations

Contact over 200M professionals
instantly by email or phone. Reveal
personal & work email addresses, as
well as phone numbers accurately with
our ContactOut Chrome extension.

In a nutshell

Mordechai Kilstein's Personality Type

Introversion (I), Sensing (S), Thinking (T), Perceiving (P)

Average Tenure

1 year(s), 9 month(s)

Mordechai Kilstein's Willingness to Change Jobs

Unlikely

Likely

Open to opportunity?

There's 89% chance that Mordechai Kilstein is seeking for new opportunities

Mordechai Kilstein's Social Media Links

/company/c...
Engage candidates 10x faster

Enjoy unlimited access and discover candidates outside of LinkedIn

Trusted by 400K users from

76% of Fortune 500 companies

Microsoft Nestle PWC JP Morgan Merck Rackspace WarnerMedia Randstad Yelp Google

The most accurate data ever

CCPA Compliant
GDPA Aligned
150M Personal Emails
300M Work Emails
50M Direct Dials
200M Professional Profiles
30M Company Profiles

Hire Anyone, Anywhere
with ContactOut today

Making remote or global hires? We can help.

  • 50 contacts/month
  • Works on standard LinkedIn only
  • Work emails, personal emails, mobile numbers
* 1 user per company limit

No credit card required

Try ContactOut for Free